Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #31  
Old 11-20-2003, 12:33 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

ok found some potential probs

If you have not please recopy your ini's by hand, there were probs i ran into just using the cvs version.. ALSO please dont cut and paste from this site...

my loginserver.ini

Code:
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Raevenloft [LEGIT] (Beta)
worldaddress=(NAT correction with No-ip.org)
locked=false
[worldserver]
defaultstatus=
unavailzone=
[loginconfig]
servermode=standalone
serverport=5997
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
also make sure you read the NAT post on the tutorials. I was finally able to log in when i corrected how world, zone, login, and my ports were talking to each other...

http://www.everquestserver.com/forum...pic.php?t=4177

Kgaul
Reply With Quote
  #32  
Old 11-20-2003, 01:39 PM
Tinv
Fire Beetle
 
Join Date: Nov 2003
Posts: 18
Default



Outstanding Troubleshooting to all 3 of you!!!

There was a descrepency in file sizes from the MWblahblah050.sql i downloaded last night and the one i just downloaded tonight.
That was problem # 1 /cheer mattmeck

Problem #2 Arkaria was dead on. All the tutorials use one form of the GRANT PRIVILEGES line to open up mysqladmin to eqemu.
I forgot ,in my rush to start messing with filled worlds after seeing this thing actually worked, that i had used eq.* in the grant privileges line and not *.* . Which had i stopped and thought about it for a minute makes sense that when i ran the database with just db.sql sourced in itwould work because that database is called eq.sql . But when i created eqtest eqemu wasnt allowed in because i didnt re run my Grant permision line to include eq*.* or eqtest.* . I am edumacated now and look forward to my next bout of noobism

Thanks a ton for listening =)
Reply With Quote
  #33  
Old 11-20-2003, 02:34 PM
arkaria's Avatar
arkaria
Discordant
 
Join Date: Oct 2003
Location: Victoria, BC
Posts: 253
Default

Glad to help.

Have fun running your server
Reply With Quote
  #34  
Old 11-21-2003, 12:47 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default .......

ok i got the files an dat have played it fine but sometimes when i restart the emu and try login to char i get zone unavaible again.... not sure wats wrong but its ok sometimes if i restart eq but it happens alot dunno why any ideas?
Reply With Quote
  #35  
Old 11-21-2003, 01:03 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

Fresh, we need more info. Your own server or another server? mini or Login with Eqemu...


Kgaul
Reply With Quote
  #36  
Old 11-21-2003, 01:05 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default .......

eh im using minilogin for my own offline server just to mess around on....
Reply With Quote
  #37  
Old 11-21-2003, 01:06 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

ok friend, Please post your Ini's and what tutorial your using...


Kgaul
Reply With Quote
  #38  
Old 11-21-2003, 01:10 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default .......

using no tutorials aint that dumb.... anyways heres my inis


loginserver.ini
[LoginServer]
loginserver=localhost
loginport=5999
worldname=BAD_ASS_BOB
worldaddress=localhost
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

db.ini
[Database]
host=localhost
user=god
password=god
database=eq
compression=off


eh u want minilogin accounts ini too and boot5zones ?
Reply With Quote
  #39  
Old 11-21-2003, 01:16 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

ok some probs first off. Use a Tutorial

second when you started Mysql for the first time did you use God as the login and God as the password?

Third Pelase check the tutorials to see if 5999 is the port for minilogin. i'm not sure if its that or 5997


Kgaul
Reply With Quote
  #40  
Old 11-21-2003, 01:18 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default .......

lol iv been around long enough no tutorials and yes the port was 5997 i changed it because i was having errors and it seems to work on 5999..
Reply With Quote
  #41  
Old 11-21-2003, 01:19 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

ok friend my Aim is Powe8525 if your still having probs please msg me and we will work throu this...


Kgaul
Reply With Quote
  #42  
Old 11-21-2003, 01:20 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default .......

yeah the user and pw was same could it be virus or sommat ... doubt it could be but 1 min it works fine next time i try login "zone not available"
Reply With Quote
  #43  
Old 11-21-2003, 01:21 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

have you set static zones? can you log in at all?


Kgaul
Reply With Quote
  #44  
Old 11-21-2003, 01:25 PM
Freshmaster17uk
Sarnak
 
Join Date: Mar 2003
Location: London UK
Posts: 36
Default ......

yeah i can get in play the game ect but certain times like a day later i try to login again to play but get zone unavailable
Reply With Quote
  #45  
Old 11-21-2003, 01:30 PM
Kgaul
Hill Giant
 
Join Date: Apr 2003
Posts: 225
Default

ok here is my best advice. if you can get in, set up static zones in batzone... then use the zone boot up commands and the zonestatus commands to make sure that zone is up, also always log out in a static zone... that will make sure you can get in(barring any other probs)


Kgaul
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 04:41 AM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3