1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development

Threaded Mode
plz help me mysql ubuntu
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#1

30.05.2014, 16:32
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
Find
Reply
GutierrezDeVelasco
Little Clucker
**
Posts: 28
Threads: 1
Joined: Dec 2013
Reputation: 0
#2

30.05.2014, 16:42
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
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#3

30.05.2014, 16:45
i have mysql r7 query in my game mode but doesnt connect
help me br
Find
Reply
GutierrezDeVelasco
Little Clucker
**
Posts: 28
Threads: 1
Joined: Dec 2013
Reputation: 0
#4

30.05.2014, 16:47
ok show me your mysql_log.txt
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#5

30.05.2014, 16:50
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] 
Find
Reply
GutierrezDeVelasco
Little Clucker
**
Posts: 28
Threads: 1
Joined: Dec 2013
Reputation: 0
#6

30.05.2014, 16:52
No thats server_log.txt I need to see mysql_log.txt
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#7

30.05.2014, 17:01
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) 
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#8

30.05.2014, 17:24
yes It exists in my gamemode

everything is correct
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#9

30.05.2014, 17:27
but not connect
Find
Reply
GutierrezDeVelasco
Little Clucker
**
Posts: 28
Threads: 1
Joined: Dec 2013
Reputation: 0
#10

30.05.2014, 17:29
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
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#11

30.05.2014, 17:31
brother #define db_host Do I put here "localhost or my ip server"
Find
Reply
GutierrezDeVelasco
Little Clucker
**
Posts: 28
Threads: 1
Joined: Dec 2013
Reputation: 0
#12

30.05.2014, 17:35
it depends on where are you running your database but the problem is there
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#13

30.05.2014, 17:39
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
Find
Reply
GutierrezDeVelasco
Little Clucker
**
Posts: 28
Threads: 1
Joined: Dec 2013
Reputation: 0
#14

30.05.2014, 17:47
ok then everything good?
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#15

30.05.2014, 17:48
but gamemode not complete to work

mysql r5 woked in ubuntu or no
Find
Reply
GutierrezDeVelasco
Little Clucker
**
Posts: 28
Threads: 1
Joined: Dec 2013
Reputation: 0
#16

30.05.2014, 17:55
mysql r5 arent you using r7?
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#17

30.05.2014, 18:00
no i cant use r7 because i not have gamemode compiled by mysql r7
Find
Reply
khalildz
Big Clucker
***
Posts: 117
Threads: 15
Joined: Aug 2012
Reputation: 0
#18

31.05.2014, 17:50
lock thread
thank you GutierrezDeVelasco
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development