Re: [PHP-DB] Corn job anomaly

> On Sep 27, 2016, at 2:24 AM, Ford, Mike <m.f...@leedsbeckett.ac.uk> wrote: > >> -Original Message- >> From: Karl DeSaulniers [mailto:k...@designdrumm.com] >> Sent: 25 September 2016 09:59 >> To: PHP List Database <php-db@lists.php.net>

RE: [PHP-DB] Corn job anomaly

> -Original Message- > From: Karl DeSaulniers [mailto:k...@designdrumm.com] > Sent: 25 September 2016 09:59 > To: PHP List Database <php-db@lists.php.net> > Subject: Re: [PHP-DB] Corn job anomaly > > Now I am getting an error with mysql syntax. > > "

Re: [PHP-DB] Corn job anomaly

ard > <inbound-lists-...@listmail.innovate.net> wrote: > > > >> Date: Sunday, September 25, 2016 08:37:14 -0400 >> From: Aziz Saleh <azizsa...@gmail.com> >> Subject: Re: [PHP-DB] Corn job anomaly >> >> On Sun, Sep 25, 2016 at 4:59 AM, Karl DeS

Re: [PHP-DB] Corn job anomaly

> Date: Sunday, September 25, 2016 08:37:14 -0400 > From: Aziz Saleh <azizsa...@gmail.com> > Subject: Re: [PHP-DB] Corn job anomaly > > On Sun, Sep 25, 2016 at 4:59 AM, Karl DeSaulniers > <k...@designdrumm.com> wrote: > >> > On Sep 23, 2016, at

Re: [PHP-DB] Corn job anomaly

On Sun, Sep 25, 2016 at 4:59 AM, Karl DeSaulniers wrote: > > On Sep 23, 2016, at 5:38 AM, Richard innovate.net> wrote: > > > > > > > >> Date: Friday, September 23, 2016 03:28:47 -0500 > >> From: Karl DeSaulniers > >> >

Re: [PHP-DB] Corn job anomaly

> On Sep 23, 2016, at 5:38 AM, Richard > wrote: > > > >> Date: Friday, September 23, 2016 03:28:47 -0500 >> From: Karl DeSaulniers >> >> Ok, so I have run down all the possible things (that I know of) >> that could be keeping

Re: [PHP-DB] Corn job anomaly

> Date: Friday, September 23, 2016 03:28:47 -0500 > From: Karl DeSaulniers > > Ok, so I have run down all the possible things (that I know of) > that could be keeping this from working. I have checked with my > hosting service that: > > 1. MySQL is accessible with the

Re: [PHP-DB] Corn job anomaly

Ok, so I have run down all the possible things (that I know of) that could be keeping this from working. I have checked with my hosting service that: 1. MySQL is accessible with the original user I started with (for this case were using db123456) via ssh. 2. The cron is accessing my php script

Re: [PHP-DB] Corn job anomaly

> 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 > >

Re: [PHP-DB] Corn job anomaly

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

Re: [PHP-DB] Corn job anomaly

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

Re: [PHP-DB] Corn job anomaly

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

Re: [PHP-DB] Corn job anomaly

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

Re: [PHP-DB] Corn job anomaly

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

Re: [PHP-DB] Corn job anomaly

> 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

Re: [PHP-DB] Corn job anomaly

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

Re: [PHP-DB] Corn job anomaly

> 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

Re: [PHP-DB] Corn job anomaly

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] Corn job anomaly

> 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

Re: [PHP-DB] Corn job anomaly

> 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

Re: [PHP-DB] Corn job anomaly

> 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

Re: [PHP-DB] Corn job anomaly

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

Re: [PHP-DB] Corn job anomaly

> 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 >>> >>>

Re: [PHP-DB] Corn job anomaly

> 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 up a

Re: [PHP-DB] Corn job anomaly

> 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 up a cron job to run a php file. > I am getting a strange error though. > > /home/(protected