Yadda ake Shigar Stack LAMP akan Debian 11/10/9


A (Agusta 14, 2021), aikin Debian ya sanar da samun sabon sigar barga (Debian 11) mai suna Bullseye.

Tare da wannan sakin, sanannen kuma sanannen da ake amfani da shi na Debian 10 Buster ya sami tsohon-tsayayyen matsayi, wanda ke ayyana ma'ajin kwanciyar hankali na baya. Kamar yadda koyaushe yake faruwa tare da sakin sabon sigar tsayayye, Bullseye ya haɗa da ɗaruruwan sabbin fakiti da sabuntawa ga dubban wasu.

Tunda Debian ke iko da kaso mai yawa na sabar gidan yanar gizo a duk faɗin duniya, a cikin wannan labarin za mu yi bayanin yadda ake shigar da tarin LAMP a cikin Debian 11 sannan kuma yana aiki akan tsofaffin Debian 10 da Debian 9.

Wannan zai ba da damar masu gudanar da tsarin su kafa sabbin sabar gidan yanar gizo a saman Bullseye ta amfani da sabuntawar kwanan nan zuwa wuraren ajiyar hukuma na rarraba. Ana ɗauka cewa kun haɓaka daga Debian 10 zuwa Debian 11.

Sanya LAMP a cikin Debian

M a cikin LAMP yana nufin MariaDB ko MySQL, uwar garken bayanai don tarawa.Ya danganta da zaɓinku, za ku iya shigar da uwar garken bayanan da sauran abubuwan (sabar yanar gizon Apache da PHP) kamar haka.

# apt update && apt install apache2 mariadb-server mariadb-client mariadb-common php php-mysqli
# apt update && apt install apache2 mysql-server mysql-client mysql-common php php-mysqli

A matsayin zaɓi na sirri, zan yi amfani da MariaDB a cikin sauran wannan labarin.

Da zarar an gama shigarwa, bari mu tabbatar da cewa duk ayyukan suna gudana. Idan haka ne, umarni masu zuwa.

# systemctl is-active apache2
# systemctl is-active mariadb

yakamata ya dawo aiki duka biyun. In ba haka ba, fara ayyukan biyu da hannu:

# systemctl start {apache2,mariadb}

Tabbatar da MariaDB a cikin Debian

A ƙarshe, kafin mu ci gaba bari mu yi amfani da mysql_secure_installation don saita kalmar sirri don asusun tushen bayanai, cire masu amfani da ba a san su ba, hana tushen shiga daga nesa kuma cire bayanan gwaji.

# mysql_secure_installation

Gwajin LAMP akan Debian

Don farawa, za mu ƙirƙira kuma mu cika samfurin bayanai. Bayan haka, za mu yi amfani da ainihin rubutun PHP don dawo da saitin bayanai daga ma'ajin bayanai a tsarin JSON.

A ƙarshe, za mu yi amfani da kayan aikin haɓaka Firefox don tabbatar da sigar Apache da ake amfani da ita. Ko da yake muna iya samun wannan bayanin guda ɗaya tare da.

# apache2 -v

Server version: Apache/2.4.51 (Debian)
Server built:   2021-10-07T17:49:44

dalilin da ya sa muke amfani da rubutun shine don tabbatar da cewa duk abubuwan da ke cikin tari suna aiki yadda ya kamata idan an haɗa su tare.

Bari mu shigar da saurin MariaDB tare da umarni mai zuwa.

# mysql -u root -p

kuma shigar da kalmar sirri da aka zaba a cikin sashin da ya gabata.

Yanzu za mu ƙirƙiri rumbun adana bayanai mai suna LibraryDB kamar haka:

MariaDB [(none)]> CREATE DATABASE LibraryDB;

kuma ƙara tebur guda biyu masu suna AuthorsTBL da BooksTBL:

MariaDB [(none)]> USE LibraryDB;
CREATE TABLE AuthorsTBL (
AuthorID INT NOT NULL AUTO_INCREMENT,
FullName VARCHAR(100) NOT NULL,
PRIMARY KEY(AuthorID)
);

MariaDB [(none)]> CREATE TABLE BooksTBL (
BookID INT NOT NULL AUTO_INCREMENT,
AuthorID INT NOT NULL,
ISBN VARCHAR(100) NOT NULL,
Title VARCHAR(100) NOT NULL,
Year VARCHAR(4),
PRIMARY KEY(BookID),
FOREIGN KEY(AuthorID) REFERENCES AuthorsTBL(AuthorID)
);

Don dalilai na tsaro, za mu ƙirƙiri asusu na musamman don isa ga bayanan mu:

MariaDB [(none)]> CREATE USER 'librarian'@'localhost' IDENTIFIED BY 'Today123';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON LibraryDB.* TO 'librarian'@'localhost';

Mataki na ƙarshe yanzu ya ƙunshi cika teburi tare da Marubuta da Littattafai:

MariaDB [(none)]> INSERT INTO AuthorsTBL (FullName) VALUES ('Paulo Coelho'), ('Isabel Allende'), ('Jorge Luis Borges');
MariaDB [(none)]> INSERT INTO BooksTBL (AuthorID, ISBN, Title, Year) VALUES
(1, '9788576653721', 'El alquimista', '1988'),
(1, '9780061194740', 'El peregrino', '1987'),
(2, '9789500720380', 'La casa de los espiritus', '1982'),
(3, '9789875666481', 'El Aleph', '1945');

Rubutun PHP mai zuwa zai fara haɗi zuwa ma'ajin bayanai kuma ya dawo da bayanan da suka dace da tambayar. Idan kuskure ya faru, za a nuna saƙon siffata don a ba mu alamar abin da ba daidai ba.

Ajiye rubutun mai zuwa azaman booksandauthors.php ƙarƙashin /var/www/html:

<?php
	// Show PHP version
	echo "Current PHP version: " . phpversion() .  "\r\n";

	// Connect to database
	$connection = mysqli_connect("localhost","librarian","Today123","LibraryDB") or die("Error " . mysqli_error($connection));

	// SQL query
	$sql = "SELECT A.ISBN, A.Title,
        	A.Year, B.FullName
        	FROM BooksTBL A JOIN AuthorsTBL B
        	ON A.AuthorID = B.AuthorID;";
	$result = mysqli_query($connection, $sql) or die("Error " . mysqli_error($connection));

	// Populate an array with the query results
	$libraryarray = array();
	while($row = mysqli_fetch_assoc($result))
	{
    	$libraryarray[] = $row;
	}

	// Convert to JSON
	echo json_encode($libraryarray);
?>

Canja ikon mallakar zuwa www-data kuma ƙara izini masu dacewa:

# chown www-data:www-data /var/www/html/booksandauthors.php
# chmod 600 /var/www/html/booksandauthors.php

A ƙarshe, buɗe mai binciken gidan yanar gizo kuma nuna shi zuwa URL inda rubutun yake.

http://192.168.0.35/booksandauthors.php

Shi ke nan! A cikin wannan labarin, mun bayyana yadda ake shigarwa da kuma gwada tarin LAMP akan Debian 11. Idan kuna da tambayoyi ko sharhi game da wannan labarin, kada ku yi shakka a sanar da mu ta amfani da fom ɗin da ke ƙasa.