phpList is a free and open-source web application for managing mailing lists and sending newsletters. It is written is PHP and uses MySQL/MariaDB to store its data. phpList is a very powerful web application, it can handle a very large number of subscribers and send newsletters to them. It provides easy to use web interface to create the newsletter and send it. It comes with a messaging queue to stop sending duplicate messages or sending failures. You can personalize the emails and the applications according to your needs. The application also provides the feature to track how many emails have been open and links have been clicked. Apart from all these, it provides many features such as bounce management, HTML emails, attachments with email etc. phpList is widely used by users from 95+ countries. It is available in more the 20 different languages.
phpList does not require any special hardware requirements. It can be installed on servers with a small amount of RAM. All the required dependencies will be installed throughout the tutorial. You will need a minimal installation of CentOS 7 with root access on it. If you are logged in as a non-root user, you can run sudo -i to switch to root user.
Before installing any package it is recommended that you update the packages and repository using the following command.
yum -y update
Once you have your system updated, you can proceed to install the LAMP stack. Start the LAMP installation by installing Apache web server and MariaDB, which is a fork of MySQL using the following command.
yum -y install httpd mariadb-server mariadb
phpList can be installed on any version of PHP greater than 5.4. But as PHP 5.4 has reached the end of life. You can install PHP 7 for high performance. PHP 7 is not included in default YUM repository, hence you will need to add the Webtatic repository in your system. Webtatic repository requires EPEL repository to work. Run the following command to install EPEL repository.
yum -y install epel-releaseyum -y update
Now install Webtatic repository using the following commands.
Make sure that you are using only one of the PHP versions mentioned above. Once you have PHP installed, you can check the version of PHP using the following command.
php -v You should get an output similar to this.
[root@liptan-pc ~]# php -v
PHP 7.1.1 (cli) (built: Jan 19 2017 20:35:16) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies
Next, you will need to enable Mod_rewrite in Apache web server by editing /etc/httpd/conf/httpd.conf using your favorite text editor.
Find the following line.
Change it to AllowOverride All.
Now start Apache web server and enable it to start at boot time using the following command.
systemctl start httpdsystemctl enable httpd
To start MariaDB and enable it to start at boot time using the following commands.
systemctl start mariadbsystemctl enable mariadb
Now run the following commands to secure your MySQL or MariaDB installation.
It will run a small script which asks you to provide the root password for MariaDB. As we have just installed MariaDB, the root password is not set, just press enter to proceed further. It will ask you if you want to set a root password for your MariaDB installation, choose y and set a strong password for the installation. It will also ask you for removing test databases and anonymous users. Most of the questions are self-explanatory and you should answer yes or y to all the questions.
To create a database we will need to login to MySQL command line first. Run the following command for same.
mysql -u root -p
This will prompt you for the password, provide the root password of MySQL which you have set earlier. Now run the following query to create a new database for your phpList installation.
CREATE DATABASE phplist_data;
The above query will create a database named phplist_data. For the database, you can use any name you prefer at the place of phplist_data.
Make sure that you use a semicolon at the end of each query as the query always ends with a semicolon. Once the database is created you can create a new user and grant all the permissions to the user for the database. Using root user is not recommended for the databases. To create a new database user, run the following query.
CREATE USER 'phplist_user'@'localhost' IDENTIFIED BY 'StrongPassword';
The above query will create a user with username phplist_user. You can use any preferred username instead of phplist_user. Replace StrongPassword with a strong password. Now provide the appropriate privileges to your database user over the database you have created. Run the following command.
GRANT ALL PRIVILEGES ON phplist_data.* TO 'phplist_user'@'localhost';
Now run the following command to immediately apply the changes on the database privileges.
Exit from MySQL prompt using exit command.
As we have all the dependencies ready, we can now download the install package from the phpList site.
cd /tmpwget https://downloads.sourceforge.net/project/phplist/phplist/3.3.0/phplist-3.3.0.zip -O phplist.zip
The above command will download the installer archive and store it as phplist.zip. You can always look for the latest release by going to the phpList download page.
Extract the archive using the following command.
If you don't have unzip installed, you can run yum -y install unzip. The above command will extract the files under phplist-3.3.0 directory. To move all the files from Upload folder to the default web root directory, use the following command.
mv /tmp/phplist*/public_html/* /var/www/html/
Now you will need to disable your SELinux because phpList does not work with SELinux policies. To temporary disable SELinux, run the following command.
To completely disable the SELinux you will need to edit
the /etc/selinux/config file.
If you don't have nano installed, you can install it using yum -y install nano. Find the following line:
Change it to:
Now you will need to reboot your server so that the new configuration can take effect. Once the server is rebooted, you will need to provide the ownership of the application to web server user using the following command.
chown -R apache:apache /var/www/html
You may also need to allow HTTP traffic on port 80 through the firewall if you are running one. Run the following commands for same.
Now edit the default configuration file config.php using the following command.
Find the following lines.
// what is your Mysql database server hostname
$database_host = 'localhost';
// what is the name of the database we are using
$database_name = 'phplistdb';
// what user has access to this database
$database_user = 'phplist';
// and what is the password to login to control the database
$database_password = 'phplist';
Change the value of the database name to the database we have created earlier to store the data. Further provide the username and password of the database user which we have created earlier. Further find the following line.
Change the above 1 to 0. It should look like shown below.
Save the file and exit from the editor.
You will also need to remove the index.html page. Run the following command to do so.
Now complete the installation using a web browser, go to the following link using your favorite web browser.
In this tutorial, we have learned how to install phpList on CentOS 7. You can now easily install phpList to send the newsletters to your subscribers to promote your business. You can also easily manage the subscribers through the phpList interface.
Truth be told, it’s difficult for a web application that doesn’t have some kind of identification, even if you don’t see it as a security measure in and of itself. The Internet is a kind of lawless land, and even on free services like Google’s, authentication ensures that abuses will...
Although data persistence is almost always a fundamental element of applications, Node.js has no native integration with databases. Everything is delegated to third-party libraries to be included manually, in addition to the standard APIs. Although MongoDB and other non-relational databases are the most common choice with Node because if you...