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.

sudden mysql issues

Discussion in 'General Discussion' started by Secret Agent, May 10, 2005.

  1. Secret Agent

    Secret Agent Guest

    Suddenly, out of nowhere mysql issues with some but not all databaes on the server (or perhaps so far not all)

    Some errors:

    phpBB : Critical Error

    Could not connect to the database

    ---

    Warning: mysql_connect(): Access denied for user 'saxon1_osc1'@'localhost' (using password: YES) in /home/saxon1/public_html/includes/functions/database.php on line 19
    Unable to connect to database server!

    --

    I've taken the following steps (checked results each step and went to the next if no resolution found)

    Restarted mysql via whm (ok)
    Reset root mysql pw
    reset local mysql pw
    /scripts/fixmysql
    /scripts/fixmysqlquota
    /scripts/mysqlup --force


    Still getting the same errors. Could someone suggest anything else? /var/log/messages doesn't say much, as there is no particular error in mysql itself anyway.

    The domain logs shows this for example:

    Code:
    xx.x49.64.77 - - [09/May/2005:22:01:41 -0700] "GET /purchase HTTP/1.0" 301 245 "-" "Googlebot/2.1 (+http://www.google.com/bot.html)"
    xx.x49.64.47 - - [09/May/2005:22:52:36 -0700] "GET /robots.txt HTTP/1.0" 404 - "-" "Googlebot/2.1 (+http://www.google.com/bot.html)"
    xx.x49.64.47 - - [09/May/2005:22:52:37 -0700] "GET /purchase/ HTTP/1.0" 200 105 "-" "Googlebot/2.1 (+http://www.google.com/bot.html)"
    xx.xx.188.141 - - [10/May/2005:01:07:29 -0700] "GET /purchase HTTP/1.0" 301 245 "-" "msnbot/1.0 (+http://search.msn.com/msnbot.htm)"
    xx.x78.0.13 - - [10/May/2005:02:47:36 -0700] "GET / HTTP/1.1" 200 1164 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.x78.0.13 - - [10/May/2005:02:48:02 -0700] "GET /purchase HTTP/1.1" 301 257 "http://www.thedomain.com/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.x78.0.13 - - [10/May/2005:02:48:03 -0700] "GET /purchase/ HTTP/1.1" 200 117 "http://www.thedomain.com/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xxx.237.238.177 - - [10/May/2005:02:49:23 -0700] "GET /purchase/viewtopic.php?p=854 HTTP/1.0" 200 105 "-" "ia_archiver"
    xx.x78.0.13 - - [10/May/2005:02:51:22 -0700] "GET /purchase HTTP/1.1" 301 257 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.x78.0.13 - - [10/May/2005:02:51:22 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:02:51:37 -0700] "GET /purchase HTTP/1.1" 301 257 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:02:51:38 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:10:34 -0700] "GET /purchase HTTP/1.1" 301 257 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:10:34 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:18:13 -0700] "GET /purchase HTTP/1.1" 301 257 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:18:13 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:19:38 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:19:40 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:21:13 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.19.104 - - [10/May/2005:03:21:14 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
    xx.xx5.138.222 - - [10/May/2005:04:20:52 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    xx.xx5.138.222 - - [10/May/2005:04:20:52 -0700] "GET /favicon.ico HTTP/1.1" 404 - "-" "Avant Browser (http://www.avantbrowser.com)"
    xx.xx.188.141 - - [10/May/2005:07:24:54 -0700] "GET /robots.txt HTTP/1.0" 404 - "-" "msnbot/1.0 (+http://search.msn.com/msnbot.htm)"
    xx.xx.188.141 - - [10/May/2005:07:24:57 -0700] "GET /purchase HTTP/1.0" 301 245 "-" "msnbot/1.0 (+http://search.msn.com/msnbot.htm)"
    xx.xx5.138.222 - - [10/May/2005:09:36:25 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    xx.xx5.138.222 - - [10/May/2005:09:36:26 -0700] "GET /favicon.ico HTTP/1.1" 404 - "-" "Avant Browser (http://www.avantbrowser.com)"
    xx.xx5.138.222 - - [10/May/2005:09:40:42 -0700] "GET /purchase/ HTTP/1.1" 200 117 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    xx.xx5.138.222 - - [10/May/2005:09:40:42 -0700] "GET /favicon.ico HTTP/1.1" 404 - "-" "Avant Browser (http://www.avantbrowser.com)"
    

    Could this possibly be nothing more than a client's mishap with configuration?
     
  2. challii

    challii Well-Known Member

    Joined:
    Feb 3, 2004
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    looks like a password issue... try getting them to reset the password for the forum (add a new user to the forum) and then dont forget to change the config file.
     
Loading...

Share This Page