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

Thu May 31 21:30:31 JST 2012

Primirily, remember send the emails to the list to, because another user may have the same problem or help you. 

In Ubuntu, the user "apache" is not created when apache is installed. You need execute this comand as root: 

groupadd apache 
useradd apache -g apache 

Then you need to edit the apache2.conf file and change these lines: 

#User ${APACHE_RUN_USER} 
#Group ${APACHE_RUN_GROUP} 

by 

User apache 
Group apache 

Finally restart the apache service and change the owner and permissions over the pgpoolAdmin tool. 

Regards. 

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

> I had installed apache using this command apt-get install apache2
> but the "apache" user didnt created

> On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam at uci.cu> wrote:
> > 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

> --
> 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/20120531/659998df/attachment.html>