How to install CKAN (Data Portal) on Ubuntu 20.04 in Aliyun

Comprehensive Knowledge Archive Network (CKAN) is an open source software for open data portal, CMS that can help us manage and publish data sets. CKAN is used by central and local governments, research institutions, and other organizations to publish data.

Software Requirements

Operating system
Ubuntu 16.04 64bit is recommended, CKAN is available in .deb package. CKAN has also been tested on CentOS and other major Linux distributions.

Web server

• Apache
• Nginx, for https and caching
• Python 2.7.x

Database server

• Postgres 9.3+
• Redis
• Tomcat/Jetty + Solr

Install Commands:

115  sudo  apt update

  116  apt update

  117  whoami

  118  sudo apt install -y libpq5 redis-server nginx supervisor

  119  cd /root

  120  pwd

  121  ls

  122  wget https://packaging.ckan.org/python-ckan_2.9-py3-focal_amd64.deb

  123  python3 --version

  124  sudo apt-get install python3.8-distutils

  125  sudo dpkg -i python-ckan_2.9-py3-focal_amd64.deb

  126  sudo apt install -y postgresql

  127  sudo -u postgres psql -l

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

Create a Linux user ckan_default, create a database 'ckan_default' in PostgreSQL

System user: ckan_default/ckan001

Database name: ckan_default

  129  sudo -u postgres createdb -O ckanuser ckan_default -E uft-8

  130  cd /home

  131  ls

  132  cd ..

  133  cd /root

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

  135  sudo -u postgres psql -l

  136  cd /home

  137  sudo -u postgres psql -l

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

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

  140  sudo -u postgres psql -l

  141  sudo apt install solr-tomcat -y

  142  vi /etc/tomcat9/server.xml

  143  sudo mv /etc/solr/conf/schema.xml /etc/solr/conf/schema.xml.bak

  144  do ln -s /usr/lib/ckan/default/src/ckan/ckan/config/solr/schema.xml /etc/solr/conf/schema.xml

  145  sudo ln -s /usr/lib/ckan/default/src/ckan/ckan/config/solr/schema.xml /etc/solr/conf/schema.xml

  146  sudo systemctl restart tomcat9.service

  147  history

Check the Solr server:

Welcome to Solr

 

Continue Install commands:

149  vi /etc/ckan/default/ckan.ini

  150  sudo ckan db init

  151  ls

  152  cd /root

  153  ls

  154  sudo ckan db /etc/ckan/default/ckan.ini

  155  vi /etc/ckan/default/ckan.ini

  156  sudo ckan db /etc/ckan/default/ckan.ini

  157  vi /etc/ckan/default/ckan.ini

Change the Ckan.ini:

solr_url = Welcome to Solr

ckan.site_url = Welcome - CKAN

sqlalchemy.url = postgresql://ckan_default:ckan001@localhost/ckan_default

  159  sudo ckan db init

root@iZ2ze2ql9nozv8wqdc69vyZ:~# sudo ckan db init

2022-06-21 19:29:56,794 INFO  [ckan.cli] Using configuration file /etc/ckan/default/ckan.ini

2022-06-21 19:29:56,795 INFO  [ckan.config.environment] Loading static files from public

2022-06-21 19:29:56,843 INFO  [ckan.config.environment] Loading templates from /usr/lib/ckan/default/src/ckan/ckan/templates

2022-06-21 19:29:57,084 INFO  [ckan.config.environment] Loading templates from /usr/lib/ckan/default/src/ckan/ckan/templates

2022-06-21 19:29:57,143 CRITI [ckan.lib.uploader] Please specify a ckan.storage_path in your config

                         for your uploads

2022-06-21 19:29:57,314 INFO  [ckan.cli.db] Initialize the Database

2022-06-21 19:29:59,098 INFO  [ckan.model] CKAN database version upgraded: base -> ccd38ad5fced (head)

2022-06-21 19:29:59,098 INFO  [ckan.model] Database initialised

Initialising DB: SUCCESS

  160  sudo supervisorctl reload

  161  sudo supervisorctl status

  162  sudo systemctl restart nginx

Check the IP for CKAN server:

Welcome - CKAN

Create a user sysadmin:  ckan/ckan0001

#ckan -c /etc/ckan/default/ckan.ini sysadmin add ckan email=ckan@workbench.com name=ckan   

#ckan -c /etc/ckan/default/ckan.ini sysadmin add ckan

Welcome - CKAN

User: ckan/ckan0001 to login

 

Ref :  How to Install CKAN for Open Data Portal on Ubuntu 20.04 • Musa Amin