Account log service HK

Results 1 to 12 of 12
  1. #1
    Valued Member Anqui3tas is offline
    MemberRank
    May 2013 Join Date
    131Posts

    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>




  2. #2
    Account Upgraded | Title Enabled! JakeJigsaw is offline
    MemberRank
    Jan 2014 Join Date
    ElderineLocation
    201Posts

    Re: Account log service HK

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


  3. #3
    Valued Member Anqui3tas is offline
    MemberRank
    May 2013 Join Date
    131Posts

    Re: Account log service HK

    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.

  4. #4
    Account Upgraded | Title Enabled! JakeJigsaw is offline
    MemberRank
    Jan 2014 Join Date
    ElderineLocation
    201Posts

    Re: Account log service HK

    Quote Originally Posted by Anqui3tas View Post
    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.

  5. #5
    Valued Member Anqui3tas is offline
    MemberRank
    May 2013 Join Date
    131Posts

    Re: Account log service HK

    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.

  6. #6
    Account Upgraded | Title Enabled! JakeJigsaw is offline
    MemberRank
    Jan 2014 Join Date
    ElderineLocation
    201Posts

    Re: Account log service HK

    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.

  7. #7
    Valued Member Anqui3tas is offline
    MemberRank
    May 2013 Join Date
    131Posts

    Re: Account log service HK

    Quote Originally Posted by JakeJigsaw View Post
    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.

  8. #8
    Account Upgraded | Title Enabled! JakeJigsaw is offline
    MemberRank
    Jan 2014 Join Date
    ElderineLocation
    201Posts

    Re: Account log service HK

    Quote Originally Posted by Anqui3tas View Post
    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.

  9. #9
    Valued Member Anqui3tas is offline
    MemberRank
    May 2013 Join Date
    131Posts

    Re: Account log service HK

    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.

  10. #10
    əʇılə ɯɐ ı fiestanerd69 is offline
    MemberRank
    Jun 2009 Join Date
    958Posts

    Re: Account log service HK

    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.

  11. #11
    Valued Member Anqui3tas is offline
    MemberRank
    May 2013 Join Date
    131Posts

    Re: Account log service HK

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

  12. #12
    əʇılə ɯɐ ı fiestanerd69 is offline
    MemberRank
    Jun 2009 Join Date
    958Posts

    Re: Account log service HK

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



Advertisement