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?
Manage User loads Add User page
Manage User loads Add User page
Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Manage User loads Add User page
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):
If it's a specific user, post the output of the following query to list all usernames and id:
Can you post the output of the database log:
Thanks.
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
Code: Select all
echo "select user_id, username from nagiosxi.xi_users;" | mysql -u root -pnagiosxi nagiosxiCode: Select all
tail -50 /var/log/mariadb/mariadb.log
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Manage User loads Add User page
This behavior is with all users.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):If it's a specific user, post the output of the following query to list all usernames and id: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 NULLCan you post the output of the database log:Code: Select all
echo "select user_id, username from nagiosxi.xi_users;" | mysql -u root -pnagiosxi nagiosxiThanks.Code: Select all
tail -50 /var/log/mariadb/mariadb.log
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 |
+--------------------------------------------+------------+
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 utf8Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
Re: Manage User loads Add User page
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:
add:
Is the user_id option tacked on?
Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1&user_id[]=100Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Manage User loads Add User page
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?
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.
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
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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Manage User loads Add User page
URL appears as: https://w.x.y.z/nagiosxi/admin/users.ph ... r_id[]=102cdienger 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:
add:Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1&user_id[]=100
Is the user_id option tacked on?Code: Select all
https://w.x.y.z/nagiosxi/admin/users.php?edit=1
Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
Re: Manage User loads Add User page
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?Next, can you download a new system profile from this server and send it over. Thanks.Code: Select all
http://<ip-address>/nagiosxi/admin/users.php?edit=1&user_id[]=1
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.
Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
Re: Manage User loads Add User page
FYI I will be out of office until Sept 16th, I'll follow-up when I return.
Thanks again,
Thanks again,
Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
Re: Manage User loads Add User page
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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: Manage User loads Add User page
The forum isn't very user friendly for sending of files, perhaps Nagios can make some phpBB configuration changes to address the following?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.
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.
Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2