Kobold (ludmilla) Setup Guide v0.4

[finalzero]

Please follow this guide fully to install the initial Kobold setup. Then follow this link:
http://forum.ragezone.com/world-warc...ds-180964.html
to configure Kobold correctly
Thanks to Kennythekid for the work in putting together the 2nd part to this guide

----------------------- KOBOLD SETUP -----------------------

Okay I am going to attempt to write up a quick guide to getting Kobold working however some steps require making changes to the SQL database so if your not sure about this don't try it as you make end up making a mess of the database.

Hopefully this guide will be detailed enough to help you setup your Kobold server. I would like to point out that my tests were unsuccessful as I was able to enter the game world however due to two files missing from the pack I could not proceed any further with the testing. Also the server produced several errors which I am assuming are bugs in the python scripts however as I have no python knowledge I have not attempted to trace the cause of the errors.

Installation Guide: (version 0.1)

1. Run the Kobold setup program (nothing more to it)
2. Tell the install where you want to install the game server e.g. C:\Kobold
3. Once setup has finished you need to perform serveral tasks:

• Make sure you are using client 1.12.1 (the latest version of wow) - I am not 100% sure if this is a requirement however the client worked fine for me
• Perform the post install tasks:

• Go to the Kobold root folder and into the folder labeled Tools
• Copy the file MapExtractor.exe into your wow client folder
• Go to your client folder and create a new folder in there called maps
• double-click MapExtractor.exe and wait for it to finish extracting the maps
• When finished, move the mps folder into your Kobold server's root (where the readme.txt file is)
• Go into the Tools folder again and double-click the file named DBCextractor.exe - when prompted extract the contents into the \KoboldServerLite\WS\ folder in the Kobold server directory
  • go to the above folder and edit the file ExtractDBC.bat
  • Modify the line set WoWdir=<your_wow_client>r\Data\ to point to your client's data foler e.g. [b]C:\Program Files\World of Warcraft\Data
  • Save the file and then double-click to run it, make sure there are no errors

Please note, there is a new database available (see bottom of this guide). If you are using the new database then skip the next step and follow on from step 4.1.
------------------------------------------------------
4. Now you need to setup the database, I will use Navicat as my example as thats what most people on this board seem to use.

• Start Navicat and then create a new database (if you don't know how to do this, go to Google and search for Navicat creating a new database
  • Make sure the database format is utf-8 and call the database kobold
• Now before you import the sql file you need to fix it as it has a bug (probably more but not found them yet):
  • Open up the file wow_server.sql using a text editor like conTEXT, don't try using Windows notepad as it can't handle the size of the sql file and will just crash (it may corrupt sql file too)
    • Locate the following line: `reputation` text NOT NULL (line number 325) and change it to the following:

      • `reputation` text NOT NULL default '',

    • Save the SQL file
• Now go to Navicat and select your database called kobold
• right-click the database and choose Execute Batch File..
• When prompted locate the wow_server.sql file and run it
• Confirm there were no errors

5. Okay now you need to edit two tables in the database so in Navicat double-click your database kobold to display the list of tables in the right hand side of the program.
------------------------------------------------------

4.1 Account Setup:

• Find the table called accounts and double-click it to open it
  • change the username and password to whatever you want it to be and then click on the small tick icon to save the changes and then close that edit window
• There is another table to edit but we cannot do that until we have the kobold server running (step 6)

6. Now we need to setup the game server so it will run correctly and connect to the MySQL database to populate it with the initial settings.

• Go to the kobold root folder and then into the folder called LS and then into the folder called conf
• Open the file first config file called login_server.conf and edit the values as follows:

• LoginServerListenIp = <your_server_lan_address>   #change this to your server's LAN ip address
  LoginServerPort = 3724
  
  DefaultRealmName = Kobold Test Realm                   # leave it as is or change it to whatever you want to call your realm
  DefaultRealmAddr = <your_server_lan_address>    # again change to your servers LAN ip address
  DefaultRealmPort = 3725
  DefaultRealmType = "Normal"

• Save the file and then open the sql.conf and edit as follows:

• DatabaseName = kobold
  DatabaseHost = localhost
  DatabasePort = 3306
  DatabaseUser = <your_database_server's_root_id>
  DatabasePassword = <your_database_server's_root_password>

• save the file and then go back to the root kobold folder

6.1 You need to perform the above steps two the conf files in the RS folder and the WS folder (e.g. \RS\conf\realm_server.conf)

* DO NOT SIMPLY CUT AND PASTE THE ABOVE LIKE AN IDIOT, ACTUALLY OPEN EACH FILE AND EDIT THE RELEVANT SETTINGS AS EACH FILE IS SLIGHTLY DIFFERENT *

7. Now you need to fire up the server initially to get the database populated with some values. Start the server in the following order:

• double-click WS_Server_Alive.bat (wait until it has loaded fully)
• double-click RS_Server_Alive.bat
• double-clickLS_Server_Alive.bat

8. Once the server has loaded up fully, the login server screen will say "Ready to accept connections" or something similar. You need to close down each window as we need to shutdown the game server now

9. Start Navicat again and do the following:

• Locate the table realm_list and double-click to edit the data
• change the filed address to whatever you have your server LAN ip as (e.g. 192.168.0.1)
• Save the changes by clicking on the small tick icon and close the edit window

10. Finally you can restart the server in the order shown above to confirm it is able to connect to the database and everything is okay (takes about 3 minutes to load up fully)

11. You now need to edit your realmlist.wtf file in your client folder to point it to your local server.

• Go to the client folder and edit the file realmlist.wtf and then change the line set realm list to point to your kobold server e.g. set realmlist mylocalserver

12. You also need to make sure Windows knows about your server, we need to edit the hosts file to do this.

• start Windows Notepad and open the file hosts located in C:\windows\system32\drivers\etc\
• Add a new line at the end to look something like:

• <your_server_lan_address>       <mylocalserver>

e.g.

192.168.0.1      kobold.localserver.com

• Save the file an then exit Notepad

13. Okay if you have got this far and had no problems then you are ready to log into the game world.

• Start your wow client and then log in with the username and password you put in the database (Step 5)
• If all is well you should get prompted to choose your realm and then you can create a new character

-----------

Thats it really, seems two files are missing that would let you import the game world (or I just haven't tested the import feature properly). Also there is an error during the startup of the WS_Server_Alive.bat script however as I mentioned earlier I have no idea what it relates to. If the author(s) of Kobold could be kind enough to post some feedback on this forum it would be greatly appreciated as its useless to post a release and then disappear without replying to comments.

Appendix:

a. Obtaining your servers IP address:

• click on START > Run.. > type cmd to start the Windows Command Prompt
• Type ipconfig /all to display your servers ip address
  • locate the line that says host name to get your servers hostname
  • locate the line ip address to locate the lan address of your server

Revisions:

0.2 - Missed out a database setup step:

• Open Navicat and find the table worldserver_list
• change the field IP to your servers LAN ip address and save the record (click on the tick icon) and close the edit window

0.3 - Added final setup steps (Thanks to Devincean for the info):

Now to do this here are the steps:
1) go to your tools folder [KoboldServerLite\Tools]

2) copy the WoWEmuSCPtoSQLConverter.exe

3) Use any other emu for instance lets say UWC 1.3.x

4) paste WoWEmuSCPtoSQLConverter.exe in the scripts folder [uwc1.4.3/scripts]

5) then go to the saves folder in the uwc and copy the world.save [uwc1.3.4/saves]

6) paste the world.save in your scripts folder [uwc1.4.3/scripts]

7) execute the WoWEmuSCPtoSQLConverter.exe.
[NOTE: This will create a folder sql with .txt files in it]

8) open the sql folder and copy all the contents [uwc1.4.3/scripts/sql]

9) paste them to your WS folder in the Kobold Repack [KoboldServerLite\WS]
[NOTE: do NOT copy the sql folder itself copy the .txt files inside they need to be directly in the WS folder]

10) ingame run the commands .import wo and .import gameobj
[NOTE: after running the gameobj the server will auto restart most the time so run it last]

11) restart and enjoy a now populated repack

(also their is no guaranty any of this works correctly as I have found even pulling these scripts I got about 70% of my world from my UWC emu server meaning nearly half the mobs are still missing. However most of them and gameobjects got added)

0.4 - links to apps and corrections; thanks to Kennythekid:

Open up the file wow_server.sql using a text editor like conTEXT, don't try using Windows notepad as it can't handle the size of the sql file and will just crash
Locate the following line: `reputation` text NOT NULL (line number 325) and change it to the following:
Code:
`reputation` text NOT NULL default '',Save the SQL file
Now go to Navicat and select your database called kobold
right-click the database and choose Execute Batch File..
When prompted locate the wow_server.sql file and run it
Confirm there were no errors

make sure u did this with no error reporting

Navicat download link:
http://www.navicat.com/download/navicat_trial.exe
conTEXT download link:
http://www.inet.hr/~edkirin/ConTEXTsetup.exe
Character creation repair download link:
RapidShare Webhosting + Webspace

-the file is set for the defaut database name "wow_server" if u use other name open the .sql file and change the first line USE `wow_server`; insted of wow_server changed to e.g. kobold if u use the name provided in the guide
if ur db is wow_server just follow the cap.4 of the guide

Save the SQL file
Now go to Navicat and select your database called kobold
right-click the database and choose Execute Batch File..
When prompted locate the wow_server.sql file and run it
Confirm there were no errors

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

Common problems and fixes:

1. Unable to connect

This happens allot with this server, just try logging in again until it realizes your client is there.

2. Realm is showing as off-line

This also seems to happen until you actually manage to get on and create a character. While the server is on and your client is at the login screen, open up Navicat

• locate the table realm_list and open it up
• in the field status change the value to 1 and save (click the tick icon) the settings and close the edit window

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

Hope that helps you peeps. btw don't bother asking my anything about the steps as I really don't have time to sit on this forum and reply to every request for help.

All the answers you need are on this forum, just need to learn how to use the Search button at the top of this forum :D

Adios,

Fz

* EDIT: Make sure this line is correct:

`reputation` text NOT NULL default '',

The '' are two single quotes i.e. ' otherwise you will have problems.


"The stuff"
Password to open server distribution is 'ILoveKobold'.

LINKS
Game server: http://forum.ragezone.com/world-warc...ld-178885.html
Web registration (php): http://forum.ragezone.com/world-warc...la-179297.html
Web server setup: http://forum.ragezone.com/world-warc...de-179863.html (please read my first post there too)

XP/GOLD/DROP rates
http://forum.ragezone.com/world-warc...ml#post1649078

SDB Converted Database for Kobold, has populated game world etc
Silver Database Conversion [0.5] Version 1

Download Link: Silver Database Conversion [0.5] Version 1
http://www.mmorpg4free.com/Mangos_converted.rar

go to your db using Navicat (see download link in the guide) and delete those tables:
- creatures
- creatures_loot
- creatures_mov
- creatures_spell
- creatures_templ
- gameobj_def
- gameobj_loot
- gameobjects

then right click on your db (e.g. kobold or wow_server) and Execute batch file
find the file Mangos_converted.sql and press ok
wait untill its inserts all the data in your tables then close it run the server again ...
P.S. Make sure u don't get any errors

[MentaL]

[[lexx]]

[mod]
This is a guide thread. Please keep it as clean as possible; Post only very technical info.

Cleaned it. Hope author will help solve all problems he didn't mention on first guide release..
[/mod]

[[lexx]]

ok, I am here to report that this guide really helps to set up fully working Kobold server. so don't report any problems, because you likely missed something. read careful.

my first impressions after playing with it approx. 1hrs is that the world isn't fully populated, quests seem to be ok.

just found that when you kill a monster, the corpse rotates following your direction :). and there's a small delay after attack and actual hit and response..

[Devincean]

ok, I am here to report that this guide really helps to set up fully working Kobold server. so don't report any problems, because you likely missed something. read careful.

my first impressions after playing with it approx. 1hrs is that the world isn't fully populated, quests seem to be ok.

just found that when you kill a monster, the corpse rotates following your direction :). and there's a small delay after attack and actual hit and response..

Well technicly there is one part of the guide left out from the readme that apparently no one Ever Reads


Server is supplied with empty World in MySQL, to import it from world_spawns.txt and world_gameobj.txt
enter the Game through WoW client onto your Server. Being GM, use GM command:

.import wo

to import World creatures, and then:

.import gameobj

to import Gameobjects

For reference to supported GM commands type:

.commands

5) Restart server after World is imported.

6) Have fun !

2006, Kobol Team.

Now to do this here are the steps:
1) go to your tools folder [KoboldServerLite\Tools]

2) copy the WoWEmuSCPtoSQLConverter.exe

3) Use any other emu for instance lets say UWC 1.3.x

4) paste WoWEmuSCPtoSQLConverter.exe in the scripts folder [uwc1.4.3/scripts]

5) then go to the saves folder in the uwc and copy the world.save [uwc1.3.4/saves]

6) paste the world.save in your scripts folder [uwc1.4.3/scripts]

7) execute the WoWEmuSCPtoSQLConverter.exe.
[NOTE: This will create a folder sql with .txt files in it]

8) open the sql folder and copy all the contents [uwc1.4.3/scripts/sql]

9) paste them to your WS folder in the Kobold Repack [KoboldServerLite\WS]
[NOTE: do NOT copy the sql folder itself copy the .txt files inside they need to be directly in the WS folder]

10) ingame run the commands .import wo and .import gameobj
[NOTE: after running the gameobj the server will auto restart most the time so run it last]

11) restart and enjoy a now populated repack

(also their is no guaranty any of this works correctly as I have found even pulling these scripts I got about 70% of my world from my UWC emu server meaning nearly half the mobs are still missing. However most of them and gameobjects got added)

[finalzero]

Okay try this script.

After you have imported the Kobold database into your MySQL database you need to import this patch script.

Copy the contents of this code into a text file and save it as patch-kobold.sql and then import this file into your database.

USE `kobold`;

DROP TABLE IF EXISTS `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` text NOT NULL default '',
  `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',
  PRIMARY KEY  (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

The above script assumes you have named your kobold database kobold - if you have called it something else then change the following line to your database's name:

USE `<your_db_name>`;

Where <your_db_name> is the name of your database.

* The above was tested with MySQL 5 *

[Zaekeon]

Okay, I had the same problem as you guys and here's how I fixed it. When I opened up the sql file for editing i went the the line where it is supposed to say:

`reputation` text NOT NULL default '',
`skills` longtext NOT NULL default '0',

Or something like that (don't copy this, it's just for reference)

Now the fix you're supposed to do to the sql file is add the [default ''] on the end of that line that says reputation. when I did that I kept getting errors just like you guys did. So try this. copy the default '0' from the line below it in your text editor and paste it at the end of that reputation line where it needs to be, then just delete the 0. For some reason that worked for me.

[devilrider20]

just change it to
`reputation` text NULL,

worked on my server

[Noloony]

wen i do i get this error

[Err] 1101 - BLOB/TEXT column 'reputation' can't have a default value

but i will just try this one

I found that the correction provided did not work, returning an error 1101, saying that a column of type text can not have a default value.

But if I left the sql file like it was, and modified the column afterwards, it worked fine, here is the script I used:

alter table characters modify reputation text NOT NULL default '';

This will do the same as modifying the original script, but for some reason (It seems to be a bug in mySQL 5.0), it works, while adding the change in line does not.

edit: Thee Quoted text wouldnt work for me

edit2: Finaly i found somting wich worked

just change it to
`reputation` text NULL,

worked on my server

[Noloony]

NOTHING WORKS FOR ME! IF i change the SQL file, i dont get any tables! dont get it!

try using the original..
then go to queries
new query
place this in the box

alter table characters modify reputation text NULL;

now run the query
worked for me

[wipedout]

also WoWEmuSCPtoSQLConverter.exe only imports from creatures.scp not the files that is being included in the creatures.scp file

[Denethor72]

I'm having the same trouble as Rachid; I've tried running the batch file through Navicat with the original wow_server.sql, and with the altered wow_server.sql, and neither one of them will create any tables. I'm using MySQL 5.0, and I haven't seen this problem before. I've tried copying and pasting individual sections out to notepad and using those files to create one or two tables at a time, but it's not working either. I've setup several servers before, but this is the first time I've seen this problem before...

[[lexx]]

I'm having the same trouble as Rachid; I've tried running the batch file through Navicat with the original wow_server.sql, and with the altered wow_server.sql, and neither one of them will create any tables. I'm using MySQL 5.0, and I haven't seen this problem before. I've tried copying and pasting individual sections out to notepad and using those files to create one or two tables at a time, but it's not working either. I've setup several servers before, but this is the first time I've seen this problem before...

check in your mysql configuration if is big enough. I use this:

set-variable	= max_allowed_packet=100M

[Denethor72]

Thanks for the help, Lexx; I hadn't thought of that before. I did make the changes, but it still didn't help. I finally went through the MySQL Query browser and opened the script and ran it through there. It created the tables, but ran into a ton of errors with the syntax. I'm going to look a little closer at it once I make it home tonight. Now I wish I would have kept the old version of the emu that I actually had running.. heh..

[username_in_use]

I'm not afraid to admit i'm a newb at this whole thing, but over the last 36 hours i've tried WoWEmu, WDDG, and SGWoW with no success. I was pointed here by a forum post i read that was saying somethign along the lines that it's amazing that people still try to use WoWEmu and the like, when Ludmilla is out and very easy/functional.

The above guide is awesome, but i think i have a few errors that aren't described in the guide. To start with, lemme explain my problem: i went through the entire guide, including adding the patch-kobold.sql to my database, and all 3 servers are up (WS, RS, then LS), however when i login on my wowclient, it authenticates and tries to suggest a realm, but the realm it suggests (obviousely the realm on my computer), shows it is "Offline". Figuring that the WS is fine (cause it let me get a Realm List), and the LS is fine (Cause it let me login), i looked in the RS command window and i see:

12 15:05:22 W connection: did not find connection to WS[127.0.0.1:4200]
~SocketHandler() 027D9768
~Protocol: 02934048
~Handler: 027D9768

Any ideas as to why i can't get into the realm?
On a side note, during the startup of the WS, i initially had my Internet IP in the configs for all the servers to allow my friends to connect and the WS would just constantly reload itself in the command window. I realize now i had to put my machine IP given to me by my router's DHCP and it doesn't constantly reload anymore. However, there is an error in the WS window i always see (well a couple, actually):

First Off, i get this error when i'm up and running:
12 14:58:39 V Getting WS info from DB:
12 14:58:39 E can't find WS[192.168.1.102:4200] in DB
12 14:58:39 I WorldSrv: listening at: 192.168.1.102:4200
12 14:58:39 I WorldSrv: <<<-- Accepting client connections -->>>

and

Secondly, if i scroll up in the WS command window, i see:
12 14:58:34 E 'gameobjects' is empty or corrupt! The World will have no GO spawned.

Other than that, everything seems to be as it should. The LS runs fine with 0 errors, but i'm wondering if the WS errors could be the cause of the RS not running right?

In any case, any help would be appreciated since this is the furthest i've been able to get with ANY private server setup guide, and i don't want to just quit.

[kennythekid]

Anyone have any idea about what i cna do to get my server up? Could really use some help.

try importing the world_spawn adn world_gameobj grab a UWC1.3.0 extract it then copy the world.save from the save dir and paste it in the scripts dir
then copy from Kobold root dir /tools WoWEmuSCPtoSQLConverter.exe to Uwc1.3.0/scripts/ and run it ...u will get one folder named sql and a log in the sql folder there are 2 .txt files copy them to kobold root dir/WS and then ingame use the commands provided in the readme.txt from the kobold root dir

theres like .import wo and .import gameobj

Server is supplied with empty World in MySQL, to import it from world_spawns.txt and world_gameobj.txt
enter the Game through WoW client onto your Server. Being GM, use GM command:

.import wo

to import World creatures, and then:

.import gameobj

to import Gameobjects

btw don't mind the error u get in this part it works atm there is not a good valid world spawn and gameobj we have to wait

pls read finalzero guide is writen all there

[HenningTM]

I cant creat a player, i get this msg on the emu: could not query SELECT guid FROM characters WHERE a
E sqlpp: cct=1: Table 'kabold.characters' doesn't exist


can somebody plz help me?

[kennythekid]

Open up the file wow_server.sql using a text editor like conTEXT, don't try using Windows notepad as it can't handle the size of the sql file and will just crash
Locate the following line: `reputation` text NOT NULL (line number 325) and change it to the following:
Code:
`reputation` text NOT NULL default '',Save the SQL file
Now go to Navicat and select your database called kobold
right-click the database and choose Execute Batch File..
When prompted locate the wow_server.sql file and run it
Confirm there were no errors

make sure u did this with no error reporting

Navicat download link:
http://www.navicat.com/download/navicat_trial.exe
conTEXT download link:
http://www.inet.hr/~edkirin/ConTEXTsetup.exe
Character creation repair download link:
RapidShare Webhosting + Webspace
-the file is set for the defaut database name "wow_server" if u use other name open the .sql file and change the first line USE `wow_server`; insted of wow_server changed to e.g. kobold if u use the name provided in the guide
if ur db is wow_server just follow the cap.4 of the guide

Save the SQL file
Now go to Navicat and select your database called kobold
right-click the database and choose Execute Batch File..
When prompted locate the wow_server.sql file and run it
Confirm there were no errors


P.S>finalzero pls add this to ur guide

[ROSEBLOOD]

How do I add items into my inventory? &quot;.mod items&quot; doesnt seem to work.
Great guide by the way.

~Roseblood

[kennythekid]

the .mod gold 1000 gives u cooper as far as i know try .mod item 7 but some vendors doesn't want to buy it so the best way to get gold is by .mod item <item> <nr of items> get from Allakhazam.com an item that costs some good gold and in nr of item type 50 and sell them u should receve some good gold and do it more times it works

[HenningTM]

if i try to set:

`reputation` text NOT NULL default '',

Script line: 308 BLOB/TEXT column 'reputation' can't have a default value

im stuck:(

[kennythekid]

Character creation repair download link:
RapidShare Webhosting + Webspace
-the file is set for the defaut database name "wow_server" if u use other name open the .sql file and change the first line USE `wow_server`; insted of wow_server changed to e.g. kobold if u use the name provided in the guide
if ur db is wow_server just follow the cap.4 of the guide

Save the SQL file
Now go to Navicat and select your database called kobold
right-click the database and choose Execute Batch File..
When prompted locate the wow_server.sql file and run it
Confirm there were no errors

[username_in_use]

try importing the world_spawn adn world_gameobj grab a UWC1.3.0 extract it then copy the world.save from the save dir and paste it in the scripts dir
then copy from Kobold root dir /tools WoWEmuSCPtoSQLConverter.exe to Uwc1.3.0/scripts/ and run it ...u will get one folder named sql and a log in the sql folder there are 2 .txt files copy them to kobold root dir/WS and then ingame use the commands provided in the readme.txt from the kobold root dir

theres like .import wo and .import gameobj

Server is supplied with empty World in MySQL, to import it from world_spawns.txt and world_gameobj.txt
enter the Game through WoW client onto your Server. Being GM, use GM command:

.import wo

to import World creatures, and then:

.import gameobj

to import Gameobjects

btw don't mind the error u get in this part it works atm there is not a good valid world spawn and gameobj we have to wait

pls read finalzero guide is writen all there

Okay, everything went along fine as you said. I put the world.save from a UWC 1.3.0 pack into the UWC1.3.0/scripts folder, then i put the WoWEmuSCPtoSQLConverter.exe file form the Tools folder into the UWC1.3.0/scripts folder and ran it. Lastly, i coped over the files to the KoboldRoot/WS directory from the UWC1.3.0/scripts/sql directory and the started up WS, then RS, then LS and i still get the sexact same problems. is it because of the "12 14:58:39 E can't find WS[192.168.1.102:4200] in DB" error, maybe? Sounds like MySQL doesn't have info for the WS to use. In any case, i cna't get into my realm to load the globalobj file and such. Any more ideas?

[dreameclipse]

if i try to set:

`reputation` text NOT NULL default '',

Script line: 308 BLOB/TEXT column 'reputation' can't have a default value

im stuck:(

Reconfig your mysql, turn off strict mode and it should work

Mysql wizard->reconfigure instance->detailed
keep going next till you u see strict more and click it to turn it off

[dreameclipse]

I'm not afraid to admit i'm a newb at this whole thing, but over the last 36 hours i've tried WoWEmu, WDDG, and SGWoW with no success. I was pointed here by a forum post i read that was saying somethign along the lines that it's amazing that people still try to use WoWEmu and the like, when Ludmilla is out and very easy/functional.

The above guide is awesome, but i think i have a few errors that aren't described in the guide. To start with, lemme explain my problem: i went through the entire guide, including adding the patch-kobold.sql to my database, and all 3 servers are up (WS, RS, then LS), however when i login on my wowclient, it authenticates and tries to suggest a realm, but the realm it suggests (obviousely the realm on my computer), shows it is "Offline". Figuring that the WS is fine (cause it let me get a Realm List), and the LS is fine (Cause it let me login), i looked in the RS command window and i see:

12 15:05:22 W connection: did not find connection to WS[127.0.0.1:4200]
~SocketHandler() 027D9768
~Protocol: 02934048
~Handler: 027D9768

Any ideas as to why i can't get into the realm?
On a side note, during the startup of the WS, i initially had my Internet IP in the configs for all the servers to allow my friends to connect and the WS would just constantly reload itself in the command window. I realize now i had to put my machine IP given to me by my router's DHCP and it doesn't constantly reload anymore. However, there is an error in the WS window i always see (well a couple, actually):

First Off, i get this error when i'm up and running:
12 14:58:39 V Getting WS info from DB:
12 14:58:39 E can't find WS[192.168.1.102:4200] in DB
12 14:58:39 I WorldSrv: listening at: 192.168.1.102:4200
12 14:58:39 I WorldSrv: <<<-- Accepting client connections -->>>

and

Secondly, if i scroll up in the WS command window, i see:
12 14:58:34 E 'gameobjects' is empty or corrupt! The World will have no GO spawned.

Other than that, everything seems to be as it should. The LS runs fine with 0 errors, but i'm wondering if the WS errors could be the cause of the RS not running right?

In any case, any help would be appreciated since this is the furthest i've been able to get with ANY private server setup guide, and i don't want to just quit.

Check you realm_list in address make sure you don't have any spaces infront of your ip.
Fixed my that way

Secondly, if i scroll up in the WS command window, i see:
12 14:58:34 E 'gameobjects' is empty or corrupt! The World will have no GO spawned.

gota load that after you get in the first time

[username_in_use]

Yeah, i'm not able to get in. I changed the worldserver_list entry from 127.0.0.1 to 192.168.1.102 which seems to have fixed the error the WS and RS were having, however it still shows my realm offline when i try to pick it. Anyone know what could be making it appear offline?

Also, do i need something more than just a wow client running 1.12.2 with the modified realmlist.wtf? Or do i need some kind of hack for my client?