[ckan-dev] Problems installing last ckan version 2.8.1 in centos 7.4
David Hernández Gutiérrez
davisoski at gmail.com
Sat Nov 3 22:41:01 UTC 2018
Hi.
*I'm trying to install ckan 2.8.1 in centos 7.4.*
I have been using a script taken from this links:
https://github.com/ckan/ckan/wiki/How-to-install-CKAN-2.x-on-CentOS-7
https://github.com/ckan/ckan/wiki/How-to-install-CKAN-2.7.2-on-CentOS-7.4
https://github.com/ckan/ckan/wiki/How-to-install-CKAN-2.5.2-on-CentOS-6.8
and works ok for the last versions of 2.7 (2.7.1, 2.7.2, 2.7.4)
But for *2.8.1* everything seems to install ok until the next command:
paster db init -c /etc/ckan/default/development.ini
I get this *error*:
Traceback (most recent call last):
File "/usr/lib/ckan/default/bin/paster", line 11, in <module>
sys.exit(run())
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 102, in run
invoke(command, command_name, options, args[1:])
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 141, in invoke
exit_code = runner.run(args)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 236, in run
result = self.command()
File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 363, in
command
model.repo.init_db()
File "/usr/lib/ckan/default/src/ckan/ckan/model/__init__.py", line 188,
in init_db
self.upgrade_db()
File "/usr/lib/ckan/default/src/ckan/ckan/model/__init__.py", line 266,
in upgrade_db
mig.upgrade(self.metadata.bind, self.migrate_repository,
version=version)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/migrate/versioning/api.py",
line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-16>", line 2, in _migrate
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/migrate/versioning/util/__init__.py",
line 160, in with_engine
return f(*a, **kw)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/migrate/versioning/api.py",
line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/migrate/versioning/schema.py",
line 93, in runchange
change.run(self.engine, step)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/migrate/versioning/script/py.py",
line 148, in run
script_func(engine)
File
"/usr/lib/ckan/default/src/ckan/ckan/migration/versions/016_uuids_everywhere.py",
line 69, in upgrade
drop_sequencies(migrate_engine)
File
"/usr/lib/ckan/default/src/ckan/ckan/migration/versions/016_uuids_everywhere.py",
line 186, in drop_sequencies
migrate_engine.execute('drop sequence %s_id_seq;' % sequence)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 2064, in execute
return connection.execute(statement, *multiparams, **params)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 939, in execute
return self._execute_text(object, multiparams, params)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1097, in _execute_text
statement, parameters
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1189, in _execute_context
context)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1402, in _handle_dbapi_exception
exc_info
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1182, in _execute_context
context)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 470, in do_execute
cursor.execute(statement, parameters)
*sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) no existe la
secuencia «package_extra_revision_id_seq»*
* [SQL: 'drop sequence package_extra_revision_id_seq;']*
I tried to clean database to install again following this link:
*https://stackoverflow.com/questions/30666258/ckan-paster-db-init-sqlalchemy-programming-error
<https://stackoverflow.com/questions/30666258/ckan-paster-db-init-sqlalchemy-programming-error>*
*but I get this new error:*
*paster db clean -c /etc/ckan/default/development.ini*
Traceback (most recent call last):
File "/usr/lib/ckan/default/bin/paster", line 11, in <module>
sys.exit(run())
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 102, in run
invoke(command, command_name, options, args[1:])
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 141, in invoke
exit_code = runner.run(args)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 236, in run
result = self.command()
File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 357, in
command
self._load_config(cmd!='upgrade')
File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 330, in
_load_config
self.site_user = load_config(self.options.config, load_site_user)
File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 261, in
load_config
site_user = logic.get_action('get_site_user')({'ignore_auth': True}, {})
File "/usr/lib/ckan/default/src/ckan/ckan/logic/__init__.py", line 464,
in wrapped
result = _action(context, data_dict, **kw)
File "/usr/lib/ckan/default/src/ckan/ckan/logic/action/get.py", line
2377, in get_site_user
user = model.User.get(site_id)
File "/usr/lib/ckan/default/src/ckan/ckan/model/user.py", line 56, in get
return query.first()
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2755, in first
ret = list(self[0:1])
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2547, in __getitem__
return list(res)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2855, in __iter__
return self._execute_and_instances(context)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 945, in execute
return meth(self, multiparams, params)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/sql/elements.py",
line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1189, in _execute_context
context)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1402, in _handle_dbapi_exception
exc_info
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1182, in _execute_context
context)
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 470, in do_execute
cursor.execute(statement, parameters)
*sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) doesn't exit
column user.password*
LINE 1: SELECT "user".password AS user_password, "user".id AS user_i...
^
[SQL: 'SELECT "user".password AS user_password, "user".id AS user_id,
"user".name AS user_name, "user".fullname AS user_fullname, "user".email AS
user_email, "user".apikey AS user_apikey, "user".created AS user_created,
"user".reset_key AS user_reset_key, "user".about AS user_about,
"user".activity_streams_email_notifications AS
user_activity_streams_email_notifications, "user".sysadmin AS
user_sysadmin, "user".state AS user_state \nFROM "user" \nWHERE "user".name
= %(name_1)s OR "user".id = %(id_1)s ORDER BY "user".name \n LIMIT
%(param_1)s'] [parameters: {'name_1': 'default', 'param_1': 1, 'id_1':
'default'}]
(default) [ckan at li655-229 ckan]$
Any suggestion?
Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20181103/54897912/attachment.html>
More information about the ckan-dev
mailing list