Comments
-
Hello, run these commands. su - lpar2rrd cd /home/lpar2rrd/lpar2rrd/ #or where your LPAR2RRD work dir is . etc/lpar2rrd.cfg echo $ORACLE_HOME $ORACLE_HOME/sqlplus
-
Hello, please contact us at support@lpar2rrd.com for further testing
-
Hello, please apply this patch and then try connection test that is in the configuration form where you set up the monitoring and send us a screenshot of the output. Just to see if this small change fixes that. https://download.lpar2rrd.com/patch/7.34-2-3-g518c/sqlserver-apitest.pl.gz Gunzip it and copy to…
-
Hello, we recently encountered the same issue in our test labs. This is what helped: Upgrade libpq on the application end and try again. If you don't need scram-sha-256 authentication, you can revert to md5: * set password_encryption = md5 in postgresql.conf * change the authentication method to md5 in…
-
Hello, can you please try connection test that is in the configuration form where you set up the monitoring and send us a screeshot of the output?
-
ok, I see now, the seemingly simple solution can be to open /etc/odbcinst.ini and manually rename [MSSQL] to for example [ODBC Driver 13 for SQL Server] as our script looks for this naming scheme [ODBC Driver * for SQL Server], can you try and do that?
-
Hello, have you gone through the installation process and installed the ODBC driver? install documentation: https://www.lpar2rrd.com/Microsoft_SQL_Server-performance-monitoring-install.php#MSSQLServer Driver to install:…
-
Hello Greg, could you try connection test on the SSL only available DB with the patch below? 1. backup your current /home/lpar2rrd/lpar2rrd/bin/oracledb-test-api.pl file. 2. Apply this patch: https://download.lpar2rrd.com/patch/7.30-1-4-g6e97f/oracledb-test-api.pl.gz Gunzip it and copy to /home/lpar2rrd/lpar2rrd/bin (755,…
-
This patch should help with getting the capacity data for SQL Server instances with versions lesser than 2016. Would you mind testing it? https://download.lpar2rrd.com/patch/7.30-1-4-g6e97f/sqlserver-db2json.pl.gz Gunzip it and copy to /home/lpar2rrd/lpar2rrd/bin (755, lpar2rrd owner) -rw-rw-r-- 1 lpar2rrd lpar2rrd 23629…
-
seems like we will have to find a workaround for earlier versions, we will look into it
-
I see. 1. Are there tables under Capacity? (Relations, Filegroups) 2. Can you try to run this query on one of the DBs and let us know its result? "exec sp_spaceused @oneresultset = 1"
-
Hello, 1. Do you see all the DBs that are missing capacity in Health Status? 2. Have you granted this permission? "GRANT CONNECT ANY DATABASE TO lpar2rrd;"?
-
Hello, I see, thank you Markus. We tested in our lab too and it seems to work fine so we will include it in the future versions and run it as a default. Here is a patch for anyone else with this issue: https://download.lpar2rrd.com/patch/7.21-30-1-gd3ac/sqlserver-db2json.pl.gz Gunzip it and copy to…
-
Hello Elix, 1. This is just an alternative way to connect to the DB right? This is not on the list right now but we might consider it in the future. 2. You should be able to connect to the named instance if you enter "<host/IP>\<namedinstancename>" into the Host input field in web UI like showed in our updated…
-
Hello Elix, there is a toggle in perl module we use that sounds like the thing you want. "causes the connection attribute SQL_ATTR_ACCESS_MODE to be set to SQL_MODE_READ_ONLY" Can you apply this patch and test if it works as expected? It seems to not have any side effects on the current solution so we will use it as a…
-
Hello Elix, this is the intended. (we will add it to documentation, thank you for letting us know). Some of the data would still be visible if users permission were just for the one DB you use in web UI form, but you would lose some metrics as the script tries to connect every DB that shows up in the results of querying…
-
Hello, this version should fix that https://www.stor2rrd.com/download/stor2rrd-2.82-5.tar
-
Hello, to fix this issue follow the steps below. 1. https://download.lpar2rrd.com/patch/6.20-4-5-gc71e/oracleDB-genmenu.pl.gz Gunzip it and copy to /home/lpar2rrd/lpar2rrd/bin (755, lpar2rrd owner) -rw-rw-r-- 1 lpar2rrd lpar2rrd 18702 21. čec 10.20 oracleDB-genmenu.pl If your web browser gunzips it…
-
Hello, this is a known issue in 6.21, please let us know on our support email and we will send you a fix. support@lpar2rrd.com
-
Hello Frank, are you able to get version with this select? (on 19c) SELECT SOURCE_VERSION FROM sys.REGISTRY$SQLPATCH; Because I am unable to do so on 18c. Just want to check before we try to find a replacement. Regards,Daniel
-
Hello Frank, from the description it doesn't sound like an intended behaviour, please send us logs so we can look into it.Note a short problem description in the text field of the upload form. cd /home/lpar2rrd/lpar2rrd # or where is your LPAR2RRD working dir tar cvhf logs.tar logs…
-
Hello, could you please send us results of these API calls? <ip address>:215/api/storage/v1/luns<ip address>:215/api/storage/v1/projects Replace "<ip address>" with IP address of your ZFS and enter the URL into your web browser.Copy the results and send it in an email to support@stor2rrd.com Thank you.
Howdy, Stranger!