Re: [PHP-DB] Corn job anomaly
[email protected] (Karl DeSaulniers) Tue, 20 Sep 2016 03:19:55 -0500
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
> On Sep 20, 2016, at 3:14 AM, Karl DeSaulniers <[email protected]> = wrote: >=20 >> On Sep 20, 2016, at 3:06 AM, Lester Caine <[email protected]> wrote: >>=20 >> 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. >>>=20 >>> Is there supposed to be a call or directive to load mysql in my = command line as well? >>> Man this is frustrating. >>=20 >> 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. >>=20 >> --=20 >> Lester Caine - G8HFL >> ----------------------------- >=20 >=20 > Pardon my ignorance, but what do you mean full path? > Full path of the host name? >=20 > Best, >=20 > 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