MySQL help ... and a few questions.
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. |
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 |
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.
|
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.... |
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. |
Quote:
*spits on extra characters* :) |
:D
Glad I could help. |
All times are GMT -4. The time now is 01:56 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.