VirtualBox5(VM)+Ubuntu12(OS Linux)+CKAN2.4(include Postgre9 DB)

1. 由 官網 下載並安裝：VirtualBox 5.0.6 for Windows hosts

http://download.virtualbox.org/virtualbox/5.0.6/VirtualBox-5.0.6-103037-Win.exe

2. 由 官網 下載並安裝：Ubuntu 12.04.5
http://releases.ubuntu.com/12.04.5/ubuntu-12.04.5-desktop-amd64.iso

virtualbox+ubuntu安裝, 請參考網友分享：http://blog.xuite.net/yh96301/blog/220731233
ubuntu中文輸入法問題, 請參考網友分享

windows與 Linux 設定共享資料夾, 請參考網友分享
 每重新開機就要重掛一次: sudo mount -t vboxsf ckan-share /home/---/d-share

3. 在ubuntu中，下載並安裝 CKAN from package：

http://docs.ckan.org/en/ckan-2.4.1/maintaining/installing/install-from-package.html

 ubuntu打開 "終端機" (從左側第一個icon "dash主目錄"，搜尋terninal)，依照 官方網站步驟 輸入以下指令：

3-1. 獲取更新程式：sudo apt-get update

3-2. 安裝更新程式：sudo apt-get install -y nginx apache2 libapache2-mod-wsgi libpq5

3-3. 取得CKAN：wget http://packaging.ckan.org/python-ckan_2.4_amd64.deb

3-4. 安裝CKAN：sudo dpkg -i python-ckan_2.4_amd64.deb

3-5. 安裝postgre DB, solr, jetty：sudo apt-get install -y postgresql solr-jetty

3-5-1. 安裝JDK:

cd /usr/lib/jvm
sudo apt-get install openjdk-6-jdk

3-6. 修改設定檔： /etc/default/jetty

 先用root改資料夾權限777

  sudo -s    (進入root)
  chmod 777 檔名

4.
Start the Jetty server:
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

sudo service jetty restart

 

open http://localhost:8983/solr/ in your web browser

修改：ckan/config/solr
 solr_url=http://127.0.0.1:8983/solr

修改後台位置, 詳見官網:
http://docs.ckan.org/en/ckan-2.4.1/maintaining/solr-multicore.html

open http://localhost:8983/solr/ckan_default/admin
 

5. 設定DB：

sudo -u postgres psql –l　　(確定utf-8)
/q

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

在etc/postgresql/9.1/main路徑下，修改：
postgresql.conf
    listen_addresses = 'localhost'
pg_hba.conf
   host all all 192.168.1.22/32 md5

修改：/etc/ckan/default/production.ini
 　sqlalchemy.url = postgres://USERNAME:PASSWORD@HOST/DBNAME　　（改成實際值）

 　ckan.site_id = default
 　ckan.site_url = http://demo.ckan.org

查出hostname：
   hostname

sudo ckan db init

sudo service apache2 restart
sudo service nginx restart

Open http://localhost in your web browser

請參考中文官網安裝: http://ckan-docs-tw.readthedocs.org/zh_TW/2.4/install.html

paster serve /etc/ckan/default/development.ini
Open http://127.0.0.1:5000/ 

------------------以上基本安裝已完成----以下是設定-----

Getting start　依官網所述步驟，建立系統管理員帳號：

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

  如果重新開機, 要重啟apache

  sudo a2enmod wsgi
  sudo service apache2 restart 

  sudo service jetty restart

 sudo service nginx restart
 open http://localhost:8983

 open http://localhost:8983/solr/
 open http://localhost

安裝paster: sudo apt-get install python-pastescript

進入虛擬環境才可使用paster:

deactivate
. /usr/lib/ckan/default/bin/activate

 paster serve /etc/ckan/default/production.ini
Open http://localhost:5000/

cd /usr/lib/ckan/default/src/ckan

paster sysadmin add seanh -c /etc/ckan/default/production.ini

paster create-test-data -c /etc/ckan/default/production.ini

安裝datastore: http://ckan-docs-tw.readthedocs.org/zh_TW/latest/datastore-datapusher.html

paster --plugin=ckan datastore set-permissions -c /etc/ckan/default/production.ini

-------------------

 安裝 ckanext-harvest

先照步驟裝一次：https://github.com/ckan/ckanext-harvest

問題解答：https://github.com/ckan/ckanext-harvest/issues/125

/usr/lib/ckan/datapusher/src/src/ckanext-harvest$ paster --plugin=ckanext-harvest harvester gather_consumer --config=/etc/ckan/default/production.ini

sudo service apache2 restart

http://localhost/harvest

新增 harvest source:

http://ckan-docs-tw.readthedocs.org/zh_TW/latest/ckanext-harvest.html#id2

https://github.com/ckan/ckanext-harvest

開2個 console：執行(如果supervisor有設, 這個就可以不用)
  cd /usr/lib/ckan/datapusher/src/src/ckanext-harvest

   paster --plugin=ckanext-harvest harvester gather_consumer -c /etc/ckan/default/production.ini

   paster --plugin=ckanext-harvest harvester fetch_consumer -c /etc/ckan/default/production.ini

新增預覽：參考官網 

  先設定production.ini

  cd /usr/lib/ckan/default/src/ckan

  paster views create image_view recline_view pdf_view -c /etc/ckan/default/production.ini

 python setup.py develop 

 ------------
DEBUG:

1. Solr 的JAVA_HOME指不到:
解答: 安裝JDK

2. 執行sudo ckan db init, 以下是錯誤訊息:
HTTP code=400, reason=Missing solr core name in path
解答:
  2-1. /etc/ckan/default/production.ini 修改:

  solr_url=http://localhost:8983/solr/ckan_default

  2-2. 再run一次 ckan db init.
  如果還有錯, 進入虛擬環境, 執行以下建db指令
  paster create-test-data -c /etc/ckan/default/production.ini

3.  Permission denied

解答: sudo -s

4.

404 Not Found

The resource could not be found.

解答: pip install ckanext-pdfview

sudo easy_install sqlalchemy