OsiROSE setup guide (and a few other helpfull guides aswell.

Results 1 to 5 of 5
  1. #1
    Apprentice merlon is offline
    MemberRank
    Aug 2010 Join Date
    10Posts

    config OsiROSE setup guide (and a few other helpfull guides aswell.

    This guide was taken from the osrose forums with the permission of the creator (me).

    Ok, so i was using psycoshooter's old guide from like 2007, and many of the links and stuff are outdated, so I am making a guide for all of you. :D :D :D

    SETUP

    ok heres what we do,

    First you need to download the file trough the OsIrose SVN: https://osirose.googlecode.com/svn/trunk/

    You can download this with TortoiseSVN which can be found here :

    32bit :
    Download TortoiseSVN from SourceForge.net

    64bit : Download TortoiseSVN from SourceForge.net

    Download source code:
    Create a folder somewhere, right click on it and choose "SVN checkout".
    In the dialog box that says "URL of repository", Enter the URL address of the SVN : https://osirose.googlecode.com/svn/trunk
    And the directory should be there ,if not then click the "..." button to browse.
    Ok you may need to wait a while for it to load everything up....

    Once its finished, go into your folder that you put in the SVN directory, click on the osirose folder:


    Then click on the Binary Folder:


    Once you get into that you should see this:
    http://forum.dev-osrose.com/download...e=view&id=2301

    double click on the .conf files and open them with notepad.

    Now download MySQL and Navicat

    64bit MySQL: MySQL :: Select a Mirror to Start Downloading - mysql-essential-5.1.49-winx64.msi
    32bit MySQL: MySQL :: Select a Mirror to Start Downloading - mysql-essential-5.1.49-win32.msi

    Navicat Lite (free) : Navicat Lite (Multiple Database GUI) - Free software downloads and software reviews - CNET Download.com

    Now you have that out of the way continue on with your configs putting in the info that you put in set them up with your MySQL data that you put in during installation.
    And edit your ip's if you want to let other people come on.

    How to get your local IP (LAN IP) :
    You have to get your local IP so launch "Command prompt" (Start->Programs->Accessories->Command Prompt).
    Once it's launched, type "ipconfig" and enter, you'll have the local IP (LAN IP), the mask and the gateway. (not really
    useful)

    How to get the LANsubnetmask:
    Quote Originally Posted by lmame
    The lansubmask is the first three numbers of lanip=192.168.0.103, it's the "generic" part of your local IP.
    It allows you playing from your local network as well as outside of it (see this thread).
    How to get your internet IP ( Server IP):
    Simply launch the website Welcome to whatisyourip.com - Search Results for "whatisyourip.com" and you'll have it.
    It'll be at the top ,underlined, and blue letters.


    This is what you Loginserver.conf should look like :
    Code:
     
    [DATABASE]
    mysql_host=(your Mysql host)
    mysql_user= (your Mysql user)
    mysql_pass=(your Mysql Password)
    mysql_database=irose
    mysql_port=3306
     
    [SERVERDATA]
    serverid=1
    servertype=0
    serverip=127.0.0.1 (replace this with your internet IP: whatimyip.com )
    serverport=29000
    servername=(your server name)
    connection=2
    lanip=127.0.0.1 (replace this with your LAN ip)
    lansubmask=127.0.0.1 (replace this with your Lansubnet mask)
     
    [LOGINSERVER]
    accesslevel=100
    CreateLoginAccount=1
    usethreads=0
     
    [PASSWORDS]
    loginpass=789456
    charpass=456123
    worldpass=321654
    And the charserver.conf
    Code:
     
    [DATABASE]
    mysql_host=(your Mysql host)
    mysql_user=(your Mysql user)
    mysql_pass=(your Mysql password)
    mysql_database=irose
    mysql_port=3306
    AutoQueryTime=600
     
    [SERVERDATA]
    serverid=2
    servertype=1
    serverip=127.0.0.1 (replace this with your internet IP: http://whatimyip.com )
    serverport=29100
    servername=Channel1
    parentid=0
    accesslevel=100
    connection=2
    lanip=127.0.0.1 (replace this with your LAN ip)
    lansubmask=127.0.0.1 (replace this with your Lansubnet mask)
    CharsPort=29110
     
    [CHARSErVER]
    deletetime=3600
    usethreads=0
     
    [PASSWORDS]
    loginpass=789456
    charpass=456123
    worldpass=321654
    And the worldserver.conf
    Code:
     
    [DATABASE]
    mysql_host=(your Mysql host)
    mysql_user=(your Mysql user)
    mysql_pass=(your Mysql password)
    mysql_database=irose
    mysql_port=3306
    AutoQueryTime=600
     
    [SERVERDATA]
    serverid=3
    servertype=2
    serverip=127.0.0.1 (replace this with your internet IP: http://whatimyip.com )
    serverport=29200
    servername=Channel 1
    maxconnections=500
    parentid=1
    connection=2
    lanip=127.0.0.1 (replace this with your LAN ip)
    lansubmask=127.0.0.1 (replace this with your Lansubnet mask)
    charip=127.0.0.1 (leave this the same)
     
    [WORLDSERVER]
    accesslevel=100
    exp_rate=3
    drop_rate=1
    drop_type=2
    zuly_rate=4
    welcome_msg=test
    autosave=1
    savetime=120
    mapdelay=10
    visualdelay=200
    worlddelay=700
    partygap=10
    maxstat=300
    fairy=1
    fairystay=45
    fairywait=30
    fairytestmode=0
    playerdmg=120
    monsterdmg=100
    cfmode=0
     
    [server2server]
    charip=127.0.0.1
     
    [PASSWORDS]
    loginpass=789456
    charpass=456123
    worldpass=321654
    Ok we got all that confusing stuff over with ,now we have to go into navicat...
    Click on the connection button.


    Then click on "MySQL" on the dropdown menu.
    Then a box called "connection" should pop up
    Fill it out with you MySQL info, and put "irose" in the top dialog box.


    Then click on test connection: And if it works then youre good to go, click "ok"
    it should make a connection called irose, double click on it. the dolphin should turn blue.
    then right click on the dolphin and click the option "New Database"
    A box named "create new database" should pop up name your database irose, dont bother with the "coallation" thing.
    Here's what it should look like:
    http://forum.dev-osrose.com/download...e=view&id=2304

    click "ok"
    after that and you should see this:


    double click on the database "irose" and the barrel thing should turn green:


    you're done with this for now, so close Navicat.

    Now you open up your server files folder!
    got to this location in you folder :
    osirose\Database\
    i like to foce it thorugh so i dont deal with all the crap, so i edit it to look like this (you can edit by right clicking and clicking on the "edit" button.)

    Code:
     
    @echo off
     
    REM - Default values
    set bin=C:\Program Files\MySQL\MySQL Server 5.1\bin
    set user=root
    set pass=root
    set db=iROSE 
    set host=localhost
    echo.
    echo                  ===== OSpRose Online Database Installer ======
    echo.
     
    REM - Menu
    :menuoptions
    echo.
    echo Backing up your database is HIGHLY recommended before installing a new database
    echo Please select an option
    echo =======================
    echo 1) Backup Database
    echo 2) Install Database
    echo 3) Quit
    :menu
    set option=0
    set /p option="Select an option: "
    if %option%==1 goto backup
    if %option%==2 goto install
    if %option%==3 goto quit
    goto menu
     
    REM - Backup
    :backup
    echo.
    echo Backing up MySQL Database %db% on host %host% to file %db%_backup.sql
    %bin%\mysqldump.exe --add-drop-table -h %host% -u %user% --password=%pass% %db% > %db%_backup.sql
    echo Database Backed Up
    echo.
    goto menuoptions
     
    REM - Install
    :install
    echo.
    echo Installing prose.sql to %db% on %host%
    %bin%\mysql.exe -h %host% -u %user% --password=%pass% -D %db% < prose.sql
    echo Database Installed
    echo.
    goto menuoptions
     
    REM - Quit
    :quit
    echo.
    echo Thanks for using the OSpRose Database Installer :-) Exiting...
    pause
    copy and paste this into your db_installer.bat so it'll look like this :

    it should install everything if you folllow its instructions.

    Now you're on the final strech, you have to pick a client, which can be found in this thread :
    osROSE Forums &bull; View topic - Client downloads

    ok download the client you want and you have to get the 3DATA out of it and put it in your 3ddata folder, in your binary folder.
    I would use the Hrose client with oro if you're a beginner. so download that and use Snipahs VFS extractor to extract the 3ddata and put it in the according folders in the 3ddata folder in your binary folder.

    After you do that go to your binary folder and double click on (in this order) loginserver.exe charserver.exe and worldserver.exe

    then you must make a launcher so open up notepad and put this in it :
    Code:
    TRose.exe @TRIGGER_SOFT@ _server 127.0.0.1(or your external ip)
    save it as launcher.bat and put it in your rose client folder.
    now when you have done this launch the launcher.bat and play!
    you can create accounts with just login it will say that the account doesn't exist.
    login with the same information and you will be in!
    when you want to make yourself gm you must go to your navicat MySQL database administration tool open the account table and set you accesslevel to 300 this is for admin, 100 is for normal user.

    Usefull Guides
    NOTE: credits giving to those who made them in the CREDITS section of this guide.

    Port Forwarding Guide:
    osROSE Forums &bull; View topic - [GUIDE] IP/Port Forwarding for osRose

    Multiple Channels Guide:
    osROSE Forums &bull; View topic - [GUIDE]Multiple Channels

    Making a skinnable Launcher-Patcher (OsIrose):
    osROSE Forums &bull; View topic - [GUIDE] (iRose) Making your own Skinnable Launcher + Patcher

    Changing Junon to snow (with resources) :
    osROSE Forums &bull; View topic - Guide: Junon --> snow



    Hope this will help!

    CREDITS
    Me (merlon)
    Lmame (for support and the port forwarding guide and config instructions.)
    Choseal (for helping me make this guide better)
    BuzBee (for making the multiple channels guide)
    Mini (for the junon to snow guide and the resources)

    EDITS

    EDIT: Made the LAN subnetmask, and LANip stuff more readable (thanks Choseal !!!! )
    EDIT2: Made the whatismyip.com link working, (and this also goes to choseal)
    EDIT3: Made a credits section!
    EDIT4: Added a multiple channels guide (made by buzbee)
    EDIT5: Updated credits:BuzBee (for making the multiple channels guide)
    EDIT6:Added lmame's port forwarding guide.
    EDIT7: Updated Credits (lmame for port forwarding guide)
    EDIT8:Changing the weather in junon. (credits mini and me)
    EDIT9: Added EDITS section.
    EDIT10: Added Usefull Guides section.
    EDIT11: Deleted Lmame's port forwarding guide and put link in Usefull Guides section.
    EDIT12:Deleted buzbee's Multiple channels guide and put link in Usefull guides section.
    EDIT13:Added Unknown's Launcher/Patcher guide in the Usefull guides section.
    EDIT14:Deleted Mini's guide to changing junon to snow, and put a link in the usefull guides section.
    EDIT15: Changed title (last edited #/#/#)
    EDIT16: Made edits to the config instructions ,Thanks Lmame!
    EDIT17: Made even more edits to the configs with MORE help from lmame
    EDIT18: took out the pics that were just listed as attachments, didnt look good.
    Last edited by merlon; 03-08-10 at 07:35 PM.


  2. #2
    Member winnerke is offline
    MemberRank
    Jul 2010 Join Date
    81Posts

    Re: OsiROSE setup guide (and a few other helpfull guides aswell.

    Where do i get the Mysql files?

  3. #3
    Novice daanov is offline
    MemberRank
    Jan 2011 Join Date
    1Posts

    Re: OsiROSE setup guide (and a few other helpfull guides aswell.

    Hi Merlon,
    first of all, it's a gr8 explanation!
    But ive got a little problem at the end,
    I started my loginserver.exe, no problem, working good.
    But when im starting charserver.exe it shows a problem, it says

    [fatal error]: could not execute query: table 'irose.channels' doesn't exist
    [info]: Reconnecting to mysql
    [fatal error]: could not execute query: table 'irose.channels' doesn't exist
    [info]: Reconnecting to mysql
    [fatal error]: could not execute query: table 'irose.list_clan' doesn't exist
    [info]: Reconnecting to mysql
    [fatal error]: server could not start


    Could you please help me?
    I'd realy appreciate it.

    Daanov

  4. #4
    Valued Member kiorochi is offline
    MemberRank
    Dec 2010 Join Date
    123Posts

    Re: OsiROSE setup guide (and a few other helpfull guides aswell.

    my rorlserder dont upload :S fail always

  5. #5
    Novice viper000 is offline
    MemberRank
    May 2011 Join Date
    3Posts

    Re: OsiROSE setup guide (and a few other helpfull guides aswell.

    Hi sir i follow all your guides

    my login,world,char are ok

    and i create my bat launcher and put my external ip its ok

    i can log in with my account but when im in log in it does not have channels

    just channel 1 but when i click that and ok nothing happens

    help please?


    thanks. :)



Advertisement