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.
Error creating a new MySQL database - create H2 instead
-
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.propertiesI 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=8091Then 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=validuserpasswordMySQL 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.dbNote: the /opt/mango/classes/env.properties file is the original, and unchanged, set to create H2 by default.
Question: what did I do wrong?
-
To override the env.properties file place it in overrides/properties
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login