[ckan-dev] Problems installing last ckan version 2.8.1 in centos 7.4

• Next message: [ckan-dev] [Errno 13] Permission denied: '/var/lib/ckan/ (no solution works)
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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>

• Next message: [ckan-dev] [Errno 13] Permission denied: '/var/lib/ckan/ (no solution works)
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]