Realmd.exe not staying up

[Shadoworcgz]

Ok,I needed help with my realmd.exe when i run "Realmd.exe" it doesnt stay up then I check my realmd.txt and it sez

2007-03-27 18:08:45 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-03-27 18:08:45 ERROR:query ERROR: Table 'realmd.realmlist' doesn't exist
2007-03-27 18:08:45 ERROR:No valid realms specified.
Then when I edit my localhost;3306;root;mypassword;realmd too localhost;3306;root;root;mypass;realmd

Then I check my realmd.txt and it says: 2007-03-27 18:09:28 ERROR:Could not connect to MySQL database at localhost: Access denied for user 'root'@'localhost' (using password: YES)

2007-03-27 18:09:28 ERROR:Cannot connect to database

Can you please tell me what I should do

 

[scrat55]

well u need to change the configs in the realm thing so it suits the ones u got in your database.

 

[Shadoworcgz]

Help plz

 

[ghostdust]

U have to edit carefully realmd.conf. In your attched image have: localhost;3306;root;root;42862588;realmd -- and is wrong!!!
Try this : localhost;3306;root;4286588;realmd

 

[Shadoworcgz]

U have to edit carefully realmd.conf. In your attched image have: localhost;3306;root;root;42862588;realmd -- and is wrong!!!
Try this : localhost;3306;root;4286588;realmd

It still says

2007-03-28 12:36:24 Database: localhost
2007-03-28 12:36:24 ERROR:Could not connect to MySQL database at localhost: Access denied for user 'ODBC'@'localhost' (using password: NO)

2007-03-28 12:36:24 ERROR:Cannot connect to database

 

[CherryCoke45]

I'm having the same problem.

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

 

[dlm1065]

It still says

2007-03-28 12:36:24 Database: localhost
2007-03-28 12:36:24 ERROR:Could not connect to MySQL database at localhost: Access denied for user 'ODBC'@'localhost' (using password: NO)

2007-03-28 12:36:24 ERROR:Cannot connect to database

Shadoworcgz,
You need to set a password in MYSQL see in your post the using password NO that means you are trying to access MYSQL incorrectly mangos is using a password that does not exist on the MYSQL database side.

I am going to guess and bet you are using WAMP or something like it for your MYSQL??
If you are using wamp go to the phpmyadmin page and click on priveleges.
Change all entries that say "All priveleges" to password and use the password you want in mangos.
(Note: as you do this you WILL loose phpmyadmin access and will have to go into your
{WAMP folder location} /apps / phpmyadmin {some #} / config.inc.php
and add the password in there to regain phpmyadmin useage and complete the changes

I'm having the same problem.

My realmd.conf looks like so:

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

CherryCoke,
Your issue is not the same close though it is a MYSQL issue I am thinking you need to grant
the user right's to user 'mangos' in the mysql database. You probably set it up using root and never granted rights to the table to user 'mangos'. To test to see if this is the issue change user 'mangos' to user 'roo't in your 3 mangos .conf files. If it works then change the user back to mangos and grant 'mangos' rights to you MYSQL tables