1 (edited by cotel_webmaster 2014-12-17 03:57:45)

Topic: [SOLVED][Error after upgrade] Php Page is not working

==== Required information ====
- iRedMail version: 1.8.2
- Store mail accounts in MySQL
- Linux/BSD distribution name and version: Ubuntu 14.04.1 LTS

Hello,

After upgrading from iRedAdmin Open source edition, the <website>/iredadmin link works in the login screen, but after trying to log in the webpage freezes and it won't advance, even after 2 minutes.

I did the upgrade as it is on the wiki:

# cd /root/
# tar xjf iRedAdmin-Pro-x.y.z.tar.bz2
# cd iRedAdmin-Pro-x.y.z/tools/
# bash upgrade_iredadmin.sh

Here is te apache log (/var/log/apache2/error_log):


[Mon Dec 15 08:28:00.029761 2014] [mpm_prefork:notice] [pid 8145] AH00169: caught SIGTERM, shutting down
[Mon Dec 15 08:28:00.842066 2014] [ssl:warn] [pid 8308] AH01909: RSA certificate configured for mail.cotel.com.ar:443 does NOT include an ID which matches the server name
[Mon Dec 15 08:28:00.842320 2014] [ssl:warn] [pid 8308] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Mon Dec 15 08:28:01.699853 2014] [ssl:warn] [pid 8310] AH01909: RSA certificate configured for mail.cotel.com.ar:443 does NOT include an ID which matches the server name
[Mon Dec 15 08:28:01.700056 2014] [ssl:warn] [pid 8310] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Mon Dec 15 08:28:01.726349 2014] [mpm_prefork:notice] [pid 8310] AH00163: Apache/2.4.7 (Ubuntu) OpenSSL/1.0.1f mod_wsgi/3.4 Python/2.7.6 configured -- resuming normal operations
[Mon Dec 15 08:28:01.726400 2014] [core:notice] [pid 8310] AH00094: Command line: '/usr/sbin/apache2'

And the mail.log (/var/log/mail.log)

Dec 15 08:36:07 vmail2 postfix/smtpd[8343]: disconnect from unknown[192.168.0.12]
Dec 15 08:37:06 vmail2 postfix/smtpd[8343]: connect from unknown[192.168.0.12]
Dec 15 08:37:07 vmail2 postfix/smtpd[8343]: disconnect from unknown[192.168.0.12]
Dec 15 08:38:03 vmail2 postfix/anvil[8345]: statistics: max connection rate 2/60s for (smtp:192.168.0.12) at Dec 15 08:29:03
Dec 15 08:38:03 vmail2 postfix/anvil[8345]: statistics: max connection count 1 for (smtp:192.168.0.12) at Dec 15 08:28:03
Dec 15 08:38:03 vmail2 postfix/anvil[8345]: statistics: max cache size 1 at Dec 15 08:28:03
Dec 15 08:38:07 vmail2 postfix/smtpd[8343]: connect from unknown[192.168.0.12]
Dec 15 08:38:08 vmail2 postfix/smtpd[8343]: disconnect from unknown[192.168.0.12]
Dec 15 08:39:07 vmail2 postfix/smtpd[8343]: connect from unknown[192.168.0.12]
Dec 15 08:39:08 vmail2 postfix/smtpd[8343]: disconnect from unknown[192.168.0.12]

The auth log (/var/log/auth.log):

Dec 15 08:20:02 vmail2 CRON[8205]: pam_unix(cron:session): session opened for user www-data by (uid=0)
Dec 15 08:20:02 vmail2 CRON[8206]: pam_unix(cron:session): session opened for user root by (uid=0)
Dec 15 08:20:02 vmail2 CRON[8206]: pam_unix(cron:session): session closed for user root
Dec 15 08:20:03 vmail2 CRON[8205]: pam_unix(cron:session): session closed for user www-data
Dec 15 08:30:01 vmail2 CRON[8385]: pam_unix(cron:session): session opened for user www-data by (uid=0)
Dec 15 08:30:02 vmail2 CRON[8385]: pam_unix(cron:session): session closed for user www-data
Dec 15 08:39:02 vmail2 CRON[8476]: pam_unix(cron:session): session opened for user root by (uid=0)
Dec 15 08:39:04 vmail2 CRON[8476]: pam_unix(cron:session): session closed for user root
Dec 15 08:40:01 vmail2 CRON[8491]: pam_unix(cron:session): session opened for user www-data by (uid=0)
Dec 15 08:40:02 vmail2 CRON[8491]: pam_unix(cron:session): session closed for user www-data

And the dovecot log (/var/log/dovecot.log):

Dec 15 08:40:07 pop3-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<zd5QtD8KCQDAqAAM>
Dec 15 08:40:08 imap-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<8SFgtD8KCwDAqAAM>
Dec 15 08:41:08 pop3-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<hn3otz8KHwDAqAAM>
Dec 15 08:41:09 imap-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<3vP3tz8KIgDAqAAM>
Dec 15 08:42:08 pop3-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<3giAuz8KPQDAqAAM>
Dec 15 08:42:09 imap-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<vIaPuz8KPwDAqAAM>
Dec 15 08:43:09 pop3-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<VqUcvz8KUADAqAAM>
Dec 15 08:43:10 imap-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<p1ssvz8KUgDAqAAM>
Dec 15 08:44:09 pop3-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<2by9wj8KeADAqAAM>
Dec 15 08:44:10 imap-login: Info: Aborted login (no auth attempts in 1 secs): user=<>, rip=192.168.0.12, lip=192.168.0.22, session=<fDzNwj8KegDAqAAM>

The other logs are empty.

I have another server for testing and on that server, the page loads (after 10-20 seconds) and both servers are exactly the same, the only difference is than the active one just doesn't work.

There are also no errors on login or anithing, it just doesn't log in.

Best Regards,
Cotel Webmaster

----

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

2

Re: [SOLVED][Error after upgrade] Php Page is not working

cotel_webmaster wrote:

After upgrading from iRedAdmin Open source edition, the <website>/iredadmin link works in the login screen, but after trying to log in the webpage freezes and it won't advance, even after 2 minutes.

You have too many old records in Amavisd SQL database, it slows down the login progress. Please execute script "tools/cleanup_amavisd_db.py" shipped in iRedAdmin-Pro to cleanup old records.

WARNING: It may take long time if you have too many records in Amavisd SQL database.

3

Re: [SOLVED][Error after upgrade] Php Page is not working

I had to stop the service, create empty new tables, rename the tables in order to work, because amavis had arround 5 gb of information on the table.

Thanks, that worked perfectly after cleaning the log