PDA

View Full Version : Minilogin Released!!!


Edgar1898
10-15-2004, 04:31 PM
After a while of hearing people complain and a few hours of free time on my hands I decided to revive minilogin. This version of Minilogin is for version 0.6.0-DR1+ of the Emu only. This will not work for previous versions because of specific changes in world. To start you will need to execute the following mysql queries:

INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');

alter table account add minilogin_ip varchar(32) not null;

Note: The following examples assume you want to use minilogin to play on the account named edgar1898 and you will be logging into it from the same computer your running minilogin on.

If you want to login with an existing account:
1. Put the ip address of the computer your using to login in the minilogin_ip field of the users account you wish to play.

The SQL code for this is:
update account set minilogin_ip='127.0.0.1' where name='edgar1898';

If you want to create a new account and login with it:

1. Insert the new account into the database. (This example also assumes you wish to give the user access to all commands on the server, change the 250 to another level if you dont)

The SQL code for this is:
insert into account (name,status, minilogin_ip) values('edgar1898',250,'127.0.0.1');

*Hint* Whenever the user connects to minilogin, it will display their ip in the console window, that IP must match the ip you put in the account table. Whenever your doing one of the above steps make sure the ip addresses are the same!



1. Once you have done that download MiniLogin and change your eqhost.txt file to 127.0.0.1:5999
You can download it here: http://prdownloads.sourceforge.net/eqemulator/MiniLogin6.0.zip?download

2. Open your server's LoginServer.ini file and change the loginserver and loginport as follows:
loginserver=127.0.0.1
loginport=5999

Thats it! You should be able to login and play normally! :)

If your world doesnt display something like Connected to LoginServer: 127.0.0.1:5999 and it does not show up in the server list, make sure your LoginServer.ini file for your server and for MiniLogin (you can use the same on if the server and minilogin is in the same directory) looks similiar to this:

[LoginServer]
loginserver=127.0.0.1
loginserver2=newlogin1.eqemulator.net
loginport=5999
loginport2=5999
worldname=Name of server here
worldaddress=Your IP Address here
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

mrea
10-16-2004, 12:27 AM
Awesome job guys, set that up and I'll try it out although I'm sure you already have!

EDIT:: Works very well guys. Been waiting for a long time :)

Elkay
10-16-2004, 03:34 AM
I love you, even if you are a robot. lol :lol:

mrea
10-16-2004, 03:40 AM
Just wondering, would someone be able to connect to my login if they set their eqhost.txt to host=myip.myip.myip.myip:5999

mystic414
10-16-2004, 05:09 AM
Woo hoo! All my whining finally paid off!

Edgar1898, you are my hero!

Going to go try it out now...

Edgar1898
10-16-2004, 05:28 AM
Just wondering, would someone be able to connect to my login if they set their eqhost.txt to host=myip.myip.myip.myip:5999

theoretically, yes as long as you have their ip in the account you want them to access. I havent tested that, but I dont see any reason why it wouldnt work. Unlike the last minilogin there is no limit to how many accounts you can have either.

Elkay
10-16-2004, 07:35 AM
Having a small problem getting this working.. almost there tho. Everything is working except when I select my server and try to enter world, I get thrown back to select with 1017. However it's not a wrong IP problem or anything, as I see the following in my World.exe console:

112375 New client from ip: 192.168.1.103 port: 1219
Login with '10516' and 'QMV1I7HNG7'
192.168.1.103: Wrong name/pass: name='10516'
Removing client from ip:192.168.1.103 port:1219
176750 New client from ip: 192.168.1.103 port: 1222
Login with '10516' and 'QMV1I7HNG7'
192.168.1.103: Wrong name/pass: name='10516'
Removing client from ip:192.168.1.103 port:1222
203109 New client from ip: 192.168.1.103 port: 1228
Login with '10516' and 'QMV1I7HNG7'
192.168.1.103: Wrong name/pass: name='10516'
Removing client from ip:192.168.1.103 port:1228

I checked my database, and that number does not match my lsaccount_id nor is that my login name, if either of those matter. I'm also assuming that's an encrypted password since that is not anything close to my password. Just not sure why it's declining my uid/pwd. Any ideas?

garim12
10-16-2004, 07:38 AM
Ok, I've been playing around with this for a few hours and here's what I'm trying to get working now:

I set it up as you said to run the server and the client on the same machine. I put an entry in my accounts table and logged in with that username and password. While it was loading, it created a new record in the account table with the username "®ñÎ?". I got to the character select screen, created a character, and logged in. Everything was working fine.

Next, I moved the programs over to another machine on my network and put holes in my router for the ports needed. I created a second login account in the database for my brother and set the ips in the minilogin_ip field to our current addresses. I logged in to the character I created earlier; the one on the weird "®ñÎ?" account. My brother logged in and got to the same character select screen as me. At this point, if I logged in then as soon as he clicked the "create character" button, I would lock up.

Another thing we noticed, no matter what we type in for username and password, it lets us in and brings us to that one account that it created. It doesn't matter what we type, what's in the database, or what ip addresses are in the minilogin_ip field. We both always end up looking at the same character. I deleted all accounts and started over, and arrived at the same place.

Any ideas?
-Garim

Edgar1898
10-16-2004, 08:14 AM
Having a small problem getting this working.. almost there tho. Everything is working except when I select my server and try to enter world, I get thrown back to select with 1017. However it's not a wrong IP problem or anything, as I see the following in my World.exe console:

112375 New client from ip: 192.168.1.103 port: 1219
Login with '10516' and 'QMV1I7HNG7'


Make sure 192.168.1.103 is the ip that is in your minilogin_ip field for the account you wish to login to.

Edgar1898
10-16-2004, 08:17 AM
Ok, I've been playing around with this for a few hours and here's what I'm trying to get working now:

I set it up as you said to run the server and the client on the same machine. I put an entry in my accounts table and logged in with that username and password. While it was loading, it created a new record in the account table with the username "®ñÎ?". I got to the character select screen, created a character, and logged in. Everything was working fine.


You didnt make the account properly, world shouldnt try to make an account, if it does, then its not setup properly. Walk through all the steps and verify your doing exactly what it says.

Another thing we noticed, no matter what we type in for username and password, it lets us in and brings us to that one account that it created. It doesn't matter what we type, what's in the database, or what ip addresses are in the minilogin_ip field. We both always end up looking at the same character. I deleted all accounts and started over, and arrived at the same place.

Only one account can be played on at a time per ip address, you have to specify a different ip address for each one.


Oh, one other note, make sure you have the right version of the server. If you didnt get the source or binaries that hit cvs about 10 hours ago, you wont be able to login properly.

garim12
10-16-2004, 11:02 AM
Oh, one other note, make sure you have the right version of the server. If you didnt get the source or binaries that hit cvs about 10 hours ago, you wont be able to login properly.

Yes, that was it. The source I grabbed was too early by a few hours. Thanks a lot!

Elkay
10-16-2004, 11:32 AM
Having a small problem getting this working.. almost there tho. Everything is working except when I select my server and try to enter world, I get thrown back to select with 1017. However it's not a wrong IP problem or anything, as I see the following in my World.exe console:

112375 New client from ip: 192.168.1.103 port: 1219
Login with '10516' and 'QMV1I7HNG7'


Make sure 192.168.1.103 is the ip that is in your minilogin_ip field for the account you wish to login to.

Yep it's 192.168.1.103 and I even just copy/pasted it here lol. Any other ideas? account 10516 doesn't even exist, I have no clue where it's coming from. When switching back to eqemu LS, I forgot to switch the MiniLogin variable the first time, and then it was showing the correct ID being passed to world (even though it obviously didn't work live that way).

Cisyouc
10-16-2004, 12:52 PM
Edgar, any chance MiniLogin 6 will be OpenSource?

Edgar1898
10-16-2004, 02:05 PM
Having a small problem getting this working.. almost there tho. Everything is working except when I select my server and try to enter world, I get thrown back to select with 1017. However it's not a wrong IP problem or anything, as I see the following in my World.exe console:

112375 New client from ip: 192.168.1.103 port: 1219
Login with '10516' and 'QMV1I7HNG7'


Make sure 192.168.1.103 is the ip that is in your minilogin_ip field for the account you wish to login to.

Yep it's 192.168.1.103 and I even just copy/pasted it here lol. Any other ideas? account 10516 doesn't even exist, I have no clue where it's coming from. When switching back to eqemu LS, I forgot to switch the MiniLogin variable the first time, and then it was showing the correct ID being passed to world (even though it obviously didn't work live that way).

Do the following:
1. Close all world/zones.
2. Download the latest binaries from http://cvs.sourceforge.net/viewcvs.py/eqemulator/EQEmuCVS/Compiled_Win32/Release/
3. Run these sql queries (post if you get any errors running it):
update variables set value='Minilogin' where varname='LoginType';
insert into account (name,status, minilogin_ip) values('edgar1898',250,'192.168.1.103');
4. Config world to connect to minilogin and attempt to login to world with your client.

Edgar1898
10-16-2004, 02:07 PM
Edgar, any chance MiniLogin 6 will be OpenSource?

Probably not.

Cisyouc
10-16-2004, 02:08 PM
Edgar, any chance MiniLogin 6 will be OpenSource?

Probably not.Hmm. Alright, then what about this: Just out of curiousity, is it possible to edit/create "green" and "yellow" servers? :wink:

Edgar1898
10-16-2004, 02:12 PM
Do you want it to display the server as yellow or green? Its a simple one byte change in the code that I can make if you guys want it that way. I'll make a poll in the forum and change it to whichever one wins.

Elkay
10-16-2004, 04:03 PM
Just downloaded those binaries and ran them but I won't be able to test this for you until I can actually get into the game now. I've posted my zone problems in the bugs forum. After those get resolved I'll test MiniLogin, but until then, there's not much point.

Elkay
10-16-2004, 04:30 PM
I fixed the problem.. my goddamn IP addres is 192.168.1.103 not 192.168.1.3... I must have had something else wrong and started over and typed it in wrong ARGH!! :roll: Now I just need to solve my zone problem that I posted and I'll actually be playable again on .0.6.0.

mrea
10-17-2004, 04:07 AM
I'm having status problems. No matter what I set my accounts status to I cannot do anything. None of the commands will work (only wanted to use minilogin for spawning, etc).

Edgar1898
10-17-2004, 04:27 AM
I'm having status problems. No matter what I set my accounts status to I cannot do anything. None of the commands will work (only wanted to use minilogin for spawning, etc).

Out of game:

update account set status=250 where name='edgar1898';
(replace edgar1898 with your account name)
Make sure that your account name matches the one that world is saying is logging in.

In game:

type #flag

mrea
10-17-2004, 06:16 AM
Thats not it. I open up MySQL-Front and when I look at all my accounts (ones created solely for minilogin) they all have the status of 250 which they would get by setting up minilogin the way you explained earlier. It's not really necessary for me as I'm on a cable connection and don't require minilogin when I can just lock the server, buts its nice :D Anyways, thanks for releasing this

finwe
10-17-2004, 08:45 AM
Then if someone who has variable ip want to play using my minilogin??? he cant??? is there anyway to desactivate the ip check???

tks

Cisyouc
10-17-2004, 08:48 AM
Minilogin is designed for LAN-login only. Thus, you can make your computers on a static local IP. If its just you, you can use 127.0.0.1

finwe
10-17-2004, 09:28 AM
it will be openSource code???

tks awesome job :)

Edgar1898
10-17-2004, 10:24 AM
it will be openSource code???


Where did you get that from? I have no plans on releasing it as open source.

Bladees1739
10-17-2004, 11:26 AM
This is a stupid question i know but is this compatible with Live. Unless they patched again. Sorry wasnt really paying attention at what i typed.

Cisyouc
10-17-2004, 11:28 AM
This is a stupid question i know but this is compatible with Live. Unless they patched again.Wheres the question in that?

Edgar1898
10-17-2004, 01:01 PM
I made a new version that provides a little more debug info that should help you guys. In the console window of minilogin, it displays the ip address of the person that connected to it. Now you dont have to guess, just copy that ip and paste it into your account table, change the variable in the variables table and your done.

finwe
10-17-2004, 07:45 PM
then, if minilogin only take care of ip when someone trying to login... ...how can someone have more than 1 account in the same machine? And is it possible in a future relase that minilogin update automatally the ip of the account when someone try to connect?? in this way you will can connect from any pc in the LAN to any account without makin any update in the database...

Tk you, great work.

Camaris
10-17-2004, 11:15 PM
Many thx for u work Edgar, u really have done that i get my best server update, i was playing on eqemu 0.5.6 (with any changues done for me...) due to the old minilogin only worked on this version.

But i now can play on the latest server version, it is so nice.......

MANY MANY THX MATE =)

Muuss
10-17-2004, 11:41 PM
finwe: you can dual box from the same account with EQemu, so no needs to have 2 different accounts, this should solve your problem, i guess.

Elkay
10-18-2004, 12:58 AM
then, if minilogin only take care of ip when someone trying to login... ...how can someone have more than 1 account in the same machine? And is it possible in a future relase that minilogin update automatally the ip of the account when someone try to connect?? in this way you will can connect from any pc in the LAN to any account without makin any update in the database...

Tk you, great work.

Your logic is flawed. The authentication of who you are is the IP Address, and the IP address alone.

finwe
10-18-2004, 01:34 AM
sure, but future release can comprobe the login and password and then update the table with the current ip of the user... just if developers want it of course ;)

Hurdlesaint
10-19-2004, 04:46 PM
Jesus i feel stupid reading this... All i want is a fricken link to download, lol. There is nothing to download or anywhere to get anything, i am just supposed to enter in these magic words and numbers into my makebelieve file. I am seemingly lost, i play EQ constantly and just want to check out emulator. Anyone have a link for more of a beginners look at getting going on this?

10-19-2004, 08:17 PM
Someone obviously didn't do much of a search.
Have you tried the Tutorials and How-To's forum??
The information is there, if you would just freaking look.

tcsmyworld
10-19-2004, 08:23 PM
..

movieman
10-20-2004, 12:40 PM
Thank you! I hadn't upgraded my eqemu local server for months, and thought I'd never get it working again after patching and upgrading to 5.9 and discovering that the old minilogin didn't work anymore... now I have a working install again, at least to the extent of logging on and zoning in.

Elkay
10-20-2004, 01:25 PM
Hey Ed I've got an idea. what about adding another column to the account table that stores the encrypted password on first login, then from that point forward checking just the encrypted password sent against the encrypted password stored (requiring no decrypting). What this will allow is someone to log in remotely (as long as there are no duplicate passwords). The only reason I'd like this functionality is that I use Minilogin while I'm world developing, to keep the database clean and since the server is going up and down constantly and I don't want to piss people off disconnecting them all the time.

Edgar1898
10-20-2004, 02:56 PM
I'll think about adding that. It is extremely low priority though, so if I do decide to add that it wont be soon because I have so many other things to do.

Elkay
10-20-2004, 02:59 PM
No rush man, honestly figuring out that black screen of death is the only thing I'm worried about right now. And as always, thanks for all the great work you're doing for the community.

gottasummer
10-25-2004, 09:32 AM
Just wondering, would someone be able to connect to my login if they set their eqhost.txt to host=myip.myip.myip.myip:5999

theoretically, yes as long as you have their ip in the account you want them to access. I havent tested that, but I dont see any reason why it wouldnt work. Unlike the last minilogin there is no limit to how many accounts you can have either.

SWEET DUDE!

This actually allows basically... unlimited accounts, is the source on the CVS server? I enjoy LAN parties (for LAN without internet access =( and itll be a pain to enter all of the IPs, would be easier to just make it accept all...)

Could I just enter *.*.*.* for IP for it to accept all?

Also, how could I integerate it into a PHPBB forum like you used to do for the old loginserver?

Elkay
10-26-2004, 02:23 AM
As far as I know, LE's code doesn't accept wildcards. It has to be an exact IP match. I myself have, however, logged into my ML from outside my LAN with the appropriate IP address set in the DB. The only workaround I've been able to think of was to store the encrypted login/password to the DB for comparison, but that's not a priority since ML does accomplish what it was meant to be used for already. Would be a nice feature for down the road, almost like a ML/LS hybrid lol.

nysson
10-27-2004, 04:48 PM
Okay, I've perused every post I can find to try and find an answer to my 1017 problem but have found none, so I'm giving in and posting.

world.exe says
504436 New client from ip:192.168.0.207 port 1685
Bad/expired session key: 10516
Removing client from ip:192.168.0.207 port:1685

LoginServer.ini

[LoginServer]
loginserver=127.0.0.1
loginserver2=127.0.0.1
loginport=5999
loginport2=5999
worldname=Moron's World
worldaddress=192.168.0.207
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=StandAlone
ServerPort=5999

db.ini

[Database]
host=127.0.0.1
user=moron
password=imamoron
database=eq

Boot5Zone.bat

@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . 192.168.0.207 7995 127.0.0.1
start zone . 192.168.0.207 7996 127.0.0.1
start zone . 192.168.0.207 7997 127.0.0.1
start zone . 192.168.0.207 7998 127.0.0.1
start zone . 192.168.0.207 7999 127.0.0.1
exit
cls

:NOSPELL

Any clues from anyone on what might be preventing me from getting in?

Back to fiddling around in hopes I can figure it out....

Edgar1898
10-27-2004, 04:59 PM
What version of EQEMu are you running? And could you paste all the output of world?

nysson
10-27-2004, 05:11 PM
Nevermind, due to your question I did some digging... apparently I need to find a copy of EQemu 6.0. I'm running 5.9-DR1 and I have the database for 6.0 but not the Emu.

troutman
11-03-2004, 05:32 AM
This works great! A big thank you to Ed for making this happen.

11-04-2004, 01:05 AM
Interesting side note concerning the minilogin server. If anyone has used or wants to use the Ethernal Quest Emulator (this one is better so far) it wants to have an internet connection to Sony's servers to check the patch level of EQ when you connect to a world. You can point that emulator's login server to minilogin to rid yourself of the need to configure theirs for offline play.

Astartae
11-15-2004, 10:00 PM
I don't know if anyone mentioned this but people need to make sure they delete the old MiniLogin.ini. I discovered this the hard way. I was getting everything to work up until I got to the server screen in eq. I saw my server but when I tried to enter world it said "an unknown error occurred."

After thinking about it, I thought it might have something to do with the MiniLogin.ini file because the World.exe output showed the new client ip but there was no username information with it. I reread the Readme file for minilogin.exe and noticed the old ini file wasn't mentioned once.

So, I deleted it, restarted everything, and am now at the character select screen. Let's hope the client doesn't crash after zoning in now, hehe. ;-)

IntesstoMic8
11-20-2004, 09:45 PM
Hello all ( and thanks for minilogin) ill use with eq sometime only with friends.

I have a probleme with account(?) or DB(?)
I ll use eqemu 6.0 DR2 with minilogin 6 (DB PEQ Kunark)
for now ill try only with one PC and minilogin on the same PC.
All seem OK ill see the server but when ill try to get into the game, after few sec ill have a error
1017.

This the same prob like ELKAY:
On the world windows have this texte:

Login with '10516' and 'QMV1I7HNG7'
192.168.0.2: Wrong name/pass: name='10516'


And find no clue on the forum...

Someone have an idea or solution for this ?


Thanks.

bushman77
11-24-2004, 04:45 PM
I keep getting that strange number account 10516 with that long password of which is nowhere in my DB. My client reports that there is no connection to the patch server.
My minilogin V0.6.0 +output is as follows:

LoginServer.ini read.
Server mode: Standalone
Login server listening on port:5999
21421 New Server connection: 127.0.0.1 port: 40719
World List:
============================
ID: 1, Name: [0.6.0-DR2] Super Local Server, Local, IP: 127.0.0.1:3999, Status: 0, AccID: 0
============================

My world.exe is as follow:
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
Reboot Zones mode ON
[Status] Loading variables..
.
.
.
Zoneserver SetConnectInfo: 127.0.0.1:4004: 127.0.0.1:7991
Zoneserver SetConnectInfo: 127.0.0.1:4005: 127.0.0.1:7992
420214 New client from ip: 127.0.0.1 port: 4011
Login with '10516' and 'QMV1I7HNG7'
127.0.0.1: Wrong name/pass: name='10516'
Removing client from ip:127.0.0.1 port:4011

Now i've followed the instruction using the queries:
INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');
alter table account add minilogin_ip varchar(32) not null;
insert into account (name,status, minilogin_ip) values('eqemu',250,'127.0.0.1');

what am i doing wrong??!!

Muuss
11-24-2004, 08:11 PM
run the following queries and dump it here :

from mysql :
select * from account;
select * from variables where varname like '%login%';

from windows (MSDos Commands) :
ipconfig -a

bushman77
11-25-2004, 04:13 AM
each account has a lsid assigned to it, usually it is a number but for me to get it to work i had to assign the value to NULL:

SELECT *
FROM `account`

+----+--------+----------+-------------+------------+----------+--------+--------------+---------+---------+--------------+
| id | name | charname | packencrypt | sharedplat | password | status | lsaccount_id | gmspeed | revoked | minilogin_ip |
+----+--------+----------+-------------+------------+----------+--------+--------------+---------+---------+--------------+
| 1 | eqemu | Bushman | | 0 | | 250 | [NULL] | 0 | 0 | 192.168.0.4 |
| 2 | Slue | Froak | | 0 | | 0 | [NULL] | 0 | 0 | 192.168.0.3 |
| 3 | Frank | Poobiter | | 0 | | 0 | [NULL] | 0 | 0 | 192.168.0.5 |
+----+--------+----------+-------------+------------+----------+--------+--------------+---------+---------+--------------+

Muuss
11-25-2004, 04:27 AM
420214 New client from ip: 127.0.0.1 port: 4011
Login with '10516' and 'QMV1I7HNG7'
127.0.0.1: Wrong name/pass: name='10516'
Removing client from ip:127.0.0.1 port:4011

Something seems wrong here, if we compare it to what your ip adresses are in your account table.

You're loging from loopback (127.0.0.1), which means that your server and your client should be on the same computer.
In your account table, you're specifying ip addresses from a private LAN (192.168.0.xxx), none of them match loopback. From what i see, I guess you have your own LAN and have several computers.
If i were you, at least for debugging purpose, i would run minilogin and the server on 1 computer, let's say 192.168.0.3 as example. (Check all your ini files on that server, 127.0.0.1 shouldn't appear anymore in any of the files. Use 192.168.0.3 instead)
Once it's running, and server is connected to minilogin. Configure your eqhost.txt on one of the 2 other comps with 192.168.0.3:5999 then try to connect. It will work :)

Someone should take the time to write a minilogin_setup.exe software, with a form containing explicit fields, like : on which computer will you run minilogin ? on which computer will u run world.exe ? on which computer did you installed mysql ? and that would produce the correct inifiles, it must'nt be that hard)

Coke
12-04-2004, 02:15 PM
How do you create the account table?

Kesia
12-04-2004, 02:29 PM
INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');

alter table account add minilogin_ip varchar(32) not null;



OKay i am lost what do i open to put this code in????

talamyen
12-14-2004, 07:47 AM
In a Command Prompt, goto c:\mysql\bin
type mysql -u root then hit enter
use eq (or whatever database it is)
type in the code

jieseng
12-09-2005, 05:21 AM
when i type in:

INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');

I get the following error:

ERROR 1146: Table 'mysql.variables' does not exist

I don't know how to create the proper table or why it doesn't exist.

Can someone help me?

Thanks

Jieseng

johane
12-09-2005, 10:50 AM
when i type in:

INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');

I get the following error:

ERROR 1146: Table 'mysql.variables' does not exist

I don't know how to create the proper table or why it doesn't exist.

Can someone help me?

Thanks

Jieseng


before you type the "INSERT... " line, make sure ou know what the name of your EQ database is (let's assume it's eqdb )

type "use eqdb ; " (no quotes)

Then type your INSERT statement.

Belfedia
12-09-2005, 11:11 PM
Use also the correct db, some old distribution don't have variables table :( you can find correct version files and up to date guide on wiki :
http://www.eqemulator.net/wiki/wikka.php?wakka=Linkit
And for official sourceforge :
http://sourceforge.net/project/showfiles.php?group_id=88515

I hope that help you :)

jieseng
12-15-2005, 04:39 PM
thank you, johane. I hadn't set the db to eq... my oversight.

Now if I can just figure out how to make combat work... I am able to target mobs and npcs, but i can't attack or con them. I put the maps.tar.gz in the eqemy/maps directory, but I don't know if I need to unzip it or something. I've never seen a .gz file before. Any help would be appreciated. Also, whne I zoned into nektulos forest, I ended up in this unfamiliar place with a bunch of tree stumps and a river (with no way to zone out....)

Help please?

Thank you kindly!!! :)

Jieseng

johane
12-15-2005, 08:40 PM
Now if I can just figure out how to make combat work... I am able to target mobs and npcs, but i can't attack or con them. I put the maps.tar.gz in the eqemy/maps directory, but I don't know if I need to unzip it or something. I've never seen a .gz file before. Any help would be appreciated. Also, whne I zoned into nektulos forest, I ended up in this unfamiliar place with a bunch of tree stumps and a river (with no way to zone out....)

Help please?

Thank you kindly!!! :)

Jieseng

Yes, it needs to be unpacked.

RangerDown
12-16-2005, 04:23 PM
Please keep this thread on-topic. Any issues you come upon are only relevant to minilogin if you actually have problems logging on, or in some cases, selecting a server. Once you've hit the character select screen, you are definitely beyond minilogin's realm of responsibility, and any issues you encounter from there forward need to be addressed in the appropriate forums.

Thanks in advance for your cooperation.

jumbodogs
12-30-2005, 04:49 AM
I start minilogin, world, then boot5zones wait til it says sleeping then start eq with the patchme but after I type in username and password it just says logging into server.

My minilogin window on the top shows 1server,1client and this is in the window

LoginServer.ini read.
[Status] Loading opcodes..
Server mode: MiniLogin
Login server listening on port:5999
28829 New Server connection: 127.0.0.1 port: 43268
492079 New client from ip: 127.0.0.1 port: 1207

thanks for any help I can get

Sakrateri
12-30-2005, 05:28 AM
make sure to set logintype to minilogin under variables in MYSql , also make sure you have your name and ip of the puter you are trying to connect to the server with in the MiniloginAccounts.ini file

jumbodogs
12-30-2005, 06:47 AM
make sure to set logintype to minilogin under variables in MYSql , also make sure you have your name and ip of the puter you are trying to connect to the server with in the MiniloginAccounts.ini file

INSERT INTO VARIABLES (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');

ALTER TABLE account ADD minilogin_ip varchar(32) NOT NULL;

Is this what you mean by setting logintype if so I did that and miniloginaccounts.ini is that loginserver.ini?
Here is what my loginserver.ini looks like:
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=jumbolands
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
ChatChannelServer=

[LoginConfig]
ServerMode=minilogin
ServerPort=5999


Thanks for the help on this

Sakrateri
12-30-2005, 11:51 AM
you should also have an ini file in your EQEMU folder that says MiniloginAccounts and inside there it should look something like this

# Max 200 lines total (including comments and blank lines)
# Blank lines may mess up the line # reported in error messages
127.0.0.1 jumbodogs password


replace ip with whatever the ip is of the machine your playing with and whatever username and password you want. it does not use the password though but its got to be there , It goes by your IP instead


Oh and one more thing , You have got to add the minilogin IP of the playing machine into the minilogin_ip field in accounts

I use MYSqlfront to work on my database so im not sure of the exact way to enter that in but something like: UPDATE account SET minilogin_ip=127.0.0.1 WHERE minilogin_ip=

may want to get that checked by someone tha knows for sure.

jumbodogs
12-31-2005, 03:19 AM
I tried switching minilogin exe from 6.2 to 6.1 and now I can get to the server select screen but after I select my server EQ locks up and I get an OP_SendloginInfo error

Here is what comes up in the world.exe:
[Error] Expecting OP_SendLoginInfo, got 0

Legna
02-25-2006, 11:30 PM
Hello,

I have the same problem about "OP_SendLoginInfo". I know my eq version is too recent, but is there an ETA on the new eqemu version able to support the current live ?

Thanks in advance :)

TheClaus
02-26-2006, 01:55 AM
There are talks about making the emulator compatible with EQ Titamium(sp) CD Set that is out but nothing solid on that.

There are some servers out there that are providing the backpatch but finding them is going to be the fun part. It can be done though.

Belfedia
02-26-2006, 04:04 AM
There are talks about making the emulator compatible with EQ Titamium(sp) CD Set that is out but nothing solid on that.

There are some servers out there that are providing the backpatch but finding them is going to be the fun part. It can be done though.

Be carefull, speak about that is forbidden by Forum's rules even if you don't provide any links :(

Legna
02-26-2006, 08:21 AM
Thanks for your infos TheClaus.

Et merci Belfedia ;) (j'aime beaucoup ta signature :p )

Takeru
03-12-2006, 11:32 AM
Forgive the noobish-ness of this post but I am a complete newb when it comes to using mysql or any server crap for that matter. I am having trouble setting up a server. Everytime I go through the wizard on the start servise check it says could not start the service MySQL. Error: 0. Anyone know what's up w/ this? Also, when I make the server, how do I connect to it? It did it once and I got the command prompt up but it said not connected when I tried to run the commands you said. Any help would be appreciated, thanks.

~Tak

RangerDown
03-12-2006, 12:57 PM
Support issues need to be posted on their own threads please. Also, they really don't belong here but rather in either General Support or Support:Windows Servers if you're having general trouble starting a server.

Closing it to further replies.