← Back to team overview

openlp-core team mailing list archive

[Bug 1030686] Re: using mysql in 1.9.11 mac crashes app on startup

 

** Changed in: openlp
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/1030686

Title:
  using mysql in 1.9.11 mac crashes app on startup

Status in OpenLP - Worship Presentation Software:
  Fix Released

Bug description:
  1. Mac OS 10.6 
  2. 1.9.11

  Steps to reproduce

  Setup a working mysql connection

  defaults write org.openlp.OpenLP "songs.db type" "mysql"
  defaults write org.openlp.OpenLP "songs.db username" "root"
  defaults write org.openlp.OpenLP "songs.db password" "****"
  defaults write org.openlp.OpenLP "songs.db hostname" "127.0.0.1"
  defaults write org.openlp.OpenLP "songs.db database" "openlp"

  verified above are working ( using deployed version )

  ( to remove settings use the following )
  defaults delete org.openlp.OpenLP "songs.db type"
  defaults delete org.openlp.OpenLP "songs.db username"
  defaults delete org.openlp.OpenLP "songs.db password"
  defaults delete org.openlp.OpenLP "songs.db hostname"
  defaults delete org.openlp.OpenLP "songs.db database"

  Application starts, Bounces a few times and then shuts down.

  Tail end of debug log has

  2012-07-29 19:01:25,113 openlp.core.lib.plugin                                  DEBUG    Plugin songs initialised
  2012-07-29 19:01:25,149 root                                                    ERROR    Traceback (most recent call last):
    File "<string>", line 44, in <module>
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core", line 325, in main
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core", line 134, in run
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core.ui.mainwindow", line 678, in __init__
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core.lib.pluginmanager", line 112, in find_plugins
    File "/Applications/OpenLP.app/Contents/MacOS/plugins/songs/songsplugin.py", line 64, in __init__
      self.manager = Manager(u'songs', init_schema, upgrade_mod=upgrade)
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core.lib.db", line 211, in __init__
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core.lib.db", line 79, in upgrade_db
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core.lib.db", line 62, in init_db
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.engine", line 336, in create_engine
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.engine.strategies", line 64, in create
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.connectors.mysqldb", line 52, in dbapi
    File "/Users/martin/Documents/pyinstaller/gitrepo/PyInstaller/loader/iu.py", line 386, in importHook
    File "/Users/martin/Documents/pyinstaller/gitrepo/PyInstaller/loader/iu.py", line 480, in doimport
    File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/MySQLdb", line 19, in <module>
    File "/Users/martin/Documents/pyinstaller/gitrepo/PyInstaller/loader/iu.py", line 386, in importHook
    File "/Users/martin/Documents/pyinstaller/gitrepo/PyInstaller/loader/iu.py", line 459, in doimport
    File "/Users/martin/Documents/pyinstaller/gitrepo/PyInstaller/loader/iu.py", line 248, in getmod
    File "/Users/martin/Documents/pyinstaller/gitrepo/PyInstaller/loader/iu.py", line 105, in getmod
  ImportError: dlopen(/Applications/OpenLP.app/Contents/MacOS/_mysql.so, 2): Symbol not found: _strnlen
    Referenced from: /Applications/OpenLP.app/Contents/MacOS/libmysqlclient_r.16.dylib
    Expected in: /usr/lib/libSystem.B.dylib
   in /Applications/OpenLP.app/Contents/MacOS/libmysqlclient_r.16.dylib
  None

  
  Note: I ran the version in my source folder ( trunk from today so it should be the same version ) and it had no issues, which helped me figure out how i should set the preferences.

  Think this is an issue with how it's deployed since the version done
  from source works correctly.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1030686/+subscriptions


References