Thread: Rights for pgadmin3

Rights for pgadmin3

From
Florent THOMAS
Date:
<font size="-1">Hy all of you,<br /><br /> I'm running under OpenSuse 11.4 and postgreSQL 9 installed from the
enterprisedbwebsite.<br /> I've installed all the stuff under the root user.<br /> And now when I want to launch the
sqlpanel on a database in the pgadmin panel, pgadmin3 crached.<br /> If I do the same with the root user, everything
workfine.<br /> How can I do for preventing pgadmin3 from crashing under a current user?<br /><br /> regards<br
/></font>

Re: Rights for pgadmin3

From
Guillaume Lelarge
Date:
On Sun, 2011-09-04 at 15:24 +0200, Florent THOMAS wrote:
> Hy all of you,
> 
> I'm running under OpenSuse 11.4 and postgreSQL 9 installed from the 
> enterprisedb website.
> I've installed all the stuff under the root user.
> And now when I want to launch the sql panel on a database in the pgadmin 
> panel, pgadmin3 crached.
> If I do the same with the root user, everything work fine.
> How can I do for preventing pgadmin3 from crashing under a current user?
> 

pgAdmin works for me with an unprivileged user. You'll have to tell us
more about your issue for us to help you. Right now, all I can say is
that it should work.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Rights for pgadmin3

From
Peter Geoghegan
Date:
On 4 September 2011 14:24, Florent THOMAS <mailinglist@tdeo.fr> wrote:
> Hy all of you,
>
> I'm running under OpenSuse 11.4 and postgreSQL 9 installed from the
> enterprisedb website.
> I've installed all the stuff under the root user.
> And now when I want to launch the sql panel on a database in the pgadmin
> panel, pgadmin3 crached.
> If I do the same with the root user, everything work fine.
> How can I do for preventing pgadmin3 from crashing under a current user?

I suggest that you open PgAdmin3 from an xterm, and see if there are
any useful error messages.

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services


Re: Rights for pgadmin3

From
Florent THOMAS
Date:
<font size="-1">Hy Guillaume,<br /><br /> Thanks for answering.<br /> Here is the log of my console as I lanch under
thecurrent user :<br /><br /><i>/opt/PostgreSQL/9.0/scripts/launchpgadmin.sh<br />
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3:/opt/PostgreSQL/9.0/lib/libuuid.so.1: no version information available
(requiredby /usr/lib64/libSM.so.6)<br /> sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non accordée<br />
16:05:40:Error: Failed to execute: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version<br /> sh:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump:Permission non accordée<br /> 16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump--version<br /> sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non
accordée<br/> 16:05:40: Error: Failed to execute: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version<br />
/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_PATHG_SLICE=always-malloc
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3<br/></i><br /> On the other side, let's have a look of the log under the root
userfor the same actions (except the fact that it's working under root user):<br
/><i>/opt/PostgreSQL/9.0/scripts/launchpgadmin.sh<br/> /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)<br /></i><br
/>According to me the problem is not coming from pgAdmin but from the users rights of my system.<br /> I'll appreciate
thatthe community give me advice  on the better way to manage the user/groups on the 9.0 folder tree.<br /><br />
Regards<br/><br /><br /><br /></font><br /> Le 04/09/2011 16:01, Guillaume Lelarge a écrit : <blockquote
cite="mid:1315144896.2085.2.camel@localhost.localdomain"type="cite"><pre wrap="">On Sun, 2011-09-04 at 15:24 +0200,
FlorentTHOMAS wrote:
 
</pre><blockquote type="cite"><pre wrap="">Hy all of you,

I'm running under OpenSuse 11.4 and postgreSQL 9 installed from the 
enterprisedb website.
I've installed all the stuff under the root user.
And now when I want to launch the sql panel on a database in the pgadmin 
panel, pgadmin3 crached.
If I do the same with the root user, everything work fine.
How can I do for preventing pgadmin3 from crashing under a current user?

</pre></blockquote><pre wrap="">
pgAdmin works for me with an unprivileged user. You'll have to tell us
more about your issue for us to help you. Right now, all I can say is
that it should work.


</pre></blockquote>

Re: Rights for pgadmin3

From
Florent THOMAS
Date:
<font size="-1">Correction under</font><br /><br /> Le 04/09/2011 16:19, Florent THOMAS a écrit : <blockquote
cite="mid:4E6388DB.7070203@tdeo.fr"type="cite"><font size="-1">Hy Guillaume,<br /><br /> Thanks for answering.<br />
Hereis the log of my console as I lanch under the current user :<br /><br
/><i>/opt/PostgreSQL/9.0/scripts/launchpgadmin.sh<br/> /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)<br /> sh:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump:Permission non accordée<br /> 16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump--version<br /> sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non
accordée<br/> 16:05:40: Error: Failed to execute: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version<br /> sh:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump:Permission non accordée<br /> 16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump--version<br /> /opt/PostgreSQL/9.0/scripts/launchpgadmin.sh: line 3: 22646
Erreurde 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<br /></i><br /> On the other side, let's have a look of
thelog under the root user for the same actions (except the fact that it's working <b><font color="#ff0000">CURRENT
</font></b>under user):<br /><i>/opt/PostgreSQL/9.0/scripts/launchpgadmin.sh<br />
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3:/opt/PostgreSQL/9.0/lib/libuuid.so.1: no version information available
(requiredby /usr/lib64/libSM.so.6)<br /></i><br /> According to me the problem is not coming from pgAdmin but from the
usersrights of my system.<br /> I'll appreciate that the community give me advice  on the better way to manage the
user/groupson the 9.0 folder tree.<br /><br /> Regards<br /><br /><br /><br /></font><br /> Le 04/09/2011 16:01,
GuillaumeLelarge a écrit : <blockquote cite="mid:1315144896.2085.2.camel@localhost.localdomain" type="cite"><pre
wrap="">OnSun, 2011-09-04 at 15:24 +0200, Florent THOMAS wrote:
 
</pre><blockquote type="cite"><pre wrap="">Hy all of you,

I'm running under OpenSuse 11.4 and postgreSQL 9 installed from the 
enterprisedb website.
I've installed all the stuff under the root user.
And now when I want to launch the sql panel on a database in the pgadmin 
panel, pgadmin3 crached.
If I do the same with the root user, everything work fine.
How can I do for preventing pgadmin3 from crashing under a current user?

</pre></blockquote><pre wrap="">pgAdmin works for me with an unprivileged user. You'll have to tell us
more about your issue for us to help you. Right now, all I can say is
that it should work.


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

Re: Rights for pgadmin3

From
Guillaume Lelarge
Date:
On Sun, 2011-09-04 at 16:19 +0200, Florent THOMAS wrote:
> 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.
> 

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


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Rights for pgadmin3

From
Florent THOMAS
Date:
<font size="-1">Hy Guillaume,<br /><br /> The result is the same under current user or root user :<br /><br
/><i>/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3<br/> /opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3: error while loading
sharedlibraries: libwx_gtk2u_stc-2.8.so.0: cannot open shared object file: No such file or directory<br /></i><br />
regards<br/></font><br /> Le 04/09/2011 16:42, Guillaume Lelarge a écrit : <blockquote
cite="mid:1315147350.4957.0.camel@localhost.localdomain"type="cite"><pre wrap="">On Sun, 2011-09-04 at 16:19 +0200,
FlorentTHOMAS 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>

Re: Rights for pgadmin3

From
Guillaume Lelarge
Date:
On Sun, 2011-09-04 at 16:45 +0200, Florent THOMAS wrote:
> 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 :
> > On Sun, 2011-09-04 at 16:19 +0200, Florent THOMAS wrote:
> >> 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.
> >>
> > Seems more an issue with the installer. If you try to launch
> > "/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3", what happens?
> >
> >

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".


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Rights for pgadmin3

From
Florent THOMAS
Date:
<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>

Re: Rights for pgadmin3

From
Guillaume Lelarge
Date:
On Sun, 2011-09-04 at 18:07 +0200, Florent THOMAS wrote:
> Hy Guillaume,
> 
> Same result as root or current user with the export command before.
> 

I guess they put the libraries elsewhere. Well, better ask them than me.
EnterpriseDB has forums to ask questions about their installers. You
should them.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: Rights for pgadmin3

From
Florent THOMAS
Date:
<font size="-1">Finally,<br /><br /> I uninstall all the stuff, then use the YaST to add the following repo : <a
class="moz-txt-link-freetext"
href="http://download.opensuse.org/repositories/server:/database:/postgresql/openSUSE_11.4/">http://download.opensuse.org/repositories/server:/database:/postgresql/openSUSE_11.4/</a><br
/>And in the end reinstall all the postgresql.<br /><br /> Everything work fine now.<br /><br /> Regards<br
/></font><br/> Le 04/09/2011 16:12, Peter Geoghegan a écrit : <blockquote
cite="mid:CAEYLb_WRtFAXaqP+3v6tw9Pv=gdRHJqUdVx3jXfxdDup2+y6bg@mail.gmail.com"type="cite"><pre wrap="">On 4 September
201114:24, Florent THOMAS <a class="moz-txt-link-rfc2396E"
href="mailto:mailinglist@tdeo.fr"><mailinglist@tdeo.fr></a>wrote:
 
</pre><blockquote type="cite"><pre wrap="">Hy all of you,

I'm running under OpenSuse 11.4 and postgreSQL 9 installed from the
enterprisedb website.
I've installed all the stuff under the root user.
And now when I want to launch the sql panel on a database in the pgadmin
panel, pgadmin3 crached.
If I do the same with the root user, everything work fine.
How can I do for preventing pgadmin3 from crashing under a current user?
</pre></blockquote><pre wrap="">
I suggest that you open PgAdmin3 from an xterm, and see if there are
any useful error messages.

</pre></blockquote>

Re: Rights for pgadmin3

From
Guillaume Lelarge
Date:
On Mon, 2011-09-05 at 11:38 +0200, Florent THOMAS wrote:
> Finally,
> 
> I uninstall all the stuff, then use the YaST to add the following repo : 
> http://download.opensuse.org/repositories/server:/database:/postgresql/openSUSE_11.4/
> And in the end reinstall all the postgresql.
> 
> Everything work fine now.
> 

Well, it's always better to use the  distribution package (or the
Windows installer on Windows).


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com