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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 9th November 2012, 15: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 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
Reply With Quote
Sponsored Links
  #2  
Old 9th November 2012, 15:38
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: LŁneburg, Germany
Posts: 36,011
Thanks: 826
Thanked 5,379 Times in 4,226 Posts
Default

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
  #3  
Old 9th November 2012, 15:51
Agonet Agonet is offline
Junior Member
 
Join Date: Nov 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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
Reply

Bookmarks

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 16:26.


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