Admins:MiniLogin

Admins - Minilogin

Return to: Admins | Tutorials | Portal | Forum | Project Manager | Bug Tracker

About

MiniLogin (Windows Only) provides an alternative to the EQ2Emu login servers and is generally used for lan or local play.

The minilogin only supports a maximum of 5 connections at a time.

Look for the latest minilogin version on the SVN

Username: anonymous (no password required).

At the time of the update of this guide the current version is 1.04

Setting up the folder structure

There is not much to set up here really. If you are like me and want to put the minilogin server in its own directory, then you will need to make a new folder in your EQ2 directory called Loginserver. If you do not have a EQ2 folder already then make one in your root directory (C:\EQ2).

If you are setting up the loginsever in the same directory as your world server then do not overwrite any files when you unzip to that directory.

That's it for setting up the folder structure.

Creating the database

If you have not already followed the guide on setting up a database for world in the How To Compile A Windows Server, then here is a recap.

Install latest MariaDB.

Alternatively you can use MySQL. Any MySQL distribution at, or above, 5.0.27 should work fine. Visit MySQL archive to find 5.0.27 and above.

Download and install HeidiSQL, SQLYog or any MySQL (official) GUI Tools. This guide uses HeidiSQL. Interpret this for your own GUI if you do not use HeidiSQL.

• Once it is installed, connect to MySQL with username: root and the password for root. I think default is no password.
• Create a database by clicking Tools, Create Database.
• Enter a name for the database. I used eq2ls as the name of the database that will house my loginserver data.

It's wise to create a user to access the database besides root. Also you need to set a password for root if you have not already done so.

• Click on Tools, User-Manager and under credentials enter a username and password that you would like to use for your server. If you will be accessing the database from multiple computers then leave it %. Otherwise set it to either your computer's IP address or localhost.
• Click on the "All Privileges" checkbox and in the "Allow access to:" box, click on the eq2ls database. Then click create.
• While in the User-Manager go ahead and change the password for root.

At this point you will probably want to make your user access you world database as well. Another option is to use the same database as your world server for your loginserver database. Doing this makes it easier to update the opcodes needed for newer client support.

Adding The SQL File To The Database

Once you have the database created (or have chosen to use the world server database), you will need to source in the sql data. Run HeidiSQL, if not already running, and choose the database you want to source the sql to. If you created a database from above it will be eq2ls, if you followed the How To Compile A Windows Server and are using the world server db then it will be eq2world. Use the eq2ls.sql from the SVN to populate the database with the necessary data.

Configure MiniLogin

There are several Things to do here. First be sure to update the LoginStructs.xml and the CommonStructs.xml from the eq2server public source. These do not change very often but the most recent version of these xml files will be in the public source.

Next you will need to edit the login_db.ini

 Edit the information in this file to match your host (localhost for the host), your MySQL username and password you created in HeidiSQL, and the name of the database (eq2ls) or (eq2world) if you are using the same database as the world server from the How To Compile A Windows Server guide.

Below are the sql commands to add a user, add your world to the loginserver, and a few useful commands.

Creat a user

 insert into account set name='thename',passwd=md5('thepasswd');

Verify their ID's by doing the command:

 select * from account;

If you need to change an ID to a different number the following command should be used:

 update account set id=# where name='thename';

6) To add a world server do:

 insert into login_worldservers set name='The World',account='loginacct',password=md5('thepass'),chat_shortname='shortname';

make sure the server id is set to 1, or it will not function. The command below will list all the world servers:

 select * from login_worldservers;

If the ID is not 1 do the following command:

 update login_worldservers set id=1 where name='thename';

Download

SVN Username: anonymous (no password required)

Download

Troubleshooting

Bad password

[Bad password]

Incorrect Version

[Incorrect version]

Old Download from sourceforge (does not not work) [Download]