Trouble starting a new server

[strife01]

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.

[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!

[Damilis]

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

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.

[strife01]

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.

[strife01]

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?

[strife01]

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?

[Damilis]

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:

###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

<?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!

[strife01]

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!