This guide explains how to password-protect web directories (with users from a MySQL database) with mod_authn_dbd on Apache2 on a Debian 8 (Jessie) server. It is an alternative to the plain-text password files provided by mod_auth and allows you to use normal SQL syntax to create/modify delete users.
10 Older Entries »
This tutorial shows how to install an Apache webserver on an Ubuntu 16.04 server with PHP 7 (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites.
I use Pingdom's free service to monitor slaptijack.com.
Apparently, late Friday night,
that the server needed more memory and took out the MySQL server.
To make matters worse, I missed the alarm from Pingdom, and
slaptijack.com was down for pretty much all of Saturday. The fact
oom-killer was invoked is annoying, but more on
The beauty of using Pelican rather than Wordpress (or any other database-driven content engine) is one less point of failure for the site. Obviously, I don't have all of slaptijack.com converted to Pelican yet (and perhaps never will), but at least parts of the site were up and working despite MySQL being down. If nothing else, this incident is enough to convince me that moving to Pelican was a good idea.
In this article we will show you how to install GLPI with Apache, PHP and MySQL on a Debian 7 VPS. GLPI is an IT software management package developed in PHP. It offers many functionalities one of which is to build up a database with an inventory for your company (computer, monitors, software, printers…). GLPI has enhanced functions to make the daily life for the administrators easier, like a job-tracking-system with mail-notification and methods to build a database with basic information about your network-topology. Below are the functions of this application: Inventory of computers, peripherals, network printers and associated components […]
I posted earlier in the year how to configure a Fedora instance to test PHP code on a local VM. However, I’ve got a few questions on how to find those posts. Here’s a consolidation with links on those steps:
- Go to this blog post and install the
phplibraries with the
- In the same blog post as step 1 (you can put the sample
PHP code into the
/var/www/htmldirectory for testing), connect to the
yumshell and remove the
php-mysqllibrary and then install the
- Go to this blog …
In this article we will walk you through the steps on how to install LAMP (Linux, Apache, MySQL and PHP-FPM) on a Debian 8 VPS. A LAMP stack is a synonym of LAMP server or LAMP web server. It refers to a set-up which includes Linux, Apache, MySQL (MariaDB) and PHP. REQUIREMENTS We will be using our SSD 1 Linux VPS hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully up to date using: # apt-get update && apt-get upgrade INSTALL APACHE To install Apache on your Debian 8 server, you need to execute the […]
It had been in the making for long time. Google announced that Google Code would be closing, and since then the Continuent team has been hard at work to handle the transition. You can guess it: this operation would have been quicker if it had been done by a small company like we were one year ago, but being part of a large corporation introduces some constraints that have affected our schedule.
However, our wish has always been, and still is, to keep Tungsten Replicator as an open source product, with full functionalities and with the full benefits that the open source development model offers.
Today, Tungsten Replicator is available on GitHub as …[Read more]
For the majority of us who have grown accustomed to a Windows environment over the years, Linux can seem like another world. In essence, Linux is a free open-source operating system that has gained increasing popularity since its release in 1991. Linux is based on the whole Unix ecosystem of operating systems that grew out of Bell Laboratories in the early 1970s. Linux has been around for almost 25 years and grew immensely in the late 1990s and early 2000s when it became associated with the LAMP web development stack; Linux stands for the ‘L’ in the acronym of popular tools, along with Apache, MySQL, and PHP/Perl/Python.
The main difference that …[Read more]
It turns out that configuring Perl wasn’t the last step for my
student instance. It appears that I neglected to configure my
student instance to support Java connectivity to MySQL. This post
reviews the configuration of Java to run programs against MySQL.
It also covers the new syntax on how you register a
DriverManager, and avoid Java compilation errors
with the older syntax.
You need to install the Open JDK libraries …[Read more]
Everything seemed complete after configuring my standalone MySQL instance to a LAMP
installation, but last night I started playing with the image
files. It turns out that I failed to install the
There’s very little feedback when you try to troubleshoot why you
can’t read an image. In fact, the error message for reading the
BLOB from MySQL was only available on the local
The image "http://localhost/ConvertMySQLBlobToImage.php" cannot be displayed because it contains errors.
The fix requires
root to install the
php-gd library with the
yum install php-gd
You’ll need to answer …[Read more]
10 Older Entries »