[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
AW: [REL] MySQL Plugin (****** Project) - maddinat0r - 29.05.2013
Because the mutex method was improved, but the improvement only takes effect on Windows machines.
Re: [REL] MySQL Plugin (****** Project) - DaLgakıran - 30.05.2013
https://code.******.com/p/sa-mp-mysq...s/detail?id=25
Can someone help me with this?
Re: [REL] MySQL Plugin (****** Project) - Diamondier - 31.05.2013
I need the mysql.so because my server isn't running on the .dll.
Re: [REL] MySQL Plugin (****** Project) - Pooh7 - 31.05.2013
Quote:
|
Originally Posted by Diamondier
 I need the mysql.so because my server isn't running on the .dll.
|
Re: [REL] MySQL Plugin (****** Project) - Finn707 - 31.05.2013
When using mysql_function_query, what should the format be for retrieving a number such as 131.512? I'm speaking in terms of retrieving x, y, z positions from a table.
AW: Re: [REL] MySQL Plugin (****** Project) - Mellnik - 10.06.2013
Quote:
|
Originally Posted by Calabresi
I don't know if MySQL version has any effects while compiling those plugin files but, I do know that MySQL 5.5 and 5.1 has different mysql.sock directories which is source of my problem. Could you recompile it in MySQL 5.5?
My Ubuntu version is 12.04 by the way. R20 was working fine I think (I couldn't really test it because of my remote and local server OS differences). |
If R20 worked for you, there must be an issue in R24.
Quote:
|
Originally Posted by RealCop228
I don't have a /usr/lib/mysql directory, but /usr/lib exists!
I did install mysql-devel earlier, but that didn't help either. And, this is another version of mysql-devel being installed but again, still not working. I'm at a loss... |
Re: [REL] MySQL Plugin (****** Project) - AndreT - 10.06.2013
yum provides mysqlclient is my source of information (the command which tells me that these files are a part of mysql and mysql-devel).
Also, as you can see, RealCop228 has these files, but in a tad different directory. So what needs to be done is alter the makefile so it says -L/usr/lib, not -L/usr/lib/mysql, as the latter does not exist on his system. I don't know if it'll work, but it is worth a try.
Furthermore, Mellnik, it would be a real honor if you started crediting people for the code and maps that you use without their permission. I'm faithfully yours =)
Re: [REL] MySQL Plugin (****** Project) - Scenario - 10.06.2013
I edited the makefile, but that didn't work either..
EDIT: Okay, I think I got the MySQL files installed into the proper directory now. However, it still doesn't seem to compile...
Quote:
|
[root@orion lib]# cd /usr/lib/mysql [root@orion mysql]# ls libmysqlclient_r.so libmysqlclient.so /usr/bin/ld: cannot find -lmysqlclient_r |
Re: [REL] MySQL Plugin (****** Project) - AndreT - 10.06.2013
Zeex once provided me this link.
It looks like your files are very well present (libmysqlclient_r* files), this means that there must be something wrong (either an inconsistency between the paths with the makefile, or symbolic links not in place).
Also, how did you get the MySQL files into /usr/lib/mysql? Copying them manually would - I assume - break the symbolic links.
But meh, this issue has driven me nuts before a few years ago, I don't know how it solved itself, I was quite ready to cancel all my projects back then
Re: [REL] MySQL Plugin (****** Project) - Scenario - 10.06.2013
I did this command: yum -y groupinstall "MySQL Database client"
It installed the libraries in the [..]/mysql directory automatically. I don't quite know why it's giving me such an issue. I don't know C++, otherwise I would be in the code looking to see what the problem is. Anyways, I would really like to find a resolution to this problem.
Is there a particular directory I need to be compiling plugins in?
Re: [REL] MySQL Plugin (****** Project) - AndreT - 11.06.2013
This is weird, but is not influenced by the code in any way.
If you were to compile without linking against mysqlclient_r (-lmysqlclient_r means the linker looks for libmysqlclient_r.so in the directories specified with -L), it would most likely compile since the MySQL headers exist, but when running the plugin, the headers wouldn't be any use without the library to actually provide these functions.
Try running ldconfig to see if refreshing the cache would solve your issue (afaik this is for runtime though, not sure, but give it a try at least).
There might be something vital I'm missing here, but if it wouldn't bother you, you could also compile a static version of the plugin (a few MBs bigger, I assume), the .a file should be in the repo as well.
Best of luck!
AW: [REL] MySQL Plugin (****** Project) - Mellnik - 11.06.2013
Yes, all my Linux builds are on Ubuntu 10.04 with MySQL 5.1
Re: [REL] MySQL Plugin (****** Project) - Scenario - 11.06.2013
EDIT: Okay, it's compiling now. However, it's the same runtime error I got when I used the downloadable Linux .so on the ****** Project page.
Quote:
|
Failed (plugins/mysql.so: undefined symbol: _ZNSt12out_of_rangeD2Ev) |
EDIT 2: I would also like to point out that I have run the same plugin on a Volt server (they run CentOS 5 IIRC) and the same errors occur.
Re: [REL] MySQL Plugin (****** Project) - DeathKing - 12.06.2013
how do u switch tables for cache_get_row_int etc etc
Ex. users to bans... is there a mysql function?
AW: Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 12.06.2013
Quote:
|
Originally Posted by Calabresi
[...]However, whenever my script tries to execute a "SELECT" query, the server crashes. I have tried many ways and checked many things to be sure about that, INSERT and UPDATE queries just work fine. I am pretty sure nothing else causes the crash.
The most interesting thing is, that crash only happens in my remote Linux server. When I try anything in Windows, it just works fine. I'm using R24 and Ubuntu 12.04. |
Quote:
|
Originally Posted by Chaprnks
What's really odd is I compiled the R24 source on CentOS 6 (x86); then when I try and run it, the "_ZNSt12out_of_rangeD2Ev" error still persists.
|
Quote:
|
Originally Posted by RealCop228
EDIT: Okay, it's compiling now. However, it's the same runtime error I got when I used the downloadable Linux .so on the ****** Project page.
This happens for both the static and non-static builds. EDIT 2: I would also like to point out that I have run the same plugin on a Volt server (they run CentOS 5 IIRC) and the same errors occur. |
Re: [REL] MySQL Plugin (****** Project) - DeathKing - 12.06.2013
while i was changing my mysql server to r24 from r20 i edited the mysql_insert_id to a new one then i compiled it and run the server but when i checked the logs i got this "[00:13:36] [INFO] Now logging: errors" but under it it said nothing and everytime i open my server that happened but i don't know why
Re: [REL] MySQL Plugin (****** Project) - Scenario - 12.06.2013
It does that to let you know what it's going to be logging. You can ignore it if you want to, it means nothing. However, in the event of an error, it'll print that error in that file for you.
Re: [REL] MySQL Plugin (****** Project) - DeathKing - 12.06.2013
ok thx for the info.... ;3
AW: [REL] MySQL Plugin (****** Project) - maddinat0r - 12.06.2013
Just pushed out R25, all the Linux issues should be fixed now.
Re: AW: [REL] MySQL Plugin (****** Project) - IstuntmanI - 12.06.2013
Quote:
|
Originally Posted by Pain123
Just pushed out R25, all the Linux issues should be fixed now.
|
Now Mellnik has to compile it again on linux. xD