NagiosXI 5.29 -> 5.30 Issue

[rajasegar]

Did an upgrade and it fails at the following line.
Tried running again same problem
sudo ./upgrade

Code: Select all

Dashlet looks ok...
CMD: cp -rf /usr/local/nagiosxi/tmp/2tcbp/rss_dashlet /usr/local/nagiosxi/html/includes/dashlets/
CMD: rm -rf /usr/local/nagiosxi/tmp/2tcbp
CMD: . /usr/local/nagiosxi/var/xi-sys.cfg && chown -R $nagiosuser /usr/local/nagiosxi/html/includes/dashlets/rss_dashlet


Done!
Dashlets installed/updated OK
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:2: ERROR:  column "api_key" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:3: ERROR:  column "api_enabled" of relation "xi_users" already exists
UPDATE 31
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:8: ERROR:  column "login_attempts" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:9: ERROR:  column "last_attempt" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:10: ERROR:  column "last_password_change" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:13: ERROR:  column "last_login" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:14: ERROR:  column "last_edited" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:15: ERROR:  column "last_edited_by" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:16: ERROR:  column "created_by" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:17: ERROR:  column "created_time" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:24: ERROR:  relation "xi_eventqueue_eventqueue_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:33: ERROR:  relation "xi_eventqueue" already exists
ERROR 1045 (28000): Access denied for user 'nagiosql'@'localhost' (using password: YES)
[nagios@MYUCBPNAGIAPP01 nagiosxi]$

Database access seems fine

Code: Select all

[nagios@MYUCBPNAGIAPP01 nagiosxi]$  mysql --user=nagiosql --password=nagiosxi --host=localhost
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 493630
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> use nagiosql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

See attached installation log and the config.inc.php file

upgrade.zip

config.inc.zip

Previous upgrade was ok without any issues.

[dwhitfield]

Could you post the output of echo "show grants for 'nagiosql'@'localhost';" | mysql -t -uroot -pnagiosxi nagiosql? Thanks!

[lmiltchev]

Check out the solution posted here:
https://support.nagios.com/forum/viewto ... 25#p198128

[rajasegar]

Could you post the output of echo "show grants for 'nagiosql'@'localhost';" | mysql -t -uroot -pnagiosxi nagiosql? Thanks!

Code: Select all

[nagios@nagiosprodxi3 debug]$ echo "show grants for 'nagiosql'@'localhost';" | mysql -t -uroot -pnagiosxi nagiosql
+-----------------------------------------------------------------------------------------------------------------+
| Grants for nagiosql@localhost                                                                                   |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'nagiosql'@'localhost' IDENTIFIED BY PASSWORD '*244733929909A95DDF1A7F78DD067589B4092EE7' |
| GRANT ALL PRIVILEGES ON `nagiosql`.* TO 'nagiosql'@'localhost' WITH GRANT OPTION                                |
+-----------------------------------------------------------------------------------------------------------------+

[rajasegar]

Check out the solution posted here:
https://support.nagios.com/forum/viewto ... 25#p198128

Thanks. Hope there will be better QC next time.

Please close this thread.

[dwhitfield]

Glad to hear it is resolved. I am going to lock the thread. Please feel free to post again if you have you another issue. Thank you for using the Nagios forums!