Need help setting up SQL stuff, the wiki is really sparse on info here

[kanemi 0]

I tried Google, not much help for the specifics here.

 

From the wiki:

 

 

 

Your login table should match. Use this SQL query (or make the changes using your favourite SQL gui):

use databasename_rag;UPDATE loginset `userid` = "[new user]", `user_pass` = "[new password]" where `account_id` = 1;

I don't know where this login table is, or what a 'query' is.

 

 

About midway down this file, you will find your SQL settings. These will be set as accordingly.

• The 'sql.db' settings control what the login-server reads for it's database settings.
• Hostname is the IP of the SQL server.
• Username is the username you use to login. For security, this should NEVER be root!
• Password is the password that the user will login with.
• The database is set to whatever the database name will be. Usually, this is just 'ragnarok'.

For this last one, I tried setting up a server or something with a password, but it would always error when I tested the connection until I removed the password.
I don't know what to do with this info about 'sql.db', and moreover don't see a 'sql.db' section.

Edited November 27, 2016 by kanemi

[anolythe 0]

i have the old guide saved, wanna see it for reference?

INDEX

 

Downloads:

1. Server Files

2. MySql Community Server

2.1 MySql GUI TOOLS

Guides:

I. - How to setup your Server Files

II. - MySql Setup

III. - Client Data Editing/Server Client Hexing

V. - Web CP

 

DOWNLOADS:

 

1. Server Files Revision - 14260 eAthena SVN Trunk Version Main

-Only works to RagexeRE 2010-02-17 client, or you can also edit mmo.h and compile it to your own.

 

2. MySql Community Server 5.1 - For windows XP and Vista or 32bit computer For Windows 7 or x64 bit computer

2.1 MySql GUI TOOLS 5.0 - CLICK ME HERE

-for those who can't configure your own MySQL you need to recover your pc or "reformat" or the hardiest is to search on how to uninstall you previous MySQL(complete UNINSTALL,this is an issue about MySQL)

 

GUIDES:

 

I - How to setup your Server Files:

 

-Go to your Server Folder, Then Click "conf" Folder

-open the "char_athena.conf" using WORDPAD or NOTEPAD

-find userid: s1 - change "s1" into what you wan't!(REMEMBER THIS ONE)

-find passwd: p1 - change "p1" into what you wan't!(REMEMBER THIS ONE)

-find server_name: eAthena - change this to your own RO server Name

-find //login_ip: 127.0.0.1 - Delete the "//" a.k.a Double Slash, and change it to your LAN IP Address - go to your "START" and click CMD and write "ipconfig" without the "

 

NEXT:

-open the "login_athena.conf" using WORDPAD or NOTEPAD

-find new_account: yes - if you want your server to use _M to create accounts, you can also change it to "no" if you wan't your.

 

NEXT:

-open the "map_athena" using WORDPAD or NOTEPAD

-find userid: s1 - change "s1" into what you wan't!(REMEMBER THIS ONE)

-find passwd: p1 - change "p1" into what you wan't!(REMEMBER THIS ONE)

-find //char_ip: 127.0.0.1 - Delete the "//" a.k.a Double Slash, and change it to your LAN IP Address - go to your "START" and click CMD and write "ipconfig" without the "

-find //map_ip: 127.0.0.1 - Delete the "//" a.k.a Double Slash, and change it to your WAN IP Address - go to! http://whatismyipaddress.com/

 

IF!!! your IP address is Dynamic! then go to http://www.no-ip.com and use there applications and instructions.

Example of Word WAN IP ADDRESS(or DNS in short term):

-pakman.no-ip.biz

-cpanel.servegame.com

-ragnarok.no-ip.biz

-ekotan.no-ip.org

etc...

___________

 

-Open motd.txt

EDIT:

// Internal default is limited to 128 lines. If you need more, you will need to modify the MOTD_LINE_SIZE definition in pc.c

Welcome to eAthena SVN Version! Enjoy! Please report any bugs you find. - DELETE ALL OF THIS AND CHANGE IT TO:

 

Welcome to "YourServerName" ENTER

"YOUR SERVER MESSAGE"

___________

 

-open subnet_athena.conf

-put like this ---> 

subnet: 255.0.0.0:127.0.0.1:127.0.0.1

subnet: 255.255.255.0:192.168.1.2:192.168.1.2

 

___________

 

-click the "grf-files.txt

grf: <data file path>

sample: grf: C:/Program Files/Gravity/Ragnarok Online/data.grf

-----> THIS IS 2nd Backup about MAPCACHE, some of other players editing some of our maps then they will make a "memo" with that map it's world of stock, just like that guys

 

-find data_dir: "Then your Server data directory"

 

SERVER FILES EDITING, IS NOW DONE!!

 

II. - MySql Setup:

-Install the MySQL Gui

-Install the MySQL Community Server

:::::IF YOUR PC CAN'T INSTALL AND CONFIGURE YOUR SECURITY WINDOW, then YOU NEED TO RECOVER OR REFORMAT YOUR PC!:::::

 

Run Your MySql Query

Server Host:localhost

Username:root

Password: YOUR_PASSWORD

Default Schema: ragnarok

 

then click "OK" if not exist

--------------

-then click the file > Open Script > "GO TO YOUR SERVER FILES FOLDER > click sql-files folder > click the "main.sql" file

-script 1 tab should POP-UP > then click the green button "EXECUTE" > scroll it down! > double click the "login" 

-change the s1 to your PASSWORD from the previous that has (REMEMBER THIS ONE)

-change the p1 to your PASSWORD from the previous that has (REMEMBER THIS ONE)

- then click the "APPLY CHANGES" > then close "ALT+F4"

 

Open it again, The MySql Query

Server Host:localhost

Username:root

Password: YOUR_PASSWORD

Default Schema: log

 

then click "OK" if not exist

--------------

-then click the file > Open Script > "GO TO YOUR SERVER FILES FOLDER > click sql-files folder > click the "log.sql" file

-script 1 tab should POP-UP > then click the green button "EXECUTE" > then close "ALT+F4"

 

PROTECT SECTION:

 

Run your MySql Administrator:

Server Host:localhost

Username:root

Password: YOUR_PASSWORD

 

then click "OK"

 

-CLICK THE "USER ADMINISTRATION"

-click "add new user" button

-MySql Username: ragnarok

-Password: PUT A PASSWORD(KEEP THIS)

-Confirm Password: PUT A PASSWORD(KEEP THIS) 

-"ANY PASSWORD YOUR WANT TO PROTECT IT FROM HACKERS"

 

Then Click "Schema Privileges"

-click the "ragnarok" then click the button "<<"

-click the "log" then click the button "<<"

-click apply changes

 

Go to Your ServerFolder/Conf/inter_athena.conf

EDIT:

// Global SQL settings

// overriden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: ragnarok

sql.db_password: ragnarok - change this to your "PUT A PASSWORD(KEEP THIS)" --> go back find that word!

sql.db_database: ragnarok

sql.codepage:

 

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok - change this to your "PUT A PASSWORD(KEEP THIS)" --> go back find that word!

char_server_db: ragnarok

 

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok - change this to your "PUT A PASSWORD(KEEP THIS)" --> go back find that word!

map_server_db: ragnarok

 

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok - change this to your "PUT A PASSWORD(KEEP THIS)" --> go back find that word!

log_db_db: log

log_codepage:

 

YOUR NOW DONE MYSQL!

 

III CLIENT DATA EDITING/Server Client Hexing:

-1st download the HEX EDITOR form http://www.download.com search "Hex Edit" use HxD editor(Simple and no bug encounter)

 

Small Instructions: Please if you wan't to remove a HEX value, don not use your BACK SPACE, instead use the HEX windows and make it "00" to make it no value

STEPS:

-install and open it

-click "FILE(TAB)" select "OPEN" open your client.exe

-NOW WE NEED TO EDIT THE (DATA.INI and Your Server Name)

-so use CTRL+F(to open the FIND window)

-your now in the window of "FIND"

-so go to dropdown menu on it then click "Datatype" scroll it down, then choose String

-before that, backup 1st to your client!

-then go search for: 2010-02-17RagexeRe(It depends on what client you used) change it to "YourRO" (DON'T USE BACKSPACE TO REMOVE!)

-then search the: "Data.ini" change it to DATA.SRO or DATA.ROO whatever!(DON'T USE BACKSPACE TO REMOVE!)

-then close it

-go to your ragnarok folder, then make a txt file, then put these

CODE

[Data]

1=yourro.grf

2=rdata.grf

3=data.grf

 

then "SAVE AS" put "all type" then rename it into DATA.SRO or DATA.RRO whatever word that you put to your client!

 

then thats all!

 

IV Web Cp Using CeresCP:

-1st your need is to download this files!

--Ceres CP

--FileZilla FTP transferer

--SIGNUP HERE!!! http://magistar-networks.com/

 

-now we need to make a user account at WWW.ZYMIC.COM sign-up there!

-then login, make a website, login to your website using there control panel

-then install your FileZilla.exe

-then you need to know what is your FTP accounts by searching it to your account info @ ZYMIC webhost

-then open your FileZilla then put your HOST: mine is "ragnarokph.uuuq.com" that was my FTP host then put your USERNAME: mine is "ragnarokph" THEN YOUR PASSWORD: mine is "********" LOL

-then use your KEYBOARD PRESS "ENTER"

-you'll now go to your WEBSITE folders, how fast right????

-so create a folder there then nameit "cp" or whatever

-then put all your CERES CP files

-then go to your WEBSITE NOW, ofcourse by using FIREFOX OR InternetExplorer http://ragnarokph.uuuq.com/cp/

-then you can now install your website

 

LIVE DEMO: http://ragnarokph.uuuq.com/cp/

 

--this is only a live DEMO, u can't install it coz i've already remove the INSTALL button,thats all

 

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

 

Hi guys im here to share.. how to set up Ceres Control Panel

 

Things You Need!

1st. Download the Ceres CP Here

2nd. mySQL My SQL

 

Use this:

Vertrigo Serv Vertrigro Serv

Xampp Xampp Here

Or Use Webhost Webhosting here's the link

 

Set up

Execute 1st the rag_ragsrvinfo.sql and table.sql using MYSQL Query, < cp folder ~> install ~> Manual

1st. Open ur Vertigro

2nd. Put ur CP folder on ur Xampp,Vertigro <~~ Put the Cp folder on www folder [ if you're using Vertigro ] for Xampp [ htdocs folder ]

3rd. type ur 127.0.0.1/cp on ur browser

4th. Click the Run Installation Script

 

We're on installation script

 

<MYSQL SETTINGS>

Ragnarok Host > ur IP or ur host ip

Ragnarok User > ur s1

Ragnarok Password > ur p1

 

<SERVERINFO SETTINGS>

Name: Your RO Ceres Panel

Rate: 10k/10k10k <<~~~~ EXAmple

 

<SERVER STATUS>

Login IP: Your Host IP, you can use 127.0.0.1 too

Char IP: Same Thing

Map IP: Same thing

 

<Control Panel Mail Send>

SMPTP Server: Your Host ip, or 127.0.0.1

Admin e-Mail: Your Contact Email

Username: s1

Password: p1

 

After the installation goto ur cp folder then Install Folder > Copy the config.php paste it on cp folder then rename or delete the install folder hope you understand sry :=(

 

=====================================================================================

 

by: bowie

= eAthena SQL = 

 

1.

Download eAthena SQL from my site. 

Link

 

2.

Extract it to anywhere you want but not in your desktop.

 

3.

Go to Conf folder, open grf-files.txt and edit the patch where your RO folder is but default is C:\Program Files\Gravity\RO\

 

4.

Files we need to edit are char_athena.conf, and map_athena.conf.

Use Notepad or Wordpad to edit .conf files.

 

char_athena.conf

-Edit userid: s1 and user_pass: p1 for Server Account.

Just change s1 and p1 to anything you want that we need it later for MySQL in login table.

It's for to prevent ppl to hack your computer.

-Remove // for login_ip:, char_ip: and change 127.0.0.1 to your Internet IP (IP for letting ppl to connect to your server) but if you just want to test, then just use 127.0.0.1, which is Local IP/Computer IP.

-Now we are done with char_athena.conf so, just SAVE and exit.

 

map_athena.conf

-Edit userid: s1 and user_pass: p1 that need to be same as you edited in char_athena.conf.

-Remove // for char_ip:, map_ip: and change 127.0.0.1 to your Internet IP (read char_athena.conf)

-SAVE and exit.

 

Everything should be done now for eAthena Server side so, time to set up MySQL.

 

= MySQL =

 

1.

Download MySQL 5.0.67, MySQL GUI Tools 5.0-r15

This is for Windows

MySQL 5.0.88

MySQL GUI Tools 5.0-r17

 

NOTE: For other OS, check here Link

 

2.

- Install MySQL 5.0.88

-Click Next.

-Choose Typical and click Next.

-Click Install. 

-Choose Skip Sign-Up and click Next. 

-When It's finished, just click Finish and don't uncheck the Configure the MySQL Server now.

-Now, you can either choose Detailed Configuration or Standard Configuration, which is up to you but if you are unsure, just choose Standard Configuration and click Next. 

-In Service Name:, pick MySQL5 and click Next. 

-Just enter the password you wish for root and it's important to remember cause we need it later. Click Next. 

-Just click the Execute and when done, just click Finish. Go to Task Manager and check if mysqld-nt.exe is running in processes although it's not necessary if no error occured during installation..

 

3.

Install MySQL GUI Tools 5.0-r17. We only need MySQL Administrator and MySQL Query Browser but just install everything. 

 

4.

Start MySQL Administrator and it will prompt up a window. Fill in Host Name, Username and Password and leave other field as it is but to make sure everything is correct, it should look like this:

 

 

Stored Connection: (just leave it empty)

Server Host: localhost

Username: root

Password: (enter the password we created before for root) 

Port: 3306

 

Click OK and you should be in MySQL Administrator now.

Go to User Administration and Click New User and enter this:

 

MySQL User: ragnarok

Password: ragnarok

Confirm Password: ragnarok

 

When you are done, then just click Apply changes and exit MySQL Administrator.

 

5.

Start MySQL Query Browser and it will prompt up a window that look like MySQL Administrator except there is a new field call Default Scheme. It should look like this:

 

Stored Connection: (just leave it empty)

Server Host: localhost

Username: root

Password: (enter the password we created before for root)

Default Schema: ragnarok 

Port: 3306

 

6.

-When you are in MySQL Query Browser, click once on ragnarok database that is below Schemata.

-Go to menu, click File and choose Open Script...

-We need to execute main.sql and logs.sql, so look for the main.sql, which should be in sql-files folder in eAthena Server and other .sql files.

-Pick main.sql and click Open.

-Click the Green Execute Icon to the upper right to execute. Do the same with mail.sql now and execute it. 

-When you are done, we need to create log database by right-click somewhere within the table where the databases are and choose Create New Schema and type in log and click OK.

-Double-click on log database, go to menu, click File, choose Open Script..., open logs.sql and Execute. 

-Double click ragnarok database to expand to see all tables.

-Look for login table and double click and double click again.

-Click once on Edit so, we can edit the cells. This icon should be in bottom.

-For userid: and user_pass:, type in the name that you used in char_athena.conf and map_athena.conf.

-When you are done editing, just click the Apply Changes that is next to the Edit icon. 

 

NOTE: userid: and user_pass: must be same in login table, char_athena.conf and map_athena.conf.

 

7.

- In menu, click Tools and choose MySQL Administrator. 

-Go to User Administration and click ragnarok user.

-Now, go to Schema Privileges and click once on ragnarok database/schema and click this button << and then click Apply changes. Do the same with log database/schema. 

 

Now we are done with MySQL.

 

=Client Side=

 

1.

Download FullDATA from my site.

Link

 

2.

-Extract FullDATA to your RO folder so you have a data folder in your RO folder.

-Inside data folder, look for sclientinfo.xml and open it with Notepad. Put your WAN IP (Internet IP) there so you can login to your RO Server to play.

-Send your sclientinfo.xml to those ppl who want to play your server or just tell them your WAN IP. 

-Now, just download Hexed client and extract to your RO folder. Use this Hexed client to play RO game.

 

Next set up is for hosting Ragnarok Online Control Panel, which is optional. 

 

=Abyss Web Server & PHP=

 

NOTE: This is for user who is using MySQL 4.1.x and higher. 

1. Download Abyss Web Server and PHP

Abyss Web Server

PHP 5.2.11

 

2. Create a folder name PHP in C: and extract PHP 5.2.11 in the PHP folder you created. Will be C:\PHP\ 

3. Go to C:\PHP\ext\ and copy php_mysql.dll to your PHP main folder, which mean in C:\PHP\ 

4. In PHP main folder, copy php.ini-recommended to your Windows folder. Rename php.ini-recommended to php.ini and open it with Worpad or Notepad but I would suggest Worpad. Look for this line ;extension=php_mysql.dll and remove this ; so it will be extension=php_mysql.dll. Save and exit.

5. Install Abyss Web Server first and choose if you want to manually start it or start it with Windows.

After installation and when ask if you want to run Abyss Web Server now, then choose YES.

It will run and configure in Internet Explore. Choose Language and you will be in next page. Type in your login name and password to make an account.

You will be in Abyss Web Server Console now. Click the Configuration button, which is next to Stop and select Scripting Parameters.

Check in Enable Scripts Execution

Click Add in Interpreters and click Browse..., go to the directory you installed PHP and select php-cgi.exe or just simple type in this C:\PHP\php-cgi.exe

In Type, choose PHP Style

Check in Use the associated extensions to automatically update the Script

In Associated Extensions, click Add and type in php and press OK

Now just click the OK

 

In Custom Environment Variables, click Add and enter this...

-------------------------------

Name: REDIRECT_STATUS

Value: 200

-------------------------------

Click OK when done and then click OK in bottom to go back to Configuration

Click Index Files icon, click Add and enter index.php and click OK

Everything is done for Abyss Web Server now.

NOTE: Abyss Web Server must be running if you want other people to access your webserver (ROCP or anything)

 

= Ragnarok Online Control Panel =

 

1. Download ROCP here

ROCP 4.3.4a

 

2. Go to Abyss Web Server folder and then to htdocs folder and extract ROCP 4.3.4a there or any version you have or want to use.

You can either make a new folder to put all ROCP files there or just put all files in htdocs folder.

Example, if I put all files in a new folder with the name CP433, then your ROCP page will be http://YourIPhere/CP433/

but if you just put all files in htdocs folder, then your ROCP page will be http://YourIPhere/

You can use IP 127.0.0.1 to test but if you want people can access your ROCP page, then they must enter your Internet IP or the IP they use to connect to your server.

 

3. Start MySQL Query Browser, go to File in menu and choose Open Script... and look for the install.sql, which should be in rocp\install\Athena & Freya\. So, just execute install.sql.

If you get error, then try to create a cp database manually. Right-click somewhere within where your ragnarok database is and choose Create New Schema and type in cp. Double-click the cp database you just created. Now just do as I explained in step 2.

 

4. In menu, click the Tools and choose MySQL Administrator. Go to User Administration and in User Information, enter this:

---------------------

MySQL User : cp

Password: cp 

Confirm Password: cp

---------------------

Go to Schema Privileges, click the cp database below to highlight it and click this button <<

NOTE: If you have cp account in your login table, then you have to delete it otherwise ppl can use it to access your ROCP as Admin but you can simply edit it with other name and password.

 

5. Among all ROCP files... open config.php in Notepad and edit these lines:

 

Important:

$CONFIG['db_host'] = 'localhost';

$CONFIG['db_username'] = 'cp';

$CONFIG['db_password'] = 'cp';

$CONFIG['cp_db_name'] = 'cp';

$CONFIG['db_name'] = 'ragnarok';

$CONFIG['passphrase'] = 'whatever'; <- Enter any name/password here but no unique letter 

$CONFIG['server_type'] = '2'; <- Must be 2

 

Optional:

$CONFIG['check_server'] = '1'; <- Enter 0 if you don't want it to check server status and 1 for checking server status

$CONFIG['accip'] = '127.0.0.1'; <- Your Internet IP (same IP as uses for eAthena Server)

$CONFIG['accport'] = '6900';

$CONFIG['charip'] = '127.0.0.1'; <- Your Intenet IP (same IP as uses for eAthena Server)

$CONFIG['charport'] = '6121'; 

$CONFIG['mapip'] = '127.0.0.1'; <- Your Internet IP (same IP as uses for eAthena Server)

$CONFIG['mapport'] = '5121';

$CONFIG['server_name'] = 'Server Name'; <- Enter your eAthena Server name here but it won't affect server side or anything.

 

You can look around in config.php and edit as you like.

NOTE: I recommend to use Live CP, which I think is better, but it's your decision.

Here is the Link and there is a guide, too. I am not in mood or just lazy to make guide for Live CP so.

 

Hope I didn't forget anything, so good luck =)

 just downloaded the newer ones

mysql-essential-5.5.5-m3-win32 > only one with essential, though idk if its necessary?

php-5.6.28-Win32-VC11-x86 > stable version

[Dastgir 1246]

You should use MySQL Workbench for connecting to your local MySQL server, and there you would find login table after importing main.sql