Re: Corn job anomaly
| From: | B. Aerts | Date: | Tue, 20 Sep 2016 19:50:13 +0000 |
| Subject: | Re: Corn job anomaly | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-49136@lists.php.net to get a copy of this message | ||
On 20/09/16 10:06, Lester Caine wrote:
On 20/09/16 06:16, Karl DeSaulniers wrote:Karl, is your MySQL database located on the machine itsself where you run the Cron job ? If so, does your Cron user have read/write/execute permissions on either the DB directory, and the DB itsself ? Regards, BertWas probably a newb question, however, now it is saying that my database user is not allowed access. I have a mysql connection inside my script that reads the database to get user email addresses to send a reminder email to. Is there supposed to be a call or directive to load mysql in my command line as well? Man this is frustrating.The user name and password you are using from the web scripts SHOULD work in the script you are using on the cron job. Although mysql does seem to have a few extra security features that cut in. Are they listed in the script, or loaded from the environment ... which is of cause different for the cron jobs ... and why you needed the full path.