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
_______________________________________________
Mailing list: https://launchpad.net/~openlp-core
Post to : openlp-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openlp-core
More help : https://help.launchpad.net/ListHelp
