book

CentOS 6 Linux Server Cookbook

by Jonathan Hobson

April 2013

Beginner

374 pages

8h 14m

English

Packt Publishing

Read now

Unlock full access

Support files, eBooks, discount offers and moreWhy Subscribe?Free Access for Packt account holders
What this book covers

ErrataPiracyQuestions
Introduction
Getting readyHow to do it...How it works…See also
Getting readyHow to do it...How it works…See also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...
Introduction
Getting readyHow to do it...How it works...There's more...Linking time and location
Getting readyHow to do it...How it works...There's more...Synchronizing multiple machinesModifying the logfile's locationFudging timeSee also
Getting readyHow to do it...How it works...There's more...Substituting the Netmask value with a prefixFinding your HWADDR/MAC address
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...There's more...
Introduction
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...
Introduction
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...See also
Introduction
Getting readyHow to do it...How it works...There's more...Change the default timeout
Getting readyHow to do it...How it works...There's more...Changing the SSH port number of your serverLimiting SSH access by user or groupSee also
Getting readyHow to do it...How it works...There's more...Allowing an IP addressBanning an IP addressSee also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...Unblocking an IP addressSee also
Getting readyHow to do it...How it works...There's more...See also...
Introduction
Getting readyHow to do it...How it works...There's more...Disable printing support in SambaRelaxing the rules for SELinuxOpening the firewallAssigning the master browserSee also
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...Controlling access and enabling a write list for specific users or groupsEnabling guest-only access to a custom share folderSee also
Introduction
Getting readyHow to do it...How it works...There's more...Enabling access to a DNS server from behind a firewallCleaning expired recordsSee also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...See also
Introduction
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...Reviewing and revoking permissions or dropping a userSee also
Getting readyHow to do it...How it works...There's more...Connecting to PostgreSQLAccessing a PostgreSQL database using psqlCreating a copy of a database in PostgreSQLSee also
Getting readyHow to do it...How it works...See also
Introduction
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...There's more...Setting up e-mail softwareSee also
Getting readyHow to do it...How it works...There's more...Setting up e-mail software with SMTP authenticationSee also
Getting readyHow to do it...How it works...There's more...Setting up a catch-all e-mail address for a virtual domainSee also
Introduction
Getting readyHow to do it...How it works...There's more...Running a CGI/Perl scriptActivating ModPerl::PerlRunSee also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...There's more...Reinstating suexecSee also
Getting readyHow to do it...How it works...There's more...See also
Getting readyHow to do it...How it works...See also
Introduction
Getting readyHow to do it...How it works...There's more...Changing the default time-outBanning a user from the FTP serviceCustomizing the bannerSee also
Getting readyHow to do it...How it works...See also
Getting readyHow to do it...How it works...There's more...
Getting readyHow to do it...How it works...There's more...

Content preview from CentOS 6 Linux Server Cookbook

Configuring remote access to PostgreSQL

In this recipe we will learn how to configure local and remote access to PostgreSQL.

PostgreSQL can be configured to allow remote access and yet it is not always obvious how this can be achieved. PostgreSQL employs a method called Host Based Authentication and it is the purpose of this recipe to show you how to troubleshoot client authentication in order to provide the access rights you need to run a safe and secure database server.

Getting ready

To complete this recipe you will require a working installation of the CentOS 6 operating system with root privileges and a text editor of your choice. It is expected that PostgreSQL is already installed and running.