Layer7 API Management

 View Only
  • 1.  API Developer Portal 5.1.2 Upgrade

    Posted Jun 02, 2023 05:42 AM

    Hi Team,

    I am trying to upgrade Developer Portal from 5.1 to 5.1.2 but after extracting the images and while running portal.sh, the DB Schema Update keeps failing.

    My Environment Details:

    Centos 7.9

    MySQL 8.0.31

    Docker 24.0.2

    Can anyone plz help me on this issue?



  • 2.  RE: API Developer Portal 5.1.2 Upgrade

    Posted Jun 05, 2023 05:59 AM

    Hello Nandadeeban Muruganandam

    Kindly check MySQL Database tables and Schema whether you have it Properly in Place.

    Also check MySQL Logs on MySQL Server, it may be not allowing your MySQL User to connect to DB.

    MySQL Configuration available in Portal.conf File on Portal Server.


    MySQL Log file Path you can find in my.cnf

    Thanks,

    Hrushikesh Jadhav



    ------------------------------
    Great Day,
    ---------------------------------------
    Hrushikesh Jadhav
    Senior API Consultant
    IT | Allied Globetech LLP
    ------------------------------



  • 3.  RE: API Developer Portal 5.1.2 Upgrade

    Posted Jun 05, 2023 07:13 AM

    Hi Hrushikesh Jadhav.

    Thanks for the reply.

    There is no issue with the connection to the Database Server, Mysql User is able to connect to the Portal db.

    since schema update failed for 5.1.2, i have reverted back to 5.1 itself, for 5.1 there was no issue, the schema got updated and the portal is running fine.

    This DB update schema issue is occuring only while running 5.1.2 




  • 4.  RE: API Developer Portal 5.1.2 Upgrade

    Posted Jun 05, 2023 10:12 AM

    I think it is worth mentioning that MySQL versions 8.0.31 and lower have some pretty high lever security vulnerabilities. 
    Since you are doing upgrades I would consider MySQL 8.0.32 or higher.  
    Just a thought. 




  • 5.  RE: API Developer Portal 5.1.2 Upgrade

    Posted Jun 06, 2023 01:31 AM

    Hi Mark Stewart,

    Thanks for the suggestion.