Difference between revisions of "Install Truxton"
| (5 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
There are several different installations of Truxton. | There are several different installations of Truxton. | ||
| − | = | + | =Community Edition Install= |
| + | Download the zip file and unzip it into a folder. | ||
| + | |||
| + | ==Single Drive Install== | ||
| + | Run <code>Truxton_Installer.exe</code> and accept the defaults. | ||
| + | This will install everything onto the C: drive. | ||
| + | |||
| + | ==Multiple Drive Install== | ||
| + | If you have a system with a small C: drive and at least one large data drive, you will probably want to install Truxton programs on C:, database and data folders on other drives. | ||
| + | To accomplish this, you must run the database and Truxton installers separately. | ||
| + | Let's assume you have a system with the following drives: | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! Drive | ||
| + | ! Task | ||
| + | ! Size | ||
| + | |- | ||
| + | | style="text-align:center;" | C: | ||
| + | | OS | ||
| + | | 256GB | ||
| + | |- | ||
| + | | style="text-align:center;" | D: | ||
| + | | Database | ||
| + | | 4TB | ||
| + | |- | ||
| + | | style="text-align:center;" | E: | ||
| + | | Bulk Data | ||
| + | | 128TB | ||
| + | |} | ||
| + | |||
| + | ===Database Installer=== | ||
| + | In the <code>Prerequisites</code> folder, you will find a PostgreSQL installer named something like <code>postgresql-17.4-1-windows-x64.exe</code>, run this installer. | ||
| + | It will ask the following questions: | ||
| + | Installation Directory: This is where the database programs will go. Accepting the default value of <code>C:\Program Files\PostgreSQL\17</code> is fine. | ||
| + | Select Components: The only two you need are "PostgreSQL Server" and "Command Line Tools" | ||
| + | Data Directory: This is the critical choice. The data folder is where the database will write all of its data files. If your large data drive is drive <code>D:</code>, enter "D:\Truxton Data\Database\data" as the folder name. | ||
| + | Password: By default, the database password is Truxton4n6 | ||
| + | Port: Accepting the default of 5432 is fine. | ||
| + | Advanced Options: Choose "C" as the Locale. | ||
| + | Complete the installation. | ||
| + | |||
| + | ===Truxton Installer=== | ||
| + | Once the database is installed onto its own drive, it is time to install Truxton. | ||
| + | Run <code>Truxton_Installer.exe</code>. | ||
| + | It will install the pieces it needs to run first, then ask you "Would you like to use the default options?" Respond by hitting the N key. | ||
| + | The Truxton setup window will now be displayed. | ||
| + | The important setting here is the "Depot Data Directory:" This is the path to where you want the large [[Depot|depot]] files will be stored. | ||
| + | Enter "E:\Truxton Data" | ||
| + | Finish the install. | ||
| + | |||
| + | =Stand-alone Install= | ||
From the root of the ISO folder, run <code>Truxton_Installer.exe</code> and accept the defaults. | From the root of the ISO folder, run <code>Truxton_Installer.exe</code> and accept the defaults. | ||
The database will be running on this machine. | The database will be running on this machine. | ||
| Line 23: | Line 73: | ||
** Set the <code>[[Default_ETL_Options|hashsetdir]]</code> setting to point to a folder on an SSD and move the NSRL hashset there | ** Set the <code>[[Default_ETL_Options|hashsetdir]]</code> setting to point to a folder on an SSD and move the NSRL hashset there | ||
** Set the <code>[[Default_ETL_Options|depotshare]]</code> setting to contain the name of the share of the depot folder | ** Set the <code>[[Default_ETL_Options|depotshare]]</code> setting to contain the name of the share of the depot folder | ||
| − | ** Restart the Truxton service | + | ** Restart the [[Truxton Service|Truxton]] service |
===Client=== | ===Client=== | ||
| Line 34: | Line 84: | ||
==Existing Install== | ==Existing Install== | ||
===Server=== | ===Server=== | ||
| + | If you are converting a stand-alone installation of Truxton to be a server, you will have to modify a few things. | ||
| + | * Stop the [[Truxton Service|Truxton]] service | ||
| + | * Share the Depot folder. The resulting share name will be something like <code>\\TruxServer\Depot</code> | ||
| + | * Set the <code>[[Default_ETL_Options|depotshare]]</code> setting to contain the name of the share of the depot folder | ||
| + | * Restart the [[Truxton Service|Truxton]] service | ||
| + | * Modify the existing entries in the <code><nowiki>[</nowiki>[[Depot Table|Depot]]<nowiki>]</nowiki></code> table to have the <code>URI</code> column contain the correct location.<source lang="SQL">UPDATE "Depot" | ||
| + | SET "URI" = REPLACE( "URI", '\\Machine\Share\', '\\TruxServer\Depot\') | ||
| + | WHERE "URI" LIKE '\\\\Machine%'</source> | ||
| + | ** [[Useful_SQL_Queries#Change_Depot_URI|Here's]] the SQL to change the URI | ||
| + | ** You can also [[Useful_SQL_Queries#Change_Depot_Path|change the depot path]] if need be. | ||
===Client=== | ===Client=== | ||
| + | * Run the <code>Truxton_Analyst_4.3.0.30731.exe</code> installer. | ||
| + | * Run the Analyst desktop and change the database connection to point to the server. | ||
| + | * If you want the client to be unable to load data into Truxton: | ||
| + | ** Stop the [[Les]] service. You can prevent it from running by executing <source lang="bat>sc config "Les" start=disabled</source> | ||
| + | ** Stop the [[Truxton Service|Truxton]] service. You can prevent it from running by executing <source lang="bat>sc config "Truxton" start=disabled</source> | ||
Latest revision as of 08:00, 9 March 2025
Contents
Description
There are several different installations of Truxton.
Community Edition Install
Download the zip file and unzip it into a folder.
Single Drive Install
Run Truxton_Installer.exe and accept the defaults.
This will install everything onto the C: drive.
Multiple Drive Install
If you have a system with a small C: drive and at least one large data drive, you will probably want to install Truxton programs on C:, database and data folders on other drives. To accomplish this, you must run the database and Truxton installers separately. Let's assume you have a system with the following drives:
| Drive | Task | Size |
|---|---|---|
| C: | OS | 256GB |
| D: | Database | 4TB |
| E: | Bulk Data | 128TB |
Database Installer
In the Prerequisites folder, you will find a PostgreSQL installer named something like postgresql-17.4-1-windows-x64.exe, run this installer.
It will ask the following questions:
Installation Directory: This is where the database programs will go. Accepting the default value of C:\Program Files\PostgreSQL\17 is fine.
Select Components: The only two you need are "PostgreSQL Server" and "Command Line Tools"
Data Directory: This is the critical choice. The data folder is where the database will write all of its data files. If your large data drive is drive D:, enter "D:\Truxton Data\Database\data" as the folder name.
Password: By default, the database password is Truxton4n6
Port: Accepting the default of 5432 is fine.
Advanced Options: Choose "C" as the Locale.
Complete the installation.
Truxton Installer
Once the database is installed onto its own drive, it is time to install Truxton.
Run Truxton_Installer.exe.
It will install the pieces it needs to run first, then ask you "Would you like to use the default options?" Respond by hitting the N key.
The Truxton setup window will now be displayed.
The important setting here is the "Depot Data Directory:" This is the path to where you want the large depot files will be stored.
Enter "E:\Truxton Data"
Finish the install.
Stand-alone Install
From the root of the ISO folder, run Truxton_Installer.exe and accept the defaults.
The database will be running on this machine.
The depot files will be stored on a folder on this machine.
This is much like a single machine install.
Client Server Install
This installation is where you have a database server and depot folders are shared.
New Install
Server
From the root of the ISO folder, run Truxton_Installer.exe and customize it to:
- Put the database onto an SSD drive
- Put the depot files into folder in storage
Customize the install by:
- Share the Depot folder. The resulting share name will be something like
\\TruxServer\Depot - Edit TruxtonSettings.xml to:
- Set the
hashsetdirsetting to point to a folder on an SSD and move the NSRL hashset there - Set the
depotsharesetting to contain the name of the share of the depot folder - Restart the Truxton service
- Set the
Client
- Run the
Truxton_Analyst_4.3.0.30731.exeinstaller. - Run the Analyst desktop and change the database connection to point to the server.
- If you want the client to be unable to load data into Truxton:
Existing Install
Server
If you are converting a stand-alone installation of Truxton to be a server, you will have to modify a few things.
- Stop the Truxton service
- Share the Depot folder. The resulting share name will be something like
\\TruxServer\Depot - Set the
depotsharesetting to contain the name of the share of the depot folder - Restart the Truxton service
- Modify the existing entries in the
[Depot]table to have theURIcolumn contain the correct location.UPDATE "Depot" SET "URI" = REPLACE( "URI", '\\Machine\Share\', '\\TruxServer\Depot\') WHERE "URI" LIKE '\\\\Machine%'
- Here's the SQL to change the URI
- You can also change the depot path if need be.
Client
- Run the
Truxton_Analyst_4.3.0.30731.exeinstaller. - Run the Analyst desktop and change the database connection to point to the server.
- If you want the client to be unable to load data into Truxton: