phplist: instalacion ubuntu-server 22.04

  • Actualizamos
sudo apt update && sudo apt upgrade -y

Instalar MySQL o MariaDB:

  • Instalamos
sudo apt install -y mariadb-server mariadb-client
  • Iniciar el servicio
sudo systemctl start mysql
sudo systemctl enable mysql
sudo systemctl status mysql
  • Asegurar la BD
sudo mysql_secure_installation
  • Resultado
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorisation.

You already have your root account protected, so you can safely answer 'n'.

Switch to unix_socket authentication [Y/n] 
Enabled successfully!
Reloading privilege tables..
 ... Success!


You already have your root account protected, so you can safely answer 'n'.

Change the root password? [Y/n] n
 ... skipping.

By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] Y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] Y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
  • Crear una base de datos para phpList
sudo mysql -u root -p (ENTER)

CREATE DATABASE phplist CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE USER 'phplistuser'@'localhost' IDENTIFIED BY 'phplistuser123';

GRANT ALL PRIVILEGES ON phplist.* TO 'phplistuser'@'localhost';

FLUSH PRIVILEGES;
EXIT;
  • acceso remoto
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
  • Y modificar
bind-address            = 127.0.0.1
X
bind-address            = 0.0.0.0
  • otorgar permisos al usuario para conectarse desde cualquier host:
sudo mysql -u root -p

GRANT ALL PRIVILEGES ON phplist.* TO 'phplistuser'@'%' IDENTIFIED BY 'phplistuser123';

FLUSH PRIVILEGES;
  • reinicamos
sudo systemctl restart mariadb
sudo systemctl status mariadb
  • Ahora desde otra maquina podemos probar la conexion
mysql -u phplistuser -p -h 10.0.2.98

Instalar Apache

  • Instalamos
sudo apt install -y apache2
  • Habilitar el módulo mod_rewrite:
sudo a2enmod rewrite
sudo systemctl restart apache2
  • Configurar el VirtualHost para phpList: Crear un archivo de configuración:
sudo nano /etc/apache2/sites-available/phplist.conf
  • Agregarle
<VirtualHost *:80>
    ServerName phplist.una.ac.cr
    DocumentRoot /var/www/html/phplist/public_html/lists/
    <Directory /var/www/html/phplist/public_html/lists>
        Options FollowSymLinks
        AllowOverride All
        Require all granted
        DirectoryIndex index.php index.html
    </Directory>
    ErrorLog ${APACHE_LOG_DIR}/phplist_error.log
    CustomLog ${APACHE_LOG_DIR}/phplist_access.log combined
</VirtualHost>
  • Habilitar el sitio y reiniciar Apache:
sudo a2ensite phplist
sudo systemctl reload apache2

Instalar PHP 8.1 y extensiones necesarias

  • Agregar el repositorio de PHP:
sudo apt install -y software-properties-common
sudo add-apt-repository -y ppa:ondrej/php
sudo apt update
  • Instalar PHP 8.1 con extensiones:
sudo apt install -y php8.1 php8.1-curl php8.1-gd php8.1-imap php8.1-mbstring php8.1-mysql php8.1-xml php8.1-zip php8.1-cli
  • Verificamos los módulos y version de php
php -v
php -m
  • Para que los cambios tengan efecto, reinicia el servidor web:
sudo systemctl restart apache2
  • Asegurarte de que PHP está habilitado en Apache:
sudo apt install libapache2-mod-php8.1
sudo systemctl restart apache2
  • Configurar parámetros opcionales (como upload_max_filesize, post_max_size
  • abrimos el archivo
sudo nano /etc/php/8.1/apache2/php.ini
  • Busca y ajusta:
memory_limit = 256M
upload_max_filesize = 64M
post_max_size = 64M
max_execution_time = 300
  • Reinicamos
sudo systemctl restart apache2
  • Creamos un archivo phpinfo para ver su funcionamiento
echo "<?php phpinfo(); ?>" | sudo tee /var/www/html/info.php

Descargar e instalar phpList

  • Descargamos
cd /tmp

wget https://sourceforge.net/projects/phplist/files/phplist/3.6.15/phplist-3.6.15.tgz
  • Extraer e instalar:
sudo tar -xvzf phplist-3.6.15.tgz -C /var/www/html/
sudo mv /var/www/html/phplist-* /var/www/html/phplist
sudo chown -R www-data:www-data /var/www/html/phplist
sudo chmod -R 755 /var/www/html/phplist
  • Editar el archivo de configuración:
sudo nano /var/www/html/phplist/public_html/lists/config/config.php
  • Y modificamos los datos de la BD
  • Ademas como el virtual host pusimos la ruta /var/www/html/phplist/public_html/lists/
  • Vamos agregar esta variables en el archivo config.php
nano /var/www/html/phplist/public_html/lists/config/config.php
  • agregamos al final
$pageroot = '/';
  • Y tambien agregamos el idioma
$default_system_language = "es";
  • Le damos inicializar la BD
  • Y completamos los datos
  • Y se crea la BD
  • le decimos que nos queremos subcribir