DB Variables Configuration

Please don't edit, I have not finished yet.

Please feel free to modify or add info to this howto, and make corrections in typos, because I don't speak english very good.

SME7 come with the most used parameters set as variables. These variables are used for pass values to final configuration files. Please, read the Gordon's devguide to understand the template and DB process.

These variables are useful to configure your system simply.

Without DB Variables you must following this process:

• If you need to modify a PHP.INI parameter, usually you need to create a custom-template file, and expand.
  • Make the custom directory
  • Copy the original template file to custom directory
  • Modify the file and save
  • Expand
  • Restart service

With DB Variables:

• The same example above, but with dbvar, execute the following command, expand and restart. In some configuration not need to restart because some signal-event make the necesary expansion and service restart, for example ibay-modify
  • db dbfile setprop key prop1 val1
  • Expand
  • Restart

Suppose you need to increase "memory-limit" in php.

You only execute this sentences:

db configuration setprop php MemoryLimit 64
expand-template /etc/php.ini

and then restart httpd service.

It is VERY IMPORTANT to type correctly, because the variables and keys are case sensitive, but if you make a mistake there are no error to alert you about that, and you think the configuration has changed, but really not changed.

These variables are located in files. Again, refer to Gordon Dev Guide.

The next is only the standard variables defined that come with SME7. Of course you can update this list with new standard variables in future SME versions. I organizing this long list with three columns. The first is the variable, the second is the target variable (located in the final configuration file), and the third is the default value.

ATALK

Usage

db configuration setprop atalk variable value

Affect file: /etc/atalk/netatalk.con

Variable	Target	Default
MaxClients	AFPD_MAX_CLIENTS	20

CLAMAV

Usage

db configuration setprop clamav variable value

Affect file: /etc/clamav.conf

Variable	Target	Default
ArchiveBlockEncrypted	ArchiveBlockEncrypted	no
ArchiveBlockMax	ArchiveBlockMax	no
ArchiveMaxCompressionRatio	ArchiveMaxCompressionRatio	300
ArchiveMaxFiles	ArchiveMaxFiles	1500
ArchiveMaxFileSize	ArchiveMaxFileSize	15M
ArchiveMaxRecursion	ArchiveMaxRecursion	8
Debug	Debug	no
DetectBrokenExecutables	DetectBrokenExecutables	no
IdleTimeout	IdleTimeout	60
LeaveTemporaryFiles	LeaveTemporaryFiles	no
LogClean	LogClean	yes
LogTime	LogTime	yes
LogVerbose	LogVerbose	yes
MaxConnectionQueueLength	MaxConnectionQueueLength	30
MaxDirectoryRecursion	MaxDirectoryRecursion	20
MaxThreads	MaxThreads	20
ReadTimeout	ReadTimeout	300
ScanArchive	ScanArchive	yes
ScanHTML	ScanHTML	yes
ScanMail	ScanMail	yes
ScanOLE2	ScanOLE2	yes
ScanPE	ScanPE	yes
SelfCheck	SelfCheck	1800
StreamMaxLength	StreamMaxLength	25M

In configuration db has ScanRAR but not in templates!!!

PHP

Usage

db configuration setprop php variable value

Affect file: /etc/php.ini

Variable	Target
MaxExecutionTime	max_execution_time
MemoryLimit	memory_limit
PostMaxSize	post_max_size
UploadMaxFilesize	upload_max_filesize
AllowUrlFopen	allow_url_fopen