1

Topic: Awstats 500 Internal Server Error

======== Required information ====
- iRedMail version: 0.8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Linux/BSD distribution name and version: Debian 7
- Related log if you're reporting an issue: /var/log/apache2/error.log
====

[Sat Jan 11 21:53:27 2014] [notice] Apache/2.2.22 (Debian) mod_auth_pgsql/2.0.3 mod_ssl/2.2.22 OpenSSL/1.0.1e mod_wsgi/3.3 Python/2.7.3 configured -- resuming normal operations
[Sat Jan 11 21:53:40 2014] [error] [client 192.xx.xx.xx] [mod_auth_pgsql.c] - ERROR - mod_auth_pgsql database connection error reset failed FATAL:  password authentication failed for user "vmail"\nFATAL:  password authentication failed for user "vmail"\nFATAL:  password authentication failed for user "vmail"\n
[Sat Jan 11 22:00:38 2014] [error] [client 192.xx.xx.xx] [mod_auth_pgsql.c] - ERROR - mod_auth_pgsql database connection error reset failed FATAL:  password authentication failed for user "vmail"\nFATAL:  password authentication failed for user "vmail"\nFATAL:  password authentication failed for user "vmail"\n
[Sat Jan 11 22:00:39 2014] [error] [client 192.xx.xx.xx] File does not exist: /var/www/favicon.ico
[Sat Jan 11 22:00:45 2014] [error] [client 192.xx.xx.xx] [mod_auth_pgsql.c] - ERROR - mod_auth_pgsql database connection error reset failed FATAL:  password authentication failed for user "vmail"\nFATAL:  password authentication failed for user "vmail"\nFATAL:  password authentication failed for user "vmail"\n

Unable to access awstats and it appears to be an authentication issue. If the username/password taken from /etc/apache2/conf.d/awstats.conf is used at https://mydomain.com/phppgadmin/, it logs in fine. Any ideas?  Thanks...

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Awstats 500 Internal Server Error

No idea yet.
Why does the log contain "\n" in username? Incorrect typo in awstats.conf?

3 (edited by cygni 2014-01-13 10:56:07)

Re: Awstats 500 Internal Server Error

ZhangHuangbin wrote:

No idea yet.
Why does the log contain "\n" in username? Incorrect typo in awstats.conf?

Which awstats.conf, /etc/apache2/conf.d or /etc/awstats/?

Well, as I was typing this response, I backed up awstats.conf in /etc/apache2/conf.d and copied the content to an editor, deleted the newlines for both Auth_PG_user and Auth_PG_pwd, then added the new file. After restarting apache, awstats miraculously is now working. Weird!

Thanks!!

Edit: The following now appears in the log:

[mod_auth_pgsql.c] - ERROR - mod_auth_pgsql: Password for user postgres not found (PG-Authoritative)

4

Re: Awstats 500 Internal Server Error

Hi,
same problem. My error.log
[Wed May 13 00:28:34.590635 2015] [authn_dbd:error] [pid 4551] [client myworip:58329] AH01656: Query execution error looking up 'postmaster@mydomain.tld' in database []
[Wed May 13 00:28:55.489244 2015] [authn_dbd:error] [pid 4550] [client myworip:58334] AH01656: Query execution error looking up 'postmaster@mydomain.tld' in database []

5

Re: Awstats 500 Internal Server Error

kysil wrote:

[Wed May 13 00:28:55.489244 2015] [authn_dbd:error] [pid 4550] [client myworip:58334] AH01656: Query execution error looking up 'postmaster@mydomain.tld' in database []

Please update your SQL server config file to log general SQL commands, then show us what SQL command this authentication module executed.