[Genex-users] Re:

[Harry M. <hj...@ta...>]

Hi Hrishi,

Good point of clarification.

If you install postgres as per the apt-get line you mention in 1), you should 
not have to do much else, besides following the instructions in the section marked:


Modify configuration files:
===========================
1- ...

2 - modify the Postgresql config file for GeneX:

which tells you how to modify the PG config file.

The lines:
 >    For the basic postgres installation, please see:
 >    http://www.postgresql.org/docs/7.4/interactive/installation.html

point you to the documentation that tell you how to do the basic postgres 
installation.  (You should understand the basics of how the system works.)
However the specifics are mentioned in the postgres stanza

hde...@gm... wrote:
> Hi Harry,
> 
> Couple of  "silly" questions:
> 
> I have been following the instructions/guidelines given in the INSTALL documnet in the latest genex-server dir (did svn .............)
> 
> 1) I did:
> The following commands pasted into a root shell will install most of 
> the pre-requisites you need to support GeneX :
> 
> apt-get update
> 
> apt-get install  postgresql postgresql-dev postgresql-client postgresql-doc \
>  libpgtcl libpgperl pgaccess unixodbc-bin expat perlSGML apache-dev \
>  libapache-mod-perl libdevel-symdump-perl odbc-postgresql libpgjava \
>  perl-modules libterm-readkey-perl libapache-session-perl \
>  libapache-request-perl  libdbd-pg-perl libdbi-perl \
>  libhtml-mason-perl libtie-ixhash-perl libxml-xerces-perl r-base-core \
>  r-recommended r-base r-base-dev r-base-html odbc-postgresql libiodbc2 \
>  unixodbc libpgjava pgaccess unixodbc-bin postgresql-client postgresql-doc \
>  libecpg-dev libpgtcl libdbd-pgsql 
> 
> Now the question is do i have to install postgresql , as per the instructions given @
> 2 - modify the Postgresql config file for GeneX:
> 
>    For the basic postgres installation, please see:
>    http://www.postgresql.org/docs/7.4/interactive/installation.html
> 
> OR does it mean that when i did step (1) postgresql was installed and i can skip the link and what it says??!!
> 
> Now at the step of enabling GeneX2 DB for remote access via TCP, 
one IP is the local host, the second IP should be the IP of the machine
on which genex is being installed?!

The paragraph below that tells what the 2 numbers are:


# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
host    all         all         127.0.0.1         255.255.255.255   password
host    genex       all         192.168.1.0       255.255.255.0     password

    In the above example, the first line allows all users from the local machine
    to access all databases as long as they provide valid passwords.  The second
    line allows machines from a private subnet (192.168.1.0, masked
    255.255.255.0) to access only the genex DB and only if they are known
    postgres users and  supply the correct postgresql password.  There are more
    (and less) stringent  authentication schemes described in the comments in
    'pg_hba.conf'.
    The two net address fields specify to which client machines a host  or
    hostssl   record applies, based on their IP address.  The precise logic
    is that the (actual-IP-address XOR IP-address-field) AND IP-mask-field must
    be zero for the record to match.

> 
> Trivial/silly, i thought it was good to clarify just in case and may be add a 
line or two in the INSTALL doc that resolves these "silly" questions.

what part of the above is unclear?  Did you read the comments in the pg_hba.conf 
file?  I admit, it's not drop-dead simple, but it's the way postgres works and 
if you don't understand the postgres basics, you won't be able to administer the 
system.


> 
> Waiting for your reply.
> 
> Thanks,
> Hrishi
> 
> 
> 
> 
> 

-- 
Cheers, Harry
Harry J Mangalam - 949 856 2847 (v&f) - hj...@ta...
             <<plain text preferred>>