I'm very confused, and don't understand how this has happened. I used pgloader in my Mac OS X to migrate data from MySQL to PostgreSQL database.
Mac OSX
I tried
pgloader mysql://root@localhost/local postgresql://postgres@localhost/portal
I got
2016-06-15T13:11:23.017000-07:00 LOG Main logs in '/private/tmp/pgloader/pgloader.log'
2016-06-15T13:11:23.060000-07:00 LOG Data errors in '/private/tmp/pgloader/'
2016-06-15T13:11:23.262000-07:00 WARNING PostgreSQL warning: table "mirror_settings" does not exist, skipping
table name read imported errors time
---------------------- --------- --------- --------- --------------
fetch meta data 25 25 0 0.092s
create, drop 0 26 0 0.217s
---------------------- --------- --------- --------- --------------
caches 1 1 0 0.156s
captive_portals 5 5 0 0.074s
captures 2 2 0 0.029s
cloud_securities 7 7 0 0.024s
devices 88 88 0 0.056s
externals 1 1 0 0.018s
migrations 52 52 0 0.028s
mirror_settings 1 1 0 0.036s
notifications 7 7 0 0.038s
operators 1 1 0 0.014s
promotions 5 5 0 0.015s
users 224 224 0 0.020s
visitors 14 14 0 0.013s
Index Build Completion 0 0 0 0.020s
---------------------- --------- --------- --------- --------------
Create Indexes 12 12 0 0.124s
Reset Sequences 0 11 0 0.012s
Primary Keys 11 11 0 0.009s
Foreign Keys 0 0 0 0.000s
Comments 0 0 0 0.000s
---------------------- --------- --------- --------- --------------
Total import time 408 408 0 0.871s
All tables, and data in within them are imported perfectly.
Cent OS 6.7 (64 bits)
Then, I've SSH into my local VM as [email protected] and run
pgloader mysql://[email protected]/local postgresql://[email protected]/portal
I got
debugger invoked on a SIMPLE-ERROR in thread
#<THREAD "main thread" RUNNING {10070AB033}>:
Error opening shared object "libssl.so.1.0.0":
libssl.so.1.0.0: cannot open shared object file: No such file or directory.
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"libssl.so.1.0.0" :NAMESTRING "libssl.so.1.0.0" :HANDLE NIL :DONT-SAVE NIL))
0] 0
An unhandled error condition has been signalled:
The value NIL
is not of type
(OR (VECTOR CHARACTER) (VECTOR NIL) BASE-STRING PATHNAME STREAM).
;
; compilation unit aborted
; caught 1 fatal ERROR condition
brew install sslon my Mac (Not sure why I need to do that) - But I gotWarning: openssl-1.0.2h_1 already installed