On Saturday, June 1, 2019 at 1:41:12 AM UTC-7, Nico Zanferrari wrote: > > Hi Dave, > > I've faced the same problem trying to add psycopg2 on MacOs binaries with > python 2.7. Following some advices, I've resolved it by installing unixodbc > (with brew) before it. > > I hope it helps, > Nico >
Sadly, pip tells me "could not find a version that satisfies te requirement unixodbc" And to help with my memory later, -t is an option to "pip install", not to pip in general. Oh, and I once said >>> Is site-packages the wrong location? >> That's web2py/applications/myapp/site-packages No, it's not. It's just web2py/site-packages. And to expand on my comments about the original traceback ... sudo pip --version gives the same traceback, while pip --version works. Probably a path issue, but I'm not sure I want to mess around with sudoing sudos. /dps > Il giorno sab 1 giu 2019 alle ore 00:09 Dave S <snide...@gmail.com > <javascript:>> ha scritto: > >> Help! >> >> /dps >> >> On Thursday, May 16, 2019 at 6:37:42 PM UTC-7, Dave S wrote: >>> >>> >>> >>> On Wednesday, May 15, 2019 at 10:26:39 AM UTC-7, Dave S wrote: >>>> >>>> >>>> >>>> On Monday, May 13, 2019 at 3:48:39 PM UTC-7, Dave S wrote: >>>>> >>>>> >>>>> >>>>> On Monday, May 13, 2019 at 2:31:33 PM UTC-7, Dave S wrote: >>>>>> >>>>>> When I check Last week I ended up making the move to Postgres on the >>>>>> busier of my production servers, and the changeover appears to be >>>>>> successful (imported existing data via CSV). I was interested to see >>>>>> that >>>>>> the import preserved some gaps in the id field, and that Postgres was >>>>>> filling some of those gaps and holding off on using id's above the >>>>>> imported >>>>>> max(id). But I'm also getting errors about 'ERROR 23505, duplicate key >>>>>> value value viotlates unique contraint "updreq_y_pkey". Key(id)=(23681) >>>>>> already exists.' >>>>>> >>>>>> Looking at this made me realize I was running pg8000 (still supplied >>>>>> in contrib in 2.15.4), and I wanted to switch to pscyopg2. So I tried >>>>>> pip install psycopg2 >>>>>> >>>>>> and that was progressing fine until it got to copying the built >>>>>> module into /usr/lib64/python2.7/dist-packages/psycogpg2 -- permission >>>>>> denied (not too surprising). So I tired the obvious: >>>>>> sudo pip install psycopg2 >>>>>> Which ends abruptly with >>>>>> [traceback excerpt] >>>>>> The 'pip==9.0.3' distribution was not found and required by the >>>>>> application >>>>>> [...] >>>>>> >>>>> >>>>> >>>>>> What can I do now? >>>>>> (AWS Linux, up to date, OS_VERSION says "2018.03") >>>>>> >>>>>> >>>>>> >>>>> >>>>> Okay, I found the -t option, and from the web2py directory specified >>>>> site-packages >>>>> Now, how do I get web2py.py to find the driver? >>>>> >>>>> >>>> Is site-packages the wrong location? >>>> >>>> That's web2py/applications/myapp/site-packages >>> >>> /dps >>> >>> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/web2py/b2aecb42-d28c-42a7-84fe-1de80100f735%40googlegroups.com >> >> <https://groups.google.com/d/msgid/web2py/b2aecb42-d28c-42a7-84fe-1de80100f735%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/413ec153-d82a-4766-834c-1280d7f00788%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
