EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   General::General Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=586)
-   -   New MiniLogin Release! (https://www.eqemulator.org/forums/showthread.php?t=27711)

image 03-29-2009 05:44 PM

Quote:

Originally Posted by neiv2 (Post 166734)
image:

<!-- Loginserver information. -->
<loginserver>
<host>localhost</host>
<port>5999</port>
<account>root</account>
<password>root</password>
</loginserver>

I forgot to add, you have the account root with the password root in plaintext in your login_worldservers table right? (account field="root" password="root")

neiv2 03-29-2009 06:00 PM

Yes, root is set as account and password in login_worldservers table. I changed the host under Loginserver information in eqemu_config.xml to 127.0.0.1 as suggested, with the same results.

image 03-29-2009 06:01 PM

seems like a configuration issue it is kind of hard to tell why, no reason for it to connect and not connect unless it wasn't up.

neiv2 03-29-2009 06:15 PM

Just to clarify my assumptions:

1. The minilogin db should be a separate db from the peq db, correct? In other words, I assume this is not a matter of simply including the tables created from the loginserverdb.sql into the existing peq db.

2. The db created from the loginserverdb.sql file ca be any name I want it to be, correct? In this case, I've named it minilogin.

3. The db created from the loginserverdb.sql file contains 4 (and only 4) tables: login_accounts, login_authchange, login_worldservers, and variables, correct?

4. I'm using Navicat to view my dbs, and while PEQ and Minilogin are separate dbs, they both appear under the same connection (called EQEMU). Is that kosher? Or is this what you were referring to when you said they had to be in different directories?

Thanks.

image 03-29-2009 06:19 PM

Quote:

Originally Posted by neiv2 (Post 166758)
Just to clarify my assumptions:

1. The minilogin db should be a separate db from the peq db, correct? In other words, I assume this is not a matter of simply including the tables created from the loginserverdb.sql into the existing peq db.

I would suggest them being in a different database, it is not completely necessary but the variables table will conflict

2. The db created from the loginserverdb.sql file ca be any name I want it to be, correct? In this case, I've named it minilogin.

That is fine

3. The db created from the loginserverdb.sql file contains 4 (and only 4) tables: login_accounts, login_authchange, login_worldservers, and variables, correct?

Yes


4. I'm using Navicat to view my dbs, and while PEQ and Minilogin are separate dbs, they both appear under the same connection (called EQEMU). Is that kosher? Or is this what you were referring to when you said they had to be in different directories?

I mean a seperate directory for my version of the MiniLogin, patch_6.2.conf, db.ini, LoginServer.ini, MiniLogin.exe should be in their own dir

Thanks.

. go quotes .

neiv2 03-29-2009 06:22 PM

All systems go on that front. I will try playing with some other settings.

guitar weazel 03-29-2009 06:25 PM

Noob question bout the minilogin
 
Hey guys, first want to say AWESOME JOB on the whole minilogin project. But I do have a couple of questions. I currently am using the public login right now. If I dl the new minilogin, will I lose my toons that I have on the public login servers. If not, can I use whichever login i want to use without having to make 100 changes to my files. Also, ive read that there is a download for people who dont want to host a server, just have access to play on the mini login servers. Could someone post a link for this please. Thanx for all you help guys, much appreciated. Again, great job on the minilogin guys, hope it turns out to be a huge success.

neiv2 03-29-2009 06:27 PM

Here is the contents of my db.ini file:

[Database]
host=localhost
user=root
password=root
database=minilogin

Should this be pointing to my minilogin db or my peq db?

neiv2 03-29-2009 06:31 PM

I should clarify, that is the db.ini file in the NewMiniLogin folder.

image 03-29-2009 06:31 PM

to the minilogin db..

Still once again, it was reporting as connecting to the LS, but then disconnecting afterwards? Would be nice to see the whole output of both world and login.

neiv2 03-29-2009 07:13 PM

The sequence is this:

1. launch start.bat. This launches World.exe and EQlaunch.exe. World.exe reports "could not connect to login server." EQlaunch.exe connects to world server.

then . . .

2. Launch minilogin.exe. World.exe reports "Connected to loginserver."

3. minilogin.exe reports "Unknown loginSOPcode"

image 03-29-2009 07:38 PM

Quote:

Originally Posted by neiv2 (Post 166781)
The sequence is this:

1. launch start.bat. This launches World.exe and EQlaunch.exe. World.exe reports "could not connect to login server." EQlaunch.exe connects to world server.

then . . .

2. Launch minilogin.exe. World.exe reports "Connected to loginserver."

3. minilogin.exe reports "Unknown loginSOPcode"

Sorry, I am not familiar with this EQlaunch.exe, someone else will need to help you with that. It doesn't sound like you are using my login server since it should be able to find that opcode or you don't have patches_6.2.conf in there. It is at http://eqemu.devnoob.com/downloads/NewMiniLogin.zip

neiv2 03-29-2009 07:42 PM

World log:
Code:

---------------------------------------------
[03.29. - 17:28:01] Starting Log: logs/eqemu_debug_world_7588.log
[03.29. - 17:28:01] [WORLD__INIT] Loading server configuration..
[03.29. - 17:28:01] [WORLD__INIT] Log settings loaded from log.ini
[03.29. - 17:28:01] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[03.29. - 17:28:01] [WORLD__INIT] Connecting to MySQL...
[03.29. - 17:28:01] [WORLD__INIT] Starting HTTP world service...
[03.29. - 17:28:01] [WORLD__HTTP] Loaded mime types from mime.types
[03.29. - 17:28:01] [WORLD__INIT] Loading variables..
[03.29. - 17:28:01] [WORLD__INIT] Loading zones..
[03.29. - 17:28:01] [WORLD__INIT] Clearing groups..
[03.29. - 17:28:01] [WORLD__INIT] Clearing temporary merchant lists..
[03.29. - 17:28:01] [WORLD__INIT] Loading items..
[03.29. - 17:28:05] [WORLD__INIT] Loading guilds..
[03.29. - 17:28:05] [RULES__CHANGE] Loading rule set 'default' (1)
[03.29. - 17:28:05] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 250
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 0.7500000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:DeathExpLossLevel to value 10
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 86400000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 120000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 95000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:PetSpellAggroMod to value 10
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:SongAggroMod to value 33
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:SpellAggroMod to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.0300000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0600000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ConsumptionMultiplier to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Spells:AutoResistDiff to value 15
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Spells:ResistChance to value 2.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Spells:ResistMod to value 0.4000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Spells:PartialHitChance to value 0.7000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Combat:ClientBaseCritChance to value 0.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Zone:NPCGlobalPositionUpdateInterval to value 60000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule NPC:MinorNPCCorpseDecayTimeMS to value 600000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule NPC:MajorNPCCorpseDecayTimeMS to value 1200000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Zone:GraveyardTimeMS to value 1200000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Zone:EnableShadowrest to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZWhenLoading to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZAtWaypoints to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZWhenMoving to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZOnSendTo to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Zone:ClientLinkdeadMS to value 180000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule NPC:UseItemBonusesForNonPets to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaSendTo to value 20.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaLoading to value 20.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaMoving to value 20.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaWaypoint to value 20.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:HealOnLevel to value false
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:FeignKillsPet to value false
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemManaRegenCap to value 15
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemHealthRegenCap to value 15
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Combat:UseIntervalAC to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Combat:PetAttackMagicLevel to value 30
[03.29. - 17:28:05] [RULES__CHANGE] Set rule NPC:SayPauseTimeInSec to value 10
[03.29. - 17:28:05] [RULES__CHANGE] Set rule NPC:OOCRegen to value 0
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:SmartAggroList to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:SittingAggroMod to value 35
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:MeleeRangeAggroMod to value 20
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:CurrentTargetAggroMod to value 0
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:CriticallyWoundedAggroMod to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:SlowAggroMod to value 450
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:IncapacitateAggroMod to value 500
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Aggro:MovementImpairAggroMod to value 175
[03.29. - 17:28:05] [RULES__CHANGE] Set rule NPC:BuffFriends to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:DeathItemLossLevel to value 10
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Watermap:CheckWaypointsInWaterWhenLoading to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Watermap:CheckForWaterAtWaypoints to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenMoving to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Watermap:CheckForWaterOnSendTo to value false
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenFishing to value true
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Watermap:FishingRodLength to value 30.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Watermap:FishingLineLength to value 40.0000000000000
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemDamageShieldCap to value 30
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemAccuracyCap to value 150
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemAvoidanceCap to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemCombatEffectsCap to value 100
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemShieldingCap to value 35
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemSpellShieldingCap to value 35
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemDoTShieldingCap to value 35
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemStunResistCap to value 35
[03.29. - 17:28:05] [RULES__CHANGE] Set rule Character:ItemStrikethroughCap to value 35
[03.29. - 17:28:05] [WORLD__INIT] Loaded default rule set 'default'
[03.29. - 17:28:05] [WORLD__INIT] Loading EQ time of day..
[03.29. - 17:28:05] [WORLD__INIT] Loading launcher list..
[03.29. - 17:28:05] [WORLD__INIT] Reboot zone modes ON
[03.29. - 17:28:05] [WORLD__INIT] Deleted 0 stale player corpses from database
[03.29. - 17:28:05] [WORLD__INIT] Deleted 0 stale player backups from database
[03.29. - 17:28:05] [WORLD__INIT] Zone (TCP) listener started.
[03.29. - 17:28:05] [WORLD__INIT] Client (UDP) listener started.
[03.29. - 17:28:05] [NET__IDENTIFY] Registered patch 6.2
[03.29. - 17:28:05] [NET__IDENTIFY] Registered patch Titanium
[03.29. - 17:28:05] [NET__IDENTIFY] Registered patch Anniversary
[03.29. - 17:28:05] [NET__IDENTIFY] Registered patch Live
[03.29. - 17:28:05] [WORLD__LS] Connecting to login server...
[03.29. - 17:28:06] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect(): connect() failed. Error: 10061
[03.29. - 17:28:15] [WORLD__LS] Connecting to login server...
[03.29. - 17:28:16] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect(): connect() failed. Error: 10061
[03.29. - 17:28:21] [WORLD__ZONE] New TCP connection from 127.0.0.1:2000
[03.29. - 17:28:21] [WORLD__CONSOLE] New launcher from 127.0.0.1:2000
[03.29. - 17:28:21] [WORLD__LAUNCH] Adding pending launcher 1
[03.29. - 17:28:21] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.
[03.29. - 17:28:21] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[03.29. - 17:28:25] [WORLD__LS] Connecting to login server...
[03.29. - 17:28:26] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[03.29. - 17:28:26] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect(): connect() failed. Error: 10061
[03.29. - 17:28:35] [WORLD__LS] Connecting to login server...
[03.29. - 17:28:35] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[03.29. - 17:28:40] [WORLD__ZONE] New TCP connection from 127.0.0.1:2005
[03.29. - 17:28:40] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:2005
[03.29. - 17:28:40] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zone
[03.29. - 17:28:40] [WORLD__ZONE] [1] Auto zone port configuration.  Telling zone to use port 7000
[03.29. - 17:28:48] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[03.29. - 17:28:49] [WORLD__ZONE] New TCP connection from 127.0.0.1:2007
[03.29. - 17:28:49] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:2007
[03.29. - 17:28:49] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zone
[03.29. - 17:28:49] [WORLD__ZONE] [2] Auto zone port configuration.  Telling zone to use port 7001
[03.29. - 17:28:52] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[03.29. - 17:28:52] [WORLD__ZONE] New TCP connection from 127.0.0.1:2009
[03.29. - 17:28:52] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:2009
[03.29. - 17:28:52] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zone
[03.29. - 17:28:52] [WORLD__ZONE] [3] Auto zone port configuration.  Telling zone to use port 7002
[03.29. - 17:28:54] [WORLD__ZONELIST] Removing zoneserver #3 at :7002
[03.29. - 17:28:54] [WORLD__ZONELIST] Hold Zones mode is ON - rebooting lost zone
[03.29. - 17:28:54] [WORLD__ZONELIST] Removing zoneserver #2 at :7001
[03.29. - 17:28:54] [WORLD__ZONELIST] Hold Zones mode is ON - rebooting lost zone
[03.29. - 17:28:54] [WORLD__LAUNCH] zone: dynamic_02 reported state STOPPED (1 starts)
[03.29. - 17:28:54] [WORLD__LAUNCH] zone: dynamic_03 reported state STOPPED (1 starts)
[03.29. - 17:28:54] [WORLD__ZONELIST] Removing zoneserver #1 at :7000
[03.29. - 17:28:54] [WORLD__ZONELIST] Hold Zones mode is ON - rebooting lost zone
[03.29. - 17:28:54] [WORLD__LAUNCH] Removing launcher zone (1)
[03.29. - 17:28:55] [WORLD__LS] Connecting to login server...
[03.29. - 17:28:56] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect(): connect() failed. Error: 10061


image 03-29-2009 07:44 PM

Looks like you are having some really strange connection issues there lol..

[03.29. - 17:28:26] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect(): connect() failed. Error: 10061
[03.29. - 17:28:35] [WORLD__LS] Connecting to login server...
[03.29. - 17:28:35] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999

I am not really sure what to tell you, its there but it doesn't stay connected :P

How 'stable' would you call your system right now heh

neiv2 03-29-2009 07:47 PM

That's the zip file I am using. In my folder are:

1. db.ini
2. patch_6.2.conf
3. LoginServer.ini
4. README.TXT
5. loginserverdb.sql
6. MiniLogin.exe

Is there a different startup sequence I should be using than what I've indicated?

image 03-29-2009 07:48 PM

MiniLogin.exe should be started before World.exe thats it.

neiv2 03-29-2009 07:50 PM

Quote:

I am not really sure what to tell you, its there but it doesn't stay connected :P How 'stable' would you call your system right now heh
Well, it works fine with the public LS (when it's up) : )

I'm sure it's just that I have not connected the pieces in the right way.

neiv2 03-29-2009 07:56 PM

Here's what the minilogin.exe is producing:

image 03-29-2009 08:08 PM

Ok are you sure you have an entry in the login_worldservers table for the account root and password root as instructed by the readme.txt? Otherwise I am not sure.

Can you re-download and get the new version see if it works better? Thats all I can suggest at this point.

neiv2 03-29-2009 08:23 PM

Okay, I think I found part of the problem. Start.bat executes both World.exe and eqlaunch.exe. I assume eqlaunch.exe is the login server for peq? In any case, I tried launching world.exe independently after launching minilogin.exe, and at least I am no longer getting the hash table effect. World maintains a stable connection and minilogin simply says "here10!"

Now, when I launch starteq.bat (which contains the single line eqgame.exe patchme), it launches what appears to be the Public LS (with the pic of the werewolf and the full moon). It asks for my station username and station password, but does not recognize it when I enter it.

Is this the screen I should see at this point? If so, is the username and password the one I registered on the website, or is it the new one I created in the login_accounts table (which happen to be the same in this case)? Or is it something else?

image 03-29-2009 08:26 PM

LS and world connection sound good, here10! is hitting the user/pass (Gotta love the old checks we had in there). Just haven't fixed em.

Anyway, I don't know about the next part, as long as your eqhost.txt is updated to use your server I think you should be ok?

neiv2 03-29-2009 08:38 PM

Just so I don't miss it, what exactly should the host=?

image 03-29-2009 08:41 PM

you can try 127.0.0.1:5999 (this is assuming you didn't change the port in LoginServer.ini). I am not sure if it is picky about the localhost ip. Otherwise you can use your LAN ip.

neiv2 03-29-2009 08:57 PM

Yeah, none of that is working. I suspect I still have something pointed in the wrong direction. I've got:

1. for db.ini (NewMiniLogin)
# READ README.TXT!
[Database]
host=127.0.0.1
user=root
password=root
database=minilogin

2. for eqhost.txt:
[LoginServer]
Host=127.0.0.1:5999

3. for the eqemu_config.xml
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>root</account>
<password>root</password>
</loginserver>

Does this look right?

Yeormom 03-29-2009 09:00 PM

Yes. Output what you see in the login console, imo.

image 03-29-2009 09:02 PM

I think that eqlaunch isn't what you need.. There is nothing wrong with that setup.

just run eqgame.exe
Start->Run
"C:\program files\sony\everquest\eqgame.exe" patchme
Click OK

Aldest 04-03-2009 02:08 PM

Hmmm
 
I've been trying to get this working today. I've made some progress on it. My world server appears to be connecting to my login server correctly:

Quote:

Using database 'eqemuls' at 127.0.0.1
Opcode OP_GuildManageRemove is missing from patch_6.2.conf
Opcode OP_GuildManageAdd is missing from patch_6.2.conf
Opcode OP_GuildManageStatus is missing from patch_6.2.conf
Opcode OP_CloseContainer is missing from patch_6.2.conf
Opcode OP_VetRewardsAvaliable is missing from patch_6.2.conf
Opcode OP_Rewind is missing from patch_6.2.conf
Opcode Op_LoginUnknown1 is missing from patch_6.2.conf
Unable to open opcodes file 'patch_Titanium.conf'. Thats bad.
Unable to open opcodes file 'patch_Anniversary.conf'. Thats bad.
Unable to open opcodes file 'patch_Live.conf'. Thats bad.
Custom IP Address: 5.2.52.138
LoginServer.ini read.
Server mode: Private Login
============================
EQEmu Private Login v1.02PL
http://eqemu.devnoob.com
============================
Connected to Central Stats Server
Resolved 5.2.52.138 to -1976303099
Login server listening on port:5999
Valid auth packet -- this is a genuine stats server.
World has connected with account name: GM
Quote:

[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: 5.2.52.138:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:2355
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:2355
My test user is unable to connect though. He is getting a un/pw error. I did add him with md5. Any thoughts?

Aldest 04-03-2009 02:45 PM

Ignore the above post.

We're good to go now. I just have to figure out how to have my new schema reference my old one so that characters show up on the appropriate accounts.

Angelox 04-03-2009 04:23 PM

Here's how I converted my accounts;
First you need something like Navicat so you can make a custom sql of the database's account table.
With Navicat, go to your account table, select id, name and password only, dump them into an sql.
You should see entries that look like this;
Code:

INSERT INTO account
  (`id`, `name`, `password`)
VALUES
  (31, 'myname', 'mypassword');

So you have to convert the password to encrypted and change table to point to login_accounts . Here's the script for that;

convert_account.pl
Code:

  #!/usr/bin/perl
    open(MYFILE,"./account.sql") || die "Couldn't open the file!\n";
    @Lines=<MYFILE>;
    close MYFILE;
    for(@Lines){
    s/account/login_accounts/;
    s/', '/', md5('/;
    s/'\);/'));/;
    #s/\(oldtext\)/\(newtext\)/;
    print $_;
    }

Run perl convert_account.pl > login_accounts.sql

Now, open login_accounts.sql, and it should look like this;
Code:

INSERT INTO login_accounts
  (`id`, `name`, `password`)
VALUES
  (31, 'myname',  md5('mypassword'));

Run this on a clean login_accounts and you'll be gtg.
This is for Minilogin users that already have Minilogin passwords in their table.
In my case I have 132 accounts (it grew some) this converted them in a flash.

Quote:

Originally Posted by Aldest (Post 167048)
Ignore the above post.

We're good to go now. I just have to figure out how to have my new schema reference my old one so that characters show up on the appropriate accounts.


Aldest 04-03-2009 04:35 PM

Thank you Angel, I'll try this out and report back.

Do I even need to include IP or is that filled in by the server?

Angelox 04-03-2009 04:41 PM

Actually, if you had an account list with no passwords (because you never used minilogin), you could still make a script for inserting passwords to the accounts.

Aldest 04-03-2009 04:50 PM

I have the password field but I just put "mini" into all of them. I didn't know why the field was there.

Angelox 04-03-2009 05:49 PM

The only fields you need are the ones I mentioned - the rest can use default settings - heres an sql script for setting a new password;
Code:

UPDATE login_accounts SET password=md5("newpassword") WHERE name = 'joeblow';
I haven't tested it yet, so you might have to play with the syntax.

You could default all your passwords to 'mini' then have them email you their username with new password if they want it changed.

You could also get real 'fancy' and set up a php page so they can do it themselves (anybody does this, I want a copy too!)



Quote:

Originally Posted by Aldest (Post 167054)
Thank you Angel, I'll try this out and report back.

Do I even need to include IP or is that filled in by the server?


Aldest 04-03-2009 06:36 PM

Ok, total victory now.

The "isaccount_id" field just needed the numbers from the login and password.

Everyone is working but the GM account that is actually local is unable to connect.

Quote:

Error in CreateAccount query 'INSERT INTO account SET name='GM', status=0, lsacc
ount_id=1;' #1062: Duplicate entry 'GM' for key 2
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'GM', d
uplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '71'
Removing connection
I believe I saw this in an earlier post. I'm going to go back through.

Sylaei 04-10-2009 06:46 PM

Is the new minilogin no longer available? I was looking forward to actually being able to run a test server and real server at the same time.

Aergad 04-13-2009 03:15 PM

the minilogin was canceled because image relased a new better pricate login server which is basicly a fully fledged loginserver check http://eqemu.devnoob.com for more details

Sylaei 04-13-2009 09:49 PM

Thanks Aergad, I found that version. It phones home with statistics. Sorry, but Microsoft spys on me enough as it is, I try hard not to use software like that. I'm not saying anything against the work Image has done, which is awesome, just that I don't like that kind of stuff.

image 04-13-2009 09:51 PM

Lol, take out the last two lines in LoginServer.ini, statsaddress and statsport.

It isn't "phoning home" it is sending public statistics http://eqemu.devnoob.com/register/status.php

no different than what EQEMu's main site used to have. Just now its with login servers and worlds :)

Edit: Should read the README.TXT sometime :)

Yeormom 04-13-2009 10:41 PM

I would try to install but I can't pass the "Genuine Advantage Tool by Image"

Please help!!!!!!1!11one1

Sylaei 04-14-2009 01:26 AM

Image, thanks for the heads up. I read on the site that it sent the statistics back and quit there. I'll browse the readme.


All times are GMT -4. The time now is 03:26 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.