<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Primirily, remember send the emails to the list to, because another user may have the same problem or help you.<br>
<br>
In Ubuntu, the user "apache" is not created when apache is installed. You need execute this comand as root:<br>
<br>
groupadd apache<br>
useradd apache -g apache<br>
<br>
Then you need to edit the apache2.conf file and change these lines:<br>
<br>
#User ${APACHE_RUN_USER}<br>
#Group ${APACHE_RUN_GROUP}<br>
<br>
by<br>
<br>
User apache<br>
Group apache<br>
<br>
Finally restart the apache service and change the owner and permissions over the pgpoolAdmin tool.<br>
<br>
Regards.<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">I had installed apache using this command apt-get install apache2<br>but the "apache" user didnt created<br><br>On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam@uci.cu> wrote:<br>> Steps for enabling the access of apache user to postgres server: (Proved in<br>> CentOS)<br>><br>> Usually, the apache user is no login user. You need edit the file<br>> /etc/passwd and change this line as root user:<br>><br>> apache:x:48:48:Apache:/var/www:/sbin/nologin<br>><br>> by<br>><br>> apache:x:48:48:Apache:/var/www:/bin/bash<br>><br>> Then, as root user, you need to execute these command:<br>><br>> mkdir /var/www/.ssh<br>> chown apache /var/www/.ssh<br>> su - apache<br>> ssh-keygen<br>><br>> Finally, copy the generated file id_rsa.pub, to postgres user home directory<br>> in the postgresql servers.<br>><br>> ssh-copy-id -i ~/.ssh/id_rsa.pub postgres@server_address<br>><br>> Then, try to copy any file as apache user from apache server to postgresql<br>> server.<br>><br>> Regards.<br>><br>> ----- Mensaje original -----<br>><br>>> How to add /var/www/.ssh/id_rsa.pub to<br>>> /home/postggres/.ssh/authorized_keys on osspc17 and osspc18?<br>><br>>> On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam@uci.cu> wrote:<br>>> > The user "apache" is created when you install the apache server (in<br>>> > CentOS<br>>> > httpd). This step is used if you going to use the pgpoolAdmin tool,<br>>> > because<br>>> > this tool is developed in PHP running under apache server, for this<br>>> > reason<br>>> > the user "apache" needs permission over the pgpool's configuration<br>>> > files.<br>>> ><br>>> > Regards.<br>>> ><br>>> > ----- Mensaje original -----<br>>> ><br>>> >> From here:<br>>> >> #cp /some/where/pgpool.conf /usr/local/etc<br>>> >> # chown apache /usr/local/etc/pgpool.conf<br>>> >> # cp /some/where/pcp.conf /usr/local/etc<br>>> >> # chown apache /usr/local/etc/pcp.conf<br>>> ><br>>> >> Do i need to create an apache user?<br>>> >> Sorry, i'm very new in this particular field.<br>>> ><br>>> >> On 5/29/12, Guillaume Lelarge <guillaume@lelarge.info> wrote:<br>>> >> > On Tue, 2012-05-29 at 16:17 +0800, Freddy Liaw wrote:<br>>> >> >> Hi,<br>>> >> >><br>>> >> >> I am following this guide to do my configuration<br>>> >> >> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/index.html<br>>> >> >><br>>> >> >> I get problem start from the Installing pgpool-II section<br>>> >> ><br>>> >> > If you want us to help you, you need to tell much more. Read<br>>> >> > this:<br>>> >> > http://wiki.postgresql.org/wiki/Guide_to_reporting_problems<br>>> >> ><br>>> >> > That may help you to report problems in a better way.<br>>> >> ><br>>> >> > Regards.<br>>> >> ><br>>> >> ><br>>> >> > --<br>>> >> > Guillaume<br>>> >> > http://blog.guillaume.lelarge.info<br>>> >> > http://www.dalibo.com<br>>> >> ><br>>> >> ><br>>> ><br>>> >> --<br>>> >> Best Regards,<br>>> >> Freddy<br>>> >> _______________________________________________<br>>> >> pgpool-general mailing list<br>>> >> pgpool-general@pgpool.net<br>>> >> http://www.pgpool.net/mailman/listinfo/pgpool-general<br>>> ><br>>> >> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>> >> INFORMATICAS...<br>>> >> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>>> ><br>>> >> http://www.uci.cu<br>>> >> http://www.facebook.com/universidad.uci<br>>> >> http://www.flickr.com/photos/universidad_uci<br>>> ><br>>> ><br>>> > 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>> > INFORMATICAS...<br>>> > CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>>> ><br>>> > http://www.uci.cu<br>>> > http://www.facebook.com/universidad.uci<br>>> > http://www.flickr.com/photos/universidad_uci<br>><br>>> --<br>>> Best Regards,<br>>> Freddy<br>><br>>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>> INFORMATICAS...<br>>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>><br>>> http://www.uci.cu<br>>> http://www.facebook.com/universidad.uci<br>>> http://www.flickr.com/photos/universidad_uci<br>><br>><br>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>> INFORMATICAS...<br>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>><br>> http://www.uci.cu<br>> http://www.facebook.com/universidad.uci<br>> http://www.flickr.com/photos/universidad_uci<br><br><br>-- <br>Best Regards,<br>Freddy<br><br>10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br><br>http://www.uci.cu<br>http://www.facebook.com/universidad.uci<br>http://www.flickr.com/photos/universidad_uci<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>