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