[ckan-pt] Instalação do Basiccharts

Segunda-Feira, 12 de Maio de 2014 - 19:41:41 UTC

Obrigado, Marconi. Tentei com o set_permissions, mas agora está me dando
outro erro:
ProgrammingError: (ProgrammingError) ERRO:  permissão negada para relação _table_metadata

Será que configurei o script errado? Deixei assim:
-- name of the main CKAN database
\set maindb "ckan_default"
-- the name of the datastore database
\set datastoredb "datastore_default"
-- username of the ckan postgres user
\set ckanuser "ckan_default"
-- username of the datastore user that can write
\set wuser "ckan_default"
-- username of the datastore user who has only read permissions
\set rouser "datastore_default"

On 12-05-14 15:53, Marconi Clementino wrote:
>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

>_______________________________________________
>ckan-pt mailing list
>ckan-pt  lists.okfn.org
>https://lists.okfn.org/mailman/listinfo/ckan-pt