Dekaron Real act9 7 clases crash cast and session

[Sirazuka]

Good afternoon to all, I have this problem with my server dekaron action 9 7 classes.

Install sql 2012, enable tcp, and put the gamehi registry, put the queries due in the query analyzer. I checked the user information and password in all the configuration files and at the start cast and session server crash and in the dbug I get this.

 Spoiler

00000000 0.00000000 [2592] [ DEADFRONT QUERY ALARM REGIST ]
00000001 0.00110300 [2592] <--------------- CastServer Started --------------->
00000002 12.30374718 [2592] [ DEADFRONT QUERY CALL ]
00000003 16.86771965 [2592] [CRITICAL ERROR] [SP_GUILD_SERVER_ID_SET] [ErrorCode : 4]
00000004 28.96120262 [2592] [ CRITICAL ERROR ] [ SP_DEADFRONT_INFO ] [ METHOD CODE : 4 ]
00000005 28.96126366 [2592] .\DeadFront\Provider.cpp(58) :
00000006 28.96129990 [2592] CastServer:eadFront::Provider::Release
00000007 28.96133423 [2592] .\DeadFront\Provider.cpp(58) :
00000008 28.96136665 [2592] .\DeadFront\Provider.cpp(58) : Wed May 11 15:59:34 2011
00000009 43.83870697 [3540] [ DEADFRONT QUERY ALARM REGIST ]
00000010 43.83929443 [3540] <--------------- CastServer Started --------------->
00000011 55.66291046 [3540] [ DEADFRONT QUERY CALL ]
00000012 60.67944336 [3540] [CRITICAL ERROR] [SP_GUILD_SERVER_ID_SET] [ErrorCode : 4]
00000013 72.31963348 [3540] [ CRITICAL ERROR ] [ SP_DEADFRONT_INFO ] [ METHOD CODE : 4 ]
00000014 72.31969452 [3540] .\DeadFront\Provider.cpp(58) :
00000015 72.31972504 [3540] CastServer:eadFront::Provider::Release
00000016 72.31975555 [3540] .\DeadFront\Provider.cpp(58) :
00000017 72.31978607 [3540] .\DeadFront\Provider.cpp(58) : Wed May 11 15:59:34 2011

Please some idea of ​​why it gives this error, it is possible to say that I came out with sql 2008 r2 and so reinstall with sql 2012 and it happens the same.

Please thank you for helping me solve this problem. Thank you very much.

[ViihJana]

Check again and be sure if tcp/udp is enabled .
If the error was "\... Provider etc " that means you dont have RAM to load the files so here is a solution :
1. Click Start.
2. Select Control Panel.
3. Select System.
4. Click the Advanced tab.
5. In the Performance region, select Settings.
6. Click the Advanced and Virtual memory click on Change button.
7. Check the box saying "Custom size" and add the gb that u wanna take from disk C:/ or D:/
8. Click Apply and Reboot

[Underfisk]

The problem of provider is not allways a certain, he may need to check the connection to db because the error is [Critical Error] connecting with Deadfront info and server_id

[Sirazuka]

Originally Posted by ViihJana

Check again and be sure if tcp/udp is enabled .
If the error was "\... Provider etc " that means you dont have RAM to load the files so here is a solution :
1. Click Start.
2. Select Control Panel.
3. Select System.
4. Click the Advanced tab.
5. In the Performance region, select Settings.
6. Click the Advanced and Virtual memory click on Change button.
7. Check the box saying "Custom size" and add the gb that u wanna take from disk C:/ or D:/
8. Click Apply and Reboot

the Virtual Machine have 20 gb ram :/

[freez00]

Both the Cast and Session connect to the database. The database is the error. Make sure your username and password is correct to the database.

[Sirazuka]

Im fixed! i need install microsoft windows 2012 r2 and sql 2014 english version!!!

[ViihJana]

Nice

[[DEV]Dekaron]

Originally Posted by Sirazuka

Im fixed! i need install microsoft windows 2012 r2 and sql 2014 english version!!!

if cast get crash thats mean you put wrong pass or login in config.
second thing can be this you don't correct Permissions to character DB
and last thing what can be wrong you don't turn on TCP/IP in Sql Server Configuration Manager.
You don't need install SQL 2012 or 2014

[tiaguim]

Originally Posted by [DEV]Dekaron

if cast get crash thats mean you put wrong pass or login in config.
second thing can be this you don't correct Permissions to character DB
and last thing what can be wrong you don't turn on TCP/IP in Sql Server Configuration Manager.
You don't need install SQL 2012 or 2014

WOOOOOOW THANKS A LOT MAN! Helped me with the Cast Server!

[[DEV]Dekaron]

no problem tiaguim

[ShadowDeka]

Does any know how to fix this pls help I triple checked IP, username and password are all the same but session can't connect to server.
23:50:04 1104 CastServer Started
23:50:07 1084 .\Provider.cpp(124) :
23:50:07 1084 <--------------- BillingServer Started --------------->
23:50:11 0908 .\GameChu\Provider.cpp(22) :
23:50:11 0908 [Module] [Japan GameChu Login module loading Success...]
23:50:11 0908 .\Provider.cpp(124) :
23:50:11 0908 <--------------- LoginServer Started --------------->
23:50:11 0908 .\Server\Account\Provider.cpp(74) :
23:50:11 1084 .\Client\Provider.cpp(74) :
23:50:11 0908 ------------------ Connect Account Server IP : [ 127.0.0.1 ] ------------------
23:50:11 1084 ------------------ [ ONOPEN ] [ CONNECT GAMESERVER IP ] : [ 127.0.0.1 ] ------------------
23:50:13 016C .\Provider.cpp(124) :
23:50:13 016C <--------------- MsgServer Started --------------->
23:50:19 0CE0 .\World\Provider.cpp(26) :
23:50:19 0CE0 [WORLD::Provider][Update is TRUE.]
23:50:19 0CE0 .\Provider.cpp(124) :
23:50:19 0CE0 <--------------- SessionServer Started --------------->
23:50:21 1084 .\Client\State\Init.cpp(41) :
23:50:21 1084 [Init::OnPacket] [Invalid Packet : 10083]
23:50:21 1104 Provider::initialize()
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
23:50:21 1104 [CRITICAL ERROR] SP_GUILD_SERVER_ID_SET SUCCESS
23:50:25 0908 .\Server\Session\Provider.cpp(106) :
23:50:25 0908 ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
23:50:37 0CE0 .\World\Provider.cpp(234) :
23:50:37 0CE0 [World OnMethod] [Critical Error SP_LOGIN_FLAG_SET is fail] [Code : 4]
23:50:37 0CE0 .\World\Provider.cpp(237) :
23:50:37 0CE0 Session::World::Provider::loginFlagSet
23:50:37 0CE0 .\World\Provider.cpp(237) :
23:50:37 0CE0 .\World\Provider.cpp(237) : Wed May 11 16:02:27 2011

[tiaguim]

Originally Posted by ShadowDeka

Does any know how to fix this pls help I triple checked IP, username and password are all the same but session can't connect to server.
23:50:04 1104 CastServer Started
23:50:07 1084 .\Provider.cpp(124) :
23:50:07 1084 <--------------- BillingServer Started --------------->
23:50:11 0908 .\GameChu\Provider.cpp(22) :
23:50:11 0908 [Module] [Japan GameChu Login module loading Success...]
23:50:11 0908 .\Provider.cpp(124) :
23:50:11 0908 <--------------- LoginServer Started --------------->
23:50:11 0908 .\Server\Account\Provider.cpp(74) :
23:50:11 1084 .\Client\Provider.cpp(74) :
23:50:11 0908 ------------------ Connect Account Server IP : [ 127.0.0.1 ] ------------------
23:50:11 1084 ------------------ [ ONOPEN ] [ CONNECT GAMESERVER IP ] : [ 127.0.0.1 ] ------------------
23:50:13 016C .\Provider.cpp(124) :
23:50:13 016C <--------------- MsgServer Started --------------->
23:50:19 0CE0 .\World\Provider.cpp(26) :
23:50:19 0CE0 [WORLD::Provider][Update is TRUE.]
23:50:19 0CE0 .\Provider.cpp(124) :
23:50:19 0CE0 <--------------- SessionServer Started --------------->
23:50:21 1084 .\Client\State\Init.cpp(41) :
23:50:21 1084 [Init::OnPacket] [Invalid Packet : 10083]
23:50:21 1104 Provider::initialize()
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
23:50:21 1104 [CRITICAL ERROR] SP_GUILD_SERVER_ID_SET SUCCESS
23:50:25 0908 .\Server\Session\Provider.cpp(106) :
23:50:25 0908 ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
23:50:37 0CE0 .\World\Provider.cpp(234) :
23:50:37 0CE0 [World OnMethod] [Critical Error SP_LOGIN_FLAG_SET is fail] [Code : 4]
23:50:37 0CE0 .\World\Provider.cpp(237) :
23:50:37 0CE0 Session::World::Provider::loginFlagSet
23:50:37 0CE0 .\World\Provider.cpp(237) :
23:50:37 0CE0 .\World\Provider.cpp(237) : Wed May 11 16:02:27 2011

@ You probably know how to solve this

[[DEV]Dekaron]

Any way you can change port to what port you want but remember make changes inside config files for cast session and other where is setup port 1433