LAN login server worl registration issue
 

After much pushing, grinding and trouble shooting, I have been able to get my server to launch, I can log in to the login server, but my world is not listed. I am getting an error from the login server that says:

[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'AAAAkkas PEQ Installer'
[World Server] Server AAAAkkas Windows PEQ Installer (R0RJgw)(AAAAkkas PEQ Installer) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1', ServerLongName = 'AAAAkkas Windows PEQ Installer (R0RJgw)' WHERE ServerID = 0

Any suggestions as to what I might be missing or doing wrong would be greatly appreciated.

I think your problem is you are using an incompatible database. You can't use a standard peq database with akka's installer you need to get a database from akka I can try to find a link for you if you have trouble finding it.

If it wasn't Akka's installed DB, it wouldn't show under [World Server]

The world server names are not matching up. Have to be exactly the same in
the eqemu_config as in your tblWorldServerRegistration table in database and
the loginserver has to accept it.

That's an interesting theory, however the peq database was installed by the Akka installer. Maybe I will dig through the SQL files and try to find where the world is registered and add my server? If you think that re-loading the correct peq files would help I will give that a shot.

That's what I am missing, thanks for that help. I will make the change and see where it get me. Thanks again!

If he has a table called tblworldserverregistration then that is his problem ;) incompatible database.

What's happening is the server is trying to inject his server name into the database table 'loginserver_world_server_registration' but the table in his database doesn't match so it can't do it.

My advice to Aeogar is to boot up heidisql and figure out how to use it and to get a new database (I'll update this with link when i find it)