Mautic Community Forums

Couldn't pass the Database setup page


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