Connection error | Blocking users from connecting | Hack/Bug?

[awesomo]

So let me explain. I connect to my server; after I type username and password and try to login I get a connection error.

If you look at the online users list on my website you can see there are two accounts logged in even when they are offline on the gameserver. This connection error always happens when the website says people are online; ingame since: never.

I'm guessing this is done deliberately to block users from accessing my server...
Does anyone have an idea on how to solve this problem?




http://i.imgur.com/YIPEFzK.jpg

[MentaL]

[Masteru]

-Maybe is Flood Cs-

-Try and create good security for MuServer-

[DragonSeth]

Have you tried making new account and testing? and if im correct 11.72.80 TT files most likely greek bladers if so hes files have bugs sometimes need to restore databases need to restart server and other stuff!

[awesomo]

Have you tried making new account and testing? and if im correct 11.72.80 TT files most likely greek bladers if so hes files have bugs sometimes need to restore databases need to restart server and other stuff!

Yep. Doesn't work.
Need to restart PC for it to work again.

[DragonSeth]

try adding me on skype i can see what i can do for you if i can't get it to work idk lol

NVM.Someone else can help him

[awesomo]

If anyone can help, without asking me for my password, be my guest.

[MrQU3ST10N]

don't open the LINKS to fast. that's the result of having connection error..

also if there's still online even if the server is off execute this code :

UPDATE MEMB_STAT SET ConnectStat = 0

[awesomo]

don't open the LINKS to fast. that's the result of having connection error..

also if there's still online even if the server is off execute this code :

UPDATE MEMB_STAT SET ConnectStat = 0

I'll try it next time the problem occurs. Thank you for replying.

[KarLi]

Check your SCFEXDB if tere is any error mate , or exdb whatever you use.

[awesomo]

Check your SCFEXDB if tere is any error mate , or exdb whatever you use.

EXDB didn't have any error. Titanlinkserver does though.
SQLSTATE:24000, Diagnosis:[MICROSOFT][SQL Server Native Client 10.0]Invalid cursor state

[KarLi]

Maybe you have to try to configure the ODBC better mate for MuOnline mostly.
else i really dont know , what sql server u use ?

plus: i used to have this issue but then i restarted server and it got fixed.

[awesomo]

MS SQL Server 2008 R2
Using MSSQL instead of ODBC, or isn't that what you are referring to? Argh, I hate this, constantly paranoid that people won't be able to connect.

[KarLi]

I'm sure if you install sql server 2000 and use it instead , since i tested and databases work perfectly with it , there won't be a problem.

Good luck with it mate ;)

[DragonSeth]

Sql 2000 is the most used sql with s6 e3 thats why its most recommend its the best for low seasons but ex702 and above requires higher sql version to function the databases correctly.With these files use sql 2000 i used to use these files i used to get connection error but sometimes my ipv4 address change so i had to re portforward or sometimes i just had to restart server again

Good luck!

[awesomo]

I probably discovered the source of the problem. I looked at the last member/ip that caused this connection error. Both accounts tried to log in simultaneously, so I conclude the server/database bugs when that happens.

Now I've got to figure out how to block two identical ip's from connecting or another solution.



edit: I'm 99% certain.
When I'm connected to the server with my MuOnline Client and I make a change in the database (which requires connecting with the same ip trough SQL Server Management Studio) I also cause a connection error.

[awesomo]

Apparently this is called Multi-boxing: http://en.wikipedia.org/wiki/Multi-boxing

Can't seem to find any solution on google yet, damn :(

- - - Updated - - -

Could be that I fixed it. Some columns were set to Allow Null = false.
And when two identical IP's connect, one IP typically throws Nulls.

source: http://scn.sap.com/thread/1917858

I'll update if it worked.

Edit: I'm pretty sure it's fixed. Players who multibox don't cause problems anymore.