Page 1 of 2
Manage User loads Add User page
Posted: Fri Aug 30, 2019 10:59 am
by TBT
In an attempt to modify an existing user, clicking the UID or Edit icon loads the Add User page, not the Edit User page.
This issue only affects 1 of our 9 XI servers. I've tried several browsers, cleared cache and also private session with same results. Any idea what could be causing this?
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 12:54 pm
by benjaminsmith
Hello
@TBT,
You may have invalid user id for that account or the xi_users table is corrupted. Is this happening to every user on this server only for a specific account.
To check the database tables, run the following query to check for corrupted tables (null entry):
Code: Select all
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table | grep NULL
If it's a specific user, post the output of the following query to list all usernames and id:
Code: Select all
echo "select user_id, username from nagiosxi.xi_users;" | mysql -u root -pnagiosxi nagiosxi
Can you post the output of the database log:
Code: Select all
tail -50 /var/log/mariadb/mariadb.log
Thanks.
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 1:46 pm
by TBT
benjaminsmith wrote:Hello
@TBT,
You may have invalid user id for that account or the xi_users table is corrupted. Is this happening to every user on this server only for a specific account.
To check the database tables, run the following query to check for corrupted tables (null entry):
Code: Select all
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table | grep NULL
If it's a specific user, post the output of the following query to list all usernames and id:
Code: Select all
echo "select user_id, username from nagiosxi.xi_users;" | mysql -u root -pnagiosxi nagiosxi
Can you post the output of the database log:
Code: Select all
tail -50 /var/log/mariadb/mariadb.log
Thanks.
This behavior is with all users.
Outup as requested, no nulls:
Code: Select all
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.00 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 0.00 |
| nagios_comments | 0.00 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.04 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 0.00 |
| nagios_contactnotifications | 0.00 |
| nagios_contacts | 0.00 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.01 |
| nagios_customvariablestatus | 0.01 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.00 |
| nagios_eventhandlers | 0.00 |
| nagios_externalcommands | 0.00 |
| nagios_flappinghistory | 0.00 |
| nagios_host_contactgroups | 0.00 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.00 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.00 |
| nagios_hoststatus | 0.02 |
| nagios_instances | 0.00 |
| nagios_logentries | 1.33 |
| nagios_notifications | 0.00 |
| nagios_objects | 0.03 |
| nagios_processevents | 0.01 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.00 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.00 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.01 |
| nagios_servicestatus | 0.03 |
| nagios_statehistory | 0.01 |
| nagios_systemcommands | 0.04 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.03 |
| tbl_contact | 0.01 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.01 |
| tbl_hostdependency | 0.00 |
| tbl_hostescalation | 0.00 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.01 |
| tbl_hosttemplate | 0.01 |
| tbl_info | 0.13 |
| tbl_lnkContactToCommandHost | 0.00 |
| tbl_lnkContactToCommandService | 0.00 |
| tbl_lnkContactToContactgroup | 0.00 |
| tbl_lnkContactToContacttemplate | 0.00 |
| tbl_lnkContactToVariabledefinition | 0.00 |
| tbl_lnkContactgroupToContact | 0.00 |
| tbl_lnkContactgroupToContactgroup | 0.00 |
| tbl_lnkContacttemplateToCommandHost | 0.00 |
| tbl_lnkContacttemplateToCommandService | 0.00 |
| tbl_lnkContacttemplateToContactgroup | 0.00 |
| tbl_lnkContacttemplateToContacttemplate | 0.00 |
| tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| tbl_lnkHostToContact | 0.00 |
| tbl_lnkHostToContactgroup | 0.00 |
| tbl_lnkHostToHost | 0.00 |
| tbl_lnkHostToHostgroup | 0.00 |
| tbl_lnkHostToHosttemplate | 0.00 |
| tbl_lnkHostToVariabledefinition | 0.00 |
| tbl_lnkHostdependencyToHost_DH | 0.00 |
| tbl_lnkHostdependencyToHost_H | 0.00 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| tbl_lnkHostescalationToContact | 0.00 |
| tbl_lnkHostescalationToContactgroup | 0.00 |
| tbl_lnkHostescalationToHost | 0.00 |
| tbl_lnkHostescalationToHostgroup | 0.00 |
| tbl_lnkHostgroupToHost | 0.00 |
| tbl_lnkHostgroupToHostgroup | 0.00 |
| tbl_lnkHosttemplateToContact | 0.00 |
| tbl_lnkHosttemplateToContactgroup | 0.00 |
| tbl_lnkHosttemplateToHost | 0.00 |
| tbl_lnkHosttemplateToHostgroup | 0.00 |
| tbl_lnkHosttemplateToHosttemplate | 0.00 |
| tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| tbl_lnkServiceToContact | 0.00 |
| tbl_lnkServiceToContactgroup | 0.00 |
| tbl_lnkServiceToHost | 0.00 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.00 |
| tbl_lnkServiceToVariabledefinition | 0.00 |
| tbl_lnkServicedependencyToHost_DH | 0.00 |
| tbl_lnkServicedependencyToHost_H | 0.00 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| tbl_lnkServicedependencyToService_DS | 0.00 |
| tbl_lnkServicedependencyToService_S | 0.00 |
| tbl_lnkServicedependencyToServicegroup_DS | 0.02 |
| tbl_lnkServicedependencyToServicegroup_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.00 |
| tbl_lnkServiceescalationToContactgroup | 0.00 |
| tbl_lnkServiceescalationToHost | 0.00 |
| tbl_lnkServiceescalationToHostgroup | 0.00 |
| tbl_lnkServiceescalationToService | 0.00 |
| tbl_lnkServiceescalationToServicegroup | 0.02 |
| tbl_lnkServicegroupToService | 0.00 |
| tbl_lnkServicegroupToServicegroup | 0.00 |
| tbl_lnkServicetemplateToContact | 0.00 |
| tbl_lnkServicetemplateToContactgroup | 0.00 |
| tbl_lnkServicetemplateToHost | 0.00 |
| tbl_lnkServicetemplateToHostgroup | 0.00 |
| tbl_lnkServicetemplateToServicegroup | 0.00 |
| tbl_lnkServicetemplateToServicetemplate | 0.01 |
| tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| tbl_lnkTimeperiodToTimeperiod | 0.00 |
| tbl_logbook | 0.00 |
| tbl_mainmenu | 0.00 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 0.00 |
| tbl_servicedependency | 0.00 |
| tbl_serviceescalation | 0.00 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.01 |
| tbl_servicetemplate | 0.02 |
| tbl_session | 0.00 |
| tbl_session_locks | 0.00 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.00 |
| tbl_timeperiod | 0.01 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.01 |
+--------------------------------------------+------------+
Tailing the log:
Code: Select all
8 Query INSERT INTO nagios_systemcommands SET instance_id='1', start_time=FROM_UNIXTIME(1567190668), start_time_usec='343', end_time=FROM_UNIXTIME(1567190668), end_time_usec='0', command_line='sed -i \'s/\\\\n\\t/\\t/g\' /mnt/ramdisk/service-perfdata && /bin/mv /mnt/ramdisk/service-perfdata /mnt/ramdisk/spool/xidpe/1567190668\.perfdata\.service', timeout='5', early_timeout='0', execution_time='0.004000', return_code='0', output='', long_output='' ON DUPLICATE KEY UPDATE instance_id='1', start_time=FROM_UNIXTIME(1567190668), start_time_usec='343', end_time=FROM_UNIXTIME(1567190668), end_time_usec='0', command_line='sed -i \'s/\\\\n\\t/\\t/g\' /mnt/ramdisk/service-perfdata && /bin/mv /mnt/ramdisk/service-perfdata /mnt/ramdisk/spool/xidpe/1567190668\.perfdata\.service', timeout='5', early_timeout='0', execution_time='0.004000', return_code='0', output='', long_output=''
190830 14:44:29 44 Connect [email protected] as anonymous on nagiosdev
44 Init DB nagiosdev
44 Query SET NAMES latin1
45 Connect [email protected] as anonymous on nagiosqldev
45 Init DB nagiosqldev
45 Query SET NAMES utf8
44 Change user [email protected] on nagiosdev
44 Init DB nagiosdev
44 Query SET NAMES latin1
45 Change user [email protected] on nagiosqldev
45 Init DB nagiosqldev
45 Query SET NAMES utf8
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 2:25 pm
by cdienger
Hover your mouse over the edit button and note the url that it points to. The difference between the edit and add pages is that the edit button will tack on a "user_id[]=ID" to the end of the URL. For example, edit:
Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1&user_id[]=100
add:
Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1
Is the user_id option tacked on?
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 2:29 pm
by benjaminsmith
Hi
@TBT,
I don't see any table information from the nagiosxi database.
If you go to the following page on this server, edit user, as id=1, is it able to pull up this users data? The user id auto-increments, so there should be settings for the first user account. If not, what is the error message?
Code: Select all
http://<ip-address>/nagiosxi/admin/users.php?edit=1&user_id[]=1
Next, can you download a new system profile from this server and send it over. Thanks.
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message and then
reply to this post to bring it up in the queue.
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 2:35 pm
by TBT
cdienger wrote:Hover your mouse over the edit button and note the url that it points to. The difference between the edit and add pages is that the edit button will tack on a "user_id[]=ID" to the end of the URL. For example, edit:
Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1&user_id[]=100
add:
Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1
Is the user_id option tacked on?
URL appears as:
https://w.x.y.z/nagiosxi/admin/users.ph ... r_id[]=102
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 2:38 pm
by TBT
benjaminsmith wrote:Hi
@TBT,
I don't see any table information from the nagiosxi database.
If you go to the following page on this server, edit user, as id=1, is it able to pull up this users data? The user id auto-increments, so there should be settings for the first user account. If not, what is the error message?
Code: Select all
http://<ip-address>/nagiosxi/admin/users.php?edit=1&user_id[]=1
Next, can you download a new system profile from this server and send it over. Thanks.
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message and then
reply to this post to bring it up in the queue.
No error message. It loads the Add User page with a URL of https://<ip-address>/nagiosxi/admin/users.php?edit=1&user_id[]=102
Sending the profile shortly.
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 3:28 pm
by TBT
FYI I will be out of office until Sept 16th, I'll follow-up when I return.
Thanks again,
Re: Manage User loads Add User page
Posted: Fri Aug 30, 2019 4:23 pm
by cdienger
We're going over the profile and found some odd messages regarding /usr/local/nagiosxi/html/includes/utils.inc.php and /usr/local/nagiosxi/html/admin/users.php. Please send us a copy of these as well.
Re: Manage User loads Add User page
Posted: Mon Sep 16, 2019 8:05 am
by TBT
cdienger wrote:We're going over the profile and found some odd messages regarding /usr/local/nagiosxi/html/includes/utils.inc.php and /usr/local/nagiosxi/html/admin/users.php. Please send us a copy of these as well.
The forum isn't very user friendly for sending of files, perhaps Nagios can make some phpBB configuration changes to address the following?
1. The extension php is not allowed.
2. Cannot add another attachment, 1 is the maximum.
3. You cannot make another post so soon after your last.
Regardless I've sent you a copy of the requested files, adding *.txt as the extension.