Book Image

Ubuntu Server Cookbook

By : Uday Sawant
Book Image

Ubuntu Server Cookbook

By: Uday Sawant

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.

Related Content you might be interested in

Current Title:

Small book image
Ubuntu Server Cookbook
Uday Sawant
Jun, 2016 | 456 pages
No titles found
Table of Contents (20 chapters)
Ubuntu Server Cookbook
Ubuntu Server Cookbook
Credits
Credits
About the Author
About the Author
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Managing Users and Groups
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
2
Networking
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
3
Working with Web Servers
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
4
Working with Mail Servers
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
5
Handling Databases
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
6
Network Storage
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
7
Cloud Computing
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
8
Working with Containers
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
9
Streaming with Ampache
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
10
Communication Server with XMPP
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
11
Git Hosting
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
12
Collaboration Tools
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
13
Performance Monitoring
Performance Monitoring
Introduction
Monitoring the CPU
Monitoring memory and swap
Monitoring the network
Monitoring storage
Setting performance benchmarks
14
Centralized Authentication Service
Centralized Authentication Service
Introduction
Installing OpenLDAP
Installing phpLDAPadmin
Ubuntu server logins with LDAP
Authenticating Ejabberd users with LDAP
Index
Index

Troubleshooting MySQL

In this recipe, we will look at some common problems with MySQL and learn how to solve them.

Getting ready

You will need access to a root account or an account with sudo privileges.

You will need administrative privileges on the MySQL server.

How to do it…

Follow these steps to troubleshoot MySQL:

  1. First, check if the MySQL server is running and listening for connections on the configured port:

    $ sudo service mysql status
$ sudo netstat -pltn

  2. Check MySQL logs for any error messages at /var/log/mysql.log and mysql.err.

  3. You can try to start the server in interactive mode with the verbose flag set:

    $ which mysqld
/usr/sbin/mysqld
$ sudo /usr/sbin/mysqld --user=mysql --verbose

  4. If you are accessing MySQL from a remote system, make sure that the server is set to listen on a public port. Check for bind-address in my.cnf:

    bind-address  = 10.0.247.168

  5. For any access denied errors, check if you have a user account in place and if it is allowed to log in from a specific IP address:

    mysql...
Previous Section
End of Section 12
Next Section