Could someone point me in the right direction....

[Evilmog]

I did a search for this but wasn't able to find what I was looking for.

I mostly followed Kavren's guide, aside from using Huppy's guide for port forwarding.

Everything installed and looks fine. But I think somewhere in the bunch I got a couple files mixed up.

Anways, my error is when I try to log into the server via the eqemulogin. This are the errors I'm given:

Error in CreateAccount query 'INSERT INTO account SET name ="LSname", status=20,lsaccount_id="My account ID I guess", time_creation=UNIX_TIMESTAMP();' #1054: Unknown Column 'time_creation' in 'field list'


Error adding local account for LS login: 'my LS account', duplicate name?

Ok those are my errors, and here is what I know:

EQEmulogin.exe doesn't like my 64x OS (Or so says my startup.bat), is that the main issue, if so has a work around been created for that? It appears setting it to run in compatibility mode helps, it doesn't crash the exe that way.

Other issue I saw when setting up, is the SVN DL never gave me a EQEmulogin.ini file, just a login.ini file which lacks a place to make changes to:

Port=5998
DumpPacketsIn=true
DumpPacketsOut=true
Trace=true
DatabaseServerName=localhost
DatabaseCatalogName=PEQLoginDB
DatabaseUserName=MySQL Login
DatabaseUserPassword=MySQL Password
OPCodePathAndFileName=login_opcodes.conf

Here is my full login.ini file I changed to match the suggested eqemulogin.ini file:

[database]
host = localhost
port = 3306
db = peqlogindb
user = MySQL Username
password = MySQL 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 = 192.168.1.100

[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

Did I set that up the way it's supposed to or has something else gone wrong?

In regards to: Error adding local account for LS login: 'my LS account', duplicate name?

I tried a different LS login and got the same error. No way it can be a dup since it's the first time i tried it and never entered it into any of my tables.

[lerxst2112]

You need to run this SQL against your database. It is from 1711_account_restricted_aa.sql. You may also be missing other updates. I believe Huppy's guide details where to find them and how to apply them.

ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

If the first line causes an error, then you should only run the last two lines.

[Evilmog]

My hero.

Works.