I am trying to install Bahmni using the bahmni -i local install. However, it fails always while connecting to mysql db. I am able to connect to mysql using command line but it is not able to connect whic installation script. Getting the below error:
TASK [mysql-users : ensure anonymous users are not in the database] ************
task path: /opt/bahmni-installer/bahmni-playbooks/roles/mysql-users/tasks/main.yml:1
fatal: [localhost]: FAILED! => {“changed”: false, “failed”: true, “msg”: “unable to connect to database, check login_user and login_******** are correct or /root/.my.cnf has the credentials. Exception message: (1045, "Access denied for user ‘root’@‘localhost’ (using ********: YES)")”}
Can you please let me know where the password should be set for the install?
I am aloso getting Same Error ,in installation of bhamni
PLAY [bahmni-emr-db] ***********************************************************
TASK [mysql-users : ensure anonymous users are not in the database] ************
task path: /opt/bahmni-installer/bahmni-playbooks/roles/mysql-users/tasks/main.yml:1fatal: [localhost]: FAILED! => {"changed": false, "failed": true, "msg":unable to connect to database, check login_user and login_******** are correct or /root/.my.cnf has the credentials. Exception message: (1045, \"Access denied for user 'root'@'localhost' (using ********: YES)\")"}
to retry, use: --limit @/opt/bahmni-installer/bahmni-playbooks/all.retry
PLAY RECAP ******************************************************************localhost : ok=63 changed=21 unreachable=0 failed=1
Traceback (most recent call last):
File "/usr/bin/bahmni", line 9, in <module>
load_entry_point('bahmni==0.1', 'console_scripts', 'bahmni')()
File "/usr/lib/python2.6/site-packages/click/core.py", line 722, in __call__
return self.main(*args, **kwargs)
File "/usr/lib/python2.6/site-packages/click/core.py", line 697, in main
rv = self.invoke(ctx)
File "/usr/lib/python2.6/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/lib/python2.6/site-packages/click/core.py", line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/lib/python2.6/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/usr/lib/python2.6/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "build/bdist.linux-x86_64/egg/bahmni.py", line 91, in install
File "/usr/lib64/python2.6/subprocess.py", line 505, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command 'ansible-playbook -i /etc/bahmni-installer/local all.yml -vv --extra-vars '@/etc/bahmni-installer/rpm_versions.yml' --extra-vars '@/etc/bahmni-backrest.conf' --extra-vars '@/etc/bahmni-installer/setup.yml'' returned non-zero exit status 2
how to reslove this problem in CentOS server Mysql database password is different .