← Back to team overview

openlp-core team mailing list archive

  1. openlp-core team
  2. Mailing list archive
  3. Message #16753

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

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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.

** Affects: openlp
     Importance: Undecided
         Status: New

-- 
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:
  New

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next