Server problem after ISPconfig upgrade and shift from Ubuntu 11 to Ubuntu 12.04

Discussion in 'General' started by Agonet, Nov 9, 2012.

  1. Agonet

    Agonet New Member

    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=[COLOR="Orange"]XXXXXXXXXXXXXX[/COLOR]] [service=smtp] [realm=[COLOR="Orange"]XXXXXXXXX[/COLOR]] [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 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
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  3. Agonet

    Agonet New Member

    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.

Share This Page