MYSQL connected nicht zur Datenbank

Masterman · 3. September 2012

Hallo leute ich habe das plugin+include a_mysql R5 aber das problem ist er connected nicht mit der datenbank. Hier der code

ongamemodeinit
mysql_connect("127.0.0.1", "root", "samp", "");

if(mysql_ping() == 0) { print("->-> VERBINDUNG ZUR DATENBANK KONNTE NICHT AUFGEBAUT WERDEN <-<-"); print("->-> SERVER WIRD BEENDET <-<-"); SendRconCommand("exit"); } else { print("->-> Verbindung zur Datenbank, erfolgreich. <-<-"); }

wenn ich das 2. rauslasse connected er trotzdem nicht aber woran liegt das?? Ich benutze easyphp 5.3.9 aber daran kann das nicht liegen weil ich hab das auch schon auf anderen datenbanken probiert.

DerFiesling · 3. September 2012

versuch es mal so:

stock Connect_To_Database()
{
mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS); //<<-- anpassen :D oder oben im Script #defines machen siehe auch unten
if(mysql_ping() == 1)
{
print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
return true;
}
else
{
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS); //<<-- anpassen :D oder oben im Script #defines machen siehe auch unten
if(mysql_ping() == 1)
{
print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
return true;
}
else
{
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Der Server wird nun beendet!");
SendRconCommand("exit");
return true;
}
}
}

und unter public OnGameModeInit dann

Connect_To_Database();
mysql_debug(1);

einfügen ...
das erste Connectet zur Datenbank
und das 2te legt ein Logfile an zecks fehlersuche
wenn script dann läuft den debug wieder ausmachen

Ich hab bei mir oben im Scipt die Mysqldaten per #define drinne

#define SQL_HOST "127.0.0.1"
#define SQL_USER "Username"
#define SQL_PASS "wie war das PW nochmal ?"
#define SQL_DATA "sampserver"

Masterman · 3. September 2012

SQL

[17:00:36]  


[17:00:36] ---------------------------


[17:00:36] MySQL Debugging activated (09/03/12)


[17:00:36] ---------------------------


[17:00:36]  


[17:00:36] >> mysql_connect( )


[17:00:36] CMySQLHandler::Connect() - Connection was successful.


[17:00:36] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.


[17:00:36] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[17:00:36] CMySQLHandler::FreeResult() - The result is already empty.


[17:00:36] CMySQLHandler::Disconnect() - Connection was closed.

Alles anzeigen

Tano Siedler · 3. September 2012

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DATA "samp"
mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);

Masterman · 3. September 2012

hab ich doch gemacht

DerFiesling · 3. September 2012

hmm... i ist noch nen fehler...

log sollte eigendlich eher so aussehen:

SQL

[22:46:16] >> mysql_connect( )


[22:46:16] CMySQLHandler::CMySQLHandler() - constructor called.


[22:46:16] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "server2" | Username: "samp" ...


[22:46:16] CMySQLHandler::Connect() - Connection was successful.


[22:46:16] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.


[22:46:16] >> mysql_ping( Connection handle: 1 )


[22:46:16] CMySQLHandler::Ping() - Connection is still alive.


[22:46:16] >> mysql_query( Connection handle: 1 )


[22:46:16] CMySQLHandler::Query(SELECT * FROM `vehicles` ORDER BY `id` ASC) - Successfully executed.


[22:46:16] >> mysql_store_result( Connection handle: 1 )


[22:46:16] CMySQLHandler::StoreResult() - Result was stored.


[22:46:16] >> mysql_retrieve_row( Connection handle: 1 )


[22:46:16]  


[22:46:16] ---------------------------


[22:46:16] MySQL Debugging activated (08/21/12)


[22:46:16] ---------------------------

Alles anzeigen

sonst änder mal 127.0.0.1 zu localhost um ... manschmal liegt es auch dadranne...

Versuchst du es über win oder linux?

/edit: Was sagt der server.log eigendlich ? wird der GM danach beendet ?

Masterman · 3. September 2012

ja der gamemode wird beendet

mysql log

SQL

[17:00:36]  


[17:00:36] ---------------------------


[17:00:36] MySQL Debugging activated (09/03/12)


[17:00:36] ---------------------------


[17:00:36]  


[17:00:36] >> mysql_connect( )


[17:00:36] CMySQLHandler::Connect() - Connection was successful.


[17:00:36] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.


[17:00:36] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[17:00:36] CMySQLHandler::FreeResult() - The result is already empty.


[17:00:36] CMySQLHandler::Disconnect() - Connection was closed.


[17:27:26]  


[17:27:26] ---------------------------


[17:27:26] MySQL Debugging activated (09/03/12)


[17:27:26] ---------------------------


[17:27:26]  


[17:27:27] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[17:27:27] CMySQLHandler::FreeResult() - The result is already empty.


[17:27:27] CMySQLHandler::Disconnect() - Connection was closed.


[17:31:41]  


[17:31:41] ---------------------------


[17:31:42] MySQL Debugging activated (09/03/12)


[17:31:42] ---------------------------


[17:31:42]  


[17:31:42] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[17:31:42] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[17:31:42] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)


[17:33:51]  


[17:33:51] ---------------------------


[17:33:51] MySQL Debugging activated (09/03/12)


[17:33:51] ---------------------------


[17:33:51]  


[17:33:51] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[17:33:51] CMySQLHandler::FreeResult() - The result is already empty.


[17:33:51] CMySQLHandler::Disconnect() - Connection was closed.


[19:35:00]  


[19:35:00] ---------------------------


[19:35:00] MySQL Debugging activated (09/03/12)


[19:35:00] ---------------------------


[19:35:00]  


[19:35:00] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[19:35:00] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[19:35:01] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)


[19:35:07]  


[19:35:07] ---------------------------


[19:35:07] MySQL Debugging activated (09/03/12)


[19:35:07] ---------------------------


[19:35:07]  


[19:35:08] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[19:35:08] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[19:35:08] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)


[22:49:07]  


[22:49:07] ---------------------------


[22:49:07] MySQL Debugging activated (09/03/12)


[22:49:07] ---------------------------


[22:49:07]  


[22:49:08] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[22:49:08] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[22:49:08] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)


[23:28:13]  


[23:28:13] ---------------------------


[23:28:13] MySQL Debugging activated (09/03/12)


[23:28:13] ---------------------------


[23:28:13]  


[23:28:13] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[23:28:13] CMySQLHandler::FreeResult() - The result is already empty.


[23:28:13] CMySQLHandler::Disconnect() - Connection was closed.


[23:30:52]  


[23:30:52] ---------------------------


[23:30:52] MySQL Debugging activated (09/03/12)


[23:30:52] ---------------------------


[23:30:52]  


[23:30:52] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[23:30:52] CMySQLHandler::FreeResult() - The result is already empty.


[23:30:52] CMySQLHandler::Disconnect() - Connection was closed.


[23:31:02]  


[23:31:02] ---------------------------


[23:31:02] MySQL Debugging activated (09/03/12)


[23:31:02] ---------------------------


[23:31:02]  


[23:31:02] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[23:31:02] CMySQLHandler::FreeResult() - The result is already empty.


[23:31:02] CMySQLHandler::Disconnect() - Connection was closed.


[23:31:21]  


[23:31:21] ---------------------------


[23:31:21] MySQL Debugging activated (09/03/12)


[23:31:21] ---------------------------


[23:31:21]  


[23:31:21] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[23:31:21] CMySQLHandler::FreeResult() - The result is already empty.


[23:31:21] CMySQLHandler::Disconnect() - Connection was closed.


[23:36:02]  


[23:36:02] ---------------------------


[23:36:02] MySQL Debugging activated (09/03/12)


[23:36:02] ---------------------------


[23:36:02]  


[23:36:03] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[23:36:03] CMySQLHandler::FreeResult() - The result is already empty.


[23:36:03] CMySQLHandler::Disconnect() - Connection was closed.


[23:42:11]  


[23:42:11] ---------------------------


[23:42:11] MySQL Debugging activated (09/03/12)


[23:42:11] ---------------------------


[23:42:11]  


[23:42:11] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[23:42:11] CMySQLHandler::FreeResult() - The result is already empty.


[23:42:11] CMySQLHandler::Disconnect() - Connection was closed.


[23:42:36]  


[23:42:36] ---------------------------


[23:42:36] MySQL Debugging activated (09/03/12)


[23:42:36] ---------------------------


[23:42:36]  


[23:42:37] CMySQLHandler::~CMySQLHandler() - deconstructor called.


[23:42:37] CMySQLHandler::FreeResult() - The result is already empty.


[23:42:37] CMySQLHandler::Disconnect() - Connection was closed.


[23:46:43]  


[23:46:43] ---------------------------


[23:46:43] MySQL Debugging activated (09/03/12)


[23:46:43] ---------------------------


[23:46:43]  


[23:47:30] >> mysql_query( Connection handle: 83 )


[23:47:30] >> mysql_query() - Invalid connection handle. (You set: 83, Highest connection handle ID is 1).


[23:47:30] >> mysql_store_result( Connection handle: 0 )


[23:47:30] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).


[23:47:30] >> mysql_fetch_row_format( Connection handle: 0 )


[23:47:30] >> mysql_fetch_row_format() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).


[23:47:43] >> mysql_query( Connection handle: 97 )


[23:47:43] >> mysql_query() - Invalid connection handle. (You set: 97, Highest connection handle ID is 1).


[23:47:43] >> mysql_query( Connection handle: 0 )


[23:47:43] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).


[23:47:43] >> mysql_store_result( Connection handle: 78 )


[23:47:43] >> mysql_store_result() - Invalid connection handle. (You set: 78, Highest connection handle ID is 1).


[23:47:43] >> mysql_fetch_row_format( Connection handle: 78 )


[23:47:43] >> mysql_fetch_row_format() - Invalid connection handle. (You set: 78, Highest connection handle ID is 1).


[23:47:43] >> mysql_free_result( Connection handle: 78 )


[23:47:43] >> mysql_free_result() - Invalid connection handle. (You set: 78, Highest connection handle ID is 1).


[23:47:50] >> mysql_query( Connection handle: 97 )


[23:47:50] >> mysql_query() - Invalid connection handle. (You set: 97, Highest connection handle ID is 1).


[23:48:02] >> mysql_query( Connection handle: 97 )


[23:48:02] >> mysql_query() - Invalid connection handle. (You set: 97, Highest connection handle ID is 1).


[23:50:54] >> mysql_query( Connection handle: 83 )


[23:50:54] >> mysql_query() - Invalid connection handle. (You set: 83, Highest connection handle ID is 1).


[23:50:54] >> mysql_store_result( Connection handle: 0 )


[23:50:54] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).


[23:50:54] >> mysql_fetch_row_format( Connection handle: 0 )


[23:50:54] >> mysql_fetch_row_format() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

Alles anzeigen

samp log
[23:46:43] <-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!
[23:46:43] <-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!
[23:46:43] <-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!
[23:46:43] <-| [MYSQL] Der Server wird nun beendet!
[23:46:43] GangZone 0 loadad: 2722.423828,-1901.509521,2812.729492,-2042.323974,2790.339355,-1944.110473,13.546897,14
[23:46:43] GangZone 1 loadad: 560.538024,-724.028320,875.840576,-362.014099,681.371826,-474.094207,16.536300,14
[23:46:43] GangZone 2 loadad: -2151.333007,-534.198120,-1969.786987,-368.509490,-2044.298217,-499.230285,35.335899,14
[23:46:43] GangZone 3 loadad: -2760.101806,818.282775,-2838.311279,1321.169555,-2802.583007,1007.611877,48.113498,13
[23:46:43] Maximale Pickups: 2048, Momentane Pickups: 54
[23:46:43] _______________________________________
[23:46:43] Das Script wurde Vollständig geladen!
[23:46:43] Evolution of San Andreas V1.5
[23:46:43] Script Edit by [ESA]Masterman
[23:46:43] _______________________________________
[23:46:43]
[23:46:43] Number of vehicle models: 94
[23:47:29] Incoming connection: 127.0.0.1:53073
[23:47:30] [join] Masterman has joined the server (0:127.0.0.1)
[23:47:43] Masterman hat sich Eingeloggt.
[23:48:01] [chat] [Masterman]: (q
[23:48:02] [part] Masterman has left the server (0:1)
[23:50:54] Incoming connection: 127.0.0.1:61238
[23:50:54] [join] Masterman has joined the server (0:127.0.0.1)
[23:51:09] [part] Masterman has left the server (0:1)

DerFiesling · 4. September 2012

Zitat

[23:46:43] <-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!
[23:46:43] <-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!
[23:46:43] <-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!
[23:46:43] <-| [MYSQL] Der Server wird nun beendet!

Dann wirst Du evtl. doch irgendwo nen fehler haben mit deinen MySQL Daten.
Oder erlaubt es dir der MySQL server viell. nicht von "außerhalb" zu Connecten?

Ist der Samp gemietet oder "eigener" Server?
Mysqlserver... Local, auf eigenen Server oder Webspace?

Masterman · 4. September 2012

eigener server mit XAMPP aber das problem liegt am Godfather ..

luiluiboy014 · 4. September 2012

kann auch sein das du keine datenbank erstellt hast

Masterman · 4. September 2012

ich habe eine datenbank erstellt keine sorge, es liegt wirklich am godfather, denn ich habe es schon an einem blank script erstellt mit mysql_connect(blablabla) und das klappte

Tano Siedler · 5. September 2012

Welches Godfather ist den das?

breadfish.de 11. März 2022