search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
520 stars 160 forks source link

create extensions failed #306

Open aolaog opened 1 month ago

aolaog commented 1 month ago

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

1715929124783

surajkharage19 commented 1 month ago

Hi @aolaog,

Can you please try the steps mentioned by @nanren8bang on https://github.com/EnterpriseDB/mysql_fdw/issues/295#issuecomment-2117839592 as he was facing the same issue?