Thread: Rights for pgadmin3
<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>
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
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
<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>
<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>
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
<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>
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
<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>
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
<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>
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