Hi,
I installed your zips yesterday in a virtual machine. Tutorial was fine and understandable, I had just one issue during the installation and I’d like to share my fix:
While running
./setup-suitecrm-data-integration.sh
the script stopped with an error like “couldn’t create all tables, check user privileges”. The provided user (adminer) was fine, but I found an additional error message in the logs (“Specified key was too long; max key length is 767 bytes”).
I’ve added these db settings:
innodb_file_format = barracuda
innodb_large_prefix = on
innodb_default_row_format = dynamic
After restarting the database and running the .sh-file again, everything went smoothly (thanks for the nice tutorial!).
I used a turnkey-linux for this test installation. The used database:
mysql -v
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6
I’ve never used pentaho before, I guess most users would like to have a summary as well on how to
- create your first own report
- restart the ETL (and maybe how to include custom modules/fields/relations)