create-mysqldb-and-user-using-plesk-api
Ansible Role: Create a new mysql database and user using PLESK API
Creates a new database user and database in Plesk.
Requirements
- a server running plesk
- this role requires admin access for plesk
- lxml >= 2.3.0
Role Variables
Required variables are listed below and can be set with values (see vars/main.yml
):
host_url: <your-strato-server-id>.stratoserver.net
host_port: 8443
dbname: "dbmydomain"
dbuser: "dbuser"
dbpw: "secure-db-pw"
plesk_admin_user: "admin"
plesk_admin_pw: "secure-admin-pw"
Available variables are listed below, along with default values (see defaults/main.yml
):
webspace_id: 1
dbtype: "mysql"
Dependencies
None.
Example Playbook
- hosts: strato-server
become: yes
vars_files:
- vars/main.yml
roles:
- { role: ansible.role.create-mysqldb-and-user-using-plesk-api }
Inside vars/main.yml
:
host_url: <your-strato-server-id>.stratoserver.net
host_port: 8443
dbname: "dbmydomain"
dbuser: "dbuser"
dbpw: "secure-db-pw"
plesk_admin_user: "admin"
plesk_admin_pw: "secure-admin-pw"
Authors
This role was created in 2018 by Sergej Kukshausen and Susann Sgorzaly.