Admin Password?

Warkral · #1 08-16-2015, 08:02 PM

Using http://wiki.eqemulator.org/p?Complet...Guide&frm=Main to create a private server for the wife and I to play on: http://wiki.eqemulator.org/p?Windows...Guide&frm=Main

I have followed these guides step by step, even trashed it all and started over and I always end up here.

Creating my own server and I've tried about 8000 possible combinations and still have no clue what the admin name or password is. Any ideas? And yes, I have tried every single PW I set, but it appears I didn't set this password or I would know it. What database? It accepts none of my logins or passwords, tried admin/Admin password/Password....nothing works. Hell I've even left it blank, still no luck.

**Uleat** · #2 08-16-2015, 08:54 PM

(Assuming that you have your own login server running...)

For world accounts, you need to ensure that the id's match in `tblserveradminregistration` and `tblworldserverregistration` .. as well as
the <account> and <password> fields in your eqemu_config.xml file to the corresponding columns in `tblserveradminregistration.`

You might try setting login.ini:unregistered_allowed to TRUE just so you can get in and verify that everything else is working.

(If you're using the eqemu public login server...)

You should be allowed to connect without a valid account/password.

Warkral · #3 08-16-2015, 09:22 PM

Quote:

Originally Posted by Uleat

(Assuming that you have your own login server running...)

For world accounts, you need to ensure that the id's match in `tblserveradminregistration` and `tblworldserverregistration` .. as well as
the <account> and <password> fields in your eqemu_config.xml file to the corresponding columns in `tblserveradminregistration.`

This is where things get confusing. Could you explain this in detail? ( I have no idea who Tom Wilson is)

**Uleat** · #4 08-16-2015, 09:45 PM

These two id's should be the same:

EDIT: And the account/password from your first image link should be what appears in your eqemu_config.xml file for world login.

**Uleat** · #5 08-16-2015, 10:03 PM

Looking at your server admin registration table, you just have the default entry from the db creation.

You can use that entry, or create a new one..either way will work - so long as the ServerAdminID's match and your config file
is up-to-date.

Warkral · #6 08-17-2015, 08:45 AM

My admin box is empty. I'll have to correct that and see if that fixes the issue.

Warkral · #7 08-17-2015, 11:41 AM

I tried Admin/Password but it didn't work. None of the accounts are showing in the world server reg box.
I've been researching this today and am not sure how to 'register' the server so it shows up admin:

Quote:

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

I found this searching around, but the query failed when I tried it:

Quote:

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.

AdrianD · #8 08-17-2015, 04:35 PM

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 suppose the obvious question doesn't get asked. Have you actually tried to login from a player account? I see no mention of you trying.

Warkral · #9 08-17-2015, 04:48 PM

Quote:

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.

Quote:

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


<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account>Razzlam</account>
<password>xxxx</password>
</loginserver>






<tcp ip="127.0.0.1" port="9000" telnet="disable"/>


<key>some long random string</key>


<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<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>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

Quote:

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.

**Uleat** · #10 08-17-2015, 08:06 PM

Ok..Let's make sure we're on the same page here...

For you and your wife to play, you will need at least two computers..which necessitates using a LAN IP for your server's address.

All IP addresses in your eqemu_config.xml file will need to be the LAN IP address of the computer hosting the server - with the exception
of database IPs..which should be '127.0.0.1'

This is the same configuration that you will use for both LAN-only and WAN access. The only difference is that you would not forward
ports on a LAN-only setup. (There is a slight difference in <world> address/localaddress..but, that can be overlooked for now.)

Your login.ini settings should be similar.

The database should point to '127.0.0.1' and the local network should contain the LAN address, minus the host address
(3 integers, 3 delimiters.)

So,

Code:

192.168.0.13

would be:

Code:

192.168.0.

I'm not quite sure why your server admin table failed..but, it may have to do with the AUTO_INCREMENT setting in the primary (used) key.

Try running your query again..but, this time, remove `ServerAdminID` and its corresponding VALUE. It should auto assign a value - which
you will need for your `tblworldserverregistration` entry.

(Assuming your world server registration and account info is up-to-date... [see previous posts])

You will need to add login server accounts for people whom you would like to allow access.

Step 5 of the private login server guide (http://wiki.eqemulator.org/p?Windows...Guide&frm=Main) shows the script used to add player accounts.

They can also be added manually through HeidiSQL. You will just need to security hash the password before the accounts can be logged in.

This sql query can be run in HeidiSQL if you manually enter the account information:

Code:

UPDATE `tblloginserveraccounts` SET `AccountPassword` = sha(`AccountPassword`) WHERE `AccountName` = '<account name>'

Change <account name> to the name of the account that you want to hash the password for. Just remember to only hash it once or the account
will be inaccessible.

Look this over and see where you are.

Warkral · #11 08-17-2015, 08:18 PM

Quote:

Originally Posted by Uleat

Ok..Let's make sure we're on the same page here...

Your a glutton for punishment haha. Thank god for me because I am determined to figure out what I did wrong. You don't even want to know how long it took the first time I did this without an exe repack (17 days), although in my defense, it was all the compiling errors before, the login server gave me no problems. Ok, here we go..........

Making changes, brb

AdrianD · #12 08-17-2015, 08:29 PM

I'm glad someone else showed up who knows more than me. That's about everyone here though.

Problem being for those like me, these people don't use lay terms...

Warkral · #13 08-17-2015, 08:35 PM

(Shortened copy pastes to relevant information:

Quote:

[database]
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

Quote:

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


<address>192.168.0.</address>
<localaddress>192.168.0.</localaddress>


<loginserver>
<host>192.168.0.</host>
<port>5998</port>
<account>Razzlam</account>
<password>xxxx</password>
</loginserver>

And every variation of the query is failing, but I'm probably doing it wrong. Anything beyond a one word query is confusing to me:

Quote:

INSERT INTO use "peq";
INSERT INTO `tblworldserverregistration` (`ServerLongName`, `ServerShortName`, `ServerLastIPAddr`) VALUES ('Affliction Test Server', 'Affliction','192.168.0.13');

AdrianD · #14 08-17-2015, 08:40 PM

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 · #15 08-17-2015, 08:49 PM

Here is my stuff, everything works fine:

eqemu_config

Code:

<?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

Code:

[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

Code:

[LoginServer]
Host=192.168.15.181:5998

query to insert MY DATA into tblworldserverregistration

Code:

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.