Layer7 API Management

  • 1.  Unable to create database

    Posted Mar 16, 2019 06:08 PM

    Hi All,

     

    We are in establishing API Gateway software in azure platform. During the gateway set up /opt/SecureSpan/Gateway/runtime/bin/setup.sh, facing the below issue.

     

    Error creating database when saving configuration 'Unable to create database'

     

    Kindly help me in resolving the issue.

     

    Regards,

    Radha



  • 2.  Re: Unable to create database

    Broadcom Employee
    Posted Mar 17, 2019 06:46 PM

    Dear Radha,

    We need more details.

    How you configure the database? for the database host you provided, can you assess it from the gateway command console? are the provided database username/password correct?

     

    Regards,

    Mark



  • 3.  Re: Unable to create database
    Best Answer

    Posted Mar 17, 2019 06:58 PM

    Hi Radha,

     

    Adding to what Mark said, do check that the MySQL root user is configured with the 'with grant option' so it can 'grant' the Gateway user the permission to do the needed.

     

    Kind Regards,

     

    Amit.



  • 4.  Re: Unable to create database

    Posted Mar 20, 2019 07:52 AM

    Hi,

     

    Now I'm able to create ssg database post privileges are set for root user.

     

    Thanks for quick support.

     

    Regards,

    Radha