Cannot connect to RDS Proxy

[notjulian]

Hi,
I'm get this error connecting on AWS RDS Proxy:

2023-07-17T11:02:36.697816+00:00 [error] Error in process <0.2639.0> on node 'emqx@172.31.35.60' with exit value:, {{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}
2023-07-17T11:02:36.697973+00:00 [error] [MySQL] Can't connect to MySQL server: {{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}
2023-07-17T11:02:36.698102+00:00 [error] Supervisor: {<0.2636.0>,ecpool_worker_sup}. Context: start_error. Reason: {{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}. Offender: id={worker,1},pid=undefined.
2023-07-17T11:02:36.698384+00:00 [error] Supervisor: {<0.2634.0>,ecpool_pool_sup}. Context: start_error. Reason: {shutdown,{failed_to_start_child,{worker,1},{{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}}}. Offender: id=worker_sup,pid=undefined.
2023-07-17T11:02:36.698379+00:00 [error] crasher: initial call: ecpool_worker:init/1, pid: <0.2637.0>, registered_name: [], exit: {{{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]},[{gen_server,init_it,6,[{file,"gen_server.erl"},{line,407}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}, ancestors: [<0.2636.0>,<0.2634.0>,emqx_auth_mysql_sup,<0.2632.0>], message_queue_len: 0, messages: [], links: [<0.2636.0>], dictionary: [], trap_exit: true, status: running, heap_size: 2586, stack_size: 28, reductions: 6878; neighbours:
2023-07-17T11:02:36.699059+00:00 [error] Supervisor: {local,emqx_auth_mysql_sup}. Context: start_error. Reason: {shutdown,{failed_to_start_child,worker_sup,{shutdown,{failed_to_start_child,{worker,1},{{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}}}}}. Offender: id=emqx_auth_mysql,pid=undefined.
2023-07-17T11:02:36.699305+00:00 [error] crasher: initial call: application_master:init/4, pid: <0.2631.0>, registered_name: [], exit: {{bad_return,{{emqx_auth_mysql_app,start,[normal,[]]},{'EXIT',{{badmatch,{error,{shutdown,{failed_to_start_child,emqx_auth_mysql,{shutdown,{failed_to_start_child,worker_sup,{shutdown,{failed_to_start_child,{worker,1},{{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}}}}}}}}},[{emqx_auth_mysql_app,start,2,[{file,"emqx_auth_mysql_app.erl"},{line,38}]},{application_master,start_it_old,4,[{file,"application_master.erl"},{line,293}]}]}}}},[{application_master,init,4,[{file,"application_master.erl"},{line,142}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]}, ancestors: [<0.2630.0>], message_queue_len: 1, messages: [{'EXIT',<0.2632.0>,normal}], links: [<0.2630.0>,<0.1516.0>], dictionary: [], trap_exit: true, status: running, heap_size: 610, stack_size: 28, reductions: 221; neighbours:
2023-07-17T11:02:36.699847+00:00 [notice] Application: emqx_auth_mysql. Exited: {bad_return,{{emqx_auth_mysql_app,start,[normal,[]]},{'EXIT',{{badmatch,{error,{shutdown,{failed_to_start_child,emqx_auth_mysql,{shutdown,{failed_to_start_child,worker_sup,{shutdown,{failed_to_start_child,{worker,1},{{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}}}}}}}}},[{emqx_auth_mysql_app,start,2,[{file,"emqx_auth_mysql_app.erl"},{line,38}]},{application_master,start_it_old,4,[{file,"application_master.erl"},{line,293}]}]}}}}. Type: temporary.
2023-07-17T11:02:36.699878+00:00 [error] [Plugins] Load plugin emqx_auth_mysql failed, cannot start plugin emqx_auth_mysql for {bad_return,{{emqx_auth_mysql_app,start,[normal,[]]},{'EXIT',{{badmatch,{error,{shutdown,{failed_to_start_child,emqx_auth_mysql,{shutdown,{failed_to_start_child,worker_sup,{shutdown,{failed_to_start_child,{worker,1},{{badmatch,{error,nxdomain}},[{mysql_conn,connect_socket,1,[{file,"mysql_conn.erl"},{line,160}]},{mysql_conn,'-connect/1-fun-0-',2,[{file,"mysql_conn.erl"},{line,136}]}]}}}}}}}}},[{emqx_auth_mysql_app,start,2,[{file,"emqx_auth_mysql_app.erl"},{line,38}]},{application_master,start_it_old,4,[{file,"application_master.erl"},{line,293}]}]}}}}

the same parameters if I use with other program are working

thanks

PS: maybe related to: mysql-otp 197

[juhlig]

This is probably not related to mysql-otp/mysql-otp#197, or to mysql-otp in general. The error you get here is nxdomain, meaning it could not resolve the hostname you gave in the host option. In mysql-otp/mysql-otp#197, a connection is established but then unexpectedly closed in the handshake/auth phase.