Welcome to Asemon documentation.
Asemon is a tool for monitoring Sybase servers : ASE , RS , IQ, RAO
Two parts in asemon :
asemon_logger : the "agent" part, written in Java, which periodically collects counters from a "monitored server", and archive them in an "archive database" (currently this "archive database" must be a Sybase ASE database)
asemon_report : the "query" and "reporting" part. Set of PHP pages, which can be installed in a Web Server. With these pages, you can query the "archive database" in order to analyse the data captured by asemon_logger.
Here are the known restrictions when using asemon on production servers [Asemon restrictions].
Detail of asemon relases : see [asemon what is new]
First, you have to install asemon_logger on a serveur (Windows or Unix)
See [Asemon logger installation] for details.
Second, install asemon_report (PHP pages in a web server).
See [Asemon report installation] for details.
Wiki: Asemon logger installation
Wiki: Asemon report installation
Wiki: Asemon restrictions
Wiki: Asemon_report documentation
Wiki: asemon what is new
Hi Team ,
I am installing asemon first time on Linux ASE 16.0 , could you please help me or share the sample for Sampleconfig.xml file .
Regards,
Bhupendra Sharma
+44-7404361486
Hi,
here is a sample config file where MYARCHIVESRV is the ASE server hosting the asemon repository database
and TESTSRV is the monitored ASE server
"sa" is used on both servers for connection.
Don't forget to update the "passwords" file in directory from which you start asemon_logger.
Look at https://sourceforge.net/p/asemon/wiki/Asemon%20logger%20installation/ fro details
Thansk Paul , for Replying
I am getting below error while installing asemon_logger
Please suggest if any value need to set in between
<srvdescriptors>
.
.
</srvdescriptors>
Error -
cailstceccdb1 asemon/asemon_logger_V3.1.3% ./asemon_logger.sh -c SR0config_file.xml
2020/02/15 23:41:06.761 main - Start Asemon_logger V3.1.3a
2020/02/15 23:41:06.785 main - Current directory is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3
2020/02/15 23:41:06.785 main - Java version : 1.7.0
2020/02/15 23:41:06.787 main - Classpath is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/dist/Asemon_logger_V3.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/jdom.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/xerces.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/java-getopt-1.0.9.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jconn4.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jTDS3.jar
2020/02/15 23:41:06.787 main - Config file used : SR0config_file.xml
2020/02/15 23:41:07.680 main - textsize for retreiving text (XML documents) for 'SR0': 65536
2020/02/15 23:41:07.681 main - validateConfig : (SR0config_file.xml) : not all monitored servers have a corresponding srvDescriptor
cailstceccdb1 asemon/asemon_logger_V3.1.3%
Regards,
Bhupendra Sharma
+44-7404361486
Hi Bhupendra,
in the section
<MonitoredSrv>... </MonitoredSrv>
you can have several "monitored server" sections
<SRV>...</SRV>
For each of them you give the name of monitored server
<name> name_of_monitored_server </name>
and you must give the reference to the subsection srvDescriptor. In case of ASE you can just use "ASE"
Ex . :
Best regards
Jpm
Thanks Jpm ,
Please help -
I am getting below error , my ASEMON and Monitor Database both on same server . is that require any entry in interface file ?
cailstceccdb1 asemon/asemon_logger_V3.1.3% setenv ASEMON_LOGGER_HOME /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3
cailstceccdb1 asemon/asemon_logger_V3.1.3%
cailstceccdb1 asemon/asemon_logger_V3.1.3% ./asemon_logger.sh -c 'SR0config_file.xml'
2020/02/23 16:12:10.567 main - Start Asemon_logger V3.1.3a
2020/02/23 16:12:10.591 main - Current directory is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3
2020/02/23 16:12:10.591 main - Java version : 1.7.0
2020/02/23 16:12:10.593 main - Classpath is : /sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/dist/Asemon_logger_V3.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/jdom.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/xerces.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/lib/java-getopt-1.0.9.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jconn4.jar:/sapmedia/backup/SRASE/asemon/asemon_logger_V3.1.3/jConnect-16_0/classes/jTDS3.jar
2020/02/23 16:12:10.593 main - Config file used : SR0config_file.xml
2020/02/23 16:12:11.578 main - Try to connect to srv : ASEMON
2020/02/23 16:12:11.579 main - connectSRV : ERROR Server ASEMON does not exists in interfaces or SQL.INI file
java.io.FileNotFoundException: passwords (No such file or directory)
at java.io.FileInputStream.<init>(FileInputStream.java:158)
at java.io.FileInputStream.<init>(FileInputStream.java:113)
at java.io.FileReader.<init>(FileReader.java:70)
at asemon_logger.PassFileMgr.delPassword(PassFileMgr.java:268)
at asemon_logger.Asemon_logger.main(Asemon_logger.java:538)
2020/02/23 16:12:11.580 main - Password removed from passwords file for 'ASEMON.sa'
cailstceccdb1 asemon/asemon_logger_V3.1.3%</init></init></init>
Regards,
Bhupendra Sharma
07404361486
Hi
of course you need an entry for your ASE server named "ASEMON" in interfaces file. Else you get the error :
2020/02/23 16:12:11.579 main - connectSRV : ERROR Server ASEMON does not exists in interfaces or SQL.INI file
Regards
JPM
Hi JPM,
I am new in ASEMON and need your support , I have trying to install ASEMON - Report in my Laptop which connect to my ASEMON-Logger and Monitoring Server but i am getting below error while running for Apche in ASEMON -Report confgiuration . Please suggest and let me know how to setup ASEMON-REport -
C:\AsemonReportSRV>
C:\AsemonReportSRV>startApache.bat
C:\AsemonReportSRV>REM Use this file to manually start the Apache server
C:\AsemonReportSRV>REM Note : start the "setup.bat" file before, if you don't have Open Client installed on your machine
C:\AsemonReportSRV>set PATH=c:\AsemonReportSRV\sybase\OCS-16_0\bin;c:\AsemonReportSRV\sybase\OCS-16_0\dll;c:\AsemonReportSRV\sybase\OCS-16_0\lib3p;C:\Sybase\DataAccess64\ADONET\dll;C:\Sybase\DataAccess\ADONET\dll;C:\Sybase\DataAccess64\ODBC\dll;C:\Sybase\DataAccess\ODBC\dll;C:\Sybase\DataAccess64\OLEDB\dll;C:\Sybase\DataAccess\OLEDB\dll;C:\Sybase\OCS-15_0\lib3p64;C:\Sybase\OCS-15_0\lib3p;C:\Sybase\OCS-15_0\dll;C:\Sybase\OCS-15_0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Webex\Webex\Applications;C:\Users\bhupendra.sharma\AppData\Local\Microsoft\WindowsApps;;C:\AsemonReportSRV\php-5.6.40
C:\AsemonReportSRV>"C:\AsemonReportSRV\Apache24\bin\httpd"
(OS 10013)An attempt was made to access a socket in a way forbidden by its access permissions. : AH00072: make_sock: could not bind to address [::]:80
(OS 10013)An attempt was made to access a socket in a way forbidden by its access permissions. : AH00072: make_sock: could not bind to address 0.0.0.0:80
AH00451: no listening sockets available, shutting down
AH00015: Unable to open logs
C:\AsemonReportSRV>
Regards,
Bhupendra Sharma
+44-7404361486
Hi,
its because the port 80 is already in use on your PC
Try another port.
Change port number in C:\AsemonReportSRV\Apache24\conf\httpd.conf
For example :
and then, when you call the asemon_report page :
localhost:8080//asemon_report/asemon_report.php
Cheers
Jpm
Hi JPM ,
could you please help my attched screenshot and ASEMON Report Page is not loading .
Please let me know if any details i m missing , All three page in same screenshot -
Regards,
Bhupendra Sharma
+44-07404361486
Hi,
I see that asemon_logger is blocked because it cannot convert a table due to option "select into/bulk copy/pll sort" not set on your asemon database.
Apache starts without error.
How do you invoke the asemon_report page from your browser ?
Best regards
Jpm
Hi JPM ,
Is that option "select into/bulk copy/pll sort" need to set on Monitor or ASEMON Server ?
In our Production server we have not enabled bulk option .
Regards,
Bhupendra Sharma
+44-07404361486
Yes only on asemon database
Regards
Jpm
Hi JPM ,
Thanks for Reply , I have enabled bulkcopy on ASEMON but my ASEMON_LOGGER Process Stuck below -
Is there any issue or it running like this way and I need to run in back group
cailstceccdb1 asemon/asemon_logger_V3.1.3% asemon_logger.sh -c SR0config_file.xml
2020/03/10 13:49:06.925 SR0_WClassInf - Start thread.
2020/03/10 13:49:06.930 SR0_WEvInf - Start thread.
2020/03/10 13:49:54.222 SR0_MonSQL - MonSQL BootID = 1
2020/03/10 13:49:54.353 SR0_MonState - Modify archive table : alter table SR0_MonState modify [SnapsExecuted] bigint null
2020/03/10 13:49:54.368 SR0_MonState - Archive table modified
create index idx on SR0_MonState (Timestamp, Interval )
2020/03/10 13:50:06.931 Purge SR0 - Start thread.
2020/03/10 13:50:06.931 Purge SR0 - Try to connect to srv : ASEMON
2020/03/10 13:50:06.932 Purge SR0 - Srv found in interfaces or SQL.INI file. Host=cailstceccdb1 Port=4901
2020/03/10 13:50:06.936 Purge SR0 - Using password from passwords file for 'ASEMON.sa'
2020/03/10 13:50:06.954 Purge SR0 - Connected to archive server : ASEMON Database : ASEMON
Regards,
Bhupendra Sharma
CadentGas - DBA
Ashbrook Court, Coventry CV7 8PE
(M) +44 7404361486
From: Jean-Paul Martin jpm-jpm@users.sourceforge.net
Sent: 10 March 2020 09:55
To: [asemon:wiki] Home@wiki.asemon.p.re.sourceforge.net
Subject: [asemon:wiki] Discussion for Home page
[CAUTION: This Email is from outside the Organization. Do not click links or open attachments unless you trust the sender.]
Yes only on asemon database
Regards
Jpm
Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/asemon/wiki/Home/https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsourceforge.net%2Fp%2Fasemon%2Fwiki%2FHome%2F&data=02%7C01%7Cbhupendrasharma%40hcl.com%7C0fabee3593a14c5cb41608d7c4d9288f%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C1%7C637194309274617350&sdata=q72c%2FzNP0pGiufQF%2B0%2F4BL%2FauxrR7ep2WufNXj%2BsBbk%3D&reserved=0
To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsourceforge.net%2Fauth%2Fsubscriptions%2F&data=02%7C01%7Cbhupendrasharma%40hcl.com%7C0fabee3593a14c5cb41608d7c4d9288f%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C1%7C637194309274617350&sdata=MuIcDTLQgDIwsiOcvI0c1PJpBcuJcLxeuEFXbsmumk4%3D&reserved=0
::DISCLAIMER::
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
Hi JPM ,
I have run ASEMON Logger and process stuck , is there any error log file we can check or it is running like this and i need to run in backgrond ?
cailstceccdb1 asemon/asemon_logger_V3.1.3% asemon_logger.sh -c SR0config_file.xml
2020/03/10 13:49:06.925 SR0_WClassInf - Start thread.
2020/03/10 13:49:06.930 SR0_WEvInf - Start thread.
2020/03/10 13:49:54.222 SR0_MonSQL - MonSQL BootID = 1
2020/03/10 13:49:54.353 SR0_MonState - Modify archive table : alter table SR0_MonState modify [SnapsExecuted] bigint null
2020/03/10 13:49:54.368 SR0_MonState - Archive table modified
create index idx on SR0_MonState (Timestamp, Interval )
2020/03/10 13:50:06.931 Purge SR0 - Start thread.
2020/03/10 13:50:06.931 Purge SR0 - Try to connect to srv : ASEMON
2020/03/10 13:50:06.932 Purge SR0 - Srv found in interfaces or SQL.INI file. Host=cailstceccdb1 Port=4901
2020/03/10 13:50:06.936 Purge SR0 - Using password from passwords file for 'ASEMON.sa'
2020/03/10 13:50:06.954 Purge SR0 - Connected to archive server : ASEMON Database : ASEMON
Regards,
Bhupendra Sharma
+44-7404361486
Hi JPM ,
I am getting issue while runing ASEMON REPORT , could you please check and advise -
C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>startApache.bat
C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>REM Use this file to manually start the Apache s
C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>REM Note : start the "setup.bat" file before, if
C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>set PATH=C:\Users\bhupendra.sharma\Documents\Ase
\dll;C:\Users\bhupendra.sharma\Documents\AsemonReportSRV\sybase\OCS-16_0\lib3p;c:\AsemonReportSRV\sy
\AsemonReportSRV\sybase\OCS-16_0\bin;c:\AsemonReportSRV\sybase\OCS-16_0\dll;c:\AsemonReportSRV\sybas
C:\SAP\ASE-16_0\dll;C:\SAP\ASE-16_0\bin;C:\SAP\COCKPIT-4\bin;C:\SAP\OCS-16_0\lib3p64;C:\SAP\OCS-16_0
\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Amazo
11.2.0\client_1\network\BIN;C:\AsemonReportSRV\php-5.6.40;C:\AsemonReportSRV\php-5.6.40;C:\Users\bhu
RV\php-5.6.40
C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>"C:\Users\bhupendra.sharma\Documents\AsemonRepor
(OS 10049)The requested address is not valid in its context. : AH00072: make_sock: could not bind t
AH00451: no listening sockets available, shutting down
AH00015: Unable to open logs
C:\Users\bhupendra.sharma\Documents\AsemonReportSRV>
Regards,
Bhupendra Sharma
+44-07404361486
Hi JPM ,
I have chnage my port 8080/8000 but stuck at below and my http://localhost:8080 not working -
C:\AsemonReportSRV>REM Use this file to manually start the Apache server
C:\AsemonReportSRV>REM Note : start the "setup.bat" file before, if you don't have Open Client installed on your machine
C:\AsemonReportSRV>set PATH=C:\Sybase\DataAccess64\ADONET\dll;C:\Sybase\DataAccess\ADONET\dll;C:\Sybase\DataAccess64\ODBC\dll;C:\Sybase\DataAccess\ODBC\dll;C:\Sybase\DataAccess64\OLEDB\dll;C:\Sybase\DataAccess\OLEDB\dll;C:\Sybase\OCS-15_0\lib3p64;C:\Sybase\OCS-15_0\lib3p;C:\Sybase\OCS-15_0\dll;C:\Sybase\OCS-15_0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Users\bhupendra.sharma\AppData\Local\Microsoft\WindowsApps;;C:\AsemonReportSRV\php-5.6.40
C:\AsemonReportSRV>"C:\AsemonReportSRV\Apache24\bin\httpd"
Regards,
Bhupendra Sharma
+44-7404361486
Hi Bhupendra,
so now when you start Apache you get no error and the command hung : this is normal because the cmd windows must stay open (there is a possibility to start apache as a windows service with the -n switch of httpd, look to Apache documentation)
And if you try http://localhost/8080/asemon_report/asemon_report.php
in a browser on same machine, you get nothing ?
Regards
Jpm
Hi Martin ,
http://localhost:8080/Asemon_report/Asemon_report.php like is open but i am not able to connect ASEMON server and getting below error , Plaese find error in below and attched screen shot -
localhost:8080 says
ERROR
Module : connectServer()
Message :
Cannot open connection
Query:
Regards,
Bhupendra Sharma
+44-07404361486
Hi Paul , Can you please check and update on error i m getting
REgards,
Bhupendra SHarma
+44-07404361486
Hi Bhupendra,
did you correctly setup the definition of your asemon (archive) server in "C:\AsemonReportSRV\Sybase\ini\sql.ini" ?
Then execute :
setup.bat
startApache.bat
let the cmd window open and go to you browser
If you give a correct user and password for asemon server you defined in you sql.ini file, it should connect
Else check if startapache has raise some error during startup
No more idea
Regrds
Jpm