MySQL Went away...

Support forum for questions about compiling and running EQ2Emulator on Linux.

Moderator: Team Members

Post Reply
lazypower
Posts: 3
Joined: Tue Sep 02, 2008 7:33 am

MySQL Went away...

Post by lazypower » Wed Sep 03, 2008 1:23 pm

Fresh Ubuntu Server: Gutsy install
Fresh compile, no given errors or issues. However when I attempt to run the world, it inits proper, but cant find the MySQL host.
-- Snippit - world_db.ini
# READ README.TXT!
[Database]
host=localhost
user=eq2emu
password=password
database=eq2
-- snippit
chuck@Bogart:~/eq2server$ ps aux | grep mysqld
root 4190 0.0 0.1 1752 528 ? S Aug29 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 4230 0.1 7.5 128696 38428 ? Sl Aug29 7:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
MySQL is running, accepting incoming connections. I'm unaware of why Eq2Emu is not finding it.
Anybody have any ideas?

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Post by John Adams » Wed Sep 03, 2008 4:06 pm

You can run
$ mysql -u root -p
:password
> use eq2;
> show tables;
Do you see many tables listed? If not, try
> show databases;
Do you see your eq2 database? If not, try
> create database eq2;
And make sure your db user has ALL privileges, since it is going to be adding/altering tables.

lazypower
Posts: 3
Joined: Tue Sep 02, 2008 7:33 am

Post by lazypower » Wed Sep 03, 2008 5:19 pm

DB exists, permissions are set, nothing is getting updated. For whatever reason the server isnt connecting to the MySQL db host process :|
More Snippets ---
mysql> grant ALL on eq2 to eq2emu@localhost identified by 'some password';
Query OK, 0 rows affected (0.16 sec)
mysql> show databases;
| eq2 |
| mangos |
mysql> use eq2;
Database changed
mysql> show tables;
Empty set (0.01 sec)
./eq2world
DB Query Error #2006: MySQL server has gone away
Database Error: Lost connection, attempting to recover....

lazypower
Posts: 3
Joined: Tue Sep 02, 2008 7:33 am

Post by lazypower » Wed Sep 03, 2008 5:54 pm

The issue was due to a whitespace trailing my password entry in the file. Very odd... but I can see how that would have forked things up.. i suppose?...
Now that I've got it all ironed out, I have to wait until the 9'th to get the database :P *shrug* small price to pay.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests