Admin Password?
 

http://img.photobucket.com/albums/v6...psbvedls8j.jpg

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.

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

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/v6...pskfhazklh.jpg
http://img.photobucket.com/albums/v6...ps7qbaghmn.jpg

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.

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.

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

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/v6...psxvwx8ydc.jpg

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

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.

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.

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

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:
The port forwarding should be fine. Its been the same for years. I'm stumped.

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

I just split 98 and 99 just to see if it would make any difference, it didn't:
http://img.photobucket.com/albums/v6...ps2yxtx5hg.jpg

Changing server name then rebooting server.

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

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;

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.

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.

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?

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:

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.

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

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

(Shortened copy pastes to relevant information:
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:
http://img.photobucket.com/albums/v6...psdkmvthfc.jpg

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.

Here is my stuff, everything works fine:

eqemu_config
login.ini
eqhost
query to insert MY DATA into tblworldserverregistration
My LAN works just fine with the above settings.

OPPS, thats why I'm posting pix. I'm really terrible with these long, detailed querys, I knew I was screwing it up, if I wasn't I'd be killing rats and snakes right now hah.

Hey Adrian, your query worked, no errors. Unfortunately it's still not showing up in the serveradminreg box, but its a start.

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

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.

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.

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/v6...ps1gwhprnr.jpg

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.

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.

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.

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.

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!

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

People ask where my hair went.

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.

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:

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.