HowtoForge provides user-friendly Linux tutorials.

• How To Set Up A USB-Over-IP Server And Client With Mandriva 2010.0

  Author: Falko Timme • Tags: mandriva • Comments: 0

  How To Set Up A USB-Over-IP Server And Client With Mandriva 2010.0 This tutorial shows how to set up a USB-over-IP server with Mandriva 2010.0 as well as a USB-over-IP client (also running Mandriva 2010.0). The USB/IP Project aims to develop a general USB device sharing system over IP network. To share USB devices between computers with their full functionality, USB/IP encapsulates "USB I/O messages" into TCP/IP payloads and transmits them between computers. USB-over-IP can be useful for virtual machines, for example, that don't have access to the host system's hardware - USB-over-IP allows virtual machines to use remote USB devices.

  read more... | view as pdf

• When To Use Indexes In MySQL

  Author: tsmonaghan • Tags: mysql • Comments: 17

  When To Use Indexes In MySQL This comes up in discussions almost every new project I work on, because it's a very important thing to consider when designing a database. When deciding when and how to create an index in your MySQL database, it's important to consider how the data is being used.

  read more... | view as pdf

• Server Monitoring With munin And monit On Mandriva 2010.0

  Author: Falko Timme • Tags: mandriva, monitoring • Comments: 0

  Server Monitoring With munin And monit On Mandriva 2010.0 In this article I will describe how you can monitor your Mandriva 2010.0 server with munin and monit. munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix and takes the appropriate action such as a restart if it finds a service is not behaving as expected. The combination of the two gives you full monitoring: graphics that lets you recognize current or upcoming problems (like "We need a bigger server soon, our load average is increasing rapidly."), and a watchdog that ensures the availability of the monitored services.

  read more... | view as pdf

• Allow Your Applications To Access The XAMPP MySQL Server Directly

  Author: mrashad • Tags: linux, mysql • Comments: 3

  Allow Your Applications To Access The XAMPP MySQL Server Directly If you want to have a full featured "LAMP" server with one step you can use "XAMPP", it's easy and fast but you can't access its MySQL database server using the regular "mysql" client (/usr/bin/mysql), you have to use its own client (/opt/lampp/bin/mysql) to do that.

  read more... | view as pdf

• Chrooting Apache2 With mod_chroot On Fedora 12

  Author: Falko Timme • Tags: apache, fedora, security • Comments: 0

  Chrooting Apache2 With mod_chroot On Fedora 12 This guide explains how to set up mod_chroot with Apache2 on a Fedora 12 system. With mod_chroot, you can run Apache2 in a secure chroot environment and make your server less vulnerable to break-in attempts that try to exploit vulnerabilities in Apache2 or your installed web applications.

  read more... | view as pdf

• Installing Nictool On CentOS 5

  Author: rhein.andrea • Tags: apache, centos, dns • Comments: 1

  Installing Nictool On CentOS 5 Nictool is a free software for managing DNS, but for download we have to register at www.nictool.com; Nictool can export from djbdns, BIND, PowerDNS. All data is stored in MySQL and can be managed over the web using a browser. This tutorial shows how to install Nictool on CentOS 5.2.

  read more... | view as pdf

• How To Easily Migrate A PostgreSQL Server With Minimal Downtime

  Author: dratone • Tags: other, debian • Comments: 5

  How To Easily Migrate A PostgreSQL Server With Minimal Downtime PostgreSQL is a great database server, but when your dataset is rather large, migrating a server by using pg_dump can be a rather long process. In this tutorial we will discuss a way to migrate a entire server with as little downtime as possible. To achieve this, we will be using the PostgreSQL built in features for PITR (Point in time recovery).

  read more... | view as pdf

• Installing Lighttpd With PHP5 And MySQL On CentOS 5.2

  Author: rhein.andrea • Tags: centos, lighttpd • Comments: 0

  Installing Lighttpd With PHP5 And MySQL On CentOS 5.2 Lighttpd is a webserver designed to be secure, fast, standards-compliant, and flexible while being optimized for speed-critical environments. This post shows how to install it with PHP5 and MySQL support on Centos 5.2.

  read more... | view as pdf

• Virtual Mail And Jabber Server (xmpp) With iRedMail And Ejabberd On Ubuntu 9.10

  Author: eddiechen • Tags: ubuntu • Comments: 0

  Virtual Mail And Jabber Server (xmpp) With iRedMail And Ejabberd On Ubuntu 9.10 iRedMail is a shell script that lets you quickly deploy a full-featured mail solution in less than 2 minutes. Since iRedMail 0.5, it supports CentOS 5.x, Debian 5.x, Ubuntu 8.04, 9.04 and 9.10 (both i386 and x86_64). iRedMail supports both OpenLDAP and MySQL as backends for storing virtual domains and users. This tutorial shows you how to integrate Ejabberd into iredmail's ldap backend on Ubuntu 9.10, passwords will be stored in ldap and you can change the password through webmail.

  read more... | view as pdf

• Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On OpenSUSE 11.2

  Author: Falko Timme • Tags: ftp, suse • Comments: 0

  Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On OpenSUSE 11.2 This document describes how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database.

  read more... | view as pdf