06.02.2014, 15:36
I'm having problem with my MySQL. I'm sure I entered the correct login details and as you can see below it says connection was successful. Do you think I still anything I missed?
Now after I start the server it still appearing as offline.
Addtional: Before I use "localhost" for the host name but because it always says "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock" I ******d this and the solution is to use 127.0.0.1
MYSQL_LOG.TEXT
SERVER_LOG.TXT
Now after I start the server it still appearing as offline.
Addtional: Before I use "localhost" for the host name but because it always says "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock" I ******d this and the solution is to use 127.0.0.1
MYSQL_LOG.TEXT
Код:
[19:45:32] [19:45:32] ** MySQL Debugging enabled (02/06/14) [19:45:32] [19:45:32] >> mysql_connect(127.0.0.1, kevinbalordb, kevinbalordb, ******) on port 3306 [19:45:32] CMySQLHandler::CMySQLHandler() - constructor called. [19:45:32] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "test1" | Username: "test2" [19:45:32] CMySQLHandler::Connect() - Connection was successful. [19:45:32] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [19:45:32] >> mysql_ping( Connection handle: 1 ) [19:45:32] CMySQLHandler::Ping() - Connection is still alive. [19:45:32] >> mysql_query_callback( Connection handle: 1 ) [19:45:32] >> mysql_query_callback( Connection handle: 1 ) [19:45:32] >> mysql_query_callback( Connection handle: 1 ) [19:45:32] >> mysql_query_callback( Connection handle: 1 ) [19:45:32] >> mysql_query_callback( Connection handle: 1 ) [19:45:32] >> mysql_query_callback( Connection handle: 1 ) [19:45:32] Passing query SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay` FROM `misc` | iii [19:45:32] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay` FROM `misc`) [19:45:32] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [19:45:32] CMySQLHandler::StoreResult() - Result was stored. [19:45:32] CMySQLHandler::FreeResult() - Result was successfully free'd. [19:45:32] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
SERVER_LOG.TXT
Quote:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3x-R2, ©2005-2013 SA-MP Team [19:45:32] [19:45:32] Server Plugins [19:45:32] -------------- [19:45:32] Loading plugin: mysql.so [19:45:32] > MySQL plugin R7 successfully loaded. [19:45:32] Loaded. [19:45:32] Loading plugin: streamer.so [19:45:32] *** Streamer Plugin v2.6.1 by Incognito loaded *** [19:45:32] Loaded. [19:45:32] Loading plugin: sscanf.so [19:45:32] [19:45:32] =============================== [19:45:32] sscanf plugin loaded. [19:45:32] Version: 2.8.1 [19:45:32] © 2012 Alex "******" Cole [19:45:32] =============================== [19:45:32] Loaded. [19:45:32] Loading plugin: Whirlpool.so [19:45:32] [19:45:32] ================== [19:45:32] [19:45:32] Whirlpool loaded [19:45:32] [19:45:32] ================== [19:45:32] [19:45:32] Loaded. [19:45:32] Loading plugin: nativechecker.so [19:45:32] Loaded. [19:45:32] Loaded 5 plugins. [19:45:32] [19:45:32] Filterscripts [19:45:32] --------------- [19:45:32] Loading filterscript 'buttons.amx'... [19:45:32] Loading filterscript 'gcustom03e.amx'... [19:45:32] Loading filterscript 'vactions.amx'... [19:45:32] Loaded 3 filterscripts. [19:45:32] [19:45:32] ======================================= [19:45:32] | | [19:45:32] | YSI version 3.01.0002 | [19:45:32] | By Alex "******" Cole | [19:45:32] | | [19:45:32] ======================================= [19:45:32] [19:45:32] [MySQL] (Main Pipelines) Connecting to 127.0.0.1... [19:45:32] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server! [19:45:32] [LoadHouses] Loading data from database... [19:45:32] [LoadDynamicDoors] Loading data from database... [19:45:32] [LoadDynamicMapIcons] Loading data from database... [19:45:32] [LoadDynamicTexts] Loading data from database... [19:45:32] [LoadTurfWars] 0 turfs loaded. [19:45:32] [LoadPaintballArenas] 10 paintball arenas loaded. [19:45:32] [LoadEventPoints] 0 event points loaded. [19:45:32] [LoadGates] 4000 gates loaded. [19:45:32] [LoadElevatorStuff] 20 floors loaded. [19:45:32] [LoadFamilies] 16 families loaded. [19:45:32] [LoadPoints] 9 points loaded. [19:45:34] [LoadCDealerships] 15 dealerships loaded. [19:45:34] [MiscLoad] Misc Loaded [19:45:34] [Tax] Government Tax/Vault Loaded. |