I just stuck in the second page of the installation.
My site on azure and I created a webapp with mysql database, on the second page of the installation it requiers the database details. I gave all the details but its giving me the below error.
Database cannot be found or created due to permissions restrictions.
is there any answer to how to give the needed permissions to the mautic
thank you very much in advance
I just stuck in the second page of the installation.
My site on azure and I created a webapp with mysql database, on the second page of the installation it requiers the database details. I gave all the details but its giving me the below error.
Database cannot be found or created due to permissions restrictions.
is there any answer to how to give the needed permissions to the mautic
thank you very much in advance
Don’t use Azure, but I have to assume you can setup the database name, user id, password, and permissions. I do this from the command line:
mysql -uroot -p
CREATE DATABASE mauticdb;
CREATE USER 'mauticuser'@'localhost' IDENTIFIED BY 'hahanoway';
GRANT ALL PRIVILEGES ON *.* TO 'mauticuser'@'localhost';
FLUSH PRIVILEGES;
A short guide for installing Mautic 2.8.1 on Ubunti 16.04 TLS:
#-- goats
If any of this is greek to you, get a free account at mautic.com.
This is very terse tutorial for installing and configuring
Mautic 2.8.1 on fresh install of Ubuntu 16.04 LTS for testing
purposes only. Includes very basic instructions for installing the
basic packages to get Mautic running. Apache, MariaDB/MySQL, plus
a certificate from letsencrypt for Apache. Modify to fit your
specific installation and use at your own risk.
Expectations
1. NOTE: this guide assumes you can ssh to the box and have experince on
the UNIX command line, otherwise visit mautic.com and get a free account.
2. a static IP is setup with DNS configured with A, PTR, and MX
records. A firewall with ports 80 and 25 open.
3. install Ubuntu 16.04 LTS
For a test system, a 10G partition is acceptable. SSD is preferred.
Install as you see fit except the following needs to be selected:
- Install LAMP Server
- Install Mail Server
- Install standard system utilities
- Install OpenSSH Server
4. during the install, set:
- manual IP, netmask, gateway, and DNS server
- Postfix as it resides on an "internet site"
- The MySQL database root user password
5. login and update the OS
apt-get -y update
apt-get -y upgrade
apt-get -y dist-upgrade
6. install php, apache2 and various modules needed
apt-get -y install php libapache2-mod-php php-mbstring php-curl php-zip php-gd php-mysql php-mcrypt php-xml php-intl php-imap unzip
7. edit php.ini
vi /etc/php/7.0/apache2/php.ini
upload_max_filesize = 64M
max_input_vars = 4000
max_execution_time = 120
memory_limit = 256M
date.timezone = America/Chicago
8. settings for the default site
a2enmod headers
9. create a default setup for Apache, edit this file:
vi /etc/apache2/sites-enabled/000-default.conf
10. then add the following under <VirtualHost *:80>
ServerName host.domain.com
Header set Access-Control-Allow-Origin: http://domain.com
Header set Access-Control-Allow-Headers "Origin, X-Requested-With, Content-Type, Accept"
Header set Access-Control-Allow-Credentials: true
<IfModule dir_module>
DirectoryIndex index.php index.html
</IfModule>
11. now use letsencrypt to create a secure Apache
add-apt-repository ppa:certbot/certbot
apt-get update
apt-get install python-certbot-apache
# good luck with this command
certbot --apache
# restart apache2
systemctl start apache2
systemctl enable apache2
systemctl status apache2
11. create database and setup user id, password, hostname, and permissions
mysql_secure_installation
systemctl status mysql
mysql -uroot -p
CREATE DATABASE mauticdb;
CREATE USER 'mauticuser'@'localhost' IDENTIFIED BY 'hahanoway';
GRANT ALL PRIVILEGES ON *.* TO 'mauticuser'@'localhost';
FLUSH PRIVILEGES;
12. download Mautic to /var/www/html, unzip, and then setup
permissions:
cd /var/www/html
unzip 2.8.1.zip
chown -R www-data:www-data . .htaccess .php_cs
13. # with your browser, finish setup:
https://host.domain.com
14. # add cron jobs and log output to /tmp
crontab -e
0,15,30,45 * * * * /path/to/php /home/path/to/app/console mautic:broadcasts:send >/dev/null 2>&1 >> /tmp/mautic:broadcasts:send.log
1,16,31,46 * * * * /path/to/php /home/path/to/app/console mautic:segments:update >/dev/null 2>&1 >> /tmp/mautic:segments:update.log
2,17,32,47 * * * * /path/to/php /home/path/to/app/console mautic:campaigns:rebuild >/dev/null 2>&1 >> /tmp/mautic:campaigns:rebuild.log
3,18,33,48 * * * * /path/to/php /home/path/to/app/console mautic:campaigns:trigger >/dev/null 2>&1 >> /tmp/mautic:campaigns:trigger.log
4,19,34,49 * * * * /path/to/php /home/path/to/app/console mautic:emails:send >/dev/null 2>&1 >> /tmp/mautic:emails:send.log
5,20,35,50 * * * * /path/to/php /home/path/to/app/console mautic:emails:fetch >/dev/null 2>&1 >> /tmp/mautic:emails:fetch.log
6,21,36,51 * * * * /path/to/php /home/path/to/app/console mautic:iplookup:download >/dev/null 2>&1 >> /tmp/mautic:iplookup:download.log
#7,22,37,52 * * * * /path/to/php /home/path/to/app/console mautic:integration:fetchleads --integration=Hubspot >/dev/null 2>&1 >> mautic:integration:fetchleads #fuck hubspot
#8,23,38,53 * * * * /path/to/php /home/path/to/app/console mautic:integration:pushleadactivity --integration=Hubspot >/dev/null 2>&1
9,24,39,54 * * * * /path/to/php /home/path/to/app/console mautic:social:monitoring >/dev/null 2>&1 >> /tmp/mautic:social:monitoring.log