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

[Akkadius]

Originally Posted by Expletus

Local that I wanted to use for the editor. NO biggie I guess I get to miss out on this :( :( :(

There are a ton more issues involved in getting NEW end users to get connected by installing their own web software/site and configuring it than it is to simply open a port and setup a user for Mysql to get started. You will have to think of a different strategy that will allow you to use the platform.

[Xiao]

Amazing amazing amazing stuff. Will be using this extensively. Would love to see quest management put in this, especially with stuff like some of your dev plugins being included (i.e. the Christmas ones). Would also be interesting to see categories in the item/race viewers (swords, spears, daggers/humanoids, undead, dragons). You do amazing work Akka and Trev, keep it up!

[Coenxai]

Server down?

[Akkadius]

Originally Posted by Coenxai

Server down?

Nope, its up?

[Coenxai]

Originally Posted by Akkadius

Nope, its up?

Thanks for the update. I'm going to clear my cache and try again in that case.

Edit: That fixed it.

[rlie_0]

IP address is correct,
User name is correct,
Port 3306 is open (check it),
DB name correct,
Password correct....

Still fails to log in.
Using Windows 7, Linksys E1200 Router, here is my ping test from router

PING 69.168.254.244 (69.168.254.244): 32 data bytes

40 bytes from 69.168.254.244: icmp_seq=0 ttl=52 Time=113.0 ms

40 bytes from 69.168.254.244: icmp_seq=1 ttl=52 Time=114.7 ms

40 bytes from 69.168.254.244: icmp_seq=2 ttl=52 Time=156.5 ms

40 bytes from 69.168.254.244: icmp_seq=3 ttl=52 Time=113.4 ms

40 bytes from 69.168.254.244: icmp_seq=4 ttl=52 Time=108.8 ms

--- 69.168.254.244 data statistics ---

5 Packets transmitted, 5 Packets received, 0% Packet loss

round-trip min/avg/max = 108.8/121.2/156.5 ms

Appears my router can talk ya.

[moofta]

Have you tried http://www.canyouseeme.org/ for that port?

Also, ensure that the MySQL user you are using has remote access rights. I had a problem where I had a user set up, re-imported the db from a backup and it wouldn't let me connect from EOC until I recreated the user (in fact I created a new one which I deleted after my session *paranoid*).

[Akkadius]

Originally Posted by moofta

Have you tried http://www.canyouseeme.org/ for that port?

Also, ensure that the MySQL user you are using has remote access rights. I had a problem where I had a user set up, re-imported the db from a backup and it wouldn't let me connect from EOC until I recreated the user (in fact I created a new one which I deleted after my session *paranoid*).

LOL. I don't do anything with anyone's logins. People who do that snakey shit should die in a fire.

[lerxst2112]

I can telnet to port 3306 on that ip. Seems open, but you could still have a permissions problem or have external logins turned off.

[moofta]

Originally Posted by Akkadius

LOL. I don't do anything with anyone's logins. People who do that snakey shit should die in a fire.

You don't I'm sure, I did emphasise the paranoid aspect

But it's not over TLS/SSL so basically sent in clear text over the net. I am a little paranoid about SQL logins over the net due to things I've encountered at work in the past... Mind you, see http://heartbleed.com/

I think it is fair to say that you should disable the port forwarding on your router after a session though unless you have a compelling reason not to (being lazy is by definition not compelling!)

[Akkadius]

Originally Posted by moofta

You don't I'm sure, I did emphasise the paranoid aspect

But it's not over TLS/SSL so basically sent in clear text over the net. I am a little paranoid about SQL logins over the net due to things I've encountered at work in the past... Mind you, see http://heartbleed.com/

I think it is fair to say that you should disable the port forwarding on your router after a session though unless you have a compelling reason not to (being lazy is by definition not compelling!)

Just restrict remote logins to IP specificly and you'll be fine.

Even with the MySQL hash exploit as long as you restrict via IP you will be fine.

[rlie_0]

Originally Posted by lerxst2112

I can telnet to port 3306 on that ip. Seems open, but you could still have a permissions problem or have external logins turned off.

How do I check the permissions and external logins? I followed all the directions on the first page it all worked as it should without skipping a beat.

Ive just hit a wall in figuring this out. I keep checking re checking, recreating users, different user name, passwords, even attempting different DB names(I got a test server and normal one). Still says I cant connect. Sucks, this looks like a great tool to use.

[AudioGarden21]

Just an FYI, I've been having issues with improperly named fields in the spell editor throwing off several "unknown column '...' in 'field list' errors which have been renamed in the database apparently (I haven't messed with PEQ in quite some time and just fresh-installed today).

I'll go through the whole list of field names on the EoC page (luckily it provides me with everything I need!) and get back to you with updated field names so you can get that fixed up. It'll have to wait a bit because I am as tired as dog shit.

[Akkadius]

I will put it on my list to add another PEQ Editor partition and keep the old one up there for more legacy DB's.

When I put up the new one I will simply add my wrappers that will leverage your same DB info into the new code/schema.

[Akkadius]

Alright, I have created a new PEQ Editor partition which should behave just like the legacy editor in which if you are logged in with your database you should have no problems managing it with the editor. This should have all the latest updates and talk nicely with the latest database schemas.

It is PEQ Editor 421 located at the bottom of the menu list (For Revision 421)