UCJ database problem. Please help

[EricTheRed]

My ucj database appears to be locked. Incoming and outgoing numbers aren't changing and haven't changed in hours. I have even tried a reset and no luck. Is there a file I can safely delete that will start the stats from scratch? I even tried to restore from this mornings backup without any change.

Thanks,
Eric

[Coke]

Did you check your cronjob?

[EricTheRed]

cronfile1 and cronfile2 are there
I don't know where they actually execute from there's nothing in crontab

[Coke]

Type:

crontab -l

If the line with ucjcron.cgi isn't shown in the output type
crontab cronfile1
!OR!
crontab cronfile2

Choose either cronfile1 or cronfile2, depending on when you'd like UCJ to be updated (1-3-5,... or 2-4-6 (minutes)).

This should get your cronjob working again.

[EricTheRed]

So it would probably be wise of me to add that to system startup!

Thanks,
Eric

[Coke]

Eh, why would you want to do this?? A cronjob is persistent unless you delete it.

[EricTheRed]

My server was restarted today and the cronfile2 wasn't initiated so I'm guessing if the server is rebooted then I need to kick it back up. Better off to add it to system startup via a shell script than to have to log in and restart it manually.

Eric

[Coke]

Well don't add it to the startup scripts.

If a server is rebooted all cronjobs still remain up. If you add a cronjob at every reboot you'll soon have many concurrent cronjobs which makes your UCJ database crash for sure.

Probably somebody removed the cronjob without wanting to do so, but it can't be removed by a simple reboot.
You can easily see this by rebooting your server yourself (command: 'shutdown -r now'). I'm quite sure it will still be there afterwards http://bbs.adultwebmasterinfo.com/ubb/smile.gif

[EricTheRed]

When I added cronfile1 to cron it deleted my other cron jobs???

Eric

[EricTheRed]

Hey Coke!

Thanks for the help http://bbs.adultwebmasterinfo.com/ubb/smile.gif

Eric