Re: pgAdmin4 - V3 - Problems managing passwords - Mailing list pgadmin-support

Hi

I recently installed v3 of pgAdmin4

When setting up the passwords for each of the databases, I kept getting the
message;

"Object type <class 'str'> cannot be passed to C code"

Although it appeared to save the password

A server reboot later, when I try to to the databases, it prompts for the
password, when I input the password and click the OK button, I get the
response "Internal Server Error - click for details"

Clicking to view the errors shows the following in a message box which
cannot be dismissed

The server encountered an internal error and was unable to complete your
request. Either the server is overloaded or there is an error in the
application.

The platform is Ubuntu v16.10


The log on the server window reported

/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/psycopg2/__init__.py:144:
UserWarning: The psycopg2 wheel package will be renamed from release 2.8;
in order to keep installing from binary please use "pip install
psycopg2-binary" instead. For details see: <
http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.  """)
Starting pgAdmin 4. Please navigate to http://127.0.0.1:5050 in your
browser.
2018-05-02 09:28:17,685: ERROR    pgadmin:    Object type <class 'str'>
cannot be passed to C code
Traceback (most recent call last): File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/pgadmin4/pgadmin/browser/server_groups/servers/__init__.py",
line 962, in connect   if password is not None else server.password File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/pgadmin4/pgadmin/utils/crypto.py",
line 31, in encrypt   cipher = AES.new(pad(key), AES.MODE_CFB, iv) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/Crypto/Cipher/AES.py",
line 200, in new   return _create_cipher(sys.modules[__name__], key, mode, *args, **kwargs) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/Crypto/Cipher/__init__.py",
line 55, in _create_cipher   return modes[mode](factory, **kwargs) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/Crypto/Cipher/_mode_cfb.py",
line 230, in _create_cfb_cipher   cipher_state = factory._create_base_cipher(kwargs) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/Crypto/Cipher/AES.py",
line 100, in _create_base_cipher   result = start_operation(c_uint8_ptr(key), File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/Crypto/Util/_raw_api.py",
line 196, in c_uint8_ptr   raise TypeError("Object type %s cannot be passed to C code" %
type(data))
TypeError: Object type <class 'str'> cannot be passed to C code
2018-05-02 09:28:17,698: ERROR    werkzeug:    Error on request:
Traceback (most recent call last): File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/werkzeug/serving.py",
line 270, in run_wsgi   execute(self.server.app) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/werkzeug/serving.py",
line 258, in execute   application_iter = app(environ, start_response) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1997, in __call__   return self.wsgi_app(environ, start_response) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1985, in wsgi_app   response = self.handle_exception(e) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1540, in handle_exception   reraise(exc_type, exc_value, tb) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/_compat.py",
line 33, in reraise   raise value File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1982, in wsgi_app   response = self.full_dispatch_request() File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1614, in full_dispatch_request   rv = self.handle_user_exception(e) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1517, in handle_user_exception   reraise(exc_type, exc_value, tb) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/_compat.py",
line 33, in reraise   raise value File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1612, in full_dispatch_request   rv = self.dispatch_request() File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/app.py",
line 1598, in dispatch_request   return self.view_functions[rule.endpoint](**req.view_args) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/flask/views.py",
line 84, in view   return self.dispatch_request(*args, **kwargs) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/pgadmin4/pgadmin/browser/utils.py",
line 254, in dispatch_request   return method(*args, **kwargs) File
"/home/douglas/py3-venv-pgadmin4v3/lib/python3.5/site-packages/pgadmin4/pgadmin/browser/server_groups/servers/__init__.py",
line 965, in connect   return internal_server_error(errormsg=e.message)
AttributeError: 'TypeError' object has no attribute 'message'


Python pip freeze

alembic==0.9.9
Babel==2.5.3
blinker==1.4
click==6.7
extras==1.0.0
fixtures==3.0.0
Flask==0.12.2
Flask-BabelEx==0.9.3
Flask-Gravatar==0.5.0
Flask-HTMLmin==1.3.2
Flask-Login==0.3.2
Flask-Mail==0.9.1
Flask-Migrate==2.1.1
Flask-Paranoid==0.2.0
Flask-Principal==0.4.0
Flask-Security==3.0.0
Flask-SQLAlchemy==2.3.2
Flask-WTF==0.14.2
html5lib==1.0.1
htmlmin==0.1.12
itsdangerous==0.24
linecache2==1.0.0
passlib==1.7.1
pbr==3.1.1
pgadmin4==3.0
psycopg2==2.7.4
pycryptodome==3.6.1
pyrsistent==0.14.2
python-dateutil==2.7.2
python-editor==1.0.3
python-mimeparse==1.6.0
pytz==2018.3
simplejson==3.13.2
six==1.11.0
speaklater==1.3
SQLAlchemy==1.2.6
sqlparse==0.2.4
testtools==2.3.0
traceback2==1.4.0
unittest2==1.1.0
webencodings==0.5.1
Werkzeug==0.14.1
WTForms==2.1

Many thanks


-- 

--

____________________________

Douglas Reed (DBA)

FSB Technology (UK) Ltd

41 Old Street
London, EC1V 9AE