Modify

Ticket #3625 (closed defect: fixed)

Opened 17 months ago

Last modified 16 months ago

ERROR> PgDBEngine.pm:118 EBox::PgDBEngine::_connect - Connection DB Error:

Reported by: mka@… Owned by: jamor@…
Milestone: 2.2.X Component: gui
Severity: normal Keywords: postgres
Cc: mka@…

Description

i cant login to the Zentyal GUI (core: 2.2.4)

2011/12/21 15:08:59 ERROR> PgDBEngine.pm:139 EBox::PgDBEngine::_disconnect - There wasn't a database connection, check if database exists\n

error.log & server.log as attach

ps: other service runs (e.g. VPN or SMB ...) pps: postgrey 5589 0.0 0.2 12012 8780 ? Ss 13:16 0:00 /usr/sbin/postgrey --inet 127.0.0.1:60000 --delay=300 --

Attachments

zentyal.tar.gz Download (121.8 KB) - added by mka@… 17 months ago.
error.log & zentyal.log
postgresql-8.4-main.log.1 Download (6.6 KB) - added by mka@… 17 months ago.
postgres logfile

Change History

Changed 17 months ago by mka@…

error.log & zentyal.log

comment:1 Changed 17 months ago by jamor@…

  • Status changed from new to closed
  • Resolution set to worksforme

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

.. and check if this solves the problem.

Anyway if you remember how you arrived to this situation we would love to hear it.

Regards,

Javier

Changed 17 months ago by mka@…

postgres logfile

comment:2 Changed 17 months ago by mka@…

  • Keywords postgres added; https removed

sorry javier,

I did not have any information that you've written me an answer (a nice fature for bugtracking, a short email msg. at new comments ;) )

if i do: sudo /usr/share/zentyal/create-db

:~$ sudo /usr/share/zentyal/create-db

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

the postgres.log was empty ?! i attach the file *.log and *.log1

yes I know exactly what I did before the error was !! i make a login to the zentyal GUI i change the password from the "default user" (with the sudo rights, which is established at setup) and then came the error...

you can meet my also via email, quest javivaz* for my data ;)

btw: happy new year

comment:3 Changed 17 months ago by mka@…

  • Cc mka@… added
  • Status changed from closed to reopened
  • Resolution worksforme deleted

sorry, i found the rss feed of this bug. and the option: Add to Cc: ;)

comment:4 Changed 16 months ago by mka@…

new, but not good, news.... update dosent work... (ok, no postgres)

root command /usr/bin/sudo -p sudo: -u postgres psql -f /usr/share/zentyal-squid/sql/squid_access.sql eboxlogs failed. Error output: 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"?

Command output: . Exit value: 2dpkg: Fehler beim Bearbeiten von zentyal-squid (--configure):

Unterprozess installiertes post-installation-Skript gab den Fehlerwert 2 zurück

Fehler traten auf beim Bearbeiten von:

zentyal-squid

E: Sub-process /usr/bin/dpkg returned an error code (1)

comment:5 Changed 16 months ago by mka@…

hola again,

thanks debian (and his users) i found a solution for my postgres-install problem. (apt + dpkg helps) now, my postgres server starts! but, i cant always login to the zentyal GUI. i have a new (fresh) installt postgres - its empty

i do the create db command...

:~$ sudo /usr/share/zentyal/create-db [sudo] password for myserver: Creating the database createdb: database creation failed: ERROR: database "postgres" already exists psql: FATAL: Ident authentication failed for user "GRANT ALL ON DATABASE TO ebox" psql: FATAL: Ident authentication failed for user "CREATE LANGUAGE plpgsql" root command /usr/bin/sudo -p sudo: -u postgres psql -f /usr/share/zentyal/sql/admin.sql eboxlogs failed. Error output: psql: FATAL: database "eboxlogs" does not exist

Command output: . Exit value: 2

saludos

comment:6 Changed 16 months ago by cperez@…

  • Owner changed from cperez@… to jamor@…
  • Status changed from reopened to new

comment:7 Changed 16 months ago by jamor@…

Hello Mka,

sorry it is needed a argument to the command. Try:

:~$ sudo /usr/share/zentyal/create-db eboxlogs

Regards,

Javier

comment:8 Changed 16 months ago by mka@…

  • Status changed from new to closed
  • Resolution set to fixed

my last theorem in spain is: "Podría darte un beso" ;)

YES, it's Work.

i must! re-install the postgres, postgres-client... and then yours command... the zentyal GUI was online....

View

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.