Blue domino fixed everything!
keywords: /tmp/mysql.sock config.php Blue Domino database cannot connect permissions
Well I am completely satified with my web host Blue Domino. I have a fully tested and working solution that they provided and I have entered it below.
But first I wanted to say that they like many sites tell customers before hand that mysql is not supported outside of myadmin connectivity.
They went above and beyond the call of duty to get this going. I talked with the senior admin on the telephone about the problem, and yes they arranged this. They spent a good hour or two with me.
I represent 7 sites with them, and I have volunteered to use my own personal business site as their test bed for vbulletin issues.
They went in and debugged the vbulletin install. I just watched. They repeated the steps again and again to make sure it would work for you people (and me). I am now ordering two more web sites from them for my customers.
That said, here is the solution, hopefully someone will post it in a faq for me please. There are perhaps 11 other threads about this and I don't want to spam this professional board by answering all of those threads... someone please help me with this? thanks.
Todd B. Aubin
President
GoodKnight Productions
Problem:
vbulletin cannot connect via /tmp/mysql.sock on some web sites that use a secure socket file. The message You do not have permission to access the database or database not found is displayed. Many threads here were answered with attempts to check for accounts and permissions. not so.
Solution:
This will work with or without a clean install of vbulletin. If you have already installed vbulletin you do not need to reinstall, but you must insure that you have undone anything you did while testing various suggestions at work arounds.
Here is what was given to me by Blue Domino:
When you first upload, edit the admin/config.php file and change the
dbusername to 'root', dbpassword to your password, and technicalemail to
your e-mail address.
THEN THIS ACTUALLY MAKES IT WORK:
$servername="localhost:/path/to/mysql.sock";
It's that easy.
If you want to let the guys over on the vbulletin forums know that all
that needs to change for it to work is the $servername variable has to
have the servername followed by a ':' and then the path to the socket.
(taubin adding this part)
That was their final write up. Now here is a real world example that I am putting here because I love examples and perhaps you do too:
Here is my config.php file with some dummied values. I did this on 3 walkthroughs from scratch and it worked everytime.
You DO NOT need to create the vbulletin database, vbulletin install will do it. If you have one already, just DROP it.
<?php
/////////////////////////////////////////////////////////////
// Please note that if you get any errors when connecting, //
// that you will need to email your host as we cannot tell //
// you what your specific values are supposed to be //
/////////////////////////////////////////////////////////////
// type of database running
// (only mysql is supported at the moment)
$dbservertype="mysql";
// hostname or ip of server
//$servername="localhost";
$servername="localhost:/home/bdwebxxxx/yourweb.com/.database/mysql/mysql.sock";
// username and password to log onto db server
$dbusername="root";
$dbpassword="password"; // <-- password from your bluedomino admin
// name of database
$dbname="vbulletin";
// technical email address - any error messages will be emailed here
$technicalemail = "[email protected]";
// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 0;
// which users are allowed to view the admin log
// separate each userid with a comma
$canviewadminlog = "1";
// which users are allowed to prune the admin log
// separate each userid with a comma
$canpruneadminlog = "";
?>
keywords: /tmp/mysql.sock config.php Blue Domino database cannot connect permissions
Well I am completely satified with my web host Blue Domino. I have a fully tested and working solution that they provided and I have entered it below.
But first I wanted to say that they like many sites tell customers before hand that mysql is not supported outside of myadmin connectivity.
They went above and beyond the call of duty to get this going. I talked with the senior admin on the telephone about the problem, and yes they arranged this. They spent a good hour or two with me.
I represent 7 sites with them, and I have volunteered to use my own personal business site as their test bed for vbulletin issues.
They went in and debugged the vbulletin install. I just watched. They repeated the steps again and again to make sure it would work for you people (and me). I am now ordering two more web sites from them for my customers.
That said, here is the solution, hopefully someone will post it in a faq for me please. There are perhaps 11 other threads about this and I don't want to spam this professional board by answering all of those threads... someone please help me with this? thanks.
Todd B. Aubin
President
GoodKnight Productions
Problem:
vbulletin cannot connect via /tmp/mysql.sock on some web sites that use a secure socket file. The message You do not have permission to access the database or database not found is displayed. Many threads here were answered with attempts to check for accounts and permissions. not so.
Solution:
This will work with or without a clean install of vbulletin. If you have already installed vbulletin you do not need to reinstall, but you must insure that you have undone anything you did while testing various suggestions at work arounds.
Here is what was given to me by Blue Domino:
When you first upload, edit the admin/config.php file and change the
dbusername to 'root', dbpassword to your password, and technicalemail to
your e-mail address.
THEN THIS ACTUALLY MAKES IT WORK:
$servername="localhost:/path/to/mysql.sock";
It's that easy.
If you want to let the guys over on the vbulletin forums know that all
that needs to change for it to work is the $servername variable has to
have the servername followed by a ':' and then the path to the socket.
(taubin adding this part)
That was their final write up. Now here is a real world example that I am putting here because I love examples and perhaps you do too:
Here is my config.php file with some dummied values. I did this on 3 walkthroughs from scratch and it worked everytime.
You DO NOT need to create the vbulletin database, vbulletin install will do it. If you have one already, just DROP it.
<?php
/////////////////////////////////////////////////////////////
// Please note that if you get any errors when connecting, //
// that you will need to email your host as we cannot tell //
// you what your specific values are supposed to be //
/////////////////////////////////////////////////////////////
// type of database running
// (only mysql is supported at the moment)
$dbservertype="mysql";
// hostname or ip of server
//$servername="localhost";
$servername="localhost:/home/bdwebxxxx/yourweb.com/.database/mysql/mysql.sock";
// username and password to log onto db server
$dbusername="root";
$dbpassword="password"; // <-- password from your bluedomino admin
// name of database
$dbname="vbulletin";
// technical email address - any error messages will be emailed here
$technicalemail = "[email protected]";
// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 0;
// which users are allowed to view the admin log
// separate each userid with a comma
$canviewadminlog = "1";
// which users are allowed to prune the admin log
// separate each userid with a comma
$canpruneadminlog = "";
?>
Comment