ispconfig after upgrade to 3.0.5.2

Discussion in 'General' started by Snowman, Apr 8, 2013.

  1. Snowman

    Snowman New Member

    Hi there,
    i encountered problem with server.php script after upgrading to 3.0.5.1 (now 3.0.5.2 - this is last patch/update that I've installed recently) : tail -f /var/log/ispconfig/ispconfig.log shows :

    08.04.2013-13:40 - DEBUG - Found 10 changes, starting update process.
    08.04.2013-13:40 - DEBUG - Calling function 'user_insert' from plugin 'mail_plugin' raised by event 'mail_user_insert'.

    Problem is related to master (primary) server where no job queues are executed. There are queued commands like :
    2013-03-11 20:52 vulpix.xx.yy Delete ftp_user
    2013-03-11 20:44 vulpix.xx.yy Update ftp_user
    2013-03-11 20:44 vulpix.xx.yy Insert ftp_user
    2013-03-11 20:43 vulpix.xx.yy Insert ftp_user
    2013-03-11 20:42 vulpix.xx.yy Update ftp_user
    2013-03-11 20:42 vulpix.xx.yy Update ftp_user
    2013-03-11 14:32 vulpix.xx.yy Update server
    2013-03-11 14:32 vulpix.xx.yy Update server
    2013-03-05 22:25 vulpix.xx.yy Update mail_user
    2013-03-05 22:19 vulpix.xx.yy Insert mail_user
    (upper is copy&paste from webinterface job queue on master server)
    Commands never gets executed and ispconfig is unusable. We cannot change no settings from that date.

    I hope someone will try to research my issue..

    Thanks a lot.

    Martin

    - Server running Debian 6.x - up-to-date squeezy

    UPDATE :

    mysql> select * from sys_remoteaction;
    +-----------+-----------+------------+-------------+--------------+--------------+----------+
    | action_id | server_id | tstamp | action_type | action_param | action_state | response |
    +-----------+-----------+------------+-------------+--------------+--------------+----------+
    | 5 | 1 | 1322228933 | ispc_update | | ok | |
    +-----------+-----------+------------+-------------+--------------+--------------+----------+
    1 row in set (0.00 sec)

    Is this OK ?
     
    Last edited: Apr 8, 2013
  2. Snowman

    Snowman New Member

    bump

    bump,
    please help :( I am lost in my ideas where is the problem..
     
  3. Snowman

    Snowman New Member

    Still no one able to help me :( ?
     
  4. till

    till Super Moderator

    Increase the value of the updated column for this server record in the server table by 1 to skip the failing entry.
     
  5. Snowman

    Snowman New Member

    You mean, I should change action id from 1 to 2 ?
     
    Last edited: Apr 23, 2013
  6. Snowman

    Snowman New Member

    Nothing changed, even if i delete this row.

    I found this when I manually start server.php :

    # /usr/bin/php -q /usr/local/ispconfig/server/server.php
    23.04.2013-12:33 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    23.04.2013-12:33 - DEBUG - Found 13 changes, starting update process.
    23.04.2013-12:33 - DEBUG - Calling function 'user_insert' from plugin 'mail_plugin' raised by event 'mail_user_insert'.

    no other rows..

    2013-03-05 22:19 vulpix.xx.yy Insert mail_user
    is the oldest request submited to ispconfig interface. From this time no interface actions are done and they are still in queue as i wrote before.
     
  7. till

    till Super Moderator

    No. You should increase the number which you find in the "updated" column of the server record in the server table. I did not mention any action ID's and actions are also not related to your problem.
     
  8. Snowman

    Snowman New Member

    mysql> select server_id,updated from server limit 10;
    +-----------+---------+
    | server_id | updated |
    +-----------+---------+
    | 1 | 2361 |
    | 2 | 2382 |
    +-----------+---------+
    2 rows in set (0.00 sec)

    mysql> update server set updated='2362' where server_id='1'
    -> ;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1 Changed: 1 Warnings: 0

    You mean like this ?

    I've updated "updated" number to +1 and server shows the same :

    # /usr/local/ispconfig/server/server.sh
    23.04.2013-13:00 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    /usr/bin/fail2ban-client
    /sbin/iptables
    /sbin/ip6tables
    23.04.2013-13:00 - DEBUG - Found 12 changes, starting update process.
    23.04.2013-13:00 - DEBUG - Calling function 'user_update' from plugin 'mail_plugin' raised by event 'mail_user_update'.
     
  9. Snowman

    Snowman New Member

    mysql> select server_id,updated from server limit 10;
    +-----------+---------+
    | server_id | updated |
    +-----------+---------+
    | 1 | 2361 |
    | 2 | 2382 |
    +-----------+---------+
    2 rows in set (0.00 sec)

    mysql> update server set updated='2362' where server_id='1'
    -> ;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1 Changed: 1 Warnings: 0

    You mean like this ?

    I've updated "updated" number to +1 and server shows the same :

    # /usr/local/ispconfig/server/server.sh
    23.04.2013-13:00 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    /usr/bin/fail2ban-client
    /sbin/iptables
    /sbin/ip6tables
    23.04.2013-13:00 - DEBUG - Found 12 changes, starting update process.
    23.04.2013-13:00 - DEBUG - Calling function 'user_update' from plugin 'mail_plugin' raised by event 'mail_user_update'.
     
  10. Snowman

    Snowman New Member

    Any other thoughts ?
     
  11. Franz

    Franz Member

    I have the same problem.


    look in vmail directory and check if all direcotries have vmail:vmail premisions.
     

Share This Page