[ckan-pt] Instalação do Basiccharts
Marconi Clementino
marconix16 gmail.com
Terça-Feira, 13 de Maio de 2014 - 12:41:06 UTC
O site de Recife está com o ckan 2.0 e datastorer.
Na documentação do 2.0 ele recomendava o datastorer. O datapusher estou
conhecendo por aqui.
Em 13/05/2014 08:12, "Carlos Augusto" <carlosmarcosaugusto gmail.com>
escreveu:
> Dúvida minha também: DataPusher ou Datastorer?
>
>
>
> Em 13 de maio de 2014 05:34, Andres MRM <andres inventati.org> escreveu:
>
>> O Datastorer não é o para versões mais antigas do CKAN?
>>
>> E isso tudo é estranho, instalei o CKAN há alguns dias atrás e não tive
>> problemas. Mas era o branch principal, não esse das views, e era em um
>> Postgres na porta padrão. Por isso é que acho que uma dessas coisas que
>> está causando os problemas.
>>
>>
>> On 13-05-14 00:35, Marconi Clementino wrote:
>>
>>> Eu utilizo o datastoreR
>>>
>>>
>>> 2014-05-12 22:02 GMT-03:00 Andres MRM <andres inventati.org>:
>>>
>>> Mais um problema talvez relacionado...
>>>> Instalei o DataPusher segundo as instruções aqui:
>>>> http://docs.ckan.org/projects/datapusher/en/latest/
>>>>
>>>> Mais estou tendo esse erro quando tento dar um push nos dados pelo
>>>> painel no site:
>>>> OperationalError: (OperationalError) no such table: apscheduler_jobs
>>>> u'DELETE FROM apscheduler_jobs WHERE apscheduler_jobs.id = ?' (7,)
>>>>
>>>> Conectando à database datastore_default vai psql, dei um \dt e ele me
>>>> disse que não há tabelas, não parece bom...
>>>>
>>>>
>>>>
>>>> On 12-05-14 21:34, Andres MRM wrote:
>>>>
>>>> As duas últimas linhas resolveram, obrigado.
>>>>> Estranho, será que é algum problema na configuração do paster?
>>>>>
>>>>> On 12-05-14 16:54, Marconi Clementino wrote:
>>>>>
>>>>> A view:
>>>>>>
>>>>>> GRANT ALL ON TABLE _table_metadata TO us_ckan; *-- Usuário CKAN*
>>>>>> GRANT SELECT ON TABLE _table_metadata TO us_ckan_data_select; *---
>>>>>> Usuário
>>>>>> ReadOnly*
>>>>>>
>>>>>>
>>>>>> Rode estes comandos diretamente que passa.
>>>>>>
>>>>>>
>>>>>> 2014-05-12 16:53 GMT-03:00 Marconi Clementino <marconix16 gmail.com>:
>>>>>>
>>>>>> 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
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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
>>>>>
>>>>> _______________________________________________
>>>> 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
>>
>
>
> _______________________________________________
> ckan-pt mailing list
> ckan-pt lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-pt
>
>
-------------- próxima parte ----------
Um anexo em HTML foi limpo...
URL: <http://lists.okfn.org/pipermail/ckan-pt/attachments/20140513/81ffa805/attachment-0003.html>
Mais informações acerca da lista ckan-pt