SQL query error just installing wifidog-auth

[anonymous]

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...

[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.

[anonymous]

Thanks, now it's working.

[benoitg]

Ok, closing