Article ID: 129745, created on Oct 29, 2016, last review on Oct 29, 2016

  • Applies to:
  • Operations Automation 6.0
  • Operations Automation 5.5

Symptoms

MySQL DB related task fails with the following error:

Can't connect to MySQL database service on XX.XX.XX.XX:XXXX. Service specific error message: Can't initialize character set latin1 (path: /usr/share/mysql/charsets/).

Cause

MySQL Service Controller misconfiguration on MN.

Resolution

  1. Set default-character-set variable value to latin1 in my.cnf file:

    [root@osscore ~]# cat /etc/my.cnf
    ...
    [client]
    default-character-set=latin1
    
  2. Restart PEM and PAU services:

    [root@osscore ~]# service pem stop
    [root@osscore ~]# service pau stop
    [root@osscore ~]# service pau start
    [root@osscore ~]# service pem start
    

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF