opencats.org

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 ?

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.

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

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

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

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