3,086
edits
Changes
→Disabling the built-in MySQL
NoTouch Center stores its data into a SQL database. The primary database is MySQL, but we also support Oracle (including the latest 12c) and Microsoft SQL Server. Both the [[Installation of NTC (Windows)|NoTouch Center Windows installer]] and the The [[Stratodesk NComputing Virtual Appliance]] come comes with MySQL included, so actually the fact that a database is used is transparent to you and you don't have to worry about that.
If, and only if, you want to use an external database, be it another MySQL that you have installed somewhere, or an existing instance of Oracle or Microsoft SQL server this information is for you. Please also note that we can not support your own external database - if for instance you chose to use Oracle, you must have all the required knowledge and time to deal with Oracle!
* '''lmc.dbpass=''' password of the database user. Default: easyadmin
* '''lmc.dbtype=''' a string value denoting the type of database used. Default: mysql
** <code>mysql </code> for MySQL** <code>jtds </code> for MSMicrosoft SQL Server (preferred)** <code>sqljdbc</code> is an alternative driver for Microsoft SQL Server, relating to Microsoft's SQL-SQLJDBC driver (NoTouch 4.2.14 and later) ** <code>oracle </code> for Oracle** <code>derby </code> for Apache Derby (unsupported)** <code>hsqldb </code> for HSQL (unsupported)** hsqldbmm <code>hsqldbmem</code> for HSQL in-memory (unsupported - "in-memory" means that all contents are gone after reboot)
* '''lmc.dbport=''' an optional TCP port number if it is non-standard for the given database type. Default: empty
* '''lmc.dbPool=''' refers to the [[#Connection Pooling]] mechanism, can be c3p0, dbcp, dbcp2_basic, dbcp2_pooling. Default: empty (means C3P0 will be used)
== Disabling the built-in MySQL ==
=== Stratodesk NComputing Virtual Appliance ===
# [[SSH login|Login to the Virtual Appliance via Secure Shell]] and gain root privileges as described
# Stop the MySQL services by executing these command:
#* service mysql stop mysql
# Make sure MySQL stays deactivated:
#* echo "manual" >> /etc/init/mysql.override
= Database migration =
If you want to migrate your complete NoTouch Center installation (i.e. not just the database), there are easy-to-use migration paths:
* [[Migrate standalone NoTouch Center into Virtual Appliance]]
* [[Virtual Appliance Migration]] to migrate from one instance of the Stratodesk NComputing Virtual Appliance into another.
Remember, this sections deals with migrating the database only. Please always use your database servers tool to import and export. So for example if you move the NoTouch Center database from an older MS SQL server to a newer version on a different server, properly export it on the old one using the Microsoft SQL Server tools and and import it on the new one. Make sure user account, password and privileges are intact on the new system as well.
== MySQL backup and restore ==
For any MySQL installation, be it those created by the NoTouch Center Windows installer or [[Stratodesk NComputing Virtual Appliance]] or any custom/third-party installation you can easily get database contents "in" and "out".
To backup a MySQL database to a file, call:
Note: Your MySQL binaries may not reside in the default PATH, i.e. your command shell may not find it. If you use the MySQL that gets installed by the NoTouch Center Windows installer, you must manually use the full path to the mysql\bin\ subdirectory of the installation folder. That means the complete path of the mysqldump.exe and mysql.exe tools is most likely something like
C:\Program Files\StratodeskNComputing\NoTouch Center\mysql\bin\
== NoTouch Center Database XML files ==
The command line tools "dbimport" and "dbexport" are located in the installation directory of NoTouch Center.
* On Windows systems this is
C:\Program Files\StratodeskNComputing\NoTouch Center\lmc* On a [[Stratodesk NComputing Virtual Appliance]] it is
/opt/center
<LMCDATA ExportFormat="2">
<METADATA>
<About>This is an export of a Stratodesk NComputing database. The content of this file is proprietary and confidential.</About>
<CreationDate TimeSource="Instance-Server">2015-06-15 01:40:56 +0000</CreationDate>
<CreatorTablePrefix></CreatorTablePrefix>
<ProductShortName>NTC</ProductShortName>
<Release>4.1.389</Release>
<Vendor>StratodeskNComputing</Vendor>
[...]
</ProductMetaData>