Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Cannot login

Newbie Spellweaver
Joined
Feb 21, 2008
Messages
65
Reaction score
0
The server is started and no errors on logs... the problem is i cant login... im using chumpy's repack...

when i login, it will say invalid account if password/username is invalid but if i enter the correct username and password (which i registered) it say server connection failed?
 
Newbie Spellweaver
Joined
Feb 21, 2008
Messages
65
Reaction score
0
applied it already sir...
i guess i found the error:
Code:
EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'.

how to fix this?
 
Upvote 0
The Cat in the Hat
Legend
Joined
Oct 26, 2005
Messages
4,475
Reaction score
677
I should have watched my mouth and not said/talked poop to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.
 
Upvote 0
Newbie Spellweaver
Joined
Jun 14, 2007
Messages
50
Reaction score
0
EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'" You need to add md5 to your database, search the forum and you`ll find the soulution.

That's not the fix. You need to make the cabal user being the owner of the db, or even better don't make the user name cabal, make it cabalserver.
 
Upvote 0
Newbie Spellweaver
Joined
Feb 21, 2008
Messages
65
Reaction score
0
i added the xp_md5.dll already sir...

ill try...
so it means on the security i will add a user named 'cabal'?

log from the GlobalDBAgent.
Code:
[Thu Aug 28 2008 22:56:58.341572 3013094304]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:56:58.548548 3013094304]: Database Connect success!
[Thu Aug 28 2008 22:56:58.548689 3013094304]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:56:58.548729 3013094304]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 22:57:47.928933 3044563872]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 22:57:47.929256 3044563872]: [##ERROR##] DB ERROR(MSG)      : [                                             FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'mast                                             er', owner 'dbo'.
[Thu Aug 28 2008 22:57:47.929593 3044563872]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 22:57:47.929618 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 22:57:47.929642 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 22:57:47.929666 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:57:49.663280 3044563872]: Database Connect success!
[Thu Aug 28 2008 22:57:49.663847 3044563872]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:57:49.663881 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 22:58:28.712963 3065543584]: Database Connect success!
[Thu Aug 28 2008 22:58:31.252684 3065543584]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 22:58:31.254681 3065543584]: [##ERROR##] DB ERROR(MSG)      : [                                             FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'mast                                             er', owner 'dbo'.
[Thu Aug 28 2008 22:58:31.255104 3065543584]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 22:58:31.255130 3065543584]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 22:58:31.255155 3065543584]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 22:58:31.255180 3065543584]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:58:31.321598 3065543584]: Database Connect success!
[Thu Aug 28 2008 22:58:31.321717 3065543584]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:58:31.322586 3065543584]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 22:59:19.278500 3055053728]: Database Connect success!
[Thu Aug 28 2008 22:59:20.460417 3055053728]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 22:59:20.468367 3055053728]: [##ERROR##] DB ERROR(MSG)      : [COLOR="Red"][FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'[/COLOR].
[Thu Aug 28 2008 22:59:20.468432 3055053728]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 22:59:20.469048 3055053728]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 22:59:20.469073 3055053728]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 22:59:20.469184 3055053728]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:59:20.977054 3055053728]: Database Connect success!
[Thu Aug 28 2008 22:59:20.977168 3055053728]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:59:20.977207 3055053728]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 23:03:08.763901 3055053728]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 23:03:08.764329 3055053728]: [##ERROR##] DB ERROR(MSG)      : [COLOR="Red"][FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'.[/COLOR]
[Thu Aug 28 2008 23:03:08.764359 3055053728]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 23:03:08.764384 3055053728]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 23:03:08.764409 3055053728]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 23:03:08.764433 3055053728]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 23:03:08.815403 3055053728]: Database Connect success!
[Thu Aug 28 2008 23:03:08.815905 3055053728]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 23:03:08.815952 3055053728]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
 
Upvote 0
Newbie Spellweaver
Joined
Jun 14, 2007
Messages
50
Reaction score
0
Listen:
The user that will access the sql gotta have a different name than cabal. I have it cabalserver. You need to give full access to this user, he needs to be a sysadmin and also db_owner of the 6 cabal db and the master db.
 
Upvote 0
Newbie Spellweaver
Joined
Feb 21, 2008
Messages
65
Reaction score
0
i found the solution sir... thanks for your tips...
what i did is, i set my (db user account) as the owner of master database, then puf....i can now log in...thanks...
 
Upvote 0
Back
Top