Admin Password?

[Warkral]

Originally Posted by AdrianD

The loginserver message is different from the OP and the more recent post. I receive the latter message and I am able to login through my LAN. I do not have anything for admin or password in those associated fields. Because of this, I am guessing there may be an issue with your eqemu_config and or login.ini file.

One suggestion I have is to change the name of your server in the two lines in the config file to something very simple like cookies or deer and make it the same in the two places where this goes. (first two simple words I thought of)

I'm not an expert on any of this but, I have been in your shoes and have configured the whole thing nearly dozen times in the last year.

I should backtrack then.

Is this the first time you are trying to do this or have you been able to login and play in the past? It sounds like the first time but can't be sure.

* I didn't see anything mentioned about `tblloginserveraccounts` and whether or not you have the account data entered into this table for each player.

I created a server using the previous walkthrough about 2 years ago, then moved to the Ax Classic repack. When they dropped support for it I figured I'd make another server the long way but sure as heck struggling with the lasty part here. Its kicking my butt.

<shortname>Affliction</shortname>
<longname>Affliction Test Server</longname>

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


<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account>Razzlam</account>
<password>xxxx</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>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

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

<zones>
<defaultstatus>20</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>xxxx</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>xxxx</password>
<db>peq</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>

host = 127.0.0.1
port = 3306
db = peq
user = root
password = xxxx
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 = 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

Yes, tried dozens of times to log in. After 5 seconds "A timeout occurred" and it kicks me back to the login screen.

[AdrianD]

<shortname>Affliction</shortname>
<longname>Affliction Test Server</longname>

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

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>

Few questions:

1. Unless you corrected your typo, the long name is different from what is in the database. Unsure if this would affect it.

2. Did you forward your ports correctly?

3. Above, where the IP addresses belong, change all of them to your IPv4 address of the computer where the server is located.

open command prompt/dos prompt, type ipconfig, hit enter

I have more questions/feedback but, I'll start there.

I just logged into my LAN login server before I typed much of this.

[Warkral]

Originally Posted by AdrianD

Few questions:

1. Unless you corrected your typo, the long name is different from what is in the database. Unsure if this would affect it.

2. Did you forward your ports correctly?

3. Above, where the IP addresses belong, change all of them to your IPv4 address of the computer where the server is located.

open command prompt/dos prompt, type ipconfig, hit enter

I have more questions/feedback but, I'll start there.

I just logged into my LAN login server before I typed much of this.

I agree, thats how it was set for Ax Classic and I never had a problem, changed them over to IP's but same status:

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

The port forwarding should be fine. Its been the same for years. I'm stumped.

[AdrianD]

Are the client eqhost files pointing to the login server.

[LoginServer]
Host=your IPv4:5998 for titanium 5999 for more recent

Just to be certain on the port forwarding, which ones are forwarded? EQEmu may use different ports than AX. I don't know so, I ask.

You need your zone ports (min range 7000 - 7100 for what's in your config file) 9000 for <tcp ip="127.0.0.1" port="9000" telnet="disable"/> which I don't know about. 5998 and 5999 are for the login server but, in a LAN I am unsure if they need to be forwarded.

Also, do you have `login_opcodes` and `login_opcodes_sod` located in your server folder (root directory)?

Still more but three at a time can narrow down your issue better than a dozen.

[AdrianD]

* I need to correct myself. My log is different, I apologize.

[World] [08.17.15 - 16:09:30] Server Jeryd's(Jeryds) did not attempt to log in but unregistered servers are allowed.

Based on that I would, change your name to something simple in your config file, as I stated, just for now, humor me or be certain your names match up with spaces, typos and anything else.

Then, manually create an entry in the table `tblWorldServerRegistration` in your database. Enter your long name/short name/3 (in `serverlisttypeid`)/192.168.0.13 (in last ip used)

That's all you need to do for that table.

[Warkral]

Originally Posted by AdrianD

Are the client eqhost files pointing to the login server.


Just to be certain on the port forwarding, which ones are forwarded? EQEmu may use different ports than AX. I don't know so, I ask.

You need your zone ports (min range 7000 - 7100 for what's in your config file) 9000 for <tcp ip="127.0.0.1" port="9000" telnet="disable"/> which I don't know about. 5998 and 5999 are for the login server but, in a LAN I am unsure if they need to be forwarded.

Also, do you have `login_opcodes` and `login_opcodes_sod` located in your server folder (root directory)?

Still more but three at a time can narrow down your issue better than a dozen.

I just split 98 and 99 just to see if it would make any difference, it didn't:


Changing server name then rebooting server.

Then, manually create an entry in the table `tblWorldServerRegistration` in your database. Enter your long name/short name/3 (in `serverlisttypeid`)/192.168.0.13 (in last ip used)

That's all you need to do for that table.

I tried that, not very familiar with the syntax because all my manually created (long, detailed) query's fail. (I just copy/paste the long query's from the walkthroughs).

[AdrianD]

I don't know what to say really. All I know is, I don't have a ton of knowledge on a lot of things related to this stuff. Because of this I try to follow tried and true methods to a T. Only upon almost certainty that I adhered to those methods, I try alternatives through my minimal knowledge base or logic with limited experience.

I don't know why you have 9000 to 9100 as a range in your ports. I don't know if a revised setup walkthrough asked for it or if it even matters.

Unless you are confident in your abilities, I would scrap any ideas about using an AX setup for an EQEmu system. Not intending to be critical with that statement just, to the point.

I would get your hands on a copy of HeidiSql pronto! It makes using MySQL quite a bit easier.

In the meantime you could use this:

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;

[Warkral]

Originally Posted by AdrianD

I don't know what to say really. All I know is, I don't have a ton of knowledge on a lot of things related to this stuff. Because of this I try to follow tried and true methods to a T. Only upon almost certainty that I adhered to those methods, I try alternatives through my minimal knowledge base or logic with limited experience.

I don't know why you have 9000 to 9100 as a range in your ports. I don't know if a revised setup walkthrough asked for it or if it even matters.

Unless you are confident in your abilities, I would scrap any ideas about using an AX setup for an EQEmu system. Not intending to be critical with that statement just, to the point.

I would get your hands on a copy of HeidiSql pronto! It makes using MySQL quite a bit easier.

In the meantime you could use this:

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

Ohh I wasn't very clear, I'm not using the Ax setup, using Heidi and followed the walkthrough to a T....or so I think.