Minilogin - cannot see local server

[cutterjohn]

Hello,

I installed a mini-login setup this evening using, primarily, the wiki guide aimed at mySQL5 usage.

I obtained the most recent copy of mySQL5 plus tools, ActiveState's Perl 5.8.8 plus added modules, minilogin 0.6.2, the full 300M mappack, peq rel 12/25/06 plus quest pack. The MSVC*71.DLL libs were already present in my system32 directory, so I skipped those.

Got everybody installed, the database setup, although I had to work around some of the items like account insertions. I ended up leaving only one account in place and gave it a name of cutterjohn, a password, and the local private ip of the machine to be played on(also running the servers) as it's minilogin_ip addr.

When I attempt to login with a brand spanking new titanium install, I can get to the login screen, enter the account name and pw, but then have no servers listed in the list. I have checked the other threads related to this and have tried using various combinations of 127.0.0.1 (for localhost) or the actual private IP that I use for the machine, but none of that seems to make any difference. (That was what appeared to make a difference to other people in the older threads...)

(As a side ntoe the same machine is running Mysql, perl, the eqemu stuff plus the client. 2G DDR-400, socket 939 Athlon x2 4800+, win2k.)

My world log looks like:

[Debug] Starting Log: logs/eqemu_debug_world_1904.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_1904.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54307
[Debug] [WORLD__INIT] Loading guilds..
[Error] Starting Log: logs/eqemu_error_world_1904.log
[Error] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='default': #1146: Table 'peq.rule_sets' doesn't exist
[Debug] [RULES__ERROR] Failed to find ruleset 'default' for load operation. Canceling.
[Debug] [WORLD__INIT] No rule set configured, using default rules
[Debug] [WORLD__INIT] Loading EQ time of day..
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes OFF
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1546
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1546
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zones'. Loading zone list.
[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list.
[Debug] [WORLD__LAUNCH] zones: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1548
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:1548
[Debug] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zones
[Debug] [WORLD__ZONE] [1] Auto zone port configuration.  Telling zone to use port 7000
[Debug] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1550
[Debug] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:1550
[Debug] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zones
[Debug] [WORLD__ZONE] [2] Auto zone port configuration.  Telling zone to use port 7001
[Debug] [WORLD__LAUNCH] zones: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1552
[Debug] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:1552
[Debug] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zones
[Debug] [WORLD__ZONE] [3] Auto zone port configuration.  Telling zone to use port 7002
[Debug] [WORLD__LAUNCH] zones: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1554
[Debug] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:1554
[Debug] [WORLD__ZONE] [4] Zone started with name dynamic_04 by launcher zones
[Debug] [WORLD__ZONE] [4] Auto zone port configuration.  Telling zone to use port 7003
[Debug] [WORLD__LAUNCH] zones: dynamic_05 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1556
[Debug] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:1556\
[Debug] [WORLD__ZONE] [5] Zone started with name dynamic_05 by launcher zones
[Debug] [WORLD__ZONE] [5] Auto zone port configuration.  Telling zone to use port 7004

Continued in part 2, as I hit the character limit for a post otherwise!

[cutterjohn]

my other server log window

LoginServer.ini read.
[Status] Loading opcodes..
Server mode: MiniLogin
Login server listening on port:5999
2531 New Server connection: 127.0.0.1 port: 2310
   0: 4D 79 20 45 51 20 4D 69 - 6E 69 6C 6F 67 69 6E 20  | My EQ Minilogin
  16: 73 65 72 76 65 72 00 00 - 00 00 00 00 00 00 00 00  | server..........
  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 4D 79 4D 69 6E 69 00  | .........MyMini.
 208: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00  | ................
 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: 00 00 92 00 01 00 00 00                            | ........
   0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 32  | ....Mon Apr 17 2
  16: 31 3A 33 37 3A 34 32 20 - 32 30 30 36 00 01 00 00  | 1:37:42 2006....
  32: 00                                                 | .
   0: 00 00 5F 44 02 00 00 00                            | .._D....
   0: 00 00 00 00 03 00 00 00                            | ........
   0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 32  | ....Mon Apr 17 2
  16: 31 3A 33 37 3A 34 32 20 - 32 30 30 36 00 02 00 00  | 1:37:42 2006....
  32: 00                                                 | .
   0: 07 00 18 00 04 00 00 00                            | ........
   0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 32  | ....Mon Apr 17 2
  16: 31 3A 33 37 3A 34 32 20 - 32 30 30 36 00 03 00 00  | 1:37:42 2006....
  32: 00                                                 | .
   0: 74 65 00 00 05 00 00 00                            | te......
   0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 32  | ....Mon Apr 17 2
  16: 31 3A 33 37 3A 34 32 20 - 32 30 30 36 00 04 00 00  | 1:37:42 2006....
  32: 00                                                 | .
   0: 00 00 00 00 4D 6F 6E 20 - 41 70 72 20 31 37 20 32  | ....Mon Apr 17 2
  16: 31 3A 33 37 3A 34 32 20 - 32 30 30 36 00 05 00 00  | 1:37:42 2006....
  32: 00                                                 | .
98953 New client from ip: 127.0.0.1 port: 1558

my eqemu_conf.xml is as such:

<?xml version="1.0">
<server>
    <world>
        <shortname>MyMini</shortname>
        <longname>My EQ Minilogin server</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>root</username>
        <password>password</password>
        <db>peq</db>
    </database>
</server>

and my LoginServer.ini as:

### --- 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=192.168.0.11
loginport=5999
worldname=My Minilogin
worldaddress=192.168.0.11
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

my eqhosts.ini has been changed to contain 127.0.0.1:5999

[bufferofnewbies]

This may not be of any help, but on:

Loginserver.ini

loginserver=192.168.0.11
loginport=5999
worldname=My Minilogin
worldaddress=192.168.0.11
locked=false
account=
password=

You said you have tried various combos, but to verify:
Have you tried changing these to 127.0.0.1?

I'm not very good with the setup, so this probably isnt the issue. I consider my ability to setup a server 50% luck and 50% uhm..well, luck.

[cutterjohn]

Originally Posted by bufferofnewbies

This may not be of any help, but on:

Loginserver.ini

loginserver=192.168.0.11
loginport=5999
worldname=My Minilogin
worldaddress=192.168.0.11
locked=false
account=
password=

You said you have tried various combos, but to verify:
Have you tried changing these to 127.0.0.1?

I'm not very good with the setup, so this probably isnt the issue. I consider my ability to setup a server 50% luck and 50% uhm..well, luck.

Yep, unfortunately I believe that I tried just about every single combinations of addresses possible to no avail. (Spent about 2.5h tinkering around with various settings after the .5h initial install and still no go...)

But, I will try again shortly, but I'm not thinking it'll work as I'm sure that I already tried that combo too... Sort of why I posted just about everything I could lay my little posting fingers on, hoping that somewhere in that mess was a sparkling little clue that I entirely overlooked...

I'll edit the post again after I try a few other things too... taking a short break ATM...

[cutterjohn]

Oh well, couldn't edit the previous message any longer, but I went back and checked, and I had already had it set to try using 127.0.0.1 in the loginserver.ini.

Decided to load up everything again and give it a try, but still nothing shows up in my server list once I login...

Giving up for the night though...

[John Adams]

Personally, I wouldn't use the 127.0.0.1 for anything. While it is the hard address for localhost, I find using my actual IP works much better. I haven't run everything on one box since my first week (you know, had to spread the work over my server farm here ), but if you haven't tried yet, use your own machine IP for all values. "localhost" seems to work for mysql/database settings, if the world/zones are running on the SQL server.

There's a nice Wiki by Crabclaw that might help. Started me off right way back when.

http://www.eqemulator.net/wiki/wikka...iniLoginConfig


Edit: Hey, guess what just happened to me? Empty server screen. I was changing over to PEQ database to test the Fabled Crush loot thingy, when I saw no servers. :O Looking into it, I saw the variables table, LoginType was set to Public (from when I ran a server), so Minilogin didn't show up. I changed it to "minilogin" and now all is well.

And I had to add a column to table: account for minilogin_ip, and set it to my machines IP address - but I imagine you already did that one.

[joh77]

Not sure if it matters but your worldname in eqemu_conf.xml and loginserver.ini are not the same name.

[cutterjohn]

Originally Posted by John Adams

Edit: Hey, guess what just happened to me? Empty server screen. I was changing over to PEQ database to test the Fabled Crush loot thingy, when I saw no servers. :O Looking into it, I saw the variables table, LoginType was set to Public (from when I ran a server), so Minilogin didn't show up. I changed it to "minilogin" and now all is well.

And I had to add a column to table: account for minilogin_ip, and set it to my machines IP address - but I imagine you already did that one.

Ah! Hah! You WERE right in a way. I followed the mySQL 5.0.23(?) setup guide under the server section as I wanted to use a recent mySQL version.

I copied and pasted the list of INSERT queries to the variables table, and NEVER checked them!

So, after reading about your comment wrt LoginType in the variables I went and checked it to find the %#^&^*&@%*&@$%7!!!! EMPTY!

So I tried the guide suggested copy and paste all INSERT query into the query browser, bang complains about duplicate ailevel. Ok, so I remove it try again, still complains about it. Look at the variables table, and only ailevel is present. WTF?!

Short story ended up adding all of those(for now) individually via query browser. (Should've dumped 'em into a text file and fed the via the CLI interface, but oh well...)

Bang! My server is now listed!

Haven't logged in and tried making a character, but will do that shortly...

Must also remember to go back and check everything else that I did through that POS query browser. (mySQL's own GUI tools suck badly...)

As to running everything on one machine, I figure it's more than capable of handling it. Even the initial peq database setup was only pushing it to about 25% utilization on ea. core, and with the 5 zones, I still see less than .5G of total memory usage... I'd run it on another machine if I had one with enough memory to bother with. I have an old 1G T-bird, but it has no drives and only 256M... also sitting as a bare mb + cpu + memory stick...

1H later,
well, you were also right sort of, in that I had to go change all of the listed IP addresses to be 127.0.0.1 . I suppose that localhost should work as well as it SHOULD be directly mapped to 127.0.0.1 anyways.

(I found the above, as while I could see the server and login it would kick me out with a log message telling me to verify my account in the account table. I did so, and created a second test account with the same results, then tried changing all of the IPs. I'm, obviously, not 100% sure that they ALL needed to be changed but it worked for me and allowed me to create a character.)

Now, I just have to figure out why my movement keys aren't moving me...

[John Adams]

Originally Posted by cutterjohn

Now, I just have to figure out why my movement keys aren't moving me...

Make sure in variables table, the Rules value is empty. If there is data in this (even a space), your server will not allow any clicking or moving until you type #acceptrules. It's a way to prevent people from coming to >your world< and whining about how you choose to run a server.

Either that, or in your account record, rulesflag field, set it to 1.

Good to see you got it sorted out.
J

[cutterjohn]

Originally Posted by John Adams

Make sure in variables table, the Rules value is empty. If there is data in this (even a space), your server will not allow any clicking or moving until you type #acceptrules. It's a way to prevent people from coming to >your world< and whining about how you choose to run a server.

Either that, or in your account record, rulesflag field, set it to 1.

Good to see you got it sorted out.
J

Yeah, I just happened across that little item on cavedude/sesmar's forum. I didn't have a rules row in my variables table, but I started the game up again and tried #acceptrules which allowed me to turn left and right now, but not forwards or backwards.

Prior to that I could click and interact with things AND sit down... need to go check the db again, and more digging, I imagine...

[Angelox]

Originally Posted by cutterjohn

Yeah, I just happened across that little item on cavedude/sesmar's forum. I didn't have a rules row in my variables table, but I started the game up again and tried #acceptrules which allowed me to turn left and right now, but not forwards or backwards.

Prior to that I could click and interact with things AND sit down... need to go check the db again, and more digging, I imagine...

Also, keep on mind, some of us have problems with version EQEmu-0.7.0-941. one of the symptoms is, when you log into the zone, you can't move. The way to know for sure is, back down to an older version, like 940

[cutterjohn]

Originally Posted by Angelox

Also, keep on mind, some of us have problems with version EQEmu-0.7.0-941. one of the symptoms is, when you log into the zone, you can't move. The way to know for sure is, back down to an older version, like 940

Yep, almost beat you to it again, as I saw that mentioned either here or on Cavedude/Sesmar's forums and just checked which one I grabbed... 941...

Should I try an even older one that 940, or should 940 just do the trick?

[Angelox]

Actually I prefer 933, because most the quest globals features were working then - So I'd say 933.

[cutterjohn]

Well, I just jumped the gun and grabbed 940, renamed my old directory copied the maps, quests, startup batch file and the 2 config files over to 940. Installed the 2 IIRC minilogin files, ran it, logged in, and BANG! I can move my char forwards and backwards!

Does 941 work for anyone? If not, I really think that they ought to retract it's release status...

933: IIRC that was the one that cavedude recomended and said that he used on sesmar.net, but if 940 works ok for me I'll just go with it as I've nothing to lose at this point, other than more time...

Thanks for all the help.

EDIT:
oops missed the part about the quests, maybe I'll go grab 933 now then...

[Angelox]

940 is fine, just has some issues with quest globals is all, but if you ever use my database, you might miss out on some cool stuff.
In fact, here's my version of 940, I've been using it all week and it works fine;
http://www.nahunta.org/~angelox/file...940-source.rar
It's source, so you'd have to get someone to compile the executables for windows.
what i did was, revert the quest globals part of the source to what it was at 933 - the rest is 940.