[ckan-pt] Instalação do Basiccharts

Segunda-Feira, 12 de Maio de 2014 - 18:53:22 UTC

Andres, se o erro persistir, você pode editar o arquivo set_permissions.sql
e rodar diretamente no banco.

2014-05-12 15:38 GMT-03:00 Andres MRM <andres  inventati.org>:

> Você tem razão, este comando:
> paster datastore set-permissions postgres -c /etc/ckan/default/development.
> ini
> Está me dando este erro:
> An error occured: psql: FATAL:  database "datastore_default" does not exist
>
> Mas rodando:
> sudo -u postgres psql -l -p 5433
> A base está la:
> ckan_default      | ckan_default | UTF8        | pt_BR.utf8 | pt_BR.utf8 |
> datastore_default | ckan_default | UTF8        | pt_BR.utf8 | pt_BR.utf8 |
> Será que o paster está tentando alterar as permissões no Postgres em 5432 e
> não em 5433 como está configurado no development.ini?
> Ele soube criá-las corretamente na instalação do CKAN...
>
> A configuração está assim:
> sqlalchemy.url = postgresql://ckan_default:SENHA@localhost:5433/ckan_
> default
> ckan.datastore.write_url = postgresql://ckan_default:SENHA@localhost:5433/
> datastore_default
> ckan.datastore.read_url = postgresql://datastore_default:SENHAA@localhost
> :5433/datastore_default
>
>
>
>
> On 12-05-14 13:00, Vitor Baptista wrote:
>
>> Oi Andres,
>>
>> Isso me parece um problema na sua instalação do DataStore. Mais
>> especificamente, na parte de configurar as permissões em
>> http://docs.ckan.org/en/latest/maintaining/datastore.html . Veja lá a
>> documentação e cheque se está tudo certo.
>>
>> Abraços,
>>
>>
>> 2014-05-09 22:05 GMT-03:00 Andres MRM <andres  inventati.org>:
>>
>>  Opa! Agora consegui adicionar os plugins e iniciar o site. Mas quando
>>> vou tentar adicionar alguma base para testar, estou tendo esse erro:
>>>
>>> 2014-05-09 22:02:35,550 ERROR [ckan.model.modification]
>>> (ProgrammingError)
>>> ERRO:  permissão negada para relação _table_metadata
>>> 'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
>>> (u'971d3b53-b5c5-4da5-94db-7e3ada438cd5',)
>>>
>>> Traceback (most recent call last):
>>>  File "/home/andres/ckan/lib/default/src/ckan/ckan/model/
>>> modification.py",
>>> line 79, in notify
>>>    observer.notify(entity, operation)
>>>  File "/home/andres/ckan/lib/default/src/ckan/ckan/lib/
>>> search/__init__.py",
>>> line 128, in notify
>>>    {'id': entity.id}),
>>>  File "/home/andres/ckan/lib/default/src/ckan/ckan/logic/__init__.py",
>>> line 414, in wrapped
>>>    result = _action(context, data_dict, **kw)
>>>  File "/home/andres/ckan/lib/default/src/ckan/ckan/logic/action/get.py",
>>> line 901, in package_show
>>>    resource_dict = item.before_show(resource_dict)
>>>  File "/home/andres/ckan/lib/default/src/ckan/ckanext/
>>> datastore/plugin.py",
>>> line 244, in before_show
>>>    resource_dict['id']
>>>  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/
>>> sqlalchemy/engine/base.py",
>>> line 1449, in execute
>>>    params)
>>>  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/
>>> sqlalchemy/engine/base.py",
>>> line 1628, in _execute_text
>>>    statement, parameters
>>>  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/
>>> sqlalchemy/engine/base.py",
>>> line 1698, in _execute_context
>>>    context)
>>>  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/
>>> sqlalchemy/engine/base.py",
>>> line 1691, in _execute_context
>>>    context)
>>>  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/
>>> sqlalchemy/engine/default.py",
>>> line 331, in do_execute
>>>    cursor.execute(statement, parameters)
>>> ProgrammingError: (ProgrammingError) ERRO:  permissão negada para relação
>>> _table_metadata
>>> 'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
>>> (u'971d3b53-b5c5-4da5-94db-7e3ada438cd5',)
>>> Error - <class 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError)
>>> ERRO:  permissão negada para relação _table_metadata
>>> 'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
>>> (u'971d3b53-b5c5-4da5-94db-7e3ada438cd5',)
>>> 2014-05-09 22:02:35,889 INFO  [ckan.lib.base]
>>>  /dataset/new_resource/ctdtdc render time 0.152 seconds
>>> 2014-05-09 22:02:36,255 INFO  [ckan.lib.base]  /api/i18n/en render time
>>> 0.003 seconds
>>>
>>>
>>> Tentei recriar o BD, mas ele persiste...
>>>
>>> _______________________________________________
>>> ckan-pt mailing list
>>> ckan-pt  lists.okfn.org
>>> https://lists.okfn.org/mailman/listinfo/ckan-pt
>>>
>>>
>>
>>
>> --
>>
>> Vítor Baptista
>>
>> Developer  |  http://vitorbaptista.com |
>> LinkedIn<http://www.linkedin.com/in/vitorbaptista>|
>> @vitorbaptista <http://twitter.com/vitorbaptista>
>>
>> The Open Knowledge Foundation <http://okfn.org>
>>
>> *Empowering through Open Knowledge*
>>
>> http://okfn.org/  |  @okfn <http://twitter.com/okfn>  |  OKF on
>> Facebook<https://www.facebook.com/OKFNetwork> |
>> Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/
>> about/newsletter/>
>>
>
>  _______________________________________________
>> ckan-pt mailing list
>> ckan-pt  lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/ckan-pt
>>
>
> _______________________________________________
> ckan-pt mailing list
> ckan-pt  lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-pt
>

-- 
Atenciosamente,

Marconi Clementino de Oliveira
Analista de Sistemas - DSI - EMPREL
Celular: +55 81 8719-1703
-------------- próxima parte ----------
Um anexo em HTML foi limpo...
URL: <http://lists.okfn.org/pipermail/ckan-pt/attachments/20140512/62f49b8d/attachment-0003.html>