The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

cron jobs not working

Discussion in 'General Discussion' started by InsaneSquirrel, Dec 15, 2006.

  1. InsaneSquirrel

    InsaneSquirrel Registered

    Joined:
    Dec 11, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi! I have a problem. The first being I know very little about cPanel operation and the 2nd being my coder guy is nowhere to be found. Oh, and the 3rd is my 5 minute crons are not running. Maybe all my crons.

    I've tried changing permissions in file manager, updating where the crond sends the crons (email) and deleting the stuff in the cron manager and reinstalling them.

    This is the error that the crond keeps sending me:

    <br />
    <b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'amazhun4'@'ans04.midphase.com' (using password: YES) in <b>/home/amazhun4/public_html/crons/4/as/mysql.php</b> on line <b>3</b><br />
    Access denied for user 'amazhun4'@'ans04.midphase.com' (using password: YES)

    Any detailed help would be greatly appreciated!

    Thank you, insanesquirrel
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    That is a database access issue. The php file is trying to connect to the database
    but seems to have invalid user name and or password.
     
  3. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Your script is calling a database that either doesn't exist or the login information
    for that database (hostname, database name, login, or password) is wrong.

    I would look at the file '/home/amazhun4/public_html/crons/4/as/mysql.php'
    listed in that error message and find out what DB login parameters are being
    called and verify those to be working.

    However ...

    Looking closer at the error, I also see 'amazhun4'@'ans04.midphase.com' and
    this might actually be your problem because the script appears to be making a remote
    database connection to a database located somewhere else not on your server and
    that database server might be offline, down, or otherwise unreachable.

    I am assuming your server is not "ans04.midphase.com" because it if were then you
    would normally be using "localhost" as the hostname instead of "ans04.midphase.com"

    (Note that you can use your main Cpanel username with your database but it is not recommended
    because if you change your main account password then the database password will also
    get changed at the same and can render scripts not working such as like what you see now)
     
    #3 Spiral, Dec 15, 2006
    Last edited: Dec 15, 2006
  4. InsaneSquirrel

    InsaneSquirrel Registered

    Joined:
    Dec 11, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Thank you, Spiral. The password thing is most likely the culprit because I had to change it to prevent my site getting hijacked. Ummmm, my next question is...how do I get the new password to match up with whatever it needs to be matched up with?

    Please excuse my lack of techspeak, my boyfriend is offline for a few days and he normally handles these emergencies. I'm just a dumb blonde squirrel, lol.:p

    oh, and it's on a shared server so I don't know if I have access to the root login
     
    #4 InsaneSquirrel, Dec 15, 2006
    Last edited: Dec 15, 2006
  5. InsaneSquirrel

    InsaneSquirrel Registered

    Joined:
    Dec 11, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    :) I figured it out Spiral, thank you very much! Everything is working now. I changed the password in that file.
     
Loading...

Share This Page