An EASA installation is designed to 'work-off-the-shelf'.

• Default passwords other than for demo are initially assigned and will need to be changed in,
  1. MySQL
  2. Four EASA configuration files
  3. The demo password is set via the EASA configuration record for StockData

• Determine strong passwords for each MySQL user,
  • sa
  • demo
  • exceluser
  • signeruser

• Update MySQL with the new passwords. In a mysql client,
  • mysql> SET PASSWORD FOR 'sa'@'localhost' = 'new_password_for_sa';
  • mysql> SET PASSWORD FOR 'demo'@'localhost' = 'new_password_for_demo';
  • mysql> SET PASSWORD FOR 'exceluser'@'localhost' = 'new_password_for_exceluser';
  • mysql> SET PASSWORD FOR 'signeruser'@'localhost' = 'new_password_for_signeruser';

• In each of the files below,
  • <SERVERDATA>\easa-share\admin\config\
    • easa.cfg.xml
    • excel.cfg.xml
    • excelTesting.cfg.xml
    • signer.cfg.xml

• in a text editor find hibernate.connection.username property
  • eg. <property name=“hibernate.connection.username”>exceluser</property>
• update the corresponding password property below it with a new password,
  • eg.<property name=“hibernate.connection.password”>new_password_for_exceluser</property>

• Navigate to EASA→Administrator→Configure→Databases→Configure Databases
• Select StockData
• Click Edit
• Update the password for demo