HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Server problem after ISPconfig upgrade and shift from Ubuntu 11 to Ubuntu 12.04 (http://www.howtoforge.com/forums/showthread.php?t=59484)

Agonet 9th November 2012 15:12

Server problem after ISPconfig upgrade and shift from Ubuntu 11 to Ubuntu 12.04
 
We have a Linux server with ISPconfig installed as stand alone server (Apache, Mysql, Postfix, Courier, Roundcube...)

Recently we did an upgrade operation of ISPconfig to ISPConfig 3.0.4.6 version and we did a release jump from 11 to 12.04 LTS.

Since then we had some strange behaviour on the server.
First of all we had to reconfigure /etc/postfix/sasl/smtpd.conf to work correctly.

We thought that everything was ok but then we experinced random failures of the SMTP auth mechanism (not on all domains, just random on some accounts)

We started to look into things and we found some things that never happened before.

For example in auth.log

Code:

Nov  9 11:16:35 efestione saslauthd[6877]: DEBUG: auth_pam: pam_authenticate failed: Memory buffer error
Nov  9 11:16:35 efestione saslauthd[6877]: do_auth        : auth failure: [user=XXXXXXXXXXXXXX] [service=smtp] [realm=XXXXXXXXX] [mech=pam] [reason=PAM auth error]

(User and realm omitted)

In the monitor section of ISPconfig we found some warnings about duplicate entries in the monitor_data that happens randomly on different dates and different hours.

Code:

DB::query(INSERT INTO monitor_data (server_id, type, created, data, state) VALUES (1, 'sys_log', UNIX_TIMESTAMP(), 'a:1:{s:6:"output";s:0:"";}', 'warning')) -> mysql_query Duplicate entry '1-sys_log-1352433939' for key 'PRIMARY'
We have a single server.sh job in the crontab

On the mail log error panel we have different errors:

Code:

Nov 5 08:40:08 efestione amavis[6272]: (06272-03) (!!)TROUBLE in process_request: Error writing a SMTP response to the socket: Broken pipe at (eval 97) line 987, line 34.
Nov 5 11:10:28 efestione amavis[19172]: (19172-07) (!!)TROUBLE in check_mail: forwarding FAILED: Error writing to socket: Broken pipe at (eval 98) line 200.
Nov 5 17:22:56 efestione authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Nov 5 17:22:56 efestione pop3d: authentication error: Input/output error

So we looked in mysql error.log but we didn't find anything that seems relevant except that we found some error regarding this:

Code:

ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TAB
LE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
121013 10:21:51 [ERROR] Aborting

But from what we see Mysql is working fine.

So we don't know right now what is wrong with this setup.
Could someone please help?
Thank you

till 9th November 2012 15:38

Did you install the ubuntu update first or the ispconfig update? ISPConfig has to be updated when you switch to a new major release of a Linux distribution to ensure that the config files are rewritten to match the new Linux release.

Agonet 9th November 2012 15:51

Thank you for the reply.
Yes we did the upgrade of ISP config and then the jump release.

We'll launch the ispconfig_update so to see if the issues get resolved.


All times are GMT +2. The time now is 23:44.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.