[POMOC] MySQL - polaczenie

[przemospl 0]

Cześć,

 

 

chciałbym Was prosić o pomoc z baza danych MYSQL, posiadam serwer VPS na ktorym mam zainstalowany SAMP + WWW.

 

 

Skrypt jest pisany pod system mysql i gdy chce połączyć się z baza ''localhost'' wywala mi błąd, jak go naprawic? Dziękuje za pomoc.

 

SYSTEM 32BIT DEBIAN 6

 

[21:19:58] >> mysql_connect( )
[21:19:58] CMySQLHandler::CMySQLHandler() - constructor called.
[21:19:58] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "baza" | Username: "root" ...
[21:19:58] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) (Error ID: 2002)
[21:19:58] >> mysql_free_result( Connection handle: 1 )
[21:19:58] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)
[21:19:58] >> mysql_query( Connection handle: 1 )
[21:19:58] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[21:19:58] >> mysql_store_result( Connection handle: 1 )
[21:19:58] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)
[21:19:58] >> mysql_fetch_row_format( Connection handle: 1 )

Edytowano Marzec 16, 2014 przez przemospl (zobacz historię edycji)

[Pan Kot 1535]

Error 2002 to "server is not responding".

 

Po 1sze spróbuj zmienić localhost na 127.0.0.1, w niektórych przypadkach pomaga. Jeśli nadal nic z tego to zdefiniuj sobie połączenie po TCP 127.0.0.1:3306 zamiast po unixowym sockecie mysql. Jeśli nadal nic to jedziesz mysql -h 127.0.0.1 -u root -p i sam sprawdź czy można się połączyć.

[przemospl 0]

Po zmienieniu w skrypcie na 127.0.0.1 pojawia mi się:

 

 

[06:19:01] [debug] Server crashed while executing RPcents.amx
[06:19:01] [debug] AMX backtrace:
[06:19:01] [debug] #0 native mysql_free_result () [b6bd86c0] from mysql.so
[06:19:01] [debug] #1 00193c78 in ?? () from RPcents.amx
[06:19:01] [debug] #2 000e160c in public OPVD_OnGameModeInit () from RPcents.amx
[06:19:01] [debug] #3 native CallLocalFunction () [080dbf60] from samp03svr
[06:19:01] [debug] #4 000a561c in ?? () from RPcents.amx
[06:19:01] [debug] #5 0009ef38 in public zcmd_OnGameModeInit () from RPcents.amx
[06:19:01] [debug] #6 native CallLocalFunction () [080dbf60] from samp03svr
[06:19:01] [debug] #7 0009ea08 in public ELC_AC_OnGameModeInit () from RPcents.amx
[06:19:01] [debug] #8 native CallLocalFunction () [080dbf60] from samp03svr
[06:19:01] [debug] #9 00095bc8 in ?? () from RPcents.amx
[06:19:01] [debug] #10 00082790 in ?? () from RPcents.amx
[06:19:01] [debug] #11 0005e520 in public Itter_OnGameModeInit () from RPcents.amx
[06:19:01] [debug] #12 native CallLocalFunction () [080dbf60] from samp03svr
[06:19:01] [debug] #13 000028e0 in ?? () from RPcents.amx
[06:19:01] [debug] #14 00001864 in public OnGameModeInit () from RPcents.amx
[06:19:01] [debug] Native backtrace:
[06:19:01] [debug] #0 b74a4e0b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[06:19:01] [debug] #1 b749ee7f in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[06:19:01] [debug] #2 b749f956 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[06:19:01] [debug] #3 b74a4b1c in ?? () from plugins/crashdetect.so
[06:19:01] [debug] #4 b7754600 in ?? ()
[06:19:01] [debug] #5 4b355fae in free_root () from /usr/lib/libmysqlclient_r.so.15
[06:19:01] [debug] #6 4b377671 in free_rows () from /usr/lib/libmysqlclient_r.so.15
[06:19:01] [debug] #7 4b3776d7 in mysql_free_result () from /usr/lib/libmysqlclient_r.so.15
[06:19:01] [debug] #8 b6bd2b71 in _ZN13CMySQLHandler10FreeResultEv () from plugins/mysql.so
[06:19:01] [debug] #9 b6bd8704 in _ZN15NativeFunctions19n_mysql_free_resultEP6tagAMXPi () from plugins/mysql.so
[06:19:01] [debug] #10 08093d84 in ?? () from ./samp03svr
[06:19:01] [debug] #11 b749d60b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[06:19:01] [debug] #12 b74a1208 in ?? () from plugins/crashdetect.so
[06:19:01] [debug] #13 b74a6f43 in amx_Exec () from plugins/crashdetect.so
[06:19:01] [debug] #14 b749ed2a in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[06:19:01] [debug] #15 b74a12a9 in ?? () from plugins/crashdetect.so
[06:19:01] [debug] #16 080dc202 in ?? () from ./samp03svr

[Pan Kot 1535]

Z tym to już na GHT.