Issue #7902 has been updated by Matthaus Litteken.

Status changed from In Topic Branch Pending Merge to Merged - Pending Release


----------------------------------------
Bug #7902: Puppet Enterprise fails out during MySQL Dashboard config when using 
non-alphanumeric in db or username variables
https://projects.puppetlabs.com/issues/7902

Author: James Fryman
Status: Merged - Pending Release
Priority: Normal
Assignee: Matthaus Litteken
Category: installer
Target version: 
Keywords: 
Branch: 
Affected PE version: 1.0.0


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)





-- 
You have received this notification because you have either subscribed to it, 
or are involved in it.
To change your notification preferences, please click here: 
http://projects.puppetlabs.com/my/account

-- 
You received this message because you are subscribed to the Google Groups 
"Puppet Bugs" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/puppet-bugs?hl=en.

Reply via email to