windows server.

proge · #1 05-21-2007, 11:33 PM

Im trying to get my own server set up, and its not looking good so far. I am 100% noob to this whole thing. so with that being said onto what is holding me up. I am going step by step from the guide http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5
and am now on the part where I have to Sourcing in the Database. ok I do what is said to do (as in
Click Start->Run-> and type in cmd to bring up your command prompt
Now type in cd\peqdb
You should be at C:\peqdb> )
but I get "mysql is not recognized as an internal or external command, operable program or batch file."

I don't know if I missed something I had to do but any help on getting passed this would be nice thanks ahead of time.

uncommon · #2 05-22-2007, 01:48 AM

mysql bin directory (for exemple : c:\mysql\bin) is not in your PATH, add it.

how to here : http://www.computerhope.com/issues/ch000549.htm

proge · #3 05-22-2007, 06:27 AM

so what should i put there for myu variable value?

proge · #4 05-22-2007, 08:39 AM

hmm i think i got past that part but now when i type in my password that i put down for it i get.

can't connect to mysql server on 'localhost'

anymore help on this part? ( and thanks a ton for the help on the last part)

vales · #5 05-22-2007, 09:48 AM

Did you open up the MySQL port? Did you change or enter your MySQL password? Did you enable OLD_PASSWORDS?

Quote:

set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');

You shouldn't be getting connection issues if this is your first time setting it up. We don't know what you've done (if you messed anything up), so it's hard to help you if you can't troubleshoot basic things by yourself. That error could mean a few things - namely a port, service or password issue.

proge · #6 05-22-2007, 10:12 AM

ok thought this info might help (like i said im 100% noob to this)

<?xml version="1.0">
<server>
<world>
<shortname>whatever</shortname>
<longname>Your server name</longname>






<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>
<pasword>williams</password>
<db>PEQ</db>
</database>
</server>

vales · #7 05-22-2007, 10:16 AM

That info doesn't answer my question.

1.) Did you open up the MySQL ports?
2.) Are you playing on the same PC you are hosting the server on?
3.) Do you have a firewall or router?

I never asked for a configuration to the server.

Let's take it step by step first. The setup guide is good, but assuming you know how to use basic networking will make things go much easier. :p

jimbabwe · #8 05-22-2007, 10:16 AM

Vales you are a support monster. I bet you never even sleep do you?

proge · #9 05-22-2007, 10:16 AM

yes i have a firewall and a router not sure what to do or how to do the ports

and no i have the server on one comp, and im going to be playing on a diff one.

vales · #10 05-22-2007, 10:18 AM

Quote:

Originally Posted by jimbabwe

Vales you are a support monster. I bet you never even sleep do you?

HEH. Being unemployed has it's advantages, lol.

proge, you didn't answer my other questions. :p

Ah, okay then.

jimbabwe · #11 05-22-2007, 10:19 AM

I'm willing to bet he changed his password at least once... if you look at his config file in the password tags he put "williams"

proge · #12 05-22-2007, 10:25 AM

did it a few times lol and the short names and so on....been at this for some hours now.

vales · #13 05-22-2007, 10:27 AM

Yeah, might want to try some basic stuff out first, though.

If this is all new to you and you don't know how to configure your router, then first of all, find out the model of your router. Then go to portforward.com and fill in the spaces and configure your router from there. It's in the Port Forward section on the top left of the site. It's pretty self explanitory.

You want to open all of the ports for your server.
5998, 5999, 3306, 700-7005

After you've done that, check to see if you can see the server name by logging in with the PC you're playing on. Make sure you change the eqhosts.txt file to reflect that you're connecting to the server PC on your LAN.

You need to understand basic networking and how to utilize your router. If it's a failry decent one, you don't even need your firewall software. In most cases, that causes more problems for people than preventing it.