openlp-core team mailing list archive

[Samuel Findlay <886989@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: openlp
     Importance: Undecided
         Status: New

** Description changed:

  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

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

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