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

[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/Act...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....l-4.0&v=4.0.26

3a) Install MySQL to c:\Mysql
3b) Download MysqlCC from: http://downloads.mysql.com/archives....ysqlcc&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/e...ar.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).