Re: problem on test perlu trigger function. - Mailing list pgsql-interfaces

From Piaff33z
Subject Re: problem on test perlu trigger function.
Date
Msg-id 4AA2A589.9020405@gmail.com
Whole thread Raw
In response to Re: problem on test perlu trigger function.  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-interfaces
<span class="moz-smiley-s6"><span> :-[   </span></span> I am stupid, it is obvious !<br /><br /> Really you are right
<spanclass="moz-smiley-s5"><span> :-D </span></span>, script is thrown with the rights of account postgres and it does
nothave the rights to browse this directory ...<br /> Your proposal of the "mkdir -p" seems to me the better solution
!<br/><br /> Still thank you for this analysis !<br /><br /> However, i have an other problem and I am going to open
newthread. And that there seems to me a little more crooked...<br /><br /> Vic   <span class="moz-smiley-s1"><span> :-)
</span></span><br/><br /> Greg Sabino Mullane a écrit : <blockquote
cite="mid:6f8c66fd5a3c12667eff14d54a398d70@biglumber.com"type="cite"><pre wrap="">-----BEGIN PGP SIGNED MESSAGE-----
 
Hash: RIPEMD160

 </pre><blockquote type="cite"><pre wrap="">if (! -d  "$PATHBASE/$_TD->{new}{categorie}") {        `sudo -u http
mkdir"$PATHBASE/$_TD->{new}{categorie}"`;     }   </pre></blockquote><pre wrap=""> </pre><blockquote
type="cite"><prewrap="">Sudo function is performed in spite of the presence of directory ! It as
 
if  "-d" serve has nothing...

Anybody knows why?   </pre></blockquote><pre wrap="">
Because the directory is created and owned by the http user, but is not
visible to the process that runs this function (postgres). One solution
would be to skip the test and call mkdir -p. Another would be to set
the permissions so that the postgres user can see the directories
inside of $PATHBASE.

- --
Greg Sabino Mullane <a class="moz-txt-link-abbreviated" href="mailto:greg@turnstep.com">greg@turnstep.com</a>
End Point Corporation
PGP Key: 0x14964AC8 200909050729
<a class="moz-txt-link-freetext"
href="http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8">http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8</a>
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkqiS88ACgkQvJuQZxSWSshetgCbB3ao2kGembYXswSu7fQ77NFH
4lEAoMfBRsbbNMg4g8wSgIJ6iE+mhFHC
=esTM
-----END PGP SIGNATURE-----


 </pre></blockquote><br />

pgsql-interfaces by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: problem on test perlu trigger function.
Next
From: Raimon Fernandez
Date:
Subject: Re: Implementing Frontend/Backend Protocol