Layer7 API Management

Expand all | Collapse all

API Portal Cr10 upgrade error

  • 1.  API Portal Cr10 upgrade error

    Posted 02-19-2019 11:00 AM

    Hi All,


    I'm trying to upgrade current portal setup 3.5 cr2 to cr10, but seeing error as below

    API Developer Portal 3.5 Gateway Installation

    Checking version...
    Found version 9.3.x

    Pre-upgrade checks are complete.

    Do you want to proceed with the upgrade [y/n]? Y

    Starting installation...

    Stopping gateway...
    Shutting down Gateway Services:                            [  OK  ]

    Creating backup & copying new files...

    restoring your portal metrics config...
    Running Portal Metrics tests...
    19 Feb 2019 09:54:50,336 DEBUG PortalMetricsSyncUtilityMain - test selected
    19 Feb 2019 09:54:50,339 INFO  PortalMetricsSyncUtilityMain - Testing database connections.
    Exception in thread "main" java.sql.SQLException: Access denied for user 'lrs'@'localhost' (using password: YES)
            at com.mysql.jdbc.SQLError.createSQLException(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(
            at com.mysql.jdbc.MysqlIO.doHandshake(
            at com.mysql.jdbc.ConnectionImpl.coreConnect(
            at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
            at com.mysql.jdbc.ConnectionImpl.createNewIO(
            at com.mysql.jdbc.ConnectionImpl.<init>(
            at com.mysql.jdbc.JDBC4Connection.<init>(
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
            at java.lang.reflect.Constructor.newInstance(
            at com.mysql.jdbc.Util.handleNewInstance(
            at com.mysql.jdbc.ConnectionImpl.getInstance(
            at com.mysql.jdbc.NonRegisteringDriver.connect(
            at java.sql.DriverManager.getConnection(
            at java.sql.DriverManager.getConnection(
            at com.l7tech.portal.metrics.PortalMetricsSyncUtilityMain.a(Unknown Source)
            at com.l7tech.portal.metrics.PortalMetricsSyncUtilityMain.main(Unknown Source)
    ... test done.

    Starting gateway...
    Starting Gateway Services:                                 [  OK  ]

    Setup complete.

    Backup saved to /opt/SecureSpan/backup.tgz



    Could you please help me to resolve this issue.



  • 2.  Re: API Portal Cr10 upgrade error

    Posted 02-19-2019 05:57 PM

    mysql permission problem, the user 'lrs'@'localhost' doesn't exist, or wrong password, or has no enough permission.


    Did you ever change the password of mysql user(s)?

  • 3.  Re: API Portal Cr10 upgrade error

    Posted 02-20-2019 09:55 AM

    No we haven't changed password for mysql users. 



  • 4.  Re: API Portal Cr10 upgrade error

    Posted 02-20-2019 05:34 PM

    You can test the db connection with command,

    mysql -u lrs -p


    it prompt you to input password, if you can login successfully, that means the user and password are all right. Then you check the permissions with mysql command,

    mysql> show grants for 'lrs'@'localhost';
    | Grants for lrs@localhost                                                |
    | GRANT USAGE ON *.* TO 'lrs'@'localhost' IDENTIFIED BY PASSWORD <secret> |
    | GRANT ALL PRIVILEGES ON `lrs`.* TO 'lrs'@'localhost'                    |
    | GRANT ALL PRIVILEGES ON `lrsdata`.* TO 'lrs'@'localhost'                |
    3 rows in set (0.00 sec)

  • 5.  Re: API Portal Cr10 upgrade error

    Posted 03-11-2019 11:13 AM


    Did the answers on this thread answered your question? If it did please mark it as the right answer.
    When your question is not answered or you still have additional questions please let us know.

    With Kind Regards