Closed Thread
Results 1 to 7 of 7

Thread: MySQL not connecting

  1. #1
    rokkwarr is offline x10Hosting Member rokkwarr is an unknown quantity at this point
    Join Date
    Aug 2009
    Posts
    31

    MySQL not connecting

    http://stygianrenegade.co.cc is connecting fine however http://the-continuum.co.cc I received a alert on it timing out, when attempting to access the site, it fails and sometimes shows a SQL connection error, any reason why its doing this? They are both on the Stoli server so why one is functioning and the other is not is beyond me.

  2. #2
    Twinkie is offline Banned Twinkie is an unknown quantity at this point
    Join Date
    Sep 2007
    Location
    Ft. Lauderdale, Florida
    Posts
    1,389

    Re: MySQL not connecting

    What is the MySQL error? The site that fails is due to an error on your page, which should be reported in an error.log file (or something like that) in the directory of the page.

    The most common MySQL error is that after the server upgrade, you can no longer user the server as the host name. Instead, localhost is now required. Please verify that both scripts use localhost as the host to connect to MySQL, and post back.

  3. #3
    rokkwarr is offline x10Hosting Member rokkwarr is an unknown quantity at this point
    Join Date
    Aug 2009
    Posts
    31

    Re: MySQL not connecting

    I've actually used localhost whenever and wherever possible no matter my hosting or what I'm using, the site gives no error besides being unable to access the database while my http://stygianrenegade.co.cc which uses the same database is completely able to connect without issue. It's not a configuration issue as the site was working fine before migration.

  4. #4
    xav0989's Avatar
    xav0989 is offline Community Public Relation xav0989 is just really nice
    Join Date
    Jul 2008
    Location
    ifk
    Posts
    4,436

    Re: MySQL not connecting

    FYI, there is a problem with the .htaccess redirection on http://stygianrenegade.co.cc/ . As for http://the-continuum.co.cc/ , try to manually view and edit the config file.
    Xavier L | Community Public Relations Manager (Free Hosting Support)
    █ Yes, my position is too cool to even exist!
    How am I helping? Rate this post by clicking the icon below! (this is even better than "liking" a post)
    Terms of Service | Acceptable Use Policy | x10Hosting Wiki

  5. #5
    rokkwarr is offline x10Hosting Member rokkwarr is an unknown quantity at this point
    Join Date
    Aug 2009
    Posts
    31

    Re: MySQL not connecting

    okay.... I could of sworn that said localhost.... Perhaps it just autoset to the actual host upon install or something. Well reset to localhost and now functioning again, jeeze that was a pain in the butt but thanks for reminding me, though stygianrenegade seems to be functioning normally without issues the way it is, I could post my .htaccess file here for you to go over and point out what needs tweaked?

  6. #6
    adamparkzer is offline On Extended Leave adamparkzer is just really nice
    Join Date
    Jun 2008
    Location
    IL, USA
    Posts
    3,745

    Re: MySQL not connecting

    Quote Originally Posted by rokkwarr View Post
    okay.... I could of sworn that said localhost.... Perhaps it just autoset to the actual host upon install or something. Well reset to localhost and now functioning again, jeeze that was a pain in the butt but thanks for reminding me, though stygianrenegade seems to be functioning normally without issues the way it is, I could post my .htaccess file here for you to go over and point out what needs tweaked?
    Hi rokkwarr,

    Yes, feel free to post your .htaccess code here. You may want to include it in [code] tags so it's easier to read.

    - Adam

  7. #7
    rokkwarr is offline x10Hosting Member rokkwarr is an unknown quantity at this point
    Join Date
    Aug 2009
    Posts
    31

    Re: MySQL not connecting

    well the Stygian Renegade one is pretty cut-and-dry

    Code:
    # BEGIN WordPress
    <IfModule mod_rewrite.c>
    RewriteBase /
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    </IfModule>
    
    # END WordPress
    The-continuum.co.cc is much more complicated,
    Code:
    # PRETTYURLS MOD BEGINS
    # Pretty URLs mod
    # http://code.google.com/p/prettyurls/
    # .htaccess file generated automatically on: January 28, 2010, 13:08
    
    RewriteEngine on
    RewriteBase /
    
    # Rules for: yagam
    RewriteRule ^announcements/([^/]+)/?$ ./index.php?action=announcements;aid=$1 [L,QSA]
    
    # Rules for: profiles
    RewriteRule ^profile/([^/]+)/?$ ./index.php?pretty;action=profile;user=$1 [L,QSA]
    
    # Rules for: actions
    RewriteRule ^(activate|admin|announcements|announcement|attachapprove|buddy|buddypage|calendar)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(clock|collapse|comment|coppa|credits|deletemsg|display|dlattach)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(editpoll|editpoll2|emailuser|findmember|forum|portal|groups|help)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(globalhf|helpadmin|im|jseditor|jsmodify|jsoption|lock|lockvoting)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(login|login2|logout|markasread|mergetopics|media|mgallery|mlist)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(moderate|modifycat|modifykarma|movetopic|movetopic2|notify|notifyboard|openidreturn)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(pm|post|post2|printpage|profile|quotefast|quickmod|quickmod2)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(recent|register|register2|reminder|removepoll|removetopic2|reporttm|requestmembers)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(restoretopic|savepad|search|search2|sendtopic|smstats|suggest|spellcheck)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(splittopics|stats|sticky|switchsubaccount|staff|theme|trackip|about:mozilla)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(about:unknown|unread|unreadreplies|verificationcode|viewprofile|vote|viewquery|viewsmfile)/?$ ./index.php?pretty;action=$1 [L,QSA]
    RewriteRule ^(who|\.xml|xmlhttp)/?$ ./index.php?pretty;action=$1 [L,QSA]
    
    # Rules for: boards
    RewriteRule ^([-_!~*'()$a-zA-Z0-9]+)/?$ ./index.php?pretty;board=$1.0 [L,QSA]
    RewriteRule ^([-_!~*'()$a-zA-Z0-9]+)/([0-9]*)/?$ ./index.php?pretty;board=$1.$2 [L,QSA]
    
    # Rules for: topics
    RewriteRule ^([-_!~*'()$a-zA-Z0-9]+)/([-_!~*'()$a-zA-Z0-9]+)/?$ ./index.php?pretty;board=$1;topic=$2.0 [L,QSA]
    RewriteRule ^([-_!~*'()$a-zA-Z0-9]+)/([-_!~*'()$a-zA-Z0-9]+)/([0-9]*|msg[0-9]*|new)/?$ ./index.php?pretty;board=$1;topic=$2.$3 [L,QSA]
    
    # PRETTYURLS MOD ENDS

Closed Thread

Similar Threads

  1. [PHP] MySQL and PHP
    By Bryon in forum Tutorials
    Replies: 43
    Last Post: 03-24-2011, 07:27 AM
  2. Connecting local mysql client to mysql database
    By nadunalexander in forum Free Hosting
    Replies: 4
    Last Post: 01-01-2010, 04:24 PM
  3. Connecting Mysql
    By ReDeR in forum Free Hosting
    Replies: 1
    Last Post: 05-08-2009, 01:24 PM
  4. Replies: 14
    Last Post: 09-29-2008, 07:07 PM
  5. New Site-Suggestions?
    By mnoutside in forum Review My Site
    Replies: 9
    Last Post: 08-27-2008, 07:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers