Account log service HK

so im attempting to use thethe HK fiesta release, and i can get everything to start except for the AccountLog Service.

here is the failure in debug:

Spoiler:

Code:

---

000002 2015-07-11 10:52:11 Launching the server.....
000003 2015-07-11 10:52:11 Local  Time      7/11/2015 10:52:11 AM
000004 2015-07-11 10:52:11 System Time(UTC) 7/11/2015 5:52:11 PM
000005 2015-07-11 10:52:11 <SUCCESSED SCRIPTOR READ> DataServerInfo_AccountLog.txt
000006 2015-07-11 10:52:11 <I AM THE _Villian_AccountLog_DB, SERVER_ID_DB_ACCOUNTLOG, WorldNo=0, ZoneNo=0>
000007 2015-07-11 10:52:11 Service start(no parameter)
000008 2015-07-11 10:52:11 <IOCP WORKTHREAD #0 RUNNING>
000009 2015-07-11 10:52:11 <IOCP WORKTHREAD #1 RUNNING>
000010 2015-07-11 10:52:11 <IOCP WORKTHREAD #2 RUNNING>
000011 2015-07-11 10:52:11 <IOCP WORKTHREAD #3 RUNNING>
000012 2015-07-11 10:52:11 <IOCP WORKTHREAD #4 RUNNING>
000013 2015-07-11 10:52:11 <IOCP WORKTHREAD #5 RUNNING>
000014 2015-07-11 10:52:12 <IOCP WORKTHREAD #6 RUNNING>
000015 2015-07-11 10:52:12 <IOCP WORKTHREAD #7 RUNNING>
000016 2015-07-11 10:52:12 <IOCP WORKTHREAD #8 RUNNING>
000017 2015-07-11 10:52:12 <IOCP WORKTHREAD #9 RUNNING>
000018 2015-07-11 10:52:12 <NUMBER OF 10 IOCP WORKTHREAD STARTED, 2 CPU DETECTED>
000019 2015-07-11 10:52:12 DB_Init FAILED = DSN=Statistics;        UID=sa;    PWD=[[mypassword]]
000020 2015-07-11 10:52:12 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000021 2015-07-11 10:52:12 < END OF MAIN = 0 >
000022 2015-07-11 10:52:12 <IOCP WORKTHREAD #8 FREE>
000023 2015-07-11 10:52:12 <IOCP WORKTHREAD #0 FREE>
000024 2015-07-11 10:52:12 <IOCP WORKTHREAD #9 FREE>
000025 2015-07-11 10:52:12 <IOCP WORKTHREAD #7 FREE>
000026 2015-07-11 10:52:12 <IOCP WORKTHREAD #6 FREE>
000028 2015-07-11 10:52:12 <IOCP WORKTHREAD #5 FREE>
000029 2015-07-11 10:52:12 <IOCP WORKTHREAD #4 FREE>
000027 2015-07-11 10:52:12 <IOCP WORKTHREAD #1 FREE>
000030 2015-07-11 10:52:12 <IOCP WORKTHREAD #2 FREE>
000031 2015-07-11 10:52:12 <IOCP WORKTHREAD #3 FREE>

---

Spoiler:

View image: Capture

these may be set up like odin but, They have their own names.

https://forum.ragezone.com/cache.php...%2FfI4vMd4.png

even if i remove the _CN from the cofig?

Spoiler:

;
; Server info for RELEASE SERVICE
; 2007.4 By Blacksky
;


#DEFINE NATION_NAME
<STRING>
#ENDDEFINE


#DEFINE WORLD_NAME
<INTEGER>
<STRING>
<STRING>
#ENDDEFINE

#DEFINE SERVER_INFO
<STRING>
<INTEGER>
<INTEGER>
<INTEGER>
<INTEGER>
<STRING>
<INTEGER>
<INTEGER>
<INTEGER>
#ENDDEFINE


#DEFINE ODBC_INFO
<STRING>
<INTEGER>
<INTEGER>
<STRING>
<STRING>
#ENDDEFINE


NATION_NAME "LanteaCorp"


WORLD_NAME 0, "Lantea", "../9Data/Hero"


; DB,Login server ------------------------------------------------------------
SERVER_INFO "PG_Account_DB", 0, 0, 0, 0, "127.0.0.1", 9000, 1, 100
SERVER_INFO "PG_AccountLog_DB", 1, 0, 0, 0, "127.0.0.1", 9005, 1, 100


SERVER_INFO "PG_Login", 4, 0, 0,20, "127.0.0.1", 9010, 50, 200
SERVER_INFO "PG_Login", 4, 0, 0, 5, "127.0.0.1", 9015, 1, 50
SERVER_INFO "PG_Login", 4, 0, 0, 8, "127.0.0.1", 9016, 1, 30


; World #0 -------------------------------------------------------------------
SERVER_INFO "PG_Character_00", 2, 0, 0, 0, "127.0.0.1", 9100, 1, 100
SERVER_INFO "PG_GameLog_00", 3, 0, 0, 0, "127.0.0.1", 9101, 1, 100


SERVER_INFO "PG_WorldManager_00", 5, 0, 0,20, "127.0.0.1", 9110, 200, 2000
SERVER_INFO "PG_WorldManager_00", 5, 0, 0, 6, "127.0.0.1", 9115, 1, 200
SERVER_INFO "PG_WorldManager_00", 5, 0, 0, 8, "127.0.0.1", 9116, 1, 30


SERVER_INFO "PG_Zone_00", 6, 0, 0,20, "127.0.0.1", 9120, 100, 1500
SERVER_INFO "PG_Zone_00", 6, 0, 0, 8, "127.0.0.1", 9121, 1, 30


SERVER_INFO "PG_Zone_01", 6, 0, 1,20, "127.0.0.1", 9122, 100, 1500
SERVER_INFO "PG_Zone_01", 6, 0, 1, 8, "127.0.0.1", 9123, 1, 30


SERVER_INFO "PG_Zone_02", 6, 0, 2,20, "127.0.0.1", 9124, 100, 1500
SERVER_INFO "PG_Zone_02", 6, 0, 2, 8, "127.0.0.1", 9125, 1, 30


SERVER_INFO "PG_Zone_03", 6, 0, 3,20, "127.0.0.1", 9126, 100, 1500
SERVER_INFO "PG_Zone_03", 6, 0, 3, 8, "127.0.0.1", 9127, 1, 30


SERVER_INFO "PG_Zone_04", 6, 0, 4,20, "127.0.0.1", 9128, 100, 1500
SERVER_INFO "PG_Zone_04", 6, 0, 4, 8, "127.0.0.1", 9129, 1, 30


ODBC_INFO "Account", 0, 0, "DSN=Account; UID=sa; PWD=[[my password]]", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog", 1, 0, "DSN=AccountLog; UID=sa; PWD=[[my password]]", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Statistics", 2, 0, "DSN=Statistics; UID=sa; PWD=[[my password]]", "USE Statistics; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OPTool", 3, 0, "DSN=OPTool; UID=sa; PWD=[[my password]]", "USE OperatorTool; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Character", 10, 0, "DSN=Character; UID=sa; PWD=[[my password]]", "USE Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "GameLog", 11, 0, "DSN=GameLog; UID=sa; PWD=[[my password]]", "USE GameLog; SET LOCK_TIMEOUT 5000"
#END

as only AccountLog service wont start. everything else is working now.

Quote:

---

Originally Posted by Anqui3tas

even if i remove the _CN from the cofig?

Spoiler:

;
; Server info for RELEASE SERVICE
; 2007.4 By Blacksky
;


#DEFINE NATION_NAME
<STRING>
#ENDDEFINE


#DEFINE WORLD_NAME
<INTEGER>
<STRING>
<STRING>
#ENDDEFINE

#DEFINE SERVER_INFO
<STRING>
<INTEGER>
<INTEGER>
<INTEGER>
<INTEGER>
<STRING>
<INTEGER>
<INTEGER>
<INTEGER>
#ENDDEFINE


#DEFINE ODBC_INFO
<STRING>
<INTEGER>
<INTEGER>
<STRING>
<STRING>
#ENDDEFINE


NATION_NAME "LanteaCorp"


WORLD_NAME 0, "Lantea", "../9Data/Hero"


; DB,Login server ------------------------------------------------------------
SERVER_INFO "PG_Account_DB", 0, 0, 0, 0, "127.0.0.1", 9000, 1, 100
SERVER_INFO "PG_AccountLog_DB", 1, 0, 0, 0, "127.0.0.1", 9005, 1, 100


SERVER_INFO "PG_Login", 4, 0, 0,20, "127.0.0.1", 9010, 50, 200
SERVER_INFO "PG_Login", 4, 0, 0, 5, "127.0.0.1", 9015, 1, 50
SERVER_INFO "PG_Login", 4, 0, 0, 8, "127.0.0.1", 9016, 1, 30


; World #0 -------------------------------------------------------------------
SERVER_INFO "PG_Character_00", 2, 0, 0, 0, "127.0.0.1", 9100, 1, 100
SERVER_INFO "PG_GameLog_00", 3, 0, 0, 0, "127.0.0.1", 9101, 1, 100


SERVER_INFO "PG_WorldManager_00", 5, 0, 0,20, "127.0.0.1", 9110, 200, 2000
SERVER_INFO "PG_WorldManager_00", 5, 0, 0, 6, "127.0.0.1", 9115, 1, 200
SERVER_INFO "PG_WorldManager_00", 5, 0, 0, 8, "127.0.0.1", 9116, 1, 30


SERVER_INFO "PG_Zone_00", 6, 0, 0,20, "127.0.0.1", 9120, 100, 1500
SERVER_INFO "PG_Zone_00", 6, 0, 0, 8, "127.0.0.1", 9121, 1, 30


SERVER_INFO "PG_Zone_01", 6, 0, 1,20, "127.0.0.1", 9122, 100, 1500
SERVER_INFO "PG_Zone_01", 6, 0, 1, 8, "127.0.0.1", 9123, 1, 30


SERVER_INFO "PG_Zone_02", 6, 0, 2,20, "127.0.0.1", 9124, 100, 1500
SERVER_INFO "PG_Zone_02", 6, 0, 2, 8, "127.0.0.1", 9125, 1, 30


SERVER_INFO "PG_Zone_03", 6, 0, 3,20, "127.0.0.1", 9126, 100, 1500
SERVER_INFO "PG_Zone_03", 6, 0, 3, 8, "127.0.0.1", 9127, 1, 30


SERVER_INFO "PG_Zone_04", 6, 0, 4,20, "127.0.0.1", 9128, 100, 1500
SERVER_INFO "PG_Zone_04", 6, 0, 4, 8, "127.0.0.1", 9129, 1, 30


ODBC_INFO "Account", 0, 0, "DSN=Account; UID=sa; PWD=[[my password]]", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog", 1, 0, "DSN=AccountLog; UID=sa; PWD=[[my password]]", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Statistics", 2, 0, "DSN=Statistics; UID=sa; PWD=[[my password]]", "USE Statistics; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OPTool", 3, 0, "DSN=OPTool; UID=sa; PWD=[[my password]]", "USE OperatorTool; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Character", 10, 0, "DSN=Character; UID=sa; PWD=[[my password]]", "USE Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "GameLog", 11, 0, "DSN=GameLog; UID=sa; PWD=[[my password]]", "USE GameLog; SET LOCK_TIMEOUT 5000"
#END

as only AccountLog service wont start. everything else is working now.

---

just making alot of extra work for your self ._.
Best just sticking with the current names.

alright. so i replaced all the files, changed all the names, and tried again, but only that service will not start again. this usually isnt the service i have issues with.

I would say just back up a few steps an start from the beginning.
When I set mine up I just took my time an read what was different an it was a smooth setup.
All I can say at this point is best of luck.

Quote:

---

Originally Posted by JakeJigsaw

I would say just back up a few steps an start from the beginning.
When I set mine up I just took my time an read what was different an it was a smooth setup.
All I can say at this point is best of luck.

---

Well I've already redone everything twice. A full format and fresh start. Which is why I'm posting this. It's probably something simple I keep missing. Or have forgotten, it has been years since I've set up a test server.

Quote:

---

Originally Posted by Anqui3tas

Well I've already redone everything twice. A full format and fresh start. Which is why I'm posting this. It's probably something simple I keep missing. Or have forgotten, it has been years since I've set up a test server.

---

yeah, and HK might be similar but it has a few extra tricks.
You seem to know enough to where you should be able to figure it out.

read a Odin set up guide an keep in mind the name changes of services an such, just to make sure all your steps are correct.
could be somthing as simple as the wrong OBDC (32 to 64 bit), or dumb mistakes.

Alright. ill take another look tonight, and a fresh look in the morning. may just need a fresh pair of eyes to eye it over quickly.

--I can still get Athens, and Odin to get running, just tried both in a Virtual machine. just hate using odin cuz of the tokens, and athens cuz lack of newer features and support for newer models.

Are you using the exe from the release? Check your ODBC again, check your config file inf the _CONF folder and check the config file in the AccountLog service folder, also check to make sure that the user you are using has enough permissions to be able to view and edit the databases. Lastly try making a new database account and use that login instead of sa.

it was the statistics database. even tho everything called for Statistics database, the database needed to be called StatisticsData

Alright, since the issue is resolved, I am closing this thread. Thank you for providing your solution.