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

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #1  
Old 01-01-2014, 11:21 PM
TylerBarnes
Sarnak
 
Join Date: Dec 2012
Location: Sunny California
Posts: 62
Default

Sorry for the delay I was busy for the new year.
I am behind a router but I did open the port on both the router and my computer's firewall.
Perhaps I didn't do it right?
Global Port Range: 7000-7100
Protocal: both
Host Port: 3306

I googled "what is my ip" and google told me 108.84.100.62.
I then put Manual DB connection and put
IP:Port: 108.84.100.62:3306
DB Name: peq
Then the login name and password I set when I created the new user.
Reply With Quote
  #2  
Old 01-02-2014, 07:31 PM
Havok2all
Sarnak
 
Join Date: May 2011
Posts: 35
Default

I am pretty much at the same spot. I am concerned whether or not my mysql in set to remotely listen to port 3306.
Reply With Quote
  #3  
Old 01-02-2014, 08:00 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Some common issues are:
  • Your Firewall is not forwarding the port correctly to your internal device (3306)
  • Windows Firewall is blocking your Mysql service (3306)
  • Your Mysql user is not properly configured to allow connections remotely (Root can be set to not allow remote connections)
  • Your Mysql user 'host' is not allowing EoC to connect, either '%' or '69.168.254.244' is not set as the allowed host

EoC won't have an issue connecting to your database given that it is actually visible to the outside world. You have to have everything open for it to be able to even see your Database before it will work correctly. Many users use this successfully however some might find a little difficulty with the initial connection.

Once they are in, the rest is easy.
Reply With Quote
  #4  
Old 01-02-2014, 09:09 PM
Havok2all
Sarnak
 
Join Date: May 2011
Posts: 35
Default

Quote:
Originally Posted by Akkadius View Post
Some common issues are:
  • Your Firewall is not forwarding the port correctly to your internal device (3306)
  • Windows Firewall is blocking your Mysql service (3306)
  • Your Mysql user is not properly configured to allow connections remotely (Root can be set to not allow remote connections)
  • Your Mysql user 'host' is not allowing EoC to connect, either '%' or '69.168.254.244' is not set as the allowed host

EoC won't have an issue connecting to your database given that it is actually visible to the outside world. You have to have everything open for it to be able to even see your Database before it will work correctly. Many users use this successfully however some might find a little difficulty with the initial connection.

Once they are in, the rest is easy.
Thanks for replying Akkadius. I am new to doing this kind of stuff, so learning as I go.

When I create a new user for connecting, should he be written out as so?:

example: 'eocuser'@'69.168.254.244'

In regards to this statement:

Your Firewall is not forwarding the port correctly to your internal device (3306)

I am not sure what this means. I am pretty sure I have my ports open on my firewall for 3306. I even turned everything off to give it try with no luck. Edit: Just to clarify are you saying we need to set up a SSH tunnel for port 3306?
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 05:07 AM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3