Help me install MySQL problems!

**TECK** · Mon 22 Apr '02, 12:45pm

what is line 47 in db_mysql.php? and you left the name "localhost" in config.php? or you change it to your host name? let me know. make sure you leave unchanged the server name part of your config.php.

**Pabs** · Mon 22 Apr '02, 12:55pm

Originally posted by nakkid
what is line 47 in db_mysql.php? and you left the name "localhost" in config.php? or you change it to your host name? let me know. make sure you leave unchanged the server name part of your config.php.

I'm not sure what you are asking.

This is my config.php:

// type of database running
// (only mysql is supported at the moment)
$dbservertype="mysql";

// hostname or ip of server
$servername="localhost";

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

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

// 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 = "";

-------------------------------------------------

This is the error:

Attempting to attach to database...

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/bdweb3912k/dmbcommunity.com/public_html/forums/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/bdweb3912k/dmbcommunity.com/public_html/forums/admin/db_mysql.php on line 40

Warning: Supplied argument is not a valid MySQL-Link resource in /home/bdweb3912k/dmbcommunity.com/public_html/forums/admin/db_mysql.php on line 47

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.

------------------------

Line 40 looks like this:

} else {
if ($usepconnect==1) {
$this->link_id=mysql_pconnect($this->server,$this->user,$this->password);
} else {
$this->link_id=mysql_connect($this->server,$this->user,$this->password);
}

----------------------

Line 47 looks like this:

if ($this->database!="") {
if(!mysql_select_db($this->database, $this->link_id)) {
$this->halt("cannot use database ".$this->database);

----------------------

I really don't know what to do anymore. If someone would like to try to help me get beyond this, you may get in touch with me via email or AIM me "Pabs815" or Yahoo IM "tap4636" ICQ is "42571584".

Thanks.

**Steve Machol** · Mon 22 Apr '02, 1:24pm

Contact your web host and ask what is the correct mysql server name. If the database is on the same server as your files then $servername should be localhost.. If it is and you're still getting that error it means that mysql cannot find the mysql.sock file. Contact your host to fix the problem.

**Pabs** · Mon 22 Apr '02, 2:05pm

Originally posted by smachol
Contact your web host and ask what is the correct mysql server name. If the database is on the same server as your files then $servername should be localhost.. If it is and you're still getting that error it means that mysql cannot find the mysql.sock file. Contact your host to fix the problem.

They gave me a PATH to the mysql.sock file. Should I put that PATH in the $servername in the config.php???

**Steve Machol** · Mon 22 Apr '02, 2:11pm

No, it's up to them to properly configure MySQL to use the correct path.

**Pabs** · Mon 22 Apr '02, 2:13pm

So do you think that it being the wrong path is what is making the connection fail?

What should I say to them? Because I have a feeling they want me to do something with this path, as in implement it somehow in the connection.

**Steve Machol** · Mon 22 Apr '02, 2:16pm

Tell them the error message you're getting:

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

A good host will see that this is a server issue and try to find and fix the problem.

**Pabs** · Mon 22 Apr '02, 4:54pm

They basically told me to go to hell.

So I guess I better find myself a new host.

Wanna know what they said?

They said that it must a problem with the way vBulletin's script is!!!!

HAHAHAA!

vBulletin is on what? 500,000 sites???

They were giving my a path to the MySQL path and telling me to put it into the config.php.

What a bunch of jerks. Damn I'm pissed.

**Pabs** · Mon 22 Apr '02, 5:01pm

Is it possible that the PATH they gave me for the MySQL server can be implemented somehow in the db_mysql.php????

I'm reaching for all possibilities.

**Steve Machol** · Mon 22 Apr '02, 5:26pm

They basically told me to go to hell.

Classy host you got there.

No, you don't want to touch db_mysql.php. Let's try something first. Create a new file called phpinfo.php with this content:

PHP Code:


<?php

phpinfo();

?>

Then upload it to your webspace and post the URL here.

**Pabs** · Mon 22 Apr '02, 5:31pm

Classy host? Understatement of the year.

Here is the URL:

http://www.dmbcommunity.com/forums/phpinfo.php

**Steve Machol** · Mon 22 Apr '02, 5:37pm

It looks like the socket is at /tmp/mysql.sock which is what the error message says it's trying to connect to. Is that where they told you it was?

**Pabs** · Mon 22 Apr '02, 5:39pm

Originally posted by smachol
It looks like the socket is at /tmp/mysql.sock which is what the error message says it's trying to connect to. Is that where they told you it was?

This is the path they told me it was.

/home/bdweb3912k/dmbcommunity.com/.database/mysql/mysql.sock

**Steve Machol** · Mon 22 Apr '02, 5:52pm

Originally posted by Pabs

This is the path they told me it was.

/home/bdweb3912k/dmbcommunity.com/.database/mysql/mysql.sock

That doesn't make any sense. The path is clearly /tmp/mysql.sock as indicated by the phpinfo.php file.

What kind of a host is this?

Help me install MySQL problems!

Help me install MySQL problems!

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment