openlp-core team mailing list archive

[Raoul Snyman <raoul.snyman@xxxxxxxxxxxxxxxxxxxxxxxx>]

** Changed in: openlp
       Status: New => Fix Committed

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/886989

Title:
  Crashes on non-alphanumeric characters in MySQL password

Status in OpenLP - Worship Presentation Software:
  Fix Committed

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/886989/+subscriptions