Vbulletin 2.0 installation problems

[Hitpoint]

I get these warnings when I run the install.php:
(I have allready adjust the config.php)

Attempting to attach to database...


Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /web/sites/52/myname/www.myname.f2s.com/upload/admin/db_mysql.php on line 37

Warning: Supplied argument is not a valid MySQL-Link resource in /web/sites/52/myname/www.myname.f2s.com/upload/admin/db_mysql.php on line 46

The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.

What do I do wrong?

[PeF]

It may occurs if:

MySQL server is not running
hostname you specified in config.php is incorrect
you don't have appropriate permissions to the db
you installed MySQL db tables as root not as mysql user


Feel free to post config.php (w/o the password).

[Hitpoint]

Here's the config.php:

<?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="db.myname.f2s.com";

// username and password to log onto db server
$dbusername="username";
$dbpassword="password";

// name of database
$dbname="forum";

// allow password viewing / editing in control panel
// 0 = not visible or editable
// 1 = not visible, but can be edited
// 2 = visible and can be edited
$pwdincp=0;

// technical email address - any error messages will be emailed here
$technicalemail = "admin@myname.f2s.com";

// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 1;

?>

[PeF]

Ask your host how to connect to their MySQL server. They'll give you the exact answer.

It seems like the hostname is incorrect.

[Christian]

If you have found out what the problem was please post it here, because we have exactly the same problem!!

One question:
Do we need to create a table before insatlling vBulletin?
I thought a table is created during install!

[Martin]

the problem only occurs under the conditions listed by PeF.

In answer to your question, yes, the install program *does* create the tables.

[Hitpoint]

The problem was that the mysql database wasn't active at that moment. But now the board is running :)

Thnxz PeF for helping me out

[Christian]

How can I activate the database?

[Martin]

you have to talk to your hosting service about that

[Christian]

Yep, the problem is solved now!
The board is running!

The problem i now have is the following:
I want to import the old UBB data, but it is on a different server! Do we have to copy it to the new server first?

[Martin]

yup

you don't have to copy the forum .html files, though. that should save some transfer time

[Christian]

OK, and now my (hopefully) last question:
In the VB cpl, there is this 4th field in the UBB import options, where I have to enter the URL.
But the problem is now that when I upload the UBB data from the other server the old domain name isn't pointed to that server/directory.
Shall I leave it blank, use the domain name of the old server or can I use the IP adress of the new server?

Thanks for all your help!

Chris

[Martin]

crap, you;ve stumped me on this one. it's been almost a year since I did one like this.

I *think* you put in your present url, including the folder where your UBB files are. if that doesn't work, try your old one.

[Christian]

Too late! Alerady uploading to the new server!
Doesn't matter.
What I have done now is that I have created a folder for it. It is IP/oldubb there is the complete old server in there (except the html files form UBB).
I can now tell VB the exact directories where the files are. What I want to know now is can i use http://ip/oldubb as adress in the 4th field? Or shall that be http://ip/oldubb/ubb?

[Mike Sullivan]

The 4th field is used to translate smilies in posts back to actual smilies (to :) from <img ...>). So you're going to point that to whatever your UBB's Non CGI URL was.

[Christian]

AHHHHHHHHH!!

Very informative! Thanks!
So I better leave the similes then on the server! ;)

[Martin]

that's right! I was in a rush to get to my day job and didn't have time to look for you. you don't have to leave the smilies page up, just the folder, and the URL should point to your old domain, since the smilies are hard-coded into the UBB CGI files.