MSQL Connect Errors

Franco · 4. Dezember 2013

Nabend,habe mein Script mit der Datenbank Verbunden aber es kommt ganze zeit das hier:

SQL

[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] >> mysql_query_callback( Connection handle: 1 )
[23:15:18] Unloading Plugin
[23:15:18] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[23:15:18] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)
[23:15:18] CMySQLHandler:: Disconnect() - You cannot call this function now. (Reason: Connection is dead)
[23:15:18] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[23:15:27] >> mysql_connect(localhost, samp3914_8741894, samp4584, ******) on port 3306
[23:15:27] CMySQLHandler::CMySQLHandler() - constructor called.
[23:15:27] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp9624" | Username: "samp4584_4441594"
[23:15:27] CMySQLHandler::Connect() - Access denied for user 'samp4584_4411591'@'localhost' (using password: YES) (Error ID: 1045)
[23:15:27] >> mysql_query_callback( Connection handle: 1 )
[23:15:27] >> mysql_query_callback( Connection handle: 1 )
[23:15:27] >> mysql_query_callback( Connection handle: 1 )
[23:15:27] >> mysql_query_callback( Connection handle: 1 )
[23:15:27] >> mysql_query_callback( Connection handle: 1 )

Alles anzeigen

Tround · 4. Dezember 2013

passwort zu 100% richtig eingegeben?
Access denied for user

Franco · 4. Dezember 2013

Das ist auch ein Problem wie mache ich es in der reinfolge also steht bei mir so:
#if defined localhost
mysql_debug(false);
printf(" (PC) Es wird versucht auf die localhost Datenbank zu verbinden.");
DatenBank = mysql_connect("localhost","******",""*********",""*********");
#else
printf(" (SERVER) Es wird versucht auf die localhost Datenbank zu verbinden.");
DatenBank = mysql_connect("localhost","*********","s"*********",""*********");
printf("Datenbankverbindung: %d (DatenBank)",DatenBank);
#endif

Wo kommt jetzt db oder das pw

Tround · 4. Dezember 2013

schau dir mal das hier an das wirds erklären: http://wiki.sa-mp.com/wiki/MySQL#mysql_connect

Franco · 4. Dezember 2013

ok danke erstmal jetzt kommt das

SQL

[23:33:16] ProcessQueryThread(OnQueryFinished) - Query was successful. (SELECT * FROM `houses`)
[23:33:16] ProcessQueryThread(OnQueryFinished) - Data caching enabled.
[23:33:16] CMySQLHandler::StoreResult() - Result was stored.
[23:33:16] CMySQLHandler::FreeResult() - Result was successfully free'd.
[23:33:16] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[23:33:16] OnQueryFinished(d) - Threaded function called.
[23:33:16] >> cache_get_data( Connection handle: 1 )
[23:33:16] ProcessTick() - The cache has been cleared.
[23:33:16] Passing query SELECT * FROM `factioninfo` | d
[23:33:16] ProcessQueryThread(OnQueryFinished) - Query was successful. (SELECT * FROM `factioninfo`)
[23:33:16] ProcessQueryThread(OnQueryFinished) - Data caching enabled.
[23:33:16] CMySQLHandler::StoreResult() - Result was stored.
[23:33:16] CMySQLHandler::FreeResult() - Result was successfully free'd.
[23:33:16] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[23:33:16] OnQueryFinished(d) - Threaded function called.
[23:33:16] >> cache_get_data( Connection handle: 1 )
[23:33:16] ProcessTick() - The cache has been cleared.
[23:33:16] Passing query SELECT * FROM `serverstate` | d
[23:33:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

Alles anzeigen

Oder hat es mit der Daten-Bank zu tuhn wenn ich die .sql hochlade kommt das
SQL-Befehl:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

MySQL meldet: Dokumentation
#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Tround · 4. Dezember 2013

Zitat von DJCarlos

ok danke erstmal jetzt kommt das

SQL

[23:33:16] ProcessQueryThread(OnQueryFinished) - Query was successful. (SELECT * FROM `houses`)
[23:33:16] ProcessQueryThread(OnQueryFinished) - Data caching enabled.
[23:33:16] CMySQLHandler::StoreResult() - Result was stored.
[23:33:16] CMySQLHandler::FreeResult() - Result was successfully free'd.
[23:33:16] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[23:33:16] OnQueryFinished(d) - Threaded function called.
[23:33:16] >> cache_get_data( Connection handle: 1 )
[23:33:16] ProcessTick() - The cache has been cleared.
[23:33:16] Passing query SELECT * FROM `factioninfo` | d
[23:33:16] ProcessQueryThread(OnQueryFinished) - Query was successful. (SELECT * FROM `factioninfo`)
[23:33:16] ProcessQueryThread(OnQueryFinished) - Data caching enabled.
[23:33:16] CMySQLHandler::StoreResult() - Result was stored.
[23:33:16] CMySQLHandler::FreeResult() - Result was successfully free'd.
[23:33:16] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[23:33:16] OnQueryFinished(d) - Threaded function called.
[23:33:16] >> cache_get_data( Connection handle: 1 )
[23:33:16] ProcessTick() - The cache has been cleared.
[23:33:16] Passing query SELECT * FROM `serverstate` | d
[23:33:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

Alles anzeigen

Oder hat es mit der Daten-Bank zu tuhn wenn ich die .sql hochlade kommt das
SQL-Befehl:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

MySQL meldet: Dokumentation
#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Alles anzeigen

sieht so aus als ob du keine fehler mehr bekommst in der log.. bei deinen anderen fehlern bin ich überfragt

breadfish.de 12. März 2022