PM97083: FAILED TO CREATE MYSQL DATABASE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • While installing Worklight Server 6.0, the creation of the MySQL
    database for Application Center fails.
    The "Database creation progress" panel shows the resulting
    output:
    Granting user test for database APPCNTR ... failed:
    Cannot connect to database 'APPCNTR' as user '...' even after
    granting access:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
    Unknown database 'APPCNTR'
    

Local fix

  • After the error occurs: Press "Back" twice. Enter the superuser
    credentials instead of the desired credentials. Press "Next".
    Enter the superuser password again. Press "Next"; the database
    is now created. Press "Back" twice. Enter the desired
    credentials. Press "Next" three times and continue the
    installation.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Worklight Server 6.0.0.0 or 6.0.0.1 in combination  *
    * with MySQL.                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Although the database doesn't exist, the "Create database"   *
    * panel shows the text "Preparing to grant user ... for the    *
    * database APPCNTR." - as if the database already existed.     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * -                                                            *
    ****************************************************************
    The logic which decides whether to create the database or the
    user account is not correct when both the database and the user
    account don't exist.
    

Problem conclusion

  • The code now creates both the database and the user account when
    both are nonexistent.
    
    The fix for this APAR is currently targeted for fixpack 6.0.0.2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM97083

  • Reported component name

    WORKLIGHT CONSU

  • Reported component ID

    5725I4301

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-16

  • Closed date

    2013-09-16

  • Last modified date

    2013-09-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WORKLIGHT CONSU

  • Fixed component ID

    5725I4301

Applicable component levels

  • R600 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Worklight

Software version:

6.0

Reference #:

PM97083

Modified date:

2013-09-16

Translate my page

Machine Translation

Content navigation