[ECODP-dev] Problem with updating the nal list

Thu Sep 26 10:59:15 UTC 2013

Hi Dimitrios,

Just to confirm: which server is this running on (and what database name)?

I cannot connect to postgres on 192.168.35.139 or on the test server.

Regards,
John

On 26 September 2013 12:56, Dimitrios Mexis <dimitrios.mexis at tenforce.com>wrote:

>  Hi John,
> the database back up is under the /home/PO.ftp/odp folder
> and currently it is running there
>
> Regards
> Dimitrios
>
>
> On 26/09/2013 12:54, John Glover wrote:
>
> Hi Bert,
>
>  Thanks for the update, so this has been resolved?
>
>  Could you please keep the database on that machine for now so that we
> can check the table sizes.
>
>  Thanks,
> John
>
>
> On 26 September 2013 12:22, Bert Van Nuffelen <
> bert.van.nuffelen at tenforce.com> wrote:
>
>>    Hi John,
>>
>>  some more background info.
>>
>>  I found out that this publisher was in the past set deprecated in the
>> source RDF, which normally means it was not uploaded then.
>>  Now it has been activated.
>>
>>  Maybe it was active in the past, made then deprecated (so there the
>> delete came from) and now it is resurrected.
>>
>>  Bert
>>
>>
>>
>> 2013/9/26 Bert Van Nuffelen <bert.van.nuffelen at tenforce.com>
>>
>>>   Hi John,
>>>
>>>  we did a quick investigation:
>>>
>>>  this is the problematic publisher: egsa
>>>
>>> The publisher was denoted deleted.
>>>
>>> After this update:
>>>
>>> update public.group set state='active', description='European GNSS
>>> Supervisory Authority', name='egsa1' where name='egsa'
>>>
>>>  the process worked.
>>>
>>>  Bert
>>>
>>>
>>>
>>> 2013/9/26 Dimitrios Mexis <dimitrios.mexis at tenforce.com>
>>>
>>>>  John good morning,
>>>>
>>>> I have the db from PO installed for you on the machine 192.168.35.139,
>>>> where we try to update this database with the corporatebodies-nal.rdf
>>>>
>>>> Running the :
>>>> ./nal2CKAN.sh /tmp/corporatebodies-skos.rdf
>>>> followed by:
>>>> ./ckan_update_publishers.sh
>>>>
>>>> produces this result which is what PO has said :
>>>> 2013-09-26 11:18:02,554 INFO
>>>> [/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/plugin.pyc]
>>>> Reading homepage content from
>>>> /applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal/data/home.json
>>>> 2013-09-26 11:18:02,555 INFO
>>>> [/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/plugin.pyc]
>>>> Reading maintenance message from
>>>> /applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal/data/maintenance.json
>>>> 2013-09-26 11:18:06,505 INFO  [root] Creating CKAN publisher (group)
>>>> objects
>>>> 2013-09-26 11:18:06,518 DEBUG [ckan.logic.action.create] group_create
>>>> validate_errs={'name': ['Group name already exists in database']}
>>>> user=ecportal group=egsa data_dict={'type': u'organization', 'name':
>>>> u'egsa', 'title': u'European GNSS Agency'}
>>>> Traceback (most recent call last):
>>>>   File "/applications/ecodp/users/ecodp/ckan/ecportal/bin/paster", line
>>>> 9, in <module>
>>>>     load_entry_point('PasteScript==1.7.5', 'console_scripts',
>>>> 'paster')()
>>>>   File
>>>> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
>>>> line 104, in run
>>>>     invoke(command, command_name, options, args[1:])
>>>>   File
>>>> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
>>>> line 143, in invoke
>>>>     exit_code = runner.run(args)
>>>>   File
>>>> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
>>>> line 238, in run
>>>>     result = self.command()
>>>>   File
>>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/commands.py",
>>>> line 109, in command
>>>>     self.update_publishers(file_path)
>>>>   File
>>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/commands.py",
>>>> line 456, in update_publishers
>>>>     self._add_publishers(new_publishers)
>>>>   File
>>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/commands.py",
>>>> line 213, in _add_publishers
>>>>     plugins.toolkit.get_action('group_create')(context, group)
>>>>   File
>>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/logic/action/create.py",
>>>> line 538, in group_create
>>>>     raise ValidationError(errors)
>>>> ckan.logic.ValidationError: {'Name': 'Group name already exists in
>>>> database'}
>>>>
>>>>
>>>> It would very kind to ssh that machine with password I can give you in skype
>>>> and give us your perspective.
>>>> Database of this mashine is on 192.168.35.137
>>>>
>>>> Best
>>>> Dimitrios
>>>>
>>>
>>>
>>>
>>>  --
>>> Bert Van Nuffelen
>>>
>>> Semantic Technologies Software Architect at TenForce
>>> www.tenforce.be
>>>
>>> Bert.Van.Nuffelen at tenforce.com
>>> Office: +32 (0)16 31 48 60 <%2B32%20%280%2916%2031%2048%2060>
>>> Mobile:+32 479 06 24 26 <%2B32%20479%2006%2024%2026>
>>> skype: bert.van.nuffelen
>>>
>>
>>
>>
>> --
>> Bert Van Nuffelen
>>
>> Semantic Technologies Software Architect at TenForce
>> www.tenforce.be
>>
>> Bert.Van.Nuffelen at tenforce.com
>> Office: +32 (0)16 31 48 60 <%2B32%20%280%2916%2031%2048%2060>
>> Mobile:+32 479 06 24 26 <%2B32%20479%2006%2024%2026>
>> skype: bert.van.nuffelen
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130926/1797557e/attachment.html>