Jump to content
  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
robby

[HowTo] Kobold V2 + MySQL + Navicat / SQLyog

Recommended Posts

Create By Alessio.

 

[Tutorial Navicat / SQLyog ]

 

(Step 1)

Get Navicat Or SQLyog

 

logo_sol_small.gif

Navicat :

 

[-] Open Navicat

[+] Setting Up Your Ip,Username,Port,Password :

151fe9.jpg

[+] Create New DB, Name : kobold

4ti1.jpg

[+] Click to kobold, Execute Batch File :

2nn5.jpg

[+] Find your SQL DB for kobold.

3nx7.jpg

[-] Execute and wait.. :)

 

sqlyog.jpg

SQLyog :

 

[-] Open SQLyog

[+] Setting Up Your Ip,Username,Port,Password :

1qw5.jpg

[+] Create New DB, Name : kobold

2bp2.jpg

[+] Click to kobold, Import Batch File :

3be8.jpg

[-] Find your SQL DB for kobold.

[-] Execute and wait.. :)

 

[End Of Navicat / SQLyog ]

 

 

Create By DigitalEffect.

 

Kobold Tutorial Setup

 

So, after that is all downloaded and installed to your desired directory. Go

to your Kobold folder and look for the following folders:

[--] WS

[--] LS

[--] RS

 

First select WS and look for the subfolder "conf", select that, like so:

2psrp1u.gif

 

You will see a couple of files:

[--] sql.conf

[--] world_server.conf

 

Now, select "sql.conf" first, open it in Notepad, Wordpad, or whatever text-editor you (person reading this) uses!

 

You will see something simular to:

 

# [Removed Header to make it fit :D]
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost 
DatabasePort = 3306
DatabaseUser = root 
DatabasePassword = Password inputted at MySQL configuration

# Options (uncomment and set options if necessary):
#DatabaseCharSet = utf8
#DatabaseCompress = yes

# MySQL connection information Account - REQUIRED
# AccountDBName, AccountDBHost, AccountDBPort(3306 default), AccountDBUser, AccountDBPassword
AccountDBName = kobold
AccountDBHost = localhost 
AccountDBPort = 3306 
AccountDBUser = root 
AccountDBPassword = Password inputted at MySQL configuration

# Options (uncomment and set options if necessary):
#AccountDBCharSet = utf8
#AccountDBCompress = yes
#Do not change any of this.

#--- END ---

 

Change your DB, Host, User, Port, and Password to whatever you supplied!

-- Very simple. I cannot get into anymore detail cause it's just simple.

 

NOTE: Make sure you remove my comments, or you can keep them.

truely does not matter.

 

Once that is done, that part is set. File > Save it and move on to the next

folder:

[--] LS

 

Double click / one click the folder, and look for "conf" like so:

 

314qxzn.gif

 

Now Select "sql.conf" and do the same as above, it may contain just

"databaseuser" stuff, but just edit it like you did with the other one.

 

Mine looks like this:

# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost
DatabasePort = 3306
DatabaseUser = root
DatabasePassword = Password inputted at MySQL configuration

# Options (uncomment and set options if necessary):
#DatabaseCharSet = utf8
#DatabaseCompress = yes

#--- END ---

 

Once done, File > Save the folder and move on.

 

Finally, the last folder before we finish the configuration part of all of this:

 

[--] RS

 

Double click / one click RS and locate the subfolder "conf" like so:

 

4byk5ds.gif

 

Locate "sql.conf" and open it up using your text-editor.

 

Edit the lines like before mine looks like this:

 

# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost
DatabasePort = 3306 
DatabaseUser = root 
DatabasePassword = Password inputted at MySQL configuration

# Options (uncomment and set options if necessary):
#DatabaseCharSet = utf8
#DatabaseCompress = yes

# MySQL connection information Account - REQUIRED
# AccountDBName, AccountDBHost, AccountDBPort(3306 default), AccountDBUser, AccountDBPassword
AccountDBName = kobold
AccountDBHost = localhost
AccountDBPort = 3306 
AccountDBUser = root 
AccountDBPassword = Password inputted at MySQL configuration

# Options (uncomment and set options if necessary):
# Do not change.
#AccountDBCharSet = utf8
#AccountDBCompress = yes

#--- END ---

 

File > Save it and close it.

[Maps]:

 

We must extract the map files, so here is what we need to do:

 

[-] - Go to where your Kobold folder is located, and open Tool directory.

 

[-] - You will see a file inside of there named "MapExporter.exe"

[-] - Here is the part where everyone gets confused:

| Instead of placing the "MapExporter.exe" into the main

| World of Warcraft folder, you will need to place it in the data folder

| and make a folder inside the World of Warcraft data folder named

| maps.

-- Once that is done, One click / DB click the "MapExporter.exe" and

let it run, once done, move the newly made maps to your "WS" folder

inside of your Kobold folder.

 

[DBC's]:

 

Download my DBC files: Here.

 

[-] Extract them

[-] Place them into the "WS" folder inside of your Kobold Folder, simple and

easy!

 

[Setting up your server for online play]:

 

Now, this is sort of the same process as setting up the SQL .conf files, here is what we do:

 

[-] - Go back to the "conf" folders as shown in the screenshots before.

| First, we will start with the WS folder, like before, go to "conf" folder and

| look for the following file:

[--] - world_server.conf

| Open it up, and it should look a little simular to this

(May I remind you, I am not posting the whole thing, only the important

part):

# Network interface and port for WORLD server to listen at.
# MUST BE SET ALWAYS
#
WorldServerListenIp = 127.0.0.1
WorldServerPort = 4200

 

Change 127.0.0.1 to your IP or Router IP.

 

[-] Moving onto LS folder, once again open the "conf" inside of the LS folder. Should look something like this:

 

# Network interface and port for LOGIN server to listen at.
# Default: 0.0.0.0 (all interfaces) port 3724
#
LoginServerListenIp = 127.0.0.1
LoginServerPort = 3724

 

Change 127.0.0.1 to your IP or Router IP.

 

[-] Finally, onto RS folder, open the subfolder "conf" and look for the

following file: "realm_server.conf" open it and you will see:

 

# Network interface and port for Realm server to listen at.
# Default: 0.0.0.0 (all interfaces) port 3725
#
RealmConnectAddress = your.dns.server
RealmServerListenIp = 127.0.0.1
RealmServerPort = 3725

 

-Change 127.0.0.1 to your IP or Router IP.

-If u have dns change your.dns.server to your real dns.

 

[-] Run WS , RS , LS .bat file.

 

[End of Kobold Tutorial]

 

 

Create By DigitalEffect.

 

[MySQL Setup Tutorial]

 

(Part 1)

Visit MySQL.com to read on it, but if you are using Windows, I will save you some time and post a download link: MySQL 5.0 Download Link

 

(Part 2)

 

Now exact it and open the MSI file, go through the instillation and then run the Server Instance Configuration

 

[Steps for Instance Configuration]

[1] - Hit Next >

[2] - Select the radio box "Detailed Configuration" like so:

 

mysqlstep3wu1.gif

 

[3] - Select the radio box "Server Machine" like so:

 

33u97ow.gif

 

[4] - Select the radio box "Multifunctional Database" like so:

 

mysqlstep5dl3.gif

 

[5] - Next step, it will come up with a installation path stuff, if you have no idea how this works press "Next >"

 

mysqlstep6io4.gif

 

[6] - Press "Next > " and select radio box "Decision Suppost )DSS/OLAP" like so:

 

mysqlstep7ew8.gif

 

[7] - Press "Next >" and you will see two checkboxes, like so:

 

2d9d0s9.gif

 

Make Sure:

[-] "Enable TCP/IP Networking" is checked.

| Select the port number you wish to use. I use the default port number

| "3306".

[-] "Enable Strict Mode" is checked.

 

[8] - Press "Next >" and select the radio box "Standard Character Set"

 

[9] - Press "Next >" and you will see two checkboxes like so:

 

2e4drag.gif

 

Do the following:

[-] - Make sure "Install Windows Service" is checked. (THIS IS A MUST!)

| I use the default service name "MySQL", but if you are setting up

| multiplue SQL servers, select different names from the drop down

| box or make up your own!

 

[10] - Press "Next >" and you will see input box(s) for a password and some check boxes, like so:

 

2hejx34.gif

 

Do the following:

[-] - Make sure "Modify Security Settings" is CHECKED.

| Input your desired password, make sure you do it TWO times.

| Make sure "Enable root access from remote machines" IS

| CHECKED (THIS IS A MUST!)

[-] - Do not check "Create An Anonymous Account"

 

[11] - Press "Next" and you will see:

 

3y2h08g.gif

 

Do the following:

[-] - Press the button "Execute"

 

2nlx1ex.gif

 

[End of MySQL Tutorial]

 

Share this post


Link to post
Share on other sites

a tu zase dalsie ...

 

 

 

Printable Version of Topic

Click here to view this topic in its original format

United World Crew _ Ludmilla Support _ [TUTORIAL] How to Install Ludmilla

Posted by: Kasra Nov 19 2006, 12:41 AM

 

.........................:::::::::::::::::::::::::Ludmilla Installation:::::::::::::::::::::::::.........................

 

 

1. What You Need:

- MySQL --> http://dev.mysql.com/downloads/mysql/5.0.html#downloads

- Navicat --> http://rapidshare.com/files/2876545/Navica...v7.2.8.rar.html

- Ludmilla --> http://forum.uw-crew.org/index.php?showforum=42

 

2. Installation:

- Install MySQL with the username: root and password: root

- Run MySQL & type in: create database Press Enter. Now type in: kobold; then type: exit

- Extract KoboldServerLite From Your Repack to C:\

- Install Navicat & when finished Run it

- Create a new connection called: Kobold & enter your Username & Password then press ok

- Click on the connection you have created and then right click on kobold and execute batch file

* kobold is the database you created earlier in the process

- Look for your database SQL file situated in your KoboldServerLite folder and execute it

* Database SQL file is usually called wow_server.sql, darac2.sql or lud.sql

- Once all queries have been processed, click ok, and exit Navicat

 

3. Configuration:

- In your KoboldServerLite folder go to your RS, LS & WS Conf folder

- Change your sql.conf files to your database configuration

- Change your other conf files to replicate this:

 

WS

 

WorldServerListenIp = 127.0.0.1

WorldServerPort = 4200

 

RS

 

RealmConnectAddress = [i.P Address]

RealmServerListenIp = 0.0.0.0

RealmServerPort = 3725

 

LS

 

LoginServerListenIp = 0.0.0.0

LoginServerPort = 3724

 

DefaultRealmName = Kobold

DefaultRealmAddr = [i.P Address]

DefaultRealmPort = 3725

DefaultRealmType = "Normal"

 

4. Starting Up Server:

- To start up the server run: WS_Server_Alive.bat until it says: Accepting Client Connections

- Then Run RS_Server_Alive.bat, Followed by LS_Server_Alive.bat

 

For More Information on Configuration See AceIndy's Post: http://forum.uw-crew.org/index.php?showtop...amp;#entry22021

 

Your Kobold Server Should Now Be Configured And Ready To Go

Posted by: Markusc Nov 19 2006, 07:59 AM

 

Looks good, I will test it now

Posted by: Kris Dec 3 2006, 01:58 PM

 

Could you post here more information about step 3 (configuration) cuz I've done what you post here but server doesn't start.

Posted by: Kasra Dec 4 2006, 08:13 AM

 

QUOTE(Kris @ Nov 19 2006, 06:59 AM) *

 

Could you post here more information about step 3 (configuration) cuz I've done what you post here but server doesn't start.

 

 

Ok Sure...

 

This Is The Configuration for sql.conf files. Insert your MYSQL username and password in and make sure that your database name is kobold unless you have called it something else.

 

DatabaseName = kobold

DatabaseHost = localhost

DatabasePort = 3306

DatabaseUser =

DatabasePassword =

 

AccountDBName = kobold

AccountDBHost = localhost

AccountDBPort = 3306

AccountDBUser =

AccountDBPassword =

 

The settings for the other .conf file are as follows:

 

WS

 

WorldServerListenIp = 127.0.0.1

WorldServerPort = 4200

 

RS

 

RealmConnectAddress = [i.P Address]

RealmServerListenIp = 0.0.0.0

RealmServerPort = 3725

 

LS

 

LoginServerListenIp = 0.0.0.0

LoginServerPort = 3724

 

DefaultRealmName = Kobold

DefaultRealmAddr = [i.P Address]

DefaultRealmPort = 3725

DefaultRealmType = "Normal"

 

Posted by: shadowspy Dec 23 2006, 09:18 PM

 

tnx Kasra...

Edited by robby

Share this post


Link to post
Share on other sites

Hello,

 

For those interested:

 

I've setup Kobold, and it took me a while before I understood how it exactly worked with port forwarding and multiple realms.

 

It's even possible to run multiple realms on 1 IP; provided DNS is set up properly; (very cleverly done /applause) Please find my plan attached

screenhunter02zp6.th.gif

 

or as PDF

 

Which translates into following configuration:

Last, check your realm_list and wordserver_list:

screenhunter01pt6.gif

Final note on realm_list table:

Use Navicat to set status to 0(green) or 1(red) AFTER LS server has started up; Realms are by default mounted as 'offline' (status=3)

 

Hope it's helpfull :P

 

PS Just saw I used different DNS's

so normal.domain.pvp should be my.dns.ip

and pvp.domain.pvp should be test.dns.ip

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×