Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Tutorials/Howto's

Archive::Tutorials/Howto's Archive area for Tutorials/Howto's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #61  
Old 06-25-2004, 02:22 PM
Makwa
Fire Beetle
 
Join Date: Jun 2004
Posts: 23
Default

I FINALLY got the server to run correctly.

BUT, it now crashes after i put in login and password.

Anyone have any advice??

Thanks
Reply With Quote
  #62  
Old 06-25-2004, 02:52 PM
Maldian
Sarnak
 
Join Date: Jun 2004
Location: Albany Ga USA
Posts: 65
Default

I am having the same problem
Reply With Quote
  #63  
Old 06-26-2004, 04:45 AM
bluejam
Hill Giant
 
Join Date: Apr 2004
Posts: 110
Default

check out this thread, it might fix your problem.

http://www.eqemulator.net/forums/vie...ht=crash+login
Reply With Quote
  #64  
Old 06-27-2004, 06:12 AM
Makwa
Fire Beetle
 
Join Date: Jun 2004
Posts: 23
Default

It still doesn't work. I am trying to play on my PC standalone first. Then move onto other peoples servers.

I have NO spaces, correct formatting, i have following this guide to the 'T', and it still crashes....

I know i know....someone is gonna say, well, it works for me, or SOMETHING is not formatted correctly.

I don't know. Its always some tiny little thing that is off.

I am going to Copy and Paste all of the files that are edited, maybe someone can see the problem...after hours of looking at the same text, it's starting to all look the same =).

----------------------------------

EQHOST.TXT

[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}

---------------------------------------------

DB.INI

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

---------------------------------------------

LOGINSERVER.INI

[LoginServer]
loginserver=localhost
loginport=5999
worldname=my minilogin test
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=10
Unavailzone=

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

----------------------------------------

MINILOGINACCOUNTS.INI

localhost eqemu eqemu

----------------------------------------

BOOT5ZONES.BAT

@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . localhost 7995 localhost
start zone . localhost 7996 localhost
start zone . localhost 7997 localhost
start zone . localhost 7998 localhost

:NOSPELL
echo you did not.....(the rest)
pause

exit
cls


------------------------------------------


Can someone please open there MYSQL admin and look at their EQ database. Look at table ACCOUNT, and tell me if you can see your LOGIN and PASSWORD listed there? Mine is not. And yes, i put it...

mysql> INSERT INTO account ( bla bla bla...all of that....


But, the login and password that i have selected is not showing up in the table.


Once again, everything loads perfectly, the eqgame.exe crashed when i put in my Login and Password. I think it crashes because the database doesnt know my login and password. But, i'm not sure how to fix that. I am going to try some things, but i am looking for some help also

Any help would be great, thanks.
Reply With Quote
  #65  
Old 06-27-2004, 09:05 AM
Brother David
Fire Beetle
 
Join Date: Jun 2004
Posts: 1
Default D/L help needed

Excuse me but, one of your servers may be bonked

It won't let me download MW055_alpha_02.zip

Anyone know where I can get this?
__________________
Did you...Poop today?
Reply With Quote
  #66  
Old 06-27-2004, 01:01 PM
Makwa
Fire Beetle
 
Join Date: Jun 2004
Posts: 23
Default

The other problem i am having is the code:

INSERT INTO account...does not work.

The error says:

ERROR 1136: Column count doesn't match value count at row 1


Now, the fields AND the values for the fields equal. So, why is it giving me this error??


Thanks
Reply With Quote
  #67  
Old 06-27-2004, 02:42 PM
tuvok_of_voyager
Fire Beetle
 
Join Date: Jun 2004
Posts: 10
Default

I'm having the same problem as Brother David, I am not able to download MW055_alpha_02.zip.
Reply With Quote
  #68  
Old 06-27-2004, 03:06 PM
tuvok_of_voyager
Fire Beetle
 
Join Date: Jun 2004
Posts: 10
Default

I figure this should work with just db.sql instead of MW055_alpha_02.sql. minilogin, world.exe, and boot5zones, load as they should, but when I start everquest with "patchme" it says it cannot connect, and I did remember to change eqhosts.txt.
Reply With Quote
  #69  
Old 06-27-2004, 04:37 PM
Makwa
Fire Beetle
 
Join Date: Jun 2004
Posts: 23
Default

Is MySQL Running?
Reply With Quote
  #70  
Old 06-28-2004, 12:06 AM
tuvok_of_voyager
Fire Beetle
 
Join Date: Jun 2004
Posts: 10
Default

yes
Reply With Quote
  #71  
Old 06-28-2004, 01:48 AM
bluejam
Hill Giant
 
Join Date: Apr 2004
Posts: 110
Default

Quote:
EQHOST.TXT

[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}
Try this format->

Quote:
[LoginServer]
Host=localhost:5999
I am not sure if you have to add "[RegistrationServer].." as well.


Quote:
DB.INI

[Database]
host=localhost
user=eqemu
password=eqemu
database=eq
Did you enter "eqemu" for your user and pw after you had installed MySQL?

Quote:
LOGINSERVER.INI

[LoginServer]
loginserver=localhost
loginport=5999
worldname=my minilogin test
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=10
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
Isn't there missing something? And paste this at the end of LoginServer.ini. It might fix your problem:

Quote:
[ChatChannelServer]
ChatChannelServer=127.0.0.1

the link should work properly now.



_________________________________________

INSERT INTO account (id, name, charname, packencrypt, sharedplat, password,
status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '', '', 0, 'eqemu', 250, NULL, 0, 0);

definately works. the two " are four single '
that confused me at the beginning as well.
Reply With Quote
  #72  
Old 06-28-2004, 03:21 AM
Yiggs
Fire Beetle
 
Join Date: Jun 2004
Posts: 2
Default

Very cool guide... I ran into a wee problem though. Minilogin.exe and World.exe work fine, but my Boot5zones.bat doesn't want to cooperate. I run it and five windows jump onto the screen all at once, and they hesitate a moment while they load the items. Then all of a sudden they all disappear! My bat file looks identical, I think....



REM: ****READ THE FOLLOWING REMARKS****

REM: There are other remarks in the original file, but I want to use this space for
REM: comments. You can erase everything in your Boot5zones.bat and paste the whole quote.
REM:
REM:
REM: IMPORTANT: Delete all spaces behind every line.
REM: -> If the cursor doesn't jump into the next line when you
REM: hit the right arrow key at the end of a line, hit backspace until
REM: it reaches the last character.
REM:
REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . localhost 7995 localhost
start zone . localhost 7996 localhost
start zone . localhost 7997 localhost
start zone . localhost 7998 localhost
start zone . localhost 7999 localhost
exit
cls

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

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


Any ideas? Thanks!
Reply With Quote
  #73  
Old 06-28-2004, 04:41 AM
bluejam
Hill Giant
 
Join Date: Apr 2004
Posts: 110
Default

Try executing the zones.bat through a cmd prompt. Dunno if that will fix it, but it's worth a try.
Reply With Quote
  #74  
Old 06-28-2004, 06:31 AM
Makwa
Fire Beetle
 
Join Date: Jun 2004
Posts: 23
Default

Yeah Bluejam the database has a login and password..they are eqemu eqemu.

The change to the EQHOST file, didn't make a difference.

I'm using EQEMu 0.5.7-DR6 also.

The four single quotes didn't give me an error after i hit enter. Thanks.

I have tried SO many different things, i guess i don't know what to try now.

I know that my Login=eqemu Password=eqemu is in the database now, because when i try the two different methods of adding users:

c:\world....this way..AND
mysql> INSERT INTO account SET name.....

both say duplicate entry...so i know they are in the database.

<shrug>

Now lost
Reply With Quote
  #75  
Old 06-28-2004, 07:44 AM
Yiggs
Fire Beetle
 
Join Date: Jun 2004
Posts: 2
Default

Quote:
Originally Posted by bluejam
Try executing the zones.bat through a cmd prompt. Dunno if that will fix it, but it's worth a try.
Hmm.... no, same thing. After I run it, my initial command prompt window closes and the 5 new ones open up, then close after they load the items. Darn, do you know of any way of telling it to not close the window? It looks like there's some sort of error that pops up right at the end.
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 07:27 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