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 20th July 2010, 05:59
MrCompTech MrCompTech is offline
Member
 
Join Date: Jul 2010
Posts: 92
Thanks: 1
Thanked 20 Times in 9 Posts
Default Is the table sys_datalog in the dbispconfig database used to store cron tasks?

By cron tasks i mean if you make a change such as adding a DNS entry is this information stored in the sys_datalog table?

It would seem that tasks need to be stored somewhere until executed.

But after the task has been completed shouldn't it be removed from the sys_datalog table?

I have 302 entries in this table and they are all "pending", is this the way it is supposed to be?

When I try to run the server/sh script it says there is already one running so exiting.

Last edited by MrCompTech; 20th July 2010 at 06:05.
Reply With Quote
Sponsored Links
  #2  
Old 20th July 2010, 09:58
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

Quote:
By cron tasks i mean if you make a change such as adding a DNS entry is this information stored in the sys_datalog table?
The sys datalog tables stores snapshots ov every changed dataset to replicate it in a multiserver setup and to raise the events on the server side.

Quote:
It would seem that tasks need to be stored somewhere until executed.
cron tasks are stored in the cron database table and in the system crontab.

Quote:
I have 302 entries in this table and they are all "pending", is this the way it is supposed to be?
Yes.

Quote:
When I try to run the server/sh script it says there is already one running so exiting.
Thats ok.

And what is your actual problem?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 20th July 2010, 23:55
MrCompTech MrCompTech is offline
Member
 
Join Date: Jul 2010
Posts: 92
Thanks: 1
Thanked 20 Times in 9 Posts
Default Actual Problem - Websites/DNS

My problem was that I added three web sites including DNS entries for all three and only 1 of the three websites was I able to browse to.

After running the server.sh script and restarting named several times over a span of about 15 minutes the two sites still came back with http 404 file not found. But the default index.html file was there.

So I deleted the DNS entries and the websites, ran server.sh, restarted named, recreated the websites and the DNS entries. Even though the DNS entries showed in the ISPConfig web console the DNS entries were not added to named.conf.local and the zone files such as /var/named/pri.mrcomptech.com were not created even after about 20 minutes.

That's when I ran the server.sh script and it gave the error that a task was already running and using "ps -A | grep -i server" I cold see that it was still running after probazbly about 15 minutes.

So I deleted the DNS entries, the three websites that i had just created, the deleted the ispconfig lock file "/usr/local/ispconfig/server/temp/.ispconfig_lock" then rebooted.

After the reboot I recreated the websites and DNS entries then all was fine.

Apparently, the server.sh script could not finish running, since debug was not on at the time a don't know were it stopped in it's execution.
Reply With Quote
  #4  
Old 21st July 2010, 00:04
MrCompTech MrCompTech is offline
Member
 
Join Date: Jul 2010
Posts: 92
Thanks: 1
Thanked 20 Times in 9 Posts
 
Default Where are the ispconfig tasks stored while waiting to be executed?

Code:
cron tasks are stored in the cron database table and in the system crontab
What files specifically, are used to store this information?
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
Upgrade problem after having added tables to dbispconfig database DFen Installation/Configuration 1 22nd October 2009 18:47
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 15:31
About database or database table to be used satimis Server Operation 4 21st October 2008 19:02
Howto analyse a IPTables firewall issue? chillifire Installation/Configuration 2 27th August 2008 08:23
phpmyadmin error lifeisboost Installation/Configuration 9 14th August 2008 20:19


All times are GMT +2. The time now is 18:35.


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