Biapy Help Desk
https://howto.biapy.com
Ease PostgreSQL server administration with pgsql-tools
https://howto.biapy.com/en/debian-gnu-linux/servers/databases/ease-postgresql-server-administration-with-pgsql-tools
pgsql-tools is a script I wrote with the goal to ease and automate the regular administration tasks of a PostgreSQL server. This howto describe howto to install and use it.No publisher2012/10/11 14:05:00 GMT+0ArticleManage PHP ini options from command line on Debian
https://howto.biapy.com/en/debian-gnu-linux/servers/php/manage-php-ini-options-from-command-line-on-debian
Memory limit, upload limit, quote management, ... are PHP configuration options which change is asked by various Web applications. This howto setup a command line script to ease the management of PHP configuration changes.No publisher2012/06/03 12:55:00 GMT+0ArticleEase MySQL server administration with mysql-tools
https://howto.biapy.com/en/debian-gnu-linux/servers/mysql/ease-mysql-server-administration-with-mysql-tools
mysql-tools is a script written with the intent to ease and automate the daily administration tasks of a MySQL server. This howto describe howto to install and use it.No publisher2012/05/30 21:45:00 GMT+0ArticleSetup the contrib and non-free Debian repositories
https://howto.biapy.com/en/debian-gnu-linux/system/software/setup-the-contrib-and-non-free-debian-repositories
The default Debian installation only provide software from the "main" repository. In order to have access to all Debian softwares, contrib and non-free repositories must be configured. This howto describe an automated process to enable the contrib and non-free repositories in Apt.No publisher2012/05/25 19:50:00 GMT+0ArticleApache 2
https://howto.biapy.com/en/debian-gnu-linux/servers/apache-2
Apache 2 installation and configuration howtos for DebianNo publisher2012/05/25 10:20:00 GMT+0ArticleHarden the security of Apache 2 on Debian
https://howto.biapy.com/en/debian-gnu-linux/servers/apache-2/harden-the-security-of-apache-2-on-debian
Apache 2 is a robust HTTP server with numerous functionalities. This howto harden the security of Apache 2 by apply basic rules.No publisher2012/05/24 16:50:00 GMT+0ArticleEnhance PHP 5 initial setup on Debian
https://howto.biapy.com/en/debian-gnu-linux/servers/php/enhance-php-5-initial-setup-on-debian
The initial PHP 5 setup provided by Debian is just fine. This howto provide adjustments enhancing it.No publisher2012/05/24 16:50:00 GMT+0ArticleSetup a regular analyze and optimization / defragmentation of MySQL tables
https://howto.biapy.com/en/debian-gnu-linux/servers/mysql/setup-a-regular-analyze-and-optimization-defragmentation-of-mysql-tables
With the flow of inserts and deletes, the MySQL tables performances can drop. Regularly optimize and analyze MySQL tables allow to rebuild the indexes and limit the disk space used by MySQL on the server. No publisher2012/05/24 10:40:00 GMT+0ArticleSyslog
https://howto.biapy.com/en/debian-gnu-linux/servers/syslog
Howtos to setup Rsyslog and Syslog-NG system events logs management softwares.No publisher2012/05/12 11:25:00 GMT+0ArticleStore PHP sessions in Memcached and MySQL
https://howto.biapy.com/en/debian-gnu-linux/servers/php/store-php-sessions-in-memcached-and-mysql
Using Memcached and MySQL to manage PHP sessions is the key to create high-availability hosting. This setup allow to share session data between several PHP servers hosted behind a load-balancer. In a simpler environment, it allow to prevent storing sessions data on file system. This howto describe the installation of a custom PHP sessions manager using a hybrid Memcached / MySQL storage.No publisher2012/05/09 13:55:00 GMT+0ArticleStore PHP sessions in Memcached
https://howto.biapy.com/en/debian-gnu-linux/servers/php/store-php-sessions-in-memcached
By default, PHP sessions are stored on file system (in /var/lib/php5, or in /tmp). If the hosted PHP sites have an intensive use of sessions, this can add a additional delay to PHP requests run. It is possible to optimize PHP performances by storing sessions in memory with the help of Memcached. This guide describe how to set this up.No publisher2012/05/07 18:15:00 GMT+0ArticleInstall Memcached on Debian
https://howto.biapy.com/en/debian-gnu-linux/servers/databases/install-memcached-on-debian
Memcached is a key/value database server easing the cache of objects in memory. It is largely used by some PHP CMS (Wordpress, Drupal, Prestashop, ...) for it bring a visible performance boost on server with available RAM. This howto ease the installation of Memcached on DebianNo publisher2012/05/07 17:55:00 GMT+0ArticleMonitoring
https://howto.biapy.com/en/debian-gnu-linux/web-applications/monitoring
Tools for monitoring servers state.No publisher2012/05/04 23:50:00 GMT+0ArticleSetup a status page on a Apache 2 server
https://howto.biapy.com/en/debian-gnu-linux/servers/apache-2/setup-a-status-page-on-a-apache-2-server
Apache 2, PHP-FPM, APC, and other tools have usage statistics in Web pages. The data provided by these statistics are critical. It is important to secure the access to them. This howto setup a secure sub-domain dedicated to the display of HTTP server statuses.No publisher2012/04/28 16:30:00 GMT+0ArticleLog PHP errors with Syslog
https://howto.biapy.com/en/debian-gnu-linux/servers/syslog/log-php-errors-with-syslog
Function of the server configuration, the PHP messages are not logged to HTTP server error log. In this case, it is necessary to setup PHP to log errors to a dedicated log file, or to Syslog. This howto propose a simple setup to log PHP errors in the file "/var/log/php.log"No publisher2012/04/26 22:30:00 GMT+0Article