Support for Nagios products and services
https://support.nagios.com/forum/
SQL Error [nagiosxi] : ERROR: column "login_attempts" does not exist
LINE 1: SELECT user_id FROM xi_users WHERE (login_attempts >= 3) AN...
Code: Select all
echo "desc xi_users;" | mysql -unagiosxi -pnagios -h xxx.xxx.xxx.xxx nagiosxissax wrote:What is the output from this command:
- Please change user/pass and xxx.xxx.xxx.xxx
Thank youCode: Select all
echo "desc xi_users;" | mysql -unagiosxi -pnagios -h xxx.xxx.xxx.xxx nagiosxi
ERROR 1146 (42S02) at line 1: Table 'nagiosqldev.xi_users' doesn't exist
Code: Select all
/usr/local/nagiosxi/html/config.inc.php
/etc/php.iniNot keen on posting login credentials. Can you be more specific on what you're looking for an I will verify?tgriep wrote:Can you post the following files from your Nagios XI server so we can view the settings?ThanksCode: Select all
/usr/local/nagiosxi/html/config.inc.php /etc/php.ini
Code: Select all
echo "desc xi_users;" | mysql -u nagiosxi -pnagios -h xxx.xxx.xxx.xxx nagiosxiCode: Select all
echo "\d+ xi_users;" | psql nagiosxi nagiosxiTable "public.xi_users"
Column | Type | Modifiers | Storage | Description
----------------+------------------------+------------------------------------------------------------+----------+-------------
user_id | integer | not null default nextval('xi_users_user_id_seq'::regclass) | plain |
username | character varying(64) | not null | extended |
password | character varying(64) | not null | extended |
name | character varying(64) | | extended |
email | character varying(128) | not null | extended |
backend_ticket | character varying(128) | | extended |
enabled | smallint | not null default (1)::smallint | plain |
Indexes:
"xi_users_pkey" PRIMARY KEY, btree (user_id)
"xi_users_username_key" UNIQUE, btree (username)
Has OIDs: no
Code: Select all
/tmp/nagiosxi/upgrade.log
/usr/local/nagiosxi/tmp/upgrade.log