• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Excel Report

    User help
    3
    16
    4.0k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L
      leoboeng @terrypacker
      last edited by leoboeng

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

      0_1530209487404_gfgdfgf.PNG

      1 Reply Last reply Reply Quote 0
      • terrypackerT
        terrypacker
        last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • L
          leoboeng
          last edited by

          Follow the link

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

          1 Reply Last reply Reply Quote 0
          • terrypackerT
            terrypacker
            last edited by

            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.

            1 Reply Last reply Reply Quote 0
            • L
              leoboeng
              last edited by

              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.

              1 Reply Last reply Reply Quote 0
              • terrypackerT
                terrypacker
                last edited by

                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

                1 Reply Last reply Reply Quote 0
                • L
                  leoboeng
                  last edited by

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

                  0_1532435544683_erro relatorio.png

                  1 Reply Last reply Reply Quote 0
                  • phildunlapP
                    phildunlap
                    last edited by

                    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.

                    1 Reply Last reply Reply Quote 0
                    • phildunlapP
                      phildunlap
                      last edited by

                      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

                      1 Reply Last reply Reply Quote 0
                      • L
                        leoboeng
                        last edited by

                        @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.

                        1 Reply Last reply Reply Quote 0
                        • First post
                          Last post