Php/mysql queries are not processing

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post 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?
frankpmjr
Forum Commoner
Posts: 26
Joined: Wed Sep 15, 2004 9:13 am

Post 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
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
Post Reply