Unable To Run Imysql command to Auditing DB Between HLRR And SDS

Asset ID:	1-71-2314713.1
Update Date:	2017-10-05
Keywords:

Solution Type Technical Instruction Sure

Solution 2314713.1 : Unable To Run Imysql command to Auditing DB Between HLRR And SDS

Applies to:

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

Goal

Why does Imysql command give unexpected output:

[root@SERVER]# Imysql -s -q -r -e "select imsi,service from exhr.Imsi left join exhr.Service on exhr.Imsi.serviceId=exhr.Service.id" > ImsiRec
ERROR 1045 (28000): Access denied for user 'awadmin'@'localhost' (using password: NO)
[root@ELSSTXHLRRNOAM01A hlrExport]#

[admusr@SERVER]$ Imysql -s -q -r -e "select imsi,service from exhr.Imsi left join exhr.Service on exhr.Imsi.serviceId=exhr.Service.id" > ImsiRec
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Solution

In later releases mysql database is accessed with the front end of "Imysql.client" instead of just "Imysql".

For example, notice how the Imysql command gives the same error when run on a later release (i.e., DSR 8.0):

[root@Server]# Imysql
ERROR 1045 (28000): Access denied for user 'awadmin'@'localhost' (using password: NO)
[root@cirrus-sds-NO-A ~]#

However when Imysql.client is used access is granted and the mysql prompt is provided:

[root@Server]# Imysql.client
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 766715
Server version: 5.7.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

Customer confirmed that running command with Imysql.client addressed the issue.

Attachments

This solution has no attachment