Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th April 2013, 16:47
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default 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 ?

Last edited by Snowman; 8th April 2013 at 17:08.
Reply With Quote
Sponsored Links
  #2  
Old 11th April 2013, 15:55
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default bump

bump,
please help I am lost in my ideas where is the problem..
Reply With Quote
  #3  
Old 23rd April 2013, 14:52
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default

Quote:
Originally Posted by Snowman View Post
bump,
please help I am lost in my ideas where is the problem..
Still no one able to help me ?
Reply With Quote
  #4  
Old 23rd April 2013, 15:05
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,769
Thanks: 840
Thanked 5,608 Times in 4,419 Posts
Default

Increase the value of the updated column for this server record in the server table by 1 to skip the failing entry.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 23rd April 2013, 15:30
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default

Quote:
Originally Posted by till View Post
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 ?

Last edited by Snowman; 23rd April 2013 at 15:30. Reason: action ID
Reply With Quote
  #6  
Old 23rd April 2013, 15:36
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default

Quote:
Originally Posted by Snowman View Post
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.
Reply With Quote
  #7  
Old 23rd April 2013, 15:55
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,769
Thanks: 840
Thanked 5,608 Times in 4,419 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 23rd April 2013, 16:04
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default

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'.
Reply With Quote
  #9  
Old 23rd April 2013, 17:10
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default

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'.
Reply With Quote
  #10  
Old 24th April 2013, 14:35
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
 
Default

Any other thoughts ?
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
All files gone after changing quota to 0 spynode General 17 19th January 2012 15:41
Version 1.3 of the ISPConfig 3 Manual is finally available! falko General 44 2nd December 2011 13:04
Bug? in how Ispconfig 3 does upgrade installs. Bookworm General 0 13th September 2009 07:40
Upgrade has taken ISPConfig offline, help! indie1982 Installation/Configuration 2 9th September 2008 21:18
Upgrading failed, ispconfig broken and ispconfig won't upgrade again dfriis Installation/Configuration 7 14th June 2006 18:54


All times are GMT +2. The time now is 23:22.


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