Ubuntu Server Cookbook

Ubuntu Server Cookbook

By : Uday Sawant

Buy this Book

Ubuntu Server Cookbook

By: Uday Sawant

Buy this Book

Overview of this book

Ubuntu is one of the most secure operating systems and defines the highest level of security as compared other operating system. Ubuntu server is a popular Linux distribution and the first choice when deploying a Linux server. It can be used with a $35 Raspberry Pi to top-notch, thousand-dollar-per-month cloud hardware. Built with lists that there are 4 million + websites built using Ubuntu. With its easy-to-use package management tools and availability of well-known packages, we can quickly set up our own services such as web servers and database servers using Ubuntu. This book will help you develop the skills required to set up high performance and secure services with open source tools. Starting from user management and an in-depth look at networking, we then move on to cover the installation and management of web servers and database servers, as well as load balancing various services. You will quickly learn to set up your own cloud and minimize costs and efforts with application containers. Next, you will get to grips with setting up a secure real-time communication system. Finally, we’ll explore source code hosting and various collaboration tools. By the end of this book, you will be able to make the most of Ubuntu’s advanced functionalities.

Ubuntu Server Cookbook

Credits

About the Author

www.PacktPub.com

Preface

Free Chapter

Managing Users and Groups

Introduction

Creating a user account

Creating user accounts in batch mode

Creating a group

Adding group members

Deleting a user account

Managing file permissions

Getting root privileges with sudo

Setting resource limits with limits.conf

Setting up public key authentication

Securing user accounts

Networking

Introduction

Connecting to a network with a static IP

Installing the DHCP server

Installing the DNS server

Hiding behind the proxy with squid

Being on time with NTP

Discussing load balancing with HAProxy

Tuning the TCP stack

Troubleshooting network connectivity

Securing remote access with OpenVPN

Securing a network with uncomplicated firewall

Securing against brute force attacks

Discussing Ubuntu security best practices

Working with Web Servers

Introduction

Installing and configuring the Apache web server

Serving dynamic contents with PHP

Hosting multiple websites with a virtual domain

Securing web traffic with HTTPS

Installing Nginx with PHP_FPM

Setting Nginx as a reverse proxy

Load balancing with Nginx

Setting HTTPs on Nginx

Benchmarking and performance tuning of Apache

Securing the web server

Troubleshooting the web server

Working with Mail Servers

Introduction

Sending e-mails with Postfix

Enabling IMAP and POP3 with Dovecot

Adding e-mail accounts

Mail filtering with spam-assassin

Troubleshooting the mail server

Installing the Zimbra mail server

Handling Databases

Introduction

Installing relational databases with MySQL

Storing and retrieving data with MySQL

Importing and exporting bulk data

Adding users and assigning access rights

Installing web access for MySQL

Setting backups

Optimizing MySQL performance – queries

Optimizing MySQL performance – configuration

Creating MySQL replicas for scaling and high availability

Troubleshooting MySQL

Installing MongoDB

Storing and retrieving data with MongoDB

Network Storage

Introduction

Installing the Samba server

Adding users to the Samba server

Installing the secure FTP server

Synchronizing files with Rsync

Performance tuning the Samba server

Troubleshooting the Samba server

Installing the Network File System

Cloud Computing

Introduction

Creating virtual machine with KVM

Managing virtual machines with virsh

Setting up your own cloud with OpenStack

Adding a cloud image to OpenStack

Launching a virtual instance with OpenStack

Installing Juju a service orchestration framework

Managing services with Juju

Working with Containers

Introduction

Installing LXD, the Linux container daemon

Deploying your first container with LXD

Managing LXD containers

Managing LXD containers – advanced options

Setting resource limits on LXD containers

Networking with LXD

Installing Docker

Starting and managing Docker containers

Creating images with a Dockerfile

Understanding Docker volumes

Deploying WordPress using a Docker network

Monitoring Docker containers

Securing Docker containers

Streaming with Ampache

Introduction

Installing the Ampache server

Uploading contents and creating catalogs

Setting on-the-fly transcoding

Enabling API access for remote streaming

Streaming music with Ampache

Communication Server with XMPP

Introduction

Installing Ejabberd

Creating users and connecting with the XMPP client

Configuring the Ejabberd installation

Creating web client with Strophe.js

Enabling group chat

Chat server with Node.js

Git Hosting

Introduction

Installing Git

Creating a local repository with Git CLI

Storing file revisions with Git commit

Synchronizing the repository with a remote server

Receiving updates with Git pull

Creating repository clones

Installing GitLab, your own Git hosting

Adding users to the GitLab server

Creating a repository with GitLab

Automating common tasks with Git hooks

Collaboration Tools

Introduction

Installing the VNC server

Installing Hackpad, a collaborative document editor

Installing Mattermost – a self-hosted slack alternative

Installing OwnCloud, self-hosted cloud storage

Performance Monitoring

Introduction

Monitoring the CPU

Monitoring memory and swap

Monitoring the network

Monitoring storage

Setting performance benchmarks

Centralized Authentication Service

Introduction

Installing OpenLDAP

Installing phpLDAPadmin

Ubuntu server logins with LDAP

Authenticating Ejabberd users with LDAP

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Storing and retrieving data with MySQL

In this recipe, we will learn how to create databases and tables and store data in those tables. We will learn the basic Structured Query Language (SQL) required for working with MySQL. We will focus on using the command-line MySQL client for this tutorial, but you can use the same queries with any client software or code.

Getting ready

Ensure that the MySQL server is installed and running. You will need administrative access to the MySQL server. Alternatively, you can use the root account of MySQL.

How to do it…

Follow these steps to store and retrieve data with MySQL:

First, we will need to connect to the MySQL server. Replace admin with a user account on the MySQL server. You can use root as well but it’s not recommended:
```
$ mysql -u admin -h localhost -p
```
When prompted, enter the password for the admin account. If the password is correct, you will see the following MySQL prompt:
Create a database with the following query. Note the semi-colon at the end...

Ubuntu Server Cookbook

By : Uday Sawant

Ubuntu Server Cookbook

By: Uday Sawant

Overview of this book

Related Content you might be interested in

Current Title:

Ubuntu Server Cookbook

Storing and retrieving data with MySQL

Getting ready

How to do it…