openlp-core team mailing list archive

[Jonathan Corwin <j@xxxxxxxxxxxx>]

Note, the mysql server is configured to create InnoDB tables by default.

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

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