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

Thu Jul 10 11:42:16 UTC 2014

Yes Ross,

I can able to read the CKAN Schema from Schema Browser.

Please see the attached screen sort,.

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

> Hi,
>
> When you click on the schema browser, do you see the CKAN schema? Also is
> there anything in the logging section?
>
>
> urllib2.HTTPError: HTTP Error 503: Service Unavailable
>>>
>>>
> This suggests that solr was unavailable.  It obviously connected to get
> this message from Solr, but you need to find out why solr was unable to
> respond.
>
> Beyond that I can’t really help.
>
> Ross.
>
>
>
> On 10 Jul 2014, at 12:08, Library IT <libraryit at iimahd.ernet.in> wrote:
>
> 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>
>>
>>
>>
> <development.ini>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140710/5c33a349/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: schema browser.png
Type: image/png
Size: 203462 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140710/5c33a349/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: RAW Schema.png
Type: image/png
Size: 352141 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140710/5c33a349/attachment-0007.png>