MiniLogin --- Host & Play on same PC *Step by Step*

[Makwa]

I FINALLY got the server to run correctly.

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

Anyone have any advice??

Thanks

[Maldian]

I am having the same problem

[bluejam]

check out this thread, it might fix your problem.

http://www.eqemulator.net/forums/vie...ht=crash+login

[Makwa]

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.

[Brother David]

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?

[Makwa]

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

[tuvok_of_voyager]

I'm having the same problem as Brother David, I am not able to download MW055_alpha_02.zip.

[tuvok_of_voyager]

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.

[Makwa]

Is MySQL Running?

[tuvok_of_voyager]

yes

[bluejam]

EQHOST.TXT

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

Try this format->

[LoginServer]
Host=localhost:5999

I am not sure if you have to add "[RegistrationServer].." as well.

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?

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:

[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.

[Yiggs]

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!

[bluejam]

Try executing the zones.bat through a cmd prompt. Dunno if that will fix it, but it's worth a try.

[Makwa]

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

[Yiggs]

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.