View Single Post
  #23  
Old 04-26-2012, 01:14 AM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Did you create a 'tblLoginServerAccounts' entry? This is the actual eq client account user/password that you will use to log into the game with. The password needs to be security hashed as well and can't (to my knowledge) be hashed by simply changing it in Navicat. You can check to see if it is hashed in Navicat by looking at the data field. If you can see the actual password, or don't have an entry in this table at all, you will need to use one of the following:

--If you have already created a login account, but need to hash the password--

UPDATE tblLoginServerAccounts SET tblLoginServerAccounts.AccountPassword = sha('password') WHERE tblLoginServerAccounts.AccountName = 'yourloginname'

password = your password, yourloginname = your login name =)

These must be enclosed by the single quotes ' '

--If you need to add a new user account to the login table--

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES ('yourloginname', sha('password'), 'fakeemailaddress', now(), '127.0.0.1')

Everything in the VALUES section is enclosed in ' ' because it is an actual value with the exception of now(). That is because it is a mysql command that inserts a current timestamp into its place. You could manually put a date/time in single quotes if you know the format it uses.

(You can 'Run' these as a 'Query' in Navicat/HeidiSQL or use it from the MySQL command line tool. Just make sure to add a semi-colon ( ; ) to the end of the line if you use the MySQL command line. If you forget and you wind up with a new line (->), just type a semi-colon on this line and hit enter again. And again, don't forget to 'Use peq' first.)

Under eqemu_config, you might change the tcpip = "localhost" to "127.0.0.1" as well. Not sure if that would keep you from logging in, but it keeps everything "neat."

What revision of EQEmuLoginServer did you finally end up using? Now that you have a "configured" |login.ini| file, if you change the revision that you use, you will just need to make sure that instead of those 5 files, you copy over the 4 remaining files. If you copy |login.ini| again, it will overwrite your configured version with a non-configured version.

Also, I'm not sure if the database name is case-sensitive, but you could verify what Navicat indicates it to be and then ensure both files use the same.

Everything else in your configs looks right for a local/solo setup.

If this works, let us know..if not, we'll see what we need to do next.

Checklist on hold..back to working on something better!

Last edited by Uleat; 04-26-2012 at 01:18 AM.. Reason: NO SMILEY!!!
Reply With Quote