There wasn't a database connection, check if database exists

[mzaffaroni@…]

There wasn't a database connection, check if database exists\n

Error

There wasn't a database connection, check if database exists\n

Trace

There wasn't a database connection, check if database exists\n at /usr/share/perl5/EBox/PgDBEngine.pm line 139
	EBox::PgDBEngine::_disconnect('EBox::PgDBEngine=HASH(0x7f01ff134798)') called at /usr/share/perl5/EBox/PgDBEngine.pm line 708
	EBox::PgDBEngine::DESTROY('EBox::PgDBEngine=HASH(0x7f01ff134798)') called at /usr/share/perl5/Error.pm line 408
	EBox::CGI::Base::run('EBox::CGI::Logs::Index=HASH(0x7f020399e9e0)') called at /usr/share/perl5/EBox/CGI/Run.pm line 129
	EBox::CGI::Run::run('EBox::CGI::Run', 'Logs/Index', 'EBox') called at /usr/share/zentyal/cgi/ebox.cgi line 34
	ModPerl::ROOT::ModPerl::Registry::usr_share_zentyal_cgi_ebox_2ecgi::handler('Apache2::RequestRec=SCALAR(0x7f0204da6258)') called at /usr/lib/perl5/ModPerl/RegistryCooker.pm line 204
	eval {...} called at /usr/lib/perl5/ModPerl/RegistryCooker.pm line 204
	ModPerl::RegistryCooker::run('ModPerl::Registry=HASH(0x7f0204ccb5b8)') called at /usr/lib/perl5/ModPerl/RegistryCooker.pm line 170
	ModPerl::RegistryCooker::default_handler('ModPerl::Registry=HASH(0x7f0204ccb5b8)') called at /usr/lib/perl5/ModPerl/Registry.pm line 31
	ModPerl::Registry::handler('ModPerl::Registry', 'Apache2::RequestRec=SCALAR(0x7f0204da6258)') called at -e line 0
	eval {...} called at -e line 0

[anonymous]

zentyal.log

[jamor@…]

Hello Mzaffaroni,

Probably there was a postgresql installation error and it does not started at time. Please, run the following command:

sudo /usr/share/zentyal/create-db eboxlogs

.. and check if this solve the problem.

Regards,

Javier

[sysadmin@…]

Hello,

I've got the same problem. I don't know if it happens after the last update or after joining an AD domain (with samba / kerberos and winbind.

the creat-db gave me that :

• Restarting PostgreSQL 8.4 database server * The PostgreSQL server failed to start. Please check the log output:

2012-03-05 15:44:18 CET LOG: could not translate host name "localhost", service "5432" to address: Name or service not known 2012-03-05 15:44:18 CET WARNING: could not create listen socket for "localhost" 2012-03-05 15:44:18 CET FATAL: could not create any TCP/IP sockets

[sysadmin@…]

solved by changing "listen_addresses = '127.0.0.1'" in /etc/postgresql/8.4/main/postgresql.conf

[jamor@…]

Hello,

I am sorry but the command was wrong, the complete command is:

sudo /usr/share/zentyal/create-db eboxlogs 

I have edited the original post with the good command.

I see that you managed to start postgresql but run anyway the command to assure the needed db tables are created.

Regards,

Javier

[jamor@…]

See also #3915 for a seup i which DB creation could fail