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 ?
Increase the value of the updated column for this server record in the server table by 1 to skip the failing entry.
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.
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.
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'.
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'.
I have the same problem. look in vmail directory and check if all direcotries have vmail:vmail premisions.