Page 1 of 1
problem with psycopg2
Posted: Tue Apr 04, 2017 5:05 pm
by qwexvf
has anyone ever tried to work with peewee + psycopg?
Source Code
Syntax: Select all
from playhouse.postgres_ext import PostgresqlExtDatabase
psql_db = PostgresqlExtDatabase('csgo', user='csgo', password='csgo')
Error code
Syntax: Select all
[SP] Caught an Exception:
Traceback (most recent call last):
File "../addons/source-python/packages/source-python/plugins/command.py", line 162, in load_plugin
plugin = self.manager.load(plugin_name)
File "../addons/source-python/packages/source-python/plugins/manager.py", line 193, in load
plugin._load()
File "../addons/source-python/packages/source-python/plugins/instance.py", line 74, in _load
self.module = import_module(self.import_name)
File "../addons/source-python/plugins/lo3/lo3.py", line 9, in <module>
from playhouse.postgres_ext import PostgresqlExtDatabase
File "../addons/source-python/packages/site-packages/playhouse/postgres_ext.py", line 26, in <module>
from psycopg2.extensions import adapt
File "../addons/source-python/packages/site-packages/psycopg2/__init__.py", line 50, in <module>
from psycopg2._psycopg import ( # noqa
ImportError: No module named 'psycopg2._psycopg'
This is too strange.
Anyone please help me.
Re: problem with psycopg2
Posted: Tue Apr 04, 2017 6:38 pm
by Ayuto
Looks like you are missing the _psycopg module.
Re: problem with psycopg2
Posted: Tue Apr 04, 2017 6:42 pm
by qwexvf
Ayuto wrote:Looks like you are missing the _psycopg module.
Thats what i thought so to make it clear.
thats what i did
Code: Select all
pip install psycopg2
cp -a /home/vagrant/.pyenv/versions/3.6/lib/python3.6/site-packages/psycopg2 /home/csgo/csgo-test/csgo/addons/source-python/packages/site-packages/.
anything i'm missing ?
Re: problem with psycopg2
Posted: Tue Apr 04, 2017 6:45 pm
by Ayuto
Have you checked if that file exists? If it exists, the reason could be that Source.Python is using 3.5 and not 3.6.
Re: problem with psycopg2
Posted: Tue Apr 04, 2017 6:51 pm
by qwexvf
Ayuto wrote:Have you checked if that file exists? If it exists, the reason could be that Source.Python is using 3.5 and not 3.6.
Sorry, i tried 3.5 ~ 3.6 but same ...
can you try out?
Oh and if i do that in python itrepter it works as i want.
Screenshot
This is what it looks inside of psycopg2
Re: problem with psycopg2
Posted: Tue Apr 04, 2017 7:28 pm
by Ayuto
Did you try it with the 32 Bit version of Python 3.5?
Edit: Yes, according to the screenshot you installed it using the 64 Bit version. You will need the 32 Bit version.
Re: problem with psycopg2
Posted: Tue Apr 04, 2017 7:32 pm
by qwexvf
Ayuto wrote:Did you try it with the 32 Bit version of Python 3.5?
Wait... 32bit?... Oook. let me compile it real quick....
Re: problem with psycopg2
Posted: Tue Apr 04, 2017 7:51 pm
by qwexvf
Ayuto wrote:Did you try it with the 32 Bit version of Python 3.5?
Edit: Yes, according to the screenshot you installed it using the 64 Bit version. You will need the 32 Bit version.
Thanks mate. everything worked.
it took a bit to figure out that i needed 32bit version >< but hopefully i can connect my sweet database now
thanks for your support <3