Account DB Server Service Problem

Results 1 to 11 of 11
  1. #1
    Account Upgraded | Title Enabled! maplepuppet is offline
    MemberRank
    Nov 2008 Join Date
    New JerseyLocation
    905Posts

    Account DB Server Service Problem

    _Account DB Server in services.msc will not run, all other services run.

    When I run it I get this error.

    "The _Account DB Server service on local computer started and then stopped. Some services stop automatically if they are not in use by the other services of programs."



    Account DB Server Debug Message
    Code:
    000002 2011-12-21 18:24:52 Launching the server.....
    000003 2011-12-21 18:24:52 Local  Time      12/21/2011 6:24:52 PM
    000004 2011-12-21 18:24:52 System Time(UTC) 12/21/2011 11:24:52 PM
    000005 2011-12-21 18:24:52 <SUCCESSED SCRIPTOR READ> config.txt
    000006 2011-12-21 18:24:52 <I AM THE _Account DB Server, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
    000007 2011-12-21 18:24:52 Service start(no parameter)
    000008 2011-12-21 18:24:52 <IOCP WORKTHREAD #0 RUNNING>
    000009 2011-12-21 18:24:52 <IOCP WORKTHREAD #1 RUNNING>
    000010 2011-12-21 18:24:52 <IOCP WORKTHREAD #2 RUNNING>
    000011 2011-12-21 18:24:52 <IOCP WORKTHREAD #3 RUNNING>
    000012 2011-12-21 18:24:52 <IOCP WORKTHREAD #4 RUNNING>
    000013 2011-12-21 18:24:52 <IOCP WORKTHREAD #5 RUNNING>
    000014 2011-12-21 18:24:52 <IOCP WORKTHREAD #6 RUNNING>
    000015 2011-12-21 18:24:52 <IOCP WORKTHREAD #7 RUNNING>
    000016 2011-12-21 18:24:52 <IOCP WORKTHREAD #8 RUNNING>
    000017 2011-12-21 18:24:52 <IOCP WORKTHREAD #9 RUNNING>
    000018 2011-12-21 18:24:52 <IOCP WORKTHREAD #10 RUNNING>
    000019 2011-12-21 18:24:52 <IOCP WORKTHREAD #11 RUNNING>
    000020 2011-12-21 18:24:52 <IOCP WORKTHREAD #12 RUNNING>
    000021 2011-12-21 18:24:53 <IOCP WORKTHREAD #13 RUNNING>
    000022 2011-12-21 18:24:53 <IOCP WORKTHREAD #14 RUNNING>
    000023 2011-12-21 18:24:53 <IOCP WORKTHREAD #15 RUNNING>
    000024 2011-12-21 18:24:53 <IOCP WORKTHREAD #16 RUNNING>
    000025 2011-12-21 18:24:53 <IOCP WORKTHREAD #17 RUNNING>
    000026 2011-12-21 18:24:53 <IOCP WORKTHREAD #18 RUNNING>
    000027 2011-12-21 18:24:53 <IOCP WORKTHREAD #19 RUNNING>
    000028 2011-12-21 18:24:53 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
    000029 2011-12-21 18:24:54 <NUMBER OF 41 SESSION WORKER STARTED>
    000030 2011-12-21 18:24:54 <SUCCESSED SESSION MANAGER INIT> PG_Account_DB
    000031 2011-12-21 18:24:54 *FAILED START LISTEN SOCKET* 
    000032 2011-12-21 18:24:54 < END OF MAIN = 0 >
    000033 2011-12-21 18:24:54 <SESSION WORKER #18 FREE>
    000037 2011-12-21 18:24:54 <SESSION WORKER #36 FREE>
    000039 2011-12-21 18:24:54 <SESSION WORKER #21 FREE>
    000034 2011-12-21 18:24:54 <SESSION WORKER #12 FREE>
    000036 2011-12-21 18:24:54 <SESSION WORKER #29 FREE>
    000040 2011-12-21 18:24:54 <SESSION WORKER #22 FREE>
    000041 2011-12-21 18:24:54 <SESSION WORKER #32 FREE>
    000038 2011-12-21 18:24:54 <SESSION WORKER #40 FREE>
    000044 2011-12-21 18:24:54 <SESSION WORKER #5 FREE>
    000048 2011-12-21 18:24:54 <SESSION WORKER #9 FREE>
    000043 2011-12-21 18:24:54 <SESSION WORKER #30 FREE>
    000047 2011-12-21 18:24:54 <SESSION WORKER #20 FREE>
    000042 2011-12-21 18:24:54 <SESSION WORKER #0 FREE>
    000058 2011-12-21 18:24:54 <SESSION WORKER #25 FREE>
    000068 2011-12-21 18:24:54 <SESSION WORKER #2 FREE>
    000071 2011-12-21 18:24:54 <SESSION WORKER #26 FREE>
    000045 2011-12-21 18:24:54 <SESSION WORKER #28 FREE>
    000049 2011-12-21 18:24:54 <SESSION WORKER #8 FREE>
    000051 2011-12-21 18:24:54 <SESSION WORKER #24 FREE>
    000052 2011-12-21 18:24:54 <SESSION WORKER #16 FREE>
    000064 2011-12-21 18:24:54 <SESSION WORKER #11 FREE>
    000050 2011-12-21 18:24:54 <SESSION WORKER #4 FREE>
    000053 2011-12-21 18:24:54 <SESSION WORKER #27 FREE>
    000054 2011-12-21 18:24:54 <SESSION WORKER #33 FREE>
    000066 2011-12-21 18:24:54 <SESSION WORKER #39 FREE>
    000056 2011-12-21 18:24:54 <SESSION WORKER #37 FREE>
    000062 2011-12-21 18:24:54 <SESSION WORKER #23 FREE>
    000046 2011-12-21 18:24:54 <SESSION WORKER #1 FREE>
    000060 2011-12-21 18:24:54 <SESSION WORKER #13 FREE>
    000055 2011-12-21 18:24:54 <SESSION WORKER #31 FREE>
    000059 2011-12-21 18:24:54 <SESSION WORKER #7 FREE>
    000063 2011-12-21 18:24:54 <SESSION WORKER #35 FREE>
    000070 2011-12-21 18:24:54 <SESSION WORKER #14 FREE>
    000065 2011-12-21 18:24:54 <SESSION WORKER #19 FREE>
    000061 2011-12-21 18:24:54 <SESSION WORKER #3 FREE>
    000069 2011-12-21 18:24:54 <SESSION WORKER #34 FREE>
    000057 2011-12-21 18:24:54 <SESSION WORKER #15 FREE>
    000067 2011-12-21 18:24:54 <SESSION WORKER #10 FREE>
    000072 2011-12-21 18:24:54 <SESSION WORKER #6 FREE>
    000035 2011-12-21 18:24:54 <SESSION WORKER #17 FREE>
    000073 2011-12-21 18:24:54 <SESSION WORKER #38 FREE>
    000074 2011-12-21 18:24:54 <IOCP WORKTHREAD #5 FREE>
    000075 2011-12-21 18:24:54 <IOCP WORKTHREAD #4 FREE>
    000076 2011-12-21 18:24:54 <IOCP WORKTHREAD #7 FREE>
    000077 2011-12-21 18:24:54 <IOCP WORKTHREAD #3 FREE>
    000078 2011-12-21 18:24:54 <IOCP WORKTHREAD #0 FREE>
    000079 2011-12-21 18:24:54 <IOCP WORKTHREAD #19 FREE>
    000080 2011-12-21 18:24:54 <IOCP WORKTHREAD #6 FREE>
    000081 2011-12-21 18:24:54 <IOCP WORKTHREAD #2 FREE>
    000082 2011-12-21 18:24:54 <IOCP WORKTHREAD #18 FREE>
    000083 2011-12-21 18:24:54 <IOCP WORKTHREAD #16 FREE>
    000084 2011-12-21 18:24:54 <IOCP WORKTHREAD #14 FREE>
    000085 2011-12-21 18:24:54 <IOCP WORKTHREAD #15 FREE>
    000086 2011-12-21 18:24:54 <IOCP WORKTHREAD #12 FREE>
    000087 2011-12-21 18:24:54 <IOCP WORKTHREAD #11 FREE>
    000088 2011-12-21 18:24:54 <IOCP WORKTHREAD #10 FREE>
    000089 2011-12-21 18:24:54 <IOCP WORKTHREAD #1 FREE>
    000090 2011-12-21 18:24:54 <IOCP WORKTHREAD #8 FREE>
    000091 2011-12-21 18:24:54 <IOCP WORKTHREAD #17 FREE>
    000092 2011-12-21 18:24:54 <IOCP WORKTHREAD #13 FREE>
    And here's my Config if that helps.
    Code:
    #DEFINE WORLD_NAME
      <INTEGER>		; World No
      <STRING>		; Name
      <STRING>		; Data path
    #ENDDEFINE
    		
    #DEFINE SERVER_INFO ; Listen socket information
      <STRING>          ; Name
      <INTEGER>         ; Server ID
      <INTEGER>         ; Server World No
      <INTEGER>         ; Server Zone No
      <INTEGER>         ; From Server ID
      <STRING>          ; IP Address == '' then Use my IP Address
      <INTEGER>         ; Port Number
      <INTEGER>         ; Backlog Count == 0 then Use SOMAXCONN
      <INTEGER>         ; Maximum of accept socket
    #ENDDEFINE
    
    #DEFINE ODBC_INFO
      <STRING>          ; DB Name
      <INTEGER>         ; DB ID
      <INTEGER>         ; World No
      <STRING>          ; ODBC Connection info
      <STRING>          ; DB Startup command
    #ENDDEFINE
    
    ;-----------------------------------------------------------------------------------
    ; Server ID
    ;-----------------------------------------------------------------------------------
    
    ; 0 SERVER_ID_DB_ACCOUNT    
    ; 1 SERVER_ID_DB_ACCOUNTLOG 
    ; 2 SERVER_ID_DB_CHARACTER  
    ; 3 SERVER_ID_DB_GAMELOG    
     
    ; 4 SERVER_ID_LOGIN         
    ; 5 SERVER_ID_WORLDMANAGER  
    ; 6 SERVER_ID_ZONE          
     
    ; 7 SERVER_ID_PATCH     
    ; 8 SERVER_ID_OPTOOL    
    ; 9 SERVER_ID_WEB       
    ; 10 SERVER_ID_UNKNOWN   
     
    ; 19 SERVER_ID_LAUNCHER  
    ; 20 SERVER_ID_CLIENT    
    
    ;-----------------------------------------------------------------------------------
    ; DB ID
    ;-----------------------------------------------------------------------------------
    
    ;define DB_ID_ACCOUNT      0
    ;define DB_ID_ACCOUNTLOG   1
    ;define DB_ID_STATICSTICS  2
    ;define DB_ID_OPTOOL_LOG   3
    ;define DB_ID_CHARACTER	  10
    ;define DB_ID_GAMELOG	  11
    
    ;-----------------------------------------------------------------------------------
    ; DEFINE WORLD NAME
    ;-----------------------------------------------------------------------------------
    
    WORLD_NAME 0, "Beta-Server", "../_CONF/Data"
    
    ;-----------------------------------------------------------------------------------
    ; CJC SERVER INFO
    ;-----------------------------------------------------------------------------------
    
    ;
    ; [ID] = Server ID, [W] = World No, [Z] = Zone No, [F] = From Server ID
    ;
    ;           [Name]             [ID, W, Z, F] [IP]               [Port] [Backlog] [Maximum of accept socket]
    ;
    ; DB Login server ------------------------------------------------------------
    SERVER_INFO "PG_Account_DB",     0, 0, 0, 0, "72.218.74.111",	9000,  1,        100	; From ALL
    SERVER_INFO "PG_AccountLog_DB",  1, 0, 0, 0, "127.0.0.1",	9005,  1,        100	; From ALL
    
    SERVER_INFO "PG_Login_Server",   4, 0, 0,20, "72.218.74.111",	9010,  10,       2000    ; From Client
    SERVER_INFO "PG_Login_Server",   4, 0, 0, 5, "127.0.0.1",	9015,  1,        50     ; From World manager
    SERVER_INFO "PG_Login_Server",   4, 0, 0, 8, "127.0.0.1",	9016,  1,        30     ; From OPTOOL
    
    ; World #0 -------------------------------------------------------------------
    SERVER_INFO "PG_Char_DB",        2, 0, 0, 0, "127.0.0.1",	9100,  1,        100    ; From ALL
    SERVER_INFO "PG_GameLog_DB",     3, 0, 0, 0, "127.0.0.1",	9101,  1,        100    ; From ALL
    
    SERVER_INFO "PG_World_Manager_Server",  5, 0, 0,20, "72.218.74.111",	9110,  10,       2000   ; From Client
    SERVER_INFO "PG_World_Manager_Server",  5, 0, 0, 6, "72.218.74.111",	9115,  1,        100    ; From Zone
    SERVER_INFO "PG_World_Manager_Server",  5, 0, 0, 8, "127.0.0.1",	9116,  1,        30     ; From OPTOOL
    
    SERVER_INFO "PG_Zone_00",        6, 0, 0,20, "72.218.74.111",	9120,  10,       2000   ; From Client
    SERVER_INFO "PG_Zone_00",        6, 0, 0, 8, "127.0.0.1",	9121,  1,        30     ; From OPTOOL
    
    SERVER_INFO "PG_Zone_01",        6, 0, 1,20, "72.218.74.111",	9122,  10,       2000   ; From Client
    SERVER_INFO "PG_Zone_01",        6, 0, 1, 8, "127.0.0.1",	9123,  1,        30     ; From OPTOOL
    
    SERVER_INFO "PG_Zone_02",        6, 0, 2,20, "72.218.74.111",	9124,  10,       2000   ; From Client
    SERVER_INFO "PG_Zone_02",        6, 0, 2, 8, "127.0.0.1",	9125,  1,        30     ; From OPTOOL
    
    
    ;-----------------------------------------------------------------------------------
    ; ODBC INFO
    ;-----------------------------------------------------------------------------------
    ;	  NAME		nDBID		nWorldNoConnection INFO			       Startup Command
    ODBC_INFO "Account",	0,		0,	"DSN=Account;	UID=sa;	PWD=matt", "USE Account;		SET LOCK_TIMEOUT 5000"
    ODBC_INFO "AccountLog",	1,		0,	"DSN=AccountLog;UID=sa;	PWD=matt", "USE AccountLog;		SET LOCK_TIMEOUT 5000"
    ODBC_INFO "Statistics",	2,		0,	"DSN=Statistics;UID=sa;	PWD=matt", "USE StatisticsData;	SET LOCK_TIMEOUT 5000"
    ODBC_INFO "OPTool",	3,		0,	"DSN=OPTool;	UID=sa;	PWD=matt", "USE OperatorTool;	SET LOCK_TIMEOUT 5000"
    ODBC_INFO "Character",	10,		0,	"DSN=Character;	UID=sa;	PWD=matt", "USE World00_Character;	SET LOCK_TIMEOUT 5000"
    ODBC_INFO "GameLog",	11,		0,	"DSN=GameLog;	UID=sa;	PWD=matt", "USE World00_GameLog;	SET LOCK_TIMEOUT 5000"
    
    #END
    I also tried changing my dynamic IPS in the config all to 127.0.0.1 but it still didn't work. Can anyone help? And yes I did the ODBC or whatever.
    Last edited by maplepuppet; 22-12-11 at 12:28 AM.


  2. #2
    Account Upgraded | Title Enabled! maplepuppet is offline
    MemberRank
    Nov 2008 Join Date
    New JerseyLocation
    905Posts

    Re: Account DB Server Service Problem

    Also I'm on a 64 bit system. I did odbcad on both of them since there's 2. I tried just 1 that didn't work either. I also tried redoing my services and did my odbc over 3 times, still nothing. I also redid my database with no results.

  3. #3
    Account Upgraded | Title Enabled! Lugapha is offline
    MemberRank
    Jul 2011 Join Date
    387Posts

    Re: Account DB Server Service Problem

    are the names of the odbc spelled correct?

  4. #4
    Account Upgraded | Title Enabled! maplepuppet is offline
    MemberRank
    Nov 2008 Join Date
    New JerseyLocation
    905Posts

    Re: Account DB Server Service Problem

    Yes they are.

  5. #5
    Electro, dude. Bakey is offline
    MemberRank
    Oct 2010 Join Date
    403Posts

    Re: Account DB Server Service Problem

    000031 2011-12-21 18:24:54 *failed start listen socket*

  6. #6
    Account Upgraded | Title Enabled! maplepuppet is offline
    MemberRank
    Nov 2008 Join Date
    New JerseyLocation
    905Posts

    Re: Account DB Server Service Problem

    Quote Originally Posted by Bakey View Post
    000031 2011-12-21 18:24:54 *failed start listen socket*
    So how do I fix that?

  7. #7
    Electro, dude. Bakey is offline
    MemberRank
    Oct 2010 Join Date
    403Posts

    Re: Account DB Server Service Problem

    Change your configs for it to run on 127.0.0.1 not your IP.

  8. #8
    Enthusiast Steffi Fomuz is offline
    MemberRank
    Nov 2011 Join Date
    42Posts

    Re: Account DB Server Service Problem

    Chance IP little Guy :P

  9. #9
    Apprentice madexorcist is offline
    MemberRank
    Jul 2012 Join Date
    13Posts

    Re: Account DB Server Service Problem

    Hi guys I have the same issue the Account db and others dont want to run and keep telling me

    "The _Account DB Server service on local computer started and then stopped. Some services stop automatically if they are not in use by the other services of programs

    Account DB Server Debug Message

    Code
    000000 2012-07-12 13:05:02 G:\Server\Account
    000001 2012-07-12 13:05:02 -------------------------------------------------------
    000002 2012-07-12 13:05:02 Launching the server.....
    000003 2012-07-12 13:05:02 Local Time 12/07/2012 13:05:02
    000004 2012-07-12 13:05:02 System Time(UTC) 12/07/2012 19:05:02
    000005 2012-07-12 13:05:02 <SUCCESSED SCRIPTOR READ> config.txt
    000006 2012-07-12 13:05:02 <I AM THE _Account DB Server, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
    000007 2012-07-12 13:05:02 Service start(no parameter)
    000008 2012-07-12 13:05:02 <IOCP WORKTHREAD #0 RUNNING>
    000009 2012-07-12 13:05:02 <IOCP WORKTHREAD #1 RUNNING>
    000010 2012-07-12 13:05:02 <IOCP WORKTHREAD #2 RUNNING>
    000011 2012-07-12 13:05:02 <IOCP WORKTHREAD #3 RUNNING>
    000012 2012-07-12 13:05:02 <IOCP WORKTHREAD #4 RUNNING>
    000013 2012-07-12 13:05:02 <IOCP WORKTHREAD #5 RUNNING>
    000014 2012-07-12 13:05:02 <IOCP WORKTHREAD #6 RUNNING>
    000015 2012-07-12 13:05:02 <IOCP WORKTHREAD #7 RUNNING>
    000016 2012-07-12 13:05:02 <IOCP WORKTHREAD #8 RUNNING>
    000017 2012-07-12 13:05:02 <IOCP WORKTHREAD #9 RUNNING>
    000018 2012-07-12 13:05:02 <IOCP WORKTHREAD #10 RUNNING>
    000019 2012-07-12 13:05:02 <IOCP WORKTHREAD #11 RUNNING>
    000020 2012-07-12 13:05:02 <IOCP WORKTHREAD #12 RUNNING>
    000021 2012-07-12 13:05:02 <IOCP WORKTHREAD #13 RUNNING>
    000022 2012-07-12 13:05:02 <IOCP WORKTHREAD #14 RUNNING>
    000023 2012-07-12 13:05:03 <IOCP WORKTHREAD #15 RUNNING>
    000024 2012-07-12 13:05:03 <IOCP WORKTHREAD #16 RUNNING>
    000025 2012-07-12 13:05:03 <IOCP WORKTHREAD #17 RUNNING>
    000026 2012-07-12 13:05:03 <IOCP WORKTHREAD #18 RUNNING>
    000027 2012-07-12 13:05:03 <IOCP WORKTHREAD #19 RUNNING>
    000028 2012-07-12 13:05:03 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
    000029 2012-07-12 13:05:03 DB_Init FAILED = DSN=Acount; UID=sa; PWD=admin
    000030 2012-07-12 13:05:03 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
    000031 2012-07-12 13:05:03 < END OF MAIN = 0 >
    000032 2012-07-12 13:05:03 <IOCP WORKTHREAD #1 FREE>
    000033 2012-07-12 13:05:03 <IOCP WORKTHREAD #18 FREE>
    000035 2012-07-12 13:05:03 <IOCP WORKTHREAD #0 FREE>

    000034 2012-07-12 13:05:03 <IOCP WORKTHREAD #19 FREE>
    000044 2012-07-12 13:05:03 <IOCP WORKTHREAD #9 FREE>

    Config faile setting.
    Code:
    #DEFINE WORLD_NAME
    <INTEGER> ; World No
    <STRING> ; Name
    <STRING> ; Data path
    #ENDDEFINE

    #DEFINE SERVER_INFO ; Listen socket information
    <STRING> ; Name
    <INTEGER> ; Server ID
    <INTEGER> ; Server World No
    <INTEGER> ; Server Zone No
    <INTEGER> ; From Server ID
    <STRING> ; IP Address == '' then Use my IP Address
    <INTEGER> ; Port Number
    <INTEGER> ; Backlog Count == 0 then Use SOMAXCONN
    <INTEGER> ; Maximum of accept socket
    #ENDDEFINE

    #DEFINE ODBC_INFO
    <STRING> ; DB Name
    <INTEGER> ; DB ID
    <INTEGER> ; World No
    <STRING> ; ODBC Connection info
    <STRING> ; DB Startup command
    #ENDDEFINE

    ;-----------------------------------------------------------------------------------
    ; Server ID
    ;-----------------------------------------------------------------------------------

    ; 0 SERVER_ID_DB_ACCOUNT
    ; 1 SERVER_ID_DB_ACCOUNTLOG
    ; 2 SERVER_ID_DB_CHARACTER
    ; 3 SERVER_ID_DB_GAMELOG

    ; 4 SERVER_ID_LOGIN
    ; 5 SERVER_ID_WORLDMANAGER
    ; 6 SERVER_ID_ZONE

    ; 7 SERVER_ID_PATCH
    ; 8 SERVER_ID_OPTOOL
    ; 9 SERVER_ID_WEB
    ; 10 SERVER_ID_UNKNOWN

    ; 19 SERVER_ID_LAUNCHER
    ; 20 SERVER_ID_CLIENT

    ;-----------------------------------------------------------------------------------
    ; DB ID
    ;-----------------------------------------------------------------------------------

    ;define DB_ID_ACCOUNT 0
    ;define DB_ID_ACCOUNTLOG 1
    ;define DB_ID_STATICSTICS 2
    ;define DB_ID_OPTOOL_LOG 3
    ;define DB_ID_CHARACTER 10
    ;define DB_ID_GAMELOG 11

    ;-----------------------------------------------------------------------------------
    ; DEFINE WORLD NAME
    ;-----------------------------------------------------------------------------------

    WORLD_NAME 0, "Beta-Server", "../_CONF/Data"

    ;-----------------------------------------------------------------------------------
    ; CJC SERVER INFO
    ;-----------------------------------------------------------------------------------

    ;
    ; [ID] = Server ID, [W] = World No, [Z] = Zone No, [F] = From Server ID
    ;
    ; [Name] [ID, W, Z, F] [IP] [Port] [Backlog] [Maximum of accept socket]
    ;
    ; DB Login server ------------------------------------------------------------
    SERVER_INFO "PG_Account_DB", 0, 0, 0, 0, "127.0.0.1", 9000, 1, 100 ; From ALL
    SERVER_INFO "PG_AccountLog_DB", 1, 0, 0, 0, "127.0.0.1", 9005, 1, 100 ; From ALL

    SERVER_INFO "PG_Login_Server", 4, 0, 0,20, "127.0.0.1", 9010, 10, 2000 ; From Client
    SERVER_INFO "PG_Login_Server", 4, 0, 0, 5, "127.0.0.1", 9015, 1, 50 ; From World manager
    SERVER_INFO "PG_Login_Server", 4, 0, 0, 8, "127.0.0.1", 9016, 1, 30 ; From OPTOOL

    ; World #0 -------------------------------------------------------------------
    SERVER_INFO "PG_Char_DB", 2, 0, 0, 0, "127.0.0.1", 9100, 1, 100 ; From ALL
    SERVER_INFO "PG_GameLog_DB", 3, 0, 0, 0, "127.0.0.1", 9101, 1, 100 ; From ALL

    SERVER_INFO "PG_World_Manager_Server", 5, 0, 0,20, "127.0.0.1", 9110, 10, 2000 ; From Client
    SERVER_INFO "PG_World_Manager_Server", 5, 0, 0, 6, "127.0.0.1", 9115, 1, 100 ; From Zone
    SERVER_INFO "PG_World_Manager_Server", 5, 0, 0, 8, "127.0.0.1", 9116, 1, 30 ; From OPTOOL

    SERVER_INFO "PG_Zone_00", 6, 0, 0,20, "127.0.0.1", 9120, 10, 2000 ; From Client
    SERVER_INFO "PG_Zone_00", 6, 0, 0, 8, "127.0.0.1", 9121, 1, 30 ; From OPTOOL

    SERVER_INFO "PG_Zone_01", 6, 0, 1,20, "127.0.0.1", 9122, 10, 2000 ; From Client
    SERVER_INFO "PG_Zone_01", 6, 0, 1, 8, "127.0.0.1", 9123, 1, 30 ; From OPTOOL

    SERVER_INFO "PG_Zone_02", 6, 0, 2,20, "127.0.0.1", 9124, 10, 2000 ; From Client
    SERVER_INFO "PG_Zone_02", 6, 0, 2, 8, "127.0.0.1", 9125, 1, 30 ; From OPTOOL


    ;-----------------------------------------------------------------------------------
    ; ODBC INFO
    ;-----------------------------------------------------------------------------------
    ; NAME nDBID nWorldNoConnection INFO Startup Command
    ODBC_INFO "Account", 0, 0, "DSN=Acount; UID=sa; PWD=admin", "USE Account; SET LOCK_TIMEOUT 5000"
    ODBC_INFO "AccountLog", 1, 0, "DSN=AccountLog;UID=sa; PWD=admin", "USE AccountLog; SET LOCK_TIMEOUT 5000"
    ODBC_INFO "Statistics", 2, 0, "DSN=Statistics;UID=sa; PWD=admin", "USE StatisticsData; SET LOCK_TIMEOUT 5000"
    ODBC_INFO "OPTool", 3, 0, "DSN=OPTool; UID=sa; PWD=admin", "USE OperatorTool; SET LOCK_TIMEOUT 5000"
    ODBC_INFO "Character", 10, 0, "DSN=Character; UID=sa; PWD=admin", "USE World00_Character; SET LOCK_TIMEOUT 5000"
    ODBC_INFO "GameLog", 11, 0, "DSN=GameLog; UID=sa; PWD=admin", "USE World00_GameLog; SET LOCK_TIMEOUT 5000"

    #END



    Account db not working
    AccountLg Db Not working
    World00_char not working
    World _ gam not working

    keep telling when I attempt to run them :

    "The _Account DB Server service on local computer started and then stopped. Some services stop automatically if they are not in use by the other services of programs"

    But
    server 0;1;2 are working
    World00_manager are working
    Login server are working

  10. #10
    Coeven Tronic is offline
    MemberRank
    Apr 2010 Join Date
    LocalhostLocation
    238Posts

    Re: Account DB Server Service Problem

    000029 2012-07-12 13:05:03 DB_Init FAILED = DSN=Acount; UID=sa; PWD=admin

    Database is wrong

  11. #11
    Enthusiast AnotherKyo is offline
    MemberRank
    Mar 2012 Join Date
    31Posts

    Re: Account DB Server Service Problem

    Hello there my friend, If none of the suggestions above helped you, i recommend u to check on my thread, i had the same problem before, i have made bunch of hamachi based fiesta servers and once i bought a new computer and tried to set a new sql/obdc/hamachi connection for some reason my services stopped working. Anyways, i found out what the problem was, you could check this link:

    http://forum.ragezone.com/f594/fixed...rvices-833040/

    If that doesn't help then fu.

    Regards.



Advertisement