Loading DB

PhilLambert · #1 02-16-2009, 04:50 PM

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 · #2 02-16-2009, 07:00 PM

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 · #3 02-16-2009, 10:23 PM

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 · #4 02-17-2009, 04:15 AM

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 · #5 02-17-2009, 11:42 AM

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 · #6 02-17-2009, 03:08 PM

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 · #7 02-17-2009, 03:08 PM

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 · #8 02-17-2009, 03:20 PM

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 · #9 02-17-2009, 04:14 PM

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

PhilLambert · #10 02-17-2009, 05:17 PM

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

PhilLambert · #11 02-17-2009, 05:18 PM

BTW Thank you for your help so far.

Andrew80k · #12 02-17-2009, 05:59 PM

Can you post your emu_config.xml and your LoginServer.ini file?

PhilLambert · #13 02-17-2009, 06:11 PM

<?xml version="1.0">
<server>
<world>
<shortname>Drache</shortname>
<longname>The Drache Family</longname>


<address>eqemulator.net</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>


<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>#############</password>
<db>peq</db>
</database>
</server>

[LoginServer]
loginserver=eqemulator.net
#loginserver2=
loginport=5998
#loginport2=
#worldname=
#worldaddress=
#locked=false
#account=
#password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=eqemulator.net
ServerPort=5998

Andrew80k · #14 02-17-2009, 06:21 PM

Ok, first let me ask you some questions. Are you trying to use minilogin or the public login server? Your config is messed up either way but let's figure out what you are trying to do first.

PhilLambert · #15 02-17-2009, 06:23 PM

Well I wanted to run on mini login, however when that failed I switched back to public login. I will probably just keep it public from a while since this is beyond my scope of ability.