Announcement

Collapse
No announcement yet.

Database Error - Can't connect to local MySQL server through socket.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Database Error - Can't connect to local MySQL server through socket.

    Okay. Here's the low-down - My forum has been on hiatus for around 3 weeks or so. I haven't changed any mods, added any new mods or changed any settings - re-opening, I'm now getting these errors and it's driving me crazy.

    Code:
    Database error in vBulletin :
    
    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/tmp/mysql5.sock' (111)
    /homepages/29/d355849155/htdocs/discussion/includes/class_core.php on line 314
    
    MySQL Error   :
    Error Number  :
    Request Date  : Sunday, April 17th 2011 @ 04:58:52 AM
    Error Date    : Sunday, April 17th 2011 @ 04:58:52 AM
    Script        : http://www.xx.com/discussion/external.php?type=RSS2&forumids=2
    Referrer      :
    IP Address    : 82.245.125.153
    Username      :
    Classname     : vB_Database
    MySQL Version :
    Code:
    Database error in vBulletin :
    
    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/tmp/mysql5.sock' (111)
    /homepages/29/d355849155/htdocs/discussion/includes/class_core.php on line 314
    
    MySQL Error   :
    Error Number  :
    Request Date  : Sunday, April 17th 2011 @ 04:58:52 AM
    Error Date    : Sunday, April 17th 2011 @ 04:58:52 AM
    Script        : http://www.xx.com/discussion/forumdisplay.php?49-Smooth-Criminal/page3&order=desc
    Referrer      :
    IP Address    : 66.249.71.112
    Username      :
    Classname     : vB_Database
    MySQL Version :
    As you can see, it seems to be just about any script that it errors on. I have about 60 odd emails just through the night with different errors.

    I run vBulletin on a 1and1 managed server. I followed the instructions on here;

    http://www.vbulletin.org/forum/showthread.php?t=206682

    Scroll to the very bottom;

    1) I run PhP as a module.

    2) I change the follow lines on config.php to be like this:
    $config['MasterServer']['servername'] = 'localhost';
    $config['MasterServer']['port'] = '/tmp/mysql5.sock';

    3) I add the follow lines on the .htaccess on the vb4.x directory:

    php_value mysql.default_socket "/tmp/mysql5.sock"
    AddType x-mapp-php5 .php
    I hope someone can help.

    Best,

    Greg

  • #2
    Please see this page for reasons of why you cannot connect:

    http://www.vbulletin.com/docs/html/cantconnect
    Shamil Nunhuck, - Radon Systems Ltd.
    VPS + Dedicated Server Hosting and Management
    vBulletin Hosting and Services
    Server / Website Consultation

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X