Gamedbd Process Issue

[nofxpunkerbrian]

I just changed servers its sooo much better than my old one but at least once a day the gamedbd process decides to flop, ive looked into logs incase its in game issues that could be causing this but its not does anyone know what might be causing this?

[MentaL]

[rbb138]

oO never had any problems with gamedbd.
does it crash if theres only 1 person online?

[das7002]

Im sure you probably know this already because you run a large server... but gamedbd is a finicky little bastard of a process, it likes to crash for seemingly no reason, Id double check all the IP addr's in the configs and start it manually and watch what it does.

[nofxpunkerbrian]

yea ive been running some tests and its related to a java issue, I run some scripts which look up the character info for the people which it uses the gamedbd to read and some people have been deliberately doing it over and over spamming till the process falls, i located the errors actually in java.

[rbb138]

you were exporting from gamedbd every time? oO
export all data to mysql everyday, job done.

oh btw remember that list.jsp i gave you and i said i do it manually so it doesnt brake the chineese names and you managed to put a export to mysql into it,
yea i found out i can just use wget for that /facepalm

[das7002]

you were exporting from gamedbd every time? oO
export all data to mysql everyday, job done.

pwAdmin reads from gamedbd everytime, I don't see why that would be that big of an issue, unless it really truly is that amazingly unstable

[343]

but normal users don't have access to pwAdmin. I would imagine if normal users had access to something that called on it, and enough people were using it, or one person with ill intent, it could cause it to crash, I could see that :)

[das7002]

but normal users don't have access to pwAdmin. I would imagine if normal users had access to something that called on it, and enough people were using it, or one person with ill intent, it could cause it to crash, I could see that :)

But the game also calls to it all the time as well, idk... maybe its just the protocol java class that has bugs in it that make the damn thing crash, would be wonderful if gamedbd was just a unix socket to mysql

[nofxpunkerbrian]

The code isnt unstable its being deliberately spammed over and over ive put an IP track on now to see whos doing what and see if its just outsiders doing it.

[rbb138]

pwAdmin reads from gamedbd everytime, I don't see why that would be that big of an issue, unless it really truly is that amazingly unstable

no, but imagine a public page that draws info from gamedbd?
now imagine that page refreshed 20 times a second?

hence the exploit.

[nofxpunkerbrian]

im almost finished something:

- User goes to the page which shows the char info.
- If information is incorrect and needs updating user can click update.
- Information updates and is put into sql db.
- The Information is displayed as sql instead of rolebean information which means less stress on gamedbd process.

Limits is the user can only press the link once a day and when pressing the link information is logged such as the account name and the IP etc so I can find people doing this issue deliberately.

[pastime4u]

good luck with that :D

[rbb138]

im almost finished something:

- User goes to the page which shows the char info.
- If information is incorrect and needs updating user can click update.
- Information updates and is put into sql db.
- The Information is displayed as sql instead of rolebean information which means less stress on gamedbd process.

Limits is the user can only press the link once a day and when pressing the link information is logged such as the account name and the IP etc so I can find people doing this issue deliberately.

or you could just run it daily and make them wait.

[vinicius.edson]

or you could just run it daily and make them wait.

I do it with my rank page. I manually update it one time each day.

[das7002]

I do it with my rank page. I manually update it one time each day.

you could just add

@daily refreshcommandgoeshere

In your crontab

OR if your cron doesn't support @daily use, 0 0 * * *