Account registration

Printable View

11-04-19
Galaeron

Account registration

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:

Spoiler:

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:

Spoiler:

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:

Spoiler:

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
13-04-19
Myster Dev

Re: Account registration

Quote:

Originally Posted by Galaeron

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:

Spoiler:

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:

Spoiler:

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:

Spoiler:

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.
14-04-19
Galaeron

Re: Account registration

DBAgent_01.log

Spoiler:

[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.
18-04-19
ijoo

Re: Account registration

[##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

centos need to install unixodbc
19-04-19
samus

Re: Account registration

account db , have a bad procedure