(SOLVED) Mails are not being auto-fetched! Cron broken?

[bayerex]

Hi all,

Pleeease can someone help me here? New incoming emails are not being downloaded automatically, there seems to be something wrong with cron. I can fetch them manually no problem.

I would much appreciate some advise,
Bayerex

I have this in otrs.log every 1min:

Code: Select all

[Thu Jun 20 21:10:02 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Thu Jun 20 21:10:02 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Thu Jun 20 21:10:02 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'

sudo crontab -l -u otrs

# fetch emails every 1 min
*/1 * * * * $HOME/bin/otrs.PostMasterMailbox.pl >> /dev/null

Apparantly the status of cron is unknown

sudo service --status-all
[ ? ] cron

Ubuntu Server 12.04LTS
OTRS 3.2.7

[crythias]

What it says is the truth. So either the process_id table is crashed or it never was...

OR, your database is not called "otrs" for some reason...?

[bayerex]

What it says is the truth. So either the process_id table is crashed or it never was...

OR, your database is not called "otrs" for some reason...?

It's definitely called "otrs". But you're quite right there is no process_id table. This is an upgraded database from Windows3.1.6 to Linux 3.2.7. Looking again at this table via Phpmyadmin on the Windows3.1.6 server it says it's "in use". I'll try stopping Apache before exporting the database and then go through the upgrade process again..

[bayerex]

Ah apparently on Windows3.1.6 server the process_id table is corrupt (oh dear!). Would it be just as good to import this table from elsewhere?

[bayerex]

Solved! I exportedand replaced the process_id table from a clean 3.2.7 install into my instance. Working fine now. Thanks for much for the help.