Category Archives: Software Programs

List of programs that I have created for my intents and purposes. Happy to share with others.

dlopen(Library not loaded: libssl.dylib) – fail to import psycopg2 in virtualenv

This is my scenario, I set up virtualenv on my MacBook (love that virtualenv btw).  I installed Jupyter in one of my Virtual Environments (pip install jupyter).  While running Jupyter, I attempted to import psycopg2 (I had previously installed this module in another virtualenv by the way). Then I received an error like the one below:

 “dlopen(Library not loaded: libssl.dylib)”

Fixing this is simple.  Copy the following files in to your /usr/local/lib folder

  • libssl.1.0.0.dylib
  • libcrypto.1.0.0.dylib

I found these files in my Postgres installation (/Library/PostgreSQL/9.5/lib), navigated there and then ran the following command

sudo cp libssl.1.0.0.dylib libcrypto.1.0.0.dylib /usr/local/lib/

After that, I am able to import psycopg2 on Jupyter running in my virtualenv with no problem!

Leave a comment

Filed under Python, Software Programs

Concatenating (Merging) Text Files in Windows

Update:  File Merge has been updated with a feature that will enable you to get a line count for each file.   I’ll keep the original version linked and add a link to the updated one below that.  Also, check out the screen shots.

Recently I’ve been working with a lot of text files that are alike in data structure.  Sometimes I have to place these files in a database, other times I have to extract information from them.  Whatever the case it’s always easier to deal with this data if it is in one large file.  I’ve been using cygwin to accomplish this task (I love this tool), but various reasons, I decided to make a small executable with a user interface that will handle this task.

I hope that you find this little utility useful.  I’ve zipped up the source code and executable.  The executable needs .NET framework 3.5 to run, but if you don’t have that framework on your computer, you can recompile the code under your version of Visual Studio and Framework.  If you have a specific question about this post a comment.  As soon as I get some more free time, I’ll create executables under Framework 2.0 since most Windows users are likely to have this.

Enjoy some screenshots of this program.  If you have any questions or need help please ask by commenting.  One more thing, this program is free and you can do what you want with it, but try not to ruin it for everyone.  – Thanks. =)

To download click here    Download updated File Merge: click here

This slideshow requires JavaScript.

Images of the updated File Merge Program (under Windows XP)

Main File Merge window

Select Files to count records for or Merge

Line count for each file selected displayed in Message Box


Filed under Computer - Technical, Software Programs