Loading DB

[PhilLambert]

I am now at a point where I can type:
source peqdb_1129Rev330.sql and it begins to update the database, however after about maybe 45 seconds or so it hits a repeating error with beegs. OMG THE BEEPS WONT STOP!
Error message is
ERROR:
Unknown command '\' '.

Any ideas?

[Andrew80k]

If I were guessing I'd say that you have a corrupted db file. I don't have that one yet as I just updated my db a couple of revs ago, so I guess it could be the uploaded file, but I don't know for sure. You might try to redownload and then unpackage it again, if you haven't already done that.

[PhilLambert]

Ok I have gotten through the above help with a lot of restarts and downloading a new peqdb file.
I think the server is working now.

The new problem is that I can not get any computer on the LAN to connect.
The eqhosts.txt all have the correct ip address and port 5999.
The router ports 3306, 5999, 7000-7100 are open for both udp and tcp, router port 9000 is open for only udp.
I am using the batch file that angelox made for keeping the eq log-in file (I forget the name right now)
The server is run on its own computer
The server DOS screen says there are connections

So the problem is that I can get to the server select screen, select the server and it boots me back to the login screen.

I am tired and my eyes hurt since I have been working on this for to many hours, so if I missed the fix for this on the message board I am sorry.

Thanks for the help.

[Andrew80k]

Check your logs. Look in your emu directory under logs. Have you set up accounts from these various machines that are connecting to the sever via the lan? The accounts table has to have the account and the IP address of the machine they are trying to login from.

[Yeormom]

You are trying to use the minilogin and not the public login correct? If you are trying to use the public login, that port looks wrong and you don't forward it on your end.

[PhilLambert]

I have checked the logs in my emu directory and nothing stands out. I deleted all log.txt files and re-ran server which then gave me 24 error logs, however nothing stood out.
The database was set up correctly.
I re did the server to connect to eqemu and I still could not log into it, I can however log into other servers.
In my ignorance the only thing I can think of is that I have the server on a switch off of the router, or maybe the router just is evil. So I am going to put the server on the router directly, and if that doesnt work then put the swtich and the server connected directly to the internet then the router.

[PhilLambert]

I did just have one thought as the server was shutting down. I read in the most common problems wiki that
"Make sure your world (and zone) servers are not bound to 127.0.0.1. This can happen in the <tcp> directive of your XML config file"
While my server is loading I do remember seeing 127.0.0.1 however after checking both my eqemu.xml and logininserver.ini I dont see 127.0.0.1 anywhere.
Could this do it?

[Andrew80k]

Does it say it's receiving a client connection in the logs at all?

[PhilLambert]

no not at all. It never mentions any client logging at all. All it talks about is server loading stuff.