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

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #31  
Old 05-28-2013, 11:46 PM
Nerdgasm
Discordant
 
Join Date: Apr 2013
Posts: 419
Default

Code:
Cannot connect to server!
Cannot connect to database "peq"

Is the error I get, all information is typed right.
__________________
I am the All Mighty Mittens!
Reply With Quote
  #32  
Old 05-28-2013, 11:57 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Nerdgasm View Post
Code:
Cannot connect to server!
Cannot connect to database "peq"

Is the error I get, all information is typed right.
Are you NATing your server? It will need to connect to your external IP (Public).

For an open public scenario (Public Address right on server) you simply need to enter your Internet facing address in the manual DB connection and your database info.

For a NAT private network scenario, you WILL need to forward ports (3306) in order for EoC to straddle your database

I made a drawing for this somewhere...


Last edited by Akkadius; 05-29-2013 at 12:03 AM..
Reply With Quote
  #33  
Old 05-31-2013, 08:21 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

There's been quite abit of use of this lately. I'm waiting to hear what people think of it so far.
Reply With Quote
  #34  
Old 06-02-2013, 09:43 AM
Cylex
Fire Beetle
 
Join Date: Apr 2013
Location: Fort Worth, TX
Posts: 7
Default

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.
Reply With Quote
  #35  
Old 06-27-2013, 02:31 PM
ZionPhoenixGM's Avatar
ZionPhoenixGM
Fire Beetle
 
Join Date: Mar 2013
Posts: 11
Default

Disregard got it. was using the wrong IP
Reply With Quote
  #36  
Old 07-03-2013, 02:26 AM
Bodmingaol
Fire Beetle
 
Join Date: Jun 2010
Location: Oregon, USA
Posts: 26
Default

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

Thanks,

Bodmin
Reply With Quote
  #37  
Old 07-04-2013, 04:46 AM
jsr
Hill Giant
 
Join Date: Aug 2008
Location: melbourne
Posts: 187
Default

this looks great, but I can't seem to get a db connection working. Here's what I've done;

1) Added port forward rule to router for TCP port 3306 to my mysql server IP

2) On the mysql server (windows 7), added firewall rule
- service MYSQL
- port 3306
- scope 69.168.254.244

3) Added a mysql user with host '%' and flushed privileges


Eq operations reports a connection error. Am I missing a step?
Reply With Quote
  #38  
Old 07-04-2013, 06:29 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Quote:
Originally Posted by jsr View Post
this looks great, but I can't seem to get a db connection working. Here's what I've done;

1) Added port forward rule to router for TCP port 3306 to my mysql server IP

2) On the mysql server (windows 7), added firewall rule
- service MYSQL
- port 3306
- scope 69.168.254.244

3) Added a mysql user with host '%' and flushed privileges


Eq operations reports a connection error. Am I missing a step?
Are you able to connect to your DB from your PC using a tool like Navicat with the same settings you are trying to use for EOC? If you try using your external IP for the connection, I think that should verify if you are setup to allow remote connections.

I don't use MySQL on windows too often, but I believe there is a setting when you install it which lets you enable remote connections. I don't know how to adjust that after installing it offhand, but you may be able to just run the MySQL install again and change that setting this time through. Make sure to backup your DB before trying anything like that just in case!
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #39  
Old 07-04-2013, 07:38 AM
jsr
Hill Giant
 
Join Date: Aug 2008
Location: melbourne
Posts: 187
Default

Nope, I can connect from local host but not to the external IP.

The only thing that feels like progress is when I use my default gateway IP, it gives an immediate connection error. Otherwise if I use my public IP (i.e. the one you'd see if you type "what's my IP" in google) or an invalid IP (201.201) it times out with a connection error.

Clearly I'm doing something wrong but I'm stumped.. I've added inbound and outbound filewall rules for port 3306 - in fact I've opened my firewall to the point where I'm sitting here paranoid, and the port forwarding is setup as per the rules for the emu server (which works fine).

If someone has this setup for a windows server and could describe the steps they took it would be great

p.s. I reconfigred mysql to make sure it was setup for remote connections (I think all it does is add a firewall rule).
Reply With Quote
  #40  
Old 07-04-2013, 09:58 AM
jsr
Hill Giant
 
Join Date: Aug 2008
Location: melbourne
Posts: 187
Default

Ok it was pretty straightforward in the end, I was confusing things by limiting connections to 1 .. and then using that connection to test locally /kick

Creating a MySQL user:
If using Navicat;
- Click 'User' on the main ribbon
- Right click 'root@localhost'
- Choose 'duplicate user'
- In the username field, change it to something preferable to root_Copy (or keep it if you think it has a nice ring to it)
- In the host field, replace 'localhost' with '69.168.254.244'
- In the password/confirm password fields, enter a secure password. Note: A long password (e.g. dogsandcatslikerawfishfordinner) is exponentially more secure than one with uppercase, lowercase, numbers, and symbols while also being much easier to remember
- Under the advanced tab, change 'max user connections' to 1
- Under the server privileges tab, uncheck the privileges 'File', 'Process', 'Drop', 'Shutdown', 'Super', and 'Create user' (there may be others worth disabling)
- Click Save

If you're using mysql command line you're either a) clever enough to do this part by yourself, or b) you should really get a copy of Navicat as it will improve your quality of life.

To create a filewall rule:
In windows firewall
- Click new rule
- Select 'Port' and click next
- Select 'TCP and specific local ports', enter 3306, click next
- Select 'Allow the connection', click next
- Select the appropriate network type ('domain', 'private', 'public'). This will typically be private but if in doubt tick them all. Then click next
- Enter a name for the rule (e.g. Incoming Mysql), click finish

For extra security:
- Refresh the list of rules (F5)
- Locate the new rule (e.g. Incoming Mysql) in the list, right click and choose Properties
- Under the scope tab, find Remote IP address and select 'These IP addresses'
- Click Add, select 'This IP or subnet'
- Enter 69.168.254.244
- Click Ok, and then click Ok again
Reply With Quote
  #41  
Old 07-04-2013, 10:50 AM
jsr
Hill Giant
 
Join Date: Aug 2008
Location: melbourne
Posts: 187
Default

Akkadius and Trevius, at a glance this looks fantastic and will hopefully replace the tools I've been writing for myself! I'll give it a good workout over the next month or so and provide feedback.

Any preference on how you want to track feedback?
Reply With Quote
  #42  
Old 07-04-2013, 02:44 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Added your Mysql instructions to the placeholder post.

As far as feedback, I've used the tool extensively myself and I kind of know what needs to be done, however it doesn't hurt to have more.

EoC has been getting used very much but no one has been really coming forth and saying anything about it. But I know who is using it based on IP requests

The tools we created in it help a lot for customization development, but the PEQ Editor still is very much used by myself, very easy to setup.
Reply With Quote
  #43  
Old 07-04-2013, 03:34 PM
Secrets's Avatar
Secrets
Demi-God
 
Join Date: May 2007
Location: b
Posts: 1,447
Default

Make sure your MySQL connection isn't set up to use @% hostmasks. There was a pretty big exploit regarding that a few months back (that was patched in recent versions), and make sure you have a proper firewall installed for the MySQL server to prevent further exploits:

http://thehackernews.com/2012/06/cve...ous-mysql.html
Reply With Quote
  #44  
Old 07-04-2013, 05:13 PM
Raghnar
Fire Beetle
 
Join Date: Feb 2010
Location: San Diego
Posts: 16
Default

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
Reply With Quote
  #45  
Old 07-04-2013, 06:07 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Sounds like you're using the PEQ Editor - which is going to fight with database schematic differences as well.

I've had a few things bomb out in PEQ Editor as well but nothing too crazy.

I could probably look at upgrading that partition of EOC.

As far as mass zone NPC editing type stuff, I do a lot of that through queries myself, though I have had thoughts in my head about doing mass NPC editing through EOC but I've been busy with other things.

As far as the task updating 'bug' what that really is, is you haven't changed the activity type value. This isn't necessarily an issue with you as it is the task editor should default that field to something else initially because it only 'updates' when the field has been changed, this is simple to fix. EDIT: I fixed the bug, the first field that pops up initially is '--- Select Activity Type ---' which defaults to 0, whenever the field changes it will update accordingly

Last edited by Akkadius; 07-04-2013 at 06:13 PM..
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 12:31 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