12 月 20
Alfresco, 未分類 AAAR, alfresco No Comments
Alfresco版本為 Community Edition
編輯以下設定檔
/opt/alfresco-community/tomcat/shared/classes/alfresco-global.properties
原因在於AAAR無法讀到正確的資料庫變數, 誤為資料庫名字就叫 ${db.name}
db.url=jdbc:postgresql://localhost:5432/${db.name}
為便於AAAR讀取, 直接改為以下即可
db.url=jdbc:postgresql://localhost:5432/alfresco
12 月 16
Alfresco, 未分類 AAAR, alfresco No Comments
預設的50,000若不足夠, 可能會使得PDF產出內容, 侷限在某個日子
變更 500,000筆後, 約15分鐘
11 月 08
Alfresco, 未分類 AAAR, alfresco No Comments
2016/11/08 14:23:45 - HTTP - Start of HTTP job entry. 2016/11/08 14:23:45 - HTTP - Connecting to URL: https://imkm.udngroup.com:443/alfresco/service/api/audit/query/alfresco-access?verbose=true&fromId=0&limit=50000 2016/11/08 14:23:46 - HTTP - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target 2016/11/08 14:23:46 - HTTP - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1949) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:296) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1509) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.Handshaker.processLoop(Handshaker.java:979) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.Handshaker.process_record(Handshaker.java:914) 2016/11/08 14:23:46 - HTTP - at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1062)
AAAR設定為 https 連線時, 會無法正確產出報表, 部分網站認為是 tomat 7 不支援SSL 1024bit以上的加密, 只能暫以走 http (port 80)
9 月 06
Alfresco, 未分類 AAAR, alfresco No Comments
造成 AAAR 讀取失效
1.在AAAR的紀錄下, 看到 http too many redirects
2.因tomcat 改由 http-proxy後, 網頁內容無法被 AAAR讀取, 進而無法登入,
3.利用apache的 AJP 做 ProxyReversePass , 可以順利讓AAAR主機登入
4.只是要重跑AAAR的Install
5.後記, 如果能找出正確的設定位置, 或許可以只要改 port number即可
更新,
應該不是這回事, 要重新再找問題了
———–
https://geofoss.net/2015/10/22/simple-ssl-proxy-for-alfresco-share/
另需要存取 postgresql
vim postgresql.conf
listen_ip
vim pg_hba.conf
allow IP
8 月 23
Alfresco, 未分類 AAAR, alfresco No Comments
在某些情況, AAAR會無法順利執行 Extract 及 publish 的 crontab
大部分情況是因為AAAR.log檔案無法被寫入
所以編寫一script, 強迫進入特定有權限的目錄
bash scripts
————————-Top ———————–
#/bin/bash
cd /opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script
./AAAR_Extract.sh silent
cd /opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script
./AAAR_Publish.sh silent
————————-End ———————–
然後放到 crontab 去執行
AAAR_Publish.sh執行後會出PDF格式的報表,以 admin 的身分產出檔案。
8 月 19
Alfresco, 未分類 AAAR, alfresco No Comments
編輯 /opt/{alfresco-home-directory}/tomcat/shared/classes/alfresco-global.properties
增加以下兩行, 即可啟用 Pivot4j 的 audit 功能
# Alfresco Audit service
audit.enabled=true
audit.alfresco-access.enabled=true
7 月 11
Alfresco, 未分類 AAAR, alfresco No Comments
reset password
https://addons.alfresco.com/addons/alfresco-login-reset-password
Custom Alfresco Share header
https://addons.alfresco.com/addons/custom-alfresco-share-header
Permission Label for Share – Increase Alfresco User Engagement (要錢)
https://addons.alfresco.com/addons/permission-label-share-increase-alfresco-user-engagement
ECM Navigator (看資料夾)
https://addons.alfresco.com/addons/ecm-navigator
外部使用者存取安全
https://addons.alfresco.com/addons/sharebox-secure-external-sharing
(未確認) (要錢)
https://addons.alfresco.com/addons/formdocs-alfresco-formfactor
Alfresco Audit Analysis and Reporting (A.A.A.R.), 須另安裝Pentaho Data Integration
https://addons.alfresco.com/addons/alfresco-audit-analysis-and-reporting-aaar
OCR
https://addons.alfresco.com/addons/alfresco-simple-ocr-action
RSS