Layer7 API Management

  • Private Community

  • 1.  api gateway configuration

    Posted Jun 30, 2017 09:53 AM

    Hi There,

    Getting following error while configuring gateway

    Error during node configuration ' Dataase conneciton error 'Access denied for user 'gateway@localhost' (using password :yes) .Pls advice.

    I am using virtual appliance and configuring the gateway with root user.



  • 2.  Re: api gateway configuration

    Broadcom Employee
    Posted Jul 05, 2017 01:24 PM

    Good afternoon,

     

    Is this the first node in the cluster or are you adding additional nodes? Also is the primary DB local to the gateway node trying to be configured. This error is normally due to either a password issue or grants for the user.

     

    Sincerely,

     

    Stephen Hughes

    Director, CA Support



  • 3.  Re: api gateway configuration

    Posted Oct 23, 2017 07:35 AM

    Hello,

    I've got this problem too. I am upgrading appliance version of CA API Developer portal from v 3.5 to v 3.5 CR5. This script should create necessary objects in SSG in order to make cooperation between API developer portal and SSG possible...

     

    [root@adp02 SecureSpan]# sh setup-ssg-35CR5.sh
    API Developer Portal 3.5 Gateway Installation
    ===================================
    Checking version...
    done
    Found version 9.2.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...
    20 Oct 2017 14:46:37,491 DEBUG PortalMetricsSyncUtilityMain - test selected
    20 Oct 2017 14:46:37,493 INFO  PortalMetricsSyncUtilityMain - Testing database connections.
    Exception in thread "main" java.sql.SQLException: Access denied for user 'gateway'@'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