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

Copying Graphical Views from one Mango web server to another


  • I have two servers running Mango under Linux. I'd like to replicate the graphical views from one to the other. However, when I copy the entire ROOT folder from the server with the configured graphical views to the other server, none of the graphical views are retained. Before copying, I stop tomcat, then remove the work folder under the apache folder to clear the web cache, then copy the ROOT folder and start the tomcat service back up.

    I must be missing a step here, any pointers would be greatly appreciated. Thanks,

    Jordan


  • Hi Jordan,

    Graphic views are stored in the database so if you didn't copy your database over that would be your problem. You could also use the export/Import tool.

    Joel.


  • Thanks! Looking in my tomcat home /bin folder, I see a number of files (including startup.sh) but nothing that I know of as a database. What's the databases filename? Might it be in a different location? The contents of tomcat/bin are:

    /usr/local/tomcat/apache-tomcat-6.0.35/bin$ ls -lrt
    total 616
    -rwxr-xr-x 1 root root 1632 Nov 28 2011 version.sh
    -rwxr-xr-x 1 root root 3472 Nov 28 2011 tool-wrapper.sh
    -rw-r--r-- 1 root root 249259 Nov 28 2011 tomcat-native.tar.gz
    -rw-r--r-- 1 root root 32277 Nov 28 2011 tomcat-juli.jar
    -rwxr-xr-x 1 root root 2023 Nov 28 2011 startup.sh
    -rwxr-xr-x 1 root root 1628 Nov 28 2011 shutdown.sh
    -rw-r--r-- 1 root root 2108 Nov 28 2011 shutdown.bat
    -rwxr-xr-x 1 root root 4114 Nov 28 2011 setclasspath.sh
    -rw-r--r-- 1 root root 3150 Nov 28 2011 setclasspath.bat
    -rwxr-xr-x 1 root root 1689 Nov 28 2011 digest.sh
    -rw-r--r-- 1 root root 2108 Nov 28 2011 digest.bat
    -rw-r--r-- 1 root root 1342 Nov 28 2011 cpappend.bat
    -rw-r--r-- 1 root root 199623 Nov 28 2011 commons-daemon-native.tar.gz
    -rw-r--r-- 1 root root 24172 Nov 28 2011 commons-daemon.jar
    -rw-r--r-- 1 root root 2374 Nov 28 2011 catalina-tasks.xml
    -rwxr-xr-x 1 root root 17708 Nov 28 2011 catalina.sh
    -rw-r--r-- 1 root root 11830 Nov 28 2011 catalina.bat
    -rw-r--r-- 1 root root 22705 Nov 28 2011 bootstrap.jar
    -rw-r--r-- 1 root root 2113 Nov 28 2011 version.bat
    -rw-r--r-- 1 root root 3479 Nov 28 2011 tool-wrapper.bat
    -rw-r--r-- 1 root root 2109 Nov 28 2011 startup.bat
    drwxr-xr-x 4 root root 4096 Jun 4 16:03 commons-daemon-1.0.7-native-src

    Thanks again,

    Jordan


  • your database is probably under tomcat6/mangoDB

    Copy the whole mangoDB folder.

    Joel.


  • Great info, thank you! I overwrote the mangoDB folder and started tomcat back up (removed the work folder as usual) but the old screens still show up under graphical view. Does something other than tomcat need to be reset? Thank you very much for your help, I have a lot of work invested in this.

    Jordan


  • Are you sure you overwrote the right database, or you don't have another database that it is running off? Can you compare data points or something else to make sure it's the same database?

    When you say old screens you mean graphic views?

    Joel.


  • I may not be connected to the mangoDB directory database. Does it connect to that by default or is there a setting to connect to it in code? I apologize if this seems basic, I'm still learning the software. Thanks again for the direction,

    Jordan


  • in your WEB-INF\classes\env.properties file under Mango it will show you your location of the Database as:

    db.type=derby
    db.url=~/../../mangoDB

    You could change it to db.url=~/mangoDB which will place it under the Mango directory.

    Joel.


  • Hi Joel, I tried setting those parameters (with the path for my system) and it didn't work to bring back the graphical views. I very much appreciate the time you've spent assisting me today, if you have any other suggestion for places the database is configured in the code or any other possible configuration parameters to check let me know. If not, thanks again.

    Jordan


  • Without seeing your systems it's hard to help. If you want you could buy an hour of live support and I could help you figure it out via a webex meeting. Other that I don't know what to suggest. Joel.


  • I may actually do that. Will keep you posted. Thanks,

    Jordan


  • Joel, I would like to tentatively schedule a Webex session for Monday in the early afternoon. Is that possible? If I get derby working with M2M before then it won't be necessary, but I'd like to have it scheduled if possible. Thanks,

    Jordan


  • Ok, I should be available Monday so just let me know.

    Joel.

    joel@infiniteautomation.com