Go Back   EQEmulator Home > EQEmulator Forums > Development > EQEmu Operations Center

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2019, 11:11 PM
sklead's Avatar
sklead
Sarnak
 
Join Date: Jul 2005
Posts: 37
Default EOC Connection [Guide]

Hello All,

I know there are many other posts that troubleshoot connection help when it comes to EOC as well as the wiki, but I still see a lot of posts that are asking for help. I'm hoping this helps others, as it's a process I go through any time I have issues connecting.

Step 1) Opening Ports

First, go to https://www.canyouseeme.org/ and add your IP address and make sure "Port" is 3306. If you don't know your IP you can go to https://www.whatismyip.com/ and use the IPv4 line.



If it doesn't say "Success" then port 3306 is closed!

To open your ports:

- Go to your firewall. In Windows 10 just click the Windows button in the bottom left and start typing Windows Defender Firewall.

- Right click Inbound Rules > New Rule



- Click Port > TCP & Specific local ports. Enter 3306 and click Next



- Click Allow the connection, click Next

- On the next screen leave all 3 boxes checked, click Next

- Name your rule anything you want

Now you need to open the port on your router.

- Go to your router page. This is usually 192.168.0.1 in your web browser

- It varies by the router, but find the Firewall or Ports page. Mine is under Advanced and Port Forwarding, yours may be similar

- Make sure the Type is TCP&UDP, Start and End Port is 3306

Now check https://www.canyouseeme.org/. It should say Success now if it didn't before.

Step 2) Setting Up HeidiSQL

HeidiSQL comes with the server installation, but whatever database editing program you use is what you'll need to do the following steps in.

- Open HeidiSQL and click Manage user authentication and privileges



- Click Add

- Your Username is whatever you want as well as the password. The From Host can either be % or 142.44.176.142. Using % will allow any connection whereas 142.44.176.142 will only allow EOC, therefore it is more secure, but either will work.

- Ensure you have Global privileges checked!



Step 3) Connecting to EOC

- Go to http://eoc.akkadius.com/EOC2/login.php

- Line 1 is YOUR IP address. You can use https://www.whatismyip.com if you don't know.

- Line 2 is your database name, "peq" (no quotes) by default

- Line 3 is the username you setup in HeidiSQL in the previous step and Line 4 is the password



- Click Verify connection

And you should be in! I tried breaking this down Barney style for people who may not be technologically inclined (as I am not either). Again, Akkadius laid it out well in his post about EOC and in the wiki, but hopefully this helped someone.
__________________
In my defens, God me defend
Reply With Quote
  #2  
Old 08-18-2019, 07:27 PM
Sintox
Fire Beetle
 
Join Date: May 2017
Posts: 1
Default

Great guide nice work. The only thing is when you setup HiediSQL don't put in a password. I did and couldn't login to the PEQ editor. I read this,

Create your Database User

To create your database user you will need to run the query below to create your database user:
This will allow connections only from EOC via the specified user below, you shouldn't need to change the password because you are only allowing from the EOC server

Shouldn't need to change the password so I deleted it in Heidi and was able to login.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:51 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3