Sybase monitoring support
Is Sybase database supported. Do you have any standard plugin's to be used.
If Sybase is not supported, any OOB options to enable monitoring.
MuraliKj
Posted 3 years ago·Last reply 3 years ago
28 comments
Is Sybase database supported. Do you have any standard plugin's to be used.
If Sybase is not supported, any OOB options to enable monitoring.
manthena2020
·3 years agoiam using this in my script
Class.forName("com.sybase.jdbc4.jdbc.SybDriver")
i have jconn4.0.1.jar in my wraper config. still its saying cant find driver. can you please tell me weather iam calling correctly or not
manthena2020
·3 years agoiam getting this error while giving ssh
The script failed, elapsed time: 0 seconds - invalid privatekey: [B@16932a9b com.jcraft.jsch.JSchException: invalid privatekey: [B@16932a9b at com.jcraft.jsch.KeyPair.load(KeyPair.java:712) at com.jcraft.jsch.KeyPair.load(KeyPair.java:603) at com.jcraft.jsch.IdentityFile.newInstance(IdentityFile.java:38) at com.jcraft.jsch.JSch.addIdentity(JSch.java:387) at com.jcraft.jsch.JSch.addIdentity(JSch.java:351) at com.jcraft.jsch.JSch$addIdentity.call(Unknown Source) at Script158.run(Script158.groovy:59)
thanks
Paul_Jeffries
·3 years ago@manthena2020
There aren’t any datasources for Sybase available out of the box, so you will need to build something yourself or have our professional services team build it for you.
You can use this doc https://www.logicmonitor.com/support/logicmodules/datasources/data-collection-methods/jdbc-data-collection which gives some explanation on how to use JDBC and create a custom datasource
The JDBC collector allows created datasources that query databases to collect and store data from a SQL query, alert on them, and graph them.
A typical jdbc command would look like this
$ !jdbc url="jdbc:sybase:Tds:SERVER:PORT" username=XXX password=XXXX SQL
There are a few Oracle and MSSQL Datasources that may give you some ideas as a starting point
Kind regards
Paul
manthena2020
·3 years agoWhy did you build an integration if you were just going to SSH into it?
If you’re going to SSH, the fact that it’s Sybase has no impact. Just do something like this or this.
Please help
manthena2020
·3 years agoI mean I have done integration by calling jcon4 and read the db . Now I want metrics , what to do
LM User
·3 years agoWhy did you build an integration if you were just going to SSH into it?
If you’re going to SSH, the fact that it’s Sybase has no impact. Just do something like this or this.
manthena2020
·3 years agoits integrated with sybase , but here in want to collect data by ssh
LM User
·3 years agoYou need to print the data out in the right format.
manthena2020
·3 years agoThank you . Integration is done . can you please tell me how to pull metrics
Paul_Jeffries
·3 years ago@manthena2020
The files we use are called jconn42.jar & jconnect-7.7.jar
But as I’ve mentioned a few times already, if you raise a support ticket we can share them with you directly
Kind regards
Paul
manthena2020
·3 years agoHi, it’s jconn42 or 4.2?
Paul_Jeffries
·3 years agoHi @manthena2020
We usually suggest having both jconn42.jar & jconnect07.7.jar in the relevant location. If you raise a support ticket we can share this with you directly.
Kind regards
Paul
manthena2020
·3 years agoThanks soo much for your help. can you please let me know what jar we need to install for sybase. is it jconn4 or jconnect 7.7. please help
Paul_Jeffries
·3 years agoHi @manthena2020
Thanks for coming back on this, details for upgrading a collector can be found here https://www.logicmonitor.com/support/collectors/collector-management/managing-your-collector#upgrading
I continue to encourage you to raise a support request directly so we can fully assist you with resolving this issue
Kind regards
Paul
manthena2020
·3 years agoCan you please update the JDBC jar version to use and to update process of collector
manthena2020
·3 years agoHow to download latest version of collector & which version of jar do we need to add??
Paul_Jeffries
·3 years ago@manthena2020 You can raise support requests via your LogicMonitor portal, details can be found here https://www.logicmonitor.com/support/about-logicmonitor/customer-support/logicmonitor-technical-support-packages#channels
manthena2020
·3 years agocan i have ur mail id for support request
Paul_Jeffries
·3 years ago@manthena2020 Thanks for sharing this, a quick glance suggests the code looks ok but as I mentioned above there are some changes you need to make to your environment/collector to get this working
Please raise a support request so we can work this through with you
manthena2020
·3 years agocode
Paul_Jeffries
·3 years agoHi @manthena2020
In the first instance can you ensure your collector is upgraded to v31.200 or later.
Also its likely that the jars aren’t being loaded and will need to be added to the collector https://www.logicmonitor.com/support/terminology-syntax/scripting-support/adding-groovy-libraries and you’ll then probably need to reference them via the wrapper config
But if you can raise this via support request we can give you the appropriate detail
Kind regards
Paul
LM User
·3 years agoAsk support to answer the questions above. If the answer isn't in the docs, ask them to put it in the docs.
manthena2020
·3 years agoDo we have a solution. ? Please
LM User
·3 years agoOk so JDBC is the method.
And the built in JDBC method won't work because the connection string needs the driver for Sybase, which either doesn't exist you you don't know what it is called. The driver name is a support question (which answer should be in the docs if it's not there already).
And a scripted JDBC option requires groovy to have a Sybase driver, which the collector either doesn't have installed or you don't know what it takes to use it. That is also a support question which answer should also be in the docs.
manthena2020
·3 years agoSo far nothing is there, need to pull all the stuff using any alternative methods. The error we are seeing with connecting “Groovy” to Sybase is not related to snmp or ssh – it is simply that Groovy cannot located the required JDBC “jconn4” SybDriver.Please post any sort of script that helps us please
LM User
·3 years agoAlmost certainly, the answer is, "Yes, LM can monitor it."
The right question is: "Does LM do Sybase monitoring OOTB or do I have to build it?" The way to know if it's available out of the box is to look for any datasources for it, either already installed in your portal or in the exchange. If none exist, you'll need to figure out how to get at the data you want and build that into one of the OOTB collection mechanisms (SNMP, WMI, JDBC, etc.). If the data isn't available through one of those methods, you'd need to see if it's available through a method that can be scripted (SSH, API, etc.). Then you'd just need to build that in. There's a whole live class (LMCD) and several on demand trainings to help with this.
@manthena2020, Did you go through the process of identifying whether they exist in your portal or in the exchange? If so and you didn’t find anything, did you figure out how you want to get at the data? Was scripting required?
manthena2020
·3 years agoCan any one have the script to integrate Sybase. Could you please provide .
thanks
LM User
·3 years agoAlmost certainly, the answer is, "Yes, LM can monitor it."
The right question is: "Does LM do Sybase monitoring OOTB or do I have to build it?" The way to know if it's available out of the box is to look for any datasources for it, either already installed in your portal or in the exchange. If none exist, you'll need to figure out how to get at the data you want and build that into one of the OOTB collection mechanisms (SNMP, WMI, JDBC, etc.). If the data isn't available through one of those methods, you'd need to see if it's available through a method that can be scripted (SSH, API, etc.). Then you'd just need to build that in. There's a whole live class (LMCD) and several on demand trainings to help with this.