Loading DB

[PhilLambert]

I have searched every key word I can think of and done everything in the posts I have found so far, yet I continue to have the same problem:

I have correctly downloaded the peq_db and peq_quests folders from the new CVS server address :pserver:anonymouse@peq.cvs.sourceforge.net:/cvsroot/peq.
Source load_player.sql loads fine
source load_system.sql did not.
Found that a new file is being used
pepdb_1129rev330
source peqdb_1129rev330 gets the
failed to open file 'peqdb_1129rev330', error 2
Found I have to extract that file which I did with 7zip
Extracted to peq_db folder and got same error
Extracted to C:, which is where peq_db and peq_quests are located, same problem.
Copied both peq_db and peqdb_1129rev330 to mysql\bin folder again same error.

I have seen a bunch of info on source load_system.sql, yet not much on peqd_1129rev330.

Please help.

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