F5 force connection reset on pool member
I have two MySQL server behind F5 and i am using Priority group for active-passive so request will go to primary everytime until it's down. Question: primary failed and all my connection going to standby box - Good now primary is back - but still my client connected to standby DB ( because of persistent connection ) How do i force my pool member to tell drop all connection and go to new primary DB? problem is if some client keep writing data to standby it will create some kind of issue. force offline doesn't drop active connection
Big IQ High Availability Configuration Fails
I have two Big IQ Virtual Machines built from the Big IQ 7.1.0.1-133 software. There are no firewalls between the two, but they do reside on two separate VM hosts. When I configure the High Availability with no auto failover (no DCDs deployed yet), the process hangs at "Configuring Database Replication" for a long time but it will eventually say the process is complete. At that point, the VM that should be the primary says it is still in Standalone mode and the VM that is secondary has the configuration replicated but the web GUI doesn't come up. The reason I know the configuration is replicated, is because when I reboot the hosts and check the High Availability settings, the primary says it is in a failed High Availability state and the secondary is in a successful state. there is also an error on the primary stating "Secondary is not actively streaming. Postgres may be down.". I checked the logs for Postgres and Tokumonx and I'm seeing fatal errors. Specifically, that the role "root" doesn't exist. My question: where else should I be looking to troubleshoot this issue? Has anyone run into this issue and just know the answer? Thank you
DataBase not found in DataSource error in Grafana Dashboard for F5 DDoS
Hello folks, I followed the procedure to install the F5 app in Grafana which is located in https://github.com/f5devcentral/f5-bados-app. However, I am having an error which says DataBase not found in DataSource every time I try to create a data source in the Grafana admin website. I am putting the word "default" in the ADMdb details Database field. I don't know where to manually create or copy the database. Thanks JMTNS LISTENER ERROR ON ORACLE RAC VIRTUAL SERVER IRULE
What steps should be listed in the Oracle RAC irule, when load balancing oracle db servers. I get the following error on my VIP (Green) (10.1.232.89:1521). Connection test failed. Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: (description= (address=(protocol=tcp)(host=10.1.232.89)(port=1521))(connect_data=(SERVICE_NAME=tpp_n4))) oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:460) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411) oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:490) oracle.jdbc.driver.T4CConnection.(T4CConnection.java:202) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474) com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:505) com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:369) sun.reflect.GeneratedMethodAccessor797.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870) org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809) org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478) org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306) org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336) org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52) ... However,all the three DB servers connection test from Oracle Server are fine, 10.1.232.191,10.1.232.192,10.1.232.193. The service name is tpp_n4, and the irule is in the comments
Query / Monitor last failover time
Hello, I have a pair of LTMs that were toggling active-standby-active. We've resolved the issue, but I'd like to detect this in the future. Is there any way to programmaitcally (i.e. something that I can script) check the time of the last failover event, or how many failover events have happened (i.e. cache a counter, and see if it increases)? So far the only thing I've been able to come up with is looking in /var/log/ltm, which is a pretty expensive operation given that we have a LOT of iRule logging going there. Thanks, Jason
