|
| From: | Geordie |
| Subject: | [Gnumed-devel] pg_hba.conf, pg_ident.conf, dh-install_gnumed_server.sh, v , net_install-gnumed_server.sh, v |
| Date: | Thu, 21 Aug 2008 22:30:14 -0400 |
| User-agent: | KMail/1.9.9 |
|
Karsten Here I go again is mailx important for I do not have it installed /net_install-gnumed_server.sh address@hidden:/home/Geordie# #!/bin/bash address@hidden:/home/Geordie# address@hidden:/home/Geordie# # ============================================ address@hidden:/home/Geordie# # $Source: /sources/gnumed/gnumed/gnumed/server/bootstrap/net_install-gnumed_server.sh,v $ address@hidden:/home/Geordie# # $Id: net_install-gnumed_server.sh,v 1.6 2008/08/01 10:38:25 ncq Exp $ address@hidden:/home/Geordie# # ============================================ address@hidden:/home/Geordie# address@hidden:/home/Geordie# # try to determine distribution of target system address@hidden:/home/Geordie# # SUSE address@hidden:/home/Geordie# if [ -f /etc/SuSE-release ]; then > DEPS="gnumed-common postgresql postgresql-plpython cron tar coreutils mailx openssl bzip2 gpg2 mc rsync python-psycopg2 gzip" > PKG_INSTALLER="zypper install" > SYS_TYPE="SuSE" > fi address@hidden:/home/Geordie# # Debian address@hidden:/home/Geordie# if [ -f /etc/debian_version ]; then > DEPS="gnumed-common postgresql postgresql-client cron anacron tar hostname coreutils mailx openssl bzip2 gzip gnupg mc rsync python-psycopg2 sudo wget" > PKG_INSTALLER="apt-get install" > SYS_TYPE="Debian" > fi address@hidden:/home/Geordie# # Mandriva address@hidden:/home/Geordie# if [ -f /etc/mandriva-release ]; then > DEPS="gnumed-common postgresql postgresql-client cron anacron tar hostname coreutils mailx openssl bzip2 gnupg mc rsync python-psycopg2 gzip" > PKG_INSTALLER="urpmi" > SYS_TYPE="Mandriva" > fi address@hidden:/home/Geordie# address@hidden:/home/Geordie# echo "" address@hidden:/home/Geordie# echo "================================================" ================================================ address@hidden:/home/Geordie# echo "This GNUmed helper will download and install the" This GNUmed helper will download and install the address@hidden:/home/Geordie# echo "latest GNUmed server onto your ${SYS_TYPE} machine." latest GNUmed server onto your Debian machine. address@hidden:/home/Geordie# echo "" address@hidden:/home/Geordie# echo "It will also take care to also install the" It will also take care to also install the address@hidden:/home/Geordie# echo "dependancies needed to operate GNUmed smoothly." dependancies needed to operate GNUmed smoothly. address@hidden:/home/Geordie# echo "================================================" ================================================ address@hidden:/home/Geordie# address@hidden:/home/Geordie# # prepare environment address@hidden:/home/Geordie# mkdir -p ~/.gnumed/server-installation/ address@hidden:/home/Geordie# cd ~/.gnumed/server-installation/ address@hidden:~/.gnumed/server-installation# rm -r GNUmed-v? address@hidden:~/.gnumed/server-installation# rm -f GNUmed-server.latest.tgz address@hidden:~/.gnumed/server-installation# address@hidden:~/.gnumed/server-installation# # install dependancies address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# echo "Installing dependancies ..." Installing dependancies ... address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# echo "Do you want to install the following dependancies" Do you want to install the following dependancies address@hidden:~/.gnumed/server-installation# echo "needed to smoothly operate the GNUmed server ?" needed to smoothly operate the GNUmed server ? address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# echo "${DEPS}" gnumed-common postgresql postgresql-client cron anacron tar hostname coreutils mailx openssl bzip2 gzip gnupg mc rsync python-psycopg2 sudo wget address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# read -e -p "Install dependancies ? [y/N]: " Install dependancies ? [y/N]: if test "${REPLY}" == "y" ; then address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# echo "You may need to enter the password for \"${USER}\" now:" You may need to enter the password for "root" now: address@hidden:~/.gnumed/server-installation# sudo ${PKG_INSTALLER} ${DEPS} Reading package lists... Done Building dependency tree Reading state information... Done gnumed-common is already the newest version. gnumed-common set to manually installed. postgresql is already the newest version. postgresql-client is already the newest version. cron is already the newest version. anacron is already the newest version. tar is already the newest version. hostname is already the newest version. coreutils is already the newest version. openssl is already the newest version. bzip2 is already the newest version. gzip is already the newest version. gnupg is already the newest version. mc is already the newest version. rsync is already the newest version. python-psycopg2 is already the newest version. python-psycopg2 set to manually installed. sudo is already the newest version. wget is already the newest version. You might want to run `apt-get -f install' to correct these: The following packages have unmet dependencies: ledgersmb: Depends: libconfig-std-perl but it is not going to be installed Depends: postgresql-client-8.1 but it is not installable or postgresql-client-8.2 but it is not installable mailx: Depends: bsd-mailx but it is not going to be installed E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution). address@hidden:~/.gnumed/server-installation# fi bash: syntax error near unexpected token `fi' address@hidden:~/.gnumed/server-installation# address@hidden:~/.gnumed/server-installation# # get and unpack package address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# echo "Downloading package ..." Downloading package ... address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# wget -c http://www.gnumed.de/downloads/server/GNUmed-server.latest.tgz --2008-08-21 21:39:10-- http://www.gnumed.de/downloads/server/GNUmed-server.latest.tgz Resolving www.gnumed.de... 213.239.197.11 Connecting to www.gnumed.de|213.239.197.11|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 565910 (553K) [application/x-gzip] Saving to: `GNUmed-server.latest.tgz' 100%[======================================>] 565,910 73.4K/s in 6.9s 2008-08-21 21:39:20 (79.8 KB/s) - `GNUmed-server.latest.tgz' saved [565910/565910] address@hidden:~/.gnumed/server-installation# tar -xzf GNUmed-server.latest.tgz address@hidden:~/.gnumed/server-installation# BASEDIR=`ls -1 -d GNUmed-v?` address@hidden:~/.gnumed/server-installation# mv -f GNUmed-server.latest.tgz ${BASEDIR}-server.tgz address@hidden:~/.gnumed/server-installation# address@hidden:~/.gnumed/server-installation# # run bootstrapper address@hidden:~/.gnumed/server-installation# cd ${BASEDIR}/server/bootstrap/ address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "" address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "Installing database ..." Installing database ... address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "" address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "The GNUmed server version \"${BASEDIR}\" has been" The GNUmed server version "GNUmed-v8" has been address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "prepared for installation in the directory" prepared for installation in the directory address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "" address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo " ["`pwd`"]" [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap] address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "" address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "The GNUmed database is about to be installed." The GNUmed database is about to be installed. address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "You may need to enter your password now:" You may need to enter your password now: address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# sudo ./bootstrap-latest.sh ln: creating symbolic link `Gnumed': File exists /root/.gnumed/server-installation/GNUmed-v8/server/bootstrap =========================================================== Bootstrapping latest GNUmed database. This will set up a GNUmed database of version v8 with the name "gnumed_v8". It contains all the currently working parts including localizations for countries you don't live in. This does not disturb the operation of the GNUmed client in your country in any way. =========================================================== 1) Dropping old baseline gnumed_v2 database if there is any. Database "gnumed_v2" will be permanently removed. Are you sure? (y/n) y Please answer "y" or "n". Are you sure? (y/n) y Password: dropdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres" ========================== 2) bootstrapping databases ################################################################################# # # log file is [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap/bootstrap-latest-v2.log] An error occurred while loading http:/root/.gnumed/server-installation/gnumed-v8/server/bootstrap/bootstrap-latest-v2.log: No hostname specified. # # Please email this file to <address@hidden> if you encounter problems. # ################################################################################# ======================================= Bootstrapping GNUmed database system... ======================================= Using config file [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap/bootstrap-local_first.conf]. You are about to install the following parts of GNUmed: ------------------------------------------------------- ------------------------------------------------------- This script can be used to run SQL files local to a site *before* bootstrapping the rest of the database. Thereby things that are only needed locally can be integrated with the bootstrapping process and need not be run manually after re-bootstrapping. It is "guaranteed" that this file will never be changed by the GNUmed team, hence keeping local modifications in a safe place. Do you really want to install this database setup ? Type yes or no: yes Using config file [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap/bootstrap-monolithic_core.conf]. You are about to install the following parts of GNUmed: ------------------------------------------------------- bundle "config" in <gnumed> (or overridden) on <> bundle "reference" in <gnumed> (or overridden) on <> bundle "demographics" in <gnumed> (or overridden) on <> bundle "clinical" in <gnumed> (or overridden) on <> bundle "documents" in <gnumed> (or overridden) on <> bundle "office" in <gnumed> (or overridden) on <> ------------------------------------------------------- This will set up a monolithic GNUmed backend with all bundles in one database named [gnumed]. It will contain the core schema without country or language-specific components. Those will have to be added by using one of the bootstrap-XX.conf file where XX represents the ISO country code. Currently this file will also import the test accounts which MUST be removed prior to real use. Do you really want to install this database setup ? Type yes or no: yes ==> bootstrapping "config" ... We are about to check whether we need to create the database user who owns all GNUmed database objects. The database owner already exists. Please provide the password previously used for it. I need the password for the GNUmed database user [gm-dbo]. Please type password: Cannot bootstrap bundles. Please check the log file for details. Bootstrapping "gnumed_v2" did not finish successfully. Aborting. address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# /home/Geordie/.gnumed/server-installation There is nothing and in /dh-install_gnumed_server.sh Package postgresql-8.1 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package postgresql-8.1 has no installation candidate it is flaged in red address@hidden:~# #!/bin/sh address@hidden:~# address@hidden:~# # ============================================ address@hidden:~# # $Source: /sources/gnumed/gnumed/gnumed/server/bootstrap/Attic/dh-install_gnumed_server.sh,v $ address@hidden:~# # $Id: dh-install_gnumed_server.sh,v 1.4 2007/10/02 19:13:42 shilbert Exp $ address@hidden:~# # ============================================ address@hidden:~# address@hidden:~# DEPS="gnumed-common postgresql-8.1 postgresql-client-8.1 cron anacron tar hostname coreutils mailx openssl bzip2 gnupg mc rsync python-psycopg2" address@hidden:~# address@hidden:~# echo "" address@hidden:~# echo "================================================" ================================================ address@hidden:~# echo "This GNUmed helper will download and install the" This GNUmed helper will download and install the address@hidden:~# echo "latest GNUmed server onto your Debian machine." latest GNUmed server onto your Debian machine. address@hidden:~# echo "" address@hidden:~# echo "It will also take care to also install the" It will also take care to also install the address@hidden:~# echo "dependancies needed to operate GNUmed smoothly." dependancies needed to operate GNUmed smoothly. address@hidden:~# echo "================================================" ================================================ address@hidden:~# address@hidden:~# # prepare environment address@hidden:~# mkdir -p ~/.gnumed/server-installation/ address@hidden:~# cd ~/.gnumed/server-installation/ address@hidden:~/.gnumed/server-installation# rm -r GNUmed-v? address@hidden:~/.gnumed/server-installation# rm -f address@hidden:~/.gnumed/server-installation# address@hidden:~/.gnumed/server-installation# # get and unpack package address@hidden:~/.gnumed/server-installation# wget -q http://www.gnumed.de/downloads/server/GNUmed-server.latest.tgz address@hidden:~/.gnumed/server-installation# tar -xzf GNUmed-server.latest.tgz address@hidden:~/.gnumed/server-installation# BASEDIR=`ls -1 -d GNUmed-v?` address@hidden:~/.gnumed/server-installation# mv -f GNUmed-server.latest.tgz ${BASEDIR}-server.tgz address@hidden:~/.gnumed/server-installation# address@hidden:~/.gnumed/server-installation# # install dependancies address@hidden:~/.gnumed/server-installation# echo "" address@hidden:~/.gnumed/server-installation# echo "Package dependancies are about to be installed." Package dependancies are about to be installed. address@hidden:~/.gnumed/server-installation# echo "You may need to enter your password now:" You may need to enter your password now: address@hidden:~/.gnumed/server-installation# sudo apt-get install ${DEPS} Reading package lists... Done Building dependency tree Reading state information... Done gnumed-common is already the newest version. gnumed-common set to manually installed. Package postgresql-8.1 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package postgresql-8.1 has no installation candidate is this a problem? address@hidden:~/.gnumed/server-installation# address@hidden:~/.gnumed/server-installation# # run bootstrapper address@hidden:~/.gnumed/server-installation# cd ${BASEDIR}/server/bootstrap/ address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "" address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "The GNUmed server version \"${BASEDIR}\" has been" The GNUmed server version "GNUmed-v8" has been address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "prepared for installation in the directory" prepared for installation in the directory address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "" address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo " ["`pwd`"]" [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap] address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "" address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "The GNUmed database is about to be installed." The GNUmed database is about to be installed. address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# echo "You may need to enter your password now:" You may need to enter your password now: address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap# sudo ./bootstrap-latest.sh ln: creating symbolic link `Gnumed': File exists /root/.gnumed/server-installation/GNUmed-v8/server/bootstrap =========================================================== Bootstrapping latest GNUmed database. This will set up a GNUmed database of version v8 with the name "gnumed_v8". It contains all the currently working parts including localizations for countries you don't live in. This does not disturb the operation of the GNUmed client in your country in any way. =========================================================== 1) Dropping old baseline gnumed_v2 database if there is any. Database "gnumed_v2" will be permanently removed. Are you sure? (y/n) y Please answer "y" or "n". Are you sure? (y/n) y Password: dropdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres" ========================== 2) bootstrapping databases ################################################################################# # # log file is [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap/bootstrap-latest-v2.log] An error occurred while loading http:/root/.gnumed/server-installation/gnumed-v8/server/bootstrap/bootstrap-latest-v2.log: No hostname specified. # # Please email this file to <address@hidden> if you encounter problems. # ################################################################################# ======================================= Bootstrapping GNUmed database system... ======================================= Using config file [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap/bootstrap-local_first.conf]. You are about to install the following parts of GNUmed: ------------------------------------------------------- ------------------------------------------------------- This script can be used to run SQL files local to a site *before* bootstrapping the rest of the database. Thereby things that are only needed locally can be integrated with the bootstrapping process and need not be run manually after re-bootstrapping. It is "guaranteed" that this file will never be changed by the GNUmed team, hence keeping local modifications in a safe place. Do you really want to install this database setup ? Type yes or no: yes Using config file [/root/.gnumed/server-installation/GNUmed-v8/server/bootstrap/bootstrap-monolithic_core.conf]. You are about to install the following parts of GNUmed: ------------------------------------------------------- bundle "config" in <gnumed> (or overridden) on <> bundle "reference" in <gnumed> (or overridden) on <> bundle "demographics" in <gnumed> (or overridden) on <> bundle "clinical" in <gnumed> (or overridden) on <> bundle "documents" in <gnumed> (or overridden) on <> bundle "office" in <gnumed> (or overridden) on <> ------------------------------------------------------- This will set up a monolithic GNUmed backend with all bundles in one database named [gnumed]. It will contain the core schema without country or language-specific components. Those will have to be added by using one of the bootstrap-XX.conf file where XX represents the ISO country code. Currently this file will also import the test accounts which MUST be removed prior to real use. Do you really want to install this database setup ? Type yes or no: yes ==> bootstrapping "config" ... We are about to check whether we need to create the database user who owns all GNUmed database objects. The database owner already exists. Please provide the password previously used for it. I need the password for the GNUmed database user [gm-dbo]. Please type password: Cannot bootstrap bundles. Please check the log file for details. Bootstrapping "gnumed_v2" did not finish successfully. Aborting. /home/Geordie/.gnumed/server-installation has nothing in it [sudo] password for Geordie: Geordie is not in the sudoers file. This incident will be reported. I will report that I put Geordie in the sodoers list at least I think I formatted right address@hidden:~/.gnumed/server-installation$ address@hidden:~/.gnumed/server-installation$ #!/bin/bash address@hidden:~/.gnumed/server-installation$ address@hidden:~/.gnumed/server-installation$ # ============================================ address@hidden:~/.gnumed/server-installation$ # $Source: /sources/gnumed/gnumed/gnumed/server/bootstrap/net_install-gnumed_server.sh,v $ address@hidden:~/.gnumed/server-installation$ # $Id: net_install-gnumed_server.sh,v 1.6 2008/08/01 10:38:25 ncq Exp $ address@hidden:~/.gnumed/server-installation$ # ============================================ address@hidden:~/.gnumed/server-installation$ address@hidden:~/.gnumed/server-installation$ # try to determine distribution of target system address@hidden:~/.gnumed/server-installation$ # SUSE address@hidden:~/.gnumed/server-installation$ if [ -f /etc/SuSE-release ]; then > DEPS="gnumed-common postgresql postgresql-plpython cron tar coreutils mailx openssl bzip2 gpg2 mc rsync python-psycopg2 gzip" > PKG_INSTALLER="zypper install" > SYS_TYPE="SuSE" > fi address@hidden:~/.gnumed/server-installation$ # Debian address@hidden:~/.gnumed/server-installation$ if [ -f /etc/debian_version ]; then > DEPS="gnumed-common postgresql postgresql-client cron anacron tar hostname coreutils mailx openssl bzip2 gzip gnupg mc rsync python-psycopg2 sudo wget" > PKG_INSTALLER="apt-get install" > SYS_TYPE="Debian" > fi address@hidden:~/.gnumed/server-installation$ # Mandriva address@hidden:~/.gnumed/server-installation$ if [ -f /etc/mandriva-release ]; then > DEPS="gnumed-common postgresql postgresql-client cron anacron tar hostname coreutils mailx openssl bzip2 gnupg mc rsync python-psycopg2 gzip" > PKG_INSTALLER="urpmi" > SYS_TYPE="Mandriva" > fi address@hidden:~/.gnumed/server-installation$ address@hidden:~/.gnumed/server-installation$ echo "" address@hidden:~/.gnumed/server-installation$ echo "================================================" ================================================ address@hidden:~/.gnumed/server-installation$ echo "This GNUmed helper will download and install the" This GNUmed helper will download and install the address@hidden:~/.gnumed/server-installation$ echo "latest GNUmed server onto your ${SYS_TYPE} machine." latest GNUmed server onto your Debian machine. address@hidden:~/.gnumed/server-installation$ echo "" address@hidden:~/.gnumed/server-installation$ echo "It will also take care to also install the" It will also take care to also install the address@hidden:~/.gnumed/server-installation$ echo "dependancies needed to operate GNUmed smoothly." dependancies needed to operate GNUmed smoothly. address@hidden:~/.gnumed/server-installation$ echo "================================================" ================================================ address@hidden:~/.gnumed/server-installation$ address@hidden:~/.gnumed/server-installation$ # prepare environment address@hidden:~/.gnumed/server-installation$ mkdir -p ~/.gnumed/server-installation/ address@hidden:~/.gnumed/server-installation$ cd ~/.gnumed/server-installation/ address@hidden:~/.gnumed/server-installation$ rm -r GNUmed-v? rm: cannot remove `GNUmed-v?': No such file or directory address@hidden:~/.gnumed/server-installation$ rm -f GNUmed-server.latest.tgz address@hidden:~/.gnumed/server-installation$ address@hidden:~/.gnumed/server-installation$ # install dependancies address@hidden:~/.gnumed/server-installation$ echo "" address@hidden:~/.gnumed/server-installation$ echo "Installing dependancies ..." Installing dependancies ... address@hidden:~/.gnumed/server-installation$ echo "" address@hidden:~/.gnumed/server-installation$ echo "Do you want to install the following dependancies" Do you want to install the following dependancies address@hidden:~/.gnumed/server-installation$ echo "needed to smoothly operate the GNUmed server ?" needed to smoothly operate the GNUmed server ? address@hidden:~/.gnumed/server-installation$ echo "" address@hidden:~/.gnumed/server-installation$ echo "${DEPS}" gnumed-common postgresql postgresql-client cron anacron tar hostname coreutils mailx openssl bzip2 gzip gnupg mc rsync python-psycopg2 sudo wget address@hidden:~/.gnumed/server-installation$ echo "" address@hidden:~/.gnumed/server-installation$ read -e -p "Install dependancies ? [y/N]: " Install dependancies ? [y/N]: if test "${REPLY}" == "y" ; then address@hidden:~/.gnumed/server-installation$ echo "" address@hidden:~/.gnumed/server-installation$ echo "You may need to enter the password for \"${USER}\" now:" You may need to enter the password for "Geordie" now: address@hidden:~/.gnumed/server-installation$ sudo ${PKG_INSTALLER} ${DEPS} We trust you have received the usual lecture from the local System Administrator. It usually boils down to these three things: #1) Respect the privacy of others. #2) Think before you type. #3) With great power comes great responsibility. [sudo] password for Geordie: Sorry, try again. [sudo] password for Geordie: Sorry, try again. [sudo] password for Geordie: Sorry, try again. sudo: 3 incorrect password attempts Yah I know three strikes and you are out Well that is it for my fun tonight and bye the way "postgres" I could not get to work Thanks Geordie /etc/postgresql/8.3/main/pg_ident.conf # PostgreSQL Ident Authentication Maps # ==================================== # # Refer to the PostgreSQL Administrator's Guide, chapter "Client # Authentication" for a complete description. A short synopsis # follows. # PostgreSQL user names. Records are of the form: # # MAPNAME IDENT-USERNAME PG-USERNAME # # (The uppercase quantities must be replaced by actual values.) # # MAPNAME is the (otherwise freely chosen) map name that was used in # pg_hba.conf. IDENT-USERNAME is the detected user name of the # client. PG-USERNAME is the requested PostgreSQL user name. The # existence of a record specifies that IDENT-USERNAME may connect as # PG-USERNAME. Multiple maps may be specified in this file and used # by pg_hba.conf. # # This file is read on server startup and when the postmaster receives # a SIGHUP signal. If you edit the file on a running system, you have # to SIGHUP the postmaster for the changes to take effect. You can use # "pg_ctl reload" to do that. # Put your actual configuration here gm-dbo-alikes gmadm gm-dbo postgres-alikes postgres postgres postgres-alikes gmadm postgres # ---------------------------------- # # No map names are defined in the default configuration. If all ident # user names and PostgreSQL user names are the same, you don't need # this file. Instead, use the special map name "sameuser" in # pg_hba.conf. # MAPNAME IDENT-USERNAME PG-USERNAMER /etc/postgresql/8.3/main/pg_hba.conf # PostgreSQL Client Authentication Configuration File # =================================================== # # Refer to the "Client Authentication" section in the # PostgreSQL documentation for a complete description # of this file. A short synopsis follows. # # This file controls: which hosts are allowed to connect, how clients # are authenticated, which PostgreSQL user names they can use, which # databases they can access. Records take one of these forms: # # local DATABASE USER METHOD [OPTION] # host DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION] # # (The uppercase items must be replaced by actual values.) # The first field is the connection type: "local" is a Unix-domain socket, # "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an # SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket. # # DATABASE can be "all", "sameuser", "samerole", a database name, or # a comma-separated list thereof. # # USER can be "all", a user name, a group name prefixed with "+", or # a comma-separated list thereof. In both the DATABASE and USER fields # you can also write a file name prefixed with "@" to include names from # a separate file. # # CIDR-ADDRESS specifies the set of hosts the record matches. # It is made up of an IP address and a CIDR mask that is an integer # (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies # the number of significant bits in the mask. Alternatively, you can write # an IP address and netmask in separate columns to specify the set of hosts. # # METHOD can be "trust", "reject", "md5", "crypt", "password", "gss", "sspi", # "krb5", "ident", "pam" or "ldap". Note that "password" sends passwords # in clear text; "md5" is preferred since it sends encrypted passwords. # # OPTION is the ident map or the name of the PAM service, depending on METHOD. # # Database and user names containing spaces, commas, quotes and other special # characters must be quoted. Quoting one of the keywords "all", "sameuser" or # "samerole" makes the name lose its special character, and just match a # database or username with that name. # # This file is read on server startup and when the postmaster receives # a SIGHUP signal. If you edit the file on a running system, you have # to SIGHUP the postmaster for the changes to take effect. You can use # "pg_ctl reload" to do that. # Put your actual configuration here # allow anyone knowing the proper password to log into # our GNUmed databases local samegroup +gm-logins md5 # ---------------------------------- # allow some people to impersonate "postgres" when connecting to template1 local template1 postgres ident postgres-alikes # replace N with the database version you want to install local gnumed_vN postgres ident postgres-alikes # allow real "postgres" to connect to all other databases, too local all postgres ident sameuser # allow some people to impersonate "gm-dbo" local template1 gm-dbo ident gm-dbo-alikes # # If you want to allow non-local connections, you need to add more # "host" records. In that case you will also need to make PostgreSQL listen # on a non-local interface via the listen_addresses configuration parameter, # or via the -i or -h command line switches. # # # If you want to allow non-local connections, you need to add more # "host" records. In that case you will also need to make PostgreSQL listen # on a non-local interface via the listen_addresses configuration parameter, # or via the -i or -h command line switches. # # DO NOT DISABLE! # If you change this first entry you will need to make sure that the # database # super user can access the database using some other method. # Noninteractive # access to all databases is required during automatic maintenance # (autovacuum, daily cronjob, replication, and similar tasks). # # Database administrative login by UNIX sockets local all postgres ident sameuser # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 |
| [Prev in Thread] | Current Thread | [Next in Thread] |