[ckan-dev] Problem installing CKAN

Wed Apr 3 14:48:56 UTC 2013

Thank you for your answers. I tried both suggestions:

- solr_url=http://my-site-url.com:8080/solr/ckan-schema-1.4
(by the way if I try this url from the browser I get 404, but both http://my-site-url.com:8080/solr/ and http://my-site-url.com:8080/solr/ckan-schema-1.4/admin/ open)
- SELinux is disabled

And still get the same error. Here's the detailed traceback, and below it the lines I edited from development.ini:

------------
Traceback:
paster --plugin=ckan sysadmin add admin --config=development.ini
2013-04-03 09:25:26,965 ERROR [ckan.lib.search.common] [Errno -2] Name or service not known
Traceback (most recent call last):
  File "/var/www/html/mysite/pyenv/src/ckan/ckan/lib/search/common.py", line 51, in is_available
    conn.query("*:*", rows=1)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/solr/core.py", line 703, in query
    return self.select(*args, **params)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/solr/core.py", line 798, in __call__
    xml = self.raw(**params)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/solr/core.py", line 823, in raw
    rsp = conn._post(self.selector, request, conn.form_headers)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/solr/core.py", line 646, in _post
 self._reconnect()
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/solr/core.py", line 625, in _reconnect
    self.conn.connect()
  File "/usr/lib64/python2.6/httplib.py", line 720, in connect
    self.timeout)
  File "/usr/lib64/python2.6/socket.py", line 553, in create_connection
    for res in getaddrinfo(host, port, 0, SOCK_STREAM):
gaierror: [Errno -2] Name or service not known
2013-04-03 09:25:27,079 WARNI [ckan.lib.search] Problems were found while connecting to the SOLR server
Traceback (most recent call last):
  File "/var/www/html/mysite/pyenv/bin/paster", line 8, in <module>
    load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/paste/script/command.py", line 104, in run
    invoke(command, command_name, options, args[1:])
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/paste/script/command.py", line 143, in invoke
    exit_code = runner.run(args)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/paste/script/command.py", line 238, in run
 result = self.command()
  File "/var/www/html/mysite/pyenv/src/ckan/ckan/lib/cli.py", line 518, in command
    self.add()
  File "/var/www/html/mysite/pyenv/src/ckan/ckan/lib/cli.py", line 542, in add
    user = model.User.by_name(unicode(username))
  File "/var/www/html/mysite/pyenv/src/ckan/ckan/model/domain_object.py", line 44, in by_name
    .filter_by(name=name).first()
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2156, in first
    ret = list(self[0:1])
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2023, in __getitem__
    return list(res)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
    return self._execute_and_instances(context)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/var/www/html/mysite/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) column does not exists column user.activity_streams_email_notifications
LINE 1: ...ey AS user_reset_key, "user".about AS user_about, "user".act...
                                                             ^
'SELECT "user".password AS user_password, "user".id AS user_id, "user".name AS user_name, "user".openid AS user_openid, "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 \nFROM "user" \nWHERE "user".name = %(name_1)s ORDER BY "user".name \n LIMIT %(param_1)s' {'name_1': u'admin', 'param_1': 1}
---------------------
Development.ini:
[server:main]
use = egg:Paste#http
host = my-site-url.com
port = 5000 
#(I also tried with port = 8080 here)

sqlalchemy.url = postgresql://ckanuser:ckanpassword@localhost/ckantest

ckan.site_url = my-site-url.com

solr_url = http://my-site-url.com:8080/solr/ckan-schema-1.4
---------------------

Thank you in advance for any idea you can suggest me to try in order to solve this.

Best,

Eduardo