Layer7 API Management

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...
done
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(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951)
        at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1717)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2395)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2428)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2213)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:247)
        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.

Thanks!

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)?

No we haven't changed password for mysql users. 

Thanks!

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)

Hi

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
Dirk