[ckan-dev] CKAN installation - unable to create database tables
Jason Tan
jason.tan at ersa.edu.au
Fri Jul 11 00:15:56 UTC 2014
Ignore this - I see you have it under control.
Apologies
Jason
On 11/07/2014 9:44 am, "Jason Tan" <jason.tan at ersa.edu.au> wrote:
> I notice you have SOLR URL has an ip of 127.0.0.1.
> That ip is only reachable by the machine it runs on.
>
> Are CKAN and SOLR running on the same machine?
>
> If not you probably want to make SOLR/jetty run on a routable interface?ip
> and set solr_url to point to the new interface/ip.
>
> Regards
> Jasin
> On 10/07/2014 10:48 pm, "Library IT" <libraryit at iimahd.ernet.in> wrote:
>
>> 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>
>>>
>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140711/b3487c43/attachment-0003.html>
More information about the ckan-dev
mailing list