[ckan-pt] Instalação do Basiccharts

[Andres MRM]

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