[highstreetsrp]

WHy is this error coming? Any solution?

Код:

[Sun Nov  2 06:33:43 2014] -------------------------
[Sun Nov  2 06:33:43 2014]       Logging Ended
[Sun Nov  2 06:33:43 2014] -------------------------
[Sun Nov  2 06:33:53 2014] -------------------------
[Sun Nov  2 06:33:53 2014]      Logging Started
[Sun Nov  2 06:33:53 2014] -------------------------
[Sun Nov  2 06:35:40 2014] -------------------------
[Sun Nov  2 06:35:40 2014]       Logging Ended
[Sun Nov  2 06:35:40 2014] -------------------------
[Sun Nov  2 06:35:45 2014] -------------------------
[Sun Nov  2 06:35:45 2014]      Logging Started
[Sun Nov  2 06:35:45 2014] -------------------------
[Sun Nov  2 06:37:49 2014] -------------------------
[Sun Nov  2 06:37:49 2014]      Logging Started
[Sun Nov  2 06:37:49 2014] -------------------------
[Sun Nov  2 06:38:25 2014] -------------------------
[Sun Nov  2 06:38:25 2014]      Logging Started
[Sun Nov  2 06:38:25 2014] -------------------------
[Sun Nov  2 06:42:15 2014] -------------------------
[Sun Nov  2 06:42:15 2014]      Logging Started
[Sun Nov  2 06:42:15 2014] -------------------------
[Sun Nov  2 06:47:15 2014] -------------------------
[Sun Nov  2 06:47:15 2014]       Logging Ended
[Sun Nov  2 06:47:15 2014] -------------------------
[Sun Nov  2 06:47:20 2014] -------------------------
[Sun Nov  2 06:47:20 2014]      Logging Started
[Sun Nov  2 06:47:20 2014] -------------------------
[Sun Nov  2 08:02:39 2014] -------------------------
[Sun Nov  2 08:02:39 2014]       Logging Ended
[Sun Nov  2 08:02:39 2014] -------------------------
[Sun Nov  2 08:07:04 2014] -------------------------
[Sun Nov  2 08:07:04 2014]      Logging Started
[Sun Nov  2 08:07:04 2014] -------------------------
[12:58:14] Plugin succesfully loaded!
[12:58:17] >> mysql_connect(5.231.71.238, root, rprp, ***) on port 3306
[12:58:17] CMySQLHandler::CMySQLHandler() - constructor called.
[12:58:17] CMySQLHandler::CMySQLHandler() - Connecting to "5.231.71.238" | DB: "rprp" | Username: "root"...
[12:58:17] CMySQLHandler::Connect() - Can't connect to MySQL server on '5.231.71.238' (111) (error ID: 2003).
[12:58:17]  
[12:58:17]  ** MySQL Debugging enabled.
[12:58:17]  
[12:58:17] >> mysql_ping(Connection handle: 1)
[12:58:17] CMySQLHandler::Ping() - You cannot call this function now (connection is dead).
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:17] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[12:58:18] >> mysql_query_callback(Connection handle: 1)
[13:00:50] >> mysql_real_escape_string(Connection handle: 1)
[13:00:50] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:00:50] >> mysql_query_callback(Connection handle: 1)
[13:01:04] >> mysql_real_escape_string(Connection handle: 1)
[13:01:04] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:01:04] >> mysql_query_callback(Connection handle: 1)
[13:01:44] >> mysql_real_escape_string(Connection handle: 1)
[13:01:44] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:01:44] >> mysql_query_callback(Connection handle: 1)
[13:02:40] >> mysql_real_escape_string(Connection handle: 1)
[13:02:40] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:02:40] >> mysql_query_callback(Connection handle: 1)
[13:03:49] >> mysql_real_escape_string(Connection handle: 1)
[13:03:49] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:03:49] >> mysql_query_callback(Connection handle: 1)
[13:04:47] >> mysql_real_escape_string(Connection handle: 1)
[13:04:47] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:04:47] >> mysql_query_callback(Connection handle: 1)
[13:05:19] >> mysql_real_escape_string(Connection handle: 1)
[13:05:19] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:05:19] >> mysql_query_callback(Connection handle: 1)
[13:21:22] >> mysql_real_escape_string(Connection handle: 1)
[13:21:22] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[13:21:22] >> mysql_query_callback(Connection handle: 1)
[13:28:39] >> mysql_close(Connection handle: 1)
[13:28:39] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[13:28:39] CMySQLHandler::FreeResult() - There is nothing to free (connection is dead).
[13:28:39] CMySQLHandler::Disconnect() - You cannot call this function now (connection is dead).
[13:28:39] Unloading Plugin
[13:28:46] Plugin succesfully loaded!
[13:28:49] >> mysql_connect(5.231.71.238, root, rprp, ***) on port 3306
[13:28:49] CMySQLHandler::CMySQLHandler() - constructor called.
[13:28:49] CMySQLHandler::CMySQLHandler() - Connecting to "5.231.71.238" | DB: "rprp" | Username: "root"...
[13:28:49] CMySQLHandler::Connect() - Can't connect to MySQL server on '5.231.71.238' (111) (error ID: 2003).
[13:28:49]  
[13:28:49]  ** MySQL Debugging enabled.
[13:28:49]  
[13:28:49] >> mysql_ping(Connection handle: 1)
[13:28:49] CMySQLHandler::Ping() - You cannot call this function now (connection is dead).
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:49] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)
[13:28:50] >> mysql_query_callback(Connection handle: 1)

[Swyft™]

Your SQL Credentials are incorrect.

[Mark_Weston]

Also do not use root account, easy way to get raped in the ass if you get hacked.

[highstreetsrp]

Quote:

Originally Posted by Swyft™ Your SQL Credentials are incorrect.

What that means?

[highstreetsrp]

After i edited the port.. now this error appears..? Any Solution?

Код:

[02:53:03] >> mysql_close(Connection handle: 1)
[02:53:03] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[02:53:03] CMySQLHandler::FreeResult() - There is nothing to free (connection is dead).
[02:53:03] CMySQLHandler::Disconnect() - You cannot call this function now (connection is dead).
[02:53:03] Unloading Plugin
[02:53:15] Plugin succesfully loaded!
[02:53:17] >> mysql_connect(5.231.71.238, root, rprp, ***) on port 22
[02:53:17] CMySQLHandler::CMySQLHandler() - constructor called.
[02:53:17] CMySQLHandler::CMySQLHandler() - Connecting to "5.231.71.238" | DB: "rprp" | Username: "root"...
[02:53:17] CMySQLHandler::Connect() - Lost connection to MySQL server at 'reading initial communication packet', system error: 0 (error ID: 2013).
[02:53:17]  
[02:53:17]  ** MySQL Debugging enabled.
[02:53:17]  
[02:53:17] >> mysql_ping(Connection handle: 1)
[02:53:17] CMySQLHandler::Ping() - You cannot call this function now (connection is dead).
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:17] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:53:18] >> mysql_query_callback(Connection handle: 1)
[02:54:12] >> mysql_real_escape_string(Connection handle: 1)
[02:54:12] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[02:54:12] >> mysql_query_callback(Connection handle: 1)
[02:54:26] >> mysql_real_escape_string(Connection handle: 1)
[02:54:26] CMySQLHandler::EscapeString() - You cannot call this function now (connection is dead).
[02:54:26] >> mysql_query_callback(Connection handle: 1)

[Swyft™]

It's probably because you're connecting to MySQL with Root. Make a new MySQL Account, and use that. Please.

EDIT #1:
I know saying that not using Root is the cause, but it was for me for some odd reason. A friend and I were figuring it out, we could use root to access the database via phpmyadmin. But we had to make a new MySQL account for the SA-MP server.. Besides, you shouldn't use root anyways.

[highstreetsrp]

Quote:

Originally Posted by Swyft™ It's probably because you're connecting to MySQL with Root. Make a new MySQL Account, and use that. Please. EDIT #1: I know saying that not using Root is the cause, but it was for me for some odd reason. A friend and I were figuring it out, we could use root to access the database via phpmyadmin. But we had to make a new MySQL account for the SA-MP server.. Besides, you shouldn't use root anyways.

The problem was that i need to put Host: localhost, instead of ip.. and now it is fixed

[batonsa]

Just for the record, using the root account doesnt make you more prone to bugs or security risks. One just has to make sure that the code doesnt "support" sql injection and that the password is strong enough to withstand a bruteforce.

[Aldo.]

Quote:

Originally Posted by batonsa Just for the record, using the root account doesnt make you more prone to bugs or security risks. One just has to make sure that the code doesnt "support" sql injection and that the password is strong enough to withstand a bruteforce.

Please stop calling yourself a web developer if you are supporting the use of the root account on an SQL server when you are not doing administrative task.

[batonsa]

Quote:

Originally Posted by Aldo. Please stop calling yourself a web developer if you are supporting the use of the root account on an SQL server when you are not doing administrative task.

Give me one reason not to use the root account on a homehost server when it is password protected. We are not talking a web-based server. We are talking a homehost on 127.0.0.1 that is used for testing purposes. Not to mention most routers need portforwarding to allow external access. Where is the risk?

So?