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

Thu Jul 10 11:19:56 UTC 2014

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!
>> 
>> Solr Admin
>> 
>> Also when I click on Solr Admin.
>> 
>> Also when I execute :
>> 
>> http://localhost:8983/
>> 
>> It's show me...
>> 
>> 
>> 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
>> 
>> 
>> 
>> 
>> 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 andhttp://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 list
>>> ckan-dev at lists.okfn.org
>>> https://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/1f173ebb/attachment-0003.html>