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.

Hi @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 configBut if you can raise this via support request we can give you the appropriate detailKind regardsPaul

@manthena2020 The files we use are called jconn42.jar & jconnect-7.7.jarBut as I’ve mentioned a few times already, if you raise a support ticket we can share them with you directlyKind regardsPaul

Ask support to answer the questions above. If the answer isn't in the docs, ask them to put it in the docs.

@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 pointKind regardsPaul

Almost 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.

Sybase monitoring support | LogicMonitor

manthena2020
Advisor
2 years ago
Thank you . Integration is done . can you please tell me how to pull metrics
Anonymous
2 years ago
You need to print the data out in the right format.
manthena2020
Advisor
2 years ago
its integrated with sybase , but here in want to collect data by ssh
Anonymous
2 years ago
Why 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
Advisor
2 years ago
I mean I have done integration by calling jcon4 and read the db . Now I want metrics , what to do
manthena2020
Advisor
2 years ago

Why 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
Advisor
2 years ago
iam 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
manthena2020
Advisor
2 years ago
iam 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

Forum Discussion

Sybase monitoring support

Related Content

Migration to New Support Platform

What happened to chat support?

New Support Portal Suggestions

Customer Support a Dumpster Fire

Process Monitoring

Recent Discussions

LM APM - Traces - HTTP Post from Powershell Scripts

dell hosts and idrac combined

Python script to run API call - AddWebsite - Need help with collectors

Can anyone help modify this Datasource to be able to use any port?

Dashboard updates