Admin Password? [Archive] - EQEmulator Forums

Warkral

08-16-2015, 08:02 PM

http://img.photobucket.com/albums/v635/Razzlam/account_zpsbvedls8j.jpg (http://smg.photobucket.com/user/Razzlam/media/account_zpsbvedls8j.jpg.html)

Using http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main to create a private server for the wife and I to play on: http://wiki.eqemulator.org/p?Windows_Private_Login_Server_Setup_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

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

08-16-2015, 09:22 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.`

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

http://img.photobucket.com/albums/v635/Razzlam/wilson_zpskfhazklh.jpg (http://smg.photobucket.com/user/Razzlam/media/wilson_zpskfhazklh.jpg.html)
http://img.photobucket.com/albums/v635/Razzlam/data_zps7qbaghmn.jpg

Uleat

08-16-2015, 09:45 PM

These two id's should be the same:

http://i.imgur.com/WyF7omQ.jpg

http://i.imgur.com/5hTwgzH.jpg

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

Uleat

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

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

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:
http://img.photobucket.com/albums/v635/Razzlam/admin_zpsxvwx8ydc.jpg

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

08-17-2015, 04:35 PM

Warkral

08-17-2015, 04:48 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 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>


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

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

08-17-2015, 05:07 PM

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

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

08-17-2015, 05:22 PM

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

08-17-2015, 05:40 PM

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

08-17-2015, 06:07 PM

* 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

08-17-2015, 06:25 PM

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:
http://img.photobucket.com/albums/v635/Razzlam/port_zps2yxtx5hg.jpg

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

08-17-2015, 07:16 PM

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

08-17-2015, 07:18 PM

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.

Warkral

08-17-2015, 07:27 PM

Thanks for trying to help, but yea, every query comes up as a sqp error 1064. Guess I'm just stuck. I do appreciate you at least attempting to help me. This stuff is way more complicated then it appears.

Warkral

08-17-2015, 07:40 PM

Since I know your server works can you post a pic of all your windows that open when you boot up your server so I can see how different they are then mine?

Uleat

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

would be:
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_Private_Login_Server_Setup_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:

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

08-17-2015, 08:18 PM

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

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

08-17-2015, 08:35 PM

(Shortened copy pastes to relevant information:
[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

<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:
INSERT INTO use "peq";
INSERT INTO `tblworldserverregistration` (`ServerLongName`, `ServerShortName`, `ServerLastIPAddr`) VALUES ('Affliction Test Server', 'Affliction','192.168.0.13');

http://img.photobucket.com/albums/v635/Razzlam/fail_zpsdkmvthfc.jpg

AdrianD

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

08-17-2015, 08:49 PM

Here is my stuff, everything works fine:

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


<address>192.168.15.181</address>
<localaddress>192.168.15.181</localaddress>


<loginserver>
<host>192.168.15.181</host>
<port>5998</port>
<account></account>
<password></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>192.168.15.181</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>192.168.15.181</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>


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


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




</launcher>


<files>




</files>

<directories>



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

08-17-2015, 08:49 PM

Warkral

08-18-2015, 01:25 PM

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

08-18-2015, 04:50 PM

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

08-18-2015, 05:24 PM

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

08-18-2015, 05:31 PM

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

08-18-2015, 05:42 PM

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.

http://img.photobucket.com/albums/v635/Razzlam/nolove_zps1gwhprnr.jpg

AdrianD

08-18-2015, 05:59 PM

I don't know what to say, again.

I don't wish to go around in circles too much more in a public forum.

I also don't want to think out loud by speaking anecdotes and create more confusion.

Warkral

08-18-2015, 06:12 PM

I don't mind looking stupid. Someone at some point is going to run into the same problem as I'm having and instead of spending a week trying to figure it out, will google it and find the eventual fix in minutes and be playing. I can't tell you how many problems I've had I just googled and fixed and was on my way. These forums are a goldmine, I think of it has contributing.

AdrianD

08-18-2015, 06:31 PM

That is more important than looking stupid or wasting a few bytes of space, I agree.

I enjoy problem solving, particularly when I know little of the problem. Solving it is that much more rewarding.

I don't know what else to ask. They would be stabs in the dark.

If it were my problem, I would set it up to use login.eqemulator.net first to make sure the server functions.

It's a process of elimination and, unfortunately, your problem seems to require this process.

Warkral

08-18-2015, 06:40 PM

I actually did that at first, and the server shows up on the list, but I was never able to log in. That's when I figured I would work on it internally and see what the real problem was.

AdrianD

08-18-2015, 06:48 PM

Creating you own loginserver is ADDING more steps. EQemu is kinda like the control, it "always" works.

Changing the config file for a LAN AFTER you know your server works is very easy.

I'm no expert but, this new revelation has a possibility of being the culprit.

Get in game from eqemu and go from there!

Uleat

08-18-2015, 07:37 PM

There's a lot of information to digest when setting up a server, for sure...

AdrianD

08-18-2015, 07:46 PM

People ask where my hair went.

Burningsoul

08-18-2015, 07:59 PM

Instead of manually entering queries for this problem table, why not just run the load_login.sql file? You can hand edit that before running it via sql command prompt to place in your name/password and the short and long server names. Since the password is SHA'd anyway this would skip a problem step.. hell if you want, PM me your details (Name, password, Server Long name, Server description, server short name) and I'll edit the files, zip em and you can try that. Worked a treat for me when I was a greenie smashing my head against the local loginserver.

Disclaimer - I've only loosely followed this thread, so I may be off base. I'll check back in a few, got dinner going right now.

Warkral

08-21-2015, 02:11 PM

UPDATE: Ok, I was using the incorrect query to register the server. Posting this here for anyone in the future who has this issue. The correct query is:
Well, its going through with no errors, but still no love, not working:
http://img.photobucket.com/albums/v635/Razzlam/nolove_zps1gwhprnr.jpg

Ok..I think I see what you need here.

You're looking to create a server admin account..but, the script you are using is for world server creation.

On this table you have linked, I would just enter the information manually at this point.

Right-click and add a new row..then start with `AccountName` and move right.

To edit a cell, you have to hit enter.

Account Name/Password must be valid since these will be used in the config file.

First/Last Name and Email can be anything (Tom Wilson?) since this is for admin use and I hope you wouldn't need to send yourself an email telling you something is wrong :P

RegistrationDate, just hit enter and the current date should appear.

RegistrationIPAddress, enter the server's LAN IP address.

If you prefer queries:
INSERT INTO `tblserveradminregistration` (`AccountName`, `AccountPassword`, `FirstName`, `LastName`, `Email`, `RegistrationDate`, `RegistrationIPAddr`) VALUES ('Ack', 'Ack', 'Mars', 'Attacks', 'mars.attacks@ackack.com', now(), '127.0.0.1')

Warkral

08-21-2015, 02:27 PM

Still working on actually connecting. I've ruled out the config file and am now thinking its a network issue. I've checked my ports (Forwarding) a dozen times and changed setting in the config and login files at least 50 times with no luck. Turning my virus protection (Kaspersky) off on one or both computers didn't work, windows firewall is off, so the list to troubleshoot is getting smaller and smaller with no connection being made, even locally. The LAN won't even connect to the server. Might be a Windows 10 issue I have to research tonight.

I have to give ULEAT a TON of props and my thanks. He has logged on with me every single night for the last week and spend hours and near a 100 PM's attempting to help me resolve this issue. I can't thank him enough.

Warkral

08-22-2015, 01:00 PM

FIXED!

Turns out it was a Windows issue. The server computer was running Win7 and client computers running Win10. Apparently upon installing 10 it created a new network and placed both client computers on that network and the server computer was on another network. I figured the easiest thing to do was go ahead and upgrade the server computer to 10 while its free and problem was solved.

Hope this helps someone in the future!