ispconfig after upgrade to 3.0.5.2

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

  1. Snowman

    Snowman 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 Member

    bump

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

    Snowman Member

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

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    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 Member

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

    Snowman 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 Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    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 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 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 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