Questions tagged [ansible]
8 questions
18
votes
5 answers
Ansible: How to change MySQL server root password by reprovisioning the server
I have provisioned my server with Ansible playbook. I've used the root/bedrock-Ansible playbook.
One of the tasks was to set up mysql server together with mysql root user password.
Now I urgently need to change this password. The steps I took:
I…
luqo33
- 285
- 1
- 2
- 5
1
vote
1 answer
How can I pass these Information to Ansible variable?
I sign-up on this site to ask an question.
How can I pass those master status information especially File and Position to an Ansible variable, to automate the processess of replication with an Ansible playbook.
I want to write this variables in my…
DRAKON
- 21
- 2
1
vote
1 answer
What's the best way to deploy changes to several databases on multiple Postgresql Databases servers
I was wondering if there is a better way to deploy changes to several Postgres databases on multiple servers. I have been using Ansible for this task, I have a playbook that basically copies the changes to the server, applies them to the databases,…
Javier Galarza
- 81
- 1
- 1
- 7
1
vote
1 answer
MariaDB root password change using Ansible
I had tried to change MariaDB root password using following Ansible script.
- name: Dump MySQL root Password
debug:
msg: "MySQL new Password : {{ mysql_pass }}"
- name: Set MySQL root Password
become: True
…
Sachith Muhandiram
- 111
- 5
0
votes
1 answer
Automating upgrades with Ansible, fighting with APT auto-starting Cassandra service
I'm preparing to upgrade nodes from 3.11.17 to 4.1.7. I've done the upgrade successfully by hand with some dev nodes, but I am wanting to make this more repeatable with Ansible. I am running on Ubuntu servers, so I have to fight with apt auto…
stratacast1
- 33
- 4
0
votes
2 answers
msg: Cannot execute SQL 'COPY "my_table" FROM '/path/big_file.csv': ERROR: Could not extend file "base/A/B": only C bytes of D written in block E
I am running an ansible playbook. The machine running ansible is localhost.
The playbook breaks during a task which loads data from a big csv (1.2 GB) into a postgres database table ( module community.postgresql.postgresql_copy
).
The task (running…
Tms91
- 101
- 1
- 6
0
votes
1 answer
How to install PostgreSQL with special version by Ansible role?
I use the ansible role installed PostgreSQL. Its default version is 10.6. How to set another version to install? Such as 12.4.
$ psql --version
psql (PostgreSQL) 10.6
Miantian
- 177
- 1
- 3
- 9
0
votes
1 answer
How to create database by Ansible with PostgreSQL?
Use this task to create a database on CentOS by Ansible
- name: Create mydb database
command: createdb -E UNICODE -l en_US.UTF-8 -T template0 mydb -O mydbuser
become_user: postgres
It will pending. Output:
TASK [db_primary : Create mydb…
rawmain
- 359
- 1
- 9
- 20