[Kobold v2] Setup Guide (Pictures included)

Page 1 of 4 1234 LastLast
Results 1 to 25 of 93
  1. #1

    Post [Kobold v2] Setup Guide (Pictures included)

    (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



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



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



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



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



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



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


    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:



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


    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:


    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:


    Do the following:
    [-] - Press the button "Execute"
    | Now, if it errored, you will see:

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

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


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

    Do the following:
    [-] Right click on your created table and look for "Execute Batch File..."
    like so:

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


    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:


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



    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:


    [-] 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:
    INSERT 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.
    Last edited by DigitalEffect; 19-11-06 at 10:04 AM. Reason: Did not finish it.. SORRY! Meant to hit View!


  2. #2
    Gamma [lexx] is offline
    MemberRank
    Nov 2004 Join Date
    LithuaniaLocation
    4,620Posts
    thanks for the guide
    [mod]
    I really know no one likes 5+ pages threads.. to make this thread clean, please do not post any questions here, just submissions to the guide, updates, fixes, corrections.
    [/mod]
    Last edited by [lexx]; 18-11-06 at 02:28 PM.

  3. #3
    Novice zseth is offline
    MemberRank
    Jul 2006 Join Date
    RussiaLocation
    3Posts

  4. #4
    Valued Member iNViSiGOD is offline
    MemberRank
    Apr 2006 Join Date
    129Posts
    And here is the requested LIBMYSQL.DLL file.
    Attached Files Attached Files

  5. #5
    Novice Anmorphic is offline
    MemberRank
    Nov 2006 Join Date
    2Posts
    LibMySQL.Dll error Answer/Alternate fix

    Not installed mySQL:
    During installation check mark "include BIN directory in Windows PATH" to avoid the libmysql.dll error. The file comes with mySQL, however, you must instruct Windows to include the BIN path into its PATH list so when the dll is called it is able to locate it.

    You have installed mySQL already:
    1) Right click "My Computer" and select Properties
    2) Select the "Advanced" Tab
    3) Click "Environmental Variables" button at bottom of tab
    4) Under "System Variables" group box scoll down and find the PATH variable
    5) Click Edit button with PATH variable selected
    6) Add the line below to the end of the entire PATH variable line including the semicolon preceeding it (this separates Paths)


    ;C:\Program Files\MySQL\MySQL Server 5.0\bin



    Note: This path above is MY directory path, the default installation path for MySQL 5.0. YOU need to verify where your MySQL Server 5.0\bin folder is and edit the line above accordingly.


    Click OK, Click OK again, and Click OK one last time to apply.
    Last edited by Anmorphic; 19-11-06 at 11:21 PM.

  6. #6
    Apprentice trs18 is offline
    MemberRank
    Oct 2006 Join Date
    CaliforniaLocation
    11Posts
    Quote Originally Posted by Markusc View Post
    Can some one please uploaded the DBC files some where ells

    PS: Sorry for the question I will delete this post when some one puts up a mirror
    DBC Mirror Here:

    Quick File Post: Download File

  7. #7
    Novice whitemolt is offline
    MemberRank
    Mar 2006 Join Date
    USALocation
    2Posts

    Question some tips

    ok,here is some of the way to make u be able to play online, first u must know ur WAN ip..and put them in Navicat's table (kobold)...look for "realm_list" and change to WAN's ip and do the same in "Worldserver_list"
    u also need to change ip in LS>conf>login_server.conf / WS>conf>world_server.conf / RS>conf>realm_server.conf
    (don't forget to go to wow dir and open realmlist file with note pad and change ip there (u can set realmlist to no-ip server name like " set realmlist whitemolt.xxxxxxip.com"
    this should help u to be able to play online.

    For people who don't want ur character to b naked..so don't forget to put "item_instances" to the table (get it from kobold folder 'sqlupdate1')

    ok...and also i use oxyxia for sql and dbc above...but quest still have many bugs...who got the good quest fix please post it for other to download....thx.

    ps. when u got d/c from internet....u must redo the process again cuz the ip have changed...for realmlist..if ur server pc using the same ip port as same as in no-ip server, so u have no need to change anything in realmlist file..for the other computer (not lan) just set realmlist to ur no-ip server name.
    Last edited by whitemolt; 10-12-06 at 04:47 AM.

  8. #8
    Proficient Member TrekPL is offline
    MemberRank
    Jun 2006 Join Date
    PolandLocation
    154Posts

    rights access...

    u forgot to tell that AFTER u created kobold DB in navicat u MUST change rights to GRANT ALL....
    Here are images for it:




    !!! AND REMEMBER !!!
    In main Navicat window clickTools->Options...
    Click on Table and UNCHECK "Limit Records" !!!!!!!!!!
    Last edited by TrekPL; 13-12-06 at 05:50 PM.

  9. #9
    Novice Omicr0n is offline
    MemberRank
    Dec 2006 Join Date
    3Posts
    okay ill just edit, so i dont take up space...

    So it dont support 1.12.2? noob question sry =P
    Last edited by Omicr0n; 13-12-06 at 06:31 PM.

  10. #10
    Proficient Member TrekPL is offline
    MemberRank
    Jun 2006 Join Date
    PolandLocation
    154Posts
    Quote Originally Posted by Omicr0n View Post
    Hi sry for posting here, but version of wow is this for.... I cant connect coz it says that server version and client version dont match
    1.12.1

    PS: Can anyone give me link to graveyards.sql? (my table is very short... I don't have all needed entries...)
    Last edited by TrekPL; 13-12-06 at 06:41 PM.

  11. #11
    Apprentice itsbmw is offline
    MemberRank
    Jun 2006 Join Date
    MichiganLocation
    11Posts

    Hmm Weird Error?

    I Get the Error DBGHELP.DLL cant be found when i run The World Server then the server goes into restart and it wont just load

  12. #12
    Proficient Member TrekPL is offline
    MemberRank
    Jun 2006 Join Date
    PolandLocation
    154Posts
    Quote Originally Posted by itsbmw View Post
    I Get the Error DBGHELP.DLL cant be found when i run The World Server then the server goes into restart and it wont just load
    Search it in your system. If found THEN copy into your server directory. Else search in GOOGLE.COM:zoo_donat

  13. #13
    Enthusiast rentyman is offline
    MemberRank
    Jul 2006 Join Date
    minnesotaLocation
    32Posts
    dont forget to extract ur maps and put the maps folder in ur kolbold/ws/ folder

    if u get a cannot open terrain.mpq error, then put the mapexporter.exe into ur wow data folder. it makes the maps folder for u when u execute it.

    also if ur refused connection or server is offline goto navicat and goto the realm_list table and look for status tab and put it on 1 3 and 0 = offline. 2 = time expired buy more time (i think)

  14. #14
    Apprentice bloodysabath is offline
    MemberRank
    Oct 2005 Join Date
    JakartaLocation
    7Posts
    excuse me, can i ask something?
    i can't use the mapextractor.exe
    i hev done everything like putting the mapextractor in the
    world of warcraft/data/
    but its says that it can't find terrain.MPQ
    i use the 9.0 wow ver..is that the problem?
    really Need ur assistance, Thanks in advance...

  15. #15
    Proficient Member TrekPL is offline
    MemberRank
    Jun 2006 Join Date
    PolandLocation
    154Posts
    Quote Originally Posted by bloodysabath View Post
    excuse me, can i ask something?
    i can't use the mapextractor.exe
    i hev done everything like putting the mapextractor in the
    world of warcraft/data/
    but its says that it can't find terrain.MPQ
    i use the 9.0 wow ver..is that the problem?
    really Need ur assistance, Thanks in advance...
    What ver????? It support 1.12.1 ONLY....

  16. #16
    Apprentice Shavik is offline
    MemberRank
    Dec 2006 Join Date
    7Posts
    I have followed the guide to a T but when i go to start the world server it gives me a
    Code:
     WoW Server Started  0:00 un 12/17/2006
    -------------------------------------------------------------------------
    =  ZOMG Kobold LOL ver. 1.646.5875-win32 Public Limited  - World Server
    =
    =  Press Ctrl-C anytime after initialization to safely close server.
    =
    =  CPU: GenuineIntel|INTEL Pentium-4 F15 M2 S7
    =  OS:  WinXP ProSP2
    =  LIMITED PUBLIC VERSION
    -------------------------------------------------------------------------
    17 00:00:57 V Log: Initialization...
    17 00:00:57 V Config: File logging[ENABLED]
    17 00:00:57 I Log: File Log Started
    17 00:00:57 I Log: Started
    17 00:00:57 V Database: Using MySQL database 'kobolds' at 192.168.1.214:3306, us
                V Database: er 'root'
    17 00:00:57 E sqlpp: Could not connect to MySQL database at 192.168.1.214: Clien
                E sqlpp: t does not support authentication protocol requested by ser
                E sqlpp: ver; consider upgrading MySQL client
    17 00:00:57 E Database: Cannot connect to MySQL
    17 00:00:57 I Log: Stoped
    WoW Server Restarted  0:00 un 12/17/2006
    
    The system cannot find the path specified.
    ^CTerminate batch job (Y/N)?
    Any suggestions?
    Last edited by Shavik; 17-12-06 at 07:00 AM.

  17. #17
    Proficient Member TrekPL is offline
    MemberRank
    Jun 2006 Join Date
    PolandLocation
    154Posts
    so try to set it on 127.0.0.1 Maybe that will help. And check your MySql settings if they are 4 shure good

  18. #18
    Apprentice Shavik is offline
    MemberRank
    Dec 2006 Join Date
    7Posts
    EDIT: Saw the moderator post. Sorry
    Last edited by Shavik; 17-12-06 at 06:06 PM.

  19. #19
    Apprentice Nuke_ is offline
    MemberRank
    Jun 2006 Join Date
    HomeLocation
    13Posts


    I have this error and i can`t continue the configuration.
    Anyone knows how to fix it ?

  20. #20
    Proficient Member TrekPL is offline
    MemberRank
    Jun 2006 Join Date
    PolandLocation
    154Posts
    Quote Originally Posted by Nuke_ View Post
    I have this error and i can`t continue the configuration.
    Anyone knows how to fix it ?
    If manual from DigitalEffect wont help u try shutdown MySQL instance, uninstall it and then install it again...

  21. #21
    Novice ArthPL is offline
    MemberRank
    Dec 2006 Join Date
    1Posts
    I have that kind of problem:



    What's going on? Can someone explain me why it's not working?

  22. #22
    Proficient Member TrekPL is offline
    MemberRank
    Jun 2006 Join Date
    PolandLocation
    154Posts
    Check all sql.conf files and create new MySQL instance. Follow direct as DigitalEffect said

  23. #23
    Apprentice Nuke_ is offline
    MemberRank
    Jun 2006 Join Date
    HomeLocation
    13Posts
    Quote Originally Posted by TrekPL View Post
    If manual from DigitalEffect wont help u try shutdown MySQL instance, uninstall it and then install it again...
    thx man that worked

    P.S. Sry foy my bad english :|

  24. #24
    Novice Dyslexicon is offline
    MemberRank
    Dec 2006 Join Date
    1Posts

    Connection error

    I am receiving the same error Shavik and ArthPL.

    Database: Using MySQL database 'kobolds' at localhost:3306. user 'root'
    sqlpp: Could not connect to MySQL database at localhost: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
    Database: Cannot connect to MySQL
    I have followed the guide exactly and I am still unable to get it to work. I have also googled this string and read something about 5.0 using a different hashing method than older version. So I went into account manager and edited the accounts so they would use OLD_PASSWORD encryption. That did not seem to produce results either. Any and all advise will be highly appreciated.

  25. #25
    Novice epila is offline
    MemberRank
    Dec 2006 Join Date
    1Posts
    Code:
    27/12/2006 08:25:18 I Log: Started
    27/12/2006 08:25:18 V Database: Using MySQL database 'kobolds' at localhost:3306
                        V Database: , user 'root'
    27/12/2006 08:25:18 V Connected to MySQL database at localhost
    27/12/2006 08:25:18 V Database: Using MySQL account database 'kobolds' at localh
                        V Database: ost:3306, user 'root'
    27/12/2006 08:25:18 V Connected to MySQL database at localhost
    27/12/2006 08:25:18 I i18n: Loading translation strings for language 'default', 
                        I i18n: file 'lang_default.txt'
    27/12/2006 08:25:18 I i18n: Language Translation Subsystem is loaded and ready!
    27/12/2006 08:25:18 I Loading Database related information...
    27/12/2006 08:25:18 I Opening DBC storages...
    27/12/2006 08:25:18 V ------------------- DBC --------------------------
    27/12/2006 08:25:18 V >> SkillLine.dbc
    27/12/2006 08:25:18 V >> SkillLineAbility.dbc
    27/12/2006 08:25:18 V >> EmotesText.dbc
    27/12/2006 08:25:18 V >> Spell.dbc
    27/12/2006 08:25:18 V >> SpellRange.dbc
    27/12/2006 08:25:18 V >> SpellCastTimes.dbc
    27/12/2006 08:25:18 V >> SpellDuration.dbc
    27/12/2006 08:25:18 V >> SpellRadius.dbc
    27/12/2006 08:25:18 V >> Talent.dbc
    27/12/2006 08:25:18 V >> AreaTable.dbc
    27/12/2006 08:25:18 V >> AreaTrigger.dbc
    27/12/2006 08:25:18 V >> WorldMapArea.dbc
    27/12/2006 08:25:18 V >> WorldMapOverlay.dbc
    27/12/2006 08:25:18 V >> WorldSafeLocs.dbc
    27/12/2006 08:25:18 V >> Map.dbc
    27/12/2006 08:25:18 V >> DurabilityCosts.dbc
    27/12/2006 08:25:18 V >> DurabilityQuality.dbc
    27/12/2006 08:25:18 V >> ItemRandomProperties.dbc
    27/12/2006 08:25:18 V >> SpellItemEnchantment.dbc
    27/12/2006 08:25:18 V >> ItemSet.dbc
    27/12/2006 08:25:18 V >> Faction.dbc
    27/12/2006 08:25:18 V >> FactionTemplate.dbc
    27/12/2006 08:25:18 V >> BankBagSlotPrices.dbc
    27/12/2006 08:25:18 V >> TaxiNodes.dbc
    27/12/2006 08:25:18 V >> TaxiPath.dbc
    27/12/2006 08:25:18 V >> TaxiPathNode.dbc
    27/12/2006 08:25:18 V --------------------------------------------------
    27/12/2006 08:25:18 V DBC storages: Done!
    27/12/2006 08:25:18 V 27/12/2006 08:25:18 V - Maitenance -------------------------------------
    27/12/2006 08:25:18 E sqlpp: could not query SELECT * FROM pet_store: Table 'kob
                        E sqlpp: olds.pet_store' doesn't exist
    27/12/2006 08:25:18 E sqlpp: could not query SELECT player_guid FROM char_state 
                        E sqlpp: WHERE online_state = 1: Table 'kobolds.char_state' 
                        E sqlpp: doesn't exist
    27/12/2006 08:25:18 V --------------------------------------------------
    27/12/2006 08:25:18 V 27/12/2006 08:25:18 I Precaching MySQL DB tables...
    27/12/2006 08:25:18 F DB: DB structure version too new for this server version.
    27/12/2006 08:25:18 F World: FATAL ERROR in world thread!
    27/12/2006 08:25:18 I Network: TCP Port 4200 listener started
    27/12/2006 08:25:18 V Getting WS info from DB:
    27/12/2006 08:25:18 E sqlpp: could not query SELECT map_id FROM worldserver_list
                        E sqlpp:  WHERE port = 4200 AND ip = '127.0.0.1 ': Table 'ko
                        E sqlpp: bolds.worldserver_list' doesn't exist
    27/12/2006 08:25:18 E can't find WS[127.0.0.1:4200] in DB
    27/12/2006 08:25:18 I WorldSrv: listening at: 127.0.0.1:4200
    27/12/2006 08:25:18 I WorldSrv: <<<-- Accepting client connections -->>>
    27/12/2006 08:25:18 I Network: TCP Port 4200 listener stopped
    27/12/2006 08:25:18 S Python: scripting shut down ->>>
    27/12/2006 08:25:18 I WorldSrv: Finished, shutting down...
    27/12/2006 08:25:18 I Log: Stoped
    then i fix this, how i create new admin account? i'm using ludmilla account manages but it says there isnt any accounts table

    i didnt found SDB database that i need to download
    Last edited by epila; 27-12-06 at 11:25 AM.



Page 1 of 4 1234 LastLast

Advertisement