Comments (9)
Setting LD_LIBRARY_PATH
nor DYLD_LIBRARY_PATH
in $HOME/.bashrc worked for me when using PostgresApp on Mac OSX. It seems to ignore these environment variables when starting the helper app on login.
However, copying the file libmysqlclient.XYZ.dylib
from MySQL's download to /usr/local/lib/libmysqlclient.dylib
and restarting PostgesApp solved this problem for me. This works because the dlopen() system call as a final resort also looks into /usr/local/lib
, as long as environment variable DYLD_FALLBACK_LIBRARY_PATH
is not set.
Read man dlopen
for more info.
from mysql_fdw.
You need to export the DYLD_LIBRARY_PATH on Mac OS
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/
On Thu, Jan 15, 2015 at 2:30 PM, Dataground [email protected]
wrote:
Mac OS-X 10.9.5: I followed instructions
All went well.I tried:
CREATE EXTENSION mysql_fdw;I Got:
ERROR: failed to load the mysql query:
dlopen(libmysqlclient.dylib, 1): image not found
HINT: export LD_LIBRARY_PATH to locate the library********** Error **********
ERROR: failed to load the mysql query:
dlopen(libmysqlclient.dylib, 1): image not found
SQL state: HV00L
Hint: export LD_LIBRARY_PATH to locate the library—
Reply to this email directly or view it on GitHub
#36.
Ibrar Ahmed
EnterpriseDB http://www.enterprisedb.com
from mysql_fdw.
Still no luck..
export DYLD_LIBRARY_PATH=/usr/local/mysql-connector-c-6.1.5-osx10.7-x86_64/lib
/Applications/Postgres.app/Contents/Versions/9.4/bin > ./psql
psql (9.4.0)
Type "help" for help.
pim=# CREATE EXTENSION mysql_fdw;
ERROR: failed to load the mysql query:
dlopen(libmysqlclient.dylib, 1): image not found
HINT: export LD_LIBRARY_PATH to locate the library
pim=#
from mysql_fdw.
It should work, please do these steps.
1 - Stop the postgres server
2 - On the same shell export DYLD_LIBRARY_PATH=/usr/local/
mysql-connector-c-6.1.5-osx10.7-x86_64/lib
3 - Start postgres server
4 - ./psql
5 - CREATE EXTENSION mysql_fdw;
Please send me listing of /usr/local/mysql-connector-c-6.1.5-osx10.7-x86_64/lib
folder.
ls /usr/local/mysql-connector-c-6.1.5-osx10.7-x86_64/lib
On Thu, Jan 15, 2015 at 8:13 PM, Dataground [email protected]
wrote:
Still no luck..
export
DYLD_LIBRARY_PATH=/usr/local/mysql-connector-c-6.1.5-osx10.7-x86_64/lib/Applications/Postgres.app/Contents/Versions/9.4/bin > ./psql
psql (9.4.0)
Type "help" for help.pim=# CREATE EXTENSION mysql_fdw;
ERROR: failed to load the mysql query:
dlopen(libmysqlclient.dylib, 1): image not found
HINT: export LD_LIBRARY_PATH to locate the library
pim=#—
Reply to this email directly or view it on GitHub
#36 (comment)
.
Ibrar Ahmed
EnterpriseDB http://www.enterprisedb.com
from mysql_fdw.
It works! Thanks! I forgot to restart the server before...
from mysql_fdw.
Can I just add... after some frustration, on Mac OS X Yosemite it is not enough to sudo launchctl unload and load postgres to effect this - you actually have to su -m _postgres and use pg_ctl to stop and start.
cheers
Ben
from mysql_fdw.
I still have the issue, not sure if i did smth wrong but i can't get it to work.
echo $LD_LIBRARY_PATH
# /usr/local/mysql/lib:/usr/local/mysql-5.6.16-osx10.7-x86_64/lib/:
ls -l /usr/local/mysql-5.6.16-osx10.7-x86_64/lib/
# total 555328
# -rwxr-xr-x 1 myuser admin 4282344 Jan 14 2014 libmysqlclient.18.dylib
# -rw-r--r-- 1 myuser admin 10599048 Jan 14 2014 libmysqlclient.a
# lrwxr-xr-x 1 myuser admin 23 Mar 3 2014 libmysqlclient.dylib -> libmysqlclient.18.dylib
# lrwxr-xr-x 1 myuser admin 23 Mar 3 2014 libmysqlclient_r.18.dylib -> libmysqlclient.18.dylib
# lrwxr-xr-x 1 myuser admin 16 Mar 3 2014 libmysqlclient_r.a -> libmysqlclient.a
# lrwxr-xr-x 1 myuser admin 20 Mar 3 2014 libmysqlclient_r.dylib -> libmysqlclient.dylib
# -rw-r--r-- 1 myuser admin 133369856 Jan 14 2014 libmysqld-debug.a
# -rw-r--r-- 1 myuser admin 136040000 Jan 14 2014 libmysqld.a
# -rw-r--r-- 1 myuser admin 14544 Jan 14 2014 libmysqlservices.a
# drwxr-xr-x 17 myuser admin 578 Jan 14 2014 plugin
/Applications/Postgres.app/Contents/Versions/9.5/bin/pg_ctl -D "/Users/myuser/Library/Application Support/Postgres/var-9.5" stop
#waiting for server to shut down.... done
#server stopped
Applications/Postgres.app/Contents/Versions/9.5/bin/pg_ctl -D "/Users/myuser/Library/Application Support/Postgres/var-9.5" start
server starting
# LOG: database system was shut down at 2016-01-10 11:43:39 CET
# LOG: MultiXact member wraparound protections are now enabled
# LOG: database system is ready to accept connections
# LOG: autovacuum launcher started
# psql -d mydb
# psql (9.5.0)
# mydb=# create extension mysql_fdw;
# ERROR: failed to load the mysql query:
# dlopen(libmysqlclient.dylib, 1): image not found
# HINT: export LD_LIBRARY_PATH to locate the library
# STATEMENT: create extension mysql_fdw;
# ERROR: failed to load the mysql query:
# dlopen(libmysqlclient.dylib, 1): image not found
# HINT: export LD_LIBRARY_PATH to locate the library
any idea?
(osx 10.11.2)
from mysql_fdw.
See my comment above for a workaround for MacOS X
from mysql_fdw.
arg! thanks a lot @morinel ... worked now :)
from mysql_fdw.
Related Issues (20)
- Failing to install mysql_fdw HOT 8
- Getting error while installing pgvector extension to PostgreSQL in windows using the pgvector source repository HOT 3
- During push-down insert, the precision of numeric type fields is lost. HOT 1
- MySQL type YEAR is not supported HOT 4
- trigger not firing on foreign table HOT 9
- How can I Disable PREPARED-STATEMENT for SELECT statement? HOT 1
- IMPORT FOREIGN SCHEMA not importing mixed case tables HOT 6
- ERROR: failed to load the mysql query: (null) HINT: Export LD_LIBRARY_PATH to locate the library in PostgreSQL 16 on Rocky Linux 8 HOT 9
- Segmentation fault w/ dual left join is null HOT 4
- [Feature request] Support Subquery pushdown
- Truncating casts are not pushed down correctly HOT 2
- bytes after ` `(0x02 0x01 0x00) get truncated in column with type `text`
- cannot `UPDATE` or `DELETE` on fdw foreign table that inherits pgsql table HOT 1
- Unable to install the extension HOT 7
- Trouble downloading mysql_fdw
- Import Schema should convert/map MySQL tinyint(1) to PG boolean. HOT 2
- Unable to install the extensions HOT 5
- make: *** No targets specified and no makefile found. Stop. HOT 2
- create extensions failed HOT 1
- PostgreSQL 17 support HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql_fdw.