Ragnarok Online Server Guide – Make own Ragnarok Online/Offline Server Guide 3

by Posted on

Change the basic connection guide

After we finished first step and second step is done successfully, we are ready to connect the fresh ragnarok server to the database (using XAMPP). Now, prepare yourself to follow these steps:

Create Database for Ragnarok Player Game Datas and Players Logs

  1. Make sure the Apache and MySQL are running.
  2. Open your favorite web browser, then open this page http://localhost/phpmyadmin
  3. Enter the correct username and password, default is root and password is empty.

    Type correct username and password to login to PHPMyAdmin
    Type correct username and password to login to PHPMyAdmin
  4. Click on “Database” menu.

    Click "Database" menu on PHPMyAdmin
    Click “Database” menu on PHPMyAdmin
  5. Create a new database for your ragnarok server, example yourragnarokdb.

    Create a new database for ragnarok server
    Create a new database for ragnarok server
  6. Then, click your ragnarok database –yourragnarokdb–

    Select the new database that created
    Select the new database that created
  7. Click the “Import” menu, you don’t need make the ragnarok tables manually. Every emulator provides the database for us on .sql file.

    Click "Import" menu to import ragnarok tables
    Click “Import” menu to import ragnarok tables
  8. So, click “Choose File”.

    "Choose File" to select the .sql file of ragnarok server
    “Choose File” to select the .sql file of ragnarok server
  9. Find the mail.sql file on trunk/sql-files. 

    Choose "main.sql" file for main ragnarok database
    Choose “main.sql” file for main ragnarok database
  10. Click the main.sql file, then click “Open”.
  11. OK, you choosed the .sql file to imported, then click “GO”.

    Click "GO" to import main.sql of ragnarok database
    Click “GO” to import main.sql of ragnarok database
  12. If it done, you will get many tables like this.

    Ragnarok main tables
    Ragnarok main tables
  13. Afterthat, we need to import more some tables for ragnarok server logs. I suggest you to make new database. Click on Database menu > give the database name. Example yourragnaroklogsdb. 

    Create a new database for Ragnarok Logs
    Create a new database for Ragnarok Logs
  14. With same way, click the database –yourragnaroklogsdb-.
  15. Click on “Import” menu to add ragnarok logs tables.

    Import .sql file for Ragnarok Logs database
    Import .sql file for Ragnarok Logs database
  16. The .sql of logs tables is same in trunk/sql-files. Select the logs.sqlfile, then click “Open”.

    Choose logs.sql that contain logs tables
    Choose logs.sql that contain logs tables
  17. Afterthat, click on “GO” button. And the tables are imported successfully.

    "GO" to import ragnarok logs tables
    “GO” to import ragnarok logs tables
  18. And the database will gets these tables for log datas.

    Ragnarok Logs tables
    Ragnarok Logs tables

Connecting Ragnarok Server to MySQL Server

And now, to make connection between MySQL server and ragnarok server, we need change some configuration files on trunk/conf. Well, follow these step-by-step guide to connecting your ragnarok server.

  1. Open “inter_athena.conf“, you can open this file with notepad. But, I give a recommendation to use Notepad++, you will get easy way to know the content line. On inter_athena.conf file, the most important things are, change the MySQL Connection for your database on MySQL Server. You must change the username, password, and database name.
  2. First, change the setting for login-server_sql. You must enter the correct username, password, and database. Username: root (default, super-user username), password: 123456 (I set it before, or keep it empty if you never change the password), and database, use yourragnarokdb.
  3. Then, change the configuration for map-server_sql and char-server_sql. Use same datas like above.
  4. For Log database, only change the database name, change it be yourragnaroklogsdb. Look at this image below, look the differences.

    Change inter_athena.conf file
    Change inter_athena.conf file
  5. Next, open “char_athena.conf” then edit it.

    Change char_athena.conf file
    Change char_athena.conf file
  6. Next, open “login_athena.conf” then edit it.

    Change login_athena.conf file
    Change login_athena.conf file
  7. Next, open “map_athena.conf” then edit it.

    Change map_athena.conf file
    Change map_athena.conf file
  8. After we decide userid and passwd for conf files, we must change the userid and user_pass on login table inside yourragnarokdb.

    Edit login table values for connection on yourragnarokdb database
    Edit login table values for connection on yourragnarokdb database
  9. Change the userid and user_pass be “YourRO”. And for user_pass, change the Function column be MD5. Click “GO” to finish the editing.

    Change the userid and user_pass with md5 function
    Change the userid and user_pass with md5 function
  10. This is the result.

    Result after editing the connection record
    Result after editing the connection record
  11. Now, your ragnarok offline server is ready, run it by clicking runserver-sql.bat on trunkfolder.

    Run the ragnarok server with sql server
    Run the ragnarok server with sql server
  12. Wait it until ready to use and your server ready to receives player.

    Your ragnarok server is ready to use
    Your ragnarok server is ready to use

Next Step 4:

Ragnarok Online Server Guide – Make own Ragnarok Online/Offline Server Guide 3: Guide to set your custom rate server Part 1. (How to set the drop rates, exp rates, maximum levels, maximum statuses/parameters, and set the commands?)

Tell your friends

Published by PServeRO

PServeRO is website that provides ragnarok modification, source modification, custom commands. Customization for ragnarok online or ragnarok offline. Also, guides to make your own ragnarok server, installation guides, step by step to make ragnarok server. Ragnarok modification based on eAthena, rAthena, 3CeAM, Hercules, and idAthena.

8 Replies to “Ragnarok Online Server Guide – Make own Ragnarok Online/Offline Server Guide 3”

  1. Hello Pservero, i guess this guide is a little bit outdated,right?;) Crack i had a lot of problem looking for some of the files(lua,lub and so on) . Will you make a part 4 to this? (i mean, is there even a need for a fourth one? I saw above me a post that requested it :p).

  5. Hi….i get this after i run runserver-sql.bat…all 3 server says d same

    [Info]: Done reading conf/import/char_conf.txt.
    [Info]: Done reading conf/char_athena.conf.
    [Info]: Done reading conf/import/inter_conf.txt.
    [Info]: Done reading conf/inter_athena.conf.
    [Info]: Done reading conf/import/inter_conf.txt.
    [Info]: Done reading conf/inter_athena.conf.
    [Info]: Connect Character DB server…. (Character Server)
    [SQL]: Access denied for user ‘root’@’localhost’ (using password: YES)
    [Debug]: at f:\users\pet\desktop\rathena\src\char\inter.c:771

    Char-Server has terminated abnormally.
    Restarting in 15 seconds, press Ctrl+C to cancel.

    1 more thing, i cannot find this:

    2. First, change the setting for login-server_sql. You must enter the correct username, password, and database. Username: root (default, super-user username), password: 123456 (I set it before, or keep it empty if you never change the password), and database, use yourragnarokdb.
    3. Then, change the configuration for map-server_sql and char-server_sql. Use same datas like above.

    Where is login-server_sql, map-server_sql, char-server_sql? its not in the conf folder

    1. 1. It’s becausse the ragnarok server can’t found the database that needed.
      2. & 3. Open your inter_athena.conf, look at picture on step no. 4 at this Connecting Ragnarok Server to MySQL Serversection.

Leave a Reply