Ticket #455 (closed Bug report: invalid)

Opened 14 years ago

Last modified 14 years ago

SQL query error just installing wifidog-auth

Reported by: anonymous Owned by:
Priority: low Milestone: WifiDog Auth Server 1.0
Component: Auth server, Install script Version:
Keywords: Cc:

Description

Hello,

I've followed all steps to install auth server, but when it redirects to the login page for the first time after the installation I can see:

execSqlUniqueRes() : An error occured while executing the following SQL query : SELECT virtual_host_id FROM virtual_hosts WHERE hostname='myhost.ec.upc.edu'

Error message : FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /var/www/wifidog-auth/wifidog/classes/AbstractDb.php:416) in /var/www/wifidog-auth/wifidog/classes/Session.php on line 83

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/wifidog-auth/wifidog/classes/AbstractDb.php:416) in /var/www/wifidog-auth/wifidog/classes/Session.php on line 83

I can see this error several times using auth server when I log as admin user.

Thanks in advance...

Change History

Changed 14 years ago by benoitg

If you are getting a "FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.", you definitely have a problem with your postgresql setup. An unsual one at that, since the connection is opened successfully, it's unliklely to be a permission problem.

So either:

  1. Try to debug your problem, start by looking in your postgresql log (on ubuntu, that would be in /var/log/postgresql/), and see if it can tell you what actually happened. You are far more likely to get usefull help in a postgres forum than here.
  2. Assume that your postgresql install was somehow corrupted, delete your datatabase cluster (the entire cluster, not just your database), uninstall postgres and resinstall postgres.

Changed 14 years ago by benoitg

  • component changed from Auth server, Content Management to Auth server, Install script

Changed 14 years ago by anonymous

Thanks, now it's working.

Changed 14 years ago by benoitg

  • status changed from new to closed
  • resolution set to invalid

Ok, closing

Note: See TracTickets for help on using tickets.