Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for Automating Perl Database Applications

Debian

Preventing MySQL Injection Attacks With GreenSQL On Debian Etch

Post date: October 28, 2008, 12:10 Category: Security Views: 4113 Comments
Tutorial quote: GreenSQL (or greensql-fw) is a firewall for MySQL databases that filters SQL injection attacks. It works as a reverse proxy, i.e., it takes the SQL queries, checks them, passes them on to the MySQL database and delivers back the result from the MySQL database. It comes with a web interface (called greensql-console) so that you can manage GreenSQL through a web browser. This guide shows how you can install GreenSQL and its web interface on a Debian Etch server.
Debian

Monitoring Services using Mon

Post date: April 4, 2006, 20:04 Category: Installing Views: 2936 Comments
Tutorial quote: mon is a general-purpose scheduler and alert management tool used for monitoring service availability and triggering alerts upon failure detection. mon was designed to be open and extensible in the sense that it supports arbitrary monitoring facilities and alert methods via a common interface, all of which are easily implemented with programs in C, Perl, shell, etc., SNMP traps, and special mon traps.
Debian

Manipulating the windows upon your desktop

Post date: January 19, 2006, 13:01 Category: Desktop Views: 3028 Comments
Tutorial quote: If you're like me you'll most likely use a wide variety of desktop applications, and spend a lot of time setting up your desktop first thing in the afternoon when you login. Minimising some applications, setting others up to be visible upon all virtual desktops, etc. Even if you have a basic window manager you can automate this activity using Devil's Pie.

Devil's Pie is a simple utility, inspired by the Sawfish's matched windows option, which allows you to conduct actions upon desktop windows. Using it is a simple matter of creating a configuration file and starting the program when you login.
Debian

Scheduled Backups With Rsyncbackup On Debian Etch

Post date: April 13, 2008, 12:04 Category: Miscellaneous Views: 3618 Comments
Tutorial quote: This document describes how to set up and configure rsyncbackup on Debian Etch. Rsyncbackup is a Perl script that cooperates with rsync. It is easy to configure and able to create scheduled backups (partial and incremental backups).
Debian

Installing A Multiserver Setup With Dedicated Web, Email, DNS And MySQL Database Servers On Debian 5.0 With ISPConfig 3

Post date: August 19, 2010, 16:08 Category: Installing Views: 4240 Comments
Tutorial quote: This tutorial describes the installation of an ISPConfig 3 multiserver setup with dedicated web, email, database and two DNS servers all managed trough a single ISPConfig 3 control panel. The setup described below uses five servers and can be extended easily to to a higher number of servers by just adding more servers. E.g. if you want to have two mailservers, do the setup steps from chapter 2 on both of these servers. If you want to set up more web servers, then install ISPConfig on all other web servers in expert mode except of the first one.
Debian

Installing LedgerSMB (Open Source Accounting Application) On Debian Etch

Post date: October 14, 2007, 10:10 Category: Software Views: 4557 Comments
Tutorial quote: LedgerSMB is a free (licensed under the GPL), web based double entry accounting system written in Perl which uses PostgreSQL for data storage. It is intended for small and medium businesses (SMB), and it can be used easily through a regular web browser like Firefox. This tutorial explains how to install LedgerSMB on a Debian Etch system.
Mandriva

Virtual Users & Domains With Postfix, MySQL & SquirrelMail (Mandriva 2008.1)

Post date: April 15, 2008, 11:04 Category: Installing Views: 3610 Comments
Tutorial quote: This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I will also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses. I will also show how to install SquirrelMail as a webmail interface so that users can read and send emails and change their passwords.
Ubuntu

Virtual Users/Domains With Postfix, Courier, MySQL, SquirrelMail (Ubuntu 9.04)

Post date: June 11, 2009, 12:06 Category: Installing Views: 3259 Comments
Tutorial quote: This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses. I will also show how to install SquirrelMail as a webmail interface so that users can read and send emails and change their passwords.
Debian

Secure Your Apache With mod_security

Post date: July 16, 2006, 16:07 Category: Security Views: 5546 Comments
Tutorial quote: This article shows how to install and configure mod_security. mod_security is an Apache module (for Apache 1 and 2) that provides intrusion detection and prevention for web applications. It aims at shielding web applications from known and unknown attacks, such as SQL injection attacks, cross-site scripting, path traversal attacks, etc.

In the first chapter I will show how to install mod_security on Debian Sarge, Ubuntu 6.06 LTS (Dapper Drake), and on Fedora Core 5, and in the second chapter I will describe how to configure Apache for mod_security which is independent from the distribution you're using.

I want to say first that this is not the only way of setting up such a system. There are many ways of achieving this goal but this is the way I take. I do not issue any guarantee that this will work for you!
CentOS

Serving CGI Scripts With Nginx On CentOS 6.0

Post date: October 23, 2011, 09:10 Category: Miscellaneous Views: 21152 Comments
Tutorial quote: This tutorial shows how you can serve CGI scripts (Perl scripts) with nginx on CentOS 6.0. While nginx itself does not serve CGI, there are several ways to work around this. I will outline two solutions: the first is to proxy requests for CGI scripts to Thttpd, a small web server that has CGI support, while the second solution uses a CGI wrapper to serve CGI scripts.
Web-based applications and online marketing solutions - LumoLink