What i get....
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!!!!! |
thats what i get too, man i wanna host me a server, can someone please help :)
|
post your loginserver.ini file and db.ini file if you will plz, looks like you've got some errors in them.
|
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....' |
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
|
Login Server & db.ini
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 |
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?
|
Try:
Code:
GRANT ALL ON *.* TO yourusername@IP IDENTIFIED BY 'yourpassword'; Code:
GRANT ALL ON *.* TO equser@192.168.0.5 IDENTIFIED BY 'trickey'; |
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 *********** |
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. |
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. |
All times are GMT -4. The time now is 08:14 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.