Export Cron Job Reporting Access Denied

Thanks Mike, still no luck unfortunately. I think I need to figure out authentication with wget, although I have tried

I'll see if the VDM guys have any suggestions here.

Chris.

Verulam Webmaster wrote: /usr/bin/wget -O /var/sites/v/verulamcc.org.uk/public_html/Reports/Server/Members_Emails.csv -o /var/sites/v/verulamcc.org.uk/public_html/Reports/Server/log.txt www.verulamcc.org.uk/index.php?option=co...t&type=VCC_ComExport

I think you need to use quotes around the entire URL in this case:

/usr/bin/wget -O /var/sites/v/verulamcc.org.uk/public_html/Reports/Server/Members_Emails.csv -o /var/sites/v/verulamcc.org.uk/public_html/Reports/Server/log.txt " www.verulamcc.org.uk/index.php?option=co...t&type=VCC_ComExport "

At least this worked for me...

Danish,

I'm getting the login page of my site as the output of my cron job, I've tried all the wget authentication I can google but I'm not winning (post-data save-data loadcookies... etc.)

I can see that the path I define in vData job config is not actually used, but the cron job output is. Is this the right approach?

/usr/bin/wget -O /var/sites/v/verulamcc.org.uk/public_html/Reports/Server/Members_Emails.csv -o /var/sites/v/verulamcc.org.uk/public_html/Reports/Server/log.txt www.verulamcc.org.uk/index.php?option=co...t&type=VCC_ComExport


Thanks, Chris.

Chris,

Thank you for your input - that was all I needed to move forward. I've successfully created a cron job to execute the vData export that I was trying to run.

Regards,
Mike

Hi Michael,

I'm a newbie myself, but when I got that error it was that the bash script that my provider 'VISAHOST' created, perhaps the response can help you too. I marked this as fixed when my issue was resolved so you might need open a new ticket for a response from the WDM guys.

The reason was due to the lines I was calling the URL with:

/usr/bin/wget -O /dev/null -o /dev/null

The following combined with a wget command till do:

-O write documents to FILE.
-o log messages to FILE

The cron is set up to run each of this tasks to the /dev/null directory, this directory is used to ignore all output written in it and as such you end up with an output of only the number of processes run from the query, or an error. Update these locations to where you want the file to go.

Chris

How do I submit the cron job. I know how to do this in general via my Cpanel cron control panel but using the URL link generated on my cron job produces a "file not found" error when the cron job attempts to run?

Am I missing something here?

I understand now, thanks.

Hi,
You can not execute Cron Job URL manually, It would work only when Cron Job on your server would trigger it.

Hi,

I have set up a Cron Jon link to run a SQl query and store the resulting CSV file on the local server. The SQL works OK (as a quick export) but when I use the URL I get this message:

{"result":"error", "error":"ACCESS_DENIED"}

I assume that it's when the CSV is trying to be written to the local server, but not sure by what user or what permissions are required.

Any ideas?

Thanks, Chris.