Bug #7902

Puppet Enterprise fails out during MySQL Dashboard config when using non-alphanumeric in db or username variables

Added by James Fryman about 2 years ago. Updated over 1 year ago.

Status:ClosedStart date:06/13/2011
Priority:NormalDue date:
Assignee:Matthaus Owens% Done:

0%

Category:installer
Target version:-
Keywords: Affected URL:
Branch: Affected PE version:1.0.0

Description

Tested Operating Systems: CentOS: 5.6 (x86_64, i386)

MySQL Version: 5.0.77

MySQL cannot create database with dashes without using backquotes. Errors out:

disallowed characters are ‘\’, ‘/’, ‘.’. All other characters can be created using back-tick syntax.

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

failure example mysql> create database puppet-enterprise; mysql> create database ‘puppet-enterprise’; mysql> create database “puppet-enterprise”; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘-enterprise’ at line 1

success example mysql> create database puppet-enterprise; Query OK, 1 row affected (0.00 sec)

mysql_error_answers.rtf (1.13 KB) James Fryman, 06/13/2011 11:17 am

mysql_error_pe_install_error.rtf (11.2 KB) James Fryman, 06/13/2011 11:17 am

History

#1 Updated by Michael Stahnke almost 2 years ago

  • Status changed from Unreviewed to Investigating
  • Assignee set to Matthaus Owens

#2 Updated by Matthaus Owens almost 2 years ago

  • Status changed from Investigating to In Topic Branch Pending Review

Added backticks around all database names.

Fixed in commit: 725482c02a0c683c98877886650c66ff17cffb12

#3 Updated by Matthaus Owens almost 2 years ago

  • Status changed from In Topic Branch Pending Review to Merged - Pending Release

#4 Updated by Michael Stahnke over 1 year ago

  • Status changed from Merged - Pending Release to Closed

Also available in: Atom PDF