Kobold (ludmilla) Setup Guide v0.4

hey i have a little prob the prog load not all objects why pls help


19 18:57:36 E db: Failed creating GO from DB! Skipping...
19 18:57:36 E db: Failed creating GO from DB! Skipping...
19 18:57:37 E db: Failed creating GO from DB! Skipping...
19 18:57:37 E db: Failed creating GO from DB! Skipping...
19 18:57:38 E db: Failed creating GO from DB! Skipping...
19 18:57:40 E db: Failed creating GO from DB! Skipping...
19 18:57:40 E db: Failed creating GO from DB! Skipping...
19 18:57:40 E db: Failed creating GO from DB! Skipping...
19 18:57:43 E db: Failed creating GO from DB! Skipping...
19 18:57:49 E db: Failed creating GO from DB! Skipping...
19 18:57:50 E db: Failed creating GO from DB! Skipping...
19 18:57:52 W objmgr: found double Transport spawn GUID[F000700000001AE0]
19 18:57:52 W objmgr: found double Transport spawn GUID[F000700000001AE3]
19 18:57:52 W objmgr: found double Transport spawn GUID[F000700000001AE4]
19 18:57:52 W objmgr: found double Transport spawn GUID[F000700000001AE6]
19 18:57:53 E db: Failed creating GO from DB! Skipping...
19 18:58:00 E db: Failed creating GO from DB! Skipping...
19 18:58:00 E db: Failed creating GO from DB! Skipping...
19 18:58:02 E db: Failed creating GO from DB! Skipping...
19 18:58:02 E db: Failed creating GO from DB! Skipping...
19 18:58:02 E db: Failed creating GO from DB! Skipping...
19 18:58:02 E db: Failed creating GO from DB! Skipping...
19 18:58:02 E db: Failed creating GO from DB! Skipping...
19 18:58:03 E db: Failed creating GO from DB! Skipping...
19 18:58:05 E db: Failed creating GO from DB! Skipping...
19 18:58:05 E db: Failed creating GO from DB! Skipping...
19 18:58:06 E db: go template was not found: 160842
19 18:58:06 E go: failed loading spell for GO from DB! skipping...
19 18:58:07 E db: Failed creating GO from DB! Skipping...
19 18:58:07 E db: Failed creating GO from DB! Skipping...
19 18:58:07 E db: Failed creating GO from DB! Skipping...
19 18:58:07 E db: Failed creating GO from DB! Skipping...
19 18:58:07 E db: Failed creating GO from DB! Skipping...
19 18:58:07 E db: Failed creating GO from DB! Skipping...
19 18:58:09 E db: go template was not found: 4
19 18:58:09 E go: failed loading spell for GO from DB! skipping...
19 18:58:09 E db: go template was not found: 4
19 18:58:09 E go: failed loading spell for GO from DB! skipping...
19 18:58:11 E db: Failed creating GO from DB! Skipping...
19 18:58:11 E db: go template was not found: 4
19 18:58:11 E go: failed loading spell for GO from DB! skipping...
19 18:58:14 E db: Failed creating GO from DB! Skipping...
19 18:58:15 E db: Failed creating GO from DB! Skipping...
19 18:58:15 W objmgr: found double Transport spawn GUID[F000700000004D68]
19 18:58:16 E db: go template was not found: 4
19 18:58:16 E go: failed loading spell for GO from DB! skipping...
19 18:58:18 E db: Failed creating GO from DB! Skipping...
19 18:58:18 E db: Failed creating GO from DB! Skipping...
19 18:58:18 E db: Failed creating GO from DB! Skipping...
19 18:58:19 E db: Failed creating GO from DB! Skipping...
19 18:58:20 E db: Failed creating GO from DB! Skipping...
19 18:58:22 E db: Failed creating GO from DB! Skipping...
19 18:58:23 E db: go template was not found: 4
19 18:58:23 E go: failed loading spell for GO from DB! skipping...
19 18:58:23 E db: Failed creating GO from DB! Skipping...
19 18:58:23 W objmgr: found double Transport spawn GUID[F000700000006C64]
19 18:58:23 W objmgr: found double Transport spawn GUID[F000700000006C67]
19 18:58:23 W objmgr: found double Transport spawn GUID[F000700000006C68]
19 18:58:24 E db: go template was not found: 4
19 18:58:24 E go: failed loading spell for GO from DB! skipping...
19 18:58:25 E db: go template was not found: 4
19 18:58:25 E go: failed loading spell for GO from DB! skipping...
19 18:58:25 E db: Failed creating GO from DB! Skipping...
19 18:58:25 E db: Failed creating GO from DB! Skipping...
19 18:58:25 E db: Failed creating GO from DB! Skipping...
19 18:58:33 E db: Failed creating GO from DB! Skipping...
19 18:58:33 E db: Failed creating GO from DB! Skipping...
19 18:58:33 E db: Failed creating GO from DB! Skipping...

that is bin told a lot of times :d
its no big deal
it wil be fix or it is , i dont now , but with that you can stil play

yes it works but are these obejcts are not required ????

this prog are really really nice but for the high instance how can i enter?? there are closed

the server it`s great... but i have a problem after a period of time everybody get`s a error #132 and i don`t know why. pls help

kenny zi-mi si mie frate ce sa ii fac :) ... daca poti da-mi sa vb pe yahoo mi-ar fi mult mai bine (j0rdan_y0 id)

plis tellme how i create this file wow_server.sql ????

what exactly do u mean

how to execute it on db
how to extract it from db

no matter wad i try, i still got error when i do this step;

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.

This is the error i got. can somebody pls tell me wad to do?
http://img152.imageshack.us/img152/2...rd01ix6.th.jpg


EDIT: Nvm find my own solution, i jsut putting only 1 dir there but i find out there more than 1 paragraph need the dir loc. my mistake sorry.

I have it mostly set up, but I ran into 1 small problem.

When I try to connect, it gets past everything and just hangs at connected. After about 10 seconds it says disconnected. I think its a problem with the realm server, but I dont know what the problem could be as when I try to pick a realm it says its online.

EDIT:

To clarify

Both WS and LS get a connection, but RS does not, its like it doesnt realize the client is trying to connect or something.

EDIT2: Fixed it, was using the wrong port in worldserver_list ><

Hey how do you set the dbpassword in the conf files to null?

LogonSrv: Login failed...
auth: failed to auth client with error code[9]
~SocketHandler<> 027D9AE8
~Protocol: 027DC338
~Handler: 027D9AE8



hi all
i have this problem too
can u help me

Quote:

---

Field 's' doesn't have a default value - Navicat

---

or

Quote:

---

Database error while adding new account - Field 's' doesn't have a default value - Web

---

thees errors i got if i try to create an account in navicat or register in my web

Quote:

---

Field 's' doesn't have a default value

---

Help me people please what to do i got this error and i can't add new accounts

In the table accounts what means column 's' and column 'v'

Hello.
All i want to say is that i also got that offline and the realmlist-loop bug, too.
First i have to say that the tut on post one is incomplete. i had to set the sql.conf file in each server instance .. not just in WS as descripted.
However. I found the reasons for all thoose errors. And it was: the ip. It seems that the server applications sometimes just work with values where i dont know where they came from. I fixed the problem by set ALL of the possible ip entrys in config files and db to my LAN adr (in my case 192.168.2.33) .. The 'make the server online manual' thing never worked. And it should not work. The reason of the offline server status is, that you somewhere have 127.0.0.1 left and somewhere not. Just check all possible config entrys and im sure it will work soon.

good luck
Tharo

TharoHello.
All i want to say is that i also got that offline and the realmlist-loop bug, too.
First i have to say that the tut on post one is incomplete. i had to set the sql.conf file in each server instance .. not just in WS as descripted.
However. I found the reasons for all thoose errors. And it was: the ip. It seems that the server applications sometimes just work with values where i dont know where they came from. I fixed the problem by set ALL of the possible ip entrys in config files and db to my LAN adr (in my case 192.168.2.33) .. The 'make the server online manual' thing never worked. And it should not work. The reason of the offline server status is, that you somewhere have 127.0.0.1 left and somewhere not. Just check all possible config entrys and im sure it will work soon.

good luck
Tharo


This is for me?

kenny help plss

you also have to check your DB there is a worldserver_list and a realm_list where you have to change your IP and in the tutorial is a section about Changing every sql config in your WS, RS and LS Folger

Just read it properly

i did that text above for all ppl that had the realm-loop.

Well i re-posted it in another thread were someone was aksing for it. But this thread got deleted (as it seems) and i agree with that. If someone have sugessions to the tut or help or bugfixes he should post it here.

And that is what i did.

###############################################################################
#
# Login Server Configuration file
#
# Contains: Base login server settings, list of realms and their types
#
###############################################################################
# Network interface and port for LOGIN server to listen at.
# Default: 0.0.0.0 (all interfaces) port 3724
#
LoginServerListenIp = 87.119.104.193
LoginServerPort = 3724
# Set up your default realm name here, server will add this single realm to the list.
# Realm IP must be accessible by end user, you can setup port forwarding there to
# actual world server IP and port if your network setup needs.
# DefaultRealmName = "some name"
# DefaultRealmAddr = address of realm - for advanced usage only (default = WorldServerListenIp)
# DefaultRealmPort = port for realm - for advanced usage only (default = WorldServerPort)
#
# Type of realm("Normal", "PvP")
# Default: "Normal"
DefaultRealmName = localhost
DefaultRealmAddr = 87.119.104.193
DefaultRealmPort = 3725
DefaultRealmType = "Normal"
# What kinds of messages don't you what to see?
# Example:
# 1. Uncomment next line to turn off logging to file
# HideLogFile = Fatal Error Warning Information Scripts Verbose Debug
# 2. Uncomment next line to turn off detailed logging to console
# HideLogConsole = Information Scripts Verbose Debug
# What sources of messages do you want to ignore?
# Example:
# 1. Uncomment next lines to turn off messages from ZThread and Sockets libs
# FileLogBlackList = ZThread Sockets
# ConsoleLogBlackList = ZThread Sockets
FileLogBlackList =
ConsoleLogBlackList =
CreateLogFile = 1
#--- END ---



###############################################################################
#
# SQL Database Client Configuration file
#
# Contains: Login and password to access SQL server with all game data
#
###############################################################################
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost
DatabasePort = 3306
DatabaseUser = root
DatabasePassword = johny
# Options (uncomment and set options if necessary):
#DatabaseCharSet = utf8
#DatabaseCompress = yes
#--- END ---



###############################################################################
#
# Realm Server Configuration file - Make one for each realm
#
# Contains: Realm specific settings - listen host, port, realm type, limits
#
###############################################################################
# Network interface and port for Realm server to listen at.
# Default: 0.0.0.0 (all interfaces) port 3725
#
# RealmConnectAddress = srv.myisp.org
RealmServerListenIp = 87.119.104.193
RealmServerPort = 3725
# Type of realm("Normal", "PvP")
# Default: "Normal"
RealmType = "PvP"
# Maximum number of players on the realm. Excluding GM's
# Default: 50
#
RealmPlayerLimit = 50
# Should realm server log all world packets in world.log file?
# Default: 0, change to yes or true or 1 to enable
LogWorld = 0
# What kinds of messages don't you what to see?
# Example:
# 1. Uncomment next line to turn off logging to file
# HideLogFile = Fatal Error Warning Information Scripts Verbose Debug
# 2. Uncomment next line to turn off detailed logging to console
# HideLogConsole = Information Scripts Verbose Debug
# What sources of messages do you want to ignore?
# Example:
# 1. Uncomment next lines to turn off messages from ZThread and Sockets libs
# FileLogBlackList = ZThread Sockets
# ConsoleLogBlackList = ZThread Sockets
FileLogBlackList =
ConsoleLogBlackList =
CreateLogFile = 1
#--- END ---



###############################################################################
#
# SQL Database Client Configuration file
#
# Contains: Login and password to access SQL server with all game data
#
###############################################################################
# MySQL connection information - REQUIRED
# DatabaseName, DatabaseHost, DatabasePort(3306 default), DatabaseUser, DatabasePassword
DatabaseName = kobold
DatabaseHost = localhost
DatabasePort = 3306
DatabaseUser = root
DatabasePassword = johny
# 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 = johny
# Options (uncomment and set options if necessary):
#AccountDBCharSet = utf8
#AccountDBCompress = yes
#--- END ---


###############################################################################
#
# World Server Configuration file
#
# Contains: World Server configuration
#
###############################################################################
# Network interface and port for WORLD server to listen at.
# MUST BE SET ALWAYS
#
WorldServerListenIp = 87.119.104.193
WorldServerPort = 4200
# Message of the Day. Displayed at worldlogin for every user.
Motd = "Welcome to |cffff6060Happy Kobold Slayer|r testing server. Please report all found problems to developers."
# Distance a Player can "see" other objects and receive updates from them.
# Measured in number of Cells around Player. Number of Cells will change CPU load
# of your server (1 - low CPU load, 2 - medium CPU load, 3 - high CPU load)
#
CellsVisual = 2
# Enable World periodic integrity checks, this may help to lower memory usage, improve Latency
# WorldIntegrityCheckInterval sets time in miliseconds ( 1 sec = 1000 msec ) how often such
# routine will be called ( recommended not often that 1 hour as may increase Latency
# on several seconds while called, then latency will normalise )
# WorldIntegrityCheck Options: (yes - no, 1 - 0)
# WorldIntegrityCheck Dafault: no
# WorldIntegrityCheckInterval Default: 1 hour 15 minutes, or 4500000 msec
#
WorldIntegrityCheck = yes
WorldIntegrityCheckInterval = 4500000
# Set Weather change interval in miliseconds ( 1 sec = 1000 msec )
# Default: every 1 hour, or 3600000 msec
#
WeatherChangeInterval = 3600000
# Server Name displayed to all Players who login to server
# (uncommented by default)
#
# ServerName = "Game Server v.1.0"
# Change to (de, ru,...) the following line to allow server loading lang_XX.txt file
# and replacing text entries from lang_default.txt with their translated versions.
#
Language = default
# Announce GM entrance into server (yes - no, 1 - 0)
#
AnnounceGM = yes
# What kinds of messages don't you what to see?
# Example:
# 1. Uncomment next line to turn off logging to file
# HideLogFile = Fatal Error Warning Information Scripts Verbose Debug
# 2. Uncomment next line to turn off detailed logging to console
# HideLogConsole = Information Scripts Verbose Debug
# What sources of messages do you want to ignore?
# Example:
# 1. Uncomment next lines to turn off messages from ZThread and Sockets libs
# FileLogBlackList = ZThread Sockets
# ConsoleLogBlackList = ZThread Sockets
FileLogBlackList =
ConsoleLogBlackList =
CreateLogFile = 1
#--- END ---



this is my configuration LS RS WS
i think there is not problem

That should work. Had you looked in the world_list and realm_list tables an checked the ip's there, too ?

Quote:

---

Originally Posted by kennythekid

does any one know a program that helps u sort files like if the same line is duplicate to remove on of them
or how do i import some files to a database and overwrite the existing ones ...

---

i use the search function of dreamweaver that looks in every file of the folder you have specified and if you want to delete just don t put anything in second value and clic replace all :winky:

1 localhost 87.119.104.193 3725 1 3 0 1


87.119.104.193 4200 0


this is a realm_list & worldserver_list

This problem is only in LS.
When i try to login

i can't opened what u send me