plz help me mysql ubuntu - Printable Version

plz help me mysql ubuntu - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: plz help me mysql ubuntu (/showthread.php?tid=516314)

plz help me mysql ubuntu - khalildz - 30.05.2014

guys

i have System: ubuntu-10.04-x86

i want engine mysql r7 i have samp 0.3z

but mysql not connected to my server

all is Connection is dead

Respuesta: plz help me mysql ubuntu - GutierrezDeVelasco - 30.05.2014

I dont really understand what are you trying to say.
you have mysql r7 query allready in your game mode and it doesnt connect?
or you want to use mysql r7 in your server but you dont know how

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

i have mysql r7 query in my game mode but doesnt connect
help me br

Respuesta: plz help me mysql ubuntu - GutierrezDeVelasco - 30.05.2014

ok show me your mysql_log.txt

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

PHP код:



SA-MP Dedicated Server

----------------------

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


[21:01:31] filterscripts = ""  (string)

[21:01:31] 

[21:01:31] Server Plugins

[21:01:31] --------------

[21:01:31]  Loading plugin: streamer.so

[21:01:31] 


*** Streamer Plugin v2.7.2 by Incognito loaded ***


[21:01:31]   Loaded.

[21:01:31]  Loading plugin: sscanf.so

[21:01:31] 


[21:01:31]  ===============================


[21:01:31]       sscanf plugin loaded.     


[21:01:31]          Version:  2.8.1        


[21:01:31]    (c) 2012 Alex "******" Cole  


[21:01:31]  ===============================


[21:01:31]   Loaded.

[21:01:31]  Loading plugin: mysql.so

[21:01:31] 


  > MySQL plugin R7 successfully loaded.


[21:01:31]   Loaded.

[21:01:31]  Loading plugin: nativechecker.so

[21:01:31]   Loaded.

[21:01:31]  Loading plugin: regex.so

[21:01:31] 


[21:01:31] ______________________________________


[21:01:31]  Regular Expression Plugin v0.2.0 loaded

[21:01:31] ______________________________________


[21:01:31]  By: Fro (c) Copyright <TBG> 2009-2011

[21:01:31] ______________________________________


[21:01:31]   Loaded.

[21:01:31]  Loaded 5 plugins.


[21:01:32] 

[21:01:32] Filterscripts

[21:01:32] ---------------

[21:01:32]   Loaded 0 filterscripts.


[21:01:32]    Error: Function not registered: 'regex_build'

[21:01:32]    Error: Function not registered: 'regex_match_exid'

[21:01:32]  

[21:01:32]  

[21:01:32]  

[21:01:32]  ======================================= 

[21:01:32]  |                                     | 

[21:01:32]  |        YSI version 1.06.0002        | 

[21:01:32]  |        By Alex "******" Cole        | 

[21:01:32]  |                                     | 

[21:01:32]  ======================================= 

[21:01:32]  

[21:01:32] OnGameo

[21:01:32] ** 0    <->    Labels Loaded From    <->    MySQL           **

[21:01:32] ** 0    <->    Vehicles Loaded From    <->    MySQL           **

[21:01:32] House loading started...

[21:01:32] House loading finished.

[21:01:32] 

----------------------------------


[21:01:32] 

LVGW/TDM

[21:01:32] 

----------------------------------


[21:01:32] Number of vehicle models: 65

[21:01:32]  

[21:01:32]  ========================================== 

[21:01:32]  |                                        | 

[21:01:32]  |  A new version (v3.09.0684) of YSI is  | 

[21:01:32]  |            available from:             | 

[21:01:32]  |                                        | 

[21:01:32]  |     www.y-less.com/YSI/YSI_1.0.zip     | 

[21:01:32]  |                                        | 

[21:01:32]  | Changelog:                             | 

[21:01:32]  |                                        | 

[21:01:32]  |   3.00.0000:                           | 

[21:01:32]  |                                        | 

[21:01:32]  |   YSI 3.0 released!  Now includes the  | 

[21:01:32]  | "y_text" library for better messages,  | 

[21:01:32]  | and a reworked "y_classes" library.    | 

[21:01:32]  | Largely documented here                | 

[21:01:32]  | "http://forum.sa-mp.com/showthread.php | 

[21:01:32]  | ?t=321092".                            | 

[21:01:32]  |                                        | 

[21:01:32]  |   3.01.0002:                           | 

[21:01:32]  |                                        | 

[21:01:32]  |   Small fixes to "y_text" and          | 

[21:01:32]  | "y_classes".                           | 

[21:01:32]  |                                        | 

[21:01:32]  |   3.09.0684:                           | 

[21:01:32]  |                                        | 

[21:01:32]  |   Reverted to old download location.   | 

[21:01:32]  | Improved (and fixed) version checks;   | 

[21:01:32]  | added y_bitmap, y_areas, y_races,      | 

[21:01:32]  | y_zonenames, better documentation;     | 

[21:01:32]  | MANY other bug fixes - see the github  | 

[21:01:32]  | repository for more details:           | 

[21:01:32]  |                                        | 

[21:01:32]  ========================================== 

[21:01:32]

Respuesta: plz help me mysql ubuntu - GutierrezDeVelasco - 30.05.2014

No thats server_log.txt I need to see mysql_log.txt

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

PHP код:



[21:25:34] >> mysql_query_callback( Connection handle: 0 )

[21:25:34] >> mysql_query_callback() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:25:47] >> mysql_connect(my ip , root, db, ******) on port 3306

[21:25:47] CMySQLHandler::CMySQLHandler() - constructor called.

[21:25:47] CMySQLHandler::CMySQLHandler() - Connecting to "my ip" | DB: "db" | Username: "root"

[21:25:47] CMySQLHandler::Connect() - Can't connect to MySQL server on ' my ip ' (111) (Error ID: 2003)

[21:25:47]  

[21:25:47]  ** MySQL Debugging enabled (05/30/14)

[21:25:47]  

[21:25:47] >> mysql_query_callback( Connection handle: 0 )

[21:25:47] >> mysql_query_callback() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:25:47] >> mysql_store_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[21:25:47] >> mysql_num_rows( Connection handle: 1 )

[21:25:47] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[21:25:47] >> mysql_free_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[21:25:47] >> mysql_query_callback( Connection handle: 0 )

[21:25:47] >> mysql_query_callback() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:25:47] >> mysql_store_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[21:25:47] >> mysql_num_rows( Connection handle: 1 )

[21:25:47] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[21:25:47] >> mysql_free_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[21:25:47] >> mysql_query_callback( Connection handle: 0 )

[21:25:47] >> mysql_query_callback() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:25:47] >> mysql_store_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[21:25:47] >> mysql_num_rows( Connection handle: 1 )

[21:25:47] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[21:25:47] >> mysql_free_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[21:25:47] >> mysql_query_callback( Connection handle: 1 )

[21:25:47] >> mysql_store_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[21:25:47] >> mysql_num_rows( Connection handle: 1 )

[21:25:47] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[21:25:47] >> mysql_fetch_row_format( Connection handle: 1 )

[21:25:47] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)

[21:25:47] >> mysql_free_result( Connection handle: 1 )

[21:25:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

yes It exists in my gamemode

everything is correct

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

but not connect

Respuesta: plz help me mysql ubuntu - GutierrezDeVelasco - 30.05.2014

are you running your host local?
the problem you are getting is that it doesnt recogniz #define db_host "this" so if you are running it local you need to put localhost if you are allready running on a server then its the ip of the server

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

brother #define db_host Do I put here "localhost or my ip server"

Respuesta: plz help me mysql ubuntu - GutierrezDeVelasco - 30.05.2014

it depends on where are you running your database but the problem is there

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

in my server
look brother

>> mysql_connect(127.0.0.1, root, db, ******) on port 3306
[22:02:17] CMySQLHandler::CMySQLHandler() - constructor called.
[22:02:17] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "db" | Username: "root"
[22:02:17] CMySQLHandler::Connect() - Connection was successful.
[22:02:17] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

its worked

Respuesta: plz help me mysql ubuntu - GutierrezDeVelasco - 30.05.2014

ok then everything good?

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

but gamemode not complete to work

mysql r5 woked in ubuntu or no

Respuesta: plz help me mysql ubuntu - GutierrezDeVelasco - 30.05.2014

mysql r5 arent you using r7?

Re: plz help me mysql ubuntu - khalildz - 30.05.2014

no i cant use r7 because i not have gamemode compiled by mysql r7

Re: plz help me mysql ubuntu - khalildz - 31.05.2014

lock thread
thank you GutierrezDeVelasco