Error 2 at SQL CMD?

[Havocide]

Thus far the guide has worked fine. But when i get to the "Project EQ" section of the guide and get into the sql through dos cmd I am able to create database but am getting an error at source load_system.sql & source load_player.sql . Can anyone enlighten me as to what possible might be wrong?

[Zandig]

You are using the wrong syntax.

Here is the proper syntax:

\. load_system.sql

Also make sure all of the files are in your mysql/bin directory.

[Sakrateri]

Or you could

source load_system.sql;

[Attere]

Okay, so .. I'm in the midst of attempting to set up my own server. I've read over this, and tried each of the ways that have been posted to load the .sql files.

I get the same error, no matter the syntax. Also, the .sql files are in the bin folder, 'cept it seems to change absolutely nothing.

Is there any other issue that it could be..?

[techguy84]

Navigate to the directory you downloaded the database to, like C:\peqdb first. Do this by running your command prompt and typing cd\peqdb or whatever directory you put it in.

Another method would be to copy the two load files over to your C:\Program Files\Mysql\bin directory and then run the MySQL CLI from your start menu and do exactly what you are already doing.

Detailed instructions to do the first method are located in my PDF guide so you have some screen shots to go along with.

\. and source are the same thing, so either will work.

[Havocide]

Well it turns out that it was a directory issue that I corrected and it compiled ok. I am on the finalizing stages of the guide where it says " You will see a 2 windows come up, one will say

Wait for World to Finish LoadingPress Enter to Continue


And the other will say several lines of code, give it a second and it should stop, with the final two lines reading

[DEBUG] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[DEBUG] [WORLD__LS] Loginserver provided YOUREXTERNALIP as world address


It opens up the first window and closes too fast for me to read and leaves up the "Wait for World to Finish LoadingPress Enter to Continue" . I click continue and it opens up the 3rd bow which displays nothing at all no matter how long i wait. Not sure where to start looking for the problem other than retracing steps.

[Derision]

Originally Posted by Havocide

It opens up the first window and closes too fast for me to read

This sounds like world.exe has a problem. What I would do would be open up a command prompt/ DOS window, then change directory to where you have world.exe installed and run it from there, e.g.

C:> cd \EQEmu (assuming this is where you have world.exe)
C:\EQEMU> world

This should display any error messages form World without closing the window. Then copy/paste the output here to allow further diagnosis.

[Havocide]

C:> cd \EQEmu (assuming this is where you have world.exe)
C:\EQEMU> world


This is what comes up.

[techguy84]

Did you set up a account with the name "eq" in mysql. I normally just use the root account at first until I can get things running right, then I vary with other features and settings. Try your root acount and see how it goes.

[Havocide]

Originally Posted by techguy84

Did you set up a account with the name "eq" in mysql. I normally just use the root account at first until I can get things running right, then I vary with other features and settings. Try your root acount and see how it goes.

Used "root" on both as a basic setup.

[techguy84]

Originally Posted by Havocide

Used "root" on both as a basic setup.

Well, your world window says that your using "eq" as the database username. Check your eqemu_config.xml file under the Database section and change eq to root.

[Havocide]

Originally Posted by techguy84

Well, your world window says that your using "eq" as the database username. Check your eqemu_config.xml file under the Database section and change eq to root.

Ya I seen that, thats very odd. here is my config.xml



does this look correct ?

[Havocide]

Actually that picture posted above is wrong, this is what it actually reads.

[techguy84]

Are you editing the right config file. Make sure its eqemu_config.xml and not the one that says full on the end of it.

Bout the only thing I can think of if your config file is right. World is saying its using "eq" as a account, soooooo.... I really dont quite know.

[Havocide]

Well like I said sql username and password are both set to "root" yet somehow its saying in the dos box its "eq" . I modified the correct xml file and still getting same db load error. So this is the end of the line for me. Thank you to all that helped and i made it to the end of the tunnel with the guide but just couldnt get through the door. Best of luck and thanks for the help.