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,
would be:
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.