pgadmin4 server error message processing
Hi, when server message is not english (my server is korean), pgadmin4 make a error bellow. File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/psycopg2/__init__.py", line 1612, in _formatted_exception_msg self.decode_to_utf8(exception_obj.diag.message_primary) UnicodeDecodeError: 'ascii' codec can't decode byte 0xec in position 0: ordinal not in range(128) This pgadmin4 is pgadmin4-v2-2.0-1.rhel7.x86_64.rpm package on CentOS7. It may be a problem utf8 encoding string processing of python 2.7. I sugesst , if server message is non english, decoding to utf8 is skiped.
Re: pgadmin4 server error message processing
This bug was not fixed still, File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/psycopg2/__init__.py", line 1541, in _formatted_exception_msg self.decode_to_utf8(exception_obj.diag.message_primary) UnicodeDecodeError: 'ascii' codec can't decode byte 0xec in position 0: ordinal not in range(128) This rpm is pgadmin4-v2-2.1-1.rhel7.x86_64. Reguards, Ioseph. 2017년 12월 27일 13:41에 Murtuza Zabuawala 이(가) 쓴 글: Hi, Similar issue was already reported by other users, https://redmine.postgresql.org/issues/2806 https://redmine.postgresql.org/issues/2821 We have recently fixed it and fix should be available in next pgAdmin4 release. Thanks, Murtuza On Wed, Dec 27, 2017 at 9:34 AM, Ioseph Kim <mailto:pgsql...@postgresql.kr>> wrote: Hi, when server message is not english (my server is korean), pgadmin4 make a error bellow. File "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/driver/psycopg2/__init__.py", line 1612, in _formatted_exception_msg self.decode_to_utf8(exception_obj.diag.message_primary) UnicodeDecodeError: 'ascii' codec can't decode byte 0xec in position 0: ordinal not in range(128) This pgadmin4 is pgadmin4-v2-2.0-1.rhel7.x86_64.rpm package on CentOS7. It may be a problem utf8 encoding string processing of python 2.7. I sugesst , if server message is non english, decoding to utf8 is skiped.
suggestion: discard python2.x venv
Hi, I used pgadmin4 since 2 month. pgadmin4 is a good application for PostgreSQL. that is true! but, in multibytes environment, python2 + pgadmin4 is not good choice. if table name or column name is multibytes, export, import is not working, because python2 unicode processing is ugly. and, if server message is multibytes, pgadmin4 does not display that, and there are many other problems so. I changed venv to python3, most problems of multibytes have been resolved smoothly as expected. we need to narrow its focus. Regards Ioseph
Re: suggestion: discard python2.x venv
Yes, I agree yours. thinking that, many pgadmin4 is used on windows, or mac, pgadmin4 for windows installer is including python2.7. so many users use the python2 environment, with no choice. if python3 is used on windows distribution (builtin python3), this will is good choice. Regards, ioseph. 2018년 02월 06일 13:55에 Murtuza Zabuawala 이(가) 쓴 글: On Tue, Feb 6, 2018 at 9:21 AM, Ioseph Kim <mailto:pgsql...@postgresql.kr>> wrote: Hi, I used pgadmin4 since 2 month. pgadmin4 is a good application for PostgreSQL. that is true! but, in multibytes environment, python2 + pgadmin4 is not good choice. if table name or column name is multibytes, export, import is not working, because python2 unicode processing is ugly. and, if server message is multibytes, pgadmin4 does not display that, and there are many other problems so. I changed venv to python3, most problems of multibytes have been resolved smoothly as expected. we need to narrow its focus. AFAIK we are using Python2.x because many enterprise linux distributions do not have native support for Python3 in them (from their default repo) for example CentOS6.x, many versions of Redhat linux etc, Admins have to download and compile Python3.x manually which adds maintenance of additional software on their servers (eg manual security updates etc), In order to support them we are shipping pgAdmin4 with Python2.x, Otherwise you are correct Python3 will resolve most of the Unicode related issues which we are currently facing with pgAdmin4. -- Murtuza Regards Ioseph
v4 3.1 Korean message file
Hi I translated pgAdmin v4 messages. pot file is version 3.1. apply to next version, plz. Regards, ioseph. pgadmin-msg-ko.po.gz Description: application/gzip
CentOS 7.x pgadmin4 3.5 require psutil module
Hi, My pgadmin4 was updated to 3.5. but it broken because I did not install python2-psutil package. pgadmin4 package might set depends on python psuitl package. Regards ioseph.
when hostname is non ascii, the application server could not be contacts
Hi, I'm using PgAdmin4 very well, thanks. I found a problem. OS: windows7 64bit, (support Korean Language) PgAdmin4: v3.6 (pgadmin.org , exe install version) When hostname (windows' computer name) is non ascii, I could not run pgadmin. this problem is resolved by change hostname. but, there are many non ascii names at Korea. they will not know this problem. review this problem, I hope this is fixed. Regards, ioseph.
