Tuesday 22 September 2020

Remote MySqli Connection timeout only while connecting via Apache2

I am facing a problem on Ubuntu 18.04 Apache EC2 Machine/Server - 172.2.27.1 that mysqli is not getting connected there to MariaDB Server - 172.2.27.2 (remote mysqli server), but it gets connected via localhost (as currently 172.2.27.1 machine has MariaDB installed on it as well), also the remote connection to 172.2.27.2 is establishing over the Terminal:

mysql -h 172.2.27.2 -u test -p (on 172.2.27.1 Machine)

Unable to understand what could be the exact issue for it. I have tried debugging all possible locations but couldn't find any.

While connecting with Apache it is giving error:

Object
(
    [affected_rows] => 
    [client_info] => 
    [client_version] => 50012
    [connect_errno] => 2002
    [connect_error] => Connection timed out
    [errno] => 
    [error] => 
    [error_list] => 
    [field_count] => 
    [host_info] => 
    [info] => 
    [insert_id] => 
    [server_info] => 
    [server_version] => 
    [stat] => 
    [sqlstate] => 
    [protocol_version] => 
    [thread_id] => 
    [warning_count] => 
)


from Remote MySqli Connection timeout only while connecting via Apache2

No comments:

Post a Comment