Yetiforcecrm: Cron job errors

[alextovey]

Morning chaps.

My cron jobs are not running correctly. I'm running 3.4.1 yetiforce on ubuntu 16.06 with 4 core cpu and 8gb ram. all settings are correct. But this is the error from my cronjob output

monster-it@web:~$ sudo sh /var/www/html/yetiforce/cron/vtigercron.sh
--------------- 2017-02-08 09:16:47 | Start CRON ----------
2017-02-08 09:16:47 | Workflow - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | SendReminder - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | LBL_CURRENCY_UPDATE - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | Scheduled Import - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | ScheduleReports - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | MailScannerAction - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | MailScannerVerification - Start task
2017-02-08 09:16:47 | MailScannerVerification - End task (0.01 s)
2017-02-08 09:16:47 | MailScannerBind - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | CardDav - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | CalDav - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | Activity state - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | LBL_MULTI_REFERENCE_VALUE - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | LBL_CRMACTIVITY_DAYS - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | Assets Renewal - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | SoldServices Renewal - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | LBL_SEND_NOTIFICATIONS - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | RecordLabelUpdater - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | PrivilegesUpdater - Task omitted, it has not been finished during the last scanning
2017-02-08 09:16:47 | UpdaterRecordsCoordinates - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | LBL_ADDRESS_BOOCK - Not ready to run as the time to run again is not completed
2017-02-08 09:16:47 | LBL_MARK_RECORDS_AS_REVIEWED - Not ready to run as the time to run again is not completed

Any help will be great thank you.

[Raggazzoo]

Good morning !

I got the same issue #3977 ... My php.ini has been configured by the Yetiforce team so I don't think it is the problem.
If someone got an idea...

[alextovey]

AH okay, So after visiting the vtiger forum as it's similar in cron job output. This is working correctly (acccording to them) the cron should be set to every 5 mins. and it will output all.

Have you ran the job manually? sudo sh /var/www/html/yetiforce/cron/vtigercron.sh

and post input here for me :)

[Raggazzoo]

This is the output

I set my cronjobs to 5 minutes but it changes nothing.

I have seen two commits about Cron, maybe it is relative to our issue

[alextovey]

@Raggazzoo right do this.
sudo updatedb
cd /usr/bin/
dir

then do a screen shot of the php folders please

[Raggazzoo]

Allright.

There is my output
output.txt

Thank's !

[mariuszkrzaczkowski]

Duplicate https://github.com/YetiForceCompany/YetiForceCRM/issues/3977
Wrongly you have set php.ini
https://yetiforce.com/en/implementer/installation-updates/103-web-server-requirements.html

[mariuszkrzaczkowski]

Check https://gitdeveloper.yetiforce.com/index.php?parent=Settings&module=ConfReport&view=Index&block=14&fieldid=65

[alextovey]

@Raggazzoo not sure what hes about. Okay so you need to locate your php core file. whats the o/s and version your using?

For instance i'm running ubuntu 16.06 and the php output is /usr/bin/php7.0.

You need to find the running php file for cron execution. is the system live?

`#**************************$

The contents of this file are subject to the vtiger CRM Public License Versio$

("License"); You may not use this file except in compliance with the License

The Original Code is: vtiger CRM Open Source

The Initial Developer of the Original Code is vtiger.

Portions created by vtiger are Copyright (C) vtiger.

All Rights Reserved.

#

*************************$

export VTIGERCRM_ROOTDIR=dirname "$0"/..
export USE_PHP=php

export USE_PHP=/usr/local/php53/bin/php

export USE_PHP=/usr/bin/php7.0

cd $VTIGERCRM_ROOTDIR

TO RUN ALL CORN JOBS

$USE_PHP -f cron/vtigercron.php
`

[alextovey]

thats my example for /var/www/html/yetiforce/cron/vtigercron.sh

So from your output I would change this line export USE_PHP=/usr/bin/php7.0
to export USE_PHP=/usr/bin/php5

and try running it manually again and let me know.

[Raggazzoo]

I have tried to replace USE_PHP by /usr/bin/php5, reboot, and run vtigercron.sh.
It didn't change anything.

I got some errors in my php.ini...

I will try to resolve all.

[alextovey]

ah okay. so here you go. if you use nano type sudo nano /etc/php5/apache2/php.ini

then use ctrl + w to find and type display_errors hit enter and find that. if you want I can login via ssh if you pm me and i;ll sort it for you.

[Raggazzoo]

I really don't understand why this variable is set on because in my php.ini it is set off

[Raggazzoo]

It is the same for log_errors

[alextovey]

ah wrong php.ini you are editing.

[alextovey]

create a info.php and place the code in it.

`

// Show all information, defaults to INFO_ALL
phpinfo();

?>`

Then visit the url/info.php and give me a screen shot :)

[alextovey]

just need this the top bit as a screen shot

[Raggazzoo]

There it is

I made a pdf with the all configuration.
phpinfo.pdf

Thank you so much !

[alextovey]

give me this output please
php -i | grep 'Configuration File'

[mariuszkrzaczkowski]

You must change php config for cron [CLI]
http://stackoverflow.com/questions/3057110/where-can-i-find-the-php-ini-for-php-cli

[alextovey]

its already set, he's having issues with the php.ini

[Raggazzoo]

Sorry I went to lunch =)
There it is the output of php -i | grep 'Configuration File'

[alextovey]

Okay can you send me the php.ini file in that path and i'll alter it for you and send back. the INNODB function wont change as mysql never let's it change now it is stuck at 50. @Raggazzoo

[Raggazzoo]

Okay there is the php.ini from /etc/php5/cli
php.ini.txt

Thank's =)

[alextovey]

@Raggazzoo give me an hour as got to pop out now but will be back in 45 mins.

[alextovey]

try this.
php.ini.txt

[Raggazzoo]

Thank you so much I try this

[Raggazzoo]

It is OK when I manually launch the script but not in Yetiforce

[alextovey]

make sure your sql table is not strict

[Raggazzoo]

I added sql_mode="" at the end of my.cnf and reboot the server but this is not very effective...

The php.ini isn't loaded in Yetiforce conf.

[alextovey]

is this a fresh install of yetiforce?

[Raggazzoo]

No, I installed a 3.2.90 at first, then I update it to 3.4.21

The issue seems to appear after the 3.4.21

[alextovey]

We do resell VPS Servers for Yetiforce. is it a production or live server?

[Raggazzoo]

This is the production server that's why I'm worried =(

[alextovey]

oh :S right. What os you running for it @Raggazzoo

[nic86]

check hidden file .htaccess in the yeti root directory

[alextovey]

its the php.ini file @nic86 its not reading it correctly.

[nic86]

the htaccess can overwrite directive in php.ini

[alextovey]

@Raggazzoo post your .htaccess file up then we'll take a look

[nic86]

yeti htacces

uncomment this line:

#php_value  max_execution_time          600
#php_value  max_input_time              600

[nic86]

and add
php_flag mbstring.func_overload off

[Raggazzoo]

Okay I will try that.

Thank you

[nic86]

to enable the htaccess, from apache doc:
https://httpd.apache.org/docs/2.4/howto/htaccess.html

add this directive to your apache conf or virtual host conf

<Directory "/www/htdocs">
    AllowOverride All
</Directory>

"/www/htdocs" = your yeti root

and reload apache service

[Raggazzoo]

I have edit the .htacces, it's OK for display_errors and log_errors but not for mbstring.func_overload.

I have already add the AllowOverride

[nic86]

the page: Software configuration > Logs > Server configuration > Start

validate the values from /etc/php5/apache/php.ini and all overwrite from htacces for the web request

This page has nothing to do with cron and /etc/php5/cli/php.ini

[Raggazzoo]

There is my php.ini from /etc/php5/apache2
php.ini.txt

What do you mean by All Overwrite from htaccess, all .htacces of Yetiforce in each folder?

[nic86]

What do you mean by All Overwrite from htaccess, all .htacces of Yetiforce in each folder?

yes, in root folder and each subfolder.
https://httpd.apache.org/docs/2.4/mod/core.html#allowoverride

you can set innodb_look_wait_timeout without restart mysql or write the directive in my.cnf and restart mysql

http://stackoverflow.com/questions/28735473/innodb-lock-wait-timeout-increase-timeout

http://www.paulbooker.co.uk/drupal-developer/command-lines/increasing-lock-wait-timeout-value-mysql-innodb-database

[nic86]

for func_overload directive try:

php_value mbstring.func_overload 0

[alextovey]

See i wouldn't use .htacccess to run it. I would run all from php.ini file as the server becomes unstable when overloading the .htaccess file. But Not my best subject is the .htaccess.

Hope fully nic can talk you through it.

[Raggazzoo]

When I try to setup the innodb_lock_wait_timeout it returns NULL

I set the php_value mbstring.func_overload to 0 and restart apache but nothing change in Yetiforce.

[alextovey]

From 5.6 onwards for mysql it's locked you can only set the session timeout but have to enable the module first in order to see it.

[Raggazzoo]

Thank you so much Alex, I'm so grateful of you help =)

[Raggazzoo]

Ok everything is fine in my Server Configuration page aside mbstring.func_overload

[nic86]

See i wouldn't use .htacccess to run it. I would run all from php.ini file as the server becomes unstable when overloading the .htaccess file. But Not my best subject is the .htaccess.

you can disable .htaccess and set all directive in php.ini

<Directory "/www/htdocs">
    AllowOverride None
</Directory>

probably .htaccess slow the server, but from my experience I have not yet noticed them

Ok everything is fine in my Server Configuration page aside mbstring.func_overload

see this htaccess

[Raggazzoo]

As you asked @nic86, there is each .htacces file part1
htacces_files.zip

[Raggazzoo]

Do you need all of these?

[nic86]

Do you need all of these?

i think so

http://httpd.apache.org/docs/2.4/howto/htaccess.html You should avoid using .htaccess files completely if you have access to httpd main server config file. Using .htaccess files slows down your Apache http server. Any directive that you can include in a .htaccess file is better set in a Directory block, as it will have the same effect with better performance.

if you have access to apache server you can rewrite all htaccess into many equal directory block in the virtual host configuration, otherwise you keep active .htaccess

[Raggazzoo]

Ok I'm lost... Sorry..

[mariuszkrzaczkowski]

we just updated the requirements https://yetiforce.com/en/implementer/installation-updates/103-web-server-requirements.html

[Raggazzoo]

I installed the 3.4.1427 and it's OK thank's for everything