The purpose of this page is to offer advice on how to securely and reliably host iDempiere either in your LAN or in the cloud. This page is a summary of the many topics discussed at greater lengths on other pages. Please note that hosting iDempiere can be very simple of very complex depending on the needs of your installation. Factors that drive complexity include:
Number of concurrent users
Need for high availability and redundancy
Number of sites or locations
Number of users connecting from the road
If you are hosting for just 3 to 5 people, the process is simple. If you are hosting for 300 concurrent users, the process is much different.
Reference iDempiere Security Page
2014-09-18 Security and Stability Discussion
Introduction
0:01:45 Today's topics
0:03:45 Installation Script
0:08:30 Operating System
0:09:45 Database
0:11:15 - backup strategies
0:16:00 - hot-standby replication
ACTION: upgrading the Ubuntu OS should upgrade your PostgreSQL instance as well.
As a result of this discussion, I created a chuboe_ubuntu_upgrade.sh in the chuboe_utils directory.
I also updated the cronJobs.txt file to include an entry for running weekly upgrades.
0:18:00 Web Server (WebUI)
Note: I updated the chuboe_hg_bindir.sh to be able to run it daily to create a daily commit.
I also updated the cronJobs.txt to include an entry for this script.
0:24:00 AWS (Amazon Web Service) for cloud hosting
0:27:30 Using Security Groups as cocoons
0:32:45 iDempiere Security (Role management)
ACTION: is there a log when someone exports: No
I created an experiment:
Set logs to "Finer"
Export all products
Look at log for key term "Export" - nothing
Looked at AD_ChangeLog - nothing
Looked through logs of any sign of an export - nothing that I could audit.