Change Passwords

This section allows you to change and encrypt passwords. To access this section, select 3 Change Passwords from the main menu. The Passwords menu is displayed:

Passwords

1 Change Unix password

2 Change MySQL instance password

3 Change MySQL root password

4 Change Solr password for a specific instance (only by sfxglb41

5 Generate encrypted password for use in configuration files

6 Set Solr shared instance password (only by sfxglb41)

7 Store MySQL root password in encrypted form in configuration file

Please select [1-7,q,m]:

Change UNIX Password

This option allows you to change the UNIX passwords of the SFX instance users.

Change MySQL Instance Password

The MySQL user is necessary to access the SFX databases and perform various activities, such as running commands in the database, running the KnowledgeBase update, and executing statistic queries. The database of each SFX instance can be accessed by a separate MySQL user with a separate user name and password. There is also a MySQL root user that is used to administer the MySQL server.

Option 2Change MySQL instance password allows you to change any MySQL password. It makes internal changes in the following file:

/exlibris/sfx_ver/sfx4_1/<instance>/config/ctx_login.config

Note that the password string stored in this file is an encrypted version of the actual password. Before SP 4.3.1, the encryption method used was Fidelis. From 4.3.1 onwards, any MySQL password change automatically uses AES encryption instead of Fidelis when storing password data. In the example below, the MySQL password is changed for the sfxlcl41 instance.

After selecting Option 2Change MySQL instance password, the following is displayed:

The MySQL root password is required to change MySQL user passwords.

Please enter the MySQL root password:

Type the MySQL root password (not to be confused with the UNIX root password). The program prompts you to type your new password and to re-type it.

New password for sfxlcl41:

Confirm password for sfxlcl41:

The MySQL passwords must contain only alphanumeric characters.

Change MySQL Root Password

Option 3 Change MySQL Root Password allows you to change the MySQL root password. The following screen is displayed:

The MySQL root password is required to change MySQL user passwords.

Please enter the MySQL root password:

New Password for root:

Confirm password for root:

Type the MySQL root password (not to be confused with the UNIX root password). The program prompts you to type the new root password and to re-type it.

If you change the MySQL root password, specify the new password in encrypted form in the backup configuration file of your SFX installation. Refer to the Backup Package Guide for information on installing and configuring the backup. In the bk_param.conf file, change the SFX_RT parameter. This parameter contains the SFX MySQL root password in encrypted format. To find the encrypted version of the MySQL root password:

Type da.
Type ./server_admin_util.
Select 3 Change passwords and then 5 Generate encrypted password for use in configuration files.
Enter a password to encrypt.
Copy and paste the string returned into the backup configuration file bk_param.conf.

Perform the encryption from the Server Admin Utility and save the result in exlibris/backup/conf/bkp_param.conf

Change Solr Password for a Specific Instance (Only By sfxglb41)

The eBook Search uses a dedicated Solr index. Within the Solr index, each instance (both local and global) has its own Solr core, with a corresponding user name (identical to the instance name) and password. This option allows you to change the Solr password. The following is an example of this option:

Please enter sfxglb41 password

Password:

Please enter UNIX user name of the instance: SST05

Please enter current Solr password:

New password for Solr:

Confirm password for Solr:

Updating local file. Please use SST05's instance UNIX password.

Please enter SST05 password

Password:

Starting update Solr password for local instance

Done!

A Solr restart is required after you change the Solr password.

Generate Encrypted Passwords for Use in Configuration Files

This option generates an encrypted password for configuration files, such as those relating to MARCIt!, MetaLib, sfx_crm.config, and any other file where password encryption is required.

The following is an example of this option. (Bold text is typed by the user):

5 Generate encrypted password for use in configuration files

Please select [1-4,q,m]: 4

Please enter password to encrypt:****** <password, no output visible>[Enter]

Confirm password:******<password, no output visible>[Enter]

The encrypted password is:

672617b7268733535303236303

Set Solr Shared Instance Password (only by sfxglb41)

If you have set up Consortia Model 2 (consortia API) in the SFX instance, where the shared and local instance do not exist in the same SFX installation and you changed the password in the shared installation, use this option to change the password also in the SFX installation of the local instances. Set the shared instance Solr password to be identical to the Solr password in the local instance, or the index build in the shared instance fails.

Store MySQL Root Password in Encrypted Form in Configuration File

This option stores the MySQL root password in encrypted form in the configuration file. This allows the mysql_upgrade command to be run automatically during MariaDB upgrades. If a password was already stored in the MySQL root password configuration file, it is overwritten by the new password you provide.