Uploaded image for project: 'Red Hat OpenShift Data Science'
  1. Red Hat OpenShift Data Science
  2. RHODS-9789

Pipeline Server cannot be started when using a custom database with dash in Database name

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Undefined Undefined
    • None
    • RHODS_1.29.0_GA
    • Pipelines
    • False
    • None
    • False
    • Release Notes
    • Testable
    • No
    • No
    • Hide
      == Pipeline servers fail to start if they contain a custom database that includes a dash in its database name or username field.
      When you create a pipeline server that uses a custom database, if the value that you set for the *dbname* field or *username* field includes a dash, the pipeline server fails to start.

      *Workaround:* Edit the pipeline server to omit the dash from the affected fields.
      Show
      == Pipeline servers fail to start if they contain a custom database that includes a dash in its database name or username field. When you create a pipeline server that uses a custom database, if the value that you set for the *dbname* field or *username* field includes a dash, the pipeline server fails to start. *Workaround:* Edit the pipeline server to omit the dash from the affected fields.
    • Known Issue
    • No
    • Pending
    • None

      Description of problem:

      When creating a Pipeline Server using a custom database, if the fields Database (dbname) or Username contain a dash (e.g. my-test-database) the Pipeline Server fails to start.

      Steps to Reproduce

      1. Create a Data Science Project
      2. Configure a Data Connection with credentials for a s3 bucket
      3. Create a pipeline server, selecting the previous data connection,  Show advanced database options and select Connect to external MySQL database
      4. Fill all fields with the database info. In Database, provide a database name with a dash (e.g. my-test-database)
      5. Click on Configure
      6. Wait until an error message is shown: Pipeline server failed

      Expected results:

      It seems that mariadb/msql lets you create identifiers using unquoted characters (they don't allow the dash and other special characters) and also using quoted characters.  RHODS should allow the same identifiers. There is more info in this document: https://mariadb.com/kb/en/identifier-names/

       

      Reproducibility (Always/Intermittent/Only Once):

      Always

      Build Details:

      RHODS 1.29

      Workaround:

      Rename the database name and/or username to use only characters allowed for unquoted identifiers: https://mariadb.com/kb/en/identifier-names/

              Unassigned Unassigned
              rhn-support-jgarciao Jorge Garcia Oncins
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: