Cài đặt với Ubuntu

Pass Mariadb

Bacai@2020

CREATE DATABASE mauticbacai;

CREATE USER 'mauticbke'@'localhost' IDENTIFIED BY 'Bacai@2020';

ALTER USER 'mauticuser'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('Bacai@2020');

GRANT ALL ON mauticbacai.* TO 'mauticbke'@'localhost' IDENTIFIED BY 'Bacai@2020' WITH GRANT OPTION;

<VirtualHost *:80>
     ServerAdmin [email protected]
     DocumentRoot /var/www/html/mautic
     ServerName truongbacai.edu.vn
     ServerAlias www.truongbacai.edu.vn

     <Directory /var/www/html/mautic/>
        Options +FollowSymlinks
        AllowOverride All
        Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/error.log
     CustomLog ${APACHE_LOG_DIR}/access.log combined

</VirtualHost>

LỖI

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/2ccb8cbb-1357-41fa-8cfe-426e7093f1e0/Untitled.png

cmod hoặc restart lại apache

sudo systemctl restart apache2.service

Lỗi khi cài

An error occurred while attempting to add default data: An exception occurred while executing 'CREATE INDEX instagram_search ON leads (instagram)': SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

Nâng cấp mariadb version

https://websiteforstudents.com/upgrading-mariadb-from-10-0-to-10-1-to-10-2-on-ubuntu-16-04-17-10/

Enable HTTPS with certbot

It’s important to enable secure connections to the users connecting to Mautic from a browser, Certbot is about the simplest way to enable SSL on your server.