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

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #1  
Old 12-24-2013, 12:21 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by Township EQ View Post
It's running great.

One question I had has to do with the task system. Is making proximities broken or is there something I'm missing? Everything else updates properly but I can't get my proximity data to stay it always just reverts to 0.

edit: I'm getting an update error at the top.

http://gyazo.com/caa069d3fa26553e42f74b5cd42c1fd4.png
I'm not sure about proximities with the task tool, but you can simulate the task update with an invisible NPC and updating their task based on the conditions that you want.

Trevius put the task tool together.
Reply With Quote
  #2  
Old 12-30-2013, 01:10 AM
TylerBarnes
Sarnak
 
Join Date: Dec 2012
Location: Sunny California
Posts: 62
Default

I can't seem to get it to work.
Quote:
Cannot connect to server!
Cannot connect to database "peq"
I made sure 3306 was open, I created a new user with Navicat, tried disabling windows firewall all together and tried it in two different browsers (Chrome/Firefox).
Anyone know of any other work arounds?
Reply With Quote
  #3  
Old 12-30-2013, 01:21 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by TylerBarnes View Post
I can't seem to get it to work.

I made sure 3306 was open, I created a new user with Navicat, tried disabling windows firewall all together and tried it in two different browsers (Chrome/Firefox).
Anyone know of any other work arounds?
Give more information, like what are you trying to put in the EoC DB form for logging in. Your IP Address, are you behind a router that is firewalling your connection?
Reply With Quote
  #4  
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
  #5  
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
  #6  
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
  #7  
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:03 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