Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 9th November 2012, 16:12
Agonet Agonet is offline
Junior Member
Join Date: Nov 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 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

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.

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:

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:

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
Reply With Quote
Sponsored Links
Old 9th November 2012, 16:38
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts

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.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Old 9th November 2012, 16:51
Agonet Agonet is offline
Junior Member
Join Date: Nov 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

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.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT +2. The time now is 02:41.

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