> Date: Tuesday, September 20, 2016 03:26:39 -0500 > From: Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> > >> On Sep 20, 2016, at 3:22 AM, Lester Caine <lester@xxxxxxxxxxx> >> wrote: >> >> 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: crontab -e 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
