Select Server Login Draco, Mars, Leo

Results 1 to 13 of 13
  1. #1
    Apprentice akstone is offline
    MemberRank
    Dec 2009 Join Date
    7Posts

    sad Select Server Login Draco, Mars, Leo

    To open multiple server please help
    please help
    please help


    Select Server
    1. Draco
    1. channel
    2. channel
    3. channel
    4. channel
    2. Mars
    1. channel
    2. channel
    3. channel
    4. channel

    3. Leo

    How do such ???????

    please help
    please help
    please help
    please help
    Last edited by akstone; 19-06-10 at 06:24 PM.


  2. #2
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: Select Server Login Draco, Mars, Leo

    You need:

    1x GlobalDBAgent
    1x GlobalMgrSvr
    1x LoginSvr
    Yx CashDBAgent
    Yx DBAgent
    Yx Worldsvr

    Basically you need a cashdbagent, a dbagent and a worldsvr all on different ports for each server you want. Don't forget to install a new clean database and to add a entry in odbc.ini for it.

    Cheers.

  3. #3
    Apprentice akstone is offline
    MemberRank
    Dec 2009 Join Date
    7Posts

    Re: Select Server Login Draco, Mars, Leo

    How can I Do video floating, my friend.
    Help you fix this issue.

  4. #4
    Banned P1MAX is offline
    BannedRank
    Jan 2010 Join Date
    69Posts

    Re: Select Server Login Draco, Mars, Leo


  5. #5
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Select Server Login Draco, Mars, Leo

    Unless you know how the server works very well you will not be able to do this as it requires you to configure everything manually.

    My cabal_config script has a 2 channel template which you can study if you want to learn how to do it. The way it does it logins will work for every server though as cabal_config cannot keep the servers seperate without the databases being modified too or everything will just use 1 db. Untill the next db release seperate servers is even hader than manually creating the config.

    A video would not help as whilst i could show you what to change you wouldn't understand why you are putting those changes in. Make 1 single mistake it it would take hours to even find what is wrong.

    If you want a specific template adding then put a request on that post P1MAX linked and i can add one. I need to know the exact number of channels per server though and emember logins will work on all servers.

  6. #6
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: Select Server Login Draco, Mars, Leo

    Quote Originally Posted by chumpywumpy View Post
    Unless you know how the server works very well you will not be able to do this as it requires you to configure everything manually.

    My cabal_config script has a 2 channel template which you can study if you want to learn how to do it. The way it does it logins will work for every server though as cabal_config cannot keep the servers seperate without the databases being modified too or everything will just use 1 db. Untill the next db release seperate servers is even hader than manually creating the config.

    A video would not help as whilst i could show you what to change you wouldn't understand why you are putting those changes in. Make 1 single mistake it it would take hours to even find what is wrong.

    If you want a specific template adding then put a request on that post P1MAX linked and i can add one. I need to know the exact number of channels per server though and emember logins will work on all servers.
    How do you plan on doing multiple the database connection? The user MUST properly install a clean database along the other one.

  7. #7
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Select Server Login Draco, Mars, Leo

    Quote Originally Posted by cypher View Post
    How do you plan on doing multiple the database connection?
    Multiple connections is not the problem, making each set of databases talk to the right databases without having to mod lots of stored procedures is the tricky part. I have a way though ;)

  8. #8
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: Select Server Login Draco, Mars, Leo

    Quote Originally Posted by chumpywumpy View Post
    Multiple connections is not the problem, making each set of databases talk to the right databases without having to mod lots of stored procedures is the tricky part. I have a way though ;)
    Why having to change any sp? You need 1 game database for each "server". No mods needed.

  9. #9
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Select Server Login Draco, Mars, Leo

    I should make you read more of my documentation

    Quote Originally Posted by The special Cypher readme
    At present the server queries execute stored procedures in the databases and some of these have hard coded values. For example cabal_sp_newchar in account db does similar to this this several times:

    EXEC account.dbo.cabal_sp_update_character_count @userNum, @serverIdx, 1

    This points the query at a database called "account" and the cabal_sp_update_character_count SP in that specific database. What if your account database is not called "account"? Several SPs need to know what databases they are connecting to, for example 2 different servers (mercury/mars) would be accessible for 1 login unless they knew which "server" (and account/game databases) they belonged to. This is not good. Database stored procedures need to be self aware of their names and partner databases.
    A "true" multi server isn't yet possible without some manual additions but i have this problem solved already.

    I think you forgot everything i told you about the next release

  10. #10
    ANTI emi is offline
    MemberRank
    Mar 2009 Join Date
    ZHLocation
    1,378Posts

    Re: Select Server Login Draco, Mars, Leo

    I am currently running 3x servers with not such a problem.
    It's true that it needed a lot of work,to change things manually but I think if you study some guides,you can succed too.
    It need port check,and bassically as cypher says
    1x GlobalDBAgent
    1x GlobalMgrSvr
    1x LoginSvr
    x CashDBAgent
    x DBAgent
    x Worldsvr
    You need different world svr for each server.
    You have to make new clean GameDB and add it in odbc.ini
    to make the command server_restart or server_stop to work for the all 3x servers you have to add new Db Agents and WorldSvr's in serverlist
    Last edited by emi; 22-06-10 at 07:21 AM.

  11. #11
    sad pierr32 is offline
    MemberRank
    Aug 2009 Join Date
    PolandLocation
    248Posts

    Re: Select Server Login Draco, Mars, Leo

    /etc/cabal/templates - here you must enter the GlobalMgrSvr.cfg
    here u add channel in server :P
    example:

    # Venus - 5 channel setup
    #
    [Server02]
    ChannelType01=1
    MaxUserNum01=100
    +add
    ChannelType02=4
    MaxUserNum02=100
    ChannelType05=12
    MaxUserNum05=100
    ChannelType04=8
    MaxUserNum04=100 (War) ....
    ChannelType10=16908368
    MaxUserNum10=100 (TG)

    next server:

    # Leo - 4 channel setup
    #
    [Server08]
    ChannelType01=1
    MaxUserNum01=100
    ChannelType04=4
    MaxUserNum04=100
    ChannelType05=12
    MaxUserNum05=100
    ChannelType10=16908368
    MaxUserNum10=100
    +add ...

    save files.

    now u go to files /etc/cabal/templates/venus.. edit:

    GlobalDBAgent
    GlobalMgrSvr
    CashDBAgent
    DBAgent_02
    DBAgent_08
    ChatNode_02
    ChatNode_08
    WorldSvr_02_01
    WorldSvr_02_02
    WorldSvr_02_05
    WorldSvr_02_04
    WorldSvr_02_10
    WorldSvr_08_01
    WorldSvr_08_04
    WorldSvr_08_05
    WorldSvr_08_10
    LoginSvr_01

    save files.

    next is: /etc/cabal/templates/odbc.cfg edit.

    [CabalGame02]
    Driver = FreeTDS
    Address = 192.168.2.9
    Port = 1433
    Database = GAMEDB
    TDS_Version = 8.0

    [CabalGame08]
    Driver = FreeTDS
    Address = 192.168.2.9
    Port = 1433
    Database = GAMEDB2 ..< +add New GameDB in DB SQL 2000>...
    TDS_Version = 8.0

    [CabalAccount]
    Driver = FreeTDS
    Address = 192.168.2.9
    Port = 1433
    Database = ACCOUNT
    TDS_Version = 8.0

    [CabalCash]
    Driver = FreeTDS
    Address = 192.168.2.9
    Port = 1433
    Database = CabalCash
    TDS_Version = 8.0

    Now install <cabal_config> in centos

    U INSTALL VENUS SERVER ONLY VENUS then be all work :P

    add New DB in SQL 2000 is best :PPP here i have ready

    here u have GAMEDB2 Link GAMEDB2


    Remember to change ports for DBAgent_ 08 or 02 the same for ChatNode_ 08 or 02 there don't also forget about WorldSvr_

    Successes: P
    Last edited by pierr32; 22-06-10 at 09:19 AM.

  12. #12
    Apprentice akstone is offline
    MemberRank
    Dec 2009 Join Date
    7Posts

    Re: Select Server Login Draco, Mars, Leo

    pierr32 Brother
    Thanks a lot.
    Everything was super-
    But there is a problem...
    Defective GAMEDB2 => cabal_delcharacter_restore = cabal_character_table

    not connected

    GAMEDB2 else here?

    Can you help?

    Thanks

  13. #13
    sad pierr32 is offline
    MemberRank
    Aug 2009 Join Date
    PolandLocation
    248Posts

    Re: Select Server Login Draco, Mars, Leo

    u copy GAMEDB2 ther C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP ;]

    or geve me pass test for yours server end sql i configure all ther
    u pm me in my mail ad_pierr32@wp.pl :]
    Last edited by pierr32; 24-06-10 at 06:39 AM.



Advertisement