[pgAdmin4][PATCH] Error running restore/backup etc utilities in WSGI mode

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: [pgAdmin4][PATCH] Error running restore/backup etc utilities in WSGI mode
Date: 2017-04-03 12:53:52
Message-ID: CAKKotZQjRypZ3X8k9eFVwhr7TN1o32J=k=zBU9kcc3Em+eAwMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi,

PFA minor patch to fix the issue where user gets error when try to run
backup/restore etc in pgAdmin4 WSGI mode.

Error in Apache log:

[Mon Apr 03 05:22:26.641789 2017] [wsgi:error] [pid 72351:tid
140303938864896] [remote ::1:28430] File
"/opt/web/pgadmin/utils/driver/psycopg2/__init__.py", line 1664, in utility
[Mon Apr 03 05:22:26.641818 2017] [wsgi:error] [pid 72351:tid
140303938864896] [remote ::1:28430] return
self.server_cls.utility(operation, self.sversion)
[Mon Apr 03 05:22:26.641883 2017] [wsgi:error] [pid 72351:tid
140303938864896] [remote ::1:28430] File
"/opt/web/pgadmin/browser/server_groups/servers/types.py", line 120, in
utility
[Mon Apr 03 05:22:26.641921 2017] [wsgi:error] [pid 72351:tid
140303938864896] [remote ::1:28430] bin_path =
self.utility_path.get().replace("$DIR",
os.path.dirname(sys.modules['__main__'].__file__))
[Mon Apr 03 05:22:26.641958 2017] [wsgi:error] [pid 72351:tid
140303938864896] [remote ::1:28430] AttributeError: 'module' object has no
attribute '__file__'

In WSGI, we get sys.modules['__main__'] as built-in object.

'__main__': <module '__main__' (built-in)>,
'pgadmin.browser.server_groups.servers.databases.schemas.tables.rules':
<module
'pgadmin.browser.server_groups.servers.databases.schemas.tables.rules' from
'/opt/PEM/server/share/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/rules/__init__.py'>,
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Attachment Content-Type Size
fix_backup_pem.diff text/plain 733 bytes

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Ashesh Vashi 2017-04-03 13:03:06 pgAdmin 4 commit: Replace the '$DIR' only when found in the binary dire
Previous Message Ashesh Vashi 2017-04-03 12:41:47 Re: [patch] Move to Alembic migration system