# mysql\_user problems

**URL:** <https://forum.ansible.com/t/mysql-user-problems/18278>\
**Category:** Ansible Project\
**Created:** [May 21, 2015, 12:21pm UTC](https://forum.ansible.com/t/mysql-user-problems/18278 "2015-05-21T12:21:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![James\_Morgan](https://avatars.discourse-cdn.com/v4/letter/j/57b2e6/32.png) [@James\_Morgan](https://forum.ansible.com/u/James_Morgan)\
**Post date:** [May 21, 2015, 12:21pm UTC](https://forum.ansible.com/t/mysql-user-problems/18278/1 "2015-05-21T12:21:48Z")

</div>

Hi,

Having problems with mysql\_user.

**ConfigParser.NoSectionError: No section: ‘client’**

I have googled it and similar issues have come up but I can’t see a fix.

This only happens in certain environments. All envs are using

Ansible - **1.9.1**  
MySQL - **5.1.73**

/etc/my.cnf has the client section

[client]  
port = 3306  
socket = /var/lib/mysql/mysql.sock

- name: Create sitebuilder MySQL user  
sudo: yes  
mysql\_user:  
name: “{{ sitebuilder\_db\_user }}”  
password: “{{ sitebuilder\_db\_password }}”  
priv: “_._:ALL,GRANT”  
host: “%”  
state: present

BECOME-SUCCESS-tdahgaeutuqqguopfedkwwxxamyfnaig  
Traceback (most recent call last):  
File “/home/obadmin/.ansible/tmp/ansible-tmp-1432210565.88-226550115643277/mysql\_user”, line 2247, in   
main()  
File “/home/obadmin/.ansible/tmp/ansible-tmp-1432210565.88-226550115643277/mysql\_user”, line 474, in main  
mycnf\_creds = load\_mycnf()  
File “/home/obadmin/.ansible/tmp/ansible-tmp-1432210565.88-226550115643277/mysql\_user”, line 408, in load\_mycnf  
passwd = config\_get(config, ‘client’, ‘password’)  
File “/home/obadmin/.ansible/tmp/ansible-tmp-1432210565.88-226550115643277/mysql\_user”, line 364, in config\_get  
return strip\_quotes(config.get(section, option))  
File “/usr/lib64/python2.6/ConfigParser.py”, line 311, in get  
raise NoSectionError(section)  
**ConfigParser.NoSectionError: No section: ‘client’**  
OpenSSH\_5.3p1, OpenSSL 1.0.1e-fips 11 Feb 2013  
debug1: Reading configuration data /home/builder/.ssh/config  
debug1: Applying options for \*  
debug1: Reading configuration data /etc/ssh/ssh\_config  
debug1: Applying options for \*  
debug1: auto-mux: Trying existing master  
debug2: fd 3 setting O\_NONBLOCK  
debug2: mux\_client\_hello\_exchange: master version 4  
debug3: mux\_client\_request\_forwards: requesting forwardings: 0 local, 0 remote  
debug3: mux\_client\_request\_session: entering  
debug3: mux\_client\_request\_alive: entering  
debug3: mux\_client\_request\_alive: done pid = 11362  
debug3: mux\_client\_request\_session: session request sent  
debug1: mux\_client\_request\_session: master session id: 2  
debug1: mux\_client\_request\_session: master session id: 2  
debug3: mux\_client\_read\_packet: read header failed: Broken pipe  
debug2: Received exit status from master 0

Any help much appreciated

J

---

<div class="post-metadata">

**Author:** ![lemaillet.efflam](https://avatars.discourse-cdn.com/v4/letter/l/f04885/32.png) [@lemaillet.efflam](https://forum.ansible.com/u/lemaillet.efflam)\
**Post date:** [July 27, 2015, 1:21pm UTC](https://forum.ansible.com/t/mysql-user-problems/18278/2 "2015-07-27T13:21:58Z")

</div>

Hi James,

I had same ssh erros recently and I didn’t find any answer on the web.  
I don’t know if it comes from the same errors but for me it was due to a privilege escalation failure.  
I don’t really understand the link with ssh error …

I hope it could help someone with this kind of error.

Was running my playbook on Red-Hat 6.6 from a Centos 6.6 with ansible 1.9.2.

Regards,

Efflam