Need help on MySource + Oracle Installation

Squiz Matrix Installation
21

[quote]That script looks for Matrix scheduled task and runs them. It always returns without content. The fact that it doesn’t fail immediately or with an error makes me think it is working.


When you insert a record into your crontab, you don’t have all the same environment variables, like PATH. Maybe when php is run as cron, is running a different (bundled?) version.



Try running “which php” and putting the full path to php (e.g., /usr/bin/php) into cron instead of just the php alias.[/quote]



*/15 * * * * [color="#0000FF"]/usr/local/bin/php /mysource/mysource_matrix/core/cron/run.php



With the full path of PHP, it seems working finally!!!

Though getting other errors in cron_errors.log, it does seems working. At least no DB extension not found.



[indent]The cron manager for the system “The System” has attempted to run 3 times, but has not been able to for one of two reasons:

  1. An existing cron manager is currently running an extremely long running job.
  2. Something has caused the cron manager to exit uncleanly and the lock wasn't able to be removed.



    Check the cron error log (in /mysource/mysource_matrix/data/private/logs/cron_errors.log) for any information.[/indent]



    Thanks Greg, you save me from another day of troubleshooting on the run.php.



    Now I can move on to another error :slight_smile:
22

Go to the Running Status screen of the Cron Manager asset (under the System Management folder in the admin interface) and clear the deadlock. You'll need to enter a very long security key to remind you this should never need to be done :wink:


It probably deadlocked because of your previous errors and just needs to be manually cleared.

23

[quote]Go to the Running Status screen of the Cron Manager asset (under the System Management folder in the admin interface) and clear the deadlock. You'll need to enter a very long security key to remind you this should never need to be done :wink:


It probably deadlocked because of your previous errors and just needs to be manually cleared.[/quote]



Hi Greg,



Thanks again for the instruction.



I tried to acquire lock in the Running Status Screen, but it keeps showing this in the next screen and there is not any field or button that I can use to clear the deadlock.



MySource Warning

A HIPO Job with this code name is currently run by "Root User" (Id: #12)

. last updated at 22/11/2008 19:51:39 [HIPO0041]



At the moment, I am asking my colleague to check who created this job and what is it.



Thanks again for the help.



Joe

24

I have just deleted the HIPO job and clear the Deadlock.
No more warning deadlock email, it looks much better.



Thanks again for everyone :slight_smile:



Joe