Issue #345: Posgres initialization failes with "Please check that the keyword arguments..." (conservancy/kallithea)

[shukri adams]

New issue 345: Posgres initialization failes with "Please check that the keyword arguments..."
https://bitbucket.org/conservancy/kallithea/issues/345/posgres-initialization-failes-with-please

Shukri Adams:

I’m trying to set up a docker container of Kallithea 0.4.1 running against Postgres 12. Initialization fails with the following ouput

`root at e849433575ed:/# kallithea-cli db-create -c /opt/kallithea/production.ini --user=admin --email=admin at admin.com --password=MYPASSWORD --repos=/opt/kallithea/repos`  
`2019-08-26 09:16:41.872 INFO  [kallithea.model.base] initializing db for postgres://kallithea:XXXXX@127.0.0.1:5432/kallithea`  
`2019-08-26 09:16:41.873 INFO  [kallithea.lib.db_manage] Any existing database is going to be destroyed`  
`Are you sure to destroy old database ? [y/n]y`  
`2019-08-26 09:16:44.095 INFO  [kallithea.lib.db_manage] Created tables for kallithea`  
`2019-08-26 09:16:44.095 INFO  [kallithea.lib.db_manage] Setting up repositories config`  
`2019-08-26 09:16:44.178 INFO  [kallithea.lib.db_manage] created ui config`  
`2019-08-26 09:16:44.179 INFO  [kallithea.lib.db_manage] creating default user`  
`2019-08-26 09:16:44.265 INFO  [kallithea.lib.db_manage] creating user admin`  
`2019-08-26 09:16:44.337 INFO  [kallithea.lib.db_manage] creating permissions`  
`2019-08-26 09:16:44.390 INFO  [kallithea.lib.db_manage] creating default user permissions`  
`Traceback (most recent call last):`  
`File "/usr/local/bin/kallithea-cli", line 10, in <module>`  
`sys.exit(cli())`  
`File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 764, in call`  
`return self.main(*args, **kwargs)`  
`File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 717, in main`  
`rv = self.invoke(ctx)`  
`File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 1137, in invoke`  
`return _process_result(sub_ctx.command.invoke(sub_ctx))`  
`File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 956, in invoke`  
`return ctx.invoke(self.callback, **ctx.params)`  
`File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 555, in invoke`  
`return callback(*args, **kwargs)`  
`File "/usr/local/lib/python2.7/dist-packages/kallithea/bin/kallithea_cli_base.py", line 52, in runtime_wrapper`  
`return annotated(*args, **kwargs)`  
`File "/usr/local/lib/python2.7/dist-packages/kallithea/bin/kallithea_cli_db.py", line 70, in db_create`  
`kallithea.CONFIG.global_conf, **kallithea.CONFIG.local_conf)`  
`File "/usr/local/lib/python2.7/dist-packages/kallithea/config/middleware.py", line 29, in make_app_without_logging`  
`return make_base_app(global_conf, full_stack=full_stack, **app_conf)`  
`File "/usr/local/lib/python2.7/dist-packages/tg/configuration/app_config.py", line 1225, in make_base_app`  
`app_config = load_environment(global_conf, app_conf)`  
`File "/usr/local/lib/python2.7/dist-packages/tg/configuration/app_config.py", line 921, in load_environment`  
`self._setup_persistence(app_config)`  
`File "/usr/local/lib/python2.7/dist-packages/tg/configuration/app_config.py", line 689, in _setup_persistence`  
`self._setup_sqlalchemy(conf)`  
`File "/usr/local/lib/python2.7/dist-packages/tg/configuration/app_config.py", line 784, in _setup_sqlalchemy`  
`engine = engine_from_config(conf, 'sqlalchemy.')`  
`File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/init.py", line 486, in engine_from_config`  
`return create_engine(url, **options)`  
`File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/init.py", line 443, in create_engine`  
`return strategy.create(*args, **kwargs)`  
`File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 172, in create`  
`engineclass.name,`  
`TypeError: Invalid argument(s) 'db1.pool_recycle','db1.echo','db1.convert_unicode' sent to create_engine(), using configuration PGDialect_psycopg2/QueuePool/Engine.  Please check that the keyword arguments are appropriate for this combination of components.`

I can’t find any information on this error elsewhere I’m afraid.