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

[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!

[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*).

[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.

[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.

[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)

[AudioGarden21]

Originally Posted by 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)

Awesome!

I just managed to finally copy a spell, which is what I was trying to do when it threw those errors. All seems well atm.

I'll be sure to forward any other issues I come across.

Great work on this thing. I can see it really shaping the future of Emu.

*** EDIT ***

I've come across two problems thus far when messing with spells;

1. - Item 'Spell Search' field under PEQ Editor - Items (under Spells) returns error "Could not connect: Unknown MySQL server host 'omittedIP/Port' (11)

2. - Generate spells_us.txt non-functional - throws error "Error opening spells_us.txt for writing. Make sure the path is writable.

I was able to use PEQ Editor r358 to generate the spell file. I'm not sure if they would be compatible, but it works there nonetheless.

*** EDIT ***

r358 is definitely not compatible. I didn't think it would be lol, but it is what it is. Hopefully this'll all get fixed soon so I can actually export my spells, otherwise it's useless for me to mess with spells anymore since Null's is far too out of date and I have no other exporter.

[Akkadius]

I've corrected the issue with spells_us.txt not generating, was simply a permissions issue with the new build.

[rhyotte]

Oooh! Spell Editor! Doing it the semi-by-hand way gets kinda tedious

[Esildor]

Might be a fail on my end but never received this error before:

When trying to Save an item edit in the EoC(not PEQEditor) I'm getting a 404 not found and the following:

The requested URL /AC/eoc/extitems.php was not found on this server.

Apache/2.2.22 (Debian) Server at eoc.akkadius.com Port 80