EQEmulator Forums - Trouble starting a new server

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Trouble starting a new server (https://www.eqemulator.org/forums/showthread.php?t=21683)

Trouble starting a new server

Hey all.

I'm having trouble starting a server on one of my computers. On the server I'm getting this error when i start the server from the EQEmu shortcut that was placed on my desktop.

Code:

[10.11. - 15:32:43] Starting Log: logs/eqemu_debug_1508.log

[10.11. - 15:32:43] [LAUNCHER__INIT] Loading server configuration..

[10.11. - 15:32:44] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061

[10.11. - 15:32:44] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.

[10.11. - 15:32:44] [LAUNCHER__INIT] Starting main loop...

I followe the 7.0 setup guide fully, I hope heh, but I'm not ruling out a mistake. I'm not using minilogon, I instaled MySQLCC, ran the 3 perl commands, im not sure if the mysql commands went correctly because when i typed in the string in run a cmd window only popped up briefly. if there is a log, i will try to find it and post it to assist any help efforts. I do have a full unpatchec copy of titanium installed on this machine as well. Any help would be amazing as my brain is fried trying to fix this. I tried searching the wiki for the error code or any related text, alas i found nothing. :[
Thank you all.

EDIT I searched the forums and realized this is a common MYSQL issue. I will work on fixing this now using previous posts. Sorry!

Quote:

Originally Posted by strife01

I followe the 7.0 setup guide fully, I hope heh, but I'm not ruling out a mistake.

Good call since its not working :)

Quote:

EDIT I searched the forums and realized this is a common MYSQL issue. I will work on fixing this now using previous posts. Sorry!

If you still cant get it to work, then post your config files(no passwords, etc) and I will help ya.

Heh, thanks for the offer. I ended up reformatting and reinstalling windows because i wanted to start fresh, i had a number of previous server installs and mysql installations on the computer, plus i was getting a few issues. Hopefully a clean and solid fresh install will do the trick. If I get the same problem, ill post here about it.

One question about the setup process, when executing the commands for mysql,
"Now it's time to finish up the installation. You just have to run a few sql commands and you will be ready to roll. If you used the PEQ databases, Click on "Start" then "Run" and type in "C:\mysql\bin\mysql -u root peq". Now type in " GRANT ALL PRIVILEGES ON peq.* TO eq@localhost IDENTIFIED BY 'eq' WITH GRANT OPTION; " If you used cavedude's database, replace "peq" with "eq"."

Is this a two step process? Or type in all of it and remove the Now type in?

Ok, im sure this will be my last question here. I figured out the MYSQL and im fairly sure my server is setup correctly. Now I want to host it on the eqemulator login server. Ive registered an account and can see it from the client computer i setup correctly. However I tried to password it and now It says its locked. How do I go about entering a username/pass to get on to my server. Secondly, How does it even know where or what IP my server is at? Is there a settings file i can manipulate?

Quote:

Originally Posted by strife01

"Start" then "Run" and type in "C:\mysql\bin\mysql -u root peq". Now type in " GRANT ALL PRIVILEGES ON peq.* TO eq@localhost IDENTIFIED BY 'eq' WITH GRANT OPTION; " If you used cavedude's database, replace "peq" with "eq"."

Okay, here's the breakdown of what this step accomplishes. (If I say things you already know or 'talk down' to ya, its only because I don't know your level of expertise, so don't take any of it personally)

Windows Start Menu -> Run
Type in "C:\mysql\bin\mysql -u root peq".
Explanation:
"C:\mysql\bin\mysql" is the path to the mysql terminal interface
"-u" command line argument fed to the mysql terminal interface indicating you want to specify a user
"root" the user mention above
"peq" the specific database you want to use when the mysql terminal interface opens. (optional. If omitted, then your first mysql> prompt command will be "use peq;")

Your DOS prompt should be replaced with the mysql> prompt.
At the mysql> prompt, type the following command:

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

Explanation:
"GRANT ALL PRIVILEGES ON " Grants all read/write privileges to the following database.
"peq.*" in this example, 'peq' is the database and '*' is a wildcard for specifying ALL tables.
"TO eq@localhost" in this example, 'eq' is the username and 'localhost' is the machine that 'eq' is allowed to access from.
"IDENTIFIED BY 'eq' " in this example 'eq' is the password required for 'eq@localhost' to connect
"WITH GRANT OPTION" gives the account 'eq@localhost' the ability to change other account permissions.

My notes:
-using the default username and password that comes with the installer, in my opinion, is a huge security risk... use your own.
-you need to be careful with the 'eq@localhost' mentioned above. User 'eq' will only have permissions to access the database if you are using localhost (or 127.0.0.1) in your EQEmu settings (loginserver.ini & eqemu_config.xml). If you change your settings (like I had to) to use the server machine's real IP instead of localhost (or 127.0.0.1) then you might need to add another permissions entry to mysql that reads like so:

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

Next step is an explanation of the config files:

loginserver.ini:

Code:

###Your current configuration is as follows:

loginserver.ini:

[LoginServer]

loginserver=192.168.1.2 (This is the IP of the login server that you want your world.exe to connect to.)

loginport=5999(This is the port that you want your world.exe to connect on.)

worldname=ShadowsOfNorrath

worldaddress=192.168.1.2(This is the IP of your world.exe that is given to the loginserver so it knows where to send clients to.)

locked=false

account=

password=

[WorldServer]

Defaultstatus=

Unavailzone=

[ChatChannelServer]

worldshortname=

chataddress=

chatport=

[LoginConfig]

ServerMode=Minilogin

ServerPort=5999

Code:

<?xml version="1.0">

<server>

         <world>

                 <shortname>SON</shortname>

                 <longname>ShadowsOfNorrath</longname>

                 <address>192.168.1.2</address>(This is the IP of your world.exe that is given to the loginserver so it knows where to send clients to.)

locked=false

                 <localaddress>127.0.0.1</localaddress>(This is the IP that the various eqemu executables will use for any 'local' calls)

locked=false





<!-- Loginserver information. -->

                 <loginserver>

                         <host>192.168.1.2</host> (This is the IP of the login server that you want your world.exe to connect to.)

                         <port>5999</port>(This is the port that you want your world.exe to connect on.)

                         <account></account>

                         <password></password>

                 </loginserver>

         </world>

 

         <!-- Database configuration, replaces db.ini. -->

         <database>

                 <host>192.168.1.2</host>

                 <port>3306</port>

                 <username>YOURMOTHERS</username>

                 <password>PASSWORD</password>

                 <db>eq</db>

         </database>

</server>

Hope that helps you out some as to where to put your numbers :) Additionally, this knowledge is all from observed behavior of my server, so if a dev has a better/more concise explanation, please feel free to correct me!

Oh man, thats perfect, I'll DEFINITELY check that out when I get back from work. Thank you so much. I'm pretty sure I set up the MySQL correctly this time, but now I know how to change it from the defaults and get everything to match up correctly! Thank you!