openlp-core team mailing list archive

[Jonathan Corwin <j@xxxxxxxxxxxx>]

Public bug reported:

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

** Affects: openlp
     Importance: Undecided
         Status: New

** Description changed:

- Now this may be user error on my part, so apologies in advance if so. 
+ 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"="root"
- "db password"="myrootpassword"
- "db hostname"="beaker"
+ "db username"="user"
+ "db password"="password"
+ "db hostname"="password"
  "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]
+   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

** Description changed:

  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"="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

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