[ckan-dev] CKAN installation - unable to create database tables

Thu Jul 10 11:08:36 UTC 2014

Dear Ross,

Please see the attached CKAN configuration file.

I have change the following parameters :

sqlalchemy.url = postgresql://ckan_default:ckan@localhost/ckan_default
solr_url=http://127.0.0.1:8983/solr

Please guide me ...

Bhavesh

On Thu, Jul 10, 2014 at 3:51 PM, Ross Jones <ross at servercode.co.uk> wrote:

>
> Best check your config then to make sure that CKAN knows where it is,
> because currently it seems to be failing to connect.
>
> Ross.
>
>
> On 10 Jul 2014, at 11:18, Library IT <libraryit at iimahd.ernet.in> wrote:
>
> Dear Alice / Ross,
>
> Yes Solr is working fine. I have configure as per the CKAN manual.
>
> whiel running http://localhost:8983/solr/  It's show me following screen..
>
> Welcome to Solr! [image: Solr] <http://localhost:8983/solr/> Solr Admin
> <http://localhost:8983/solr/admin/>
>
> Also when I click on Solr Admin.
>
> Also when I execute :
>
> http://localhost:8983/
>
> It's show me...
>
> <http://jetty.mortbay.org/> Welcome to Jetty 6 on Debian
>
> *Jetty* is a 100% Java HTTP Server and Servlet Container. This means that
> you do not need to configure and run a seperate web server (like Apache) in
> order to use java, servlets and JSPs to generate dynamic content. Jetty is
> a fully featured web server for static and dynamic content. Unlike separate
> server/container solutions, this means that your web server and web
> application run in the same process, without interconnection overheads and
> complications. Furthermore, as a pure java component, Jetty can be simply
> included in your application for demonstration, distribution or deployment.
> Jetty is available on all Java supported platforms.
>
> You can also visit Jetty's Javadoc <http://localhost:8983/javadoc/>
>
>
>
> On Thu, Jul 10, 2014 at 2:36 PM, Alice Heaton <a.heaton at nhm.ac.uk> wrote:
>
>>  Hi,
>>
>> The stack trace suggests that Solr isn't running or properly configured.
>> See
>> http://docs.ckan.org/en/ckan-2.2/install-from-package.html#install-postgresql-and-solr
>> and
>> http://docs.ckan.org/en/ckan-2.2/install-from-source.html#setting-up-solr
>>
>> Best,
>> Alice
>>
>>
>> On 10/07/14 08:27, Library IT wrote:
>>
>>  Dear CKAN Tech Team,
>>
>>  I am new for CKAN and I am facing some issue while installing the CKAN.
>>
>>  System :
>> ---------------
>>  System archit : 32-bit
>>  OS : Ubuntu 12.04 LTS (64-bit)
>>
>>
>> I have try using Installing CKAN from Package as well as Installing CKAN
>> from Source but on the both I am stuck on following command :
>>
>> paster db init -c /etc/ckan/default/development.ini
>>
>>
>> 
>> 
>>  It's showing me 
>> some error as following :
>> ------------------------
>> (default)root at library-it:/usr/lib/ckan/default/src/ckan# paster db init
>> -c /etc/ckan/default/development.ini
>> 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/local/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/local/lib/python2.7/site-packages/paste/script/command.py",
>> line 143, in invoke
>>     exit_code = runner.run(args)
>>   File
>> "/usr/lib/ckan/default/local/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 141, in
>> command
>>     self._load_config()
>>   File "/usr/lib/ckan/default/src/ckan/ckan/lib/cli.py", line 96, 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
>> 270, in update_config
>>     search.check_solr_schema_version()
>>   File "/usr/lib/ckan/default/src/ckan/ckan/lib/search/__init__.py", line
>> 291, in check_solr_schema_version
>>     res = urllib2.urlopen(req)
>>   File "/usr/lib/python2.7/urllib2.py", line 126, in urlopen
>>     return _opener.open(url, data, timeout)
>>   File "/usr/lib/python2.7/urllib2.py", line 406, in open
>>     response = meth(req, response)
>>   File "/usr/lib/python2.7/urllib2.py", line 519, in http_response
>>     'http', request, response, code, msg, hdrs)
>>   File "/usr/lib/python2.7/urllib2.py", line 444, in error
>>     return self._call_chain(*args)
>>   File "/usr/lib/python2.7/urllib2.py", line 378, in _call_chain
>>     result = func(*args)
>>   File "/usr/lib/python2.7/urllib2.py", line 527, in http_error_default
>>     raise HTTPError(req.get_full_url(), code, msg, hdrs, fp)
>> urllib2.HTTPError: HTTP Error 503: Service Unavailable
>> ------------------------------------------------------------------------
>>  What may be the issue.. please help me on this.
>>
>>  NOTE : Please find the attached image
>>
>>  Bhavesh Patel
>>
>>
>>
>> _______________________________________________
>> ckan-dev mailing listckan-dev at lists.okfn.orghttps://lists.okfn.org/mailman/listinfo/ckan-dev
>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>
>>
>>
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>
>>
> <solr admin.png>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140710/bafe2a53/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: development.ini
Type: application/octet-stream
Size: 4650 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140710/bafe2a53/attachment-0003.obj>