The cftpconfig tool may be used for modifying and querying the CompleteFTP configuration database (config.db). Whether run with or without options the tool will always update config.db (schema and/or data) to the latest version of CompleteFTP (unless it's already up-to-date).
By default cftpconfig operates on the configuration file at the default location (i.e. C:\ProgramData\Enterprise Distributed Technologies\Complete FTP\config.db), but this can be changed using the options.
Please note that as cftpconfig operates directly on the configuration file, the CompleteFTP service will need to be restarted to reload the configuration. Until this is done
changes will not be able to be seen in the CompleteFTP manager. Normally this tool should only be used when the service is stopped.
Available options:
| /c [file] | Customize installation using SQL commands in this file or read from stdin if path is absent or '-' (ctrl+Z to mark end of input). |
| /f file | Configure the given configuration file instead of the configuration file at the default location |
| /h | Show help |
| /i file | Import the configuration in the given file instead of upgrading the configuration at the default location |
| /o | Create a new configuration file rather than upgrading the existing config.db. All existing configuration data will be overwritten. |
| /p password | Set administrator password to this |
| /q query | Execute this SQL query (INSERT, UPDATE, DELETE or SELECT) on the configuration. Output generated by SELECT statements is tab-delimited. |
| /r | Generate (and write) random administrator password |
| /v | Verbose - write status messages to console |
The schema of the CompleteFTP configuration database is available upon request. The SQL syntax adds the UPDATE-FROM command. The syntax of the UPDATE-FROM command is
UPDATE TableA SET FieldA1=AliasB.FieldB1 WHERE FieldA2=value1
FROM TableB AliasB WHERE FieldB2=value2A tool such as DB Browser for SQLite may be useful in viewing your config.db file.