Jan's Installation Error on Ubuntu 20.04

[sriniazhagar]

Hi All,

I was getting below error while doing the fresher installation of Jans on ubuntu 20.04 AWS EC2 instance. Can you please help me to solve this error.

Installing packages mysql-server
FATAL: (pymysql.err.OperationalError) (1045, "Access denied for user 'jans'@'localhost' (using password: YES)")
(Background on this error at: http://sqlalche.me/e/13/e3q8)
FATAL: True
Traceback (most recent call last):
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
return fn()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/impl.py", line 140, in do_get
self.dec_overflow()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.raise(
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/compat.py", line 182, in raise
raise exception
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 661, in connect
pool.logger.debug("Error on connect(): %s", e)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.raise(
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/compat.py", line 182, in raise
raise exception
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/default.py", line 508, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/lib/python3/dist-packages/pymysql/init.py", line 94, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 325, in init
self.connect()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 599, in connect
self._request_authentication()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 882, in _request_authentication
auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
File "/usr/lib/python3/dist-packages/pymysql/_auth.py", line 265, in caching_sha2_password_auth
pkt = _roundtrip(conn, data)
File "/usr/lib/python3/dist-packages/pymysql/_auth.py", line 122, in _roundtrip
pkt = conn._read_packet()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, "Access denied for user 'jans'@'localhost' (using password: YES)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/opt/jans/jans-setup/setup.py", line 419, in do_installation
rdbmInstaller.start_installation()
File "/opt/jans/jans-setup/setup_app/installers/base.py", line 38, in start_installation
self.install()
File "/opt/jans/jans-setup/setup_app/installers/rdbm.py", line 62, in install
self.import_ldif()
File "/opt/jans/jans-setup/setup_app/installers/rdbm.py", line 484, in import_ldif
self.dbUtils.import_ldif(ldif_files)
File "/opt/jans/jans-setup/setup_app/utils/db_utils.py", line 866, in import_ldif
self.rdm_automapper()
File "/opt/jans/jans-setup/setup_app/utils/db_utils.py", line 720, in rdm_automapper
self.metadata.reflect(self.engine)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/sql/schema.py", line 4558, in reflect
with bind.connect() as conn:
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/base.py", line 2263, in connect
return self._connection_cls(self, **kwargs)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/base.py", line 104, in init
else engine.raw_connection()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/base.py", line 2369, in raw_connection
return self._wrap_pool_connect(
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
Connection.handle_dbapi_exception_noconnection(
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/base.py", line 1583, in handle_dbapi_exception_noconnection
util.raise(
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/compat.py", line 182, in raise
raise exception
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
return fn()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/impl.py", line 140, in do_get
self.dec_overflow()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.raise(
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/compat.py", line 182, in raise
raise exception
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 661, in connect
pool.logger.debug("Error on connect(): %s", e)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.raise(
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/util/compat.py", line 182, in raise
raise exception
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/opt/jans/jans-setup/setup_app/pylib/sqlalchemy/engine/default.py", line 508, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/lib/python3/dist-packages/pymysql/init.py", line 94, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 325, in init
self.connect()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 599, in connect
self._request_authentication()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 882, in _request_authentication
auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
File "/usr/lib/python3/dist-packages/pymysql/_auth.py", line 265, in caching_sha2_password_auth
pkt = _roundtrip(conn, data)
File "/usr/lib/python3/dist-packages/pymysql/_auth.py", line 122, in _roundtrip
pkt = conn._read_packet()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'jans'@'localhost' (using password: YES)")
(Background on this error at: http://sqlalche.me/e/13/e3q8)

[corriganjeff]

I had this issue too. One thing to check is that if you changed the pwd for the jans db user (a good practice), that you also the same value between the jans and mysql environment variables.

Another observation is that it seems like the mysql root pwd must match the jans db password. I didn't have time to investigate that further. I never got past the access denied issue.

I subsequently switched to an ldap install instead. If you're in a rush for a quick test environment that might be faster. docker-jans-monolith/jans-ldap-compose.yml

[devrimyatar]

Hello,

This error occurs because you have mysql installed on your instance previously. If you need currenlty installed mysql on your instance, chose "Remote MySQL", it will ask hostname and admin password. Hostname will be localhost, and enter admin password, you will be good. If you don't need previously installed mysql, you have to remove it propery, apt remove mysql-server is not enough. Please follow https://www.fosslinux.com/96135/how-to-properly-uninstall-mysql-server-in-ubuntu.htm

[nynymike]

Also keep in mind that the VM distribution of Janssen is only for development. We aren't publishing upgrade scripts or cluster deployment assets for VMs.