Excel Report

[leoboeng]

@terrypacker he does not start, and the service is in active status

[terrypacker]

Can you zip up the logs/ma.log file from the Mango folder and post that? There will be the reason why it failed to start in the logs and I can then tell you how to fix it.

[leoboeng]

Follow the link

https://drive.google.com/file/d/19-tQDbCn9bl1yHeCeiOLPBST7QJTmcAd/view?usp=sharing

[terrypacker]

The log says:

'Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost''

This is probably due to a permissions problem with MySQL or you have put in the wrong password. I have found that setting up permissions in MySQL is a little tricky.

First make sure you can connect to the 'mango' database in MySQL as the root user from the command line or the MySQL Workbench application. Then restart mango.

I would guess that the root user does not have permissions to access the mango database from localhost. In MySQL each user has permissions to databases based on hostname/IP address.

[leoboeng]

Ah ok thanks, I typed the wrong password. I already made another user use root only for testing.

But do you know if I can copy the data from the old database to the new sql? I tried the backups but it did not work if you missed a large part of the setup.

[terrypacker]

This is a pretty good site for those kinds of questions: https://help.infiniteautomation.com

I found your answer here:
https://help.infiniteautomation.com/database-conversions/?rq=convert database

[leoboeng]

Hi, I switched to MySQL as recommended, but started to make the same mistake. Follow the error photo

[phildunlap]

Hmm. Well, the DATA4 column was not created by Mango, nor was the index on it.

You could post the stack trace produced by running a report here and perhaps it will shed some different light than that from the H2 attempt (copy it from the log file)

The other thing MySQL would enable is a show create table pointValues; statement and a show create table pointValueAnnotations;

You may also want to post a screenshot of the top section of /system_settings.shtm so we can ensure this is indeed MySQL.

[phildunlap]

I see you sent in your log file to support@infiniteautomation.com

If that is fully up to date, then you are still using H2

[leoboeng]

@phildunlap said in Excel Report:

the top section of /system_settings.shtm

I just checked the top section of /system_settings.shtm and I actually saw that you are using H2.

I think it was something of the update, because I made an update and since then it did not work anymore, but before that it was like MYSQL.

I will pass the database to MYSQL and check if the error will continue.