• 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

    Error creating a new MySQL database - create H2 instead

    Mango Automation Installation
    2
    2
    1.7k
    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.
    • M
      mlavelle42
      last edited by

      I setup the overrides file with /opt/mango/ as root. See all three found below.
      ./overrides/classes/properties/env.properties
      ./templates/env.properties
      ./classes/env.properties

      I then changed the /overrides/classes/properties/env.properties file as follows:

      Commented out H2
      #Default database settings, NOTE that on windows this must be an absolute path
      #db.type=h2
      #db.url=jdbc:h2:${ma.home}/databases/mah2
      #db.location=${ma.home}/databases/mah2
      #db.username=
      #db.password=
      #For web console
      #db.web.start=false
      #db.web.port=8091

      Then uncommented MySQL
      #MySQL database settings. Your MySQL instance must already be running and configured before this can be used.
      db.type=mysql
      db.url=jdbc:mysql://localhost/mango
      db.username=validusername
      db.password=validuserpassword

      MySQL was running
      /opt/mango/overrides/classes/properties $ /etc/init.d/mysql status
      ● mysql.service - LSB: Start and stop the mysql database server daemon
      Loaded: loaded (/etc/init.d/mysql)
      Active: active (running) since Wed 2016-04-20 15:17:12 EDT; 2 days ago
      Process: 491 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
      CGroup: /system.slice/mysql.service
      ├─ 596 /bin/sh /usr/bin/mysqld_safe
      └─1004 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log -...

      *But mango built an H2 database in /opt/mango/databases
      7360512 Apr 22 15:20 mah2.h2.db

      Note: the /opt/mango/classes/env.properties file is the original, and unchanged, set to create H2 by default.

      Question: what did I do wrong?

      1 Reply Last reply Reply Quote 0
      • JoelHaggarJ
        JoelHaggar
        last edited by

        To override the env.properties file place it in overrides/properties

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