MySQL R7 Urgent Problem - WILL PAY

MySQL R7 Urgent Problem - WILL PAY - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL R7 Urgent Problem - WILL PAY (/showthread.php?tid=409800)

MySQL R7 Urgent Problem - WILL PAY - lolumadd_ - 23.01.2013

As Posted Here: http://forum.sa-mp.com/showpost.php?...postcount=2970

When I try to connect using "localhost" (which I've always been doing)

Code:

[02:27:09] >> mysql_connect(localhost, lscnr_****, lscnr_****, ******) on port 3306
[02:27:09] CMySQLHandler::CMySQLHandler() - constructor called.
[02:27:09] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "lscnr_***" | Username: "lscnr_****"
[02:27:09] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002)

When I change to 127.0.0.1, it does this. (I think it is because the actual MySQL is set up as localhost)

Code:

[02:17:20] >> mysql_connect(127.0.0.1, lscnr_****, lscnr_****, ******) on port 3306[02:17:20] CMySQLHandler::CMySQLHandler() - constructor called.
[02:17:20] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "lscnr_****" | Username: "lscnr_****"
[02:17:20] CMySQLHandler::Connect() - Can't connect to MySQL server on '127.0.0.1' (111) (Error ID: 2003)

Using RC7-2-v4 on Centos 5.3 64-bit. Any help please? The MySQL connection is up...

This fix is really urgent, I'll pay anyone who can help me with this fast, upload a working version or something!

Re: MySQL R7 Urgent Problem - WILL PAY - Djole1337 - 23.01.2013

What's your bind-address ?

127.0.0.1 ?

Re: MySQL R7 Urgent Problem - WILL PAY - lolumadd_ - 23.01.2013

Not sure because I'm not the Server Administrator, but when I go on phpmyadmin, it says "lscnr_****@localhost"

So it may be set to "localhost" and not "127.0.0.1"

Re: MySQL R7 Urgent Problem - WILL PAY - Djole1337 - 23.01.2013

Can you use terminal ?

Re: MySQL R7 Urgent Problem - WILL PAY - lolumadd_ - 23.01.2013

Quote:

Originally Posted by Mr_DjolE

Can you use terminal ?

Yes, but I don't have access to the MySQL library and root.

Re: MySQL R7 Urgent Problem - WILL PAY - jonrb - 23.01.2013

"#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"

Make sure that your MySQL server is indeed using 3306, and make sure that there are no firewalls that could be blocking the internal connection. You may find the netstat command useful for this.

Re: MySQL R7 Urgent Problem - WILL PAY - Djole1337 - 23.01.2013

Does your mysql running ?

Type: ps -ef | grep mysqld

and post results here

Re: MySQL R7 Urgent Problem - WILL PAY - lolumadd_ - 23.01.2013

Yeah it is running.

Code:

lscnr    21626 10624  0 03:36 ttyp0    00:00:00 grep mysqld

Quote:

Make sure that your MySQL server is indeed using 3306, and make sure that there are no firewalls that could be blocking the internal connection. You may find the netstat command useful for this.

Code:

SHOW GLOBAL VARIABLES LIKE 'PORT';

Returns "3306". That isn't the issue, plus, all other MySQL plugins have worked fine before, just not this one (R7).

edit: googling around and found these artices:
http://askubuntu.com/questions/79226...ld-mysqld-sock
http://stackoverflow.com/questions/1...ld-mysqld-sock

Starting to think that the "bind-address" could be set to "localhost" and is what is causing this.

Re: MySQL R7 Urgent Problem - WILL PAY - lolumadd_ - 23.01.2013

The connection works when using the external IP address instead of "localhost" or "127.0.0.1". Weird.

Re: MySQL R7 Urgent Problem - WILL PAY - lolumadd_ - 23.01.2013

Bump, still need a definite solution or someone to tell me what's wrong.

P.S: The MySQL topic is locked?