 | Cron Jobs?? |  |
 Posted: 04/06/2007 7:46 AM |
 |
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Nov 01, 2006
Local time: 5:39 AM
Location: Denver, PA
|
|
|
|
|
 |
Hello Nightrider!!
Are you familiar with Cron Jobs?? I have done a ton of googling and reading up on cron jobs in an attempt to get one set up on my forums to automatically back-up the database. I am of course a newbie so I tried to use one that was already put together and I must have missed something somewhere.
I have attached the file I am trying to use (perhaps I should just try a different one?)
I have it set up to run once a day at 3am I think. This is what I get in my email.
I get an email from my server company with the following
| Code:
|
begin 644 ./etc/MySQL.sql.gz.UU
4'XL(``/^%48``P,`````````````
`
end
|
Then I get an email from Cron Daemon that says the following
| Code:
|
mysqldump: Got error: 1045: Access denied for user 'user'@'localhost'
(using password: YES) when trying to connect
|
The reason why it says passowrd as "YES" was because I was playing around with it and trying to get it to work. I figured the error states it's a user error, I created a new user and password to see if that would help and it didn't.
This is just too over my head, I don't know what to do next.  |
|
|
|
|
| Back to Top |
|
|
| Re: Cron Jobs?? | |
| Posted: 04/06/2007 8:00 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 5:39 AM
Location: St Pete, FL
|
|
|
|
|
|
Yes, we use Cron jobs to import all of the news into our Newsgroup forums. I have it pull news every 4 hours...
Can you set up the Cron job in your Host CPanel? That would probably be the easiest...
 |
|
|
|
|
| Back to Top |
|
|
| Re: Cron Jobs?? | |
| Posted: 04/06/2007 8:50 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 5:39 AM
Location: Denver, PA
|
|
|
|
|
|
I am assuming I can do that. The cpanel is where I set it up to run once a day. Here are a couple screen shots of the cron jobs area in my cpanel.
Could it just be the .sh file? I really don't know if I did everything right, maybe I should just start over. |
|
|
|
|
| Back to Top |
|
|
| Re: Cron Jobs?? | |
| Posted: 04/06/2007 8:58 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:39 AM
Location: St Pete, FL
|
|
|
|
|
|
The sh file is just a shell file that may or may not run on your host server. For security, sh files may be blocked. Do you have a php file that you can call? That path looks like it could be a problem too. Do you have access to the host's etc folder???
|
|
|
|
|
| Back to Top |
|
|
| Re: Cron Jobs?? | |
| Posted: 04/06/2007 9:10 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 5:39 AM
Location: Denver, PA
|
|
|
|
|
|
I was just following the directions from where ever I got that .sh file from. It told me to put it in the ect folder for security reasons. I don't have any .php files for a cron job, do you know where I can find one?? I have googled and read but there is just so much info out there about cron jobs I get all discombobulated. 
That must be the problem, I can't chmode any of my files to 777 so I doubt I would be able to use an .sh file if that is sometimes blocked. |
|
|
|
|
| Back to Top |
|
|
| Re: Cron Jobs?? | |
| Posted: 04/06/2007 9:23 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:39 AM
Location: St Pete, FL
|
|
|
|
|
|
No, you don't need to find a CRON file. You need to find the utility file that actually does all the work. To launch our Newsfeeds, I run the news_insert.php file that came with the MOD. I can run it manually or allow CRON to run it automatically for me...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
