Windows Server Setup

[HeavyHand]

Originally Posted by kavren

I have been reading
• On to Setting up the world server. Here's the sql statement to make the world server entry. Save the below statement as worldreg.sql onto your servers desktop.
• INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'NameOfServer', 'ServerTagDescription', 'ShortNameOfServer', '2', NULL, NULL, '1', NULL);
• Edit the above statement as follows:
• After VALUES, edit the following:
• NameOfServer is the actual name of the server.
• ShortNameOfServer is the shortname for client files in your game directory (i.e. UI_Soandso_ShortNameOfServer.ini).
• ServerTagDescription is what you will see in parenthesis after the server's name - i.e. NameOfServer(Come and have fun!)
• The number 2 signifies what kind of server it is. 1 = Legends, 2 = Preferred, 3 = Standard.
• In navicat, right click the PEQLoginDB DB and select “Execute SQL File…” and choose accounts.sql from your desktop. Do the same again but choosing worldreg.sql from your desktop.

If you find yourself getting stuck here, with Navicat, remove the single quotes from the bolded area (i.e. table name and all variable names in the first statement)

Wow. Took me a long time to notice the obvious.

Also, thank you very much for posting this. I tried to do the Linux walkthroughs, but I am a Windows Guy and don't need the extra headaches.

[HeavyHand]

Now a question of my own. From here:

Originally Posted by kavren

• Save your changes and open up eqemulogin.ini located in the server folder
• Port=5998
• DumpPacketsIn=true
• DumpPacketsOut=true
• Trace=true
• DatabaseServerName=localhost
• DatabaseCatalogName=PEQLoginDB
• DatabaseUserName=MySQL Login
• DatabaseUserPassword=MySQL Password
• OPCodePathAndFileName=login_opcodes.conf
• PEQLoginDB is the name of the Login Database
• MySQL Login and MySQL Password is the same as what you used above just a moment ago

eqemulogin.ini was not found. I made the assumption that the plain login.ini was the file needed, but once I got to the above steps, I noticed there were changes. Now what? There is different info than the above. It looks more like this:

Originally Posted by login.ini

[database]
host = localhost
port = 3306
db = peqlogindb
user = <your_username>
password = <your_password>
subsystem = MySQL

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

[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

Suggestions on how to proceed? I, of course will check further down and put an answer here for people reading this excellent how-to.