I see this in a host file. define host { host_name knew alias knew address knew.int.example.org parents bast ... Where is the 'parents' value set in NagioSQL?
I raised a similar issue for FreeBSD and have referenced this issue from there: https://github.com/net-snmp/net-snmp/issues/280
If a new release had been made (say 3.4.1), then 3.4.0 would still work on FreeBSD. Now it does not work. No new installs can occur until the FreeBSD port is fixed. I have no doubt that all other package systems are now similarly broken like this.
If a new release had been made (say 3.4.1), then 3.4.0 would still work on FreeBSD. Now it does not work. No new installs can occur until the FreeBSD port is fixed. I have no doubt that all other pacakge systems are now similarly broken like this.
The FreeBSD port of nagiosql is marked as broken now, because the tarball is now unfetchable. When the software detects that the tarball it has has downloaded does not match what is expected for this release (i.e. the SHA256 values has changed), the install will not happen. This is for security reasons. From https://www.freshports.org/net-mgmt/nagiosql/: BROKEN: unfetchable IGNORE: is marked as broken: unfetchable This is because the size and SHA256 values differ. This a security check.
I encourage you to issue a new release each time this happens. Please increment the release number. Why? If you don't, I know you will break the FreeBSD package, and I suspect any other package system.
So the answer is yes, the tarball for release 3.4.0 was released on 2019-04-26? Please be direct.
Has the 3.4.0 been rerolled? Does it contain the same files as it id back when it was first released? The FreeBSD port has been marked as unfetchable. When I investigated, size differences were observed. Specifically, https://downloads.sourceforge.net/project/nagiosql/nagiosql/NagiosQL%203.4.0/nagiosql-3.4.0.tar.bz2 was 1040465 bytes instead of the expected 1032592. When the FreeBSD port was updated on Nov 10 2019, the size and checksum were recorded then: TIMESTAMP = 1539089848 SHA256 (nagiosql-3.4.0.tar.bz2)...
That works. At first, I thought it hadn't, but that was only because there was now no date. So all the same files were affected, but this will happen only once. My preference would be to add a configuration item for this, but that may take a while to come. See how long it took me to try this.
When I export my NagioSQL configuration, I then import it into a repository. Before I commit the changes, I run a diff to see what changed. This is difficult to do when you export, because every file has changed.
It appears this is done through Administration -> Supervision -> Services Select your service, add it to a host group.
If I am at admin/hostgroups.php how do I see the services which are associated with this host group?
I have two distinct nagios configurations. I have successfully imported one configuration and now I am trying to learn how to import and manage a second. I see data domains & config targets but I don't know exactly how to use them For the second configuration, I have create a new Config target via admin/configtargets.php NOTE: this page confuses me because the menu refers to 'Config targets' but the caption says 'Configuration domain administration'. I called the new target EXTERNAL. It seems that...
I have imported my existing Nagios configuration, renamed a host, exported the configuration, and reloaded Nagios. Success. Thank you.
Success. On the MySQL server: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '[redacted]'; GRANT USAGE ON *.* TO 'root'@'%' WITH GRANT OPTION;
The easy way out: comment out those steps in the code issue the permissions myself But that doesn't help things. ;0
Heh. now I get: Access denied for user 'root'@'%' to database 'db_nagiosql_v34' I can do this from mysql on the database server but not from the webserver: GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ONdb_nagiosql_v34.* TO 'nagiosql_user'@'10.55.21.6' Clearly, a permissions issue, which I have not tracked down yet.
I think I found it: Jan 11 17:56:29 fruity-int httpd: running: 'GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `db_nagiosql_v34`.* TO 'nagiosql_user'@'10.55.21.6'' Jan 11 17:56:29 fruity-int httpd: that failed with Access denied for user 'root'@'10.55.21.6' to database 'db_nagiosql_v34':: Jan 11 17:56:29 fruity-int httpd: leaving grantDBUser with return code 1 Trying that from MySQL: mysql> GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `db_nagiosql_v34`.* TO 'nagiosql_user'@'10.55.21.6';...
In grantDBUser, this returns zero rows: Jan 11 17:42:06 fruity-int httpd: this failed without an error message: 'SELECT * FROM `mysql`.`user` WHERE `Host`='10.55.21.6' AND `User`='nagiosql_user'' When I run that from the webserver use the root creds, I get one row returned. Still looking.
Which file can I start adding debugging to?
[dan@fruity-int:~] $ mysql -h mysql01.int.unixathome.org -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 280209 Server version: 5.6.42 Source distribution Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement....
For testing, I decided to supply 'abc' for all password. I got this, as expected: Create new NagiosQL database [mysql01.int.unixathome.org] Connection to the database server has failed by reason: Access denied for user 'root'@'fruity-int.int.unixathome.org' (using password: YES) Database server connection (privileged user) failed (mysqli) When I supply the correct value for 'Administrative Database Password', I get: Create new NagiosQL database Access denied for user 'root'@'fruity-int.int.unixathome.org'...
Interesting. The root password does not contain any special characters. The nagiosql password contained several special characters. I changed that password and it now contains only letters and digits. The result is the same.
I am configuring a new instance of NagiosQL 3.4.0 on FreeBSD 11.2 with PHP 7.2 and MySQL 5.6.42 The webserver is at fruity-int.int.unixathome.org The database server is at mysql01.int.unixathome.org I cannot complete the NagiosQL Installation: Setup phase. I keep getting: Access denied for user 'root'@'fruity-int.int.unixathome.org' to database 'db_nagiosql_v34' I do not know why this occurs: Create NagiosQL database user failed It is there, it has been created: mysql> select host,user from user...
I've just encounted this issue with ed25519 keys on 0.10.2 Is ed25519 supported ...
Attached...
FYI, it did not build on i386 and I have not investigated that yet: http://servi...
All seems well, just a few minutes after upgrading, the correct number of users is...
Ahhh Oh there it is... https://sourceforge.net/p/net-snmp/code/ci/master/tree/
My plan was to find the commit, apply it to my local tree, and try it out. But I...
I'm going to try this now.
The proof is in the pudding.
The proof is in the pudding.
The proof is in the pudding:
Patch at https://gist.github.com/dlangille/dc1bccfe046a283579b5
Before installing patched snmpd: $ snmpwalk -v3 -l authPriv -u rodvl -a SHA -A AuthPass...
What testing can I do on my systems to help?
Ahh, yes, the #ifdef lines 682-686. are you suggesting this patch: ```shell @@ -16,5...
I chatted with Ed Schouten about w. He suggested I try this from the command line:...
I chatted with Ed Schouten about w. He suggested I try this from the command line:...
Hello Bill, Fancy meeting you here.... I'm reading https://www.freebsd.org/cgi/man.cgi?query=utmpx&sektion=3&manpath=FreeBSD+10.1-RELEASE...
FYI, the value returned appears to go up, but never goes back down.
HOST-RESOURCES-MIB::hrSystemNumUsers.0 returns wrong number of users