[pgpool-general: 566] Re: Encounter Configuration Problem

[Lazaro Ruben Garcia Martinez]

Steps for enabling the access of apache user to postgres server: (Proved in CentOS) 

Usually, the apache user is no login user. You need edit the file /etc/passwd and change this line as root user: 

apache:x:48:48:Apache:/var/www:/sbin/nologin 

by 

apache:x:48:48:Apache:/var/www:/bin/bash 

Then, as root user, you need to execute these command: 

mkdir /var/www/.ssh 
chown apache /var/www/.ssh 
su - apache 
ssh-keygen 

Finally, copy the generated file id_rsa.pub, to postgres user home directory in the postgresql servers. 

ssh-copy-id -i ~/.ssh/id_rsa.pub postgres at server_address 

Then, try to copy any file as apache user from apache server to postgresql server. 

Regards. 

----- Mensaje original -----

> How to add /var/www/.ssh/id_rsa.pub to
> /home/postggres/.ssh/authorized_keys on osspc17 and osspc18?

> On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam at uci.cu> wrote:
> > The user "apache" is created when you install the apache server (in
> > CentOS
> > httpd). This step is used if you going to use the pgpoolAdmin tool,
> > because
> > this tool is developed in PHP running under apache server, for this
> > reason
> > the user "apache" needs permission over the pgpool's configuration
> > files.
> >
> > Regards.
> >
> > ----- Mensaje original -----
> >
> >> From here:
> >> #cp /some/where/pgpool.conf /usr/local/etc
> >> # chown apache /usr/local/etc/pgpool.conf
> >> # cp /some/where/pcp.conf /usr/local/etc
> >> # chown apache /usr/local/etc/pcp.conf
> >
> >> Do i need to create an apache user?
> >> Sorry, i'm very new in this particular field.
> >
> >> On 5/29/12, Guillaume Lelarge <guillaume at lelarge.info> wrote:
> >> > On Tue, 2012-05-29 at 16:17 +0800, Freddy Liaw wrote:
> >> >> Hi,
> >> >>
> >> >> I am following this guide to do my configuration
> >> >> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/index.html
> >> >>
> >> >> I get problem start from the Installing pgpool-II section
> >> >
> >> > If you want us to help you, you need to tell much more. Read
> >> > this:
> >> > http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
> >> >
> >> > That may help you to report problems in a better way.
> >> >
> >> > Regards.
> >> >
> >> >
> >> > --
> >> > Guillaume
> >> > http://blog.guillaume.lelarge.info
> >> > http://www.dalibo.com
> >> >
> >> >
> >
> >> --
> >> Best Regards,
> >> Freddy
> >> _______________________________________________
> >> pgpool-general mailing list
> >> pgpool-general at pgpool.net
> >> http://www.pgpool.net/mailman/listinfo/pgpool-general
> >
> >> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS
> >> INFORMATICAS...
> >> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
> >
> >> http://www.uci.cu
> >> http://www.facebook.com/universidad.uci
> >> http://www.flickr.com/photos/universidad_uci
> >
> >
> > 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS
> > INFORMATICAS...
> > CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
> >
> > http://www.uci.cu
> > http://www.facebook.com/universidad.uci
> > http://www.flickr.com/photos/universidad_uci

> --
> Best Regards,
> Freddy

> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS
> INFORMATICAS...
> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

> http://www.uci.cu
> http://www.facebook.com/universidad.uci
> http://www.flickr.com/photos/universidad_uci


10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

http://www.uci.cu
http://www.facebook.com/universidad.uci
http://www.flickr.com/photos/universidad_uci
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120530/b7a06714/attachment-0001.html>