Re: Corn job anomaly
| From: | Karl DeSaulniers | Date: | Tue, 20 Sep 2016 08:19:55 +0000 |
| Subject: | Re: Corn job anomaly | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-49127@lists.php.net to get a copy of this message | ||
> On Sep 20, 2016, at 3:14 AM, Karl DeSaulniers <karl@designdrumm.com> wrote:
>
>> On Sep 20, 2016, at 3:06 AM, Lester Caine <lester@lsces.co.uk> wrote:
>>
>> On 20/09/16 06:16, Karl DeSaulniers wrote:
>>> Was 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.
>>
>> --
>> Lester Caine - G8HFL
>> -----------------------------
>
>
> Pardon my ignorance, but what do you mean full path?
> Full path of the host name?
>
> Best,
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
The command line I am using is as follows.
/usr/bin/php5 /home/(directory name removed)/auto_reminder.php
The time stamps (minute, hour, day, etc) that precede the /usr are loaded by my host. just fyi.
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com