Ok, question
 

Ok well I think I'm alot closer to getting my server up, And I've been searching around and haven't seen anyone who has the same problems with there server as me. When I dclick the Start.bat, I get 2 screens, one dissapears real fast, and a screen that says Wait for world to finish loading... Press enter when done... Press any key to continue. I press enter and it takes me to a blank screen that says nothing, and I did what the tutorial said, I waited 30 seconds, actually 10 minutes and it still does nothing, So, I just move on and try to open the zone.exe and the world.exe, they both open for a split second and then close, when I read the error logs it says ---------------------
[05.03. - 02:27:56] Starting Log: logs/eqemu_debug_world_3156.log
[05.03. - 02:27:56] [WORLD__INIT] Loading server configuration..
[05.03. - 02:27:56] [WORLD__INIT] Log settings loaded from log.ini
[05.03. - 02:27:56] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[05.03. - 02:27:56] [WORLD__INIT] Connecting to MySQL...
[05.03. - 02:27:56] [WORLD__INIT_ERR] Cannot continue without a database connection.

AND I KNOW that people have had similiar problems but there not exactly the same as mien and I tried the replies and solutions and they haven't worked for me, any ideas one what this might be?

Well, it's really self explaining : there's a problem while etablishing the connection with mysql.

Check that part of your eqemu config file, make it reflect your actual mysql configuration (you set the password after mysql install and the DBNAME is the name of your database : peq, ax_peq or whatever your sourced).

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>Your Password</password>
<db>DBNAME</db>
</database>

PS : In fact you should read the mysql section of that howto, it's better than my crappy english.
http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3309</port>
<username>root</username>
<password>******</password>
<db>peq</db>
</database>
</server>

Thanks for your post, Where it says localhost, I tried 127.0.0.1 and my Internal and external ip, and it still didnt work, but I've already went by that tutorial and tried what you said, and it still doesnt work, I even enabled ports 5999, 3309, 3306 on my router, shut off my firewall, I have perl, MYSQL, set up exactly how they said to have it set up. Any other possible problems that I might not be noticing?

Make sure you did these steps.

C:\mysql\bin\mysql -u root peq

> GRANT ALL PRIVILEGES ON peq.* TO eq@localhost IDENTIFIED BY 'eq' WITH GRANT OPTION;

This is if you installed the PEQ database.

Change eq@localhost to root@localhost

If you are using root which it looks like you are.

make sure the dtabase server is on the same machine as the eqemu server. It doesn't have to be but it will make things easier to start out.

Hmmm
 

Where do I type all that? In the MYSQL command line client? I just re-did the WHOLE tutorial over again on a brand new computer in my basement, still the same problem. The world.exe and the zone.exe just dissapear instantly. I tried typing what you said into the SQL command line client and it just gave me some error. In the logs it says cant find database or some crap (Same thing I posted above) I've tried going through the login server and typing my IP, 127.0.0.1 and my Internal 192.168.1.104 and External in every place it asks for it. I tried ports 5999 and 3066 for everything that asks for a port, I have them all unblocked, And I know 100% that I did everything right. What your saying might work but I dont know where to type all that, or how to do it. Thanks for the post, can you guide me a little more? By the way, heres some other error I find in the log, now that I re-did the server thing: ---------------------------------------------
[05.03. - 18:40:33] Starting Log: logs/eqemu_error_zone_4008.log
[05.03. - 18:40:33] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

Go to Mysql site and download the MySql Adminsitrator GUI, it's all real easy there

Ok, thanks, hopefully it helps. I'll tell you if it does or if I have a question :)

should I set all the places that ask for ports to 5999 or 3306? If not one, which ones need to be set to 5999 and which ones 3306? Also for IP addresses, which ones should be set to localhost and which ones 127.0.0.1?
Thanks

You mean your firewall? is this a windows, linux, or router firewall? If you have a router, you don't need Windows or Linux firewall, unless you have a DMZ server.
heres some ports;
3306/udp 5999/udp 9000/udp 7000 - 7005/udp 3306/tcp 5999/tcp 7000 - 7005/tcp
You don't need to clear ports on your router if you play in your LAN only

If you use static zones, then you have to open more of the 7000 ish zones

No I mean in the files like LoginServer.txt and eqemu_config.xml. I have my firewall turned off, and all those ports enabled. Im not for sure what static zones are, the only experience with this that I've had is the tutorial I went through. I'musing mini login and right now all I'm trying to do is get the server up, no public or even lan, just trying to get singplayer working and lan later.

What guide did you follow.

If used the latest guide, the GRANT ALL PRIVILAGES command is not needed.


Try this one, as the error you get is normally do to this step being missed in the guide.

**** being the password for your root account you put in when running the instance server config wizard from the end of the mysql setup. (LEAVE THE ' IN THERE)


To get to where you need to type this in, Start->Programs->Mysql->Mysql Server5->MySql Command Line client

or Go to run, type in cmd, and when that comes up, type in mysql -u root -p



You dont have to be under any database to do this. Just run the command

I did that step, the ***** is my password. (just blanked it out because it doesnt need to be shown) Thanks for the post, got any other ideas? Does MYSQL need to be in a certain location of my computer? like C:\MYSQL because mine was originally installed in C:\program files\MYSQL

Not really. I use MySQL in its deafult folder. What version are you running of the emu and mysql. Assuming the latest right?

Are you using eq in your eqemu_config.xml file under the database information, or root


Also, the port number in your eqemu_config.xml file is supposed to be 3306, you have 3309 from a ealier post

Yes, both the latest versions in the latest Server setup tutorial for windows. I followed every letter of it as best I could.

What do you mean by "Are you using eq in your eqemu_config.xml file under the database information, or root"? Im not for sure what you ment, my eqemu_config.xml file is in my EQEmu folder and I have it set to root and PEQ database.

Yeah I noticed that and changed the port, still the same problem, so that wasnt it. Thanks alot for the help, I hope you can help me get this working! :)

If you're using MySql 5x, did you run the above line in your MySql command box?

Yes I did run that line, even though someone above said I didnt need to, I did anyways.

I said you didnt need to run the GRANT ALL PRIVILAGES command.

But the one that I mentioned and the one that angelox mentioned have to be run in mysql 5.x. EQEmu was built for mysql 4, and the password system has changed between 4 and 5 so that command is a must.

Mine was for the root account. Angelox mentioned the eq account that you may have created. Given that line I mentioned in my last post about 'eq'@'localhost' error you had in one of your logs, that would mean that in your eqemu_config.xml file under that database information you would have the username as eq instead of root.


ON the contrary though. You posted your xml file that had root in it and also you said that you were using root. So why is this error showing up for you? You have had to change the xml file at some point and put eq in there. If you did this, you need to create the account in mysql, assign it a password.

Then run the GRANT all privilages command from a very early post. This will give 'eq'@'localhost' permision ot accesee and modify the peq databse. You will then also have to run the set password command angelox mentioned to to fix the password scheme from 5.x to make it compatible with 4.x type applications

Do I just type in > GRANT ALL PRIVILEGES ON peq.* TO eq@localhost IDENTIFIED BY 'eq' WITH GRANT OPTION;

or do I have to do that C:\mysql\bin\mysql -u root peq, because the last time I tried typing that in I got an error... And do I need to change eq@localhost to root@localhost since Im using root? Thanks

Heres the best way to do this. Download the GUI Tools from Mysql

Open up Mysql Administator

Go to User Administration

in the bottom left corner, see if you have two users, on being root, the other being eq, if you only have root do this

At the bottom right, click on Add New User, and fill in the information for user name and password, ingnore the rest. Once this is done click Apply changes

Now click on the eq user in the bottom left window. Then go to Schema Privilages. Click on the peq databse, then click the << buttone in the middle to assign all available privilages.


Once that is done, Open up the mysql command thing, and then type in the command angelox said earlier.

putting the password you gave eq in the Mysql Adminstation program a couple steps ago.

This will set up a accoutn name eq that has the same ability as the root account if you followed the guide from the wiki. Personaly, if you have issues using the root account, your still going to have issues with the eq account.

Ok I did what you said, but it didnt work, and said that eq@localhost didnt exist, so I clicked the eq user on the serveradministater UI thing, and it said eq@anyhost, so then I clicked add host changed the name to local host, it was then eq@localhost. I then typed in the code to change the password, it worked but it said 0 rows affected, like it changed nothing. But then I tried the start.bat, it did the same thing it always does, starts up real quick, world dissapears instantly and the other screen stays blank, so I went back to the log and it said -- ------------------------------
[05.03. - 21:48:34] Starting Log: logs/eqemu_debug_world_3872.log
[05.03. - 21:48:34] [WORLD__INIT] Loading server configuration..
[05.03. - 21:48:34] [WORLD__INIT] Log settings loaded from log.ini
[05.03. - 21:48:34] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[05.03. - 21:48:34] [WORLD__INIT] Connecting to MySQL...
[05.03. - 21:48:34] [WORLD__INIT_ERR] Cannot continue without a database connection.

so now the other problem is gone (I think), and were back to this one, The only thing I think could screw this up is a firewall or router blocking it ,and I turned my firewall off and unblocked 3306. And 5999 even though its not nessacary, so now the only thing I think could be the problem is my LoginServer.ini and my eqemu_config.xml . So I'm going to post what the have in them, see if I have anything wrong --
eqemu_config.xml

<?xml version="1.0">
<server>
<world>
<shortname>JGT</shortname>
<longname>JGTs Server</longname>

<!-- Only specify these two if you really think you need to. -->
<!--<address>192.168.1.105</address>-->
<!--<localaddress>127.0.0.1</localaddress>-->

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>3306</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>everquest</password>
<db>PEQ</db>
</database>
</server>

and
LoginServer.ini

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=127.0.0.1
loginserver2=newlogin1.eqemulator.net
loginport=3306
loginport2=3306
worldname=JGTs Server
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=3306

may be stupid on my part but you might try going under mysql and typing in CONNECT **the name of your database here**. sometimes when you restart mysql it won't restart with the DB connected