2 days in still no server. Looking for some tips please.

[arcadius]

Ok, well I hope the issue isn't the installed version of mysql. I cannot get 5.0.82 to install on 2K8. It will fail at service startup during the final phase of install--despite the fact that the service starts fine. When you do a reconfig from the wizard, it starts the service fine, but then fails at applying the security settings. Arg!!!

EDIT: Managed to get 5.0.82 installed thanks to this website. It allowed me to start the server with a txt file that forced a root password thereby correcting the issue caused by the faulty windows installer. Now 5.0.82 is running fine on my server. Now to see if it makes a whit of difference for my emu install

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

EDIT2: Well, went through all that and redid the db sourcing, etc..and the LS server still won't connect to MySQL database. It doesn't really log anything too useful:

g] [08.27.12 - 14:12:18] Logging System Init.
[Debug] [08.27.12 - 14:12:18] Config System Init.
[Debug] [08.27.12 - 14:12:18] MySQL Database Init.
[Database] [08.27.12 - 14:12:18] Failed to connect to MySQL database.
[Debug] [08.27.12 - 14:12:18] Encryption Initialize.
[Debug] [08.27.12 - 14:12:18] Encryption Loaded Successfully.
[Debug] [08.27.12 - 14:12:18] Server Manager Initialize.
[Network] [08.27.12 - 14:12:18] ServerManager listening on port 5998
[Debug] [08.27.12 - 14:12:18] Client Manager Initialize.
[Network] [08.27.12 - 14:12:18] ClientManager listening on Titanium stream.
[Network] [08.27.12 - 14:12:18] ClientManager listening on SoD stream.
[Debug] [08.27.12 - 14:12:18] Server Started.

[lerxst2112]

If you're using eqemuloginserver.exe you need a file named login.ini that should look like this:

[database]
host = 127.0.0.1
port = 3306
db = peqlogindb
user = root
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = TRUE
dump_packets_out = TRUE
listen_port = 5998
local_network = 127.0.0.1

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

[arcadius]

Thanks again for the tip, question though: the guide does not mention that file, but it does make sense, and the only place I see it is in the extracted eqemuloginserver folder. But the guide doesn't say to do anything with that other than copy over the eqemuloginserver.exe..not mention of anything else that extracted with the LS download...?

That did it! Thanks a bunch! Or at least I think that did it. For the first time so far I have a connected LS server and when I launch world.exe it connects to the LS server and does not immediately crash it. I cannot test client connections yet as I am doing this all remotely from work, so launching an client would be very awkward on a remote admin type connection. But it looks to be about as far as I have ever gotten so far. Very happy about that.

Though I do notice in the LS running window something that makes me think maybe I am not completely ready for client connections. At the bottom it mentions my server tried to login but did not provide a password...?

D:\EQEmuServer-Rev2098>EQEmuLoginServer.exe
[Debug] [08.27.12 - 14:51:57] Logging System Init.
[Debug] [08.27.12 - 14:51:57] Config System Init.
[Debug] [08.27.12 - 14:51:57] MySQL Database Init.
[Debug] [08.27.12 - 14:51:57] Encryption Initialize.
[Debug] [08.27.12 - 14:51:57] Encryption Loaded Successfully.
[Debug] [08.27.12 - 14:51:57] Server Manager Initialize.
[Network] [08.27.12 - 14:51:57] ServerManager listening on port 5998
[Debug] [08.27.12 - 14:51:57] Client Manager Initialize.
[Network] [08.27.12 - 14:51:57] ClientManager listening on Titanium stream.
[Network] [08.27.12 - 14:51:57] ClientManager listening on SoD stream.
[Debug] [08.27.12 - 14:51:57] Server Started.
[Network] [08.27.12 - 14:53:59] New world server connection from 192.168.0.11:49219
[World] [08.27.12 - 14:53:59] Server Arcadius Private EQ(APEQ) did not attempt to log in but this server requires a password.


Is this going to be a problem?

EDIT: Nevermind, I figured this one out. Needed to edit the admin username and password to reflect what was in the tblserveradminregistration table in the peqlogindb.

Whew, been quite a little journey, but things are looking okay right now. Sucks that I cannot confirm until I get home, but this is great.

Thanks very much for your tips lerx!