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

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #16  
Old 03-23-2013, 04:47 AM
Burningsoul
Banned
 
Join Date: Oct 2009
Posts: 312
Default

No worries on the large screengrabs - this looks AMAZING. I'll get you some feedback after getting my DB synched with it. Thank you for the incredible work put into this - it'll help out many a noob server op.
Reply With Quote
  #17  
Old 03-23-2013, 05:07 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Burningsoul View Post
No worries on the large screengrabs - this looks AMAZING. I'll get you some feedback after getting my DB synched with it. Thank you for the incredible work put into this - it'll help out many a noob server op.
Not even for noob server ops, I wish I had this when I was actively server developing.
Reply With Quote
  #18  
Old 03-24-2013, 04:16 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

I'm going to be creating a local database reference for the EoC platform so I can implement users, allow users to create logical 'servers' and then they can create developers to work on those servers.

So if EoC is behaving a bit whack, that's because I'm developing on the BETA production.
Reply With Quote
  #19  
Old 03-31-2013, 09:56 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Made a fix to the Item Editor today, apparently when I made the last fixes I broke the miscellaneous fields from even showing which messes up the Mysql query save generation.
Reply With Quote
  #20  
Old 05-24-2013, 02:05 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

I can't get EOC to connect to my database. I type in everything to login and i have forwarded port 3306 to my servers IP within my network yet it tells me it cannot connect. I'm wondering what i'm doing wrong. In the IP:Port box I type my Ip address then : and then the port 3306. The the database name which I have left as peq then my username and password. I don't understand what i'm doing wrong.
__________________
Why Windows Vista is BAD
Reply With Quote
  #21  
Old 05-24-2013, 02:17 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by xplodr View Post
I can't get EOC to connect to my database. I type in everything to login and i have forwarded port 3306 to my servers IP within my network yet it tells me it cannot connect. I'm wondering what i'm doing wrong. In the IP:Port box I type my Ip address then : and then the port 3306. The the database name which I have left as peq then my username and password. I don't understand what i'm doing wrong.
Are you using root?

Because your setup may have included that root cannot be used from outside connections period.

You may have to setup another user and use that user that can accept connections from anyone and then give that user privileges.
Reply With Quote
  #22  
Old 05-24-2013, 02:37 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

How do i set up another user?
__________________
Why Windows Vista is BAD
Reply With Quote
  #23  
Old 05-24-2013, 02:43 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by xplodr View Post
How do i set up another user?
Easy to do in Navicat, you go to Manage Users. Otherwise if you don't have Navicat, you have to use:

https://www.digitalocean.com/communi...sions-in-mysql

EDIT: Instead of doing localhost, you would do % to signify it would come from anywhere. Or you could lock it down to my server and have @69.168.254.244

Last edited by Akkadius; 05-24-2013 at 03:06 AM..
Reply With Quote
  #24  
Old 05-24-2013, 03:48 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

I did what it says and as far as i can tell the users were created however it still won't let me login
__________________
Why Windows Vista is BAD
Reply With Quote
  #25  
Old 05-24-2013, 04:00 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

Also, I downloaded navicat but I can't figure out what to do with it when I have it up. Like how to load the database or anything.
__________________
Why Windows Vista is BAD
Reply With Quote
  #26  
Old 05-24-2013, 04:04 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

Whenever I try to connect to my server through navicat it also times out
__________________
Why Windows Vista is BAD
Reply With Quote
  #27  
Old 05-24-2013, 06:53 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by xplodr View Post
Whenever I try to connect to my server through navicat it also times out
Can you give a bit more detail as to what you are doing when you try to connect to your server?
Reply With Quote
  #28  
Old 05-25-2013, 01:53 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

When I click the connection button upon opening navicat and use my personal IP address and port 3306 and fill out the rest of the connection with the username and password for MySQL it fails to connect. Could it be a firewall issue? usually my firewall asks me to unblock something if it detects something but it never asked.
__________________
Why Windows Vista is BAD
Reply With Quote
  #29  
Old 05-25-2013, 04:47 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

I finally got it to work! I think it was my firewall, I turned it off and logged in like a charm. Now I have some questions about how to use it haha. Is there a way to remove no trade from all items and instead make all items attunable?
__________________
Why Windows Vista is BAD
Reply With Quote
  #30  
Old 05-25-2013, 04:56 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

Or set up a sort of firiona vie ruleset?
__________________
Why Windows Vista is BAD
Reply With Quote
Reply


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