create extensions failed

[aolaog]

Hi, i had compile mysql_fdw source code completely. And i had start my postgresql ,but execute command:
CREATE EXTENSION mysql_fdw;
occured below errors:
postgres=# CREATE EXTENSION mysql_fdw;
ERROR: failed to load the mysql query:
(null)
HINT: Export LD_LIBRARY_PATH to locate the library.

i had add mysql's libs to /etc/ld.so.conf.d/mysql.conf:
/opt/software/mysql-8.3.0/lib
/opt/software/mysql-8.3.0/lib/private
/opt/software/mysql-8.3.0/lib/plugin
/opt/software/mysql-8.3.0/lib/private/sasl2

all is likely normal, but get errors. i had try reinstall mysql_fdw on another server, get the same error? any one can help me ? thanks.
Postgresql version: 15.5
mysql version: 8.3.0
mysql_fdw version: 2.9.0 or 2.9.1

i also review the mysql_fdw's source , and found in mysql_fdw.c has 'failed to load the mysql query' at _PG_init()

[surajkharage19]

Hi @aolaog,

Can you please try the steps mentioned by @nanren8bang on #295 (comment) as he was facing the same issue?