[ckan-pt] Instalação do Basiccharts
Marconi Clementino
marconix16 gmail.com
Segunda-Feira, 12 de Maio de 2014 - 19:53:01 UTC
Como fica nosso banco datastore :
DATASTORE:
GRANT CONNECT, TEMPORARY ON DATABASE dbpockan_data_storage_utf8 TO public;
GRANT ALL ON DATABASE dbpockan_data_storage_utf8 TO us_ckan; --- *Usuario
CKAN*
GRANT CONNECT ON DATABASE dbpockan_data_storage_utf8 TO
us_ckan_data_select; ---- *Usuario ReadOnly*
GRANT ALL ON SCHEMA public TO us_ckan;
GRANT USAGE ON SCHEMA public TO us_ckan_data_select;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES
TO us_ckan_data_select; *--- Usuario ReadOnly*
2014-05-12 16:46 GMT-03:00 Andres MRM <andres inventati.org>:
> 9.3
>
>
> On 12-05-14 16:44, Marconi Clementino wrote:
>
>> Qual a versão do postgresql?
>>
>>
>> 2014-05-12 16:41 GMT-03:00 Andres MRM <andres inventati.org>:
>>
>> 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
>>>>
>>>>
>>> _______________________________________________
>>> 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
>>
>
> _______________________________________________
> 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/1703115f/attachment-0003.html>
Mais informações acerca da lista ckan-pt