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 <https://maps.google.com/?q=41+Old+Street+%0D%0ALondon,+EC1V+9AE&entry=gmail&source=g> London, EC1V 9AE
