Recurring Problem

[rainwalkerx]

Thanks Kobaz, gaeorn, and pfyon. Still getting the same error.

I tried the following two ways to run it as root:

main@userv:~/eqserver$ sudo ./start
main@userv:~/eqserver$ su root
main@userv:~/eqserver$ ./start

Also, a couple times throughout the installation, when permissions seemed incorrect, I ran this:

main@userv:~/eqserver$ sudo chown -R main:root /home/main/eqserver
main@userv:~/eqserver$ sudo chmod -R 775 /home/main/eqserver

...per one of the guide's instructions. Shouldn't that have made sure that my user had correct permissions? After this, I also selected all of the items in the folder, right-clicked, and check that executable option.

I also tried your suggestion, pfyon, in both the main eqserver directory and eqserver/world directory.

That's why all of this leads me to suspect that it's something to do with MySQL. I might receive some kind of permission denied error if "db.ini" file had incorrect settings, right? But if that were true, I should be able to just put my root account settings in and it ought to work, right? That hasn't worked, either. So I think that that file is ok but I'm wondering if there's a problem with my MySQL user or database. Or maybe I just have no idea what I'm talking about

Anyway, would it be useful for me to post my entire setup procedure? I can download/use whatever files you all recommend or I can just tell you which ones I've been using.

Thanks again,
rainwalker

P.S. - Kobaz - how do I check the targets of the sym links?

[rainwalkerx]

Ok, maybe some progress. I tried running an ancient "bootserver" file leftover from a previous attempt and this time a world.log file was generated. I check it out and this is what it said:

[Debug] Starting Log: logs/eqemu_debug_world.log
[Debug] [COMMON__THREADS] Starting TCPServerLoop with thread ID -1215403120
[Debug] [COMMON__THREADS] Starting TCPServerLoop with thread ID -1223795824
[Debug] [RULES__CHANGE] Resetting running rules to default values
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Error] Starting Log: logs/eqemu_error_world.log
[Error] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)
[Debug] [WORLD__INIT_ERR] Cannot continue without a database connection.
[Debug] [COMMON__THREADS] Ending TCPServerLoop with thread ID -1223795824
[Debug] [COMMON__THREADS] Ending TCPServerLoop with thread ID -1215403120

The interesting part is that I don't have a user named 'eq' in MySQL. Perhaps I created one a long time ago but not via Webmin nor MySQL do I see a user called 'eq' anywhere. Is there (hopefully) a really easy way to fix this?

[trevius]

[Error] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

That means that your config file for the server has eq set as the username to get into the database, which is the default username in that file. This probably means that you did not edit your config file, which you definitely need to do before the server will work.

[rainwalkerx]

Thanks trevius. Well, I think I edited the eqemu_config.xml files correctly. When I run that old bootserver file, though, it still shows me as trying to connect with user 'eq'. Which other files was I supposed to edit?

[gaeorn]

Try logging in to the mysql server with the mysql CLI using the same username and password you have in the eqemu_config.xml file.

This should prompt you for the password:

mysql -u <your mysql username here> -p

If that works, then you know you have the correct username and password. However, there is still a possibility that your config file has an error. So I would suggest you post your config file here.

NOTE: Make sure to remove/replace the username and password before posting the config. We don't need to know that information

[rainwalkerx]

gaeorn - I am positively able to login to MySQL with the code you supplied.

Here's my full xml config file:

<?xml version="1.0">
<server>
	<world>
		<shortname>RegnumImbrium</shortname>
		<longname>Regnum Imbrium</longname>

		<!-- Only specify these two if you really think you need to.  (read: You dont) -->
		<!-- <address></address> -->
		<!-- <localaddress></localaddress> -->

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>www.regnumimbrium.net</host>
			<port>5999</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="localhost" port="9000" telnet="disable"/>

		<!-- 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.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>channels.eqemulator.net</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>channels.eqemulator.net</host>
		<port>7779</port>
	</mailserver>

	<zones>
		<defaultstatus>20</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>localhost</host>
		<port>3306</port>
		<username>myusername</username>
		<password>mypassword</password>
		<db>eqemu</db>
	</database>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

Like I said, what I find really strange is that the one log file seems to indicate that somewhere, something is trying to login with 'eq' when clearly I've changed it in the xml file. Maybe it's time to try the stock eqemulator.net emulator again.

[trevius]

Originally Posted by rainwalkerx

Thanks trevius. Well, I think I edited the eqemu_config.xml files correctly. When I run that old bootserver file, though, it still shows me as trying to connect with user 'eq'. Which other files was I supposed to edit?

Your problem is probably due to whatever old bootserver you are running, then. You should not need to use anything like that to get a server running. It comes with everything you need other than the start.bat and shortcuts.

[rainwalkerx]

No, I tried that out of desperation. I normally and continue to use start, stop, and persist_world (taken from the Debian Linux guide).

Just for reference, here's the steps I'm trying tonight:

1. Extract EQEmu server 554 (from angelox) to directory.
2. Open terminal, type "su - root" to switch to root user.
3. "apt-get update"
4. "apt-get install mysql-server"
5. "apt-get install libmysqlclient15-dev"
6. "apt-get install gcc g++ make libio-stringy-perl libperl-dev unzip"
7. "chown -R root:root /my_server_directory"
8. "chmod -R 775 /my_server_directory"
9. Open my_server_directory/utils/Makefile and change gmake to make. Also open my_server_directory/world/client.cpp and, at the top, add "#include <limits.h>". While still in terminal, in my_server_directory, type "make".
10. 	"mysql -p"
	"USE mysql;"
	" SELECT Host,User FROM user;"
	"insert into user set Host='localhost', User='equser', Password=password('eqpassword');"
	"CREATE DATABASE eqemu;"
	"GRANT ALL PRIVILEGES ON eqemu TO equser;"
	"FLUSH PRIVILEGES;"
	"exit"
11. Extract ax_classic SQL files (core and version) to my_server_directory, as well as plugins and quests.
12. Open terminal, type "su - root" to switch to root user.
13. 	"mysql -p -u equser eqemu"
	"source ax_classic_3.10o_R42.sql"
	"source version.sql"
14. 
	"ln -s /my_server_directory/utils/defaults/* ."
	"ln -s /my_server_directory/utils/patch_* ."
	"ln -s /my_server_directory/utils/cleanipc"
	"ln -s /my_server_directory/world/world"
	"ln -s /my_server_directory/zone/zone"
	"ln -s /my_server_directory/EMuShareMem/libEMuShareMem.so"
	"ln -s /my_server_directory/eqlaunch/eqlaunch"
15. Copy persist_world, stop, and start files. In terminal, type ./start to start world.

It's basically the same thing that I've been doing, except that I kept out a lot of different directories from more "modern" source codes, such as the new public login server and bot files. I doubt it'll work but I'll repost in the morning. If any extra ideas were waiting for me, it'd be awesome

[AndMetal]

Paste the results from the following command:

ls -la /home/main/eqserver

Also, paste the ./start, ./stop, and ./persist_world scripts as you have them saved.