Ubuntu Saucy Databases

From

Revision as of 21:51, 1 November 2013 by Perspectoff (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Ubuntu Saucy Databases
Full page | eBook Version

Contents

Servers

Many server packages (such as Apache2, MySQL, PHP, etc.) can be installed individually, on either a Desktop edition or a Server edition (using the tasksel command described below). It is not necessary in general, therefore, to install Ubuntu Server if you only wish to use an occasional server package on a Desktop edition. Most of the instructions for individual server packages will work on the Server edition, on the Desktop edition, or on a Server edition that has had an Ubuntu or Kubuntu desktop installed on it.

Nevertheless, the Server edition is optimised for speed and ease of monitoring and maintenance when implemented in large networks and is therefore recommended. (For complete information see the Ubuntu Server Guide.) It is always possible to add an Ubuntu (Gnome) or Kubuntu (KDE) GUI desktop to an Ubuntu Server at any time.

(If you are attempting to create a dual-boot or multi-boot configuration with multiple operating systems on your computer, then see these tips.)

(Tip: During installation of the server, an initial user / password is created. Many servers are intended to run unattended with little subsequent intervention and it can be easy to forget the original user / password pair that is created at installation. I suggest writing this information down and taping it to the inside of the computer case cover for later reference. (Lock the computer case if you desire extra security.))

There are many server packages that are available to be installed as a one-step process during the Server edition installation process from the LiveCD, or at any time (on most editions) using the tasksel command. For a list of server packages that can be installed using the tasksel command:

sudo apt-get install tasksel
sudo tasksel --list-tasks
or using a GUI list:
sudo tasksel

Ultimate Server Walkthrough

  • Using instructions from Ubuntuguide, an ultimate server can be created with two wikis (MediaWiki), two Drupal websites, a Moodle online learning website, a BigBlueButton teleconferencing server, an Ubuntu desktop, and dynamic DNS access from the web. All components can be expanded and/or additional servers added.
  • Lucid ultimate server walkthrough.
  • Original Jaunty ultimate server walkthrough.

Add a desktop to an Ubuntu Server

Packages that require server capabilities (such as Drupal with Apache, etc.) are often happier when a Server edition is installed as the base OS. However, adding a desktop can make the administration and maintenance of many packages easier for many users (albeit with a cost of reduced server speed). Add an Ubuntu (Unity or Gnome) or Kubuntu (KDE) desktop to a server using:

sudo apt-get install ubuntu-desktop
or
sudo apt-get install kubuntu-desktop

LAMP server installation

During server installation, you will have the option of installing a LAMP (Linux, Apache, MySQL, PHP) server stack. Many (but not all) open source servers use this integrated server stack. Drupal, for example, needs to have a LAMP server installed. If you intend to install a groupware server, however, make sure it is compatible with a LAMP server stack before choosing this option. Many groupware servers will install LAMP (or their own variation) automatically, so you do not need to install the LAMP stack. Others will install and use postgreSQL instead of MySQL, so you would not need to install a LAMP server.

Apache2 + MySQL + PHP

This is the preferred method:

sudo apt-get install tasksel
sudo tasksel install lamp-server

(Tip: During installation of the LAMP server, an initial MySQL "root" user password is created. This information will sometimes be needed when installing other server packages that use MySQL. I suggest writing the MySQL password down and taping it to the inside of the computer case cover for later reference. (Lock the computer case if you desire extra security.))

Other servers

During server installation, you can choose other servers to install, as well. These include a Mail server (Postfix with Dovecot), a DNS server (bind9), the OpenSSH server, a print server, a Tomcat Java web server, a Samba file server (for use with Windows networks), and a virtual machine host (Xen). Again, if you are using a groupware solution, you should be careful about installing these services, as they may conflict with similar (but competing) servers which the groupware solution will install by default.

eBox (server and network manager)

eBox is a web-browser based server management platform that is useful in managing multiple servers and networking functions in a small to medium business. It is modular so that as the network grows and more networking functions or servers (such as the ones listed below) are added, eBox can manage those, as well. Install:

sudo apt-get install ebox

OpenSSH server

OpenSSH allows encrypted communications through a designated secure port. See setting up an SSH server.

VPN Server

Mail Server

There are two methods for setting up a mail server.

  • The dovecot-postfix package install the components and configuration files to use the Maildir (mail spooling) folder system by default. See Dovecot-Postfix Mail server.
  • The mail-server task installs the components and configuration files to use the mbox (mail spooling) system by default. This can be installed:
sudo apt-get install tasksel
sudo tasksel install mail-server

Bind9 (DNS server)

BIND DNS servers are the most commonly used on the Internet. Bind9 is the current edition. See the usage instruction here. Also see the official Ubuntu documentation for more configuration information. It can be installed using the tasksel option during installation of the Ubuntu server from the LiveCD, or at any time using:

sudo tasksel install dns-server

Apache Tomcat (Java server)

Tomcat is a free open source platform from Apache which provides a "pure Java" HTTP web server environment for Java code to run (see here for more info).

It is not part of the Apache2 web server. See the official Ubuntu documentation for more configuration information. It can be installed using the tasksel option during installation of the Ubuntu server from the LiveCD, or at any time using:

sudo tasksel install tomcat-server

Xen virtual machine host

Xen is a free open source virtualization platform that allows the host to run "guest" operating systems simultaneously (see here for more info). Xen implementation in the (K)ubuntu server is based on integration with KVM, the kernel-based virtualization platform in Linux. KVM integrates with QEMU components, which have been merged with Xen.

Note: KVM requires a 64-bit processor with a virtualization extension, i.e. an Intel VT or AMD-V CPU, therefore this package currently is successful only with the 64-bit Ubuntu server installation and on those CPUs.

It can be installed using the tasksel option during installation of the Ubuntu server from the LiveCD, or at any time using:

sudo tasksel install virt-host

Print server

Ubuntu uses the CUPS print server, which is integrated into the desktop. Installing a print server in Ubuntu Server is necessary only if you do not intend to use a desktop (i.e. you intend a "headless" server). It can be installed using the tasksel option during installation of the Ubuntu server from the LiveCD, or at any time using:

sudo tasksel install print-server

OpenLDAP

OpenLDAP is a community-based LDAP server that allows directory querying over TCP/IP, generally for organizations arranged by domain. Ubuntu uses the slapd daemon for the OpenLDAP server. See the official Ubuntu documentation for more information about installation and setup.

Proxy server

Squid

Squid is a widely-used proxy web server and web cache daemon that is useful for corporate or other large LANs that wish to accelerate and/or control traffic through the LAN. For initial configuration information, see the official Ubuntu documentation. Install:

sudo apt-get install squid

Privoxy

Privoxy is a non-caching web proxy with advanced filtering capabilities for enhancing privacy, modifying web page data and HTTP headers, controlling access, and removing ads and other obnoxious Internet junk. It is easier to configure and more useful for individual users. Install:

sudo apt-get install privoxy

Reverse proxy Servers and Load Balancers

A reverse proxy server allows incoming web traffic on a LAN to be directed to multiple computers (each running one or more servers) on the LAN. When redundant instances of a server exist on a LAN, a Load Balancer allows traffic to be directed to the most available instance.

Pound (Reverse proxy and load balancer)

Pound is a free, open source (GPL-licensed) lightweight reverse proxy and load balancer. Also see the Ubuntu Community instructions. Install:

sudo apt-get install pound

Apache Reverse proxy

The Apache2 server has a mod_proxy module available that enables reverse proxies. See these instructions for a simple method to implement reverse proxies using this Apache module.

Control panels

There are several free and/or GPL-licensed control panel utilities for managing multiple servers on a single physical server or cluster of servers running Debian/Ubuntu-based servers. Here is a brief overview.

  • Webmin is the most widely used web browser-based free open source web hosting control panel for Linux.
  • GNUPanel is a free GPL-licensed web hosting control panel system that is compatible with Debian/Ubuntu OS using PHP.
  • Web-cp.net is a free GPL-licensed web hosting control panel system that is compatible with Debian/Ubuntu OS using PHP.

Media servers

See this Linux Planet article recommending open source Linux media servers, including MediaTomb (also see Ubuntu Community help -- MediaTomb), Jinzora (also see here), Wizd, Firefly (now forked as forked-daapd), and MythTV.

Network Attached Servers

  • Here are some user-contributed suggestions regarding commercially available NAS/RAID devices.

FreeNAS

FreeNAS allows a PC with several hard drives to function as a self-contained network attached storage RAID device. It is a very small, fast system, so that an older PCs could function quite well as an NAS.

Setup RAID in Ubuntu/Kubuntu

See this thread for a discussion how to set up RAID on an Ubuntu/Kubuntu server.

Databases

There are several free enterprise-strength databases that can be used in (K)Ubuntu Linux.

PostgreSQL

PostgreSQL is a free standards-compliant enterprise-strength open-source database, initially developed at UC Berkeley. See the PostgreSQL Server documentation for server configuration information. Install using the dummy task:

sudo apt-get install tasksel
sudo tasksel postgresql-server
or install directly:
sudo apt-get install postgresql-8.4
or
sudo apt-get install postgresql

MySQL

MySQL is one of the most widely-used relational databases, and has been licensed under the GPLv2. It has now been bought by Oracle as part of the purchase of Sun. It has long been integrated into co-ordinated server platforms using the LAMP stack, but it can also be installed separately.

sudo apt-get install mysql-server

MariaDB

Since the purchase of MySQL by Oracle, an effort to maintain a true community-driven replacement for MySQL has emerged in the form of MariaDB, whose lead developer is the founder of the original MySQL. It is touted as a drop-in replacement for MySQL on a verion-by-version basis. (See this comparison.) Installation is from the MariaDB repositories. For example, to install MariaDB version 10.0:

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
sudo add-apt-repository 'deb http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu saucy main'
sudo apt-get update
sudo apt-get install mariadb-server
Note: Key servers often use port 11371. Make sure your firewall allows port 11371 to be open.
  • This page includes these steps to add required dependencies:
sudo apt-get install libmariadbclient-dev libmariadbclient18 libmariadbd-dev libmysqlclient18 mariadb-client
sudo apt-get install mariadb-client-5.5 mariadb-client-core-5.5 mariadb-common mariadb-server mariadb-server-5.5 
sudo apt-get install mariadb-server-core-5.5 mariadb-test mariadb-test-5.5 mysql-common
sudo /etc/init.d/mysql start
  • This page recommends immediately securing the database: "Secure MariaDB by the mysql_secure_installation command and configure:"
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y
Personal tools
Sponsor
Going Tribal