OK, banged my head against this long enough...

[klinzhai]

Followed the instructions for db setup (including the minilogin stuff) at:

http://www.eqemulator.net/wiki/wikka.php?wakka=MySQLSetup

My eqemu_config.xml looks like this (copy/paste, so it's exact):

<?xml version="1.0">
<server>
<world>
<shortname>Korancia2</shortname>
<longname>Matt's Korancia Server</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address>wendy</address>
<!--localaddress>192.168.1.101</localaddress -->

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account>eq</account>
<password>klinzhai</password>
</loginserver>

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults

are shown -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- 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. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>
<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>klinzhai</password>
<db>eqemudata</db>
</database>

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>


My minilogin LoginServer.ini looks like:

### --- 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 reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=Korancia2
worldaddress=192.168.1.101
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=minilogin
ServerPort=5999


Yet every time I try to start world.exe, it just pops up the error:

[Debug] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect(): connect() failed. Error: 10061

If anyone has any ideas, I can be reached on Yahoo messenger as solinear.

[klinzhai]

Just an FYI. When I connect to the minilogin server from a client, it says "904344 New client from ip: 127.0.0.1 port: 4884"

At least something is working... :)

[klinzhai]

Went and hunted down Cavedude's installer, seems to be working, only I'm not seeming to be able to login from my EQ client. I'm sure that it's something stupid (more PEBCAK) like I haven't added in the user/password for the client.

Edit: Yep, went into the db and inserted the record with a password (Yay for MysqlCC!!) and everything and *bam*! I got in. Now all I have to do is figure out how to get my server onto the server list :)

[Kirgothi]

I am having the same problem as you. Where are you stuck at? The "Logging into the server. Please wait..." screen? Or the server selection screen.

Cavedude told me that his installer takes care of adding a default user/passcode for you. I think it's mini/mini, but I am not positive.

Kir

[klinzhai]

I'm at the server screen.

His installer does not install default user/password into the account table (if you go get MysqlCC from the good MySQL folks, you can view the table and there's nothing in it). Just right-click on the account table, select "Open Table > Return all rows" and it will actually return you all the data in the table. If there isn't anything in there, right-click again in the open area where it appears that the data is and select "Insert record". Now you can go through and set all those wonderful settings that you'll need so that you can create new users. As soon as you click on the "name" field, it will autocreate a new master key (the "id" field for the table... never change this, it's only important for the db itself and it autoincrements) for the record.

[Kirgothi]

I am trying to use access to open the table, but I can't seem to find anything to open. What are you using to look at the database?

[cavedude]

Installer Pack 3.5 is out and should work for you.

[klinzhai]

You can find MysqlCC here:

http://downloads.mysql.com/archives.php?p=mysqlcc&v=0.9.2

It's a control center. If you load it on your db server (like probably most of us do), your settings should be:

Name: (doesn't matter, I just put down 'localhost')
Host Name: localhost
User Name: root (unless you want to use your EQ user)
Password: (your password :) )

You can actually do all the database admin type stuff through this... it's a lot easier than trying to do it through the command line version. However, you can't run really large (20+MB) .sql files in it, you have to do those through the command line version (*sniff*). I create all my users in that, since it's easier to just insert record and give it a name, password, status, ip, etc...

P.S.: Cavedude. I used 3.5 it does work way better than everything else, but for some odd reason it did not create an entry into the account table for a user.

[Kirgothi]

Um ok, completely lost here. I have actually had a class on SQL and Oracle, but this all seems totally different than any of that. We were able to use Access to look at any of our databases.

I downloaded the control center. I entered the information you mentioned. How do I like do anything in here? How do you find the tables? They don't seem to be listed anywhere. When I try to connect to the database it just says:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

[Kirgothi]

Ok, now I am trying to add the account using the command line method. I am trying to follow the incredibly cryptic guide here:
http://www.eqemulator.net/wiki/wikka.php?wakka=MiniLoginSetup

I am trying to just open a command prompt and typing in the code:
INSERT INTO account(name, STATUS, minilogin_ip) VALUES('mini',250,'127.0.0.1');

In the first set of parenthensis, do I type in "name", "STATUS", "minilogin_ip" as it says in the guide? Or am I supposed to substitute some other value? What is 250 for? I thought it was for GM or admin level access. Where do you find that information?

It just replies by telling me that INSERT is not a recognized command.

[klinzhai]

It's not going to look like Access, you can probably use Access to edit your database and tables if you like. I'm just used to doing more db design type stuff, where having the database view is more easy for me to do stuff with.

It's possible that one of the problems that you're having is one of the problems that I was having... my password for the eq user (inside MySQL) was not set the same as what the 3.5 installer set it for by default (user: eq - password: eq). I changed that in the database and it worked fine.

That being said, the connection error could be that you're entering the wrong password for root. Or it's possible that you need the odbc driver (I always forget that I have it installed).

If you want to use Access, it's not that different and you should be able to view the data in the tables easier than with MySQLCC

[Maus]

No such luck, cavedude. :(

[Kirgothi]

Ok, now I am connected to the server in mysqlcc. I have an emusp3 and an eq database. They look pretty similar. Which one do I want to use to insert into the account table?

How does one do this insert?

[klinzhai]

Oh the beauties... they're possibly both the same thing, you probably just installed again, so it created another db. Check and see which one was created most recently (look at the tables and see which ones were created more recently) and that's probably the more recent of the two.

That being said, I tried out 'mini' and 'mini' and while they aren't in the db, they do still seem to work. Maybe this is a minilogin feature that I didn't know about.

Either way though, if you want anyone else to be able to connect to your game, you'll need to be able to add more users.

BTW, I've reinstalled about 3 times and I think that my problem is related to whatever is causing my one command session to eventually switch over to saying "0: sleeping". If I can figure out what's going on with that, I think it will start working (redownloaded 3.5 about a 1/2 hour ago and reinstalled and it just kind of keeps doing the same thing).

[Kirgothi]

ok, but how do you actually insert a record? I can open the table now and I see an "insert record" button, but when I click it, it just turns gray. Is there room on that wall for me to bang my head on it too? Together we can probably knock it down. :)

[klinzhai]

When you choose "Insert Record" you'll notice that you'll have one spreadsheet-esque row underneath the column names. Simply click on the 'name' field for that row and enter something in, then tab across to the password field and enter a password there (yes, this means that anyone that has access to your db can find out anyone's username/password), then enter an IP address in the minilogin_ip field, etc...

Edit: Apparently the sleeping thing isn't the problem :( Well, at least I probably only have 1 more problem left.

[Kirgothi]

argh, when I click on "insert record" the areas you are talking about where you can enter data do not appear. The button just turns gray.

Let me try reinstalling mysqlcc.

[klinzhai]

Yeah, that sounds a little weird... but you should still be able to use mini for username and password to see if you get to the server selection list.

[Kirgothi]

ok, I reinstalled and now I am able to connect to the database and I inserted the record into the emusp3 account table. I also had to copy the patch_6.2.conf file into the opcodes.conf file before I was able to get past the login screen. YAY!!

Now I am right back where I was before serverpack 3.5, a server selection screen with no servers listed.

[cavedude]

You are using the wrong database. 3.5 creates a database called eq, not emusp3. Try completely dropping all databases, un-installing the Server Pack, manually delete the EQEmu dir if logs are left, re-download 3.5 and try again. I guarantee it works.

[klinzhai]

You are using the wrong database. 3.5 creates a database called eq, not emusp3. Try completely dropping all databases, un-installing the Server Pack, manually delete the EQEmu dir if logs are left, re-download 3.5 and try again. I guarantee it works.

Yeah, I actually deleted all but my 'mysql' and 'test' databases before reinstalling. Wasn't sure if there was a reason why I had a emusp3 db before, but then it created an eq db after (with 3.5). I still can't get past the server screen either though. :(

[Kirgothi]

Cavedude, I will try that. I have to go out for a couple hours. When I get back I will try all of that and reply here. I will try to post all the info I can find. It will be a loooong post.

[klinzhai]

Maybe this will help, my eqemu_config.xml file:

<?xml version="1.0">
<server>
<world>
<shortname>Korancia</shortname>
<longname>Korancia - EQ</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></account>
<password></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>

(changed from red... it was so obnoxious)

Here is my minilogin

###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=Korancia - EQ
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

Still stuck at server screen. Before I installed this last time (earlier today) I deleted all but my 'mysql' and 'test' databases, made sure that the 'eq' user in MySQL had the password of 'eq', deleted everything in my eqemu directory other than the maps (take too long to download) and then reinstalled. Still nothing at the Server screen :(

[cavedude]

Ohhh... you changed the server names... You don't have to with minilogin, in fact I recommend that you don't. Only change your server name for public. Try changing back to My Minilogin Server for both. That may just get it.

[klinzhai]

After I finish reinstalling EQ (just in case... installing it to a different location) I'll change that over.

[Kirgothi]

Ok, I tried all of that and nothing has changed. After instalation, there was not a record in the account table for mini/mini. I added one. If I start everquest after getting the server started I am, once again, stuck at the "Logging into the server. Please wait..." screen.

If I copy patch_6.2.conf into opcodes.conf I can get past the login. Then I am facing the dreaded server selection screen with no servers in the list.

Are you sure there isn't anything else you are doing and just not thinking about Cavedude? It seems odd that while the serverpack doesn't create a record in the account table that you are not getting stuck at the login screen. Are you entering the record somehow? Is there anything else that you are doing?

Here are my files and output:
eqemu_config.xml
<?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></account>
<password></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>


The Run EQemu window:
Waiting for World to finish before starting Zone...

The World.exe window:
[Status] Using database 'eq' at localhost:3306
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54535

The 1 Server(s), 0 Client(s) Connected window:
LoginServer.ini read.
[Status] Loading opcodes..
Server mode: MiniLogin
Login server listening on port:5999
5698 New Server connection: 127.0.0.1 port: 15373
0: 4D 79 20 4D 69 6E 69 6C - 6F 67 69 6E 00 00 00 00 | My Minilogin....
16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
32: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
48: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
64: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
80: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
96: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
112: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
128: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
144: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
160: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
176: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
192: 00 00 00 00 00 00 00 00 - 00 6D 69 6E 69 6C 6F 67 | .........minilog
208: 69 6E 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | in..............
224: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
240: 00 00 00 00 00 00 00 00 - 00 00 00 31 32 37 2E 30 | ...........127.0
256: 2E 30 2E 31 00 00 00 00 - 00 00 00 00 00 00 00 00 | .0.1............
272: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
288: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
304: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
320: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
336: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
352: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
368: 00 00 00 00 00 00 00 00 - 31 32 37 2E 30 2E 30 2E | ........127.0.0.
384: 31 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | 1...............
400: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
416: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
432: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
448: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
464: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
480: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
496: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
512: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
528: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
544: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
560: 00 00 00 30 2E 33 2E 31 - 30 00 00 00 00 00 00 00 | ...0.3.10.......
576: 00 00 00 00 00 00 00 00 - 00 00 00 00 30 2E 37 2E | ............0.7.
592: 30 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | 0...............
608: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
624: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
640: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 | .............
0: E8 01 36 00 01 00 00 00 | ..6.....
0: 49 6E 76 69 02 00 00 00 | Invi....
0: 00 50 5F 4C 03 00 00 00 | .P_L....
0: 00 00 00 00 04 00 00 00 | ........
0: 00 00 6C 64 05 00 00 00 | ..ld....
0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 30 | ....Mon Apr 17 0
16: 39 3A 35 39 3A 31 34 20 - 32 30 30 36 00 01 00 00 | 9:59:14 2006....
32: 00 | .
0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 30 | ....Mon Apr 17 0
16: 39 3A 35 39 3A 31 34 20 - 32 30 30 36 00 02 00 00 | 9:59:14 2006....
32: 00 | .
0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 30 | ....Mon Apr 17 0
16: 39 3A 35 39 3A 31 34 20 - 32 30 30 36 00 03 00 00 | 9:59:14 2006....
32: 00 | .
0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 30 | ....Mon Apr 17 0
16: 39 3A 35 39 3A 31 34 20 - 32 30 30 36 00 04 00 00 | 9:59:14 2006....
32: 00 | .
0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 30 | ....Mon Apr 17 0
16: 39 3A 35 39 3A 31 34 20 - 32 30 30 36 00 05 00 00 | 9:59:14 2006....
32: 00 | .

and the window that says 0: sleeping
[Debug] Starting Log: logs/eqemu_debug_2616.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [LAUNCHER__INIT] Starting main loop...
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is alre
ady running.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_01
[Debug] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second
zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_02
[Debug] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zon
e.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_03
[Debug] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zon
e.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_04
[Debug] [LAUNCHER__STATUS] Zone dynamic_04 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zon
e.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_05
[Debug] [LAUNCHER__STATUS] Zone dynamic_05 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.


That is what things look like when before I launch the client. If I launch the client, it changes the window to say 1 Server(s), 1 Client(s) Connected and adds the following line at the end of the window:
285771 New client from ip: 127.0.0.1 port: 3400

I don't know if this helps but if I click the "Admin" button on the server list, it times out and I get this line in the 1 Server(s), 1 Client(s) Connected window:
Unknown packet: .4233692 [***.***.***.***:15->0.0.0.0:0]
[OpCode 0x000e (OP_Unknown) Size=11]
00000: 00 08 00 00 00 00 00 00 - 00 00 00 | ...........

the ***'s are my real IP address, instead of the 127.0.0.1.
If there is any other data that may help, just ask, I will post it.

[Kirgothi]

One added note, the ***'s are not my real IP. I have no idea what the numbers are. That's interesting.

BTW - a guy over at the forums on darkrogue productions (the site cavedude's serverpack is at) got past this problem by using MySQL 4.0.10 instead of the version we are using. Does anyone have a link to it? I can't find it.

[Maus]

Tried all of the above on 2 different machines, done about a dozen clean delete and reinstalls of various versions. Still no servers listed.

Anything else to try?

[Kirgothi]

Yeah, over at Dark Rogue's site, they are saying there may be some configuration problem causing this. Also, if you install mySql 4.0.10 instead of 4.0.23 it seems to let you log into the game. But you crash on zoning, dying, or logging out.

[klinzhai]

OK, got it solved and have reinstalled several times successfully (believe it or not!!). I'll go through it step by step.

Anything in quotes ("anything") is something you are going to type in (without the quotes), anything in single quotes ('anything') is something that you are going to click on or otherwise select (unless inside something that is "quoted").

1) Remove Perl, MySQL and EQEMU.

2) Download Perl from: http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.7.813-MSWin32-x86-148120.msi

2a) Install Perl to c:\perl
2b) Download nMake.exe from: http://home.comcast.net/~molimo140/NMAKE.EXE and copy it to the C:\perl\bin directory
2b) Go to a command prompt, change directories to perl\bin (command: "cd\perl\bin")
2c) type in: perl -MCPAN -e shell
2d) Type in: "No" when it asks you about autoconfig
2e) type in: "IO::Scalar"

3) Download MySQL from: http://downloads.mysql.com/archives.php?p=mysql-4.0&v=4.0.26

3a) Install MySQL to c:\Mysql
3b) Download MysqlCC from: http://downloads.mysql.com/archives.php?p=mysqlcc&v=0.9.2
3c) Install MySQLCC (default location is fine) and run it, setting up your connection as:

Name: localhost
Host Name: localhost
User Name: root
Password: ****** (whatever you set the root password to)

Note: You may need the ODBC driver from: http://dev.mysql.com/downloads/connector/odbc/3.51.html I already had it installed when I installed MyCC, so I don't know offhand.

3d) Right-click on User Administration, choose 'New User' and name the user "eq" with the password of "eq" (you can change this later, just set it as this for now).


4) Download version 3.5 installer from: http://eqemu.sesmar.net/sp/EQEmuServerPack-3.5.exe

4a) Run the installer, choosing whatever options and database that you want to use (project EQ or Cavedude's).
4b) Download the maps from: http://prdownloads.sourceforge.net/eqemulator/Maps.tar.gz?download and extract them into your C:\EQEMU directory (it will create a maps directory automatically).
4c) Go into MySQLCC, choose the EQ database, click on the "SQL" button (for sql query entry) and enter the following line: "update variables set value = 'minilogin' where varname='LoginType';" then choose the 'Execute' button (looks like a red exclamation mark). Close the SQL query window after that finishes running (don't close MySQLCC, just the query window).
4d) Go into the EQ database and double-click on the 'account' table. Choose the 'Insert Record' button and then go to the 'name' field and enter "player", tab across to 'password' and enter "eq", tab over to 'status' and enter "250", tab across to 'minilogin_ip' and enter the IP address of your EQ computer (127.0.0.1 if you're running EQ from your EQEMU computer, otherwise run "ipconfig" from a command prompt from your EQ client computer). Close MySQLCC when finished. Note: the account table is where you will add more users or change user passwords in the future. MySQLCC is a lot easier to use than the command line options, since it's basically like Excel once you get into the tables. Don't forget to use 'Insert Record' when you want to add a new login and don't overwrite ones that you might want to keep using.

5) Start the EQEmu (Start->All Programs->EQEmu Server Pack->Run EQEmu)

6) Start Everquest (Start->All Programs->EQEmu Server Pack->Run Everquest).

6a) Enter the character name "player" with the password "eq"
6b) Choose the server '[0.7.0] My Minilogin Server', create a new character and start playing. :)

[Kirgothi]

Very nice Klinzhai! I will have to give this a try.

[Kirgothi]

When I try to type in the IO::Scalar command, it says it can't the method IO in the Scalar package. Also when I typed in perl -MCPAN -e shell it did NOT ask about autoconfig, it asked about manual config.

Also, I went on ahead in the hopes that this will work. When trying to use MySqlcc, where is this "user adminstration" you want us to right click? I can't find it anywhere on the screen or in the menus.

[klinzhai]

Sorry... was watching a movie with my wife... just an FYI: Brokeback Mountain, while acclaimed by many, lacks good storytelling and while many good tragic love stories will leave you wanting to cry, BB Mtn leaves you going "There was nothing special about that movie..." Save your time and don't see it if you haven't already.

When you go into MySQLCC, you'll see your connection name (localhost if you named it that), then underneath there you'll see the 'Databases' container, 'Server Administration' container and 'User Administration' container. You can also simply select it and then click on the 'New User' button (looks like a head with a little spark at the crown). If you create the 'eq' user before you run the install, it will automatically grant the rights on the db. Otherwise, you can go into the properties for the 'eq' user, select (checkbox) on the 'eq' database, then choose 'All Privileges' on the left-hand side.

Sorry about the autoconfig/manual miscommunication, I was going by someone else's notes about that (from the 6.4 install guide I think) and apparently forgot that it was manual that it asked about (just checked the instructions and it does say manual).

[drunkgoblin]

"By george he's got it!" Now titanium edition works with minilogin. And rather than reinstalling everything all you have to do is add the minilogin logintype entry ( update variables set value = 'minilogin' where varname='LoginType'; ) and the account info. works for logging in from the same comp and logging in from a dif comp, or more than one dif comp at the same time. Good work klinzhai and thank you!

P.S. might I suggest downloading a trial of Navicat from http://www.navicat.com/ for database editting, works great.

[klinzhai]

Thanks.

I figured that the 1 database command *might* do it. It's possible that something else might be causing the whole issue for a particular user, so it's better to be safe and start a bit more 'fresh', as it were and eliminate any other potential issues.

I think that there are still issues with quests, but think that's related to perl and when I get that worked out, I'll add in those changes and maybe they'll add it into the Wiki, so that we're not all running around blind (like I think we all are right now ;) ).

[klinzhai]

The perl and MySQL sections should be reversed if you're having problems. Also, if you're having problems (lots of errors) in the perl section, go to:

http://www.eqemulator.net/wiki/wikka.php?wakka=WindowsServerGuide

Follow the directions there for Perl installation. Some computers seem to work with that, while others work with what I outlined in the instructions earlier. Not completely sure why yet and it's way too late and I'm otherwise busy, so I can't run through and find out why right now.

[BFC]

Howdy,

I've been struggling to get a 7.0 server up a running for most of this week. I've tried several different install methods including the one you post one page back.

All methods result in the same thing eventually. When a client logs in and selects the server to play on, in the server window an error pops up.

"Unknown Packet: .4455296 [16.64.89.0:16->0.0.0.0:0]
[OpCode 0x0003 ,OP_Unknkown. Size=11]
00000: 00 06 00 00 00 00 00 00 - 00 00 00"

I can't connect local or have someone outside connect either. Results are the same in either case. I am able to get onto any of the public servers without any issues with my client and so can my external person helping me test.

We have tried 7.0 clients, 6.2 clients.
We have tried 7.0 server
We have tried 6.6 server

I really don't have a good idea on what to try from here. Any suggestions?

-BFC

[Belfedia]

We need more information on your install for help you.

1- have you use the Drp installer (cavedude).
2- can you produce some config files (xml) or more complete log files.
3 - Have you success to see your server in server list ?
4 - are you behind a router and if yes , have you forward the zone port ?

[BFC]

1- Yes, used Cavedude's 3.5 and 3.52 installers. Same result with either

2- I can produce XML files, but would be later as i'm away from the server location at the moment. However, these seem in order

3- Server will appear in list after logging in like it should and like it does when connecting to public servers.

4- Server is behind a D-Link router and the server machine is set as the DMZ.

As for changing IP addresses in the config files and xml files, this has no impact on the opcode error. If the config files are setup to use 127.0.0.1 or Localhost or the IP the router assigns to the server which is 192.168.blah.blah it doesn't change the error. What happens if the config files are not setup right is the client will not get past the login process and will never see a server select window.

I appreciate the help,

-BFC

[Belfedia]

Opcode error are useless (except for devs)
I don't think it was about your server don't work.
Perhaps a config files, perhaps no, i just try to understand
for help you :)

[BFC]

I found the solution,

http://www.eqemulator.net/forums/showthread.php?p=120355#post120355

-BFC