← Back to team overview

openlp-core team mailing list archive

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

 

This is confirmed to be fixed in recent nightly builds.  Mysql has to be
recompiled on the osx 10.7 build machine with compatibility for osx
10.6.

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

** Changed in: openlp
     Assignee: (unassigned) => matysek (mzibricky)

** Changed in: openlp
    Milestone: None => 1.9.12

-- 
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 Committed

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