New MiniLogin Release!

[image]

Hi Everyone,

I wanted to announce that after a few hours of gruesome programming, I have a login server available for you all to work with your Titanium clients.

This MiniLogin is limited to 20 authenticated users (that is by username/password) and 3 world accounts (also required to be authenticated by username/password).

Enjoy!

http://eqemu.devnoob.com/downloads/NewMiniLogin.zip

http://www.universalconquestonline.com/lswork.jpg

PS. I want my $100, thanks :P

[leslamarch]

PS. I want my $100, thanks :P

Let me have 33 users and 1 world and your paypal account email address and you will have triple that :)

[image]

Lol exactly 33 users and just 1 world server? Thats an awkward request :P

[Angelox]

So what are we talking about here - by more users you mean more servers can hookup to the Mini LS? and the world account would mean how many times the same IP or Account (can hook up)? And just to be sure, it only accepts Titanium, or will it accept the other versions available?

[Sakrateri]

First problem post lol

what this mean ?

Error in CheckWorldVerAuth query 'SELECT approval FROM login_versions WHERE vers
ion='0.7.0';' #1146: Table '70login.login_versions' doesn't exist
Bad Version (soft): #2 127.0.0.1:4894


Im using a 7.0 server ?

[Sakrateri]

also getting this too.

Error importing functions from EQCrypto.dll.

[neiv2]

Outside of the readme file, is there any documentation that would assist the non-techie in the setup of this LS? I am toying with the decision of moving to the mini-LS since game play on my server is really just for family and friends. A step-by-step guide akin to the server setup guide would be groovy.

[Angelox]

You can go get leslamarch's install package from my site (http://forums.nahunta.org/index.php), all you have to do is run the install, and the rest is done - you'll be able to choose between ax classic or peq database (via option).

[image]

Sakrateri: Your first error you seem to be getting because your database doesn't recongize to just let the world server connect if the table does not exist... I am not sure why..

CREATE TABLE `login_versions` (
`version` char(16) NOT NULL default '',
`approval` int(11) NOT NULL default '0',
) TYPE=MyISAM;

insert into login_versions set version='0.7.0',approval=1;

Should fix your issue, add the version with a approval of 1 for any version you want to support.

The second error (Error importing functions from EQCrypto.dll.) you can ignore, those import functions are not used as the encryption is now hardcoded into the LS.

Secrets has tested this and says this supports Titanium + SoF.

If you run into issues logging into world from the login server, make sure the server is unlocked and you got the latest zip file above (Put up at about 3PM EST on March 22nd).

There is an issue with the server list where the IP is offset to the client, so it tries connecting to a bogus server.

[image]

So what are we talking about here - by more users you mean more servers can hookup to the Mini LS? and the world account would mean how many times the same IP or Account (can hook up)? And just to be sure, it only accepts Titanium, or will it accept the other versions available?

I can set the values to whatever I want for how many users/worlds can be used, this was just a number that was suggested to me.

World accounts can only connect as one otherwise they get ghosted, it will limit to 3.

Secrets says this works for Titanium and SoF.

[Angelox]

Thanks for your Minilogin image, we'll put it to good use!

[neiv2]

Angelox, does your instruction hold true even for a setup that already uses public LS? Just run the install and it's changed?

[Sakrateri]

Ok, Got the world and client to connect to minilogin but then I get this error in world

Account Attempting to be created:Skaramang 0
Error in CreateAccount query 'INSERT INTO account SET name='Skaramang', status=0
, lsaccount_id=2;' #1364: Field 'minilogin_ip' doesn't have a default value
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'Skaram
ang', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '71'
Removing connection

Any ideas? and thanks alot for this !

[Angelox]

Angelox, does your instruction hold true even for a setup that already uses public LS? Just run the install and it's changed?

The only change you have to make in your database would be to set the logintype to Minilogin in table variables

If you were referring to leslamarch's install package; the database, mysql, perl, and everything else is included and ready to use.

[neiv2]

Hmm . . . that will likely present a problem since my game has been extensively customized. I assume the install package would just overwrite everything. How do I maintain my customizations and still use the minilogin? Is there a separate install for that?

[devn00b]

You can get just the mini login from the link provided in the 1st post.

[neiv2]

Is there documentation on setup, aside from the readme file?

[image]

Not for the login server, but I believe they are planning on grouping this new MiniLogin with a package to make it easier for people to use.

I also wanted to update that 7:20PM there is a new build in that zip file, I believe I have fixed any server list issues. I was able to list 90+ servers without any hiccups so it seems promising.

[neiv2]

Yeah, the readme file assumes a knowledge of creating and populating a database that I just don't have. The peril of opening up an open-source community like this is that it invariably attracts technically-challenged people like me who have all kinds of creative interest and drive in game creation, but very little of the the wide technical knowledge required to know how to do all aspects on the technical side. We end up learning things like perl script and database modification by lots of explanation, tutorials and examples. Unfortunately, our knowledge ends up being a lot like someone speaking very broken English and not really understanding the underlying grammar.

[Angelox]

leslamarch has a great package for people who just want to play and not to have become a "programming master" in order to do so.
He keeps it all up to date with the latest from everybody. and you can backup/restore your characters to the updated databases. I'm sure you'll see the new MiniLogin Server included in the package soon.
No matter what you choose, If you want to keep your custom fixes, then you'll have to learn how to make SQL inserts and updates of your work, so you can patch them on to the newer database. We've all had to learn how to do this. The best way to learn is do a lot of Googling , and searching through the forums and wikki.
You can't expect to learn all this in a few hours - It takes patience.
Have you been making your custom fixes with the PHP Editor? if you have, you may already have the sql inserts you need in the log file it includes.

[neiv2]

Yeah, learning sql commands will probably be my next project. And no, I haven't been using an editor. I've just been modifying the db manually. I guess I'll need to backup my db, install the new version of the db, and experiment with how to insert my customizations after the fact.

[Aergad]

great job image i was wondering if there was any chance that this could be made to allow more users (not servers) or allow more user accounts atleast in the readme it says that, user accounts with an ID Greater then 20 wont work. I fully plan on using this but between my family and friends id need atleast 30-45 accounts allowed or people will have to share accounts.

Once again You and Devnoob did an awesome job, My hat is off to you

[image]

Yes it is possible and I am going to decide this week what I can do about people requesting special builds, I have gotten too many requests for me to just start streamlining builds for everyone, just a lot of work for me..

[Aergad]

any chance you could just make one with a higher player count or what not? if you need any assistance i am procidient in c++ and mysql if you need a hand with it at any point.

thanks alot though this is a HUGE step forward for the community

[Sakrateri]

Anyway for me to fix this error?

Account Attempting to be created:Skaramang 0
Error in CreateAccount query 'INSERT INTO account SET name='Skaramang', status=0
, lsaccount_id=2;' #1364: Field 'minilogin_ip' doesn't have a default value
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'Skaram
ang', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '71'
Removing connection

This is an error in world after I select the server and hit play...

Thanks again.

[number6]

Anyway for me to fix this error?

I'm playing with the minilogin at the moment and managed to reproduce and fix this. You need to alter the ls_accountid field in the accounts table for your user to match the id you gave your user in the minilogin database.

I'm still not getting into game but at least I'm at character select. I'm getting mysterious
*** glibc detected *** double free or corruption (out): 0xb17540f8 ***
messages so something else is wrong here (not the fault of minilogin probably, I'm trying to update my old server to the newest source).

[image]

Once you get into the world server it shouldn't have anything to do with the Login Server.

It is however true that your ID's may not match if you used an old login server or the public one. There isn't anything I can do about that, you usually should use a clean database to make sure that things are in synch.

Also please note this isn't a MiniLogin like the old logins. This is a full fleged Login Server with restrictions, so do not try to do IP authentication.

[number6]

Once you get into the world server it shouldn't have anything to do with the Login Server.
And indeed it wasn't. I had to add various database fields and fiddle with things to get my DB up to date.

I'm very happy to report that this minilogin works just fine for me, both with Titanium and SoF clients. Thank you very very much.

[devn00b]

And indeed it wasn't. I had to add various database fields and fiddle with things to get my DB up to date.

I'm very happy to report that this minilogin works just fine for me, both with Titanium and SoF clients. Thank you very very much.

Your welcome Very Very much

[Sakrateri]

That was it Number6 Thanks alot, all working great now, Thank you Image and Devnoob for this, This is awesome!

Devnoob you can finally take yourself out of the I hate Devnoob club after all these years :)

[devn00b]

That was it Number6 Thanks alot, all working great now, Thank you Image and Devnoob for this, This is awesome!

Devnoob you can finally take yourself out of the I hate Devnoob club after all these years :)

I know right?! Amazing!

[image]

Losing numbers in the I hate devn00b club is unacceptable! I will help increase the numbers back to norm.

[devn00b]

For every one that leaves...5 more crop up!! Guess I'll always be hated.

[Angelox]

I got a problem here, sort of know what it is, but not sure what to do.
You all using MySql 5.1x? I have MySql 5.0x
here's my problem;
After the variables table is made, I get this error;
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'
When attempting to run this line;
SET character_set_client = @saved_cs_client;
I'm thinking it's the version, or maybe it's because I have the old password method active?

[devn00b]

yeah stupid sql i think you can just remove that line from the sql file and it should load normally

[Angelox]

Thanks! I had an urge to do that but I wasn't sure, been researching that error for about an hour now (I found a lot of brick walls). I'll give it a run.

[image]

Yea you can ignore those, thats new MySQL stuff, don't ask me what for. You just need the default tables anyway.

[Aergad]

Just a side note you have to put the minilogin server into a seperate directory from your main eqemu server with all the files included in the zip file for it to work

[warhawk]

I'm having trouble sourcing the SQL. This bit seems to cause a 1064 error:-

DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
`varname` varchar(25) NOT NULL default '',
`value` text NOT NULL,
`information` text NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT;


Any Ideas?

[image]

DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
`varname` varchar(25) NOT NULL default '',
`value` text NOT NULL,
`information` text NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM;

Remove " DEFAULT"

[warhawk]

Bah, simple when you know how :D

Thanks Image!

[warhawk]

Hi again

I'm still struggling to get this working.

I'm getting the following error on the minilogin shell.
Error in CheckWorldVerAuth query `SELECT approval From login_versions Where version=`0.7.0`;`
#1146: Table `peq.login_versions` does not exist
Bad Version <soft>: #1 192.168.11.53:4972


World.exe shows

[WORLD__LS] Connecting to login server...
[WORLD__LS] Setting World to MiniLogin Server type
[WORLD__LS] Connected to Loginserver: 192.168.11.53:5999
[WORLD__LS_ERR] Login server responded with FatalError. Disabling reconnect.
[WORLD__LS_ERR] Incorrect version

I`ve ran in the loginserver.sql and configured the db.ini. Also ensuring that the its set to minilogin in the variables DB.

Any help would be great.

Thanks

War

[Angelox]

[WORLD__LS] Setting World to MiniLogin Server type


You gotta set it to Public, not MiniLogin (it's in Variables)

[image]

The MiniLogin type will work I think, it just seems to have more checks like the world version and such :)

[Angelox]

I can set the values to whatever I want for how many users/worlds can be used, this was just a number that was suggested to me.

World accounts can only connect as one otherwise they get ghosted, it will limit to 3.

Secrets says this works for Titanium and SoF.

Anyway I'm still unsure about this, but what I'm looking for in this new mini-login, is unlimited user/player accounts. the reason for this is I already have hundreds of users for the AX_CLASSIC Server Repack (probably still have people that use my older MiniLogin package too), and they already have their characters and accounts made (the REPACK updates characters to newer versions of DB). My test server, which I don't promote and use at home, has 126 accounts - I need to protect those too, as I see people playing there.

I would even be willing to trade this feature off with only one game server able to connect LS. I would still greatly benefit because it has a true account system that doesn't require the old ip system

Three game servers hooked up to the LS would be nice, I could bring back my old ax_peq , and even some other old DB i was thinking of resurrecting.

Unlimited would be even nicer , all us "Minilogin" people could hook up with each other if we wanted.

But it's not needed - a true account system that doesn't require the old ip system is what I need, I think this wouldn't burst anybody's bubble.

[image]

Well the 'eqemu team' from what I understand was not too encouraged with the new minilogin, I am waiting on them to decide the next course of action for the login server since from what I read they are considering that as one option. I would rather they made that decision first, but if things continue to stall like they have who knows.

[Angelox]

Well, Like I said nerf it down to one server on the LS.
Give me a good account system that doesn't require the old ip system . That's not asking for nothing other than an upgrade to the old Minilogin.
They can't feel threatened by that!

[image]

They didn't even like the idea that it authenticated user/pass.

Besides the point, if there was a public LS where you had unlimited accounts that anyone could get, it would be time for a login server list. I think if the LS is released to the public it should be a responsible release. Eg. there is some way for everyone to know about all login servers (that people host and want public), and some generic method for handling user accounts (this is more tricky and may not be possible). But a public server list would be key.

[Aergad]

Isnt the server discussion area for precisly that listing your servers?

PLEASE relase a minilogin that has a good number of users allowed me personally im with angelox i only want one world server and a good ammount of accounts allowed black hand of doom had over 700 accounts before the change to your minilogin

[Aergad]

oh one matter of note i tested the old minilogin theres no limit on users if there is supposed to be it doesnt work lol i made a ton of accounts and could login to one with a id of 199 in the database

[image]

Thats not really what I was getting at, some emulators have automatic server list that show user count and such. So you would have an 'active' list of login servers that you know are up.

[Aergad]

well that wouldnt be hard to make at all wouldnt really be any different then making a page for account registration cept the server list page pings the ls listed in the database and shows if its up or down pretty simple php script to be honest

[image]

No heh...

I am not talking some shared login server, likely if everyone had their own login it would be individual user/passwords (that is an issue). But what im saying is each individual LS will try uplinking with a stats server and upload their current users/world information. Then a website can populate all that out.

Just to make it easy for the userbase to find reliable login servers and such.

[Aergad]

I think if you gave people the option of autonomy (which obviously alot of people would like) from the "official" LS same as minilogin works now but with username and password authentication most people would still use the two public Loginservers, the only people that would change to the new improved minilogin would be people that either already use the currrent one or that are new users wanting a private server.

SoD has thier own login server and they are quite popular and autonomous they dont host anything on their ls but their own server and that is waht most people who want to use the minilogin option want i think.

[Aergad]

that makes sense I personally wouldnt want to host any more world servers then my own so a minilogin with one world and a healthy ammount of user accounts allowed would be ideal for me and i think angelox as well.

I dont really want the responsibility of worrying about other peoples uptime if that makes sense

[image]

Maybe if there was more community involvement on this decision I would agree with it more but at this point its a small percentage voicing their opinion about public LS. There seems to be a few that want to keep it the way it is but ofcourse with a more reliable central LS.

But I am not sure I totally agree this should be the decision of the elite either... just saying.

[Aergad]

Well most people have always used the public LS is the wayi understand it. Some prefer minilogin but im thinking that the people that use minilogin dont spend much time on the forums unless they are having a problem with it

Personally I dont see what their issue is with you releasing a decent updated minilogin personally I mean having done some googling it was yours to do with what you wish anyway originally. Even with unlimited accounts and 3 world servers its not like they would have to worry about competition from the general end user.

Like i said I think if you limit the world accounts to one only for minilogin then that should satisfy everyone, you have a new public LS opion up for the public ls users, and a good secure minilogin option for the minilogin users

But you are right It shouldnt be an elitist decision either

[Asram]

I'm with Angelox that an account-based (rather than IP-based) minilogin would be a great boon for the minilogin users. I don't think that's the part of the design that's causing the consternation though, right?

It's the effect of federating the servers and the potential problem of duplicate account names, right?

[neiv2]

Well, I'm trying to set up the minilogin, and think I've figured out the readme file so far; but I have a question about two instructions:
insert into login_accounts set name='username',password=md5("yourpassword"),user_active=1;

I set the user_active field at 1, but I'm not sure just what specifically I need to put for the name and password. Are the above settings ('username' for name and md5("yourpassword") for password) literal strings to be entered into these fields, or do they represent variables? In other words, do I replace 'username' with my own username and md5("yourpassword") with my own password, or do I type these lines in as literal strings into the db? My guess is that these are variables, but "md5" just seems like a strange way to note a variable.

Also . . .
insert into login_worldservers set account='accountname',password='yourpassword',name ='Public Name';
Same question as before. Is 'accountname' my account, or is it a literal string of characters to be entered into the db? Same question for 'Public Name'.

I appreciate any help with this.

[Aergad]

you set them to whatever you want them to be they are not variables user_active must be set to 2 or you cant login makle sure you ONLY Change yourpassword to what you want the password to be DO NOT REMOVE md5("") that is the encryption of the password and MUST Be there

[image]

insert into login_accounts set name='username',password=md5("yourpassword"),user_ active=1;

Replace username with the name you want your account to be.
Replace yourpassword with the password you want to use, md5 is an encryption technique.
The user_active field makes sure you can login, if it is 0, it will not let you.

insert into login_worldservers set account='accountname',password='yourpassword',name ='Public Name';
Replace accountname with a account you will use in your eqemu_config.xml under <account>
Replace your password with an account password which will also be reflected in the eqemu_config.xml
The contents of name do not matter as far as I remember, this just needs to have something there.

[neiv2]

Thanks for the help. I see there is some conflict in the information. Is it user_active=2 (per Aergad), or user_active=1 (per the readme file)?

[image]

Any value that is not 0 should make the user active, but in reality it should be 1.

[neiv2]

Thanks again. One more clarification. You wrote:

"Replace accountname with a account you will use in your eqemu_config.xml under <account>"

Here is the contents of my eqemu_config.xml (names and password have been changed). Which piece of information are you calling the "accountname"? Is it the shortname, the username, something else?
<?xml version="1.0">
<server>
<world>
<shortname>NAME</shortname>
<longname>LONG NAME</longname>

<!-- 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>username</username>
<password>password</password>
<db>peq</db>
</database>
</server>

[Aergad]

it should look something like


<?xml version="1.0">
<server>
<world>
<shortname>name</shortname>
<longname>Name of your server</longname>

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

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>loginserver</host>
<port>5999</port>
<account>accountname</account>
<password>password</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="enable"/>

<!-- 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="true" mimefile="mime.types" />
</world>

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

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

<zones>
<defaultstatus>0</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7099"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>xxx.xxx.xxx</host>
<port>3306</port>
<username>xxxxx</username>
<password>xxxxxx</password>
<db>newpeq</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>

[neiv2]

Do I need to change my host or port settings? I noticed they are different from yours.

[Aergad]

well yeah tailor it how you need to but itll work if you set what i posted up properly

[neiv2]

Hmm . . . not working.

On the start.bat I'm getting "[world_LS_ERR] Unable to resolve 'loginserver' to an IP."

On the minilogin.exe, I'm getting "Error in LoadWorldList query 'Select ID, account, name, admin_id, greenname from login_worldservers where showdown=1' #1146: Table 'peq.login_worldservers' doesn't exist."

Also, minilogin.exe is reporting lots of missing Opcodes from patch_6.2 conf, patch_Titanium.conf, patch_Anniversary.conf, patch_Live.conf, and error importing functions from EQCrypto.dll.

I'm certain I have something wrong here.

[Aergad]

you have to make the table and you need to set loginserver to either the actual hostname (like eqemulator.net) or the ip of your loginserver ignore the errors about the conf and make sure you DONT put the loginserver in the same folder as the emu server files/ check the readme and all your settings in eqemu_config.xml

[neiv2]

I'm using the readme file for the NewMiniLogin; to wit:
Welcome to the NEW MiniLogin!

Brought to you by Image and Devn00b.

This new MiniLogin is limited to 20 users authenticated by username/password.
There is also a 3 world limit which is enforced by authorized worlds only (user/pass).

Any world server without a user/pass will connect, but not be listed. Same goes for a server with ID > 3.

Green servers do not work at this time, user reporting may only be presented when first logging in.

Create a new database using the contents of loginserverdb.sql

For a new user (PLEASE NOTE: the ID field cannot be greater than 20 or the user will fail login) :

insert into login_accounts set name='username',password=md5("yourpassword"),user_active=1;

For a world server (PLEASE NOTE: the ID field cannot be greater than 3 or the world will not list):

insert into login_worldservers set account='accountname',password='yourpassword',name ='Public Name';
As far as I can tell, I have followed this to the letter. I would love to use yours, Angelox, but I can't have my db overwritten (any chance of separating out the minilogin by itself?).

Aergad wrote: "you have to make the table . . . "

The login_worldservers table does exist, but not under the peq db (as the error message indicates). The readme file says to create a "new" db, so that's what I did (I named the db "minilogin"). It is a separate db from my "peq" db, and it does contain the table in question. Did I misinterpret something? Is there a setting that is wrong? Do I need to point something in a different direction?

Aergad wrote: " . . . and you need to set loginserver to either the actual hostname (like eqemulator.net) or the ip of your loginserver"

Where exactly do I set this? There seems to be no place in the table to set this. Is this in the eqemu_config.xml file?

Aergad wrote: "make sure you DONT put the loginserver in the same folder as the emu server files"

They are in separate folders.

Aergad wrote: "check the readme and all your settings in eqemu_config.xml"

I thought I did all that.

[neiv2]

Okay, I changed the default host in the db.ini to localhost, and now the error message is CheckWorldVerAuth . . . Table 'peq.login_versions' doesn't exist. I cannot find that table in either my peq db nor in my minilogin db.

Also World.exe is reporting, Could not connect to login server: TCPConnection::connect<>: connect<> failed. Error: 10061

[image]

I am not familiar with the PEQ database really, but you still need the tables included with the mini-login release. The CheckWorldVerAuth is because you have some database flag for MiniLogin, this is a regular Login Server. I think that was explained previously.

[neiv2]

I created the minilogin db from the supplied .sql file in the NewMiniLogin folder, per the instructions in the readme file. After creation, I found that (my version of) the minilogin db contains four tables: login_accounts, login_authchange, login_worldservers, and variables. Are there supposed to be others?

[image]

You gotta set it to Public, not MiniLogin (it's in Variables)

Quoting previous post.

[neiv2]

The CheckWorldVerAuth is because you have some database flag for MiniLogin, this is a regular Login Server.
So, no change in the variables table from public to minilogin? I must have missed that one.

EDIT:

Ah, my bad.

[neiv2]

I changed it back to Public. Here's the latest:

1. World.exe reporting [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect<>: connect<> failed. Error: 10061

2. EQLaunch.exe reporting Connected to World: Localhost:9000

3. Minilogin.exe reporting . . .
Server mode: Standalone.
Login server listening on port:5999
here10!
Unknown LoginSOPcode: 0x3002 size:33

This is followed by what appears to be some sort of hash table for 0, 16 % 32.

Once Minilogin.exe is launched, World.exe reports "connected to loginserver: localhost:5999"

No login screen actually appears.

[image]

eqemu_config.xml what do you have for the login server.

[neiv2]

image:

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

[image]

Ehh im not so sure localhost is good to use... try 127.0.0.1

[image]

Image I haven't even tested your MiniLogin yet, reason being, I got a few people playing on what I have now, and don't want to ruin their play. I started to yesterday, but the limited account, just won't work for me.
I guess, I'm going to have to separately set up a new server/database so no one will get affected, your new Minilogin in the package still would be great for anyone who doesn't have accounts they want preserve.

Not sure if this was intended for this post, but I did send you a PM a while ago Angelox.

[image]

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]

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]

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]

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]

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]

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

[guitar weazel]

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]

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]

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

[image]

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]

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]

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]

World log:
---------------------------------------------
[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]

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]

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]

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

[neiv2]

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]

Here's what the minilogin.exe (http://www.scinc.com/images/loginserver.htm) is producing:

[image]

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]

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]

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]

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

[image]

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]

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]

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

[image]

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]

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:

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

[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]

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]

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;
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

#!/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;
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.

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]

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]

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]

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

[Angelox]

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;

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!)



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]

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.

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]

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]

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]

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]

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]

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

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

[Sylaei]

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.