[ckan-dev] Problem installing CKAN
Eduardo Bejar
wonka at fundapi.org
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
More information about the ckan-dev
mailing list