Admin Password?

[AdrianD]

I think you just missed my edit:

use "yourDBname";
INSERT INTO `tblworldserverregistration` (`ServerLongName`, `ServerShortName`, `ServerListTypeID`, `ServerLastIPAddr`) VALUES ('yourname', 'yourname', 3, 'yourIP');

* Oh, and only change the text where it says yourname yourip, leave the little quotes. Remove the double quote for yourDBname so it's just use dbname;

Also, except for the login.ini file the format for the IP in those fields should be XXX.XX.X.XXX

Since you have HeidiSQL you don't need to use a query to change a table. Go to the table and play around with it. It's actually quite simple.

[AdrianD]

Here is my stuff, everything works fine:

eqemu_config

<?xml version="1.0"?>
<server>
	<world>
		<shortname>Jeryds</shortname>
		<longname>Jeryd's</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't)-->
		<address>192.168.15.181</address>
		<localaddress>192.168.15.181</localaddress>

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>192.168.15.181</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="127.0.0.1" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>some long random string</key>

		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>192.168.15.181</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>192.168.15.181</host>
		<port>7778</port>
	</mailserver>

	<zones>
		<defaultstatus>0</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>root</username>
		<password>xxx</password>
		<db>jeryds</db>
	</database>

	<qsdatabase>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>root</username>
		<password>xxx</password>
		<db>jeryds</db>
	</qsdatabase>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

login.ini

[database]
host = 127.0.0.1
port = 3306
db = jeryds
user = root
password = xxx
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.15.

[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

eqhost

[LoginServer]
Host=192.168.15.181:5998

query to insert MY DATA into tblworldserverregistration

INSERT INTO `tblworldserverregistration` (`ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `ServerTrusted`, `Note`) VALUES ('Jeryd\'s', '', 'Jeryds', 3, '2015-08-17 16:09:30', '192.168.15.181', 0, 0, NULL);

My LAN works just fine with the above settings.

[Warkral]

Originally Posted by AdrianD

I think you just missed my edit:

use "yourDBname";
INSERT INTO `tblworldserverregistration` (`ServerLongName`, `ServerShortName`, `ServerListTypeID`, `ServerLastIPAddr`) VALUES ('yourname', 'yourname', 3, 'yourIP');

* Oh, and only change the text where it says yourname yourip, leave the little quotes. Remove the double quote for yourDBname so it's just use dbname;

Also, except for the login.ini file the format for the IP in those fields should be XXX.XX.X.XXX

Since you have HeidiSQL you don't need to use a query to change a table. Go to the table and play around with it. It's actually quite simple.

OPPS, thats why I'm posting pix. I'm really terrible with these long, detailed querys, I knew I was screwing it up, if I wasn't I'd be killing rats and snakes right now hah.

[Warkral]

Hey Adrian, your query worked, no errors. Unfortunately it's still not showing up in the serveradminreg box, but its a start.

INSERT INTO `tblworldserverregistration` (`ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `ServerTrusted`, `Note`) VALUES ('Affliction Test Server', '', 'Affliction', 3, '2015-08-17 16:09:30', '192.168.15.181', 0, 0, NULL);

[AdrianD]

I used the query you provided and it worked for me. You can now login to my login server.

Kidding aside, sometimes it may not appear in the table right away because you need to refresh the table. The toolbar at the top near the left side has a button with two small green arrows shaped kinda like ying-yang, on my versionof HeidiSQL. Click that and see if it shows up.

EDIT: I read your reply incorrectly. Disregard my previous.

I don't know if it matters but, I haven't had anything in that table and I can login through my LAN.

Also, and a direct question: Are you paying attention to what that query was supposed to do? INSERT INTO `tblworldserverregistration` - NOT tblserveradmin..blahblah Your response gave me this impression.

Fire it up and see if anything changes.

and change the IP...

[Warkral]

Far as I know I'm trying to get the server registered, which it has thus far REFUSED to do. I did the query, it was (I think) accepted, I saw the "rows affected" 1, yet it won't actually do it.

[Debug] [08.18.15 - 16:23:59] Logging System Init.
[Debug] [08.18.15 - 16:23:59] Config System Init.
[Debug] [08.18.15 - 16:23:59] MySQL Database Init.
[Debug] [08.18.15 - 16:24:00] Encryption Initialize.
[Debug] [08.18.15 - 16:24:00] Encryption Loaded Successfully.
[Debug] [08.18.15 - 16:24:00] Server Manager Initialize.
[Network] [08.18.15 - 16:24:00] ServerManager listening on port 5998
[Debug] [08.18.15 - 16:24:00] Client Manager Initialize.
[Network] [08.18.15 - 16:24:00] ClientManager listening on Titanium stream.
[Network] [08.18.15 - 16:24:00] ClientManager listening on SoD stream.
[Debug] [08.18.15 - 16:24:00] Server Started.
[Network] [08.18.15 - 16:24:02] New world server connection from 192.168.0.13:55848
[Database] [08.18.15 - 16:24:02] Mysql query returned no result: SELECT AccountName, AccountPassword FROM tblServerAdminRegistration WHERE ServerAdminID = 1
[World] [08.18.15 - 16:24:02] Server Affliction Test Server(Affliction) attempted to log in but database couldn't find an entry but unregistered servers are allowed.

[AdrianD]

I edited my comment immediately after posting it initially. You may have not seen it again. I give you credit for being on top of your subscriptions.

Change the IP to your IP in the table that query was referring to.

[Warkral]

Still no love. This is unreal. Put the entire thing together in 2-3 hours and have spend 5 days on the login. Maybe it got corrupted somehow.