• MySQL and Ulib
    13 replies, posted
Does anyone know of a working MySQL intergration for ULiB? I have been trying to make one myself but I didn't succeed (using the base of MrPresident form Ulysses). Would be really appreciated if someone could help me out!
Elaborate...
[QUOTE=Fillipuster;50409361]Elaborate...[/QUOTE] Please do not spam on my topic, I'm trying to learn Lua and getting things fixed. If you just want to raise your post count, go to a different topic please.
[QUOTE=djrefor;50409656]Please do not spam on my topic, I'm trying to learn Lua and getting things fixed. If you just want to raise your post count, go to a different topic please.[/QUOTE] I'm sorry if you mis-understood me. By "elaborate" I meant explain your problem further/in more detail. I didn't quite understand your problem.
Good attitude, good use of examples and definition of your problem, and good job at jumping to conclusions. Also "spam" isn't when someone posts on your thread once. [URL="http://www.dictionary.com/browse/elaborate"]Elaborate[/URL]
[QUOTE=Fillipuster;50409669]I'm sorry if you mis-understood me. By "elaborate" I meant explain your problem further/in more detail. I didn't quite understand your problem.[/QUOTE] My english failed me in that case. I thought you meant something like develop it yourself. I'm sorry for the misunderstanding. Ontopic: I have a problem that my ULiB freezes/locks my server when someone joins (or whenever it checks for permissions/groups) because it's reading all the .txt files. I've read that with using a MySQL database to store all the data, this won't happen anymore.
[QUOTE=djrefor;50409721] Ontopic: I have a problem that my ULiB freezes/locks my server when someone joins (or whenever it checks for permissions/groups) because it's reading all the .txt files. I've read that with using a MySQL database to store all the data, this won't happen anymore.[/QUOTE] It shouldn't lag unless the hard drive on the computer is ridiculously slow or your have a huge database of users. Using MySQL could fix this problem, though it depends on how it's implemented.
[QUOTE=bigdogmat;50409806]It shouldn't lag unless the hard drive on the computer is ridiculously slow or your have a huge database of users. Using MySQL could fix this problem, though it depends on how it's implemented.[/QUOTE] They are pretty fast hard drives and I resetted the database so it only has 1 user in it, but it still causes problems. (the problems disappear when I remove ULX and ULiB and I also did a full reinstall of both of them).
[QUOTE=djrefor;50409816]They are pretty fast hard drives and I resetted the database so it only has 1 user in it, but it still causes problems. (the problems disappear when I remove ULX and ULiB and I also did a full reinstall of both of them).[/QUOTE] Then its probably other addons I recommend using one of these to find the problem [url]https://facepunch.com/showthread.php?t=1518412[/url] [url]https://facepunch.com/showthread.php?t=1517058[/url]
[QUOTE=rtm516;50414180]Then its probably other addons I recommend using one of these to find the problem [url]https://facepunch.com/showthread.php?t=1518412[/url] [url]https://facepunch.com/showthread.php?t=1517058[/url][/QUOTE] FProfiler shows me that its ULiB (shows around 500 ms on ULiB and the next most used function is around 20 ms). So I have no clue what a good fix would be, except from ULiB supporting MySQL.
[QUOTE=djrefor;50409721]My english failed me in that case. I thought you meant something like develop it yourself. I'm sorry for the misunderstanding. Ontopic: I have a problem that my ULiB freezes/locks my server when someone joins (or whenever it checks for permissions/groups) because it's reading all the .txt files. I've read that with using a MySQL database to store all the data, this won't happen anymore.[/QUOTE] ULiB does not continually re-read savedata on player join. And if it did, and if it actually gave each user their own file, it would refer directly to that users file using a derivative of their steamid in the file name. I don't think mysql would solve your problem, you're probably seeing something else and have mis-diagnosed the problem. MySQL is not only slower and has no native support nor publicly available addons for the functionality, it's also only useful if you are hosting multiple servers off the same database. From different machines. Elaborating on Fillipusters request for you to elaborate, let me ask the following questions. Question 1: How do you know for 100% certain that it is ULiB? Question 2: If you are getting errors showing you it's ULiB, can you please post them? Question 3: Show us your addons please Question 4: When you say "freeze/locking", does your server freeze and crash? is it a short lag spike? Be more descriptive please. And finally, i think this needs to be said. [QUOTE=djrefor;50409656]Please do not spam on my topic, I'm trying to learn Lua and getting things fixed. If you just want to raise your post count, go to a different topic please.[/QUOTE] You had given us no information at all that we can actually use to help you, and leaves me with the feeling that you yourself are "spamming to raise your post count". You contributed absolutely nothing to your own support request with that statement, and made yourself out to be a total jerk. I almost don't want to help you because of this. We are not mind readers.
[QUOTE=Pyro-Fire;50438354]ULiB does not continually re-read savedata on player join. And if it did, and if it actually gave each user their own file, it would refer directly to that users file using a derivative of their steamid in the file name. I don't think mysql would solve your problem, you're probably seeing something else and have mis-diagnosed the problem. MySQL is not only slower and has no native support nor publicly available addons for the functionality, it's also only useful if you are hosting multiple servers off the same database. From different machines. Elaborating on Fillipusters request for you to elaborate, let me ask the following questions. Question 1: How do you know for 100% certain that it is ULiB? Question 2: If you are getting errors showing you it's ULiB, can you please post them? Question 3: Show us your addons please Question 4: When you say "freeze/locking", does your server freeze and crash? is it a short lag spike? Be more descriptive please. And finally, i think this needs to be said. You had given us no information at all that we can actually use to help you, and leaves me with the feeling that you yourself are "spamming to raise your post count". You contributed absolutely nothing to your own support request with that statement, and made yourself out to be a total jerk. I almost don't want to help you because of this. We are not mind readers.[/QUOTE] Answer 1: Because when I only run ULiB and ULX, the server still shows a lag spike but smaller. And also because FProfiler tells me. Answer 2: I don't get any errors. Answer 3: As answered in answer 1, I tested the server with only ULX, ULiB and the map. Answer 4: It's like a lag spike, where the server doesn't respond on anything while it's happening. And about your last comment, I apologized that I didn't want to respond like that. The reason I thought he ment something else is because the word translated to something different in my langauge. But if I would have read further in the translations I would've found out he ment something else.
This is kinda obvious, but have you tried reinstalling ulib?
[QUOTE=danker pepers;50444995]This is kinda obvious, but have you tried reinstalling ulib?[/QUOTE] Yes and also tried reinstalling GMOD
Sorry, you need to Log In to post a reply to this thread.