[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)
+- 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: AW: Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 09.07.2014
Quote:
|
Originally Posted by Danny
 I'm sorry for 'bumping' my question, but can anybody help me out with this? I'm kinda on a schedule.
In the meantime I've been able again to reproduce the hang-issues. With some optimisations (replacing cache_get_row by cache_get_row_int/float in some places) I succeeded in reducing the hang time from > 100 to 81 seconds. But the issue hasn't been solved yet: I never had issues like this with the old plugin. |
Re: Re : [REL] MySQL Plugin (Now on github!) - [Mr]Wallace - 09.07.2014
Quote:
|
Originally Posted by iZN
wat?
Don't you see your mistake there? |
Re: [REL] MySQL Plugin (Now on github!) - Faix - 09.07.2014
It's working! Thank you very much. +REP
Re : [REL] MySQL Plugin (Now on github!) - Noliax8 - 10.07.2014
Hi all,
I use the version R7, and I've a problem to start my gamemode on Dйbian 7 32bit.
I installed:
Quote:
|
apt-get update apt-get upgrade apt-get install apache2 apt-get install php5 php5-mysql apt-get install mysql-server apt-get install phpmyadmin apt-get install libmysqlclient-dev |
I get that:
Quote:
|
[13:09:11] Loading plugin: mysql.so [13:09:11] Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64) |
Thanks a lot!
Nlx
Re: [REL] MySQL Plugin (Now on github!) - iZN - 10.07.2014
First post of this thread needs to be updated as I can see many users gets confuse with the part that the latest release are on Github page and that's R39-2 at the moment.
@Noliax8: Use mysql_static.so which is available in further releases or download R39-2 but you should know what you're doing because after R21, queries are now cache-only.
@[Mr]Wallace: You've missed the part where I bold the text. You're using outdated plugin (R7) and your script is compiled with (R39-2). Download R39-2 package and place the plugin .dll or .so of R39-2 NOT R7. Now you should know what mistake you've made.
Re : Re: [REL] MySQL Plugin (Now on github!) - Noliax8 - 10.07.2014
Quote:
|
Originally Posted by iZN
@Noliax8: Use mysql_static.so which is available in further releases or download R39-2 but you should know what you're doing because after R21, queries are now cache-only.
|
EDIT:
Quote:
|
[13:36:00] Loading plugin: mysql.so [13:36:00] Failed (libmysqlclient_r.so.16: wrong ELF class: ELFCLASS64) [13:36:00] Loading plugin: mysql_5.5.so [13:36:00] >> plugin.mysql: R39-2 successfully loaded. [13:36:00] Loaded. [13:36:00] Loading plugin: mysql_static.so [13:36:00] >> plugin.mysql: R39-2 successfully loaded. [13:36:00] Loaded. |
Quote:
|
[13:50:37] Loading plugin: mysql_static.so [13:50:37] >> plugin.mysql: R39-2 successfully loaded. |
EDIT 3:
But.... But don't work on my Windows computer...
Do you have a idea?
Thanks
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 10.07.2014
Quote:
|
Originally Posted by Danny
Thank you for your quick reply. I have 4 GB RAM in total. I use about 50% of it without my SA-MP server running.
When I fire it up it only increases by 2%. But my CPU skyrockets from ~20% to values between 70-80%. After some time it drops again, presumably when the loading job is finished. Moreover, I asked one of my fellow developers to launch the server on his (state-of-the-art) PC and check the log timestamps. His server process took only 2 seconds to load. He has an 8-core CPU and I have an AMD Athlon X2 Dual-Core QL-65 2,1 GHz processor. So apparently I'm a part of the problem here since I have a terrible computer. Is there anything you could do to lower the CPU usage in the next version and is there anything I could do to prevent this behaviour? |
Quote:
|
Originally Posted by Noliax8
Hi all,
I use the version R7, and I've a problem to start my gamemode on Dйbian 7 32bit. I installed: I placed libmysqlclient_r.so.16 on the racine of my gamemode, and in /usr/lib. I get that: Do you have a idea, please ? Thanks a lot! Nlx |
You'll need a 32bit library or the static version (like iZN said) to run your server with the MySQL plugin.
EDIT: Seems like the 5.5 version works. Use that version (mysql_5.5.so) instead of the static version (mysql_static.so).
Your Windows error indicates, that you don't have the correct redistributables installed. Take a look at the FAQ, there is a list of all required redistributables.
Quote:
|
Originally Posted by iZN
First post of this thread needs to be updated as I can see many users gets confuse with the part that the latest release are on Github page and that's R39-2 at the moment.
[...] |
Re : Re: [REL] MySQL Plugin (Now on github!) - Noliax8 - 10.07.2014
Quote:
|
Originally Posted by maddinat0r
Your Windows error indicates, that you don't have the correct redistributables installed. Take a look at the FAQ, there is a list of all required redistributables.
|
Re: [REL] MySQL Plugin (Now on github!) - iZN - 10.07.2014
Quote:
|
Originally Posted by maddinat0r
There are big fat links on the first post, linking to the Github page. Also, I don't think many users really confuse this.
|
Re: Re : Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 10.07.2014
Quote:
|
Originally Posted by Noliax8
I've trying and it's not different...
|
Re : Re: Re : Re: [REL] MySQL Plugin (Now on github!) - Noliax8 - 10.07.2014
Quote:
|
Originally Posted by maddinat0r
Remove all .dll's you've placed in your SA-MP server folder (except the libmysql.dll of course).
|
Re: [REL] MySQL Plugin (Now on github!) - Danny - 12.07.2014
Quote:
|
Originally Posted by maddinat0r
You said you are using pqueries, weren't you? Try using tqueries instead, this should lower the performance (and thus CPU usage). Also disable parallel queries (by setting the pool_size parameter in mysql_connect to '0'). If this still doesn't help, I'll try to compile a special version for you (with some performance adjustments of course).
|
Re: [REL] MySQL Plugin (Now on github!) - Luca12 - 12.07.2014
Hello everyone I have a problem with loading mysql plugin R39-2 so I downloaded that plugin and of course I put in wrigth places libmysql in main root server folder where is samp server exe mysql plugin in plugins folder and of course a_mysql.inc in /pawno/include folder then I compile the gamemode and it all fine no errors also I downloaded correct visual c++ redistributables 2010 2010 SP1 and 2012 x86 like it said in this link https://github.com/pBlueG/SA-MP-MySQL#faq. Also I use windows not linux and in my sever.cfg goes plugins mysql
and when I start server I get this errors:
pawn Код:
[12:55:24] Error: Function not registered: 'mysql_log'
[12:55:24] Error: Function not registered: 'mysql_connect'
[12:55:24] Error: Function not registered: 'mysql_stat'
[12:55:24] Error: Function not registered: 'mysql_errno'
[12:55:24] Error: Function not registered: 'mysql_format'
[12:55:24] Error: Function not registered: 'mysql_tquery'
[12:55:24] Error: Function not registered: 'mysql_close'
[12:55:24] Error: Function not registered: 'cache_insert_id'
[12:55:24] Error: Function not registered: 'cache_get_data'
[12:55:24] Error: Function not registered: 'cache_get_row'
[12:55:24] Error: Function not registered: 'cache_get_row_int'
[12:55:24] Error: Function not registered: 'cache_get_field_content_int'
[12:55:24] Error: Function not registered: 'cache_get_field_content'
[12:55:24] Error: Function not registered: 'cache_get_field_content_float'
[12:55:24] [debug] Run time error 19: "File or function is not found"
Re: [REL] MySQL Plugin (Now on github!) - Jake187 - 14.07.2014
seem to be having a problem with my dialog login not loading up from upgrading from R38 to R39 when I downgrade back to R38 I have no problems.
Re: [REL] MySQL Plugin (Now on github!) - Reynolds - 14.07.2014
I am trying to perform an SQL injection using this plugin on my own server (solely for pentest purposes) and I have a question. I have a command whose input is deliberately unescaped and I am trying to delete a table abusing this mistake. The code is:
Код:
CMD:testtest( playerid, params[] )
{
TestT( "asd", params );
return 1;
}
TestT(nme[], tst[])
{
format(query, sizeof(query), "INSERT INTO `test` (`asdfg`, `fghij`) VALUES ('%s', '%s')", nme, tst);
mysql_query(query);
return 1;
}
Код:
/testtest fgh'); DROP TABLE `example`;--
Код:
[23:44:38] CMySQLHandler::Query(INSERT INTO `test` (`asdfg`, `fghij`) VALUES ('asd', 'fgh'); DROP TABLE `example`;-- ')) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE malibusux;-- ')' at line 1)
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 14.07.2014
Quote:
|
Originally Posted by Reynolds
I am trying to perform an SQL injection using this plugin on my own server (solely for pentest purposes) and I have a question. I have a command whose input is deliberately unescaped and I am trying to delete a table abusing this mistake. The code is:
Код:
CMD:testtest( playerid, params[] )
{
TestT( "asd", params );
return 1;
}
TestT(nme[], tst[])
{
format(query, sizeof(query), "INSERT INTO `test` (`asdfg`, `fghij`) VALUES ('%s', '%s')", nme, tst);
mysql_query(query);
return 1;
}
Код:
/testtest fgh'); DROP TABLE `example`;-- Код:
[23:44:38] CMySQLHandler::Query(INSERT INTO `test` (`asdfg`, `fghij`) VALUES ('asd', 'fgh'); DROP TABLE `example`;-- ')) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE malibusux;-- ')' at line 1)
|
However, that doesn't mean, that you are now completely safe against SQL injections. There are still ways to cause damage without using multiple SQL statements.
Re: [REL] MySQL Plugin (Now on github!) - Reynolds - 14.07.2014
I totally understand that merely disabling multiple queries won't make my system secure, I just wasn't sure why there was an error given for a seemingly valid query.
Re: [REL] MySQL Plugin (Now on github!) - caoraivoso3 - 19.07.2014
the setkey function sets the variable from orm to the table?
like i use the cache insert id to get the autoincriment id then i use the setkey to set the key to the table and use it on the next query to save other variables. it is right?
edit:
I think i fix the last problem I just save the thing iwth the function but i still have a problem
I get this error
[ERROR] CMySQLQuery::Execute[OnAccountCreate] - (error #1062) Duplicate entry '33' for key 'PRIMARY'.
I dont know why this is giving me errors in this function i have
g_PlayerInfo[playerid][pSQLid] = cache_insert_id();
and this is called in this other function
orm_insert(g_PlayerInfo[playerid][ORM_ID], "OnAccountCreate", "d", playerid);.
any idea?
Re : [REL] MySQL Plugin (Now on github!) - S4t3K - 19.07.2014
I think you have forgotten to use orm_setkey before.
Re: [REL] MySQL Plugin (Now on github!) - IKnowWhatIAmDoing - 20.07.2014
I want to update to R39-2 But I got a lot of errors, can someone tell me what should I replace these with?
Quote:
|
(900) : error 017: undefined symbol "mysql_store_result" (901) : error 017: undefined symbol "mysql_num_rows" (361  : error 017: undefined symbol "mysql_store_result"(3619) : error 017: undefined symbol "mysql_num_rows" (3621) : error 017: undefined symbol "mysql_fetch_row" (3627) : error 017: undefined symbol "mysql_free_result" (6895) : error 017: undefined symbol "mysql_store_result" (6896) : error 017: undefined symbol "mysql_num_rows" (689 : error 017: undefined symbol "mysql_fetch_row"(6904) : error 017: undefined symbol "mysql_free_result" (11143) : error 017: undefined symbol "mysql_store_result" (11144) : error 017: undefined symbol "mysql_num_rows" (11146) : error 017: undefined symbol "mysql_fetch_row" (1114 : error 017: undefined symbol "mysql_get_field"(11154) : error 017: undefined symbol "mysql_free_result" (11167) : error 017: undefined symbol "mysql_store_result" (1116 : error 017: undefined symbol "mysql_fetch_row"(11170) : error 017: undefined symbol "mysql_get_field" (11171) : error 017: undefined symbol "mysql_get_field" (1118 : error 017: undefined symbol "mysql_store_result"(11189) : error 017: undefined symbol "mysql_fetch_row" (11191) : error 017: undefined symbol "mysql_get_field" (11192) : error 017: undefined symbol "mysql_get_field" (11232) : error 017: undefined symbol "mysql_store_result" (11233) : error 017: undefined symbol "mysql_num_rows" (11235) : error 017: undefined symbol "mysql_fetch_row" |