ProyectoDatosAbiertos

Proyecto sobre datos abiertos de la UGR

Instalación CKAN (versión 2.5, Ubuntu 14.04 64 bits)

Pasos de instalación que luego habrá que automatizar:

Instalar dependencias

sudo apt-get update && apt-get install -y apache2 git-core libapache2-mod-wsgi libpq-dev libpq5 nginx openjdk-7-jdk postgresql python-dev python-pastescript python-pip redis-server solr-jetty

Instalar CKAN

wget http://packaging.ckan.org/python-ckan_2.5-trusty_amd64.deb
sudo dpkg -i python-ckan_2.5-trusty_amd64.deb
sudo pip install -r /usr/lib/ckan/default/src/ckan/requirements.txt

Instalar base de datos PostgreSQL

sudo -u postgres createuser -S -D -R -P ckan_default

Introducir PASSWORD.

sudo -u postgres createdb -O ckan_default ckan_default -E utf-8

Instalar Solr

Editar /etc/default/jetty:

NO_START=1 -> NO_START=0
#JETTY_HOST=$(uname -n) -> JETTY_HOST=127.0.0.1
#JETTY_PORT=8080 -> JETTY_PORT=8983

sudo service jetty start
sudo mv /etc/solr/conf/schema.xml /etc/solr/conf/schema.xml.bak
sudo ln -s /usr/lib/ckan/default/src/ckan/ckan/config/solr/schema.xml /etc/solr/conf/schema.xml
sudo service jetty restart

Editar /etc/ckan/default/production.ini:

sqlalchemy.url = postgresql://ckan_default:pass@localhost/ckan_default -> sqlalchemy.url = postgresql://ckan_default:{PASSWORD}@127.0.0.1/ckan_default
#solr_url = http://localhost:8983/solr -> solr_url=http://127.0.0.1:8983/solr
ckan.site_url = -> ckan.site_url = http://127.0.0.1

Acceder a http://127.0.0.1:8983/solr/.

Crear tablas de la base de datos

cd /usr/lib/ckan/default/src/ckan
paster db init -c /etc/ckan/default/production.ini

Configurar DataStore

Editar /etc/ckan/default/production.ini:

ckan.plugins = stats text_view image_view recline_view -> ckan.plugins = stats text_view image_view recline_view datastore

sudo -u postgres createuser -S -D -R -P -l datastore_default
sudo -u postgres createdb -O ckan_default datastore_default -E utf-8

Editar /etc/ckan/default/production.ini:

#ckan.datastore.write_url = postgresql://ckan_default:pass@localhost/datastore_default -> ckan.datastore.write_url = postgresql://ckan_default:{PASSWORD}@127.0.0.1/datastore_default
#ckan.datastore.read_url = postgresql://datastore_default:pass@localhost/datastore_default -> ckan.datastore.read_url = postgresql://datastore_default:{PASSWORD}@127.0.0.1/datastore_default

sudo ckan datastore set-permissions | sudo -u postgres psql --set ON_ERROR_STOP=1

Comprobar acceso a DataStore (debería devolver un JSON):

curl http://127.0.0.1/api/3/action/datastore_search?resource_id=_table_metadata

Comprobar permiso de escritura:

curl -X POST http://127.0.0.1/api/3/action/datastore_create -H "Authorization: {USER_API}" -d '{"resource": {"package_id": {PACKAGE_ID}}, "fields": [ {"id": "a"}, {"id": "b"} ], "records": [ { "a": 1, "b": "xyz"}, {"a": 2, "b": "zzz"} ]}'

Comprobar recurso creado:

http://127.0.0.1/api/3/action/datastore_search?resource_id={5a3304ac-f742-4dfa-aa56-3829f795f326}

Eliminar recurso de prueba creado:

curl -X POST http://127.0.0.1/api/3/action/datastore_delete -H "Authorization: 6e30990b-8af0-4920-8fee-74958a6bcfaa" -d '{"resource_id": "5a3304ac-f742-4dfa-aa56-3829f795f326"}'

Configurar FileStore

sudo mkdir -p /var/lib/ckan/default

Editar /etc/ckan/default/production.ini:

#ckan.storage_path = /var/lib/ckan -> ckan.storage_path = /var/lib/ckan/default

sudo chown www-data /var/lib/ckan/default
sudo chmod u+rwx /var/lib/ckan/default
sudo service apache2 reload

Probar:

curl http://127.0.0.1/api/3/action/resource_create -H 'Authorization: {USER_API}' --form upload=@{FILE} --form name={NAME} --form url=NULL --form package_id={PACKAGE_ID}

Configurar DataPusher

Editar **/etc/ckan/default/production.ini **:

#ckan.datapusher.url = http://127.0.0.1:8800/ -> ckan.datapusher.url = http://0.0.0.0:8800/
ckan.plugins = stats text_view image_view recline_view datastore -> ckan.plugins = stats text_view image_view recline_view datastore datapusher

sudo service apache2 restart

Configurar visualizaciones

git clone https://github.com/ckan/ckanext-viewhelpers.git
cd ckanext-viewhelpers
sudo python setup.py install

git clone https://github.com/ckan/ckanext-dashboard.git
cd ckanext-dashboard
sudo python setup.py install

git clone https://github.com/ckan/ckanext-basiccharts.git
cd ckanext-basiccharts
sudo python setup.py install

git clone https://github.com/ckan/ckanext-mapviews.git
cd ckanext-mapviews
sudo python setup.py install

sudo pip install ckanext-geoview
sudo pip install ckanext-pdfview

ckan.plugins = stats text_view image_view recline_view datastore -> ckan.plugins = stats viewhelpers resource_proxy dashboard_preview recline_grid_view recline_graph_view recline_map_view text_view image_view webpage_view geo_view pdf_view linechart barchart piechart basicgrid navigablemap choroplethmap datapusher datastore

Instalar servidor de correo

export HOST=opendata.ugr.es
export SERVER=ugr.es
export USER=vagrant

sudo debconf-set-selections <<< "postfix postfix/mailname string $HOST"
sudo debconf-set-selections <<< "postfix postfix/main_mailer_type string 'Internet Site'"
sudo apt install -y postfix

Editar /etc/postfix/main.cf:

myhostname = CKAN -> myhostname = $HOST

Editar sudo nano /etc/postfix/virtual:

Añadir $USER@$HOST $USER

sudo postmap /etc/postfix/virtual
sudo service postfix restart

echo -e '#!/bin/bash\ncd /usr/lib/ckan/default/src/ckan && paster --plugin=ckan post -c /etc/ckan/default/production.ini /api/action/send_email_notifications > /dev/null' | sudo tee /etc/cron.hourly/mail.sh

sudo chmod +x /etc/cron.hourly/mail.sh

Editar /etc/ckan/default/production.ini:

#ckan.activity_streams_email_notifications = true -> ckan.activity_streams_email_notifications = true
ckan.site_title = CKAN -> ckan.site_title = $SITE
#smtp.server = localhost -> smtp.server = $SMTP:$PORT_SMTP
#smtp.starttls = False -> smtp.starttls = True
#smtp.user = [email protected] -> smtp.user = $USER@$SERVER
#smtp.password = your_password -> smtp.password = $PASSWORD va
#smtp.mail_from = -> smtp.mail_from = $USER@$SERVER

sudo service apache2 reload

Instalar worker para trabajos en segundo plano

sudo apt-get install supervisor

Comenzando

http://docs.ckan.org/en/latest/maintaining/getting-started.html

Crear cuenta de administrador del sistema.

export USER=vagrant

cd /usr/lib/ckan/default/src/ckan
paster sysadmin add $USER -c /etc/ckan/default/production.ini
paster create-test-data -c /etc/ckan/default/production.ini

Configuración de autorización

sudo sed -i '/^ckan.auth.*/ s/= .*/= false/' /etc/ckan/default/production.ini
sudo sed -i '/^ckan.auth.roles*/ s/= .*/= admin/' /etc/ckan/default/production.ini

PostgreSQL' full-text search parameters

ckan.datastore.default_fts_lang = spanish

Front-End Settings

ckan.site_title = OpenDataUGR ckan.site_logo = /base/images/ckan-logo.png ckan.site_description = Portal para gestionar los datos abiertos de la UGR ckan.favicon = /images/icons/ckan.ico ckan.gravatar_default = identicon ckan.preview.direct = png jpg gif ckan.preview.loadable = html htm rdf+xml owl+xml xml n3 n-triples turtle plain atom csv tsv rss txt json pdf jpg png

Internationalisation Settings

ckan.locale_default = es ckan.locale_order = en pt_BR ja it cs_CZ ca es fr el sv sr sr@latin no sk fi ru de pl nl bg ko_KR hu sa sl lv ckan.locales_offered = ckan.locales_filtered_out = en_GB

Feeds Settings

ckan.feeds.authority_name = Universidad de Granada ckan.feeds.date = ckan.feeds.author_name = Oficina de Software Libre ckan.feeds.author_link =

Email settings

email_to = [email protected] error_email_from = [email protected] smtp.server = smtp.ugr.es:587 smtp.starttls = True smtp.user = opendata.ugr.es #smtp.password = PASSWORD smtp.mail_from = [email protected]

renatolrr / proyectodatosabiertos Goto Github PK