[Plugin] [REL] MySQL Plugin (Now on github!)

[Plugin] [REL] MySQL Plugin (Now on github!) - 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: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Jeffry - 04.08.2011

Good Job G-sTyLeZzZ.

+1 Rep for you.

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Jochemd - 04.08.2011

The plugin does not work on R5 for me.

Re : [REL] MySQL Plugin R6-2 - 17/07/11 - ombre - 04.08.2011

Is it possible to connect 2 databases ( in the GM)? database 1 = accounts, database 2 = bans.
mysql_connect("123.456.789", "DB1", "AA");
mysql_connect("123.456.789", "DB2", "BB");

With the php I believe it's possible. Thx.

Re: Re : [REL] MySQL Plugin R6-2 - 17/07/11 - xxmitsu - 04.08.2011

Quote:

Originally Posted by ombre

Is it possible to connect 2 databases ( in the GM)? database 1 = accounts, database 2 = bans.
mysql_connect("123.456.789", "DB1", "AA");
mysql_connect("123.456.789", "DB2", "BB");

With the php I believe it's possible. Thx.

why aren't you reading the first post ppl ?

Код:

//this example demonstrates how to use more connections
new SQLPtr[2]; //global var
...
Function()
{
   SQLPtr[0] = mysql_connect(...);
   SQLPtr[1] = mysql_connect(...);
   mysql_query("SELECT a FROM table WHERE foo = 'bar'",(-1),(-1),SQLPtr[0]); //select query in the first DB
   mysql_query("UPDATE b SET bar = 'foo'",(-1),(-1),SQLPtr[1]); //update query in the second DB
   mysql_close(SQLPtr[1]); //close the 2nd DB connection, the other connection still exists

Re : [REL] MySQL Plugin R6-2 - 17/07/11 - ombre - 04.08.2011

ok sry not seen. But I dont really understand. There are a GM or other with?

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Jochemd - 04.08.2011

I've tested mysql_connect on two databases, with SA-MP 0.3c R5 server

Код:

[20:34:59] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

It both gives this. I can tell you it simply works fine on my previous version (0.3c R2 server)

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - array13 - 04.08.2011

good job

worked perfectly to me

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Donya - 05.08.2011

another small problem.. R6

my server kinda like.. disconnects from the mysql server around 27 - 35 seconds after connection.. this only happens when I gmx

edit: its offical, threads/callbacks are freezing( locking up ) the server.. (it doesn't always happen)

second time now

pawn Код:

[05:18:28] CMySQLHandler::ProcessQueryThread(SELECT * FROM Drug_Plants WHERE Owner = 'Harry') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

other time, (previous page)

pawn Код:

[16:02:06] CMySQLHandler::Query("OnUserLogin") - Custom callback query with index 102 started (ExtraID: -1)

passwords like "ииит ртпрн" is making the mysql lost connection during the query? >.<

some more logs..

pawn Код:

[13:41:55] >> mysql_real_escape_string( Connection handle: 1 )
[13:41:55] CMySQLHandler::EscapeString(Galamonkey); - Escaped 10 characters to Galamonkey.
[13:41:55] >> mysql_query( Connection handle: 1 )
[13:41:55] CMySQLHandler::Query(resultID) - Threaded query with id 3 started. (Extra ID: 8)
[13:41:55] >> mysql_real_escape_string( Connection handle: 1 )
[13:41:55] CMySQLHandler::EscapeString(Peter_Toman); - Escaped 11 characters to Peter_Toman.
[13:41:55] >> mysql_query( Connection handle: 1 )
[13:41:55] CMySQLHandler::ProcessQueryThread(SELECT * FROM Drug_Plants WHERE Owner = 'Galamonkey') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)
[13:41:55] CMySQLHandler::Query(UPDATE `Accounts` SET `WantedLevel` = 3 WHERE `Username` = 'Peter_Toman') - An error has occured. (Error ID: 2013, Lost connection to MySQL server during query)
[13:41:55] OnQueryError() - Called.
[13:41:55] >> mysql_reconnect( Connection handle: 1 )
[13:41:55] CMySQLHandler::Disconnect() - Connection was closed.
[13:41:55] CMySQLHandler::Connect() - Connection was successful.
[13:41:55] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[13:41:55] OnQueryFinish(3,"SELECT * FROM Drug_Plants WHERE Owner = 'Galamonkey'") - Called.
[13:41:55] >> mysql_store_result( Connection handle: 1 )
[13:41:55] CMySQLHandler::StoreResult() - No data to store.
[13:41:55] >> mysql_num_rows( Connection handle: 1 )
[13:41:55] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[13:41:55] >> mysql_retrieve_row( Connection handle: 1 )
[13:41:55] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)
[13:41:55] >> mysql_free_result( Connection handle: 1 )
[13:41:55] CMySQLHandler::FreeResult() - The result is already empty.

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Sergei - 05.08.2011

Hmm, I don't think that incldue was updated to R6 in R6 package (and include is missing in R6-2 package).

And another thing. I wonder why mysql_log was renamed to Debug. I liked original name more

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Donya - 06.08.2011

Hey, was just searching the forums for a solution and this guy had the same problem..

http://forum.sa-mp.com/showthread.ph...=onqueryfinish

edit: a user with the EXACT same problem as me

Quote:

Originally Posted by Alice[WS]

Nice plugin

I wanted to know, since i've threaded some queries my server freezes sometimes. By checking in the logs i can find "Data is getting passed to OnQueryFinish() - (Threadsafe: No)".
What does that "Threadsafe: No" mean ? I think it has something to do with the MySQL server's configuration, the threaded queries cannot execute in the specified thread, but i am not sure.

If it has an importance, how could i activate it ?

Thanks in advance.

edit 2: another user!

http://forum.sa-mp.com/showthread.ph...sh#post1269390

* Yes, I know those posts are from R5, it's just an example.

I believe its Linux only

BEFORE ANYONE SHOWS ME WHAT BLUEG SAID

Quote:

Originally Posted by G-sTyLeZzZ

The plugin has been updated after almost one year once again due to a threading bug which was discovered by xxmitsu. I have added mutexes to make sure shared variables don't get accessed twice by different threads at the same time. (which causes random crashes) Besides that I have made some code improvements and fixed some small bugs.

I advice everyone who uses the threading capabilities to update to R6, the files are as usual in the first post.

Great thanks for this release goes to xxmitsu for testing and compiling the plugin on Debian5 and CentOS.

The bug is back!

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Eric - 06.08.2011

Thanks for this plugin.
Very useful.

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - xxmitsu - 06.08.2011

Quote:

Originally Posted by Donya

Hey, was just searching the forums for a solution and this guy had the same problem..

The bug is back!

That bug caused the server to crash not to loose the connection to database. Is your mysql server on the same host as the samp server is ? because otherwise it could be packet loss issue between the samp host and mysql server. I'm not using R6-2 in production yet(I'm using R6). But I've tested R6-2 and didn't experienced any of your problems.

Are you using threded queries mixed with standard queries ?(if yes, it could be the problem) are you freeing the results after storing them ?
Also:

Код:

[13:41:55] OnQueryError() - Called.

check your query sintax seems like there is an error somewhere.

--
EDIT: I've just read that this problem only appears on gmx. Well, I can't tell you for sure because I NEVER gmx. I always prefer killing/restarting the server process.

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Donya - 06.08.2011

I'm not using R6-2 because it doesn't have a CentOS download.

yes I am freeing results after storing them

I use like a callback for onuserlogin, then a thread for loading groups and drug plants(when a player spawns), others are standard queries.

I never GMX on the real host.

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - xxmitsu - 06.08.2011

Quote:

Originally Posted by Donya

I never GMX either.

Quote:

Originally Posted by Donya

another small problem.. R6

my server kinda like.. disconnects from the mysql server around 27 - 35 seconds after connection.. this only happens when I gmx

I don't get it.

And like I said.. check what cause OnQueryError to be called.

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Donya - 06.08.2011

oh sorry, that was on my windows test server, but otherwise forget that. The crashing is coming from the linux real host, whereas about atleast 13+ players are online when it happens

Edit: Didn't I post the query logs already... and this is my onqueryerror

pawn Код:

public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
    switch(errorid)
    {
        case CR_COMMAND_OUT_OF_SYNC: {
            mysql_free_result();
            printf("[Mysql Error] - Commands Out Of Sync For Thread ID: %d", resultid);
        }
        case ER_UNKNOWN_TABLE: printf("[Mysql Error] - Unknown table '%s' in %s", error, query);
        case ER_SYNTAX_ERROR: printf("[Mysql Error] - Something is wrong in your syntax, query: %s", query);
        case CR_SERVER_GONE_ERROR: mysql_reconnect();
        case CR_SERVER_LOST: mysql_reconnect();
        case CR_SERVER_LOST_EXTENDED: mysql_reconnect();
    }
    if(errorid == CR_SERVER_LOST && resultid == THREAD_INITIATE_GROUPS) mysql_query("SELECT * FROM Groups", THREAD_INITIATE_GROUPS);
    printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
    return 1;
}

as you can see.. the error with lost / gone_error are the ones that are being called..

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - AndreT - 06.08.2011

Quote:

Originally Posted by xxmitsu

Are you using threded queries mixed with standard queries ?(if yes, it could be the problem) are you freeing the results after storing them ?
[...]
EDIT: I've just read that this problem only appears on gmx. Well, I can't tell you for sure because I NEVER gmx. I always prefer killing/restarting the server process.

Would threading every single query possibly fix the lockups/freezing issues? And yes, I can confirm that at least 7 GMXes out of 10 lock the server up.

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - xxmitsu - 06.08.2011

I can't pronounce myself regarding the gmx issue because I'm not using gmx. But perhaps using threaded with non-treaded queries can lead to unexpected results (I don't know this either because all my queries are threded - was just an suggestion).

Re: [REL] MySQL Plugin R6-2 - 17/07/11 - Donya - 06.08.2011

Quote:

Originally Posted by xxmitsu

I can't pronounce myself regarding the gmx issue because I'm not using gmx. But perhaps using threaded with non-treaded queries can lead to unexpected results (I don't know this either because all my queries are threded).

wow every single one? well.. hmm.. This problem actually didn't exist in R4-5... I must say( well for me obviously )

and again I say, this happens my host that's running on linux, not the windows. I never gmxed or even clicked the "restart" button on my host, it's stop then start.

I was gmxing on windows to try to find a bug in my onplayerconnect and saw that the mysql server disconnects, that isn't a problem with the lockups

AW: [REL] MySQL Plugin R6-2 - 17/07/11 - jig - 15.08.2011

Thanks AndreT,

i tested with Debian-mysqlR6-normal.tar.gz and the error is gone.
I have ia32-libs already installed.

But now i get this error:
Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

In startpost is only the libmysqlclient.so.15.
libmysqlclient16 is installed in the newest version.

Now starts my server, and if a player join i get this message in console:
./samp03svr: symbol lookup error: plugins/mysql.so: undefined symbol: compress

greetings

Re: AW: [REL] MySQL Plugin R6-2 - 17/07/11 - xxmitsu - 15.08.2011

Quote:

Originally Posted by jig

Thanks AndreT,

i tested with Debian-mysqlR6-normal.tar.gz and the error is gone.
I have ia32-libs already installed.

But now i get this error:
Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

In startpost is only the libmysqlclient.so.15.
libmysqlclient16 is installed in the newest version.

Now starts my server, and if a player join i get this message in console:
./samp03svr: symbol lookup error: plugins/mysql.so: undefined symbol: compress

greetings

install openssl devel or try the static build. It's too bad that I haven't had the time to test all of them in production.

But on my servers I'm running R6-static both CentOS and Debian.