Error installing Datafari v4.1

[THIAGO FERNANDO DE AZEVEDO]

Hello

I am trying to start Datafari 4.1 on a server with 192.0 GB of RAM and 2 x Intel (R) Xeon (R) CPU E5-2620 0 @ 2.00GHz with Debian 9.4 and jdk1.8.0_151, but I get an error. The error is:

____________________________________________________________________

jul 19, 2018 5:44:48 PM org.postgresql.Driver connect GRAVE: Connection error: org.postgresql.util.PSQLException: FATAL: empty password returned by client at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) at org.postgresql.Driver.makeConnection(Driver.java:450) at org.postgresql.Driver.connect(Driver.java:252) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:144) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnectionWithRetries(ConnectionFactory.java:126) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:75) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:797) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1457) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:204) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:538) at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:994) at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:135) at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37) at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60) jul 19, 2018 5:44:58 PM org.postgresql.Driver connect GRAVE: Connection error: org.postgresql.util.PSQLException: FATAL: empty password returned by client at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) at org.postgresql.Driver.makeConnection(Driver.java:450) at org.postgresql.Driver.connect(Driver.java:252) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:144) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnectionWithRetries(ConnectionFactory.java:126) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:75) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:797) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1457) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:204) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:538) at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:994) at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:135) at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37) at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60) jul 19, 2018 5:45:08 PM org.postgresql.Driver connect GRAVE: Connection error: org.postgresql.util.PSQLException: FATAL: empty password returned by client at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) at org.postgresql.Driver.makeConnection(Driver.java:450) at org.postgresql.Driver.connect(Driver.java:252) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:144) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnectionWithRetries(ConnectionFactory.java:126) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:75) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:797) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1457) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:204) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:538) at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:994) at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:135) at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37) at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60) jul 19, 2018 5:45:18 PM org.postgresql.Driver connect GRAVE: Connection error: org.postgresql.util.PSQLException: FATAL: empty password returned by client at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) at org.postgresql.Driver.makeConnection(Driver.java:450) at org.postgresql.Driver.connect(Driver.java:252) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:144) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnectionWithRetries(ConnectionFactory.java:126) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:75) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:797) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1457) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:204) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:538) at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:994) at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:135) at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37) at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60) org.apache.manifoldcf.core.interfaces.ManifoldCFException: Error getting connection: FATAL: empty password returned by client at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:83) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:797) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1457) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:204) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:538) at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:994) at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:135) at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37) at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60) Caused by: org.postgresql.util.PSQLException: FATAL: empty password returned by client at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) at org.postgresql.Driver.makeConnection(Driver.java:450) at org.postgresql.Driver.connect(Driver.java:252) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:144) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnectionWithRetries(ConnectionFactory.java:126) at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:75) ... 9 more [Shutdown thread] INFO org.apache.zookeeper.ZooKeeper - Session: 0x164b3a4df870001 closed

____________________________________________________________________

Regards.

Thiago

[Olivier Tavard]

Hi Thiago,

Could you provide more details about this issue ? We cannot reproduce it.

I mean did you have another instance of Postgresql running into your server before installing Datafari ? Is it a dedicated server with only Datafari installed on it ? 

Could you send us the entire logs file ?

Best regards,

Olivier

--
You received this message because you are subscribed to the Google Groups "Datafari" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datafari+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[THIAGO FERNANDO DE AZEVEDO]

Hi Olivier,

I'm using a dedicated server with a virgin Debian.

Attached logs.

Regards.

Thiago

To unsubscribe from this group and stop receiving emails from it, send an email to datafari+u...@googlegroups.com.

[Olivier Tavard]

Hello,

OK thanks for the logs.

How was the Datafari installation ? Did you fill the two admin passwords when asked ?

Could you check the content of the file /opt/datafari/pgsql/pwd.conf : is your password displayed on it or the file is empty ?

Best regards,

Olivier

[THIAGO FERNANDO DE AZEVEDO]

Hello.

During the installation I put the admin password twice. 

Yes, the pwd.conf file contains my password.

Regards

Thiago.

[THIAGO FERNANDO DE AZEVEDO]

Hello.

I fixed it. The problem is in the debian locale. It has to be:

#cat /etc/default/locale

LANG = en_US.UTF-8

Regards

Thiago

[THIAGO FERNANDO DE AZEVEDO]

Hello.

I did it by using dpkg-reconfigure locales.

Regards.

Thiago

[Olivier Tavard]

Hello,

Thanks for your report. The issue is not related to Datafari itself but to Debian configuration. The locale needs to be filled but not necessary with English value. For information for our French customers the locale is LANG="fr_FR.UTF-8".

We will update the Datafari documentation including your remark.

Thanks,

Best regards,

Olivier