setup new personal server

[hoosierbilly]

I will be going to work at southpole within few days.
I am trying to setup a server on my windows laptop so I can continue to play EQ without internet.
I have tried to follow the various server guides, but find that they are old and refer to files (MySQL & Perl) that are no longer availible.

I am NOT computer literate and don't understand some of the instruction in the guides.

Can someone point to the a current, most up to date guide to setup up a server? and help me to understand how to set up a server?


Thanks

[Furniture]

If you are not computer literate as you say and if your not going to have internet soon for support, id reccomend just getting the peq repack, from here:

http://www.georgestools.chrsschb.com//

The program should do all the work of setting up the server for you. I don't believe it comes with the server maps though. Your going to have to google tortisesvn and download/install that program. Then you will have to right click on your maps folder in the install directory wherever the peqrepack installed to, click SVN Checkout, and put in the following URS: http://eqemu-maps.googlecode.com/svn/trunk/

This will start downloading all the missing maps.


To get your client to access your loginserver your going to want to change the eqhost file to read localhost:5999

[hoosierbilly]

Thank you very much Furniture.

I have only two problems/questioins:
How do I create or upgrade an account to GM 120 level?
How do I get the underfoot client to work?

[c0ncrete]

drop to a command prompt and run this to give an account access to all commands:

mysql -u<mysql username> -p<mysql password> --database=<emu database name> -e "UPDATE account SET status=255 WHERE name='<emu account username>' LIMIT 1;"

note: everything in red will need to be changed to fit your setup.

[hoosierbilly]

Thank you for responding. I finally figured out how to make a GM account.

Now if I could just get teh underfoot client to work :(

[Furniture]

theres no reason its not working, whats the problem?

[Furniture]

i dont know if you cant get in from just the underfoot client or what,

First of all, did you set up your own loginserver via the repack?

[VileDeeds]

when you say to change eqhost file to 5999, is that in the one in the eq titanium file?

[VileDeeds]

Also i cant get it to run at all, it stops at ...Telling zone to use port 7004 and the server says sleeping. I feel to stupid to be able to do this considering i have been tring to get one of these to work for a week or more

[VileDeeds]

Sorry for being a numbskull, i guess my frustration automatically made me think things were not working when in reality they were. i got the server up and running i just had a few questions.
1. where do i type the command promt for gm access, i opened cmd through run and typed it in but it did not reconize the command. how do i access the mysqyl cmd promt?
2.My wife and i will be staying with her mother for a few months while she recovers from a health issue. how do i run this on a LAN so we can play while we have no internet access?

[c0ncrete]

i have no idea how the repack installs mysql, honestly. what happens when you just run the following from a command prompt?

mysql -V

[VileDeeds]

it says " 'mysql' is not recognized as an internal or external command, operable program or batch file"

same thing it says when i put the command in for gm access

[Noport]

here you go VileDeeds for playing eq off line at mother-in-laws house.
follow this url http://www.eqemulator.org/forums/showthread.php?t=35057

mysql -uroot -ppassword

If you really want access to the internet at mother-in-laws house i would ask you if you had a extra wireless router? if you do then i'll show you how to get free internet.
I understand i been married 23yrs-present and my wife mother has no internet access so i take the internet with me

[c0ncrete]

you're probably better off ignoring noport's suggestions, as he usually supplies random, barely intelligible information that is either slightly applicable, or not at all.

the message you've supplied indicates that your windows environment (path) doesn't know where to find the mysql bin directory. i'm not certain if it's because of how the repack installs or not, as i haven't ever used it. you'll have to look in the directory you installed the repack and see if there is a mysql directory. you should find the executable you need to run in there. you can switch to that directory in a command prompt and then execute the line i supplied to give an account full access.

as for running a lan only server, does the repack include EQEmuLoginServer.exe?

[c0ncrete]

not to derail the thread or anything...

i know that feel, bro. i got married when i was 9 and i steal internet at my mother in law's house because i'm cool. i'll tell you how to do it if we can be best friends!

[Noport]

c0ncrete so are you replaying when you goto McDonalds,Hardee's, a free wifi hot spot you are stealing internet. no it's no diffent then you sittng at McDonalds using the internet in the comfort of you own home. 80)

[Caryatis]

going to work at southpole

Protip: thats not a strip club.

[naveed]

Im having the same issue..but after poking around the repack I found this in the config file. I believe it holds the answer to our problems.

# Paths
# ........Path to mysql bin folder
binpath=W:\usr\local\mysql\bin
################################################## #####
# Path to sql\updates for core (last slash not needed)#
# These will be created if they do not exist.. #
# so dont bother setting these #
################################################## #####
updpath=sql\updates
# Path to backup folder
backuppath=backup

# Settings for connection to database
user=root
pass=eqemu
axcdb=ax_classic
logindb=login
peqdb=peq
characterpath=backup\toonswap
host=localhost
port=3306

[hoosierbilly]

I am using teh repak as suggested from http://www.georgestools.chrsschb.com//

The titanium cleint is working properly but I can't get the underfoot client to log into the server. It simple hangs-up at "logging into server" after I enter my user and password. It would be super if could get teh underfoot client working, but the repak states that it only uses titanium and SOD clients. If someone knows a way to set it up for underfoot that would be great.