What i get....

Deathmore222 · #1 11-16-2002, 05:22 PM

ok what i get is Failed to connect to database: Error: Access denied for user: 'jordanpappas@loca
lhost' (Using password: YES)
EQEMu 0.3.12 - Wiederbelebung
Error in GetVariable query 'SELECT value FROM variables WHERE varname like 'hold
zones'' #2006: MySQL server has gone away
Loading zone names & items...
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
EMuShareMem.dll loaded.
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #2006: MySQL
server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
...done.
[WorldServer] block not found in LoginServer.ini.
Loading guild ranks...Error in LoadGuilds query 'SELECT id, eqid, name, leader,
rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank
4title, rank5, rank5title from guilds' #2006: MySQL server has gone away
done.
World server listening on: port 9000

whats the problem!!!!!

MrBlizzard89 · #2 11-16-2002, 05:41 PM

thats what i get too, man i wanna host me a server, can someone please help

tamarae · #3 11-16-2002, 05:50 PM

post your loginserver.ini file and db.ini file if you will plz, looks like you've got some errors in them.

Trumpcard · #4 11-16-2002, 10:21 PM

Post your ini files and verify you correctky ran the step that says..

execute 'grant all privileges to username@localhost identified by 'password' with grant option;' in mysql

your problem is a permissions problem with mysql. They hide that fact in the error message that says 'Falied to connect to database: Error: Access denied for user....'

Deathmore222 · #5 11-17-2002, 05:34 AM

ok im typing the grant all thing wrong.....cause everytime i try to type it, i get a syntax error near blah blah blah. Could someone type out an example? like put <username>@localhost with everything i need to fill in....thanks

MrBlizzard89 · #6 11-17-2002, 06:05 AM

Ok, here they are, after I post these I'm going to try the grant all privilages...

db.ini
*******************************

[Database]
host=localhost
user=
password=
database=eq

******************************

and LoginServer.ini
******************************

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=JACK BLACK TEST
locked=false
account=
password=
worldaddress=
[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
********************************

and that's them, im goin to try the grant all privilages and be back

MrBlizzard89 · #7 11-17-2002, 06:13 AM

i keep getting a syntax error near the word "to" whenever i try to use mysql...is there a word im supposed to be using instead of to?

Xarslik · #8 11-18-2002, 05:21 PM

Try:

Code:

GRANT ALL ON *.* TO yourusername@IP IDENTIFIED BY 'yourpassword';

For example, let's say your username is equser, your IP is 192.168.0.5, and your password is trickey. You'd enter:

Code:

GRANT ALL ON *.* TO equser@192.168.0.5 IDENTIFIED BY 'trickey';

MrBlizzard89 · #9 11-19-2002, 03:32 PM

it worked in MySQL but didnt do anything for world.exe, still getting that error access denied

**********8
Error: Access denied for user: 'jordanpappas@loca
lhost' (Using password: YES)
EQEMu 0.3.12 - Wiederbelebung
Error in GetVariable query 'SELECT value FROM variables WHERE varname like 'hold
zones'' #2006: MySQL server has gone away
Loading zone names & items...
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
EMuShareMem.dll loaded.
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #2006: MySQL
server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
...done.
[WorldServer] block not found in LoginServer.ini.
Loading guild ranks...Error in LoadGuilds query 'SELECT id, eqid, name, leader,
rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank
4title, rank5, rank5title from guilds' #2006: MySQL server has gone away
done.
World server listening on: port 9000
***********

morpheus014 · #10 11-19-2002, 03:54 PM

http://forums.eqemu.net/showthread.p...;threadid=2395

see that thread for some more insight on this issue, also, make sure you put in the right user and host(your ip, probably localhost), and that you have the right pass(must match your sql info in db.ini), also, insure that you have in fact sourced the DB.sql file into your eq database in mysql.

tamarae · #11 11-19-2002, 04:29 PM

Make sure you fill in the blanks in the 2 .ini files that you have left.

The username and pass for db.ini
worldaddress in loginserver.ini

I dont expect you to post that info here for all the world to see, just make sure that they're filled in properly.