I deployed SuiteCRM via Ansible Playbook. When I access it via IP address and configuring the database it give me an error message (Database connection error “name” “password” etc is wrong). Here is the screenshot:
I have tried with my Server IP and also with localhost IP address etc. but not successful.
this is my playbook:
hosts: all
gather_facts: false
become: yes
vars:
ansible_host: “{{ HOSTIP }}”
ansible_port: “{{ HOSTPORT }}”
ansible_user: student #ansible_ssh_pass: student
tasks:
name: Wait 300 seconds, but only start checking after 60 seconds
wait_for_connection:
timeout: 3
name: Enable .htaccess
blockinfile:
path: /etc/apache2/sites-available/000-default.conf
insertafter: ‘DocumentRoot’
block: |
<Directory “/var/www/html/public”>
AllowOverride All
Order Allow,Deny
Allow from All
name: Start Apache2 if not started
ansible.builtin.service:
name: apache2
state: restarted
name: Allow root to access from 127.0.0.1
community.mysql.mysql_user:
login_unix_socket: /var/run/mysqld/mysqld.sock
name: student
host: 127.0.0.1
priv: ‘.:ALL,GRANT’
name: Start MariaDB
ansible.builtin.service:
name: mysql
state: started
name: Set output attributes
set_stats:
data:
app_endpoint: “http://{{ HOSTIP }}/”
I tried MariaDB Username. I didn’t specified any MariaDB password. I tried admin, root, and random etc. By defaul xampp mariadb server password is blank, no password.
Of course, these names will be different for different PHP versions. Note that there is a MySQL module there - without that one you won’t be able to reach the database.
Another tip: instead of doing guess work about what could be wrong, keep an eye on both your logs, there are specific error messages pointing you to the issues.
@vijay1992@Mac-Rae I resolved the database errors. now when I proceed, it doesn’t show anything , just few seconds searching and again the same window. however, i set the values like these
max_execution_time = xx ← try putting 3000
max_input_time = xx ← 3000
max_input_vars = xx <— 10000
memory_limit = xx <— 500M
upload_max_filesize = xx ← 256M