I finally managed to install Mautic !!!
Here is information about the problem I had in my environment to help the community.
Basically being able to discover that the problem was in the process of creating the Mautic tables. To reach this understanding, I ran the following command from the Mautic console on the command line:
$> php bin/console mautic:install:data
This command recreates all the Mautic tables, to my surprise, this process took more than 40 minutes to complete. That’s when I started to analyze the MariaDB settings and arrived at this configuration in the /etc/my.cnf
file
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
query_cache_size = 64M
tmp_table_size = 64M
max_heap_table_size = 64M
performance_schema=ON
performance-schema-instrument='stage/%=ON'
performance-schema-consumer-events-stages-current=ON
performance-schema-consumer-events-stages-history=ON
performance-schema-consumer-events-stages-history-long=ON
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 16K
myisam_sort_buffer_size = 8M
thread_cache_size = 16
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
long_query_time = 1
wait_timeout = 60
# Don't listen on a TCP/IP port at all.
skip-networking
skip-name-resolve
# required unique id between 1 and 2^32 - 1
server-id = 1
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000
# InnoDB tables are now used by default
# innodb_data_home_dir = /srv/mysql
# innodb_log_group_home_dir = /srv/mysql
# All the innodb_xxx values below are the default ones:
innodb_data_file_path = ibdata1:12M:autoextend
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 2G
innodb_log_file_size = 48M
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_file_per_table = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
As the script’s execution time is very long, the page falls due to time out and we received the famous error 500.
After all the settings, I started the installation process via the browser again.
If after all these configurations, you still return error 500 (you will be YOURDOMAIN.COM/installer/step/1.1
), you must wait for the process of creating the tables to finish (check the processes running on MySQL) when finish, simply change to YOURDOMAIN.COM/installer/step/1.2
, so the installation process will continue.
Summing up:
If error 500 occurs in step 1.1:
YOURDOMAIN.COM/installer/step/1.1
After creating the tables, change to step 1.2:
YOURDOMAIN.COM/installer/step/1.2
And finish the installation.