{"id":21881,"date":"2023-11-02T13:00:20","date_gmt":"2023-11-02T10:00:20","guid":{"rendered":"https:\/\/trueconf.com/blog\/?p=21881"},"modified":"2023-11-02T14:55:31","modified_gmt":"2023-11-02T11:55:31","slug":"how-to-export-trueconf-server-data-from-linux-to-windows","status":"publish","type":"post","link":"https:\/\/trueconf.com/blog\/knowledge-base\/how-to-export-trueconf-server-data-from-linux-to-windows","title":{"rendered":"How to export TrueConf Server data from Linux to Windows"},"content":{"rendered":"

\"\"<\/a><\/p>\n

The approach to storing TrueConf Server settings depenads on the OS. In Windows, a part of the information is stored in the registry which is not included in Linux. Besides, there are some platform-specific parameters. This is why it is necessary to use a separate utility when importing\/exporting the data required by TrueConf Server.<\/p>\n

<\/p>\n

Important!<\/b> Please take into account that chat history can be saved only if the public server name remains unchanged because the sender of messages is determined by the full TrueConf ID.<\/div>\n

Step 1. TrueConf Server update<\/h2>\n

To migrate successfully, you need to make sure that the new server installed on Windows and the current server are of the same version. On our website, only the latest version of the installation file is available for download. We do not provide earlier versions of the server due to security reasons. So, we suggest updating the current server to the latest version. Read this article<\/a> to learn how it can be done.<\/p>\n

Step 2. Server data export<\/h2>\n
Use the sudo<\/b> program to run the commands in administrator mode, Please make sure that the current user is added to the sudo<\/b> group (check the corresponding instructions for your OS on the Internet). You need to take into account that the sudo<\/b> may not be installed on your OS by default. To check, if this command is available, run sudo -V<\/code>.<\/div>\n

To migrate TrueConf Server, you will need the registration key<\/a> of your TrueConf Server instance and the backup copies listed below.<\/p>\n

Please note that the migration of TrueConf Server from one machine to another will be impossible without these preliminary actions.<\/div>\n

Registration key<\/h3>\n

The registration key cannot be found directly in the control panel due to security reasons. This key was sent to you in the email confirming the registration of your TrueConf Server instance. To find this email, search by content and specify Server ID<\/a> which can be found in the Summary \u2192 License info<\/strong> section.<\/p>\n

Main data<\/h3>\n

Database<\/h4>\n

The database stores all TrueConf Server settings, including chat history and reports.<\/p>\n

How to check the current port number<\/h5>\n

To export the database, you will need to specify the port needed for connecting to the database. The 5444<\/code> port is used by default.<\/p>\n

Since the port could be changed at some point in the past (e.g., the port could be set to 5433<\/code> after updating TrueConf Server from versions earlier than 5.2.9), run this command in the terminal to check the current port number:<\/p>\n

grep port \/opt\/trueconf\/server\/etc\/database\/postgresql.conf<\/pre>\n
Export<\/h5>\n
Then, complete the following steps to export the database:<\/p>\n
    \n
  1. Open the terminal (if it was previously closed).<\/li>\n
  2. Sign in as the postgres<\/b> user:\n
    sudo su postgres<\/pre>\n<\/li>\n
  3. Go to the database directory:\n
    cd \/opt\/trueconf\/server\/bin\/database<\/pre>\n<\/li>\n
  4. Run the following command and specify the current port<\/a>:\n
    .\/pg_dump -p 5444 -c -C -d tcs -f tcs.dump<\/pre>\n
    Data export may take much time if a large number of chats is stored on the server.<\/div>\n<\/li>\n
  5. Sign out of the postgres<\/b> user account by running this command:\n
    exit<\/pre>\n<\/li>\n
  6. Move the file to the home directory or to a portable drive:\n
    sudo mv \/opt\/trueconf\/server\/bin\/database\/tcs.dump \/home\/$USER\/backups<\/pre>\n<\/li>\n<\/ol>\n
    Later, we will refer to this folder as an example. To access it, run this command after copying all the data:<\/p>\n
    sudo chmod -R 777 \/home\/$USER\/backups<\/pre>\n
    Registry<\/h4>\n
    On Windows, the information about groups, aliases, conferences, streams, server settings (parameters for LDAP, SIP\/H.323, WebRTC, federation and so forth) are stored in the registry.<\/p>\n
    To export these settings run this command in the terminal:<\/p>\n
    sudo \/opt\/trueconf\/server\/bin\/vcs\/tc_regkey export \"\" \/home\/$USER\/backups\/registry.csv<\/pre>\n
    To ensure correct transfer of registry from the backup file, you will need to delete the lines that are incompatible with Windows. To do it, run these commands in the terminal:<\/p>\n
    sed -i '\/Configuration,Working Directory\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration,Executable Path\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration,Recordings Path\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration,Ffmpeg Path\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration,Push Script\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration,File Storage Path\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration,version\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration,DB Connection String\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Configuration\\\\ConfDefault,Working Directory\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/WebManager,server_dir\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/WebManager,db_port\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/WebManager,group_security\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/WebManager,group_admin\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/WebManager,client_path\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/Transceivers\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/WebManager\\\\API\\\\AccessTokens\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i '\/WebManager\\\\API\\\\RefreshTokens\\\\\/d' \/home\/$USER\/backups\/registry.csv\r\nsed -i 's\/ffmpeg\\.exe\/\\\/opt\\\/trueconf\\\/server\\\/bin\\\/ffmpeg\\\/ffmpeg\\\/\/' \/home\/$USER\/backups\/registry.csv<\/pre>\n
    If the new server has a different IP address, execute the following command in the terminal:<\/p>\n
    sed -i \"s\/x\\.x\\.x\\.x\/y.y.y.y\/\" \/home\/$USER\/backups\/registry.csv<\/pre>\n
    where:
    \nx\\.x\\.x\\.x<\/code> is the previous IP address with dots (.) escaped, for example, 192\\.168\\.0\\.1<\/code>.
    \ny.y.y.y<\/code> is the new IP address where dots are not escaped, for example: 192.168.1.1<\/code>.<\/p>\n
    HTTPS settings<\/h4>\n
    If you have configured HTTPS, the key and certificate files will be stored in the directory:<\/p>\n
    \/opt\/trueconf\/server\/etc\/webmanager\/ssl<\/pre>\n
    Save the backup copy of this directory:<\/p>\n
    sudo cp -R \/opt\/trueconf\/server\/etc\/webmanager\/ssl \/home\/$USER\/backups<\/pre>\n
    Additional data<\/h3>\n
    Conference and call recordings<\/h4>\n
    If conferences or calls are automatically recorded<\/a> on the server side, the files will be saved in the Recordings folder by default (this folder can be found in the TrueConf Server working directory). To find the location of video files, check the Path<\/b> field in the Recordings<\/b> section of the TrueConf Server control panel.<\/p>\n
    \"\"<\/a><\/p>\n
    If you need to move them to a new server, just copy necessary recordings.<\/p>\n
    sudo cp -R \/opt\/trueconf\/server\/var\/lib\/recordings \/home\/$USER\/backups<\/pre>\n
    Chat files<\/h4>\n
    All chat files shared by the users of your server are saved in the files<\/code> folder in the TrueConf Server working directory by default. To find their exact location, check the Path<\/b> field in the File Storage<\/b> section of the TrueConf Server control panel.<\/p>\n
    \"\"<\/a><\/p>\n
    If it is necessary to move them to the new server, save the backup of this directory. For example, to copy the chat files to the home directory of the current OS user, execute this command:<\/p>\n
    sudo cp -R \/opt\/trueconf\/server\/var\/lib\/files \/home\/$USER\/backups<\/pre>\n
    Log files<\/h4>\n
    Log files may be needed when submitting a ticket to technical support (e.g., to analyze the issues you had when using the previous instance of TrueConf Server).
    \nThe log files are located in the TrueConf installation folder at the path \/opt\/trueconf\/server\/var\/log. To export them, create a backup copy of all directories and files with the cp command that we have already mentioned:<\/p>\n
    sudo cp -R \/opt\/trueconf\/server\/var\/log \/home\/$USER\/backups<\/pre>\n
    User avatars<\/h4>\n
    Avatars of the users registered on your TrueConf Server instance are stored in the avatars<\/code> folder in the TrueConf Server working directory. Copy this directory to a convenient location on your server.<\/p>\n
    By default, it is located at the path \/opt\/trueconf\/server\/var\/lib<\/code>; however, you can check the location in the Control panel \u2192 Settings section<\/strong> (Working path<\/strong> block).<\/p>\n
    \"\"<\/a><\/p>\n
    Copy the directory with this command:<\/p>\n
    sudo cp -R \/opt\/trueconf\/server\/var\/lib \/home\/$USER\/backups<\/pre>\n
    Step 3. TrueConf Server installation<\/h2>\n
    Check this article<\/a> to learn how TrueConf Server can be installed from a file and repository.<\/p>\n
    Do not<\/b> register TrueConf Server after installation.<\/div>\n
    Step 4. Importing date on Windows<\/h2>\n
    Database<\/h3>\n
    How to check the current port number<\/h4>\n
    To ensure successful data import, you will need to specify the port used for connecting to the database. The 5444<\/code> port is used by default.<\/p>\n
    Since the port could be changed at some point in the past (e.g., the port could be set to 5432<\/code> after updating TrueConf Server from versions earlier than 5.2.9), run this command in the terminal to check the current port number:<\/p>\n
    findstr port \"C:\\Program Files\\TrueConf Server\\database\\conf\\postgresql.conf\"<\/pre>\n
    Import<\/h4>\n
    Disable TrueConf services and restart the database service to close all active connections. For this purpose, run these commands as the administrator:<\/p>\n
    sc stop \"TrueConf Web Manager\"\r\nsc stop trueconf-manager\r\nsc stop \"TrueConf Database\" && sc start \"TrueConf Database\"<\/pre>\n
    Next, run the following command to import data:<\/p>\n
    \"C:\\Program Files\\TrueConf Server\\database\\bin\\psql.exe\" -p 5444 -U postgres -d postgres -f tcs.dump<\/pre>\n
    The data import may take much time, if a large number of chats is stored on the server.<\/div>\n
    Registry<\/h3>\n
    To import the registry, run this command:<\/p>\n
    \"C:\\Program Files\\TrueConf Server\\tc_regkey.exe\" import \"\" registry.csv<\/pre>\n
    When all the data is imported, restart the following TrueConf Server services by running these commands consecutively:<\/p>\n
    sc stop \"TrueConf Database\" && sc start \"TrueConf Database\"\r\nsc start \"TrueConf Web Manager\"\r\nsc start trueconf-manager<\/pre>\n
    HTTPS settings<\/h3>\n
      \n
    1. Copy the exported folder<\/a> with the SSL key and certificate to this directory
      \n[installation_path]\\httpconf\\ssl<\/code>, where [installation_path]<\/code> \u2013 the server installation path.<\/li>\n
    2. Go to the TrueConf Server control panel<\/a>.<\/li>\n
    3. In the Web \u2192 HTTPS<\/strong><\/a> section, apply the same key and certificate settings that were used on the previous instance of TrueConf Server.<\/li>\n<\/ol>\n
      Additional data<\/h3>\n
      Copy other data saved in Step 2<\/a> to the corresponding directories of the new server:<\/p>\n