Upon inspection it seems psycopg2 is installed at 3 locations. .
*/home/ouruser/.local/lib/python3.6/site-packages/psycopg2*
*/usr/local/lib64/python3.6/site-packages*
*AND*
*/usr/lib64/python3.6/site-packages/psycopg2*
Two first two are 2.9.3 and the last one is 2.8.6.
When I log the packages using this code
import pkg_resources
pkgs = str({p.project_name: p.version for p in pkg_resources.working_set})
I get 'psycopg2': '2.9.3' among others. However, importing it does not
work.
Perhaps we should try with a newer version of python again with sudo pip
install. Though if it were a compatibility problem I don't see why it
should work without wsgi.
On Thursday, March 31, 2022 at 4:20:45 PM UTC+2 Jim S wrote:
> You don't have different versions of psycopg2 in the ourusr vs system
> drivers do you? Looks like newer versions of psycopg2 no longer support
> python 3.6
>
> https://www.psycopg.org/psycopg3/docs/basic/install.html
>
>
>
> On Thursday, March 31, 2022 at 9:01:24 AM UTC-5 [email protected] wrote:
>
>> Thank you for the reply!
>>
>> I believe we've already tried sudo pip install psycopg2.
>> Psycopg2 seems to be located at
>> */usr/local/lib64/python3.6/site-packages*
>> Other packages that don't exhibit the same problem are also there.
>> There's another installation of psycopg2 in
>> */home/ouruser/.local/lib/python3.6/site-packages/psycopg2*
>>
>> I'm not sure about the user running the process, but I think it isn't
>> root. I'll have to check that with the colleague chiefly wrestling with
>> this migration.
>>
>> Yes, we're going to move to a newer version. In fact we started on a
>> newer version but ran into this problem. We're now on 3.6 because we were
>> checking if the problem would persist since 3.6 was the default python3 on
>> the machine.
>>
>> It's interesting that this is an issue in particular with psycopg2.
>>
>> On Thursday, March 31, 2022 at 2:21:42 PM UTC+2 Jim S wrote:
>>
>>> When I've run into similar situations on Ubuntu the resolution was to
>>> install the package using sudo. If you just pip installed the package
>>> under your user then I believe it is stored in
>>> .local/lib/python3.x/site-packages in the user home directory.
>>>
>>> This would explain why it works when you run it interactively. What
>>> user is running your uwsgi process?
>>>
>>> Also, if possible I'd move to a newer version of python3. Python 3.6 is
>>> end-of-life as of 12/23/2021
>>>
>>> -Jim
>>>
>>>
>>> On Thursday, March 31, 2022 at 6:24:32 AM UTC-5 [email protected]
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Trying to setup web2py, python3 centos 7, nginx, uwsgi.
>>>>
>>>> The application is already running on centos 7 with python 2.7.
>>>>
>>>> With python 3.6 I get the following error:
>>>>
>>>> class 'RuntimeError'> Failure to connect, tried 5 times:
>>>> Traceback (most recent call last):
>>>> File "/opt/web2py/gluon/packages/dal/pydal/base.py", line 514, in
>>>> __init__
>>>> self._adapter = adapter(**kwargs)
>>>> File "/opt/web2py/gluon/packages/dal/pydal/adapters/postgres.py",
>>>> line 28, in __call__
>>>> return AdapterMeta.__call__(cls, *args, **kwargs)
>>>> File "/opt/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
>>>> line 41, in __call__
>>>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>>> File "/opt/web2py/gluon/packages/dal/pydal/adapters/postgres.py",
>>>> line 67, in __init__
>>>> after_connection,
>>>> File "/opt/web2py/gluon/packages/dal/pydal/adapters/base.py", line
>>>> 424, in __init__
>>>> super(SQLAdapter, self).__init__(*args, **kwargs)
>>>> File "/opt/web2py/gluon/packages/dal/pydal/adapters/base.py", line
>>>> 85, in __init__
>>>> self.find_driver()
>>>> File "/opt/web2py/gluon/packages/dal/pydal/adapters/base.py", line
>>>> 134, in find_driver
>>>> "No driver of supported ones %s is available" % str(self.drivers)
>>>> RuntimeError: No driver of supported ones ('psycopg2',) is available
>>>>
>>>> This only occurs when running the application through uwsgi, but not
>>>> when I run the web2py application directly through:
>>>> *> python3 web2py.py*
>>>>
>>>> I also tried importing psycopg2 in the welcome app and got the
>>>> following error:
>>>> File "/opt/web2py/gluon/custom_import.py", line 78, in custom_importer
>>>> result = sys.modules[modules_prefix]
>>>> KeyError: 'applications.welcome.modules.psycopg2'
>>>>
>>>> *Any clue as to what might be the problem? Apparently python is unable
>>>> to locate the psycopg2 app when ran via uwsgi.*
>>>>
>>>> *I'm not sure if this is enough information or what other details I
>>>> should provide.*
>>>>
>>>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/701351c4-5a00-4c06-b2bb-3fabd4341da2n%40googlegroups.com.
