Kafa PHP da Maria DB don girka Mautic akan Ubuntu 20.04

Kafa PHP da MariaDB

Wani lokaci da suka wuce mun kasance muna rubutu jerin makaloli kan yadda ake girkawa Mautic, ingantaccen aikin sarrafa kayan talla. Kodayake yanayin daidaitawar yana da ɗan wahala, amma daga ƙarshe sai ya kawo ƙarshen biyan kuɗi cikin sassauƙa da farashi don biyan bukatun masu juzu'i kamar Hubspot.

Kafa php da Maria DB

Mataki na gaba da ya kamata mu yi (duk da cewa a cikin taken na sanya su a cikin tsari na baya) shine tsarin bayanan bayanai.

sudo mysql -u root

Kuna iya canza tushen mai amfani da kuke so. A cikin taga da yake buɗewa
CREATE DATABASE mautic DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
A layin da ke biye, canza kalmar kalmar sirri ta hanyar kalmar sirri da kuka fi so.
GRANT ALL ON mautic.* TO 'root'@'localhost' IDENTIFIED BY 'contraseña';
FLUSH PRIVILEGES;
EXIT;

Tunda rumbunan adana bayanai suna daga cikin abubuwan da aka fi so na cin zarafin mutane, dole ne mu dauki wasu matakan tsaro. Muna yin hakan ta hanyar ƙaddamar da rubutu tare da wannan umarnin:
sudo mysql_secure_installation
Za mu ga masu zuwa:

Shigar da kalmar sirri na yanzu don tushen (shigar da babu):

Saka kalmar sirri da ka zaba a cikin tsarin bayanan bayanan sannan ka shiga Shigar

Canja kalmar sirri na tushen? [Y / n]

Latsa N don barin kalmar wucewa ta yanzu.

Cire masu amfani marasa amfani? [Y / n]

Latsa Y don cire masu amfani da ba a san su ba.

Disallow tushen shiga mugun? [Y / n]

Latsa Y don dakatar da samun damar nesa.

Cire bayanan gwaji da samun damar hakan? [Y / n] da

Latsa Y don share bayanan gwajin da kuma damar sa (Na san bashi da yawa, amma ga yadda rubutu ya bayyana)

Sake saitin gatan kyauta a yanzu? [Y / n]

Latsa Y don sabunta gata

Kafa PHP

Idan ka fara mayen shigarwa na Mautic, zai nuna maka kurakurai guda uku:

  • Lokacin lokaci ba'a saita shi ba.
  • Limitarancin ƙwaƙwalwar ajiya.
  • Gidan yanar gizon ba shi da takardar shaidar tsaro.

Mun warware farkon biyun ta hanyar gyaggyara abubuwa a cikin fayil ɗin php.ini

sudo nano /etc/php/7.4/apache2/php.ini

Tare da CTRL + W muke bincika

kwanan wata.zuwa lokaci =

Lokacin da nayi maki wannan layin

; kwanan wata.timezone = "UTC"

Cire semicolon kuma maye gurbin UTC tare da yankinku na lokaci. Za'a iya samun jerin yankuna masu tallafi a nan

Tare da CTRL + W muna neman wannan layin

; cgi.fix_pathinfo = 1

Canja 1 de 0 kuma share semicolon.

Don gamawa, sake danna CTRL + W kuma bincika

memory_limit

Saka darajar a cikin 512. Idan akwai semicolon, share shi.
Ajiye tare da CTRL + W

Samun takardar shaidar tsaro

Masu bincike suna da tsauri kan tsaro, sa'a, za mu iya samun damar takardar sheda kyauta don tabbatar da cewa rukunin yanar gizonmu halal ne. Dogaro da tsarin mai ba da sabis ɗinku ana iya yin hakan ta atomatik ko kuma ta atomatik.

Ana ajiye maɓalli ta atomatik a kan sabar kuma mai ba da takardar shaidar ta isa ta kuma duba cewa komai daidai ne. A cikin hanyar atomatik atomatik dole ne ku sanya wannan maɓallin a cikin DNS ɗin ku don mai ba da sabis ɗin ya iya tabbatar da shi. Gidan ku zai ba ku umarni kan yadda ake yin sa.

Hanyar kamar haka:
Mun shigar da aikace-aikacen
sudo snap install --classic certbot
Muna ƙirƙirar haɗin haɗin alama don yayi aiki kamar dai shiri ne na asali
sudo ln -s /snap/bin/certbot /usr/bin/certbot
Mun ƙaddamar da shirin don saita sabar.
sudo certbot --apache

Idan ya ba ku saƙon kuskure, gwada wannan:
sudo certbot --manual --preferred-challenges dns certonly \
-d midominio1.com \
-d www.midominio1.com \

Za ku ga cewa yana nuna muku rubutun lambobi da take wanda dole ne ku ƙara a cikin DNS ɗinku kamar rikodin rubutu. Da zarar kun yi. Latsa Shigar kuma mai ba da takardar shaidar zai tabbatar da cewa kun mallaki shafin.

Don gamawa dole ne ka sake saita apache don fara rukunin yanar gizon cikin yanayin aminci ta tsohuwa. Kuna yi tare da:

sudo certbot --apache

Select da wani zaɓi to reinstall takardar shaidar.

Yanzu zaku iya buɗe burauzar kuma saka sunan yankinku. Za ku ga shafin gida na Mautic wanda ke gaya muku cewa komai yana daidai. Yanzu zaku iya samun damar fayil ɗin sanyi wanda dole ne ku kammala tare da bayanan mai zuwa:
Database driver: MySQL PDO
Database Host: localhost
Database port: 3306
DB name: mautic
Database Table Prefix: Déjalo vacio
DB User: root
DB Password: La contraseña que pusiste en tu base de datos
Backup existing tables: No


Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Alhakin bayanai: AB Internet Networks 2008 SL
  2. Manufar bayanan: Sarrafa SPAM, sarrafa sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.