> Date: Tuesday, September 20, 2016 03:26:39 -0500
> From: Karl DeSaulniers <k...@designdrumm.com>
>> On Sep 20, 2016, at 3:22 AM, Lester Caine <les...@lsces.co.uk>
>> On 20/09/16 09:14, Karl DeSaulniers wrote:
>>> Pardon my ignorance, but what do you mean full path?
>> Full path to php application.
>> Cron jobs run as 'root' and so need and user account settings added
>> manually if they do not match the 'root' environment.
> OH, ok, I did read something about root earlier.
> I think it was something like:
> root /usr/bin/php5 /home/(directory name removed)/auto_reminder.php
> But not positive. I will have to research that more.
> Thank you.
Whether cron jobs run as root or a standard user depends on how they
are set up. If set up under a user -- which is the better approach
for general use -- they will run as that user. Really only
system-type cron jobs (that require root access) should be set up to
run as root.
If you use the command:
from a user account, then the crontab is set up as that user. The
first 5 fields/values are time/date related, followed by the command
to be invoked. See: man -s5 crontab for more details.
In that case, the user that mysql sees is the user that is running
the job. So, if your mysql authentication is set to accept
connections/give access to say the user your web server is running as
(which is how php will show by default), then you will either need to
pass those credentials in your cron job php script or, give the user
that's running the cron job access.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php