Scheduler not firing

English Language - Forum
1

I have SuiteCRM 7.11.20 installed in MacBoom with MAMP. I have got the crontab configured according to the edit suggestion at the bottom of the schedulers screen.

When I look a the log of Check Inbound Mailboxes scheduled job (which is running every minute, I see no log). I have configured a group mailbox to create a case. The mail setup seem is correct based on the test connection.

I am not sure what to look in the logs as I am new to SuiteCRM in general. Any help is appreciated.

2

Is the crontab running? what do you see for the following command.

crontab -l

3

I do not sure how to verify if crontab is running. Can you show give me pointer?

for crontab -l, i
t shows the following:

          • cd /Applications/MAMP/htdocs/crm; php -f cron.php > /dev/null 2>&1
4

Hi,
did you have a look in the suitecrm.log already? I could imagine that the user executing the cron.php is not listed in your config.php:

 'allowed_cron_users' => 
    array (
      0 => 'www-data',
    ),

if I’m correct, you should find log entries like “user xyz is not allowed to execute cron.php”. In this case, you need to update your config.php with the proper user.

5

When I ran ‘php -f cron.php;’ in the terminal, I get the error about not being able to connect to database in the terminal.
Could not connect to the database. Please refer to suitecrm.log for details (0).

Fatal error: Uncaught Exception: Could not connect to the database. Please refer to suitecrm.log for details (0). in /Applications/MAMP/htdocs/crm/include/utils.php:1906

Stack trace:

#0 /Applications/MAMP/htdocs/crm/include/database/MysqliManager.php(327): sugar_die(‘Could not conne…’)

#1 /Applications/MAMP/htdocs/crm/include/database/DBManagerFactory.php(150): MysqliManager->connect(Array, true)

#2 /Applications/MAMP/htdocs/crm/include/entryPoint.php(182): DBManagerFactory::getInstance()

#3 /Applications/MAMP/htdocs/crm/cron.php(48): require_once(’/Applications/M…’)

#4 {main}

thrown in /Applications/MAMP/htdocs/crm/include/utils.php on line 1906

In the suitecrm.log, I see the following:
Could not connect to DB server localhost as root. port : No such file or directory

I have:

‘allowed_cron_users’ =>
array (
0 => ‘utia’,
),

where utia is the user.

what is www-data?

6

the user associated with your webserver, usually its something like “apache” or “www-data”. If the rest of the crm is working fine, you should already know which user to enter (when you ran the chown command).

Otherwise, have a look at the schedulers ListView. At the bottom of the screen you should find install instructions prepared for your environment, and the proper user is mentioned there too. After completing this step (adding the cron), just add the user (if missing) to the allowed_cron_users-array.

Besides that:

In general, it is technically okay to use the root-user directly, but from a security perspective you might want to create a designated DB-user for Suite.

7

Thanks. But I could not get this working at all. I will try some other measures. However, I am not seeing this behavior in Windows system. so I am moving to windows for now.