MANGOS World of Warcraft Private Server Help

[Dflat Major]

I'm sure some people know how this works.

Anyway,
I'm having this problem.

http://i29.tinypic.com/9thbau.jpg

My realmd.conf looks like so:

# MaNGOS realmd configuration file
ConfVersion=2007062001

# Database connection settings for the realm server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database - use named pipes at Windows
# Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = "127.0.0.1;3306;mangos;root;realmd"

# Logs directory setting.
# Important: Logs dir must exists, or all logs be disable
# Default: "" - no log directory prefix, if used log names isn't absolute path then logs will be stored in current directory for run program.
LogsDir = ""

# Settings for maximum database-ping interval (minutes between pings)
MaxPingTime = 30

# Default RealmServerPort
RealmServerPort = 3724
# Bind Realm Server to IP/hostname
BindIP = "0.0.0.0"

# realmd daemon PID file
# Default: "" - do not create PID file
# "./realmd.pid" - create PID file (recommended name)
PidFile = ""

# Server console level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogLevel = 0

# Include time in server console output [hh:mm:ss]
# Default: 0 (no time)
# 1 (print time)
LogTime = 0

# Logfile name
# empty name disable creating log file: LogFile =
# Default: "Server.log" - not recommended.
LogFile = "Realmd.log"

# Logfile with timestamp of server start in name
# Default: 0 - no timestamp in name
# 1 - add timestamp in name in form Logname_YYYY-MM-DD_HH-MM-SS.Ext for Logname.Ext
LogTimestamp = 0

# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogFileLevel = 0

# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN, 3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 - CYAN, 7 - GREY,
# 8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
# "13 7 11 9" - for example :)
LogColors = ""

# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
# number (bitmask value of selected processors)
UseProcessors = 0

# Process proirity setting (Used only at Windows)
# 0 (Normal)
# Default: 1 (HIGH)
ProcessPriority = 1

# Realm list Update up delay (updated at realm list request if delay expired).
# 0 (Disabled)
# Default: 20
RealmsStateUpdateDelay = 20

[LiNuX]

is that fire for linux or windows? and from the looks of it, ur computer is running windows and the file is for linux, im not sure

are you trying to set up a private server? you didn't really explain what it is you want to do, you just posted a bunch of random stuff without the real info anyone will need to help you

[Dflat Major]

is that fire for linux or windows? and from the looks of it, ur computer is running windows and the file is for linux, im not sure

are you trying to set up a private server? you didn't really explain what it is you want to do, you just posted a bunch of random stuff without the real info anyone will need to help you

Lawl,
Sorry
I thought people would assume from the thread name.
I'm trying to make a private server,
And I get that error.
I have Windows
And I used,
[Mangos]How to make a Mangos Server (http://forum.ragezone.com/f114/mangos-how-make-mangos-server-332335/)
As a tutorial on how to do it.

[LiNuX]

ok so it is for windows - not the safest but ok...

did you set up the mysql program the right way?

and try this on top, this is what i am picking out from your thing


LoginDatabaseInfo = "127.0.0.1;3306;mangos;root;realmd"

replace the bold with localhost

the one thing about servers is that you cant use 127.0.0.1 to allow others to log in, it's a lan ip for your computer ONLY, it's not even the internal IP for your LAN

try that and let me know if it fixes

[Dflat Major]

ok so it is for windows - not the safest but ok...

did you set up the mysql program the right way?

and try this on top, this is what i am picking out from your thing



replace the bold with localhost

the one thing about servers is that you cant use 127.0.0.1 to allow others to log in, it's a lan ip for your computer ONLY, it's not even the internal IP for your LAN

try that and let me know if it fixes

Same error.
I thought localhost and 127.0.0.1 are the same thing ?
And yeh, I know it's not completely safe,
But it's just some playing around with me and a few friends.
Soo yeah.
Right now I'm just trying to get the LAN to work.
I know how to switch it to public.

[LiNuX]

since you say u know how to switch to public i'll assume you know how to forward the ports

find your internal IP. and replace your internal IP with the "localhost" this time

if you don't know how to find your internal ip, check this blog post: Finding Internal IP in Windows (http://www.oldpapers.info/computers/finding-internal-ip-in-windows/)

you should also set up your static IP if you haven't, these all could be problems you are having - its not easy setting up a private server trust me, for any thing infact, even teamspeak, gave me a bunch of headaches in the beginning

let me know how it turns out

[Dflat Major]

Same thing.
And I tried setting up a static IP.
Doesn't work.
Soo, I set up a dynamic IP. (http://www.no-ip.com),And change it frequently.
I don't think the IP thing is the problem.


EDIT-
Fixed it, thanks for the help, I just had to troubleshoot abit.
Turned out while I was editing the server's settings,
I changed something that wasn't supposed to be changed.
Thanks anyway!

[LiNuX]

I changed something that wasn't supposed to be changed.
Thanks anyway!

that's what i was gonna say next :rolleyes1:

lol glad you figured it out, have fun

[Dflat Major]

Another error. :(

ERROR:Error in creature_template table, probably sql file format was updated (there should be 61 fields in sql).

[LiNuX]

Another error. :(

ERROR:Error in creature_template table, probably sql file format was updated (there should be 61 fields in sql).

check ur sql fields and see if there are more than 61 or less than 61 fields

i dont know too much about the sql database this uses but it's probably because its missing something in the table called "creature_template" or there is an extra field in there

[Dflat Major]

check ur sql fields and see if there are more than 61 or less than 61 fields

i dont know too much about the sql database this uses but it's probably because its missing something in the table called "creature_template" or there is an extra field in there

Ok.
If I counted correctly, which I think I did.
There's 60.
Uhm, iunno what's missing.

[LiNuX]

Ok.
If I counted correctly, which I think I did.
There's 60.
Uhm, iunno what's missing.

hm..

install another in another database and see how many are in there and compare which is there and which isnt - i usually do that if i have sql trouble if im not familiar with the database type