Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2004, 10:33 AM
ryder911
Hill Giant
 
Join Date: Jun 2002
Posts: 212
Default Error !

Ok I get a access denied to mysql database on world.exe when I run it. Yes I tried doing what the post said.

Here is all my information

Quote:
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport2=5997
loginport3=5997
worldname=Shadowed Realm(Legit-Custom)
worldaddress=138.89.74.XXX
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=192.168.1.XXX
Quote:
# READ README.TXT!

[Database]
host=192.168.1.xxx
user=ryder911
password=mysqlusername
database=eq
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

Quote:
REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . 138.89.xx.xxx 7995 192.168.1.xxx
start zone . 138.89.xx.xxx 7996 192.168.1.xxx
start zone . 138.89.xx.xxx 7997 192.168.1.xxx
start zone . 138.89.xx.xxx 7998 192.168.1.xxx
start zone . 138.89.xx.xxx 7999 192.168.1.xxx
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

[quote]Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[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
[Status] ./LoginServer.ini read.
[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
Warning: Pants may change during online play.
TCP listening on: 138.89.74.210 :9000
World server listening on: 138.89.74.210 :9000
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1

Hit any key to exit
Quote:


And I granted access to ryder911, I tried 2 times. I can access DB with eqadmin and such, but the world.exe wont connect to it. Any help is apprecaited. And I am running DB on the same computer as this one.
__________________
Chris---
Reply With Quote
  #2  
Old 05-03-2004, 11:27 AM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default

Your host should be "localhost" instead of your IP address.
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #3  
Old 05-03-2004, 11:28 AM
ryder911
Hill Giant
 
Join Date: Jun 2002
Posts: 212
Default

I did it in the db.ini and still getting the same problem...=(
__________________
Chris---
Reply With Quote
  #4  
Old 05-03-2004, 11:40 AM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default

Try running this query:

Quote:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER ON whatever_your_EQEMu_DB_is.* TO "whatever_your_username_is"@"localhost" IDENTIFIED BY "whatever_your_password_is" WITH GRANT OPTION;
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #5  
Old 05-03-2004, 11:43 AM
ryder911
Hill Giant
 
Join Date: Jun 2002
Posts: 212
Default

K, I will try that, and can anyone tell me what the bind address in you my.ini for Mysql is supose to be. I changed it i think, I dont remember, not sure if that might be causing it
__________________
Chris---
Reply With Quote
  #6  
Old 05-03-2004, 11:47 AM
ryder911
Hill Giant
 
Join Date: Jun 2002
Posts: 212
Default

Tried that, It didn't work!=( It is weird though I am able to open the DB with Mysql Front, but it wont run on the world.exe
__________________
Chris---
Reply With Quote
  #7  
Old 05-03-2004, 12:16 PM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default

When using MySQL-Front, do you log in as the root user or as your equser?
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #8  
Old 05-03-2004, 12:25 PM
ryder911
Hill Giant
 
Join Date: Jun 2002
Posts: 212
Default

What do you mean? I log in with mysql username and pword...
__________________
Chris---
Reply With Quote
  #9  
Old 05-03-2004, 04:34 PM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default

Right, but is that username "root" or is it the one you created for your server? My guess is it's "root."

It definately looks like it's a simple permissions error. I get the same thing when I try to manually create users in MySQL. I've never been able to get it to work without using PHPMyAdmin (which, unless you have a web server with PHP installed on that same box, you can't do).

Tell ya what... Just for giggles try this. It's basically the same thing I told you to do earlier with one extra step at the beginning. . .

Quote:
USE mysql
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER ON whatever_your_EQEMu_DB_is.* TO "whatever_your_username_is"@"localhost" IDENTIFIED BY "whatever_your_password_is" WITH GRANT OPTION;
Man, if this works, I'm gonna be sooo pissed. . .
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:37 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3