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?
Php/mysql queries are not processing
Moderator: General Moderators
Yes he is being paid, however his attitude is crappy. His reply to what I relayed earlier from the former posts is below:
Anyhow, thanks for the help, I'll look at the documentation above (is getting root access when I use 'sudo'?).
Frank
No explanation as to where that came from, no fix, nothing. It doesn't even match the error that is being displayedPHP 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
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.Fatal error: Call to undefined function: mysql_connect() in /usr/local/www/data-dist/insidedigitalmedia/includes/featured_message.inc on line 1
Anyhow, thanks for the help, I'll look at the documentation above (is getting root access when I use 'sudo'?).
Frank
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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.
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.