nagios xi 5.2.1 config wizard services not comes in nagiosql

[zaji_nms]

[root@test-nagios zops]# chage -l nagios
Last password change : Jun 06, 2012
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : 0
Maximum number of days between password change : 99999
Number of days of warning before password expires : 7

[lmiltchev]

Run the following command and show us the output in code wraps:

Code: Select all

grep ndo2db /var/log/messages

Is opening a support ticket in our email ticketing system an option for you? We may need to schedule a remote session in order to further troubleshoot this issue. Thanks!

[zaji_nms]

we do have option to open a email ticket with support but how ? never done remote session before

previuos cmdsubsys.log i have observed

/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&username=nagiosxi&password=q80899' -O nagiosql.loginLOGIN SUCCESSFUL!
IMPORTING CONFIG FILES...URL: http://localhost/nagiosxi/includes/components/ccm/
Array
(
)

=======================================================================================================================================
test-nagios ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

-----------------------------------------------------
ndo2db.cfg & config.inc.php (ndoutils )

db_user=nagios
db_pass=n@gweb

all services are running as well
-----------------------------------------------------
[root@test-nagios data]# mysql -unagios -pn@gweb
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 925
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, 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.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| nagios |
| test |
+--------------------+
3 rows in set (0.00 sec)

[zaji_nms]

also plz check
i am able to delete add modified through ccm /var/log/mess

Dec 31 09:57:25 test-nagios nagios: ndomod: Successfully connected to data sink. 15 queued items to flush.
Dec 31 09:57:25 test-nagios nagios: ndomod: Successfully flushed 15 queued items to data sink.
Dec 31 09:57:25 test-nagios nagios: ndomod registered for process data
Dec 31 09:57:25 test-nagios nagios: ndomod registered for log data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for system command data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for event handler data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for notification data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for comment data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for downtime data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for flapping data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for program status data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for host status data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for service status data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for adaptive program data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for adaptive host data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for adaptive service data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for external command data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for aggregated status data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for retention data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for contact data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for contact notification data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for acknowledgement data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for state change data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for contact status data'
Dec 31 09:57:25 test-nagios nagios: ndomod registered for adaptive contact data'
Dec 31 09:57:25 test-nagios nagios: Event broker module '/usr/local/nagios/bin/ndomod.o' initialized successfully.

[lmiltchev]

db_user=nagios
db_pass=n@gweb

It seems like you modified the ndo2db.cfg by changing the "default" db_user from "ndoutis" to "nagios". Can you run the following commands and show the output?

Code: Select all

echo "show grants for 'ndoutils'@'localhost';" | mysql -u root -pnagiosxi
echo "show grants for 'nagios'@'localhost';" | mysql -u root -pnagiosxi

You can open a support ticket in our email ticketing system by sending an email to [email protected]. Please, type in the email's subject: "nagios xi 5.2.1 config wizard services not comes in nagiosql" and post a link to this post in the email's body. Thanks!

[zaji_nms]

I have one suggestion in forum new post ( comment ) should come always first not on last page

[root@test-nagios zops]# echo "show grants for 'ndoutils'@'localhost';" | mysql -u root -pnagiosxi
Grants for ndoutils@localhost
GRANT USAGE ON *.* TO 'ndoutils'@'localhost' IDENTIFIED BY PASSWORD '*244733929909A95DDF1A7F78DD067589B4092EE7'
GRANT ALL PRIVILEGES ON `nagios`.* TO 'ndoutils'@'localhost' WITH GRANT OPTION
[root@test-nagios zops]# echo "show grants for 'nagios'@'localhost';" | mysql -u root -pnagiosxi
Grants for nagios@localhost
GRANT USAGE ON *.* TO 'nagios'@'localhost' IDENTIFIED BY PASSWORD '*244733929909A95DDF1A7F78DD067589B4092EE7'
GRANT ALL PRIVILEGES ON `nagios`.* TO 'nagios'@'localhost'
[root@test-nagios zops]#

[lmiltchev]

I would recommend that you open a support ticket in our email ticketing system to further troubleshoot the issue.

Meanwhile, let's check some of the permissions. Run the following commands and show the output:

Code: Select all

ll -d /usr/local/nagios/etc
ll /usr/local/nagios/etc
ll -d /usr/local/nagiosxi/scripts/
ll /usr/local/nagiosxi/scripts/

[zaji_nms]

PFA requested log

[zaji_nms]

Dear lmiltchev,
thanks for your kind support and concern after change permission /usr/local/nagios/etc/import issue get resolve , but why its get changed and why nagiosxi reset permis script could not fix it as i have run that script sevral times but no luk ?

before :- drw-rw-r-- 2 apache nagios 4096 Dec 27 15:00 import

after change chmod -R 775 import

now working : drwxrwxr-x 2 apache nagios 4096 Dec 27 15:00 import

[lmiltchev]

I am glad your issues has been resolved! I am not sure why your permissions were different - perhaps someone made changes to the system? Running the "reset_config_perms.sh" script should have taken care of the issue - it is strange it didn't. I can see the following line in the script:

Code: Select all

/bin/chmod -R ug+rw /usr/local/nagios/etc/

Also, you may need to run:

Code: Select all

chmod g+s /usr/local/nagios/etc/import

Here's the "default" permissions on the "import" directory:

Code: Select all

ll -d /usr/local/nagios/etc/import
drwsrwsr-x 2 apache nagios 4096 Jan  4 15:30 /usr/local/nagios/etc/import

Let us know if it is all right to lock this topic. Thanks!