Setting up a LAN.. have a few questions...

[saioncear]

im currently trying to set up a lan at my school so we can play eq here.. we would just use emu login servers but they are blocked and the only way we can access what would normally be "restricted" websites by using desproxy to create a tunnel in the proxy and using an ssh encryption so their proxy and such cant block it.. but i havent figured out how to connect through login servers using a socks proxy.. so we tried the mini login.. we have everything set up.. ive gone through hundreds of posts.. and to no avail.. the 2 problems we are having are

1) Other computers on the LAN cant connect to our server..
by this i mean.. if your on the computer running the server.. it works just fine.. everyone else can get to the server select.. it shows the count and everything.. but then we get error 1017 and get crashed back to server select every time..

and 2) Spells arent working.. we have copied over spells_en.txt and spells_us.txt into the directory.. boot5 works but when we login and do #scribespells 65 and zone.. it scribes random spells.. that arent memmable..

Im Running Windows XP
3.2Ghz P4
1024mb ram
ATI Radeon 9800 pro 128mb

and ive also tried it on

Windows XP and Windows 2000
1Ghz P3
256mb ram
and nvidia geforce mx 64mb of ram

(both ends of the spectrum)

Im using DR-2 Binary
DB.sql
Jan 24 Update
MyraDB.sql
MyraItems.sql
MiniLogin0.5.0
spells_us.txt
spells_en.txt

db.ini

[Database]
host=127.0.0.1
user=saionce
password=********
database=eq
compression=off

LoginServer.ini

# READ README.TXT
[LoginServer]
loginserver=localhost
loginport=5997
worldname=Henrys_Pwnage
worldaddress=127.0.0.1
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5997
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

i realize that MiniLogin is unsupported.. and im not asking for 'support' im just wondering if anyone has some insight as to how to resolve this problem.. thanks in advance for anyone that can help![/code]

[farce]

your world address is listed as 127.0.0.1.. therefore when someone tries to login to it they'll try to connect to their own machine.

[Kroeg]

Farce, he just said that he's using minilogin.. I know that didn't escape your attention.

to saioncear:

would there happen to be a router between you and the proxy? My first thoughts would lead me to believe ports are blocked. Can you tell us more about your configuration at school? At most schools there are buttloads of routers between each room/part of campus and proxies (as there typically aren't multiple proxies)...

[farce]

kroeg, and what does that matter. Loginserver will tell client 'World is at 127.0.0.1" and they'll 1017 trying to connect to themselves.

[Kroeg]

ok, you know best.. and you're so damned helpful too. 2 for 1.

[Scorpious2k]

Farce is right. The world address should be the lan ip address if others on the lan (and you) are to logon, localhost if its just for yourself, and your external ip if you want everyone on your lan, people outside the lan and yourself to be able to logon.

All with minilogon.

[saioncear]

ok.. got it so other people can log in.. now for the spells

the spells arent working and i honestly have no diea why.. everything else works great.. no ld on zonin or death.. particles work.. etc etc.. just wondering how i can get the spells fixed when you try to cast it gives the error:

Sorry you dont have the required items, perhaps its time you visited a town. x4
your spell is interrupted

then it spams you with

I dont know that TargetType. 0xff

and if you dont have a target and you cast a group spell/song it gets error:spell requires a target
Error aquiring target

the current zone gets:

Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 204; Time Offset = 0
Couldn't find/read ./cfg/ponightmare.cfg. (returning -1)
Couldn't find/read ./cfg/ponightmare.cfg. (returning -1)
Corrupt (or nonexistant) zhdr file ./cfg/ponightmare.cfg -- fread count = -1 (sh
ould be 588)
Using default zone header data...
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
Error in LoadGroundSpawns query 'SELECT max_x,max_y,max_z,min_x,min_y,heading,na
me,item,max_allowed,respawn_timer from ground_spawns where zoneid=204 limit 50'
#1054: Unknown column 'respawn_timer' in 'field list'
[Status] Loading doors for ponightmare ...
[Status] Done loading doors for ponightmare ...
[Status] Zone Bootup: ponightmare (204)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [07:44 pm]
[Status] 2402234 New client from ip:10.1.18.206 port:2655
Unable to get group id: #1054: Unknown column 'groupid' in 'field list'
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
 opcode: 0x0175, size: 4

thanks for your help..

Saionce

[samandhi]

I have had SOME issues with missing fields in the Myra DB as well, but I love it as it is VERY complete for the zones that are, well, completed hehe....

There are a couple of things I would try (not being an expert you may not find it useful, but I DO have my server up and running). I noticed that you are using DR 2 but using the jan24update.sql file... Well, if Im not mistaken there was an update.sql file that came wtih the DR 2 release (not sure what it contained, as I didnt open it just sourced it hehe). Try sourcing this.. And I also noticed you didnt source the dumpeditems.sql, which, if memory serves (and it may not) myra's readme says to source this before sourcing her db... Try this and in this order.. This is what I have done and mine works great.

db.sql
dumpeditems.sql
myradb.sql
myraitems.sql
update.sql
jan24update.sql

The major problem I was having with Myra db was when making anything that has a pet... I noticed they were like lvl 152 and have 49k hp (or something like that). I checked the pet table and something didnt look right (though as I said, I dont know tons about it, just enough to be dangerous I think).. There was NO data and noticed that zone.exe told me it couldnt find the data so using defaults. Sheesh, helluva' default pet. So from the mw_052_053_alpha2.sql db, I exported the whole "pets" table into myradb and everything was gravy after that..... Hope one of these items helps you, if not I just dont know the answer, guess the gurus will have to help

Also, is this happening to you with EVERY spell or just ones that need reagents, and AoE spells... The AoE's mostly dont work (though some do)????

P.S. if you want to fix the Error loading Groundspawns, all you have to do is add the respawn_timer field. Do a search for that error, as I am not sure of the proper syntax. But I did find it here in the forums. Or you could even just export the field from mw db to myra db ( I think it is the same). I noticed that was missing also. Sorry Myra havent made it to the bug page yet, but I AM writing them down... Great DB


Oh by the way, you can export using MySQL in SQL, but I dont know it, so I used MySQLFront, which just connects to your db in a gui type of manner... Awesome proggie.

[saioncear]

Yes this is happening to every spell.. ill try the pet fix as well but atm i cant even summon pets.. hope i can get this working soon.. its alot of fun =)

thanks for the help
saionce


ps i am using 5.3.. when i first posted this topic i was using 5.2 but i updated it a bit after that.. sorry i didnt clarify sooner..

[edit] i deleted my spells_us.txt from my eq directory and repatched live.. took the new one and put it in the emu directory and it works fairly well!! now i have one last problem to conquer

[torquer]

Hmm, I sourced all the DBs in the order you suggested, samandhi, and its still doing what I reported in this thread here: http://www.eqemulator.net/forums/viewtopic.php?t=12660

[samandhi]

Originally Posted by saioncear

i deleted my spells_us.txt from my eq directory and repatched live.. took the new one and put it in the emu directory and it works fairly well!!

Try doing that. but make sure you are not patching the eq directory you are playing eqemu from, just in case it breaks it.

[saioncear]

already patched it.. i know it works with the latest patch because i did it at school (no way around it) but now i have one more big issue.. the characters are goin across accounts.. like for example.. i have 3 accounts.. well say saioncear eqemu and test... if i make a character on one it puts it on all of them.. is it because of the minilogin.ini saying that they are all from a local address? like if i were at school and i had it like

10.1.18.125 eqemu eqemu
10.1.18.206 saioncear password
10.1.18.126 test password

that it would seperate the characters?
because my ini at home looks like:

127.0.0.1 eqemu eqemu
127.0.0.1 saioncear password
127.0.0.1 test password

if so thatll releive me greatly.. if not can anyone help me? hehe..

i appreciate all the help so far!

saionce

[edit] torquer, delte your spells_us.txt and repatch.. put the repatched spells_us.txt into your emu directory.. worked for me

[wize_one]

Originally Posted by saioncear

already patched it.. i know it works with the latest patch because i did it at school (no way around it) but now i have one more big issue.. the characters are goin across accounts.. like for example.. i have 3 accounts.. well say saioncear eqemu and test... if i make a character on one it puts it on all of them.. is it because of the minilogin.ini saying that they are all from a local address? like if i were at school and i had it like

10.1.18.125 eqemu eqemu
10.1.18.206 saioncear password
10.1.18.126 test password

that it would seperate the characters?
because my ini at home looks like:

127.0.0.1 eqemu eqemu
127.0.0.1 saioncear password
127.0.0.1 test password

if so thatll releive me greatly.. if not can anyone help me? hehe..

i appreciate all the help so far!

saionce

[edit] torquer, delte your spells_us.txt and repatch.. put the repatched spells_us.txt into your emu directory.. worked for me

mini login only looks at the IP(at least it looks that war to me), with your 127.0.0.1 setup the only account that would be able to access the emu would be the eqemu account from the same machine running the emu..


it would be nice if minilogin would look at the IP and name, but for now it doesnt.

[samandhi]

mini login only looks at the IP(at least it looks that war to me)

Yeah wize is right, in other words minilogin only supports one account. you can create more than one LOGIN, but it will basically use the same account.