[Fiware-tech-help] [FI-WARE-JIRA] (SEC-33) CLONE - [Chp - Security][Identity Management] Default database names

[Álvaro Alonso (JIRA)]

     [ http://jira.fi-ware.org/browse/SEC-33?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Álvaro Alonso updated SEC-33:
-----------------------------

        Status: Closed  (was: Fixed)
    Resolution: Done

> CLONE - [Fiware-tech-help] [Chp - Security][Identity Management] Default database names
> ---------------------------------------------------------------------------------------
>
>                 Key: SEC-33
>                 URL: http://jira.fi-ware.org/browse/SEC-33
>             Project: Chp - Security
>          Issue Type: Bug
>          Components: Identity Management
>            Reporter: FIWARE-TECH-HELP
>            Assignee: Álvaro Alonso
>
> When using the default database names provided in the
> database.example.yml configuration file, the create database mysql
> command must enclose the database name within backtick characters (`)
> or mysql will raise an error like this:
>   mysql> create database fi-ware-idm_development;
>   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 '-ware-idm_development' at line 1
>   mysql> create database 'fi-ware-idm_development' ;
>   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 ''fi-ware-idm_development'' at line 1
> Enclosing the name in backtick characters avoids this problem:
>   mysql> create database `fi-ware-idm_development` ;
>   Query OK, 1 row affected (0.00 sec)
> Please, add backticks to the create database example available on the document.
> _______________________________________________
> Fiware-tech-help mailing list
> Fiware-tech-help at lists.fi-ware.org
> https://lists.fi-ware.org/listinfo/fiware-tech-help



--
This message was sent by Atlassian JIRA
(v6.1.7#6163)