erpnext 為開源的erp系統(tǒng)线得，采用python語言編寫担汤，本次部署采用windows7+docker方式進行壤巷，erpnext需要運行python、redis铭段、mariadb或者mysql魂那、nginx。
參考資料
- erpnext gtihub源碼地址 https://github.com/frappe/erpnext
- frappe web框架源碼地址 https://github.com/frappe/frappe
- Multi-tenant platform to manage Frappe（管理工具） / ERPNext https://github.com/frappe/bench
docker鏡像
- dockerfile構建地址 https://github.com/Ridhosribumi/docker-erpnext
erpnext基于ubuntu操作系統(tǒng)構建稠项。
pull erpnext鏡像
docker pull lukptr/erpnext7
運行erpnext
docker run -d --name erpnext -p 80:80 lukptr/erpnext7
- 啟動之后訪問虛擬機ip地址就可以涯雅，比如 192.168.99.100
- 登錄名：Administrator 密碼：12345678
這種方式運行之后，數(shù)據(jù)沒有得到持久化展运，db數(shù)據(jù)沒有持久化活逆，app數(shù)據(jù)沒有進行持久化，如果程序發(fā)生錯誤拗胜，下次再次運行erpnext時蔗候，數(shù)據(jù)就會消失。
erpnext 數(shù)據(jù)持久化
通過docker的volume方式埂软，把docker容器的數(shù)據(jù)持久化到宿主機锈遥。
site1.local 目錄數(shù)據(jù)持久化
- 把容器里面的site1.local目錄復制到windows7系統(tǒng)，在做操作之前勘畔，把windows7的F盤共享給docker宿主機
docker cp erpnext:/home/frappe/frappe-bench/sites/site1.local /F/DataAgg/erpnext/frappe/
如下：
docker@dataagg:/F/DataAgg/erpnext/frappe/site1.local$ ls -la
total 9
drwxrwxrwx 1 docker staff 4096 Mar 20 00:52 ./
drwxrwxrwx 1 docker staff 4096 Mar 20 08:13 ../
drwxrwxrwx 1 docker staff 0 Mar 20 00:52 error-snapshots/
drwxrwxrwx 1 docker staff 0 Mar 19 17:07 locks/
drwxrwxrwx 1 docker staff 0 Mar 19 17:07 private/
drwxrwxrwx 1 docker staff 0 Mar 19 17:07 public/
-rwxrwxrwx 1 docker staff 107 Mar 20 03:29 site_config.json
drwxrwxrwx 1 docker staff 0 Mar 19 17:07 task-logs/
docker@dataagg:/F/DataAgg/erpnext/frappe/site1.local$
- db數(shù)據(jù)持久化
docker cp erpnext:/var/lib/mysql /F/DataAgg/erpnext/
把mysql的數(shù)據(jù)復制到F:\DataAgg\erpnext\mysql下面所灸，下次啟動erpnext時候，映射到宿主機
執(zhí)行docker數(shù)據(jù)持久化命令:
docker run -d --name erpnext -v /F/DataAgg/erpnext/mysql/:/var/lib/mysql/ -v /F/DataAgg/erpnext/frappe/site1.local:/home/frappe/frappe-bench/sites/site1.local -v /F/DataAgg/erpnext/logs:/home/frappe/frappe-bench/logs -p 80:80 lukptr/erpnext7
進入容器查看mysql數(shù)據(jù)權限不對炫七，如下：
# pwd
/var/lib/mysql
# ls -la
total 177065
drwxrwxrwx 1 frappe staff 4096 Mar 20 07:44 .
drwxr-xr-x 29 root root 4096 Mar 15 07:44 ..
drwxrwxrwx 1 frappe staff 393216 Mar 15 07:46 1bd3e0294da19198
-rwxrwxrwx 1 frappe staff 78504 Mar 20 07:36 2ad672a21283.err
-rwxrwxrwx 1 frappe staff 146756 Mar 20 07:44 6f45cefeaeff.err
-rwxrwxrwx 1 frappe staff 24576 Mar 20 07:44 aria_log.00000001
-rwxrwxrwx 1 frappe staff 52 Mar 20 07:44 aria_log_control
-rwxrwxrwx 1 frappe staff 0 Mar 15 07:39 debian-10.1.flag
-rwxrwxrwx 1 frappe staff 240847 Mar 20 07:11 fd9157e5d433.err
-rwxrwxrwx 1 frappe staff 50331648 Mar 20 07:44 ib_logfile0
-rwxrwxrwx 1 frappe staff 50331648 Mar 15 07:38 ib_logfile1
-rwxrwxrwx 1 frappe staff 79691776 Mar 20 07:44 ibdata1
-rwxrwxrwx 1 frappe staff 0 Mar 15 07:39 multi-master.info
drwxrwxrwx 1 frappe staff 40960 Mar 20 06:30 mysql
-rwxrwxrwx 1 frappe staff 15 Mar 15 07:39 mysql_upgrade_info
drwxrwxrwx 1 frappe staff 0 Mar 15 07:39 performance_schema
-rwxrwxrwx 1 frappe staff 24576 Mar 20 07:00 tc.log
#
修改mysql數(shù)據(jù)目錄的用戶和組為mysql爬立，命令:
# chown -R mysql:mysql mysql
# ls -la
total 84
drwxr-xr-x 29 root root 4096 Mar 15 07:44 .
drwxr-xr-x 24 root root 4096 Mar 20 07:37 ..
drwxr-xr-x 7 root root 4096 Mar 15 07:44 apt
drwxr-xr-x 13 root root 4096 Mar 15 07:44 dpkg
drwxr-xr-x 2 root root 4096 Mar 23 2016 git
drwxr-xr-x 2 root root 4096 Feb 5 2016 initscripts
drwxr-xr-x 2 root root 4096 Feb 5 2016 insserv
drwxr-xr-x 2 root root 4096 Apr 12 2016 misc
drwxrwxrwx 1 frappe staff 4096 Mar 20 07:44 mysql
drwxr-xr-x 7 root root 4096 Mar 15 07:44 nginx
drwxr-xr-x 2 root root 4096 Nov 14 16:21 pam
drwxr-xr-x 2 postfix postfix 4096 Mar 15 07:44 postfix
drwxr-xr-x 2 root root 4096 Mar 15 07:37 python
drwxr-xr-x 2 redis redis 4096 Mar 15 07:37 redis
drwxr-xr-x 3 root root 4096 Nov 23 05:00 sudo
drwxr-xr-x 7 root root 4096 Mar 15 07:34 systemd
drwxr-xr-x 2 root root 4096 Nov 23 05:00 ucf
drwxr-xr-x 2 root root 4096 Mar 6 2015 update-rc.d
drwxr-xr-x 2 root root 4096 Feb 5 2016 urandom
drwxr-xr-x 3 root root 4096 Mar 15 07:44 vim
drwxr-xr-x 2 root root 4096 Mar 15 07:37 xfonts
#
發(fā)現(xiàn)/var/lib/mysql的目錄權限沒有發(fā)生變化，再查看mysqld服務是否啟動万哪，多次輸入supervisorctl status 查看服務狀態(tài)
# supervisorctl status
crond:cron RUNNING pid 30, uptime 0:46:25
frappe-bench-redis:frappe-bench-redis-cache RUNNING pid 9, uptime 0:46:25
frappe-bench-redis:frappe-bench-redis-queue RUNNING pid 8, uptime 0:46:25
frappe-bench-redis:frappe-bench-redis-socketio RUNNING pid 10, uptime 0:46:25
frappe-bench-web:frappe-bench-frappe-web RUNNING pid 13, uptime 0:46:25
frappe-bench-web:frappe-bench-node-socketio RUNNING pid 14, uptime 0:46:25
frappe-bench-workers:frappe-bench-frappe-default-worker-0 RUNNING pid 26, uptime 0:46:25
frappe-bench-workers:frappe-bench-frappe-long-worker-0 RUNNING pid 28, uptime 0:46:25
frappe-bench-workers:frappe-bench-frappe-schedule RUNNING pid 27, uptime 0:46:25
frappe-bench-workers:frappe-bench-frappe-short-worker-0 RUNNING pid 29, uptime 0:46:25
mysqld RUNNING pid 7960, uptime 0:00:04
nginx RUNNING pid 17, uptime 0:46:25
# supervisorctl status
crond:cron RUNNING pid 30, uptime 0:46:30
frappe-bench-redis:frappe-bench-redis-cache RUNNING pid 9, uptime 0:46:30
frappe-bench-redis:frappe-bench-redis-queue RUNNING pid 8, uptime 0:46:30
frappe-bench-redis:frappe-bench-redis-socketio RUNNING pid 10, uptime 0:46:30
frappe-bench-web:frappe-bench-frappe-web RUNNING pid 13, uptime 0:46:30
frappe-bench-web:frappe-bench-node-socketio RUNNING pid 14, uptime 0:46:30
frappe-bench-workers:frappe-bench-frappe-default-worker-0 RUNNING pid 26, uptime 0:46:30
frappe-bench-workers:frappe-bench-frappe-long-worker-0 RUNNING pid 28, uptime 0:46:30
frappe-bench-workers:frappe-bench-frappe-schedule RUNNING pid 27, uptime 0:46:30
frappe-bench-workers:frappe-bench-frappe-short-worker-0 RUNNING pid 29, uptime 0:46:30
mysqld RUNNING pid 8061, uptime 0:00:03
nginx RUNNING pid 17, uptime 0:46:30
#
通過上面pid可以發(fā)現(xiàn)侠驯，mysqld的pid一直在遞增，說明mysqld服務一直在重啟奕巍。
由于mysql數(shù)據(jù)目錄的用戶和屬組沒有成功改成mysql吟策，導致mysql服務一直起不來。初步判斷是因為共享機制的問題的止，windows7的數(shù)據(jù)共享個docker 宿主機檩坚，docker宿主機再次把數(shù)據(jù)映射到docker erpnext容器。其他windows系統(tǒng)可以嘗試上面的方法持久化mysql數(shù)據(jù)。在linux下面采用這種方式?jīng)]有問題效床，已經(jīng)測試可以使用。
采用外部mariadb數(shù)據(jù)庫
由于windows7的共享機制嘗試失敗权谁，采用外部db作為erpnext存儲剩檀，達到持久化數(shù)據(jù)目的。
- 修改F:\DataAgg\erpnext\frappe\site1.local目錄下面的site_config.json文件內(nèi)容
{
"db_host": "192.168.10.234",
"db_name": "erpnext",
"db_user": "erpnext",
"db_password": "erpnext"
}
- 修改mariadb的配置文件
[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
- 運行erpnext容器旺芽，備份mysql數(shù)據(jù)
docker run -d --name erpnext -v /F/DataAgg/erpnext/frappe/site1.local:/home/frappe/frappe-bench/sites/site1.local \
-p 80:80 lukptr/erpnext7
# cd /home/frappe/frappe-bench
# bench backup
# pwd
/home/frappe/frappe-bench/sites/site1.local/private/backups
# ls -la
total 3974
drwxrwxrwx 1 frappe staff 4096 Mar 20 08:37 .
drwxrwxrwx 1 frappe staff 0 Mar 19 17:07 ..
-rwxrwxrwx 1 frappe staff 3156985 Mar 20 03:01 20170320_110153_83043d43_database.sql
-rwxrwxrwx 1 frappe staff 453779 Mar 20 03:01 20170320_110153_83043d43_database.sql.gz
-rwxrwxrwx 1 frappe staff 453458 Mar 20 08:37 20170320_163732_b350d2cf_database.sql.gz
#
啟動20170320_163732_b350d2cf_database.sql.gz文件為備份的sql文件
- 在外部db執(zhí)行備份的sql文件
最終采用下面命令啟動erpnext
docker run -d --name erpnext -v /F/DataAgg/erpnext/logs:/home/frappe/frappe-bench/logs -v /F/DataAgg/erpnext/frappe/site1.local:/home/frappe/frappe-bench/sites/site1.local -p 80:80 lukptr/erpnext7
訪問192.168.99.100進入登陸界面沪猴，默認的用戶名Administrator 密碼 12345678，app數(shù)據(jù)和db數(shù)據(jù)得到持久化處理采章。
