struggling with 0.6.1

[steffijade]

Hello there folks,
I`m new to EQEMU but have been trawling the boards for a few days trying to set up a server using minilogin. I used eqvercheck in my everquest directory and it reccomended using 0.6.1 so I found a tutorial specifying 0.6.1 and gave it a try. I have followed iwantavr4`s tutorial on how to do this but have run into a seemingly common problem. By using localhost as the ip address i have been able to access the server list and see the server I set up but get an error 1017.

The thing is, the server identifies itself as 0.6.0 server and I was wondering if this is the reason I am unable to connect to it?

I have tried changing a few files in the database, following suggestions I have found in iwantavr4`s tutorial thread and from other threads on the forums and have ended up dropping the database a few times to start over. I suspect that I may have left some files in either mysql or perl that are affecting the database setup.

Would it do any good to try unistalling mysql and perl and starting from scratch again?

Sorry if this seems a little vague but I`m definitely no expert in programming. Any suggestions would be warmly welcomed,
thanks, steff.

[Dr Zauis]

Yep..You are way off. You need to determine if you are 0.6.1DR1 or 0.6.1DR2...
If you can play on PEQ then you are 0.6.1DR1..
Then go here..
http://www.steelpsychos.com/index.php?link=eqemu.php

I dont know about the data base..Im using the one listed in the 0.6.1DR2 tutorial. Seems to work OK..(But there are errors in zone.exe/ect. so I might have to change that. But gameplay is correct.)I just got it all going tonight!

[steffijade]

Thanks for your response Dr Zauis,
I`ve been messing around a little more and had a better result. I uninstalled mysql and perl and tried another tutorial..the one by Sesmar on how to set up a 6.1 DR-2 server.

Using this tutorial I have been able to get to the server list and see my server on the list (I also saw one called Dr Zauis <test> :) ) but can`t log in to my own server. I did try logging into a few others though. I got onto the PEQ ok and was able to create and play a char with a few minor bugs and I was also able to log on to another server and create/play. Both these servers show as 0.6.1 DR-1 on the server list.My own server, which shows as 0.6.1 DR-2 I can`t log into.

When starting the emu I can get world and boot5 to load up with no errors but am still having problems with minilogin. I can still get to the server list and see my server and the others and can still log into the other servers using minilogin with the settings I currently have but still can`t log into my own.
I have messed around with settings in db, loginserver and boot5, altering the ip addresses. I have tried various combinations using 127.0.0.1 ,localhost and actual ips for internal and external. I have also added the lines of code regarding minilogin on the forums using mysql, such as :

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('[user]',250,'127.0.0.1');

I have tried altering the minilogin_ip value to match the ip used in loginserver and boot5. I have also tried altering eqhost to use different ips but the only way I can get to see the server list is by using :

[LoginServer]
Host=newlogin1.eqemulator.net:5998

in eqhost.

My current settings are as below.


db:

# READ README.TXT!

[Database]
host=localhost
user=xxxxxx
password=xxxxxx
database=eqdr2


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.
-------------------------------------------------------------------------
loginserver :

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=newlogin1.eqemulator.net
loginserver2=localhost
loginport=5998
loginport2=5999
worldname=xxxxxxxxxxxxxxx
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=StandAlone
ServerPort=5999
--------------------------------------------------------------------------
boot5 :

REM: ****Read this first!!!****



REM: This file requires your real IP in the place of "127.0.0.1" when you are connecting

REM: To the EQEmu Loginserver.



REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1



REM: If you still get errors try using localhost instead of 127.0.0.1



REM:--------------Start-----------------------

@echo off



if NOT exist spells_us.txt goto NOSPELL



start zone . localhost 8780 localhost
start zone . localhost 8781 localhost
start zone . localhost 8782 localhost
start zone . localhost 8783 localhost
start zone . localhost 8784 localhost

exit

cls



:NOSPELL

echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.

PAUSE



REM:---------------END------------------------
------------------------------------------------------------------------
and eqhost :

[LoginServer]
Host=newlogin1.eqemulator.net:5998

I know Dr Zauis said I needed to find out if I was compatable with DR-1 or DR-2 but I`m a little confused. Does the fact that I can login to servers that are listed as DR-1 but not my own which is listed as DR-2 mean that I am compatable with DR-1 but not DR-2?

Another point I have been thinking on is the difference between the 2 tutorials I have tried. In the tutorial by Iwantavr4 there are sql files that have to be sourced into mysql but in the tutorial by sesmar it doesn`t say anything about sourcing files..just to put the database into the mysql data folder. (I can`t see any sql files in the database folder to source). Is the reason why my server can`t be accessed because I need to add some sql files and source them into the database?

As if that wasn`t enough...I also use a dsl router and have been wondering if that was causing problems. I tried making the pc I am trying to set up on into a DMZ and it made no difference. I then tried switching off DMZ and tried port forwarding (I was a little unsure as to which ports to use but there was a predefined setup for everquest in my router`s setup so I used this and added ports 5999 and 9000) this made no difference.

All in all I am pleased to be able to access other servers but it would be nice if I could set up a working server of my own. I assume I have probably made some stupid errors in the ini files and/or some stupid assumptions as to the usage of code, but as I stated in the original post...I`m no expert in programming.

If anyone who reads this can spot something that I`ve done wrong or offer up any hints/tips/advice they would be gratefully recieved.
Thanks, steff.

EDIT: When trying to access my server from the server list I get 1017 error and the folowing shows up in world :

New client from ip: 127.0.0.1 port:1202
[Error] Expecting Op_SendlogInfo, got 0
Removing client from ip: 127.0.0.1 port:1202

[Dr Zauis]

OK Bud..heres some answers for ya..I just went through this the other day myself. So you say you did the 0.6.2DR2 tutorial by sesmar. Great! I did too. And found out that DR1 and DR2 are NOT compatible. Concerning sourcing the Database. I didnt do any of that. By the time I figured out I was not compatible I also figured out that the Database that I DLed while doing the 0.6.1DR2 tut is already complete! No sourcing! So Im using that. The mysql from the same tut. The pearl from the same tut.
And heres what I did to fix my problem(We have the same version client).

Go to that page in the link above. It may take a while to load the page but it will get there eventually.
Find the 0.6.1DR1 packages. There are 3. The non perl. The perl. The debug.
Right now Im using the Nonperl version.(I will work on the perl one today.)

Put that version in your folder.(I use eq emu)
Now open db ini and put your mysql name/password and the name of the
0.6.1DR2 database!
Make up a name for your server. And enter that name in the login .ini...
Thats it! I didnt change anything else!!!(That I can think of LOL).

What should happen is when you log in instaed of it saying receiving unknown.
It will say your name you use in your LS. You may see other errors in world.exe if you are watching that when you play. But I still get the correct gameplay here. Im working on that. Im a total noob dude!!

EDIT>> Oh and concerning Minilogin..I just logged in(To my server) as I nomally do to play on PEQ. Then my Brother came along and wanted to use the internet. Seeing as I didnt have my router hooked up I just let him remove the modem while I was logged into my server.(Its all set on localhostanyway for now). I played normally(Well many errors from server not being able to find loginserver../ingnore)for almost 24 hours that way.

[steffijade]

Thank you for the helpful tips Dr Zauis,
I managed to get it all working ok now, can log into available servers and also into my own server via minilogin.
I followed your advice and downloaded the 0.6.1DR-1 eqemu but still had problems with minilogin. I managed to get around this by making a new account and using that to login. I did this by using the 'GRANT ALL PRIVILEGES' etc. code with a new user name and then using the insert into account (name,status, minilogin_ip) values('[user]',250,'127.0.0.1'); also using the new user name. After doing that I just made sure that the ip`s were all set to 127.0.0.1 in db, loginserver, boot5 and eqhost and I was good to go.

Had a little fun messing round on my server and now my next challenge is to try and iron out a few bugs and see if I can customise it a little.

Once again, thank you for your advice..it worked a treat.
Steff.

[Dr Zauis]

You're Welcome!
Now my only problem is that the perl version is not loading the quests!
So Im back to the search for the perfect 0.6.1DR1. I did manage to install C++ but Im not too familiar with it..I need perl enabled.. I have an Idea that requires scions and such to work..Also Arias has a spell or something to port back to POK..That would be cool..Then I can disable the #zone command for the players. Sounds like a dumb server compared to non legit but I have a plan! It will be fun!