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

Thu Jul 10 13:18:31 UTC 2014

Dear Ross / Alice,

Thanks for your help.. I think it's solr connection issue. I have set the
IP instead of localhost on solr and it's working fine..

Thanks for your help...!
See the attached file for CKAN Home page

Thanks,
Bhavesh

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/3671dd66/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ckan_homepage.png
Type: image/png
Size: 248098 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140710/3671dd66/attachment-0003.png>