Page 2 of 2

Posted: Thu Jul 20, 2006 4:56 pm
by Benjamin
That is a bit involved... You need root access

http://builder.com.com/5100-6374-5290304.html might be a start.

If your host messed it up, they should fix it. Your paying them right?

Posted: Thu Jul 20, 2006 6:31 pm
by frankpmjr
Yes he is being paid, however his attitude is crappy. His reply to what I relayed earlier from the former posts is below:
PHP Warning: mysql_connect():
Can't connect
to local MySQL server through socket '/tmp/mysql.sock' (2) in
/usr/local/www/dat
a-dist/includes/featured_message.inc on line 3

the mysql server is on 127.0.0.1:3306
No explanation as to where that came from, no fix, nothing. It doesn't even match the error that is being displayed
Fatal error: Call to undefined function: mysql_connect() in /usr/local/www/data-dist/insidedigitalmedia/includes/featured_message.inc on line 1
He never replied when I pointed these facts out to him. I called and of course no one is answering the phone. I will try to escalate this tomorrow, but he seems to be the only technical person on staff. I have no idea how this will be handled. I would switch hosts, but there is a mail program bring used (ezmlm or something) by the owner of the site (I am just the webmaster) that is integral to running his business. I haven;'t found anything that duplicates the functionality and don't think I can write one.

Anyhow, thanks for the help, I'll look at the documentation above (is getting root access when I use 'sudo'?).

Frank

Posted: Thu Jul 20, 2006 6:37 pm
by RobertGonzalez
There are two things going on here. One, you do not have the right extensions enabled to use mysql (or just about any other extension functions for that matter). Two, the MySQL error you are getting is not at all reltaed to PHP. It is an issue with the server. Why is the IP address of the server 127.0.0.1? That is the standard local host IP address for a fresh install. If this is a database server, he might want to consider using a dedicated IP. Just a thought.

Anyway, it looks like the DB was upgraded and that there may be a problem with the server not having been restarted. I ran into this once and had to restart the server. Then I had to edit the my.cnf file to use old passwords since the client API version was outdated but the DB was new.

Your host should have been able to get right into your php.ini file, enable the extensions and have you rocking and rolling within minutes.