EOC BETA Launch (Developer's Tool) EQEmu Operations Center

[xplodr]

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.

[Akkadius]

Originally Posted by xplodr

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.

[xplodr]

How do i set up another user?

[Akkadius]

Originally Posted by xplodr

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

[xplodr]

I did what it says and as far as i can tell the users were created however it still won't let me login

[xplodr]

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.

[xplodr]

Whenever I try to connect to my server through navicat it also times out

[Akkadius]

Originally Posted by xplodr

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?

[xplodr]

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.

[xplodr]

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?

[xplodr]

Or set up a sort of firiona vie ruleset?

[Cylex]

The tool is great, and the Project Editor is amazingly useful.

There is a minor thing I noticed; when using it to create a new loot drop, it will not process the request, as there is no probability field.

[ZionPhoenixGM]

Disregard got it. was using the wrong IP

[Bodmingaol]

Never mind....lol I figured it out..../facepalm

Thanks,

Bodmin

[Raghnar]

EOC is the only tool I use now. There are a few things I cannot do here that I still do by hand in the db itself, but EOC is much easier.

Task editing seems a little buggy and updates to fields sometimes do not show up, but as long as I am paying attention and know which ones I have updated then no problems and the tasks work fine.

If I am mass tuning npcs in a zone then it is usually just easier to do that in Heidi or MySQL Command Center, but for tweaking individual npcs or loot tables I use EOC.

For some reason when editing spells if the spell is checked as uninteruptable, EOC's query fails on update:

Query failed:
UPDATE spells_new SET `uninterruptable` = "on" WHERE id=1617 - Incorrect integer value: 'on' for column 'uninterruptable' at row 1