Can't connect to server

[pokonski]

I'm totally new at this, so bare with me: My ISP is AIT ([url]www.aitcom.net[/url]). PHP is at v4.0.6 and was also patched with the latest security patch. Mysql is at v3.23.33
I wasn't really sure about some of the config file information. For "hostname or IP of server" I put in my site IP address. For the username and password to log onto db server, I just put in my username and password. For "name of database" I put the name I'd like for my database - assuming that vB would create it. I uploaded the files and executed the install and confirmed the config info. But when it tries to connect, I get this:
Attempting to connect...

Warning: Can't connect to MySQL server on '216.117.168.230' (111) in /usr/local/etc/httpd/htdocs/Board/admin/db_mysql.php3 on line 31

Warning: Supplied argument is not a valid MySQL-Link resource in /usr/local/etc/httpd/htdocs/Board/admin/db_mysql.php3 on line 37

Did I set up the config file wrong?

[filburt1]

Re: Install Problem: Can't connect to server

[QUOTE][i]Originally posted by pokonski [/i]
[B]Did I set up the config file wrong? [/B][/QUOTE]

Probably...what does it read?

[pokonski]

<?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="216.117.168.230";

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

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

//password needed to enter the control panel
$cppassword="******";

?>

[filburt1]

Try changing $servername to localhost.

[pokonski]

...well at least we got different error messages. I wasn't quite sure what you meant so first I did this:
localhost="216.117.168.230";

That didn't work, so I did this:
$servername="localhost";

and got this:

Attempting to connect...

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/etc/httpd/htdocs/Board/admin/db_mysql.php3 on line 31

Warning: Supplied argument is not a valid MySQL-Link resource in /usr/local/etc/httpd/htdocs/Board/admin/db_mysql.php3 on line 37

So this is progress I think. What to try next?

[filburt1]

Not sure if it is the problem, but you should be using the .php version, not the .php3 version (the .php version is for PHP4, which is what you have).

[pokonski]

Do you think I should try the other version?

[filburt1]

Yes.

[pokonski]

:confused: Okay. This looks very similar:
Attempting to connect...

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/etc/httpd/htdocs/forum/admin/db_mysql.php on line 31

Warning: Supplied argument is not a valid MySQL-Link resource in /usr/local/etc/httpd/htdocs/forum/admin/db_mysql.php on line 37

I tried putting in the IP address, localhost, etc. Same results.:(

NOTE: I just read the "mySQL Tutorial" mentioned in the online manual. Wow do I feel in over my head.

[Steve Machol]

This is a server issue. Either the host has specified the wrong location for mysql.sock or there's some other problem connecting to it. I suggest you ask your host about this.

[pokonski]

[QUOTE][i]Originally posted by smachol [/i]
[B]This is a server issue. Either the host has specified the wrong location for mysql.sock or there's some other problem connecting to it. I suggest you ask your host about this. [/B][/QUOTE]

How do I ask my host service about that? I don't what questions to ask.
Sorry - I'm pretty new at this.

[Steve Machol]

First try the solution in this thread:

[url]http://www.vbulletin.com/forum/showthread.php?s=&threadid=45223[/url]

If that doesn't work then tell your host what's happening (send them the error message) and ask them to check the location of mysql.sock and to make sure it has the necessary permissions (srwxrwxrwx).

[pokonski]

Ok - these guys are not really working with me. I poked around in my directories and couldn't find a file called mysql.sock. So I called the support line and asked them for the location and they directed me to view the my.cnf file which, amoung other things, says this:

# The MySQL server
[mysqld]
user = moscraps
port = 4071
socket = /vs4/vs4/moscraps/tmp/mysql.sock
tmpdir = /vs4/vs4/moscraps/tmp
basedir = /vs4/vs4/moscraps/usr/local/mysql/

Does that help anyone, because it doesn't help me. I did try to follow the vs4/vs4/... path and couldn't. Assuming that I just don't know enough about anything, I threw that path into the fix that you directed me to in the other thread and that didn't work either. Should I be looking for a file called mysql.sock? Am I doing something wrong? Why did the tech direct me to my.cnf?

[Steve Machol]

Are you on a dedicated or shared server? If it's shared then there's really not much you can do anyway. Any changes to my.cnf,or php.ini for that matter, would need to be done by the host.

Also do you have a phpinfo.php file? If not create a text file with this content:

[php]<?php
phpinfo();
?>[/php]Upload it to your forum directory and post the URL here.

[pokonski]

[url]http://www.moscraps.com/forum/phpinfo.php[/url]

Wow.

Hey - answer me this. The path vs4/vs4/moscraps.com/tmp/mysql.sock; When I look at the directory structure, I can follow the path moscraps.com/tmp/
....and there's nothing in that directory. But the path seems to be saying mysql.sock should be there. Is that the problem? (I know it can't be that simple.)

By the way - I am very interested in buying a full version if I can just figure this install out and get it running on my server.