openlp-core team mailing list archive

[Jonathan Corwin <714510@xxxxxxxxxxxxxxxxxx>]

As long as the MySQL is set to create MyISAM tables by default, then it
should now be possible to use MySQL to store songs, using the settings
in the description.

mysql> set global storage_engine=myisam;

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

Title:
  MySQL support on Windows fails

Status in OpenLP - Worship Presentation Software:
  In Progress

Bug description:
  Now this may be user error on my part, so apologies in advance if so.
  I attempted to turn on MySQL support for Windows (7 Enterprise), running the latest Windows package exe.

  I pasted the following into an openlp.reg text file and used it to
  update the registry:

  Windows Registry Editor Version 5.00

  [HKEY_CURRENT_USER\Software\OpenLP\OpenLP\songs]
  "db username"="user"
  "db password"="password"
  "db hostname"="host"
  "db database"="test"
  "db type"="mysql"

  Now when I start OpenLP, the following appears in the debug trace:

  2011-02-07 10:52:59,707 openlp.core.lib.pluginmanager                           DEBUG    Loaded plugin <class 'PresentationPlugin'> with helpers
  2011-02-07 10:52:59,707 openlp.core.lib.pluginmanager                           DEBUG    Loaded plugin <class 'RemotesPlugin'> with helpers
  2011-02-07 10:52:59,763 root                                                    ERROR    Traceback (most recent call last):
    File "<string>", line 287, in <module>
    File "<string>", line 281, in main
    File "<string>", line 191, in run
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.ui.mainwindow", line 583, in __init__
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.pluginmanager", line 105, in find_plugins
    File "c:\dev\OpenLP\plugins\songs\songsplugin.py", line 56, in __init__
      self.manager = Manager(u'songs', init_schema)
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", line 134, in __init__
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.lib.db", line 161, in init_schema
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", line 54, in init_db
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine", line 254, in create_engine
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.strategies", line 60, in create
    File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\windows-updates\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.dialects.mysql.mysqldb", line 101, in dbapi
    File "c:\Documents and Settings\raoul\My Documents\My Projects\pyinstaller\iu.py", line 436, in importHook
    File "c:\Documents and Settings\raoul\My Documents\My Projects\pyinstaller\iu.py", line 521, in doimport
    File "c:\dev\OpenLP\eggs\mysql_python-1.2.3-py2.6-win32.egg\MySQLdb\__init__.py", line 19, in <module>
      import _mysql
    File "c:\Documents and Settings\raoul\My Documents\My Projects\pyinstaller\iu.py", line 436, in importHook
    File "c:\Documents and Settings\raoul\My Documents\My Projects\pyinstaller\iu.py", line 521, in doimport
    File "c:\dev\OpenLP\eggs\mysql_python-1.2.3-py2.6-win32.egg\_mysql.py", line 7, in <module>
      __bootstrap__()
    File "c:\dev\OpenLP\eggs\mysql_python-1.2.3-py2.6-win32.egg\_mysql.py", line 4, in __bootstrap__
      __file__ = pkg_resources.resource_filename(__name__,'_mysql.pyd')
    File "c:\dev\OpenLP\eggs\setuptools-0.6c11-py2.6.egg\pkg_resources.py", line 882, in resource_filename
      self, resource_name
    File "c:\dev\OpenLP\eggs\setuptools-0.6c11-py2.6.egg\pkg_resources.py", line 1352, in get_resource_filename
      return self._extract_resource(manager, zip_path)
    File "c:\dev\OpenLP\eggs\setuptools-0.6c11-py2.6.egg\pkg_resources.py", line 1363, in _extract_resource
      zip_stat = self.zipinfo[zip_path]
  KeyError: '_mysql\\_mysql.pyd'
  None