errors on World and Zone5boot...

[Xalivor]

When i start up world i get this error.

LoginServer.ini read.
Failed to connect to database: Error: Unknown MySQL Server Host '192.168.0.x' (1
1001)
Loading items...DB Query Error
Error #2006: MySQL server has gone away
Error in PopulateZoneLists query 'SELECT MAX(id) FROM items' #2006: MySQL server
has gone away
done.
Loading guild ranks...DB Query Error
Error #2006: MySQL server has gone away
Error in GetGuildRank query 'SELECT id, eqid, name, leader, rank0title, rank1, r
ank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5
title from guilds' #2006: MySQL server has gone away
done.
World server listening on: 127.0.0.1:9000
Connected to LoginServer: eqlogin.eqemu.net:5999

When i open Boot5zone i get this on the regular ms window

E:>REM: ****Read this first!!!****

E:>
E:>REM: This file requires your real IP in the place of 127.0.0.1 when you are
connecting

E:>REM: To a EQEmu Loginserver.

E:>
E:>REM: When you are using minilogin, leave all IP entrys as 127.0.0.1 and if y
ou still get errors try

E:>REM: Using localhost as the IP instead of 127.0.0.1

E:>
E:>REM: zone9x.exe is for use with Windows 98 and ME only.

E:>REM: If you are running Windows NT/2000 or XP use ZoneNT.exe

E:>
E:>REM:--------------Start-----------------------

E:>
E:>


Then on the other 5 ms windows that open with it i get this

has gone away
DB Query Error
Error #2006: MySQL server has gone away
Error in LoadNPCTypes query 'SELECT MAX(id) FROM npc_types' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...DB Query Error
Error #2006: MySQL server has gone away
Error in GetGuildRank query 'SELECT id, eqid, name, leader, rank0title, rank1, r
ank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5
title from guilds' #2006: MySQL server has gone away
done.
Loading faction data...DB Query Error
Error #2006: MySQL server has gone away
Error in LoadFactionData 'SELECT MAX(id) FROM faction_list' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
InitWorldServer failed
Entering sleep mode

If anyone can help i would be very thankful

[Kyouchou]

I had similar problems... I discovered that you have to have the MySQL database running before you start the World.exe or Boot5Zones.bat progs...

Go to your MySQL folder and start MySQL.exe or MySQLAdmin.exe and leave it running... This should solve your problem... if not *shrugs* I don't know what to tell you.

The readme file needs to be updated to reflect this issue as well, instead of saying to close MySQL, it needs to say to leave it running.

Hope this helps,
Kyouchou

[Lurker_005]

If your getting database has gone away, your problem is:
a) mysql isn't running
b) wrong username/pass in db.ini
c) wrong DB in db.ini
d) no DB in mysql
e) wrong IP in db.ini...

Just looked at your post again and you didn't edit your db.ini Otherwise it wouldn't say Unknown MySQL Server Host '192.168.0.x'

[ibleet]

The readme states to close mysqladminAdmin which leaves the mysql server running in the background. This is not a misprint in the readme, it is correct.

[Kyouchou]

Also, verify that your LoginServer.ini file has the correct information...

If you are trying to connect to public servers on teh eqemu.org server system, then your LoginServer.ini file needs to say the following:

### --- This file tells world.exe what loginserver to connect to.
### --- do not add an account and password unless a EQEmu Dev member has created an account for you.
### --- adding an account and password only grants the server a green name and is not needed.

# READ README.TXT

[LoginServer]
loginserver=eqlogin.eqemu.org
worldname=<your server name here>
locked=false
account=
password=
worldaddress=<your IP address here>
loginport=5999

It also needs to have your account username and password in the appropriate fields according to what you set up at http://www.eqemu.org/login

If you are trying to connect via Minilogin.exe so you can play without being on the internet then it needs to say the following:

### --- This file tells world.exe what loginserver to connect to.
### --- do not add an account and password unless a EQEmu Dev member has created an account for you.
### --- adding an account and password only grants the server a green name and is not needed.

# READ README.TXT

[LoginServer]
loginserver=localhost
worldname=<your server name here>
locked=false
account=
password=
worldaddress=localhost
loginport=5999

I haven't been able to get minilogin.exe to work properly, but that doesn't mean you wont be able to if you want to try.

The reason I'm mentioning all of this is because of the message at the beginning of the information you provided...

"LoginServer.ini read.
Failed to connect to database: Error: Unknown MySQL Server Host '192.168.0.x' (11001)"

Hope this helps as well,
Kyouchou

[Kyouchou]

Lurker is right, you need to check your db.ini file too...

the "host" value should be "localhost"

Kyouchou

[Xalivor]

Well my Loginserver.ini reads this

[LoginServer]
loginserver=eqlogin.eqemu.net
worldname=Xalivor's World
locked=false
account=my minilogin username
password=my minilogin password
worldaddress=my IP
loginport=5999

My Db.ini file reads

[Database]
host=localhost
user=my minilogin username
password=my minilogin password
database=eq

hope that helps...i changed a couple things in them before i posted im gunna test it now

[Xalivor]

i go into mysql dos window and type use eq it says DB changed, i then type source db.sql and it tells me error blah blah duplicate item blah blah key 1 stuff.....I tested it after i changed some things in login server and stuff and i still got the same errors

[Shawn319]

[LoginServer]
loginserver=eqlogin.eqemu.net
worldname=Xalivor's World
locked=false
account=my minilogin username
password=my minilogin password
worldaddress=my IP
loginport=5999


nonononono


leave account and password BLANK. the the comments in the file and you will see why.

[Shawn319]

Failed to connect to database: Error: Unknown MySQL Server Host '192.168.0.x' (1
1001)


This also means your db.ini had host=192.168.0.x or your trying to use a network.

Only use localhost

[Xalivor]

Ok after reading this i changed my loginserver.ini thats all i understood to do. So now my Boot5zones reads this

has gone away
DB Query Error
Error #2006: MySQL server has gone away
Error in LoadNPCTypes query 'SELECT MAX(id) FROM npc_types' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...DB Query Error
Error #2006: MySQL server has gone away
Error in GetGuildRank query 'SELECT id, eqid, name, leader, rank0title, rank1, r
ank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5
title from guilds' #2006: MySQL server has gone away
done.
Loading faction data...DB Query Error
Error #2006: MySQL server has gone away
Error in LoadFactionData 'SELECT MAX(id) FROM faction_list' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
InitWorldServer failed
Entering sleep mode

And my World.exe reads this.

.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1932
Removing console from ip: 127.0.0.1 port:1932
New TCP connection: 127.0.0.1:1940
DB Query Error
Error #2006: MySQL server has gone away
Error in CheckZoneserverAuth query 'SELECT * FROM zoneserver_auth WHERE '127.0.0
.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1940
Removing console from ip: 127.0.0.1 port:1940
New TCP connection: 127.0.0.1:1941
DB Query Error
Error #2006: MySQL server has gone away
Error in CheckZoneserverAuth query 'SELECT * FROM zoneserver_auth WHERE '127.0.0
.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1941
Removing console from ip: 127.0.0.1 port:1941
New TCP connection: 127.0.0.1:1943
DB Query Error
Error #2006: MySQL server has gone away
Error in CheckZoneserverAuth query 'SELECT * FROM zoneserver_auth WHERE '127.0.0
.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1943
Removing console from ip: 127.0.0.1 port:1943

I think they have some what changed.

[ibleet]

Open the mysql server. It appears that you are trying to run without a database.

[Xalivor]

how ccan i be running it without a DB? I went to the MS Dos window of mysql and typed use eq which is the name of DB and and typed source db.sql but i kept getting 2006 errors about duplicate items. And if i am runing it without a DB how can i fix it

[Xalivor]

well if this is what you mean by not having a DB please tell me how to fix it.

http://www.strike9.com/eq/file.aspx/path=/Xalivor_00/fullsize%5cHill/111111.jpg

[Kyouchou]

The readme states to close mysqladminAdmin which leaves the mysql server running in the background. This is not a misprint in the readme, it is correct.


The readme file states the following (cut/pasted directly from readme.txt):

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

"Part 3: Setting up mySQL Database.


1) Download and install mySQL from http://www.mysql.com/downloads/mysql-3.23.html

2) Copy db.sql from your EQEmu folder to the mySQL bin directory (default is C:\mysql\bin).

3) In your mySQL bin directory, run Winmysqladmin.exe. It should ask you to enter a username and password. Choose a username and password that you can remember because you will need it in Part 4. Do not give the password out to anyone for any reason because with this, anyone can log into your mySQL database and change your data.

**NOTE: If it doesnt not ask you to enter a username/password or you wish to change it, delete the file c:\windows\my.ini and re-run Winmysqladmin.exe.


4) After you have chosen a username and password go to the Database tab in WinmySQLAdmin and right click the area for Databases and click Create Database.

5) Type in "eq" as the database name (without the quotes) and click Create database.

6) Close winmysqladmin.

7) Run mysql.exe in your mySQL/bin directory.

8) Type "use eq" without the quotes and hit enter. It should say Database changed.

9) Type "source db.sql" without the quotes and hit enter. A bunch of lines should pass by (that is normal). If you get an error at this point then you didn

[Shawn319]

Most people can close Winmysqladmin completely and still be able to connect (it keeps mysql-nt.exe in Windows Processes).

Re-run winmysqladmin.exe, minimize it then try again.. i will fix the readme.

[Shawn319]

Also, there's a post about 2006 error on the top of this forum.

[ibleet]

Hmmmm....why are we constantly reprinting info from the readme.txt file in these forums? I'm not gonna answer that question because the majority of us already know. /bonk anyone who doesn't use the readme. That is your first line of tech support.

_____________________
Ibleet

[ibleet]

Ok my bad...you are not trying to run without a database, rather the program is having trouble finding a database on your local machine.

[Xalivor]

Everytime i go to the mysql and type use eq it says DB changed, but when i type source db.sql it says this

ERROR 1062: Duplicate entry '2136' for key 1
ERROR 1062: Duplicate entry '2137' for key 1
ERROR 1062: Duplicate entry '2138' for key 1
ERROR 1062: Duplicate entry '2139' for key 1
ERROR 1062: Duplicate entry '2140' for key 1
ERROR 1062: Duplicate entry '2141' for key 1
ERROR 1062: Duplicate entry '2142' for key 1
ERROR 1062: Duplicate entry '2143' for key 1
ERROR 1062: Duplicate entry '2144' for key 1
ERROR 1062: Duplicate entry '2145' for key 1
ERROR 1062: Duplicate entry '2146' for key 1
ERROR 1062: Duplicate entry '2147' for key 1
ERROR 1062: Duplicate entry '2148' for key 1
ERROR 1062: Duplicate entry '2151' for key 1
ERROR 1062: Duplicate entry '2152' for key 1
ERROR 1062: Duplicate entry '2154' for key 1
ERROR 1062: Duplicate entry '2156' for key 1
ERROR 1062: Duplicate entry '2158' for key 1
ERROR 1062: Duplicate entry '2160' for key 1
ERROR 1062: Duplicate entry '2162' for key 1
ERROR 1062: Duplicate entry '2164' for key 1
ERROR 1062: Duplicate entry '2165' for key 1
ERROR 1062: Duplicate entry '2166' for key 1
ERROR 1062: Duplicate entry '2171' for key 1
E
and so on

[Trumpcard]

You already have the database loaded, of course its going to spit out a million duplicate items when you source db.sql.

drop database eq;
create database eq;
source db.sql;

[Xalivor]

thanks trump that worked. But i am still getting errors about 2006. i read the post about it and did this.

mysql> GRANT ALL PRIVILEGES ON eq.* TO Ashy@localhost INDENTIFIED BY <mypass> WIT
H GRAN OPTION

but it didnt do anything that i noticed.

When i open World.exe it still says the same thing listed in previous posts.

[Xalivor]

also in my winmysqladim under process it still doesnt list a DB

[Meekrat]

[Database]
host=localhost
user=my minilogin username
password=my minilogin password
database=eq

You are not putting minilogon user/pass are you? You are putting in the user/pass that you made for MySQL?

Thought i'd ask. Your post was not clear.

[Xalivor]

yeah i think i am. i forgot my MYSQL password/username. But everytime i go to the MS window to fix it nohing happens

[ibleet]

Open up winmysqladmin, your username and password are listed there under the my.ini Setup tab.

[Xalivor]

ok i did and it seems as though its the same as mini login

[ibleet]

Actually minilogin is eqemu eqemu, but any username and pw provided will work.

[Xalivor]

im still getting the same errors

Grr all i wanna do is make items

[Shawn319]

DB.ini HAS to have your mySQL login and password. if you forgot it then delete c:\windows\my.ini then re-run Winmysqladmin.exe and make a new one.

[Xalivor]

ok Shawn i did that and now i get this look at the pic.......