server shows on 0.7.0 but won't connect

[doomkiller]

Problem: When I log onto EQ I see the server in the server list, I click on it game freezes, and finally sends me back to the login screen.

Setup:
-Fresh windows (had to do this for other reasons so I thought it would be a good time to try this)
-MySQL 4.0.24
-ActiveState Perl (no extra modules)
-EQ Titanium
-Cavedude's 3.5 installer (I first set it up as public server to try my cleint worked fine so i used his switcher program and switched it to MiniLogin)
- Ran the mysql command ( update variables set value = 'minilogin' where varname='LoginType'; )

I started up the server with no other changes, loged in with a random account. Then choose the ony server on the list and hit Play EverQuest. This is when the problem above occured.

Extra Note: When I choose the server and hit play this is what the minilogin gave me:

Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 (OP_Unknown) Size=11]
00000: 00 06 00 00 00 00 00 00 - 00 00 00 |.............

[ichijin]

That is driving me nuts too. Have been trying to identify that since I first seen it. It doesnt seem to affect anything though, as my server still runs fine with that bug. (Other than discon on death)

[doomkiller]

Ahh I found my mistake, I wasn't sure if I had to make an account manually so I was inputing junk. I read up a little and found you infact had to input an account in manually. Thanks for reading though

[klinzhai]

If you get a MySQL admin tool that will let you edit the data in the tables (MySQLCC for example), you can simply edit the account table that way, takes about 15-20 seconds to add a new user account if you type slow.

[armflailing]

hi I am getting this same error, can you tell me how to add an account manually, I have been frustrated with this error, it kicks me back to login every time.

[klinzhai]

You have to edit the account table in the database.

Make sure you put a username, password, status and ip address (127.0.0.1 if it's on the same machine).

[Maus]

I've put in the accounts manually and I'm STILL having this trouble.. (used navicat to do it and rebooted several times since.. all info is saved).

<?xml version="1.0">
<server>
<world>
<shortname>minilogin</shortname>
<longname>My Minilogin</longname>

<!-- Only specify these two if you really think you need to. -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>eq</account>
<password>eq</password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>
</server>

###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=My Minilogin
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999



I'm so open to suggestions its not even funny.

Just for sng, I note that -I- can get in to play on the main machine just fine. It's any other machine that runs into the trouble. They pick the server, click Play and hang to eventually go back to the login/pw screen.

[klinzhai]

Try changing all your "127.0.0.1" over to your network address (192.168.1.101 or whatever). Leave the database settings alone though.

[Maus]

I did.. no love =/