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 without mysql dump directories on env.properties
-
Dear All,
We use our customer's remote Mysql in our installation. Customer do not prefer to share mysql dump directories. So that, we make comment the properties shown below in env.properties file. Then we get an error on the console like below. what should we do to prevent this error without adding mysql dump directories.
#db.mysqldump=<location/command for mysqldump executable for backups>
#db.mysql=<location/command for mysql executable for restore>Error:
ERROR 2020-11-19T18:27:26,889 (com.infiniteautomation.mango.spring.components.DiskUsageMonitoringService.doPoll:159) - Unable to get Filestore partition usage
java.nio.file.NoSuchFileException: \data01\mysql
at sun.nio.fs.WindowsException.translateToIOException(WindowsException.java:79) ~[?:1.8.0_252]
at sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:97) ~[?:1.8.0_252]
at sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:102) ~[?:1.8.0_252]
at sun.nio.fs.WindowsLinkSupport.getFinalPath(WindowsLinkSupport.java:107) ~[?:1.8.0_252]
at sun.nio.fs.WindowsFileStore.create(WindowsFileStore.java:83) ~[?:1.8.0_252]
at sun.nio.fs.WindowsFileSystemProvider.getFileStore(WindowsFileSystemProvider.java:482) ~[?:1.8.0_252]
at java.nio.file.Files.getFileStore(Files.java:1461) ~[?:1.8.0_252]
at com.infiniteautomation.mango.spring.components.DiskUsageMonitoringService.doPoll(DiskUsageMonitoringService.java:155) ~[mango-3.7.7.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_252]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) ~[?:1.8.0_252]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_252]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) ~[?:1.8.0_252]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_252]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_252]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252]Thanks!
-
@CraigWeb told me that DiskUsageMonitoringService error is because of permission of mysql user.
What is the exact permission we should give to mysql user?
Thanks!
-
@Nurr The user that Mango is running as will need permissions to that R/W permissions to the MySQL directories.
-
Do you have a mysql script to give this permisson?
-
It is an operating system permission, not a MySQL permission
