Server Solutions

Common Useful MySQL Commands — by opsec — last modified Nov 02, 2009 01:29 PM

These are examples of some common MySQL commands and syntax that may be helpful in programming, scripting or normal administration of MySQL databases.

Fedora Core: Connecting to an ADS Server — by scott_glaser — last modified Feb 01, 2010 07:41 PM

As many Fedora Core users may note, there are times when Windows just does not cut it, and you would rather be working on your data in Linux instead of Windows. During those times you may find it necessarry to connect to a Server 2003 ADS. This soulution came about for just one such ocassion. We are not going to cover the requirements in this procedure as this solution is not recommended for a new Fedora Core user, this is tailored for an advanced user that would have the knowledge to join a domain with their Fedora Core machine. Also assistance will be required from the Administrator of the domain, should that not be you!!

How To Install Virtualbox Guest Additions in Fedora Guest — by Re Alvarez — last modified Mar 12, 2008 02:30 PM

VirtualBox is an open source virtualization application that lets you run another operating system within your existing operating system. Your original system is called Host and then secondary system is called Guest. VirtualBox guest additions provide features such as mouse integration.

Installing & Configuring MySQL Server — by opsec — last modified Feb 23, 2010 08:55 PM

This Howto will show you how to install MySQL 5.x, start the service, make sure the server starts on reboot, login via terminal, change the root database admin password, change the name of the root user, add a new user with specific privileges to a specific database, add a new DBA, add a new database, remove all anonymous logins, remove all non-root users, added file security steps, disable remote access (via port 3306), purge the scrollback history, and finally the installation of the gui tool mysql-administrator.

Installing Fedora Using PXE Images — by zcat — last modified Jan 07, 2009 03:49 PM

Booting grub with the Fedora PXE vmlinuz/initrd images allows you to perform a network installation of Fedora over any existing linux distro, should you not be able to write to or boot from the conventional CD/DVD install media. A PXE netinstall can both be done locally, and with extra care, remotely using VNC. Both methods are explained in this HOWTO.

Installing VirtualBox on Fedora 8 HowTo — by kjs — last modified Feb 01, 2010 08:20 AM

HowTo install VirtualBox on Fedora core 8, however this should work on other versions.

Installing Zope+Plone on Fedora — by daMaestro — last modified Jan 30, 2008 03:46 AM

This guide will help you set up your own Plone site using Zope and Apache on Fedora Core. Zope is capable of acting as a standalone server, but we use Apache and its URL rewriting engine (mod_rewrite) to give us more power and flexibility.

iptables Howto — by kanarip — last modified Jan 30, 2008 02:44 AM

A Howto on using iptables to configure your firewall

MySQL Database Replication — by opsec — last modified Jun 13, 2008 04:01 PM

This Howto will show you how to setup MySQL database replication in case of hardware failure. This is not a permanent backup solution because if the DELETE command was given accidentally, it would also be replicated to the slave. This howto assumes you will not be making mistakes or giving DBA access to people who are not trustworthy. When finished, you'll have 2 identical MySQL databases on 2 different computers. This process can be adjusted to include multiple databases as well so you can backup all of your MySQL databases. Let's begin...

Postfix Mail Server — by daMaestro — last modified Jan 30, 2008 03:46 AM

This howto explains how to setup postfix with features such as tls encryption, smtp auth, content filtering, spam protection, virus protection and grey listing. This howto uses postfix, amavisd-new, spam assassin, clamav and sqlgrey. Most of which are in Fedora Extras. Work is also being done to make sure all are in Fedora Extras soon.

Repository Synchronization Script — by kanarip — last modified Nov 21, 2009 04:06 PM

This is a repository synchronization script for Fedora. It enables administrators to synchronize a local mirror of several repositories using the RSYNC protocol. Currently supported repositories are Fedora Core, Updates, Extras, Source and Livna.

Securing SSH — by zcat — last modified Feb 05, 2008 02:42 PM

This howto outlines a few extra steps that can be taken to further secure a SSH server, chiefly from the constant onslaught of automated brute-force password attacks.

Setting up a LAMP stack — by hypodermia — last modified Mar 04, 2010 01:45 PM

The so-called LAMP stack is one of the most compelling reasons to install Linux in the first place and probably the one primary purpose for many Fedora server-based installations. The combination of Linux/Apache/MySQL/PHP (or Perl, or even Python) allows webmasters to build websites and run complex applications such as a webmail interface or a wiki.

Sharing files with NFSv4 on Fedora (Server -> Multi) — by renich — last modified Mar 24, 2008 01:40 AM

This HowTo explains how to set up the Network File System version 4 on your LAN for multiple shares. It explains, also, how to mount the "exports" on your client.

SSHFS — by strikeforce — last modified Mar 10, 2008 12:52 PM

The idea of sshfs was taken from the SSHFS filesystem distributed with LUFS, which I found very useful. There were some limitations of that codebase, so I rewrote it. Features of this implementation are: * Based on FUSE (the best userspace filesystem framework for linux ;-) * Multithreading: more than one request can be on it's way to the server * Allowing large reads (max 64k) * Caching directory contents This install will explain how to install and mount sshfs. It will give examples of how to mount on boot using the /etc/fstab

VMware Server Installation — by scott_glaser — last modified Jan 19, 2009 12:03 PM

The free VMware Server is based upon VMware proven virtualization technology. With this robust yet easy to use software you can: Streamline software development and testing by allowing developers to create multiple environments with different operating systems on the same server. Simplify IT testing of patches, new applications and operating systems by allowing systems administrators to test in secure virtual machines and be able to roll back to a clean state by leveraging snapshots. Simplify server provisioning by building a virtual machine once and deploying it multiple times. Evaluate software in ready-to-run virtual machines without installation and configuration. Re-host legacy operating systems such as Windows NT Server 4.0 and Windows 2000 Server in a virtual machine running on new hardware and operating system. Leverage pre-built, ready-to-run virtual appliances that include virtual hardware, operating system and application environments. Virtual appliances for Web, file, print, DNS, email, proxy and other infrastructure services are available for download on VMware Technology Network (VMTN).

Yum & RPM FAQ — by zcat — last modified Oct 10, 2009 02:26 PM

Solutions to some of the most commonly asked yum and rpm questions.