HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   ispconfig after upgrade to 3.0.5.2 (http://www.howtoforge.com/forums/showthread.php?t=61338)

Snowman 8th April 2013 15:47

ispconfig after upgrade to 3.0.5.2
 
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 ?

Snowman 11th April 2013 14:55

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

Snowman 23rd April 2013 13:52

Quote:

Originally Posted by Snowman (Post 295679)
bump,
please help :( I am lost in my ideas where is the problem..

Still no one able to help me :( ?

till 23rd April 2013 14:05

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

Snowman 23rd April 2013 14:30

Quote:

Originally Posted by till (Post 296219)
Increase the value of the updated column for this server record in the server table by 1 to skip the failing entry.

You mean, I should change action id from 1 to 2 ?

Snowman 23rd April 2013 14:36

Quote:

Originally Posted by Snowman (Post 296222)
You mean, I should change action id from 1 to 2 ?

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.

till 23rd April 2013 14:55

Quote:

You mean, I should change action id from 1 to 2 ?
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.

Snowman 23rd April 2013 15:04

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

Snowman 23rd April 2013 16:10

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

Snowman 24th April 2013 13:35

Any other thoughts ?


All times are GMT +2. The time now is 20:19.

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