Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Webmin Administrator's Cookbook
  • Table Of Contents Toc
Webmin Administrator's Cookbook

Webmin Administrator's Cookbook

By : Michal Karzynski
4 (11)
Buy this Book
close
close
Webmin Administrator's Cookbook

Webmin Administrator's Cookbook

4 (11)
By: Michal Karzynski
Buy this Book

Overview of this book

Written in a cookbook format with practical recipes this book helps you to perform various administrative tasks using Webmin and enables you to perform common jobs more efficiently. This book is perfect for System administrators who want to learn more advanced concepts of Webmin and how it can help to set up a server for development, testing or deployment.
Table of Contents (19 chapters)
close
close
close
Webmin Administrator's Cookbook
Icon
Webmin Administrator's Cookbook
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Setting Up Your System
Icon
Setting Up Your System
Icon
Introduction
Icon
Installing Webmin on a Debian-based system
Icon
Installing Webmin on an RPM-based system
Icon
Installing Webmin on another system
Icon
Connecting to Webmin
Icon
Installing additional Webmin modules
Icon
Monitoring what Webmin is doing
Icon
Controlling which system services are started at boot
Icon
Inspecting the installed software packages
Icon
Installing software packages
Icon
Updating the installed packages to the latest versions
Icon
Enabling Webmin to send an e-mail
Icon
Getting an e-mail when new versions of packages become available
Icon
Reading the documentation of the installed software
2
User Management
Icon
User Management
Icon
Introduction
Icon
Creating a Webmin user
Icon
Creating a Webmin group with access to specific modules and options
Icon
Allowing users to log in to Webmin with the system credentials
Icon
Creating Webmin users based on system accounts
Icon
Controlling who is currently using Webmin
Icon
Creating a system user account
Icon
Modifying a user's UID and other information
Icon
Temporarily disabling a user account
Icon
Creating and editing a system group
Icon
Changing a user's password
Icon
Exporting users and importing them into another system
Icon
Installing Usermin
3
Securing Your System
Icon
Securing Your System
Icon
Introduction
Icon
Setting up a Linux firewall
Icon
Allowing access to a service through the firewall
Icon
Verifying your firewall by port scanning
Icon
Turning off unnecessary services
Icon
Verifying the strength of passwords
Icon
Disabling root login over SSH
Icon
Restricting Webmin access to a specific IP
Icon
Connecting to Webmin securely over an SSH tunnel
Icon
Closing inactive Webmin sessions automatically
4
Controlling Your System
Icon
Controlling Your System
Icon
Introduction
Icon
Executing a command on the server
Icon
Executing a command as another user
Icon
Setting a command to be executed in the future
Icon
Scheduling a command to run regularly with cron
Icon
Creating a panel for the commands that you execute often
Icon
Creating a panel with the database commands that you execute often
Icon
Running a terminal emulator in the browser
5
Monitoring Your System
Icon
Monitoring Your System
Icon
Introduction
Icon
Viewing and searching through system logfiles
Icon
Saving Syslog messages to a file
Icon
Adding other logfiles to Webmin
Icon
Configuring logfile rotation
Icon
Listing recent logins
Icon
Receiving an e-mail when a service stops running
Icon
Automatically restarting a service that goes down
Icon
Monitoring a remote server
6
Managing Files on Your System
Icon
Managing Files on Your System
Icon
Introduction
Icon
Downloading files from the server
Icon
Uploading files to the server
Icon
Managing files and directories on the server
Icon
Changing file ownership and permissions
Icon
Setting up network-shared folders for Windows
Icon
Mounting a Windows-shared folder
Icon
Setting up an NFS-shared volume
Icon
Mounting a remote NFS volume
Icon
Giving users access to your server via SFTP
Icon
Giving users access to your server via FTP
7
Backing Up Your System
Icon
Backing Up Your System
Icon
Introduction
Icon
Backing up configuration files
Icon
Restoring configuration files from backup
Icon
Automatically backing up configuration files
Icon
Creating a backup of a selected directory
Icon
Creating a backup of an entire mount point
Icon
Backing up to a remote host
Icon
Setting up automatic backups
Icon
Backing up databases
8
Running an Apache Web Server
Icon
Running an Apache Web Server
Icon
Introduction
Icon
Installing Apache on your system
Icon
Restarting Apache
Icon
Enabling Apache modules
Icon
Creating a static HTML site
Icon
Creating a virtual host
Icon
Setting options for directories, files, and locations
Icon
Creating a password-protected website
Icon
Displaying a listing of files in a directory
Icon
Redirecting incoming requests
Icon
Setting up encrypted websites with SSL
Icon
Logging incoming requests and errors
Icon
Analyzing logfiles using Webalizer
9
Running a MySQL Database Server
Icon
Running a MySQL Database Server
Icon
Introduction
Icon
Installing the MySQL database server
Icon
Allowing access to MySQL over the network
Icon
Accessing your MySQL server over an SSH tunnel
Icon
Creating a new database
Icon
Creating users and granting permissions to databases
Icon
Creating a backup of your database
Icon
Executing custom SQL commands
Icon
Restoring database from the backup
Icon
Editing the structure of your database
Icon
Editing records in a database
Icon
Checking who is using your database server
Icon
Installing phpMyAdmin
10
Running a PostgreSQL Database Server
chevron up
Icon
Running a PostgreSQL Database Server
Icon
Introduction
Icon
Installing the PostgreSQL database server
Icon
Locating the PostgreSQL server configuration files
Icon
Allowing access to PostgreSQL over the network
Icon
Accessing the PostgreSQL server over an SSH tunnel
Icon
Creating a new database
Icon
Creating users and granting permissions
Icon
Creating a backup of your database
Icon
Executing custom SQL commands
Icon
Restoring a database from backup
Icon
Editing the structure of your database
Icon
Editing records in a database
Icon
Installing phpPgAdmin
11
Running Web Applications
Icon
Running Web Applications
Icon
Introduction
Icon
Generating dynamic pages using CGI
Icon
Installing PHP
Icon
Changing PHP configuration settings
Icon
Displaying PHP errors while debugging
Icon
Logging in PHP
Icon
Installing WordPress on your server
Icon
Installing Drupal on your server
Icon
Installing a Django-based application using mod_wsgi
12
Setting Up an E-mail Server
Icon
Setting Up an E-mail Server
Icon
Introduction
Icon
Setting up your server to send and receive e-mails
Icon
Setting up secure IMAP access to mailboxes
Icon
Setting up a secure SMTP relay for users
Icon
Controlling the mail queue
Icon
Reading and writing e-mails on the server
Icon
Configuring e-mail aliases
Icon
Filtering incoming mail using Procmail and SpamAssassin
Icon
Debugging e-mail-related problems
1
Index
Icon
Index

Chapter 10. Running a PostgreSQL Database Server

In this chapter, we will cover the following recipes:

  • Installing the PostgreSQL database server

  • Locating the PostgreSQL server configuration files

  • Allowing access to PostgreSQL over the network

  • Accessing the PostgreSQL server over an SSH tunnel

  • Creating a new database

  • Creating users and granting permissions

  • Creating a backup of your database

  • Executing custom SQL commands

  • Restoring a database from backup

  • Editing the structure of your database

  • Editing records in a database

  • Installing phpPgAdmin

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Webmin Administrator's Cookbook
End of Section 10
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon