Re: Rights for pgadmin3

<font size="-1">Hy Guillaume,<br /><br /> Same result as root or current user with the export command before.<br /><br
/>Regards<br /></font><br /> Le 04/09/2011 18:02, Guillaume Lelarge a écrit : <blockquote
cite="mid:1315152159.24140.1.camel@localhost.localdomain"type="cite"><pre wrap="">On Sun, 2011-09-04 at 16:45 +0200,
FlorentTHOMAS wrote:
 
</pre><blockquote type="cite"><pre wrap="">Hy Guillaume,

The result is the same under current user or root user :

//opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3: error while loading shared 
libraries: libwx_gtk2u_stc-2.8.so.0: cannot open shared object file: No 
such file or directory
/
regards

Le 04/09/2011 16:42, Guillaume Lelarge a écrit :
</pre><blockquote type="cite"><pre wrap="">On Sun, 2011-09-04 at 16:19 +0200, Florent THOMAS wrote:
</pre><blockquote type="cite"><pre wrap="">Hy Guillaume,

Thanks for answering.
Here is the log of my console as I lanch under the current user :

//opt/PostgreSQL/9.0/scripts/launchpgadmin.sh
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3:
/opt/PostgreSQL/9.0/lib/libuuid.so.1: no version information available
(required by /usr/lib64/libSM.so.6)
sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non accordée
16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version
sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non accordée
16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version
sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non accordée
16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version
/opt/PostgreSQL/9.0/scripts/launchpgadmin.sh: line 3: 22646 Erreur de
segmentation
LD_LIBRARY_PATH=/opt/PostgreSQL/9.0/pgAdmin3/lib:/opt/PostgreSQL/9.0/lib:$LD_LIBRARY_PATH
G_SLICE=always-malloc /opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3
/
On the other side, let's have a look of the log under the root user for
the same actions (except the fact that it's working under root user):
//opt/PostgreSQL/9.0/scripts/launchpgadmin.sh
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3:
/opt/PostgreSQL/9.0/lib/libuuid.so.1: no version information available
(required by /usr/lib64/libSM.so.6)
/
According to me the problem is not coming from pgAdmin but from the
users rights of my system.
I'll appreciate that the community give me advice  on the better way to
manage the user/groups on the 9.0 folder tree.

</pre></blockquote><pre wrap="">Seems more an issue with the installer. If you try to launch
"/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3", what happens?


</pre></blockquote></blockquote><pre wrap="">
You need the LD_LIBRARY_PATH variable. Try "export
LD_LIBRARY_PATH="/opt/PostgreSQL/9.0/pgAdmin3/lib", and then
"/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3".


</pre></blockquote>