lerxst2112,

You sir are da man! It was my router port. Thanks so much for your assistance.

Looks like I got it working.
I used MYSQL to create a new user and granted it privileges.
Here are the links I used to do so just in case anyone else is having these problems.
Thanks for pointing me in the right direction, all.

Creating a new MySQL user
Granting privileges to user

I can't for the life of me get this to work.

I used NaviCat Premium and set up the user as described.
I used gaming rules to open port 3306 (tcp / udp) for my machine (192.168.0.198)
I used incoming rules for windows firewall to allow as described.

All info I put in is correct, whats my ip etc. Just won't connect. :-?

user / pw / db etc all checked and accurate.

Using firefox and even tried in IE8. I'm at a loss.

Did you check your ports on your router? Making sure had one open for port 3306. That was my issue.

Yes sir. Ports are open. Every step has been double checked.

Windows firewall is showing the rule made as allowing the port and the ip address was added (the step 2).

I removed the router and direct connected and still couldn't get connected to the site. Nothing is blocking the port. I got my public ip address... I just don't know where to look now.

Try making a new database connection in Navicat using your external IP address for the host, and 3306 for the port. If that works, then it should prove that your external access stuff is setup properly and then we might need to look into it further why it isn't working for EOC. I suspect that your external access will not work, which would point to further issues on your end.

Most likely, you are running your server on Windows, and you did not enable remote DB access when you installed MySQL. If that is the case, then you should be able to go through the setup settings again like a new install of MySQL and check the box to allow remote connections when going through the setup.

Did everything you told me to, didn't get a connection with the external ip for the host. Re-did MySQL and didn't work either.

I dunno now. I'm kinda up shits creek.

Alright so I rand a http://localhost:3306/ in my browser and got the following:

Any ideas ?

3306 Port Closed - Connection timed out

according to http://www.ipmango.com/network/port_forward

I've tried everything I can. I'm wondering if anyone knows if verizon blocks this port with their 4G usb cards? Everything is done according to the steps given. Getting mad now ;)

Expletus, 3306 is not a web browser port. Are you reading the instructions on the first page? Everything is listed there.

Yes I did around 10-12 times now. That was me trying to see if my port was open, which I later learned was not the way. So that's my bad.

I'm just trying to figure out of my usb verizon pantech uml290 blocks that port naturally. Everything else is in line with the directions however this port just won't open.

Looks like I found my answer.
http://www.4ginfo.com/index.php/veri...lications.html

apparently they do not allow any sort of port forwarding.

You are trying to run a server on cellular? Or was this just a local server that you want Akkaidus' tools for?

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.

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!

Server down?

Nope, its up?

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

Edit: That fixed it. :)

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.

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.

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.

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.

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.

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.

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.

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)

http://i.imgur.com/dlpP0mP.png

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.

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

You sir, are a sexy man. ;)

Whut

/10char

Just commending you on your prompt fixes and responses. =D

Also, is there any plan to add an import feature? Or perhaps an assignment to "lowest spell ID available" option?

I'm running into the spell count overflow issue using my SoF client, and with no way to import my old spell file from way back I'm sort of stuck in a rut.

The PEQ editor is not my work so you'd have to ask them. I do plan on writing an extensive spell editor here soon though

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

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

Try it again sir

Yup, it's working again, Nice!