Crashes on non-alphanumeric characters in MySQL password

Bug #886989 reported by Samuel Findlay
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenLP
Fix Released
Low
Raoul Snyman

Bug Description

OpenLP 1.9.7 on Win7 Pro x64

-- as reported by jstruebel on forums:
It appears that OpenLP can't handle non-alphanumeric characters in the mysql password. I had generated a random password that included some symbols originally and even still if I try to use that password OpenLP fails to connect to the database. The second password that I tried today and which worked, was a random password using only alphanumeric characters.
The debug logs for both an unsuccessful attempt and the successful connection are at the following links.
* crashed with traceback: http://pastebin.com/nWFLSNT2
* successful: http://pastebin.com/zCCgs2aW

I have run into this issue with other software where passwords must not contain symbols. Since it works with a strictly alphanumeric password it isn't a showstopper, but the documentation should indicate that the password cannot contain symbols.

http://openlp.org/en/forums/general-support/troubleshooting/trouble-connecting-mysql-db#comment-3769

Related branches

description: updated
description: updated
Changed in openlp:
assignee: nobody → Raoul Snyman (raoul-snyman)
importance: Undecided → Low
milestone: none → 1.9.8
Changed in openlp:
status: New → Fix Committed
Changed in openlp:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.