Jump to content
  • 0

Mysql errror


InSide*

Question

Problemă: Am incercat sa pun un gamemode ce ruleaza pe mysql pe host. Baza de date urcata, in gamemode toate lucrurile sunt bine puse.
Am mai vazut ca serverul nu porneste, ramane picat in totalitate, am deschis server_log si am gasit asta:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-R4, (C)2005-2014 SA-MP Team

[19:31:20] filterscripts = ""  (string)
[19:31:20]
[19:31:20] Server Plugins
[19:31:20] --------------
[19:31:20]  Loading plugin: sscanf.so
[19:31:20]

[19:31:20]  ===============================

[19:31:20]       sscanf plugin loaded.     

[19:31:20]          Version:  2.8.1        

[19:31:20]    (c) 2012 Alex "Y_Less" Cole  

[19:31:20]  ===============================

[19:31:20]   Loaded.
[19:31:20]  Loading plugin: mysql_static.so
[19:31:20]  >> plugin.mysql: R39-2 successfully loaded.
[19:31:20]   Loaded.
[19:31:20]  Loading plugin: Whirlpool.so
[19:31:20]  
[19:31:20]  ==================
[19:31:20]  
[19:31:20]   Whirlpool loaded
[19:31:20]  
[19:31:20]  ==================
[19:31:20]  
[19:31:20]   Loaded.
[19:31:20]  Loading plugin: streamer.so
[19:31:20]   Loaded.
[19:31:20]  Loaded 4 plugins.

[19:31:20]
[19:31:20] Filterscripts
[19:31:20] ---------------
[19:31:20]   Loaded 0 filterscripts.

[19:31:20] [MYSQL]: Connection to database (w3op) failed!
[19:31:20] SUCCES: Conexiunea la baza de date`zp_hid4684` a fost stabilita!
[19:31:20]  
[19:31:20]  
[19:31:20]  RPG: RPG V 0.0.1 (beta) LS,LV
[19:31:20] ____________________________
[19:31:20] Number of vehicle models: 82
[19:31:20] --- Server Shutting Down.
[19:31:20]

[19:31:20]  ===============================

[19:31:20]      sscanf plugin unloaded.    

[19:31:20]  ===============================

[19:31:20] plugin.mysql: Unloading plugin...

Dupa aceea, am intrat in mysql_log si am gasit asta:
19:31:10    mysql_connect    OK    host: "93.119.26.250", user: "zp_hid4684", database: "zp_hid4684", password: "****", port: 3306, autoreconnect: true, pool_size: 2
19:31:10    CMySQLHandle::Create    OK    creating new connection..
19:31:10    CMySQLHandle::CMySQLHandle    OK    constructor called
19:31:10    CMySQLHandle::Create    OK    connection created (id: 2)
19:31:10    CMySQLConnection::Connect    OK    establishing connection to database...
19:31:10    CMySQLConnection::Connect    OK    establishing connection to database...
19:31:10    CMySQLConnection::Connect    ERROR    (error #2003) Can't connect to MySQL server on '127.0.0.1' (111)
19:31:10    CMySQLConnection::Connect    OK    establishing connection to database...
19:31:10    CMySQLConnection::Connect    ERROR    (error #2003) Can't connect to MySQL server on '127.0.0.1' (111)
19:31:10    CMySQLConnection::Connect    OK    connection was successful
19:31:10    CMySQLConnection::Connect    OK    auto-reconnect has been enabled
19:31:10    mysql_tquery    OK    connection: 2, query: "SELECT * FROM `houses`", callback: "LoadHouses", format: "(null)"
19:31:10    mysql_tquery    OK    connection: 2, query: "SELECT * FROM `business`", callback: "LoadBusiness", format: "(null)"
19:31:10    mysql_tquery    OK    connection: 2, query: "SELECT * FROM `sbusiness`", callback: "LoadSBusiness", format: "(null)"
19:31:10    mysql_tquery    OK    connection: 2, query: "SELECT * FROM `safes`", callback: "LoadSafes", format: "(null)"
19:31:10    mysql_tquery    OK    connection: 2, query: "SELECT * FROM `vehicles`", callback: "LoadVehicles", format: "(null)"
19:31:10    CMySQLConnection::Connect    OK    establishing connection to database...
19:31:10    CMySQLConnection::Connect    OK    connection was successful
19:31:10    CMySQLConnection::Connect    OK    auto-reconnect has been enabled
19:31:10    CMySQLQuery::Execute[LoadHouses]    OK    starting query execution
19:31:10    CMySQLQuery::Execute[LoadHouses]    OK    query was successfully executed within 0.239 milliseconds
19:31:10    CMySQLResult::CMySQLResult()    OK    constructor called
19:31:10    CMySQLQuery::Execute[LoadBusiness]    OK    starting query execution
19:31:10    CMySQLQuery::Execute[LoadBusiness]    OK    query was successfully executed within 0.189 milliseconds
19:31:10    CMySQLResult::CMySQLResult()    OK    constructor called
19:31:10    CMySQLQuery::Execute[LoadSBusiness]    OK    starting query execution
19:31:10    CMySQLQuery::Execute[LoadSBusiness]    OK    query was successfully executed within 0.244 milliseconds
19:31:10    CMySQLResult::CMySQLResult()    OK    constructor called
19:31:10    CMySQLQuery::Execute[LoadSafes]    OK    starting query execution
19:31:10    CMySQLConnection::Connect    OK    establishing connection to database...
19:31:10    CMySQLConnection::Connect    OK    establishing connection to database...
19:31:10    CMySQLQuery::Execute[LoadSafes]    OK    query was successfully executed within 0.662 milliseconds
19:31:10    CMySQLResult::CMySQLResult()    OK    constructor called
19:31:10    CMySQLQuery::Execute[LoadVehicles]    OK    starting query execution
19:31:10    CMySQLConnection::Connect    OK    connection was successful
19:31:10    CMySQLConnection::Connect    OK    auto-reconnect has been enabled
19:31:10    CMySQLQuery::Execute[LoadVehicles]    OK    query was successfully executed within 0.302 milliseconds
19:31:10    CMySQLResult::CMySQLResult()    OK    constructor called
19:31:10    CMySQLConnection::Connect    OK    connection was successful
19:31:10    CMySQLConnection::Connect    OK    auto-reconnect has been enabled
19:31:10    mysql_close    OK    connection: 1
19:31:10    CMySQLConnection::Disconnect    WARNING    no connection available
19:31:10    CMySQLConnection::Disconnect    WARNING    no connection available
19:31:10    CMySQLHandle::~CMySQLHandle    OK    deconstructor called
19:31:10    CMySQLConnection::Disconnect    OK    connection was closed

Cod sursă:
Le-am pus mai sus.
Ce am încercat: Toate chestiile, am dat reinstal la server, l-am urcat din nou, am inlocuit plugins, am urcat din nou baza de date, am modificat datele, dar fara succes.
Alte detalii: N-am idee de la ce provine aceasta mica defectiune.
Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.