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

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2014, 09:47 PM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,742
Default

You don't need a tunnel, you need port 3306 on your router forwarded to port 3306 on the machine with MySQL running on it.

When you say:
Quote:
Global Port Range: 7000-7100
Protocal: both
Host Port: 3306
It sounds like you did it wrong.
Reply With Quote
  #2  
Old 01-02-2014, 10:12 PM
Havok2all
Sarnak
 
Join Date: May 2011
Posts: 35
Default

lerxst2112,

You sir are da man! It was my router port. Thanks so much for your assistance.
Reply With Quote
  #3  
Old 01-03-2014, 01:48 PM
TylerBarnes
Sarnak
 
Join Date: Dec 2012
Location: Sunny California
Posts: 62
Default

Looks like I got it working.
I used MYSQL to create a new user and granted it privileges.
Here are the links I used to do so just in case anyone else is having these problems.
Thanks for pointing me in the right direction, all.

Creating a new MySQL user
Granting privileges to user
Reply With Quote
  #4  
Old 01-05-2014, 09:38 PM
Expletus
Hill Giant
 
Join Date: Jan 2010
Location: Baltimore Maryland
Posts: 152
Default

I can't for the life of me get this to work.

I used NaviCat Premium and set up the user as described.
I used gaming rules to open port 3306 (tcp / udp) for my machine (192.168.0.19
I used incoming rules for windows firewall to allow as described.

All info I put in is correct, whats my ip etc. Just won't connect.

user / pw / db etc all checked and accurate.

Using firefox and even tried in IE8. I'm at a loss.
__________________
Expletus / Volgar
Reply With Quote
  #5  
Old 01-07-2014, 05:22 PM
Havok2all
Sarnak
 
Join Date: May 2011
Posts: 35
Default

Did you check your ports on your router? Making sure had one open for port 3306. That was my issue.
Reply With Quote
  #6  
Old 01-08-2014, 08:54 AM
Expletus
Hill Giant
 
Join Date: Jan 2010
Location: Baltimore Maryland
Posts: 152
Default

Yes sir. Ports are open. Every step has been double checked.
__________________
Expletus / Volgar
Reply With Quote
  #7  
Old 01-08-2014, 10:05 AM
Expletus
Hill Giant
 
Join Date: Jan 2010
Location: Baltimore Maryland
Posts: 152
Default

Windows firewall is showing the rule made as allowing the port and the ip address was added (the step 2).

I removed the router and direct connected and still couldn't get connected to the site. Nothing is blocking the port. I got my public ip address... I just don't know where to look now.
__________________
Expletus / Volgar
Reply With Quote
  #8  
Old 01-08-2014, 01:09 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Try making a new database connection in Navicat using your external IP address for the host, and 3306 for the port. If that works, then it should prove that your external access stuff is setup properly and then we might need to look into it further why it isn't working for EOC. I suspect that your external access will not work, which would point to further issues on your end.

Most likely, you are running your server on Windows, and you did not enable remote DB access when you installed MySQL. If that is the case, then you should be able to go through the setup settings again like a new install of MySQL and check the box to allow remote connections when going through the setup.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
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 12:30 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3