Integration

Get Involved. Join the Conversation.

Topic

    Christopher Maggiulli
    MySQL adapter cannot connect (needs JDBC jar?) Using...Answered
    Topic posted March 19, 2018 by Christopher MaggiulliSilver Crown: 22,500+ Points, tagged Agent, Connection, Database 
    88 Views, 2 Comments
    Title:
    MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agent
    Summary:
    MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agent
    Content:

    I have an OIC instance with an On-Prem adapter installed within my firewall.  The On-Prem adapter works when I use the various REST and SOAP connections.  However when I set up a connection using the MySQL adapter it fails to connect, saying that I should check the com.jdbc.myswl.driver.  Following that advice I SHH'd into the box and found where location of the driver's for the weblogic server. I see the MySQL connector/j driver is already present (additionally, it already says pre installed on the GUI (underneath the adapter)). I verified that I can access the MySQL box from the box the on prem agent is installed on. The log files do not say anything interesting beyond "cannot connect" and to check if the jar driver is installed.  Does anyone have any thoughts?

    Best Comment

    Nagireddy Tadi

    The MySQL Database driver is not shipped with the OIC Agent. You must download the correct driver and configure in your onpremise agent. Please double check whether your have done following configuration on your onpremise agent or not.

    1. Download the driver library from the MySQL Database site
    2. Copy the driver library to <AgentInstallDir>/agenthome/thirdparty/lib 
    3. Restart the agent

    Comment

     

    • Nagireddy Tadi

      The MySQL Database driver is not shipped with the OIC Agent. You must download the correct driver and configure in your onpremise agent. Please double check whether your have done following configuration on your onpremise agent or not.

      1. Download the driver library from the MySQL Database site
      2. Copy the driver library to <AgentInstallDir>/agenthome/thirdparty/lib 
      3. Restart the agent
    • Christopher Maggiulli

      Thank you this worked. I was checking the Oracle Cloud Weblogic Server, not the On-Prem agent.  Once I added the jar to the On-Prem agent it started working.  On an unrelated note, are there any suggestions on running the wrapping the On-Prem agent with init.d or some other service wrapper?  I don't like starting / stopping with a bash script/nohup