DJRavine's Codebook:

[ADVERTISEMENT]
Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[KoBold v2] Setup Guide + PICTURES
02-19-2007, 02:35 PM (This post was last modified: 07-24-2007 04:04 AM by DJRavine.)
Post: #1
[KoBold v2] Setup Guide + PICTURES
(Introduction)
Hey there,
seeing how so many people have problems setting up the newest version of Ludmilla, I shall help everyone out here and explain it, including screenshots (If possible), I figured it out on my own really (Cause I have tons of experience with MySQL, Navicat, Mango's, and TONS of other emulators for WoW).

Before I begin this tutorial, I will show anyone who is clueless about setting up MySQL, how to set it up!

[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

[Image: mysqlstep2tg6.gif]

[Steps for Instance Configuration]
[1] - Hit Next >
[2] - Select the radio box "Detailed Configuration" like so:

[Image: mysqlstep3wu1.gif]

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

[Image: 33u97ow.gif]

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

[Image: mysqlstep5dl3.gif]

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

[Image: mysqlstep6io4.gif]

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

[Image: mysqlstep7ew8.gif]

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

[Image: 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" like so:

[Image: 2ahwfwk.gif]

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

[Image: 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!
[-] - Do not check "Include Bin Directory in Windows PATH"

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

[Image: 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:

[Image: 3y2h08g.gif]
Do the following:
[-] - Press the button "Execute"
| Now, if it errored, you will see:
[Image: 473lqpz.gif]
[Fixing this error]:
(Just redo the process over, make sure SQL is TURNED OFF
do it through Task Manager, by going into the "Processes" tab
and looking for "mysql-nt" and ending the process)
The Fix:
Redo that whole process over, after removing the instance by
doing the "Remove instance" in the beginning. Do the SAME steps
over as listed in this tutorial, if you do not get an error then good.
but if you get the error again, do the following:

[-] - Start from the beginning, but instead of selecting
"Detailed Configuration", select "Standard Configuration"

[-] - It will ask for your current password, input your
current password then input a new password and hit "Next >"
and hit "Execute" and it should not error!
----------

[-] - If that does not work, try this:
| If you previously had it installed and didn't not have problems
| then go back all the way to the start and select
| "Remove instance configuration" or something along those lines.
[-] - If all worked, you should see:
[Image: 2nlx1ex.gif]
[End of MySQL Tutorial]

[Kobold Tutorial Setup]

(Step 1)
So, here is where we begin:

First we will need to download a free trial of Navicat, visit:
Link: Trial for Navicat for a free trial (There are cracks, but I will not post any).

(Step 2)
So once that is all done, fine and dandy. Visit this thread:
Link: SQL Tools / Files
[Download the newest converted SDB database for Kobold]

(Step 3)
Extract the database to where ever and then open up Navicat and we
will be creating a new database:

So, go over to where you see the list that lists for example:

- test
- mysql

Right click and it should look simular to this:

[Image: step3ng0.gif]
What to do:
[-] - Input ANY name you wish for your database.
| Mine is: "kobolds"
[-] - Hit "Okay"

(Step 4)

Now, as stated before, you should of downloaded a converted version of the Mango's database supplied previously in this tutorial. Now, it should all be extracted and set to where you want it EX: "C:\Something\Desktop"

Now, we are to execute the database into the table, Navicat will handle all of the creating of tables, so no need to worry, just sit back and wait [Image: smoke.gif]

Do the following:
[-] Right click on your created table and look for "Execute Batch File..."
like so:
[Image: 4ig31q8.gif]
| Now a box will come up, asking for the location of your SQL file
| (Which is the converted Mango's SQL file), locate it.
| (Meaning, go to where you extracted it and select it)
| Mine is at, for example: J:\Mangosconverted\onyxia.sql"
[-] Once selected, press OPEN and Navicat will handle the rest. Just sit
back and wait, it might take a while.

(Step 5)

While it is executing, we will want to edit our config files, in which Kobold has come with. So here is what we do (Assuming you have the latest version of Kobold, if you do not, download it here: Ludmilla V 2.0

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:
[Image: 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:
Code:
# [Removed Header to make it fit :D]
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = Your Database Name #Mine is kobolds
DatabaseHost = localhost #use localhost or your WAN IP
DatabasePort = 3306 #Change if needed
DatabaseUser = root #do not change this
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 = Your Database Name #Mine is Kobolds
AccountDBHost = localhost #Use localhost, or your WAN IP.
AccountDBPort = 3306 #Change if Needed
AccountDBUser = root #Do not change this.
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:
[Image: 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.

Code:
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobolds
DatabaseHost = localhost
DatabasePort = 3306
DatabaseUser = root
DatabasePassword = #Insert your password [remove # before doing it]

# 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:

[Image: 4byk5ds.gif]

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

Edit the lines like before mine looks like this:

Code:
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobolds
DatabaseHost = localhost
DatabasePort = 3306 #Change if needed
DatabaseUser = root #Do not change username
DatabasePassword = #Put your password here, remove # (My comment)

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

# MySQL connection information Account - REQUIRED
# AccountDBName, AccountDBHost, AccountDBPort(3306 default), AccountDBUser, AccountDBPassword
AccountDBName = kobolds
AccountDBHost = localhost
AccountDBPort = 3306 #change if needed
AccountDBUser = root #do not change
AccountDBPassword = #put your password. Remove # before doing so.

# 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 it.
(EX: J:\Kobold\KoboldServerLite" is my path)
[-] - Look for the subfolder named "tools", open it.
[-] - 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!

(Step 6)

By now, your SQL query should be done executing and be completed
(Sorry, no screenshot, but it should say "Success! Executed [number]
queries", or something along those lines when it is finished!)

Now, we need to apply the newest updates that were supplied with the core. So here is what we do:

[-] Locate the Kobold folder
| Look for the subfolder "sqlupdate1" & "sqlupdate2" like so:
[Image: 2n01vnb.gif]

[-] Double click the first folder "SQLUPDATE1", then you'll see all the SQL files.
like so: Image Here (Sorry, cannot have any more images!)
[Know this]:
[-] The Update_[name].sql files update the table without having to delete the
data within' the table =D, somethings you will need to delete. Delete the following tables out of your database:

- account_sessions
- inventory
- spell_prices
- taxinodemounts
- db_properties

Now apply the following SQL updates to the database by right clicking the database and hitting "Execute Batch File...":

Locate the following:
- account_sessions.sq;
- inventory.sql
- spell_prices.sql
- taxinodemounts.sql
- db_properties.sql

- Apply each one, one by one to the database

(Step 6)

Now that you finished applying all those updates. Before we move on to applying SQLupdates2, we will need to fix an account problem.

In this newest core release, there is a problem with character creation. So
do the following:

Delete the table "characters" and apply the following code by right clicking your database and hitting "Execute Batch File...":

Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`guid` bigint(20) unsigned NOT NULL default '0',
`acct` bigint(20) unsigned NOT NULL default '0',
`data` longtext NOT NULL,
`indepData` longtext NOT NULL,
`name` varchar(21) NOT NULL default '',
`level` int(10) unsigned NOT NULL default '0',
`class` int(10) unsigned NOT NULL default '0',
`race` int(10) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`mapId` int(10) unsigned NOT NULL default '0',
`zoneId` int(10) unsigned NOT NULL default '0',
`orientation` float NOT NULL default '0',
`taximask` longtext NOT NULL,
`outfit` longtext NOT NULL,
`reputation` bigint(20) unsigned NOT NULL default '0',
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float NOT NULL default '0',
`taxiZ` float NOT NULL default '0',
`unlearn_count` int(11) NOT NULL default '0',
`transportGuid` bigint(32) unsigned NOT NULL default '0',
`stableSlots` tinyint(4) unsigned NOT NULL default '0',
`enumFlag` int(10) unsigned NOT NULL default '0',
`resurrectionLoc` text NOT NULL,
`instanceId` int(10) unsigned NOT NULL default '0',
`actionButtons` longtext,
`tutorials` longtext,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- Put that into your text editor and save it as "character.sql" and execute it into your database and that will fix the character creation problem.
(Many thanks to: xavios for that fix)

Now, once that is done, we will finish up applying the SQLupdates2 to our SQL DB, so delete the following tables from your database:

- char_auras
- db_properties
- gameobjects
- gameobj_def
- spell_cooldown
- creatures_equip

Now, within' the "sqlupdates2" folder, there are a few .zip folders, extract them and you will get the .SQL files with all of the "new" data for the creatures, gameobjects, gameobj_def's, etc. All the big stuff.

Now for the final part, apply the following updates by right clicking your database and selecting "Execute Batch File...":

- char_auras.sql
- db_properties.sql
- gameobjects.sql (Where ever you extracted it!)
- gameobj_def.sql
- spell_cooldown.sql
- creatures_equip.sql (Where ever you extracted it)
- update_characters.sql (This update will update the table with the tutorials, actionbar colums, so just run it on your database.)

NOTE: If you apply update_characters.sql and it does not allow you to make a character, just delete the table and reexecute the fix supplied in this thread.

That is it! Now go back to the main folder where the alive_ stuff is located
and launch in the following order:

WS_Server_Alive.bat (Wait until FULLY loaded)

RS_Server_Alive.bat
LS_Server_Alive.bat

-- Hope you like my tutorial, took over 3 hours of non-stop work to write. I hope this answers EVERYONE's question. If you have any problems, feel free to post them in this thread or PM me

- DigitalEffect


PS: Couple of more things I forgot to mention.

Inserting an account into your account table is easy. Here is the SQL query I used:

Code:
NSERT INTO accounts
  (acct, login, password, s, v, gm, sessionkey, email, joindate, regip, lastip, skin, language, status, validtill)
VALUES
  (2, "admin", "something", "", "", 3, "", "", "0/0/0000", "", "", "", "", 0, "0");
Change: admin - To your username
Change: something - to your password.
Change: 3 - to a GM level, works like this:

3 = GM
2 = Moderator
1 = Player

Once that is done, execute your query by right clicking your database and hitting "Execute Batch File.." (Make sure you saved it in in the format of .sql)

(Tutorial still needs a little work, but I will cover EVERY single thing that is possible to making Kobold work 100.0%, right now I need to do somethings, I will update this thread) - DigitalEffect

[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):
Code:
# Network interface and port for WORLD server to listen at.
# MUST BE SET ALWAYS
#
WorldServerListenIp = 192.168.1.XXX
WorldServerPort = 4200
(Replace XXX with your router IP, if you have one.)

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



Code:
# Network interface and port for LOGIN server to listen at.
# Default: 0.0.0.0 (all interfaces) port 3724
#
LoginServerListenIp = 192.168.1.XXX
LoginServerPort = 3724
To do:
[-] - Change XXX to your last 3 numbers of your router IP (If you have one)

[-] Finally, onto RS folder, open the subfolder "conf" and look for the
following file: "realm_server.conf" open it and you will see:



Code:
# Network interface and port for Realm server to listen at.
# Default: 0.0.0.0 (all interfaces) port 3725
#
# RealmConnectAddress = srv.myisp.org
RealmServerListenIp = 192.168.1.XXX
RealmServerPort = 3725
To do:
[-] - Change XXX to your last 3 numbers of your router IP

[Getting your Router IP]:
You may ask "Well hell, how do I obtain my router IP?", very simple, do the following:

[1] Press Start in your taskbar
[2] Go to "Run"
[3] When a box shows, type into the input "cmd" and press Enter.
[4] When "Command Prompt" shows, type "ipconfig" and press Enter.

Should be simular to this:

Code:
Ethernet adapter Local Area Connection 2:

        Connection-specific DNS Suffix  . : [Removed for stuff :O].
        IP Address. . . . . . . . . . . . : 192.168.1.100
        Subnet Mask . . . . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . . . . : 192.168.1.1
Your Router IP is where IP Adress ............... is. Very simple, use that IP
shown in your conf files, if you do not have a router, use your WAN IP (Wide Area Network), get it from Here

EDIT:

Apparantlly, people have been getting a LibSQL error, I haven't but I will post the fix since it's being asked about everywhere:

[The Fix]

[-] Download this file: www.dll-files.com - Error downloading the file
[-] Place the DLL file in your: WS, LS, and RS folders.


SOURCE: http://forum.ragezone.com/world-warcraft...91204.html

[Image: DJRavine_userbar.gif]
[Image: djr_sig.png]
[Image: thedjravine.png]
"In a world of genocide... The pacifist must take control..." - DJRavine
Visit this user's website Find all posts by this user
Add Thank You Quote this message in a reply
10-15-2008, 07:23 PM
Post: #2
[KoBold v2] Setup Guide + PICTURES
Hey Smile I i have a problem at the end i get a x At Start Service How could i fix this
Find all posts by this user
Add Thank You Quote this message in a reply
10-16-2008, 03:35 PM
Post: #3
[KoBold v2] Setup Guide + PICTURES
Soz problem is solved
Find all posts by this user
Add Thank You Quote this message in a reply
11-10-2008, 04:54 PM
Post: #4
[KoBold v2] Setup Guide + PICTURES
Links are broken please fix Sad
Find all posts by this user
Add Thank You Quote this message in a reply
Post Reply 


[-]
Share/Bookmark (Show All)
Facebook Linkedin Technorati Twitter Digg MySpace Delicious

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  [KoBold v1] Setup Guide DJRavine 2 3,204 03-31-2008 10:32 AM
Last Post: marlox
  Kobold Announcer DarkNation 9 1,825 03-04-2007 04:13 AM
Last Post: »Yama«
  [Kobold] How To Configure Using DNS DJRavine 0 1,528 02-27-2007 03:49 AM
Last Post: DJRavine
  [Kobold] How to add an AI script to a Creature DJRavine 0 2,400 02-27-2007 03:32 AM
Last Post: DJRavine

Forum Jump:


Contact Us | WoWps.org | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication | CSS Validated!