If you’ve had a chance to try SuiteCRM Analytics then i’d love to hear your feedback or any issues you have run into! Im more than happy to answer any questions no matter how simple or complex they might be.
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)
Great feedback thank you! We will look into this issue and try to make future installations a little smoother.
As for documentation and tutorials, thats the next thing we will be working on and version 2 of the solution which will include more reports / dashboards and templates to help you get started.
The first set of tutorials we plan to work on are geared around building reports to help you guys create your own interesting solutions!
i tried to establish the suitecrm data integration and analytics in my local system, i tried to do it in windows machine, and i use cygwin to execute bash commands.
the suitecrm analytics web application is established, but i couldnt establish connection to mysql database when i trying to set up suitecrm data integration . i use mysql in wamp for database.
i copied the data integration and analytics package in C:\wamp64\www folder.
I assume you have configured the install.properties correctly with SuiteCRM database details. Can you test those connection details and make sure they are correct?
the db name , username and password is given right in nstall.properties. and i use mysql workbench as UI for mysql. if you need any more information to help me please ask me
If thats all you are getting out of the log then it looks to me like the data integration engine isn’t starting up. These could be for many reasons but I suspect that its because you are using Windows / cygwin and the setup script has been written and tested on linux.
What I can do is create a setup that will work for Windows for the next release which should be in the next week or so and update the documentation to reflect a windows installation.
If you can hold on a little until the next version I will try and get this fixed.
As far as hooking up to LDAP, it is possible and you can refer to the Pentaho documentation on how to do this here.
Hi, I installed data integration and web analytics in linux environment, the data Integration successfully created tables, but in the web analytics, the tomcat server is started , the application didnt start.please take a look on the attached image.
i deployed and started both data integration and web analytics in linux system, but the web analytics web app is not starting, could you please help me on this?
Can you look at the log file in suitecrm-analytics/tomcat/logs/ called catalina.out? If there is no obvious error you can spot in that log then send me a copy so I can take a look