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!

Account registration

Newbie Spellweaver
Joined
Nov 18, 2018
Messages
38
Reaction score
11
I've managed to set everything up, but now I'm having issues with account creation using GM Tools OR directly in DB - Code:
Code:
Exec dbo.cabal_tool_registeraccount 'user' , 'pass'
And I get following error:
Code:
Msg 8152, Level 16, State 30, Procedure dbo.cabal_tool_registeraccount, Line 6 [Batch Start Line 0]
String or binary data would be truncated.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure dbo.cabal_tool_registeraccount, Line 12 [Batch Start Line 0]
Cannot insert the value NULL into column 'UserNum', table 'Account.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row affected)

TDChien88's tools:
Code:
---------------------------
.: Execute Stored Procedures :.
---------------------------
Error. 

 

String or binary data would be truncated.

Cannot insert the value NULL into column 'UserNum', table 'Account.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.

Cannot insert the value NULL into column 'UserNum', table 'CabalCash.dbo.CashAccount'; column does not allow nulls. INSERT fails.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.
---------------------------
OK   
---------------------------

And BeGa's Tools:
Code:
---------------------------
CRITICAL
---------------------------
An critical error occured while creating the account! Closing form...
---------------------------
OK   
---------------------------
I've tried a few things but nothing really helped. I'm using toast2250's DB.

------------------------------------------------------------------
Fixed it ... Somehow. No idea how. And now I can't connect to the server YAY! :D
 
Last edited:
Banned
Banned
Joined
Apr 13, 2014
Messages
734
Reaction score
76
I've managed to set everything up, but now I'm having issues with account creation using GM Tools OR directly in DB - Code:
Code:
Exec dbo.cabal_tool_registeraccount 'user' , 'pass'
And I get following error:
Code:
Msg 8152, Level 16, State 30, Procedure dbo.cabal_tool_registeraccount, Line 6 [Batch Start Line 0]
String or binary data would be truncated.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure dbo.cabal_tool_registeraccount, Line 12 [Batch Start Line 0]
Cannot insert the value NULL into column 'UserNum', table 'Account.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row affected)

TDChien88's tools:
Code:
---------------------------
.: Execute Stored Procedures :.
---------------------------
Error. 

 

String or binary data would be truncated.

Cannot insert the value NULL into column 'UserNum', table 'Account.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.

Cannot insert the value NULL into column 'UserNum', table 'CabalCash.dbo.CashAccount'; column does not allow nulls. INSERT fails.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.
---------------------------
OK   
---------------------------

And BeGa's Tools:
Code:
---------------------------
CRITICAL
---------------------------
An critical error occured while creating the account! Closing form...
---------------------------
OK   
---------------------------
I've tried a few things but nothing really helped. I'm using toast2250's DB.

------------------------------------------------------------------
Fixed it ... Somehow. No idea how. And now I can't connect to the server YAY! :D

logs.
 
Upvote 0
Newbie Spellweaver
Joined
Nov 18, 2018
Messages
38
Reaction score
11
DBAgent_01.log
[Sun Apr 14 2019 00:29:11.333063 4151506688]: open log file '/var/log/cabal/DBAgent_01.log'
[Sun Apr 14 2019 00:29:11.333132 4151506688]: LOG LEVEL: 3
[Sun Apr 14 2019 00:29:11.333152 4151506688]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Apr 14 2019 00:29:11.333282 4151506688]: Seed: 1024247739
[Sun Apr 14 2019 00:29:11.333715 4151506688]: Start DBAgent_01 Server
[Sun Apr 14 2019 00:29:11.334218 4151506688]: UseEcryptText (Off)
[Sun Apr 14 2019 00:29:11.334238 4151506688]: UseQueryTimeOutSec (0)
[Sun Apr 14 2019 00:29:11.334250 4151506688]: CacheUserDataKeepMin (60)
[Sun Apr 14 2019 00:29:11.334726 4151506688]: ServerType(233): 5 Threads
[Sun Apr 14 2019 00:29:11.334841 4151506688]: try listening 38181 port
[Sun Apr 14 2019 00:29:11.338334 4012985152]: CProcessLayer(0)::svc Start [4012985152]
[Sun Apr 14 2019 00:29:11.340182 4096912192]: CProcessLayer(0)::svc Start [4096912192]
[Sun Apr 14 2019 00:29:11.340286 4130483008]: CProcessLayer(0)::svc Start [4130483008]
[Sun Apr 14 2019 00:29:11.340329 4080126784]: CProcessLayer(0)::svc Start [4080126784]
[Sun Apr 14 2019 00:29:11.340357 4004592448]: CProcessLayer(0)::svc Start [4004592448]
[Sun Apr 14 2019 00:29:11.340397 4071734080]: CProcessLayer(0)::svc Start [4071734080]
[Sun Apr 14 2019 00:29:11.340162 4038163264]: CProcessLayer(0)::svc Start [4038163264]
[Sun Apr 14 2019 00:29:11.340422 4063341376]: CProcessLayer(0)::svc Start [4063341376]
[Sun Apr 14 2019 00:29:11.340592 4122090304]: CProcessLayer(0)::svc Start [4122090304]
[Sun Apr 14 2019 00:29:11.340627 4113697600]: CProcessLayer(0)::svc Start [4113697600]
[Sun Apr 14 2019 00:29:11.340653 4088519488]: CProcessLayer(0)::svc Start [4088519488]
[Sun Apr 14 2019 00:29:11.340679 4147268416]: CProcessLayer(0)::svc Start [4147268416]
[Sun Apr 14 2019 00:29:11.340707 4105304896]: CProcessLayer(0)::svc Start [4105304896]
[Sun Apr 14 2019 00:29:11.340732 4029770560]: CProcessLayer(0)::svc Start [4029770560]
[Sun Apr 14 2019 00:29:11.340772 4054948672]: CProcessLayer(0)::svc Start [4054948672]
[Sun Apr 14 2019 00:29:11.340883 3987807040]: CProcessLayer(0)::svc Start [3987807040]
[Sun Apr 14 2019 00:29:11.340242 4046555968]: CProcessLayer(0)::svc Start [4046555968]
[Sun Apr 14 2019 00:29:11.340219 4138875712]: CProcessLayer(0)::svc Start [4138875712]
[Sun Apr 14 2019 00:29:11.340970 3996199744]: CProcessLayer(0)::svc Start [3996199744]
[Sun Apr 14 2019 00:29:11.341021 4021377856]: CProcessLayer(0)::svc Start [4021377856]
[Sun Apr 14 2019 00:29:22.355472 4012985152]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Apr 14 2019 00:29:22.355528 4012985152]: [##ERROR##] DB ERROR(CODE) : 20009
[Sun Apr 14 2019 00:29:22.355539 4012985152]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 14 2019 00:29:22.355548 4012985152]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sun Apr 14 2019 00:29:22.355558 4012985152]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 14 2019 00:29:22.355567 4012985152]: [##ERROR##] Database Connect Fail ((null))
[Sun Apr 14 2019 00:29:22.355594 4012985152]: [##ERROR##] check 'pDB' fail
[Sun Apr 14 2019 00:29:22.355603 4012985152]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sun Apr 14 2019 00:29:32.349594 4130483008]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Apr 14 2019 00:29:32.349655 4130483008]: [##ERROR##] DB ERROR(CODE) : 20009
[Sun Apr 14 2019 00:29:32.349667 4130483008]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 14 2019 00:29:32.349678 4130483008]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sun Apr 14 2019 00:29:32.349688 4130483008]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 14 2019 00:29:32.349699 4130483008]: [##ERROR##] Database Connect Fail ((null))
[Sun Apr 14 2019 00:29:32.349711 4130483008]: [##ERROR##] check 'pDB' fail
[Sun Apr 14 2019 00:29:32.349721 4130483008]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sun Apr 14 2019 00:29:32.961288 4151506688]: success accept 8(127.0.0.1:48790)
[Sun Apr 14 2019 00:29:32.961673 4151506688]: 1.open user 8 [913D570] (127.0.0.1)
[Sun Apr 14 2019 00:29:32.964473 4151506688]: 1.close user 8 [913D570] (127.0.0.1)
I tried pinging Win -> CentOS -> Win, works fine. That's the only log file w/ errors.
 
Upvote 0
Junior Spellweaver
Joined
Mar 2, 2008
Messages
170
Reaction score
17
[##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

centos need to install unixodbc
 
Upvote 0
Back
Top