Setup LAMP stack with Manjaro OpenRC

LAMP Stack

LAMP Stack (obsolete)

DAMP Stack

Package Management

Local Group

Preface

Hello all. I hope everyone that is reading this, is having a really good day.

I decide to share my ordinary log, about setting up LAMP stack which is very common.

With special customization

OpenRC instead of systemd
MariaDB instead of MySQL
Manjaro pacman instead of debian-based apt-get.

It is 2022, I’m using Artix instead of Manjaro OpenRC.

Reading

Before you read this, you might want to check the holy arch wiki.

Install

[terminal]

$ sudo pacman -S apache mariadb php php-apache phpmyadmin apache-openrc mysql-openrc

$ sudo apachectl start

$ sudo rc-update add httpd default
 * service httpd added to runlevel default

$ sudo rc-update add mysql default
 * service mysql added to runlevel default

[browser: test]

http://localhost/

Basic Apache Configuration

[editor: /etc/httpd/conf/httpd.conf]

# epsi!
LoadModule mpm_prefork_module modules/mod_mpm_prefork.so
LoadModule php5_module modules/libphp5.so

# comment out
#LoadModule mpm_event_module modules/mod_mpm_event.so

# uncomment
LoadModule rewrite_module modules/mod_rewrite.so

# epsi!
ServerName localhost

<IfModule mime_module>
    # ...    
    
 # epsi !
 AddType application/x-httpd-php .php
 AddType application/x-httpd-php-source .phps
 
</IfModule>

# epsi!
Include conf/extra/php5_module.conf

In PHP 8

LoadModule php_module modules/libphp.so

[editor: /usr/lib/tmpfiles.d/]

This is not command line. Edit this in your favorite text editor.

d /run/httpd 0755 http http -

[terminal]

$ sudo rc-service httpd restart

Localhost Test

[terminal]

$ sudo sh -c 'echo "<html><body>miauw</body><html>" > /srv/http/hello.html'
$ sudo sh -c 'echo "<html><body>miauw</body><html>" > /srv/http/hello.php'
$ sudo sh -c 'echo "<?php phpinfo(); ?>" > /srv/http/phpinfo.php'

[browser: test]

http://localhost/hello.html http://localhost/hello.php http://localhost/phpinfo.php

mariadb

$ sudo /usr/bin/mysqld_safe --datadir='/var/lib/mysql'

[editor: /etc/mysql/my.cnf]

# The MariaDB server
port = 3306
socket = /run/mysqld/mysqld.sock

# epsi !
user        = mysql
basedir     = /usr
datadir     = /var/lib/mysql
pid-file    = /run/mysql/mysql.pid

$ sudo rc-service mysql restart
 * Checking mysqld configuration for mysql ...                    [ ok ]
 * Starting mysql ...
 * /run/mysql: creating directory
 * /run/mysql: correcting owner 
 
$ cd /media/Works/Backup.Temp/
$ mysql -u root < sf_book2.sql
$ mysql -u root < joomla30.sql

In 2022 my config is simple

# The MariaDB server
port = 3306
socket = /run/mysqld/mysqld.sock

# epsi !
user        = mysql

But the service has different name.

❯ sudo rc-service mariadb restart
[sudo] password for epsi: 
mariadb           | * Stopping mariadb ...                                   [ ok ]
mariadb           | * Starting mariadb ...
mariadb           |220202 20:14:04 mysqld_safe Logging to syslog.
mariadb           |220202 20:14:04 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql

phpmyadmin

[reading]

https://wiki.archlinux.org/index.php/PhpMyAdmin

[terminal]

$ sudo touch ls /etc/httpd/conf/extra/phpmyadmin.conf

[editor: /etc/httpd/conf/extra/phpmyadmin.conf]

Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
    DirectoryIndex index.php
    AllowOverride All
    Options FollowSymlinks
    Require all granted
</Directory>

[editor: /etc/httpd/conf/httpd.conf]

# epsi!
# phpMyAdmin configuration
Include conf/extra/phpmyadmin.conf

[editor: /etc/php/php.ini]

# set
date.timezone = "Asia/Jakarta"

# uncomment
extension=mysqli.so
# extension=mcrypt.so

# add directory
open_basedir = /srv/http/:/home/:/tmp/:/usr/share/pear/:/usr/share/webapps/:/etc/webapps/

[terminal]

$ cat /etc/webapps/phpmyadmin/config.inc.php | less

$ sudo rc-service httpd restart

[browser: test]

http://localhost/phpmyadmin

[editor: /usr/share/webapps/phpMyAdmin/config.inc.php]

 CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
 GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';
 FLUSH PRIVILEGES;

Local Host

[editor: /etc/httpd/conf/httpd.conf]

<Directory "/srv/http">
    # change
    AllowOverride All
</Directory>

[terminal]

$ cd /srv/http
$ sudo ln -s /media/Works/Development/www/symfony2/book2/ book2
$ sudo ln -s /media/Works/Development/www/drupal/ drupal
$ sudo ln -s /media/Works/Development/www/sites/ sites

$ sudo rc-service httpd restart

Virtual Host

[terminal]

$ sudo mkdir /etc/httpd/conf/vhosts
$ sudo touch /etc/httpd/conf/vhosts/localhost.conf
$ sudo touch /etc/httpd/conf/vhosts/book2.conf

[editor: /etc/hosts]

#<ip-address>   <hostname.domain.org>   <hostname>
127.0.0.1       localhost
127.0.1.1       axioo
127.0.0.1       book2
127.0.0.1       localhost.localdomain   localhost
::1             localhost.localdomain   localhost

[editor: /etc/httpd/conf/vhosts/localhost.conf]

<VirtualHost *:80>
    ServerName localhost
    DocumentRoot /srv/http
</VirtualHost>

[editor: /etc/httpd/conf/vhosts/book2.conf]

<VirtualHost *:80>

    ServerName book2
    DocumentRoot /media/Works/Development/www/symfony2/book2/web
    DirectoryIndex app.php
    ErrorLog /var/log/httpd/book2.log
    CustomLog /var/log/httpd/book2.log common

    <Directory "/media/Works/Development/www/symfony2/book2/web">
        AllowOverride All
     Require all granted
    </Directory>
    
</VirtualHost>

[editor: /etc/httpd/conf/httpd.conf]

# epsi!
# Enabled Vhosts:
Include conf/vhosts/localhost.conf
Include conf/vhosts/book2.conf

[editor: /etc/php/php.ini]

# uncomment
extension=mysql.so
extension=pdo_mysql.so

# add folder
open_basedir = /srv/http/:/home/:/tmp/:/usr/share/pear/:/usr/share/webapps/:/etc/webapps/:/media/Works/Development/www/

[terminal]

$ sudo rc-service httpd restart
$ httpd -S

Finalization

Sleep

Have a nice dream.