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
Can any one have the script to integrate Sybase. Could you please provide .
thanks
Anonymous
2 years ago

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.

@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
Advisor
2 years ago
So 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
manthena2020
Advisor
2 years ago
Do we have a solution. ? Please
manthena2020
Advisor
2 years ago
code
manthena2020
Advisor
2 years ago
can i have ur mail id for support request
manthena2020
Advisor
2 years ago
How to download latest version of collector & which version of jar do we need to add??
manthena2020
Advisor
2 years ago
Can you please update the JDBC jar version to use and to update process of collector
manthena2020
Advisor
2 years ago
Thanks 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
manthena2020
Advisor
2 years ago
Hi, it’s jconn42 or 4.2?

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