Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 12:16 AM, Karl DeSaulniers wrote: > >> On Sep 19, 2016, at 6:14 AM, Richard >> wrote: >> >> >> >>> Date: Monday, September 19, 2016 03:26:54 -0500 >>> From: Karl DeSaulniers >>> >>> I am hoping someone can enlighten me on this issue I am having. >>> I am trying to set

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Lester Caine
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 suppose

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:06 AM, Lester Caine 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 emai

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:06 AM, Lester Caine 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

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:14 AM, Karl DeSaulniers wrote: > >> On Sep 20, 2016, at 3:06 AM, Lester Caine 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 connecti

Re: [PHP-DB] Cron job anomaly

2016-09-20 Thread Lester Caine
On 20/09/16 09:10, Karl DeSaulniers wrote: > Hi Lester, > They are listed inside the php file. > > The error message I get is: > > Access denied for user '(user name removed)'@'%' to database '(database name > removed)' > > Thanks for your response. Need a mysql guy to deal with that ;) I have

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Lester Caine
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. -- Lester Caine - G8HFL ---

Re: [PHP-DB] Cron job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:20 AM, Lester Caine wrote: > > On 20/09/16 09:10, Karl DeSaulniers wrote: >> Hi Lester, >> They are listed inside the php file. >> >> The error message I get is: >> >> Access denied for user '(user name removed)'@'%' to database '(database name >> removed)' >> >> Than

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:22 AM, Lester Caine 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

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Lester Caine
On 20/09/16 09:19, Karl DeSaulniers wrote: > The command line I am using is as follows. > > /usr/bin/php5 /home/(directory name removed)/auto_reminder.php Which runs when entered on YOUR command line, but fails in the cron job? Something in auto_reminder.php needs replacing with the 'full' text a

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Richard
> Date: Tuesday, September 20, 2016 03:26:39 -0500 > From: Karl DeSaulniers > >> On Sep 20, 2016, at 3:22 AM, Lester Caine >> 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 'r

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
On Sep 20, 2016, at 7:21 AM, Richard wrote: > > > >> Date: Tuesday, September 20, 2016 03:26:39 -0500 >> From: Karl DeSaulniers >> >>> On Sep 20, 2016, at 3:22 AM, Lester Caine >>> wrote: >>> On 20/09/16 09:14, Karl DeSaulniers wrote: Pardon my ignorance, but what do you mean ful

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Richard
Original Message > Date: Tuesday, September 20, 2016 12:54:38 -0500 > From: Karl DeSaulniers > > On Sep 20, 2016, at 7:21 AM, Richard > wrote: >> >> >> >>> Date: Tuesday, September 20, 2016 03:26:39 -0500 >>> From: Karl DeSaulniers >>> On Sep 20, 2016, at 3:2

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread B. Aerts
On 20/09/16 10:06, Lester Caine 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 remind

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
Hi Richard & Bert, Thanks for the responses. I think I understand what you are both saying. Not sure where my database is housed as I am using a hosting provider (Mediatemple) and they allow limited access to such things or I am unaware how to access them. For my current issue, lets just say my

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Peter Beckman
I suspect you are taking the pipe or semicolon literally. Drop the pipe and semicolon entirely. This should work: /usr/bin/php5 -c /home/123456/etc/php.ini -f /home/123456/data/auto_reminder.php The "pipe" (|) in unix (and I assume this is unix) means to pipe the output of php5 -c config t

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 10:09 PM, Peter Beckman wrote: > > I suspect you are taking the pipe or semicolon literally. > > Drop the pipe and semicolon entirely. This should work: > >/usr/bin/php5 -c /home/123456/etc/php.ini -f > /home/123456/data/auto_reminder.php > > The "pipe" (|) in unix