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

[support@…]

just clicking on dhcp log

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(0xbc4ac068)') called at /usr/share/perl5/EBox/PgDBEngine.pm line 708
	EBox::PgDBEngine::DESTROY('EBox::PgDBEngine=HASH(0xbc4ac068)') called at /usr/share/perl5/Error.pm line 408
	EBox::CGI::Base::run('EBox::CGI::Logs::Index=HASH(0xbc46c8e0)') 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(0xbc36b1a8)') 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(0xbc32fd88)') called at /usr/lib/perl5/ModPerl/RegistryCooker.pm line 170
	ModPerl::RegistryCooker::default_handler('ModPerl::Registry=HASH(0xbc32fd88)') called at /usr/lib/perl5/ModPerl/Registry.pm line 31
	ModPerl::Registry::handler('ModPerl::Registry', 'Apache2::RequestRec=SCALAR(0xbc36b1a8)') called at -e line 0
	eval {...} called at -e line 0

[anonymous]

zentyal.log

[jamor@…]

Hello, it seems that you were unable to connect to the logs database. How do you installed the system? you upgraded from a previous version?.

Try this command to list the postgres databases:

sudo su postgres -c'psql -l'

If there is a 'eboxlogs' database them check that postgres is running and if not restart it.

If it is not, the database creation failed in the setup. Try this command to create them

/usr/share/zentyal/create-db

Regards, Javier

[support@…]

my postgres8.4 script is accidentally deleted from /etc/init.d , how can i get a new one

[jamor@…]

Maybe the script was not the only postgre thing missing. You should try to reisntall the psotgre system with:

apt-get install --reinstall postgresql

Then you should try to create the 'eboxlogs' database with the create-db script.

I will close this ticket because it seems that was not a Zentyal bug the root of the problem but a corruption of the postgres database.

Regards,

Javier