Changing Passwords

This section describes how to:

Change every administrator password used in SL1.

Appliances installed as an AWS EC2 instance have the "root" operating system account disabled by default. During the setup process, the user "ec2-user" is automatically added to the operating system configuration. The ec2-user account can be used to perform administrative tasks that require SSH command-line access. The ec2-user account is permitted to perform all operating system commands using the "sudo" command without a password.

Use the following menu options to navigate the SL1 user interface:

To view a pop-out list of menu options, click the menu icon ().
To view a page containing all the menu options, click the Advanced menu icon ().

This section includes the following topics:

Disabling phpMyAdmin

The phpMyAdmin interface provides a web interface for viewing and managing MySQL databases. By default, you can log in to the Database Server using the phpMyAdmin interface to view and manage the MySQL databases on all Database Servers, Data Collectors, and Message Collectors in the system.

To disable phpMyAdmin, you must disable the service and then disable the ports on which the service runs. To do this:

If you are using a distributed system, either go to the console of the Database Server or use SSH to access the Database Server. Open a shell session on the server. Log in as an administrator.
If you are using an All-In-One Appliance, either go to the console of the All-In-One Appliance or use SSH to access the All-In-One Appliance. Open a shell session on the server. Log in as an administrator.

NOTE: For details on enabling and using SSH, see the manual System Administration. For details and warnings about root access and instructions on how to make root access secure, see the manual System Administration.

Edit the file /etc/siteconfig/firewalld-rich-rules.siteconfig:
```
sudo vifirewalld
```

Add the following lines:

rule service name="phpmyadmin" reject\
rule port port="8008" protocol="tcp" reject

Save your changes and exit the file (:wq).

Changing the Password for the Default Account for the User Interface

To change the password for the default em7admin user account, which can be used to access the user interface, perform the following steps:

Go to the User Accounts page (Registry > Accounts > User Accounts).

Click the wrench icon () for the em7admin user. The Account Permissions page appears.

Enter the new password in the Change Password field.
Re-type the new password in the Confirm Password field.
Click the Save button. A pop-up window appears, asking you to confirm the change.
Click "OK" in the pop-up window. The message "Password Saved" is displayed.

Changing the Password for the Default Console User

To change the password for the default administrative user em7admin for console logins and SSH access:

Either go to the console of the SL1 appliance or use SSH to access the server.
Log in as user em7admin with the appropriate password. The default password is em7admin.
At the shell prompt, type the following:

passwd
When prompted, type and re-type the new password.

Changing the Password for the Web Configuration Utility

You can change the password for the Web Configuration Utility.

NOTE: If you want to change the password for the Web Configuration Utility on all SL1 appliances, you must log in to the Web Configuration Utility on each appliance and perform the steps in this section.

NOTE: You cannot change the username for the Web Configuration Utility. The username remains em7admin.

To change the password for the Web Configuration Utility:

Click the Device Settings button. The Settings page appears.

In the Settings page, type the following:

Web Config Password (change only). Type the new password.
Confirm Web Config Password. Type the new password again.

Click Save
Perform steps 1-4 for each appliance for which you want to change the password for the Web Configuration Utility.

Changing Database Passwords

The following SL1 appliances include a database instance:

All-In-One Appliances
Database Servers
Data Collectors
Message Collectors

By default, SL1 appliances use the following user accounts to access appliance databases:

ap_user. This user is used by the user interface to access the database on a Database Server or All-In-One Appliance. This user account exists only on the Administration Portal and does not exist by default on Data Collectors and Message Collectors. By default, this user has the user name apuser and the password apuser.
dbuser. This user is used by ScienceLogic platform processes to access the database instance on all appliances. By default, this user has the user name root.

To change the password for the ap_user account, you must:

Configure a new password for the Administration Portal using the Web Configuration Utility for the Administration Portal.

To change the password for these dbuser account, you must:

Configure a new password in the database instance.
Configure SL1 to use the new password.

Exercise caution when manipulating MySQL user accounts. Do not use these procedures unless you are confident and know how to undo changes, should something go wrong.

Configuring a New Password on Collector Appliances

Perform the following steps to change the password for a user on a Collector:

Either go to the console of the Database Server, All-In-One Appliance, Data Collector, or Message Collector or use SSH to access the server in CLI mode.
Log in as em7admin with the appropriate password.
Run the following command to launch the MySQL prompt:
```
silo_mysql
```
From the MySQL prompt, change the root password by running the following SQL query:
```
MariaDB [(none)]> SET PASSWORD FOR 'root' = PASSWORD('new_password');
```
To effect the change immediately, run the following SQL query:
```
MariaDB [(none)]> FLUSH PRIVILEGES;
```
Ensure you can access the database with the new password. Exit the MySQL interface, and test by running the following command, entering the new password when prompted:
```
mysql -u root -p
```
Edit the /etc/silo.conf file and change the dbpasswd variable to the new password. See Editing Silo.Conf for assistance.
From the SL1 interface, go to the Appliances page (System > Settings > Appliances) and retrieve the appliance ID for the Collector.
Go to the DB Tool page (System > Tools > DB Tool), and enter the following query to allow the Database Appliance to access the MySQL database of the Collector:
```
UPDATE master.system_settings_licenses SET db_pass='{new password}' WHERE id={appliance ID} LIMIT 1;
```
Confirm in the Collector Status page (System > Monitor > Collector Status) that the Collector is available.

Editing Silo.Conf

Either go to the console of the SL1 appliance or use SSH to access the SL1 appliance.
Open a shell session on the server.
Type the following at the command line:

sudo visilo
Edit the value assigned to dbuser and to ap_user. Assign the value you defined in the section Configuring a New Password in the Database Instance.
Save and close the file (:wq).

Updating the master.system_settings_licenses Table

To update the master.system_settings_licenses table after you have changed the root password on a Data Collector or Message Collector:

Go to the Appliance Manager page (System > Settings > Appliances).

Locate the Data Collector or Message Collector in the list of appliances. Note the value in the ID column for the Data Collector or Message Collector.
Go to the Database Tool page (System > Tools > DB Tool).
Enter the following in the SQL Query field, replacing <new password> with the new password and <ID value of Collector> with the value you noted in step 2:

UPDATE master.system_settings_licenses SET db_user='root', db_pass=<new password> WHERE id=<ID value of Collector>;

If you want to update all Data Collectors and Message Collectors with the same password, enter the following in the SQL Query field, replacing <new password> with the new password:

UPDATE master.system_settings_licenses SET db_user='root', db_pass='<new password>' WHERE function in (5,6);
Click the Go button.

Changing the MySQL Root Password on Database Appliances

To change the MySQL root password on database appliances:

Either go to the console of the Database Server or use SSH to access the server in CLI mode.
Log in as em7admin with the appropriate password.

If your Database Appliances are part of an HA cluster, place your HA cluster in maintenance mode using the steps found in the section on Disaster Recovery with Two Appliances .
Run the following command to launch the MySQL prompt:
```
silo_mysql
```
From the MySQL prompt, change the root password by running the following SQL query:
```
MariaDB [(none)]> SET PASSWORD FOR 'root' = PASSWORD('new_password');
```
To effect this change immediately, run the following SQL query. Enter the new password when prompted.
```
MariaDB [(none)]> FLUSH PRIVILEGES;
```
Ensure you can access the database with the new password. Exit the MySQL interface, and test by running the following command, entering the new password when prompted:
```
mysql -u root -p
```
Edit the silo.conf file, as described in Editing Silo.Conf. Change the dbpasswd variable to the new password in both the [LOCAL] and [CENTRAL] sections.

If you have clustered database appliances, be sure to update the silo.conf file for all cluster members.
If you have admin portals, update the dbpasswd variable in silo.conf on all admin portals.
If the Data Collector's MySQL root user password is now different from the MySQL root user password on the Database Server, and the db_pass column in master.system_settings_licenses is "NULL", then the Database Server will attempt to use its own password to connect.
Change the db_pass column for the collectors to their root MySQL user password using the instructions in Updating the master.system_settings_licenses Table.
If you placed an HA cluster into maintenance mode to perform these steps, remember to return it to ready mode by setting coro_config to option 1. For more information, see the section on Disaster Recovery with Two Appliances .

Recovering the Root MySQL Password

To reset the root MySQL password if you become locked out:

Either go to the console of the Database Server or use SSH to access the server in CLI mode.
Log in as em7admin with the appropriate password.
Stop the em7 and mariadb services:
```
systemctl stop em7 mariadb
```

Start the mariadb service with the "--skip-grant-tables' option:

systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mariadb

Access the MySQL database:
```
mysql -u root mysql
```

Reset the root password from the MySQL prompt:

UPDATE user SET password=PASSWORD('{new password}') WHERE User='root';

Stop the mariadb service again, unset the environment variable, and restart the service, using the following sequence of commands:
```
systemctl stop mariadb
systemctl unset-environment MYSQLD_OPTS
systemctl start mariadb
```
Ensure that you can access the MySQL database with the new password:
```
mysql -u root -p
```
Restart the em7 service:
```
systemctl start em7
```
Ensure that the password you set is also updated in the /etc/silo.conf dbpasswd variable. For more information, see Changing the MySQL Root Password on Database Appliances

Recovering the MySQL SNMP User Account on Data Collector

If you have removed the SNMP user account from the Data Collector's MySQL database in an attempt to harden your system, you must recover the account so that SL1 can insert incoming SNMP traps into the database for processing.

To restore the SNMP user account:

Either go to the console of the Database Server or use SSH to access the server in CLI mode.
Log in as em7admin with the appropriate password.

Run the following command to restore the SNMP user account:

/opt/em7/share/scripts/em7_firstboot.d/30_trap_listener-db_init.sh