EQEmulator Forums - Remote Admin Access

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Remote Admin Access - DB files (https://www.eqemulator.org/forums/showthread.php?t=36325)

Eq4Life2

01-23-2013 11:48 PM

Remote Admin Access - DB files

Ok - First - New to this -

My friend and I have recently gotten a server set-up, its listed and anyone can log in. Question we both have at this point, he has it hosted from his computer, so all files are located there. How do we configure, and most importantly what do we configure, to allow my system to remote in to access the files to tweak them?

Example: I DL'd George's tools on my system and I want to create/add items to the server remotely. Open "EQITEM" or a like program on my system and have them saved onto the server. I am not exactly sure how to set it up to be modifying the server file.

Any assistance would be GREATLY appreciated, thanks in advance folks.

lerxst2112

01-24-2013 12:07 AM

Google for "MySQL remote access"

Eq4Life2

01-24-2013 12:35 AM

Ok once we have the access resolved, what is the set-up with the EQITEMS type program?

Zamthos

01-24-2013 12:39 AM

Would be more of a GeorgeS section question, but I'll help you out to the best of my abilities.

Code:

host=localhost ##Host

user=root ##username

password=root ##password

database=peq ##database

everquest_folder= ##location of client folder

quest_folder= ##location of quests folder

Eq4Life2

01-24-2013 12:40 AM

What I mean is

host= (IP Address and port?)
user=(whatever my user is)
password=obvious
database=obvious (what format tho? i.e. http://ipadddress:port/x/x/x/x?
everquest_folder=c:users\administrator\desktop\etc \etc or ?

Zamthos

01-24-2013 12:54 AM

No, there is no need for port, the quests folder is not listed in what you typed, the database is the name of the database, for example, 'peq', the most common database in EverQuest Emulator, your EverQuest/Quests folder is the location, and that's it, so like C:\eqemu\quests or C:\EverQuest.

Example:

Code:

host=localhost

user=root

password=root

database=peq

everquest_folder=C:\EverQuest

quest_folder=c:\EQEmu\quests

lerxst2112

01-24-2013 12:57 AM

host: the ip address or dns name of the remote machine
database: whatever the database is named, probably 'peq'
everquest_folder: wherever you have the client installed on your local machine.

Eq4Life2

01-24-2013 01:17 AM

Quote:

Originally Posted by lerxst2112 (Post 216959)

host: the ip address or dns name of the remote machine
database: whatever the database is named, probably 'peq'
everquest_folder: wherever you have the client installed on your local machine.

dumb question (not a truly savvy guy)

host=xxx.xxx.xx.xxx or http://xxx.xxx.xx.xxx?

lerxst2112

01-24-2013 02:19 AM

Just the IP address or hostname.

Noport

01-24-2013 02:37 AM

i recommend using ESF Database Migration Toolkit Professional Editon 7.4.14

Eq4Life2

01-24-2013 02:38 AM

thanks Lerx

c0ncrete

01-24-2013 05:46 AM

ssh tunneling ftw

jdoran

01-24-2013 04:27 PM

Speaking of ports, if you are using a router make sure that it passes database traffic. Port 3306 is used by mysql.

All times are GMT -4. The time now is 04:31 AM.