[ckan-dev] error 500 internal server error

[Jason Tan]

Hi All and Thanks Nigel


Belatedly (other stuff has taken by time) I finally found the solution for
this problem by running paster as Nigel suggested.

I needed to run  " grant select on _table_metadata to datastore_prd;" on
the datastore database. datastore_prd is the data store read only user. I'm
pretty sure I ran the set_permisisons.sql script at install time so I
suspect that in our version of CKAN (2.1.1) the _table_metadata table in
the datastore database is not created until some runtime event occurs, e.g.
a file is uploaded or data is pushed into the datastore or similar

Regards
Jason Tan


On 4 September 2014 15:52, Nigel Babu <nigel.babu at okfn.org> wrote:

> Hi Jason,
>
> The line in the error log is perfectly normal. If you don't want this
> printed, you need to tweak the logging settings in your production.ini
> file. I'm not sure what's causing apache to throw a server error though.
> The logs don't seem to say. Have you tried running the server with paster
> with Debug = True to see if it says anything interesting?
>
> Nigel Babu
> Developer, Open Knowledge
>
>
> On 4 September 2014 11:41, Jason Tan <jason.tan at ersa.edu.au> wrote:
>
>> Hi All,
>>
>> I'm hoping someone might be able to throw some light on a problem I'm
>> seeing.
>>
>> We have a collection with some resources.
>>
>> When I click on the resource's link   - the red rectangle in the attached
>> screenshot (
>> https://www.data.sa.edu.au/dataset/tag-single-nucleotide-polymorphisms-snps-in-cyp1b1/resource/ad11e799-374c-44a3-8f5e-fc73dd2b0070)
>>
>>
>> I  get the following in the apache ssl error log:
>>
>> /dataset/tag-single-nucleotide-polymorphisms-snps-in-cyp1b1/resource/ad11e799-374c-44a3-8f5e-fc73dd2b0070
>> render time 0.074 seconds
>>
>
>> Running strace on apache I see this:
>>
>> [pid 20379] read(22, "import os\nactivate_this = os.pat"..., 4096) = 406
>> [pid 20379]
>> stat("/etc/ckan/prd/apache-prd.wsgi/dataset/tag-single-nucleotide-polymorphisms-snps-in-cyp1b1/resource/acdb3aee-4270-4458-bf6f-97716b04a255",
>> 0x7fff64364740) = -1 ENOTDIR (Not a directory)
>>
>> Which is perfectly correct -  there is no directory at:
>>
>> /etc/ckan/prd/apache-prd.wsgi/dataset/tag-single-nucleotide-polymorphisms-snps-in-cyp1b1/resource/acdb3aee-4270-4458-bf6f-97716b04a255
>>
>> When I click on the button  Explore->Go To Resource  (yellow rectangle in
>> atached screenshot):
>>
>> This URL  loads and displays the expected data:
>>
>> https://www.data.sa.edu.au/storage/f/2014-06-27T04:19:20.451Z/cyp1b1cleaned3.ped
>>
>>
>> We're using:
>> mod_wsgi  on centos 5
>> with python 2.6.6
>> httpd-tools-2.2.15-31.el6.centos.x86_64
>> httpd-2.2.15-31.el6.centos.x86_64
>> mod_wsgi-3.2-3.el6.x86_64
>>
>> And ckan was installed like this:
>> pip install -e 'git+https://github.com/ckan/ckan.git@ckan-2.1.1#egg=ckan'
>> .
>>  I gather that  for some reason mod_wsgi/CKAN  is not mapping a URL to a
>> filesystem path, but I'm not sure why or how to fix it.
>>
>> Any pointers very gratefully received.
>>
>> Thanks
>> Jason
>>
>> --
>> Jason Tan
>> Data Infrastructure Specialist, eResearch SA
>>
>> phone: +61 8 8313 2184
>> Mob: +61 407 268 270
>> email: jason.tan at ersa.edu.au
>> web: http://www.ersa.edu.au
>>
>> _______________________________________________
>> 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
>
>


-- 
Jason Tan
Data Infrastructure Specialist, eResearch SA

phone: +61 8 8313 2184
Mob: +61 407 268 270
email: jason.tan at ersa.edu.au
web: http://www.ersa.edu.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140918/056f7db7/attachment-0003.html>