MySQL Users not Preserved on Query Server after an Upgrade from HLRR 4.0 to 4.1

Asset ID:	1-72-2323197.1
Update Date:	2017-11-02
Keywords:

Solution Type Problem Resolution Sure

Solution 2323197.1 : MySQL Users not Preserved on Query Server after an Upgrade from HLRR 4.0 to 4.1

Applies to:

Tekelec HLR Router - Version HLRR 4.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading from HLRR v4.0, the customer configured users that access the Query Server mysql DB will not be able to login (access denied)

Cause

The upgrade cleans up the Mysql database before re-initializing it with the new schema. The upgrade recreates the qsuser, qsadmin, etc. users after the upgrade. But it doesn't retain the other mysql users (configured by hand). The non-standard mysql user settings (not included in the HLRR product) are not persistent and are lost over the upgrade.

Solution

Prior to upgrading the HLRR Query Server, gather the Imysql version, and current users list.

Check the Imysql version:

# Imysqld -V

Check the current users (logged-in) :

# Imysql.admin proc stat

Check the current users (configured). As 'root' user:

# Imysql.client -uroot -p<Imysql_root_password>

To check the configured users once logged in as root.

> select User, Host from user;
> exit

Visit the on-line Customer Documentation: https://docs.oracle.com/cd/E76437_01/docs.41/AdminGuide/EAGLE_XG_HLR_Router_Admin_Guide_4_1.html

HLR Router Administration > Query Server > Creating a new user with Query Server access

Note: Replace mysql with Imysql, whenever seen on the procedure.

Recreate the users.

References

https://docs.oracle.com/cd/E76437_01/docs.41/AdminGuide/EAGLE_XG_HLR_Router_Admin_Guide_4_1.html

Attachments

This solution has no attachment