[ckan-dev] (no subject)

Wed Apr 22 06:22:12 UTC 2015

Hi:

I'm working with a colleague to install CKAN using the instructions found
at: https://github.com/ckan/ckan/wiki/How-to-install-CKAN-2.0-on-CentOS-7.
We made it through 6. Create the Database Tables, but when it comes time to
initialize the CKAN database:

*paster db init -c /etc/ckan/default/development.ini*

we run into an authentication error:

(default)[ckan at sociotechnical-missouri-edu ckan]$ paster db init -c
/etc/ckan/default/development.ini

2015-04-21 11:44:44,976 ERROR [ckan.lib.search.common] HTTP code=404,
reason=Not Found

Traceback (most recent call last):

  File "/usr/lib/ckan/default/src/ckan/ckan/lib/search/common.py", line 51,
in is_available

    conn.query("*:*", rows=1)

  File "/usr/lib/ckan/default/lib/python2.7/site-packages/solr/core.py",
line 703, in query

    return self.select(*args, **params)

  File "/usr/lib/ckan/default/lib/python2.7/site-packages/solr/core.py",
line 798, in __call__

    xml = self.raw(**params)

  File "/usr/lib/ckan/default/lib/python2.7/site-packages/solr/core.py",
line 823, in raw

    rsp = conn._post(self.selector, request, conn.form_headers)

  File "/usr/lib/ckan/default/lib/python2.7/site-packages/solr/core.py",
line 639, in _post

    return check_response_status(self.conn.getresponse())

  File "/usr/lib/ckan/default/lib/python2.7/site-packages/solr/core.py",
line 1097, in check_response_status

    raise ex

SolrException: HTTP code=404, reason=Not Found

2015-04-21 11:44:44,977 WARNI [ckan.lib.search] Problems were found while
connecting to the SOLR server

Traceback (most recent call last):

  File "/usr/lib/ckan/default/bin/paster", line 9, in <module>

    load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 104, in run

    invoke(command, command_name, options, args[1:])

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 143, in invoke

    exit_code = runner.run(args)

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/paste/script/command.py",
line 238, in run

    result = self.command()

  File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 156, in
command

    self._load_config()

  File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 98, in
_load_config

    load_environment(conf.global_conf, conf.local_conf)

  File "/usr/lib/ckan/default/src/ckan/ckan/config/environment.py", line
232, in load_environment

    p.load_all(config)

  File "/usr/lib/ckan/default/src/ckan/ckan/plugins/core.py", line 124, in
load_all

    unload_all()

  File "/usr/lib/ckan/default/src/ckan/ckan/plugins/core.py", line 182, in
unload_all

    unload(*reversed(_PLUGINS))

  File "/usr/lib/ckan/default/src/ckan/ckan/plugins/core.py", line 210, in
unload

    plugins_update()

  File "/usr/lib/ckan/default/src/ckan/ckan/plugins/core.py", line 116, in
plugins_update

    environment.update_config()

  File "/usr/lib/ckan/default/src/ckan/ckan/config/environment.py", line
354, in update_config

    model.init_model(engine)

  File "/usr/lib/ckan/default/src/ckan/ckan/model/__init__.py", line 179,
in init_model

    version_table = Table('migrate_version', meta.metadata, autoload=True)

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/schema.py",
line 318, in __new__

    table._init(name, metadata, *args, **kw)

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/schema.py",
line 381, in _init

    self._autoload(metadata, autoload_with, include_columns)

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/schema.py",
line 408, in _autoload

    self, include_columns, exclude_columns

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 2424, in run_callable

    conn = self.contextual_connect()

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 2490, in contextual_connect

    self.pool.connect(),

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/pool.py",
line 224, in connect

    return _ConnectionFairy(self).checkout()

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/pool.py",
line 387, in __init__

    rec = self._connection_record = pool._do_get()

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/pool.py",
line 741, in _do_get

    con = self._create_connection()

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/pool.py",
line 188, in _create_connection

    return _ConnectionRecord(self)

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/pool.py",
line 270, in __init__

    self.connection = self.__connect()

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/pool.py",
line 330, in __connect

    connection = self.__pool._creator()

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py",
line 80, in connect

    return dialect.connect(*cargs, **cparams)

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 281, in connect

    return self.dbapi.connect(*cargs, **cparams)

  File
"/usr/lib/ckan/default/lib/python2.7/site-packages/psycopg2/__init__.py",
line 179, in connect

    connection_factory=connection_factory, async=async)

sqlalchemy.exc.OperationalError: (OperationalError) FATAL:  Ident
authentication failed for user "ckan_default"

 None None

(default)[ckan@

Postgres is installed and configured, but we also are having trouble
querying it using Navicat. Any ideas about the cause of the issue would be
appreciated. Also, apologies for any cross-postings.

AJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150422/22416f2b/attachment-0003.html>