[bogomil]

Hi everybody,

I installed the wordpress plugin and entered the exact same login details as I use with Navicat.
The plugin keeps telling me that it cant connect to the db..

I cant find the reason.

Can somebody help me ?

[RussH]

Hi! I suspect you don't have the target IP address configured?

also - if you're connecting to a remote opencats instance, then you'll have to permit the MySQL traffic. Port 3306 by default? Also - the MySQL user you're logging in as will have to be allowed to log in from the remote server, and not just on localhost.

[bogomil]

Hey Russ,

thank you for your quick reply..
I already did what you said.
I am using aws ecs instance.
I configured the my.cnf file.
Set the user rights for root to access without tunneling.
Also I opened the 3306 port via terminal and set the security group in aws...

After this I can log in my db with Navicat without tunneling..
So shouldnt it work with the plugin ?

Surely I have missed something..

Greetz

[RussH]

Hey - okay next step is to see what's happening

can you check your logs to see if your wordpress site tries to connect out to your opencats installation?
From a command prompt on that wordpress installation, can you telnet to the mysql port?

Do you see a rejected connection attempt on your opencats installation?

Basically - just need to see where it's failing (or being blocked).

[bogomil]

Dear Russ,

thanks for your patience.
So I did what you said "$telnet host port" I also tried with the ip to make sure that I dont have a DNS resultion problem.

In both cases I get: "telnet: Unable to connect to remote host: Connection timed out"

So I guess that after all I did miss something..
Maybe I need to add the wordpress server ip to the cats aws server security group ?

Although I specified 3306 to be accesed by any machine..
My feeling teels me that I missed a security setting in aws but I cant tell what it is.
It is strange that I can get a connection with navicat. As I said I needed before to tunnel to MySql, now I can connect withe username and password.
So it shouldn´t it work from a different remote host?

Greetz

Greetz

[bogomil]

OK I finally know the problem...

My Wordpress hosting service one.com is blocking by default all connections which try to get out there webspace.
This is pretty frustrating, at least I know the problem now.


Thank you for your support and sorry for taking your time.

Greetings,

Bogomil