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
  #11  
Old 10th March 2011, 17:45
James A James A is offline
Member
 
Join Date: Jan 2011
Posts: 67
Thanks: 15
Thanked 0 Times in 0 Posts
Default

Hi Till

Just tried your suggested test, unfortunately still nothing in the job queue.
Reply With Quote
Sponsored Links
  #12  
Old 10th March 2011, 18:10
James A James A is offline
Member
 
Join Date: Jan 2011
Posts: 67
Thanks: 15
Thanked 0 Times in 0 Posts
Default

Hi Till

Just checking the mailuser database table, I can confirm that the account is appearing to update on mysql. Here's the output form one of the tests adding an autoresponder and custom filter:

mailuser_id: 40
sys_userid: 1
sys_groupid: 0
sys_perm_user: riud
sys_perm_group: riud
sys_perm_other:
server_id: 1
email: james@xyz.com
password: xxxxxxxxxx
name:
uid: 5000
gid: 5000
maildir: /var/vmail/xyz.com/james
quota: 529530880
cc:
homedir: /var/vmail
autoresponder: y
autoresponder_start_date: 2011-03-10 16:25:00
autoresponder_end_date: 2011-03-12 00:00:00
autoresponder_text: help me
move_junk: n
custom_mailfilter: cc: james_ashworth@blahblah.com
postfix: y
access: n
disableimap: n
disablepop3: n
disabledeliver: n
disablesmtp: n
Reply With Quote
  #13  
Old 11th March 2011, 12:50
James A James A is offline
Member
 
Join Date: Jan 2011
Posts: 67
Thanks: 15
Thanked 0 Times in 0 Posts
Default

Hi Till

Sorry to keep pestering but I'm hoping I can get to the bottom of this shortly. Can you tell me where the raw data for the job queue displayed in ISPConfig is stored, I assume it is in the sys_datalog table. This currently has jobs listed in it, hence I wanted to know which process is used to retrieve this job queue so I can check this.

I guess my concern is that ever since we truncated the sys_datalog table to clear the jobs that were simply stacking up we found the jobs queue stopped being added to (apologies if this was not clear from my earlier email).
Reply With Quote
  #14  
Old 11th March 2011, 14:23
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,983
Thanks: 825
Thanked 5,372 Times in 4,219 Posts
Default

Quote:
I guess my concern is that ever since we truncated the sys_datalog table to clear the jobs that were simply stacking up we found the jobs queue stopped being added to (apologies if this was not clear from my earlier email).
Ok, then its clear what the problem is, you should have mentioned that in the first post! Never delete records manually in the sys_datalog or you will break the system! The jobs in sys_datalog are cleared automatically by ispconfig, so do not touch this table.

If you truncate the table, then you reset the auto incremenet ID's of the table which causes the server jobs to get out of sync.

To fix the problem, edit the server record in the server table and set the value of the updated column to 1.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #15  
Old 11th March 2011, 14:57
James A James A is offline
Member
 
Join Date: Jan 2011
Posts: 67
Thanks: 15
Thanked 0 Times in 0 Posts
 
Default

Hi Till

It Works!

My bad, I had mentioned clearing sys_datalog but not specified that we had truncated this in order to clear it. Out of interest, the only reason we truncated the table was bacause the system wouldn't clear the jobqueue, is there any other way to clear it?

Once again many thanks for all your support and for a great product.
Reply With Quote
Reply

Bookmarks

Tags
autoresponder, courier, jobqueue, mail filter, plugin

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
ffmpeg Video support for ubuntu 7.10 [suphp-ispconfig] amaurib Installation/Configuration 13 16th February 2010 17:26
when deleting index.* files index.html is created and owned by root pssara Installation/Configuration 3 27th February 2009 12:37
The system is currently updating the configuration files. warlock General 8 21st February 2009 18:15
ubuntu 8.04 server installation of ispconfig fails DocProc Installation/Configuration 27 5th June 2008 21:23
pure-ftp woes d3th_n1gG4 Server Operation 4 24th January 2007 13:11


All times are GMT +2. The time now is 06:21.


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