MySQL help ... and a few questions.

[kai_shadowbane]

ok, when I just use the base files I get this:


Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[LoginServer] block not found in 'LoginServer.ini'.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Abort/retry/cancel?
TCP listening on: port 9000
World server listening on: port 9000
===============================
Runtime errors:

MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id=3

Hit any key to exit


but when I try to edit the ini files in notepad or wordpad, it doesn't recognize the blocks (namely the [Database] block from the db.ini)
A side note, I have tried the fix mentioned, and it didn't seem to help at all
so:
1) I would like to know what you guys use to edit the ini files, since in mine to even have them recognizable, they have to be all on one line

and 2) how can I fix the above errors, since I have redid all the file permissions on everything, this is apparently my only block is the sql server killing the connections when I try to get large databases. I read something in the MySQL site about increasing the buffer (the default is only like 1MB) but I can't seem to get the changes to stick.

[krich]

This is likely a problem with your db.ini file. Check to make sure you don't have spaces at the end of any of the lines in your db.ini.

You can check that your MySQL is working by typing the following from the command/shell prompt:

for windows:
cd <mysql install directory>/bin
mysql -u <userid> -p <dbname>
enter password when requested

for linux:
mysql -u <userid> -p <dbname>
enter password when requested

Where:
<userid> = userid in your db.ini file
<password> = password in your db.ini file
<dbname> = dbname in your db.ini file

If you get into the mysql prompt, the problem likely lies within your db.ini file.

regards,

krich

[kai_shadowbane]

checked it again, I even went to using the cmd prompt edit command in winxp so I could even save without the files messing up. still no joy, and there is no extra spaces, note that it doesn't seem to like the compression setting either.

[Purcevil]

I was having the same problem. There were odd characters in the .ini files as distributed (don't know why <shrug>).

Try typing them in by hand in a blank file (yes its a pain) and then save those with the proper name....

Now if I could just get the zone servers to not lock at EMuShareMem loaded....

[tcsmyworld]

Zone server isn't locked up , wait a few mins and it will finish.

Make sure compression is set to off , sounds like it has a 0 in it instead of an o.

[kai_shadowbane]

Originally Posted by Purcevil

I was having the same problem. There were odd characters in the .ini files as distributed (don't know why <shrug>).

Try typing them in by hand in a blank file (yes its a pain) and then save those with the proper name....

Now if I could just get the zone servers to not lock at EMuShareMem loaded....

Thanks, that did it
*spits on extra characters*

[Purcevil]

Glad I could help.