1

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
8
  • Wait, my first command, I ran it in my Mac and pointing it to my VM that is also host by my Mac. I don't think I have installed any kinds of SSL for my local VM. Are you sure ? Plus, how do I install libssl ? I hope you don't mind . Commented Jun 16, 2016 at 3:06
  • I don't think I purchased or enable any kind of SSL on my local VM. I'm not saying that you're wrong because even me I am not sure. How do check to see if my local VM has SSL enabled/installed. Commented Jun 16, 2016 at 3:10
  • Note: the issue is happening when I ssh into my local linux cent OS VM. The issue is not happening on my Mac. Commented Jun 16, 2016 at 3:13
  • I tried brew install ssl on my Mac (Not sure why I need to do that) - But I got Warning: openssl-1.0.2h_1 already installed Commented Jun 16, 2016 at 3:13
  • Sorry, I was a bit confused too. You are seeing the error only when you execute the pgloader command in centos but not on your mac? Commented Jun 16, 2016 at 3:18

1 Answer 1

1

I believe you have a corrupt pgloader installation. The download link on http://tapoueh.org/pgloader/download.html from which you appeared to have grabbed the RPM is for Centos 6.4 unfortunately a lot has changed since then.

I recommend that you try the official postgresql YUM repository. Please uninstall the previously installed RPM before you do so. However even this repository has marked pgloader as not fully compatible. So if this option fails you will have no choice but to compile from source.

Sign up to request clarification or add additional context in comments.

11 Comments

Thanks for your details answered.
No, it's not working. I have 6.7 and I use the one for 6.4. I'm not sure what to do now, I created issues on pgloader git hub site. I hope they have some hints for me.
Which one did you try? Installing from the postgresql YUM repo or the source install?
Yesterday, I tried cloning from the git hub site.
usually with yum install package .
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.