Re: Trouble installing psycopg2 - Mailing list pgsql-general

From Augori
Subject Re: Trouble installing psycopg2
Date
Msg-id CAFE+72MYY9n_4FX6MaMLfhqG00chGtag-WLMPLu+UynC_0AK+A@mail.gmail.com
Whole thread Raw
In response to Re: Trouble installing psycopg2  (Augori <augori@gmail.com>)
Responses Re: Trouble installing psycopg2  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Hmm maybe you're right.  I just tried starting over again from a directory under joshmoe, following the tutorial again, but I get permssions errors at every turn. 

# wget http://python.org/ftp/python/2.7.3/Python-2.7.3.tar.bz2
# tar xf Python-2.7.3.tar.bz2
# cd Python-2.7.3
# ./configure --prefix=/usr/local
# make && make altinstall
Running the make && make altinstall looks okay for a bit (maybe during the build), but then fas with the permissions errors below:

Failed to build these modules:
_sqlite3

running build_scripts
creating build/scripts-2.7
copying and adjusting /home/realmark/public_html/cronjobs/gisSupportCode/Pyth
on-2.7.3/Tools/scripts/pydoc -> build/scripts-2.7
copying and adjusting /home/realmark/public_html/cronjobs/gisSupportCode/Pyth
on-2.7.3/Tools/scripts/idle -> build/scripts-2.7
copying and adjusting /home/realmark/public_html/cronjobs/gisSupportCode/Pyth
on-2.7.3/Tools/scripts/2to3 -> build/scripts-2.7
copying and adjusting /home/realmark/public_html/cronjobs/gisSupportCode/Pyth
on-2.7.3/Lib/smtpd.py -> build/scripts-2.7
changing mode of build/scripts-2.7/pydoc from 644 to 755
changing mode of build/scripts-2.7/idle from 644 to 755
changing mode of build/scripts-2.7/2to3 from 644 to 755
changing mode of build/scripts-2.7/smtpd.py from 644 to 755
/usr/bin/install -c -m 644 ./Tools/gdb/libpython.py python-gdb.py
/usr/bin/install -c python /usr/local/bin/python2.7
/usr/bin/install: cannot remove `/usr/local/bin/python2.7': Permission denied
make: *** [altbininstall] Error 1

Since it's already their, I thought maybe I could skip to these steps but they give permission errors as well
# wget http://pypi.python.org/packages/source/d/distribute/distribute-0.6.35.tar.gz
# tar xf distribute-0.6.35.tar.gz
# cd distribute-0.6.35
# python2.7 setup.py install
I guess this is the reason I started installing things from root.



On Sun, Sep 29, 2013 at 1:15 PM, Augori <augori@gmail.com> wrote:
No, sorry.  I just checked that again and I can yum.  I guess I remembered that incorrectly.

But the thing is, I'm worried that I have all this stuff set up and working --postgresql, virtualenv, psycopg2 in root; then if I try another install under joshmoe it could cause even more more chaos. 


On Sun, Sep 29, 2013 at 1:01 PM, Augori <augori@gmail.com> wrote:
You're right, I installed the virtualenv as user root into /root.  

The reason for this is that I can't run 'yum' and probably many of the other commands from joshmoe, so I gave up on that route.  But I'm open for suggestions...do you think it would be better to try to get access to these commands? 


On Sun, Sep 29, 2013 at 12:46 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
On 09/29/2013 09:38 AM, Augori wrote:
Thanks to Adrian for pointing to this site.
http://toomuchdata.com/2012/06/25/how-to-install-python-2-7-3-on-centos-6-2/
  I was able to get the virtual environment set up and install psycopg2
from there.  Now things seem to be working well when I'm logged in as root.

But I need to be able to use the virtualenv as a non-root user, joshmoe.
  (And start/stop postgresql as this other user)

I've found a good many examples of sudoer statements.  But I can't
figure out the syntax that will make this work.  I'm hoping once I get
this one, I'll be able to give access to statements like 'service
postgresql status' and so forth.


Looks to me you installed the virtualenv as user root into /root. Why not install the virtualenv as joshme into /joshme? Then you avoid the sudo problems all together. It also one of the benefits of virtualenv you can run programs as an ordinary user and not make them system wide.


--
Adrian Klaver
adrian.klaver@gmail.com



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: multiple databases vs multiple clusters on the same host
Next
From: Adrian Klaver
Date:
Subject: Re: Trouble installing psycopg2