** Changed in: openlp
Milestone: 1.9.5 => 1.9.6
--
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
_______________________________________________
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
