Send Gnumed-devel mailing list submissions to
address@hidden
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.gnu.org/mailman/listinfo/gnumed-devel
or, via email, send a message with subject or body 'help' to
address@hidden
You can reach the person managing the list at
address@hidden
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Gnumed-devel digest..."
Today's Topics:
1.
Changes in "pg_hba.conf" between postgresql versions 7.3.2 & 7.2.2
(Michael Bonert)
2. Gnumed Providers (Dr. Jones)
3. Re: Gnumed Providers (Horst Herb)
4.
Re: Changes in "pg_hba.conf" between postgresql versions 7.3.2 &
7.2.2 (Andreas Tille)
5. Re: Gnumed Providers (Karsten Hilbert)
6. Re: Re: Changes in "pg_hba.conf" between postgresql
versions 7.3.2 & 7.2.2 (Karsten Hilbert)
7.
Re: Changes in "pg_hba.conf" between postgresql versions 7.3.2 &
7.2.2 (Andreas Tille)
8. Re: Gnumed Providers (Andreas Tille)
----------------------------------------------------------------------
Date: Tue, 17 Jun 2003 20:52:01 -0400 (EDT)
From: Michael Bonert <address@hidden>
To: gnumed-devel <address@hidden>
Subject: [Gnumed-devel]
Changes in "pg_hba.conf" between postgresql versions 7.3.2 & 7.2.2
Message-ID: <address@hidden>
Content-Type: TEXT/PLAIN; charset=US-ASCII
MIME-Version: 1.0
Precedence: list
Message: 1
I recently installed gnumed on Mandrake 9.0 again (which has an older
version of postgresql than Mandrake 9.1). In doing this I noticed that
the critical part of "pg_hba.conf" differs between version 7.3.2 and
7.2.2. If you're upgrading from 7.2.2 to 7.3.2... I imagine this could
cause problems.
Here they are side-by-side:
-----
Postgresql 7.3.2 (Mandrake 9.1)
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
-----
Postgresql 7.2.2 (Mandrake 9.0)
local all trust
host all 127.0.0.1 255.255.255.255 trust
------------------------------
Date: Tue, 17 Jun 2003 23:52:58 -0600
From: "Dr. Jones" <address@hidden>
To: <address@hidden>
Subject: [Gnumed-devel] Gnumed Providers
Message-ID: <address@hidden>
References: <address@hidden>
Content-Type: text/plain;
charset="iso-8859-1"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: list
Reply-To: "Dr. Jones" <address@hidden>
Message: 2
I am hoping to find other gnumed users who are providers. I realize that
most on the list here are developers, but am hoping a few are actual
providers, dealing directly with patients instead of just with the the
patient data.
Please write me if you are a provider!
Scott
------------------------------
Date: Wed, 18 Jun 2003 16:07:54 +1000
From: Horst Herb <address@hidden>
To: "Dr. Jones" <address@hidden>
Cc: address@hidden
Subject: Re: [Gnumed-devel] Gnumed Providers
Message-ID: <address@hidden>
In-Reply-To: <address@hidden>
References: <address@hidden>
<address@hidden>
Content-Type: text/plain;
charset="iso-8859-1"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: list
Message: 3
On Wed, 18 Jun 2003 15:52, Dr. Jones wrote:
I am hoping to find other gnumed users who are providers. I realize that
most on the list here are developers, but am hoping a few are actual
providers, dealing directly with patients instead of just with the the
patient data.
Please write me if you are a provider!
I believe you are mistaken. I myself am the Principal of a busy rural general
practice, originally trained as a General Surgeon.
Karsten Hilbert is a doctor currently working in A&E,
Richard Terry a seasoned G.P. as well,
Tony Lemke and David Guest both Australian GPs,
Ian Haywood an Intern and so forth -
in reality, most of the gnumedders are qualified and practising medical
doctors, some of us with dual qualifications in IT as well. We want gnumed to
happen in our own practises and hospitals.
Horst
------------------------------
Date: Wed, 18 Jun 2003 11:13:36 +0200 (CEST)
From: Andreas Tille <address@hidden>
To: Michael Bonert <address@hidden>
Cc: gnumed-devel <address@hidden>
Subject: [Gnumed-devel]
Re: Changes in "pg_hba.conf" between postgresql versions 7.3.2 &
7.2.2
Message-ID: <address@hidden>
In-Reply-To: <address@hidden>
Content-Type: TEXT/PLAIN; charset=US-ASCII
MIME-Version: 1.0
Precedence: list
Message: 4
On Tue, 17 Jun 2003, Michael Bonert wrote:
Here they are side-by-side:
-----
Postgresql 7.3.2 (Mandrake 9.1)
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
-----
Postgresql 7.2.2 (Mandrake 9.0)
local all trust
host all 127.0.0.1 255.255.255.255 trust
While I have no doubt that this works I decided to open not all rights when
I builded the GnuMed Debian packages.
At first I exclusively use sockets for the connection. This would leave just
the lines containing 'local' in the beginning. The lines started with 'host'
can be removed.
Moreover I think allowing authentification TRUST for *all* databases is more
than we want and the number of users can also be reduced. The databases we
connect to are at first template1. This is done by the password method and
this leads to the line
local template1 @gmTemplate1User.list password
(for PostgreSQL 7.3.* !! - no tests for 7.2 so far)
The syntax starting with @ for the user means that the users which are allowed
to connect are stored in a file $PGDATA/gmTemplate1User.list and thus I
have a file
~# cat /var/lib/postgres/data/gmTemplate1User.list
gm-dbowner
on my box. Once the gnumed-test database is created the user gm-dbowner has
to connect also to this database. After some discussion with Karsten Hilbert
we found no better way than to use TRUST here. This leads to the line
local gnumed-test @gmTemplate1User.list trust
which enables all users listed in /var/lib/postgres/data/gmTemplate1User.list
to access database gnumed-test from localhost.
In my opinion these settings are the most restrictive settings to get the
database bootstrapped.
If local users want to *access* the database we need a further line for
pg_hba.conf:
local gnumed-test @gmGnumedUser.list password
~# cat /var/lib/postgres/data/gmGnumedUser.list
gm-dbowner
test-doc
_test-doc
so all users who want to *run* GnuMed on localhost have to be listed in this
file to enable password authentication to gnumed-test for them. The settings
above are quite insecure in my opinion and so I would like you to try this.
Kind regards
Andreas.
------------------------------
Date: Wed, 18 Jun 2003 11:04:54 +0200
From: Karsten Hilbert <address@hidden>
To: address@hidden
Subject: Re: [Gnumed-devel] Gnumed Providers
Message-ID: <address@hidden>
In-Reply-To: <address@hidden>
References: <address@hidden>
<address@hidden>
Content-Type: text/plain; charset=us-ascii
MIME-Version: 1.0
Precedence: list
Message: 5
Karsten Hilbert is a doctor currently working in A&E,
Actually in an A&E-like surgical practice. It is supposed to
be an A&E at night but during after-hours often turns into a
convenient GP practice for people too lazy to go to the doctor
during business hours. During the day I now also work at a
paediatric practice.
So, plenty of doctors in here, I suppose :-))
Karsten