Uploaded image for project: 'The Virtual Brain'
  1. The Virtual Brain
  2. TVB-1134

The new build produced with MacMini x64 doesn't work with postgreSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1.1
    • Component/s: None
    • Labels:
      None

      Description

      On the build machine I tried to compile psycopg2 from sources, install with pip and easy_install, but I could not make it work until I added:
      cp /Library/PostgreSQL/9.3/lib/libssl.1.0.0.dylib /usr/lib/
      cp /Library/PostgreSQL/9.3/lib/libcrypto.1.0.0.dylib /usr/lib/

      But when gathering package, py2app does not include anything from /usr/lib (being considered as universal).

      Starting TVB Web Interface
      Could not find compatible psycopg2/postgresql bindings. Postgresql support not available.Found the first free port: 8080.
      Traceback (most recent call last):
      File "runpy.pyc", line 162, in _run_module_as_main
      File "runpy.pyc", line 72, in _run_code
      File "/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/tvb/interfaces/web/run.py", line 60, in <module>
      from tvb.core.adapters.abcdisplayer import ABCDisplayer
      File "/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/tvb/core/adapters/abcdisplayer.py", line 40, in <module>
      from tvb.core.adapters.abcadapter import ABCSynchronous
      File "/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/tvb/core/adapters/abcadapter.py", line 48, in <module>
      from tvb.basic.traits.types_mapped import MappedType
      File "/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/tvb/basic/traits/types_mapped.py", line 43, in <module>
      import tvb.core.traits.types_mapped as mapped
      File "/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/tvb/core/traits/types_mapped.py", line 52, in <module>
      from tvb.core.entities.storage import dao
      File "/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/tvb/core/entities/storage/_init_.py", line 43, in <module>
      from tvb.core.entities.storage.session_maker import transactional, SA_SESSIONMAKER
      File "/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/tvb/core/entities/storage/session_maker.py", line 56, in <module>
      DB_ENGINE = create_engine(cfg.DB_URL, pool_recycle=5, max_overflow=1, pool_size=cfg.MAX_DB_CONNECTIONS)
      File "build/bdist.macosx-10.9-intel/egg/sqlalchemy/engine/_init_.py", line 338, in create_engine
      File "build/bdist.macosx-10.9-intel/egg/sqlalchemy/engine/strategies.py", line 64, in create
      File "build/bdist.macosx-10.9-intel/egg/sqlalchemy/dialects/postgresql/psycopg2.py", line 312, in dbapi
      File "psycopg2/_init_.pyc", line 50, in <module>
      File "psycopg2/_psycopg.pyc", line 14, in <module>
      File "psycopg2/_psycopg.pyc", line 10, in __load
      ImportError: dlopen(/Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/lib-dynload/psycopg2/_psycopg.so, 2): Library not loaded: libssl.1.0.0.dylib
      Referenced from: /Users/lia.domide/Downloads/TVB_Distribution 2/tvb.app/Contents/Resources/lib/python2.7/lib-dynload/psycopg2/_psycopg.so
      Reason: image not found
      Some old PIDs were still registered. They have been stopped.logout

      [Process completed]

      If I tried to manually copy the 2 dylib in tvb.app/Framework I got other errors (pysopg related as well):
      File "/Users/lia.domide/Downloads/TVB_Distribution/tvb.app/Contents/Resources/lib/python2.7/tvb/core/entities/storage/session_maker.py", line 56, in <module>
      DB_ENGINE = create_engine(cfg.DB_URL, pool_recycle=5, max_overflow=1, pool_size=cfg.MAX_DB_CONNECTIONS)
      File "build/bdist.macosx-10.9-intel/egg/sqlalchemy/engine/_init_.py", line 338, in create_engine
      File "build/bdist.macosx-10.9-intel/egg/sqlalchemy/engine/strategies.py", line 64, in create
      File "build/bdist.macosx-10.9-intel/egg/sqlalchemy/dialects/postgresql/psycopg2.py", line 312, in dbapi
      File "psycopg2/_init_.pyc", line 67, in <module>
      File "psycopg2/extensions.pyc", line 61, in <module>
      ImportError: cannot import name Diagnostics
      Some old PIDs were still registered. They have

        Gliffy Diagrams

          Attachments

            Activity

              People

              Assignee:
              lia.domide Lia Domide
              Reporter:
              lia.domide Lia Domide
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 day
                  1d
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours Time Not Required
                  4h