Can't find libsybdb.dylib on mac

[Paxa]

I downloaded package pgloader-3.2.0.pkg installed and try to run.

% pgloader --version

debugger invoked on a SIMPLE-ERROR in thread
#<THREAD "main thread" RUNNING {1006E666E3}>:
  Error opening shared object "libsybdb.dylib":
  dlopen(libsybdb.dylib, 10): image not found.

Type HELP for debugger help, or (SB-EXT:EXIT) to exit from SBCL.

restarts (invokable by number or by possibly-abbreviated name):
  0: [CONTINUE       ] Skip this shared object and continue.
  1: [RETRY          ] Retry loading this shared object.
  2: [CHANGE-PATHNAME] Specify a different pathname to load the shared object from.

(SB-SYS:DLOPEN-OR-LOSE #S(SB-ALIEN::SHARED-OBJECT :PATHNAME #P"libsybdb.dylib" :NAMESTRING "libsybdb.dylib" :HANDLE NIL :DONT-SAVE NIL))
0] 

Then if I try to migrate data from mysql to postgresq, I get this:

2015-01-28T06:48:07.627000+01:00 ERROR Database error 42601: syntax error at or near "3"
QUERY: CREATE TABLE merchants 
(
  id                     text not null,
  merchant_name          text,
  email                  text,
  phone                  text,
  url                    text,
  3d_secure_mpi_type     text,
  ....
);

Seems like postgres don't like column name starting with number

But it imports data correctly

[robins]

Well you can be sure that PostgreSQL accepts only column-names, starting with either an alphabet or an underscore (_) ... (More detail here) ... although I'd let @dimitri respond to what PgLoader does in such scenarios.

[dimitri]

The first bug has been fixed meanwhile, so please consider building from sources to see the bug disappear. If you're already using brew, building pgloader is quite easy and described in the docs, see INSTALL.md file.

Then the MySQL migration is another error entirely, you can work around it already by adding the option WITH quote identifiers so that case will be respected in the migration and column names will be protected with double-quotes. Working on a fix now so that it just work for that case.

[Paxa]

Thanks

[dimitri]

If you have the opportunity to try with the fix and with the option downcase identifiers (which is the default) so that you could then confirm the fix, it would be awesome. Thanks.

[Paxa]

When I compile from source:

  Unable to load foreign library (SYBDB).
  Error opening shared object "libsybdb.dylib":
  dlopen(libsybdb.dylib, 10): image not found.

press continue then:

build/bin/buildapp.sbcl      --logfile /tmp/build.log                \
                         --require sb-posix --require sb-bsd-sockets --require sb-rotate-byte                        \
                         --sbcl sbcl                            \
                         --asdf-path .                           \
                         --asdf-tree build/quicklisp/local-projects     \
                         --manifest-file build/manifest.ql             \
                         --asdf-tree build/quicklisp/dists              \
                         --asdf-path .                           \
                         --load-system pgloader               \
                         --load src/hooks.lisp                   \
                         --entry pgloader:main                   \
                         --dynamic-space-size 4096         \
                         --compress-core                    \
                         --output build/bin/pgloader.tmp
;; loading system "pgloader"
Fatal MISSING-DEPENDENCY:
  Component #:UUID not found, required by #<SYSTEM "pgloader">
make: *** [build/bin/pgloader] Error 1

[dimitri]

Ah, yes sorry, to compile from source yes you need to install freetds, brew install freetds.

[Paxa]

pgloader working without libsybdb.dylib well (I remove freetds after compilation)
table with column 3d_secure_mpi_type ok
Thnks

[dimitri]

Perfect, thanks for your feedback!

[Themanwithoutaplan]

I'm getting this error even with FreeTDS installed.

I'm using MacOS with MacPorts so the library is at /opt/local/lib/libsybdb.dylib

[dimitri]

Can you try to set your lib in the library path for MacOS that way:

DYLD_FORCE_FLAT_NAMESPACE=1 DYLD_INSERT_LIBRARIES=/path/to/your.dyld command

Note that I'm using a mac with brew myself and didn't need anything like that. Of course it might just be that brew is doing it for me (by just installing files in /usr/local/lib):

/usr/local/lib/libsybdb.5.dylib
/usr/local/lib/libsybdb.a
/usr/local/lib/libsybdb.dylib

[Themanwithoutaplan]

There are good reasons for using MacPorts over Brew. But each to their own. I normally don't have a problem compiling anything as a result of installing MacPorts.

What is the name of the dyld command I should be looking for? I only seem to have /usr/lib/system/libdyld.dylib but setting this does not help.

[dimitri]

Try:

DYLD_FORCE_FLAT_NAMESPACE=1 DYLD_INSERT_LIBRARIES=/opt/local/lib/libsybdb.dylib make

[Themanwithoutaplan]

Sorry, this doesn't solve the problem. What other components have you installed with Brew that might be relevant?