Ticket #3625 (closed defect: fixed)
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
Change History
Changed 17 months ago by mka@…
-
attachment
zentyal.tar.gz
added
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
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
error.log & zentyal.log