Problème d'authentification

E.devaud · April 24, 2016, 9:02am

Bonjour,

Problème d’authentification de tous les utilisateurs.

Pas de modifs système. Ca fait quelques temps que tout fonctionne sans problème.
Bmctl restart ne donne rien.
Serveur redémarré ne donne rien.

tail -f /var/log/bm-hps/hps.log au moment de la connexion :

2016-04-24 08:55:55,457 [New I/O worker #5] net.bluemind.proxy.http.impl.HttpProxyServerHandler INFO - / needs re-auth
2016-04-24 08:55:55,663 [New I/O worker #4] net.bluemind.proxy.http.impl.HttpProxyServerHandler WARN - ifModifiedSince: 'Sun, 24 Apr 2016 08:42:01 GMT': Unparseable date: "Sun, 24 Apr 2016 08:42:01 GMT"
2016-04-24 08:56:02,155 [New I/O worker #4] net.bluemind.proxy.auth.bmcore.impl.BMCAuthProvider WARN - No core location for 'e.devaud'
2016-04-24 08:56:02,156 [New I/O worker #4] net.bluemind.proxy.http.impl.HttpProxyServerHandler INFO - /bluemind_sso_security needs re-auth

Core.log :

2016-04-24 08:40:31,704 [main] net.bluemind.lib.vertx.internal.BMPlatformManagerFactory INFO - Using BM platform manager factory.
2016-04-24 08:40:32,780 [main] net.bluemind.core.launcher.Main INFO - Starting BlueMind Core...
2016-04-24 08:40:32,805 [main] net.bluemind.hornetq.client.MQ INFO - MQ setup for net.bluemind.core.launcher.Main$1@5a3dfc08....
2016-04-24 08:40:32,830 [defaultEventExecutorGroup-3-1] net.bluemind.hornetq.client.MQ INFO - ************** MQ producer CONNECTING ****************
2016-04-24 08:40:33,946 [defaultEventExecutorGroup-3-1] net.bluemind.hornetq.client.impl.NonOsgiActivator WARN - failed to locate bm/mq server. falling back to localhost
2016-04-24 08:40:34,624 [defaultEventExecutorGroup-2-1] net.bluemind.hornetq.client.MQ INFO - ************** MQ consumer CONNECTING ****************
2016-04-24 08:40:34,644 [defaultEventExecutorGroup-2-1] net.bluemind.hornetq.client.MQ INFO - DE-QUEUEING 1 handlers.
2016-04-24 08:40:34,644 [defaultEventExecutorGroup-2-1] net.bluemind.hornetq.client.MQ INFO -  On: net.bluemind.core.launcher.Main$1@5a3dfc08
2016-04-24 08:40:34,653 [defaultEventExecutorGroup-2-1] net.bluemind.hornetq.client.MQ INFO - Producer on jms.topic.bm.core.notifications created.
2016-04-24 08:40:34,667 [defaultEventExecutorGroup-2-1] net.bluemind.core.CoreActivator INFO - Activate core.
2016-04-24 08:40:34,668 [defaultEventExecutorGroup-2-1] net.bluemind.core.BMCore INFO - core starting...
2016-04-24 08:40:34,671 [defaultEventExecutorGroup-2-1] net.bluemind.core.BMCore INFO - Loading JDBC pool
2016-04-24 08:40:34,719 [defaultEventExecutorGroup-2-1] net.bluemind.utils.RunnableExtensionLoader INFO - net.bluemind.jdbc.pgsql.provider.PgSQLConnectionFactory loaded.
2016-04-24 08:40:34,719 [defaultEventExecutorGroup-2-1] net.bluemind.utils.RunnableExtensionLoader INFO - Loaded 1 implementors of net.bluemind.pool.jdbcdriver
2016-04-24 08:40:34,732 [defaultEventExecutorGroup-2-1] net.bluemind.pool.BMPoolActivator INFO - Starting connection pool 164.132.53.171/bj
2016-04-24 08:40:34,732 [defaultEventExecutorGroup-2-1] net.bluemind.pool.BMPoolActivator INFO - dbtype from bm.ini is PGSQL
2016-04-24 08:40:34,772 [defaultEventExecutorGroup-2-1] net.bluemind.pool.xa.PoolActivator INFO - Pool bundle started.
2016-04-24 08:40:34,792 [defaultEventExecutorGroup-2-1] net.bluemind.pool.xa.impl.DataSource INFO - Starting pool...(jdbc:postgresql://164.132.53.171/bj)
2016-04-24 08:40:34,805 [defaultEventExecutorGroup-2-1] net.bluemind.pool.xa.impl.ConnectionPool INFO - Creating Physical connection...
2016-04-24 08:40:34,871 [defaultEventExecutorGroup-2-1] net.bluemind.pool.xa.impl.ConnectionPool ERROR - Could not create DB connection to jdbc:postgresql://164.132.53.171/bj with l / p: bj / bj
2016-04-24 08:40:34,911 [defaultEventExecutorGroup-2-1] net.bluemind.pool.BMPoolActivator ERROR - Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) ~[na:na]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:138) ~[na:na]
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) ~[na:na]
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) ~[na:na]
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) ~[na:na]
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) ~[na:na]
	at org.postgresql.Driver.makeConnection(Driver.java:410) ~[na:na]
	at org.postgresql.Driver.connect(Driver.java:280) ~[na:na]
	at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[na:1.7.0_60]
	at java.sql.DriverManager.getConnection(DriverManager.java:215) ~[na:1.7.0_60]
	at net.bluemind.pool.xa.impl.ConnectionPool.getNewPhysicalConnection(ConnectionPool.java:161) ~[net.bluemind.pool.xa_1.0.0.b13769.jar:na]
	at net.bluemind.pool.xa.impl.ConnectionPool.createPhysicalConnection(ConnectionPool.java:136) ~[net.bluemind.pool.xa_1.0.0.b13769.jar:na]
	at net.bluemind.pool.xa.impl.ConnectionPool.<init>(ConnectionPool.java:101) ~[net.bluemind.pool.xa_1.0.0.b13769.jar:na]
	at net.bluemind.pool.xa.impl.DataSource.<init>(DataSource.java:57) ~[net.bluemind.pool.xa_1.0.0.b13769.jar:na]
	at net.bluemind.pool.xa.PoolActivator.createDataSource(PoolActivator.java:85) ~[net.bluemind.pool.xa_1.0.0.b13769.jar:na]
	at net.bluemind.pool.BMPoolActivator.newPool(BMPoolActivator.java:121) [net.bluemind.pool_1.0.0.b13769.jar:na]
	at net.bluemind.pool.BMPoolActivator.newPool(BMPoolActivator.java:95) [net.bluemind.pool_1.0.0.b13769.jar:na]
	at net.bluemind.pool.BMPoolActivator.startPool(BMPoolActivator.java:90) [net.bluemind.pool_1.0.0.b13769.jar:na]
	at net.bluemind.pool.BMPoolActivator.start(BMPoolActivator.java:78) [net.bluemind.pool_1.0.0.b13769.jar:na]
	at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at java.security.AccessController.doPrivileged(Native Method) [na:1.7.0_60]
	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:299) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:440) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:268) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:107) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:463) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:400) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.SingleSourcePackage.loadClass(SingleSourcePackage.java:35) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:473) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:429) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:417) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358) [na:1.7.0_60]
	at net.bluemind.core.BMCore.start(BMCore.java:104) [net.bluemind.core_1.0.0.b13769.jar:na]
	at net.bluemind.core.launcher.Main.mqAvailable(Main.java:68) [net.bluemind.core.launcher_1.0.0.b13769.jar:na]
	at net.bluemind.core.launcher.Main.access$0(Main.java:66) [net.bluemind.core.launcher_1.0.0.b13769.jar:na]
	at net.bluemind.core.launcher.Main$1.connected(Main.java:56) [net.bluemind.core.launcher_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.MQ.dequeue(MQ.java:144) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.MQ.mqConnectImpl(MQ.java:132) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.MQ.access$2(MQ.java:121) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.MQ$3.run(MQ.java:112) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.impl.SafeExecutorGroup$1.run(SafeExecutorGroup.java:26) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at io.netty.util.concurrent.DefaultEventExecutor.run(DefaultEventExecutor.java:36) [netty-all-4.0.24.Final.jar:4.0.24.Final]
	at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116) [netty-all-4.0.24.Final.jar:4.0.24.Final]
	at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:137) [netty-all-4.0.24.Final.jar:4.0.24.Final]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_60]
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.7.0_60]
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) ~[na:1.7.0_60]
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) ~[na:1.7.0_60]
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) ~[na:1.7.0_60]
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.7.0_60]
	at java.net.Socket.connect(Socket.java:579) ~[na:1.7.0_60]
	at java.net.Socket.connect(Socket.java:528) ~[na:1.7.0_60]
	at org.postgresql.core.PGStream.<init>(PGStream.java:60) ~[na:na]
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101) ~[na:na]
	... 50 common frames omitted
2016-04-24 08:40:34,970 [defaultEventExecutorGroup-2-1] net.bluemind.hornetq.client.MQ ERROR - net/bluemind/pool/BMPoolActivator
java.lang.NoClassDefFoundError: net/bluemind/pool/BMPoolActivator
	at net.bluemind.core.BMCore.start(BMCore.java:104) ~[na:na]
	at net.bluemind.core.launcher.Main.mqAvailable(Main.java:68) ~[na:na]
	at net.bluemind.core.launcher.Main.access$0(Main.java:66) ~[na:na]
	at net.bluemind.core.launcher.Main$1.connected(Main.java:56) ~[na:na]
	at net.bluemind.hornetq.client.MQ.dequeue(MQ.java:144) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.MQ.mqConnectImpl(MQ.java:132) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.MQ.access$2(MQ.java:121) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.MQ$3.run(MQ.java:112) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at net.bluemind.hornetq.client.impl.SafeExecutorGroup$1.run(SafeExecutorGroup.java:26) [net.bluemind.hornetq.client_1.0.0.b13769.jar:na]
	at io.netty.util.concurrent.DefaultEventExecutor.run(DefaultEventExecutor.java:36) [netty-all-4.0.24.Final.jar:4.0.24.Final]
	at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116) [netty-all-4.0.24.Final.jar:4.0.24.Final]
	at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:137) [netty-all-4.0.24.Final.jar:4.0.24.Final]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_60]
Caused by: org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter$TerminatingClassNotFoundException: An error occurred while automatically activating bundle net.bluemind.pool (12).
	at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:122) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:463) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:400) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.SingleSourcePackage.loadClass(SingleSourcePackage.java:35) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:473) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:429) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:417) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358) ~[na:1.7.0_60]
	... 13 common frames omitted
Caused by: org.osgi.framework.BundleException: Exception in net.bluemind.pool.BMPoolActivator.start() of bundle net.bluemind.pool.
	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:734) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:299) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:440) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:268) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:107) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	... 22 common frames omitted
Caused by: java.lang.Exception: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at net.bluemind.pool.BMPoolActivator.newPool(BMPoolActivator.java:127) ~[na:na]
	at net.bluemind.pool.BMPoolActivator.newPool(BMPoolActivator.java:95) ~[na:na]
	at net.bluemind.pool.BMPoolActivator.startPool(BMPoolActivator.java:90) ~[na:na]
	at net.bluemind.pool.BMPoolActivator.start(BMPoolActivator.java:78) ~[na:na]
	at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	at java.security.AccessController.doPrivileged(Native Method) ~[na:1.7.0_60]
	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) ~[org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]
	... 28 common frames omitted
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) ~[na:na]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:138) ~[na:na]
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) ~[na:na]
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) ~[na:na]
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) ~[na:na]
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) ~[na:na]
	at org.postgresql.Driver.makeConnection(Driver.java:410) ~[na:na]
	at org.postgresql.Driver.connect(Driver.java:280) ~[na:na]
	at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[na:1.7.0_60]
	at java.sql.DriverManager.getConnection(DriverManager.java:215) ~[na:1.7.0_60]
	at net.bluemind.pool.xa.impl.ConnectionPool.getNewPhysicalConnection(ConnectionPool.java:161) ~[na:na]
	at net.bluemind.pool.xa.impl.ConnectionPool.createPhysicalConnection(ConnectionPool.java:136) ~[na:na]
	at net.bluemind.pool.xa.impl.ConnectionPool.<init>(ConnectionPool.java:101) ~[na:na]
	at net.bluemind.pool.xa.impl.DataSource.<init>(DataSource.java:57) ~[na:na]
	at net.bluemind.pool.xa.PoolActivator.createDataSource(PoolActivator.java:85) ~[na:na]
	at net.bluemind.pool.BMPoolActivator.newPool(BMPoolActivator.java:121) ~[na:na]
	... 34 common frames omitted
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.7.0_60]
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) ~[na:1.7.0_60]
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) ~[na:1.7.0_60]
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) ~[na:1.7.0_60]
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.7.0_60]
	at java.net.Socket.connect(Socket.java:579) ~[na:1.7.0_60]
	at java.net.Socket.connect(Socket.java:528) ~[na:1.7.0_60]
	at org.postgresql.core.PGStream.<init>(PGStream.java:60) ~[na:na]
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101) ~[na:na]
	... 50 common frames omitted

Vous pouvez m’aider à comprendre ce qui c’est passé ?

Merci

Toony · April 25, 2016, 7:02am

Il smeblerait que votre service PostgreSQL ne fonctionne pas.

Que donne les commandes:

# su - postgres
$ psql bj

E.devaud · April 25, 2016, 8:25am

Ci dessous le résultat :

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?

Toony · April 25, 2016, 8:28am

Votre service PostgreSQL n’est pas démarré.

Que donne la commande:

# /etc/init.d/postgresql restart

Quelle est votre distribution ?
Que contient le fichier /var/log/postgresql/postgresql--main.log* ?

E.devaud · April 25, 2016, 9:11am

/etc/init.d/postgresql restart

Restarting PostgreSQL 9.3 database server OK ]

Ubuntu 14.04.3 LTS

/var/log/postgresql/postgresql-*-main.log

2016-04-25 09:05:09 GMT LOG:  database system was shut down at 2016-04-24 08:15:25 GMT
2016-04-25 09:05:09 GMT LOG:  MultiXact member wraparound protections are now enabled
2016-04-25 09:05:09 GMT LOG:  database system is ready to accept connections
2016-04-25 09:05:09 GMT LOG:  autovacuum launcher started
2016-04-25 09:05:09 GMT LOG:  incomplete startup packet
2016-04-25 09:08:35 GMT LOG:  received fast shutdown request
2016-04-25 09:08:35 GMT LOG:  aborting any active transactions
2016-04-25 09:08:35 GMT LOG:  autovacuum launcher shutting down
2016-04-25 09:08:35 GMT LOG:  shutting down
2016-04-25 09:08:35 GMT LOG:  database system is shut down
2016-04-25 09:08:36 GMT LOG:  database system was shut down at 2016-04-25 09:08:35 GMT
2016-04-25 09:08:36 GMT LOG:  MultiXact member wraparound protections are now enabled
2016-04-25 09:08:36 GMT LOG:  database system is ready to accept connections
2016-04-25 09:08:36 GMT LOG:  autovacuum launcher started
2016-04-25 09:08:37 GMT LOG:  incomplete startup packet

Toony · April 25, 2016, 9:15am

Avez-vous d’autres lignes dans ce fichier de logs après avoir exécuté:

# service postgresql restart

E.devaud · April 25, 2016, 9:25am

eh ben non ! rien

Toony · April 25, 2016, 9:30am

Que donnent les commandes:

# df -h
# df -i

Est-ce que le dossier /run/postgresql/ existe ?

E.devaud · April 25, 2016, 10:21am

df -h
Filesystem      Size  Used Avail Use% Mounted on
udev            1,9G  4,0K  1,9G   1% /dev
tmpfs           386M  452K  386M   1% /run
/dev/vda1       9,9G  8,0G  1,5G  85% /
none            4,0K     0  4,0K   0% /sys/fs/cgroup
none            5,0M     0  5,0M   0% /run/lock
none            1,9G     0  1,9G   0% /run/shm
none            100M     0  100M   0% /run/user
overflow        1,0M  740K  284K  73% /tmp

 df -i
Filesystem     Inodes  IUsed  IFree IUse% Mounted on
udev           492464    389 492075    1% /dev
tmpfs          493758    342 493416    1% /run
/dev/vda1      655360 179588 475772   28% /
none           493758      2 493756    1% /sys/fs/cgroup
none           493758      3 493755    1% /run/lock
none           493758      1 493757    1% /run/shm
none           493758      2 493756    1% /run/user
overflow       493758     23 493735    1% /tmp

Oui, le dossier existe !

Toony · April 25, 2016, 12:20pm

Que contient le dossier /run/postgresql ?

Quel est le résultat des commandes:

# su - postgres
$ /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf -d 5

E.devaud · April 25, 2016, 12:59pm

Le dossier run/postgresql contient un fichier :
9.3-main.pid

Résultat de la commande:

2016-04-25 12:55:58 GMT DEBUG:  postgres: PostmasterMain: initial environment dump:
2016-04-25 12:55:58 GMT DEBUG:  -----------------------------------------
2016-04-25 12:55:58 GMT DEBUG:          XDG_SESSION_ID=10
2016-04-25 12:55:58 GMT DEBUG:          SHELL=/bin/bash
2016-04-25 12:55:58 GMT DEBUG:          TERM=xterm
2016-04-25 12:55:58 GMT DEBUG:          USER=postgres
2016-04-25 12:55:58 GMT DEBUG:          MAIL=/var/mail/postgres
2016-04-25 12:55:58 GMT DEBUG:          PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
2016-04-25 12:55:58 GMT DEBUG:          PWD=/var/lib/postgresql
2016-04-25 12:55:58 GMT DEBUG:          LANG=fr_FR.UTF-8
2016-04-25 12:55:58 GMT DEBUG:          SHLVL=1
2016-04-25 12:55:58 GMT DEBUG:          HOME=/var/lib/postgresql
2016-04-25 12:55:58 GMT DEBUG:          LOGNAME=postgres
2016-04-25 12:55:58 GMT DEBUG:          XDG_RUNTIME_DIR=/run/user/0
2016-04-25 12:55:58 GMT DEBUG:          _=/usr/lib/postgresql/9.3/bin/postgres
2016-04-25 12:55:58 GMT DEBUG:          PGLOCALEDIR=/usr/share/locale
2016-04-25 12:55:58 GMT DEBUG:          PGSYSCONFDIR=/etc/postgresql-common
2016-04-25 12:55:58 GMT DEBUG:          LC_COLLATE=fr_FR.UTF-8
2016-04-25 12:55:58 GMT DEBUG:          LC_CTYPE=fr_FR.UTF-8
2016-04-25 12:55:58 GMT DEBUG:          LC_MESSAGES=en_US.UTF-8
2016-04-25 12:55:58 GMT DEBUG:          LC_MONETARY=C
2016-04-25 12:55:58 GMT DEBUG:          LC_NUMERIC=C
2016-04-25 12:55:58 GMT DEBUG:          LC_TIME=C
2016-04-25 12:55:58 GMT DEBUG:  -----------------------------------------
2016-04-25 12:55:58 GMT FATAL:  lock file "postmaster.pid" already exists
2016-04-25 12:55:58 GMT HINT:  Is another postmaster (PID 25806) running in data directory "/var/lib/postgresql/9.3/main"?
2016-04-25 12:55:59 GMT DEBUG:  shmem_exit(1): 0 callbacks to make
2016-04-25 12:55:59 GMT DEBUG:  proc_exit(1): 0 callbacks to make
2016-04-25 12:55:59 GMT DEBUG:  exit(1)

Toony · April 25, 2016, 1:04pm

Pouvez-vous exécuter:

# rm -f /var/lib/postgresql/9.3/main/postmaster.pid
# /etc/init.d/postgresql start

Arrivez-vous à vous connecter à PostgreSQL maintenant:

# su - postgres
$ psql bj

Si oui, exécutez:

# bmctl restart

Est-ce mieux ?

E.devaud · April 25, 2016, 1:13pm

Pas mieux…

Starting PostgreSQL 9.3 database server * Error: Port conflict: another instance is already running on /var/run/postgresql with port 5432

Toony · April 25, 2016, 1:17pm

Que donne:

# ps auwx | grep postgres

E.devaud · April 25, 2016, 1:18pm

ps auwx | grep postgres
root      5787  0.0  0.0  10948   936 pts/0    S+   15:18   0:00 grep --color=auto postgres
postgres 25806  0.0  0.4 217792 16460 ?        S    11:08   0:00 /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf
postgres 25808  0.0  0.0 217792  1724 ?        Ss   11:08   0:00 postgres: checkpointer process                                                                 
postgres 25809  0.0  0.0 217792  2256 ?        Ss   11:08   0:00 postgres: writer process                                                                       
postgres 25810  0.0  0.0 217792  1520 ?        Ss   11:08   0:00 postgres: wal writer process                                                                   
postgres 25811  0.0  0.0 218636  2848 ?        Ss   11:08   0:00 postgres: autovacuum launcher process                                                          
postgres 25812  0.0  0.0 102836  1764 ?        Ss   11:08   0:00 postgres: stats collector process

Toony · April 25, 2016, 2:00pm

Les commandes:

# su - postgres
$ psql bj

ne donnent toujours rien ?

E.devaud · April 25, 2016, 2:10pm

root@inbox:~# su - postgres
postgres@inbox:~$  psql bj
psql (9.3.10)
Type "help" for help.

bj=#

Toony · April 25, 2016, 2:16pm

Re-démarrez les services BlueMind dans ce cas:

# bmctl restart

Est-ce mieux ?

E.devaud · April 25, 2016, 2:44pm

J’arrive maintenant a m’authentifier, mais ensuite page blanche sur mon site de bluemind.

Toony · April 25, 2016, 3:08pm

Sur quelle URL ?
Est-ce bon si vous accèdez directement à l’agenda (URL: https//bm.srv.tld/cal) ?