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-22-2009 02:57 AM

New MiniLogin Release!
 
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 03-22-2009 12:57 PM

Quote:

Originally Posted by image (Post 166012)
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 03-22-2009 02:52 PM

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

Angelox 03-22-2009 03:00 PM

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 03-22-2009 03:07 PM

First problem post lol

what this mean ?

Code:

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 03-22-2009 03:15 PM

also getting this too.

Code:

Error importing functions from EQCrypto.dll.

neiv2 03-22-2009 03:18 PM

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 03-22-2009 03:23 PM

You can go get leslamarch's install package from my site, 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 03-22-2009 03:35 PM

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 03-22-2009 03:38 PM

Quote:

Originally Posted by Angelox (Post 166034)
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 03-22-2009 04:33 PM

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

neiv2 03-22-2009 05:21 PM

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

Sakrateri 03-22-2009 05:29 PM

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

Code:

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 03-22-2009 05:43 PM

Quote:

Originally Posted by neiv2 (Post 166046)
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 03-22-2009 05:47 PM

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 03-22-2009 05:57 PM

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

neiv2 03-22-2009 06:52 PM

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

image 03-22-2009 07:27 PM

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 03-22-2009 08:31 PM

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 03-22-2009 09:47 PM

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 03-22-2009 09:57 PM

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 03-23-2009 05:43 AM

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 03-23-2009 07:22 AM

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 03-23-2009 09:23 AM

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 03-23-2009 09:26 AM

Anyway for me to fix this error?

Code:

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 03-23-2009 09:32 AM

Quote:

Originally Posted by Sakrateri (Post 166106)
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
Code:

*** 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 03-23-2009 10:16 AM

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 03-23-2009 10:41 AM

Quote:

Originally Posted by image (Post 166108)
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 03-23-2009 11:23 AM

Quote:

Originally Posted by number6 (Post 166109)
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 03-23-2009 12:07 PM

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 03-23-2009 12:12 PM

Quote:

Originally Posted by Sakrateri (Post 166115)
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 03-23-2009 01:50 PM

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

devn00b 03-23-2009 01:53 PM

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

Angelox 03-23-2009 07:46 PM

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

ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'
When attempting to run this line;
Code:

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 03-23-2009 07:52 PM

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

Angelox 03-23-2009 08:01 PM

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 03-23-2009 08:41 PM

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

Aergad 03-26-2009 02:15 AM

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 03-26-2009 04:08 PM

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

Code:

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 03-26-2009 04:26 PM

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"


All times are GMT -4. The time now is 10:11 PM.

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