Layer7 API Management

Expand all | Collapse all

Unable to connect otk databse

Jump to Best Answer
  • 1.  Unable to connect otk databse

    Posted 03-28-2018 10:52 PM

    Hi Team,

    I have a Gateway installed on my local machine , and i am using Mysql Databse,whihc is installed on my machine,

    When i try connecting the database i see the following issue.

     

     

    OTK 4.1

    Policy manager 9.2



  • 2.  Re: Unable to connect otk databse

    Posted 03-29-2018 01:00 AM

    can you upload the screenshot showing the jdbc connection settings please



  • 3.  Re: Unable to connect otk databse

    Posted 03-29-2018 10:34 AM

    Hi

     

    Try the following URL and driver:

     

    URL = jdbc:mysql://localhost:3306/otk_db

     

    Driver = com.l7tech.jdbc.mysql.MySQLDriver

     

    Regards



  • 4.  Re: Unable to connect otk databse

    Posted 04-03-2018 12:52 AM

    That means either the user 'root'@'localhost' had been removed, or the password of 'root'@'localhost' is not correct



  • 5.  Re: Unable to connect otk databse
    Best Answer

    Posted 04-03-2018 09:09 AM

    First please confirm you created the otk_db on the local mysql? If you did then I recommend creating a seperate user in mysql to use for the connection and not use mysql root user.

     

    You can use the following to create the user with the necessary privileges and set the password for the user

    1. GRANT SELECT,UPDATE,DELETE,INSERT ON otk_db.* TO '<db_user>'@'%' identified by '<db_user_password>';
    2. mysql> flush privileges;


  • 6.  Re: Unable to connect otk databse

    Posted 04-03-2018 09:24 AM

    OTK 4.1

    POLicy manager 9.2

     

    1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. 0.015 sec



  • 7.  Re: Unable to connect otk databse

    Posted 04-03-2018 10:09 AM

    Hello,

     

    this is from the current OTK documentation, I am sure in future versions it will be updated accordingly.

     

    MySQL Database - CA API Management OAuth Toolkit - 4.2 - CA Technologies Documentation 



  • 8.  Re: Unable to connect otk databse

    Posted 04-04-2018 08:12 PM

    Thanks Barry