Installation Problem

[emud]

Hi,

When I run the installation file, I get the following error:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /data/4/0/154/55/317381/user/322913/htdocs/pixelpost/admin/install.php on line 40
Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I've checked and rechecked the information that I put into pixelpost.php and everything is as should be. I can get access to my database through phpMyAdmin and created a test table through that without a problem (except that 'The additional Features for working with linked Tables have been deactivated').

Finally, I'm not sure if it matters but my site is being hosted by Network Solutions. I would really appreciate any help with resolving this.

Thanks,
Emud

[raminia+]

it seems that your sql server was not running at that time. try again. ask you host admin too.

[tinyblob]

First off: Don't worry about: 'The additional Features for working with linked Tables have been deactivated'. It's an advanced feature which most hosting services will disable for performance reasons.

You said that you checked the information in pixelpost.php, but most of the problems people have with MySQL are due to incorrect configuration.

If your username and password were wrong then the error would be different, so i can only assume that you have the wrong information in this variable:
$pixelpost_db_host
More often than not, it's "localhost".

The error suggests that the php file is actually unable to connect to the mysql server, rather than authenticate, so here's a quick checklist.

1) Do you have MySQL installed on the webserver (not an external server)?
2) Is it a compatible version of MySQL?
3) Is PHP a compatible version?
4) Is the MySQL server actually running?
5) Are you supply exactly the right information in pixelpost.php?
6) Have you confirmed the above with your hosting company?

If all of the above are answered YES, then you should have no problems. Otherwise, post again and we'll see what we can do.

[GeoS+]

There are other questions:
1) are you sure that your DB exists??
2) are you sure that your user exists??
3) are you sure that your password is correct??
4) are you sure that you have permissions to access your DB??

[tinyblob]

GeoS, in my experience those issues would all result in a more identifiable error message.
A virtual "socket" file is used to make the connection to the MySQL database, the error shows that the connection isn't being made.
I know this happens when:

* The MySQL server isn't running.
* The MySQL server isn't running locally (i.e the hosting company have an external database server).
* The servers hard drive is full.

If you have access, the best thing to do is always to check your MySQL log files. If you don't have access to the log file, ask your hosts to look into it.
If you have SSH access you can try a manual database connection from the command line.

[GeoS+]

Oups. I read first post and then yours and forgot about reason of error.

Yeah, problem with socket generaly means that MySQL server isnt online

[emud]

Thanks for all the responses. I contacted the host last night and they said that they would look into it and contact me in 24 hours. However, after seeing tinyblob's response just now, I decided to check to see what version of mysql they are running and sure enough, it's version 3.23.58 and not 3.24.58 so I guess that's my problem.

I had assumed that Network Solutions would have their stuff updated to the latest. I'm looking into hosting with eleven2 but I signed a one year deal with Network Solutions in August and would hate to just throw that money away, yet I would love to use pixelpost. Well, I have some figuring out to do but thanks again for your quick responses.

Best,
Emud

[emud]

Ok, I just got a response from Network Solutions and apparently the problem was that the database is not located on localhost. The admin pointed pixelpost.php to the correct address and the install.php worked. I was able to run it and create all the necessary tables, although I haven't tried posting anything just yet. Will the fact thay they are running mysql version 3.23 cause any problems?

Thanks again,
Emud

[tinyblob]

Yeah, i had a funny feeling they'd be using an external MySQL server. Glad that is resolved. You should keep note of the information they've entered into that file, for the future.

Originally Posted by emud

Will the fact thay they are running mysql version 3.23 cause any problems?

You tell us

The minimum requirement for Pixelpost is MySQL version 3.23.58, so "3.23" could well be good enough

[emud]

Yeah, I noted the address. I just got through testing the basics like posting images, comments, and thumbnails, and everything seems to be working great. Thanks again.
Emud