DB Variables Configuration

From SME Server
Jump to navigationJump to search

Created by: PicsOne (Normando Hall)

DB VARIABLES

Template:DrawBoxNote

SME7 come with the most used parameters set as variables. These variables are used for pass values to final configuration files. Please, read the SME Server Developer's Guide 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
Affected file: /etc/atalk/netatalk.conf
Variable Target Default
MaxClients AFPD_MAX_CLIENTS 20


CLAMAV

Usage

db configuration setprop clamav variable value
Affected 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


Affected file: /etc/freshclam.conf
Variable Target Default
Checks Checks 24
DatabaseMirror DatabaseMirror db.local.clamav.net
DNSDatabaseInfo DNSDatabaseInfo current.cvd.clamav.net
LogVerbose LogVerbose yes
MaxAttempts MaxAttempts 6


DHCPD

Usage

db configuration setprop dhcpd variable value
Affected file: /etc/dhcpd.conf
Variable Target Default
Bootp bootp deny


FLEXBACKUP

Usage

db configuration setprop flexbackup variable value
Affected file: /etc/flexbackup.conf
Variable Target Default
Blocksize $blksize 32
TapeBlocksize $mt_blksize 0
BufferProg $buffer buffer
BufferMegs $buffer_megs 20
erase_rewind_only $erase_rewind_only false
Type $type tar


HTTPD-ADMIN

Usage

db configuration setprop httpd-admin variable value
Affected file: /etc/httpd/admin-conf/httpd.conf and /etc/services
Variable Target Default
TCPPort TCPPort 980

MAIL-SPAMASSASSIN

Usage

db configuration setprop spamassassin variable value
Affected file: /etc/mail/spamassassin/local.cf
Variable Target Default
DNSAvailable dns_available yes
OkLanguages ok_languages all
OkLocales ok_locales all
ReportSafe report_safe 0
Subject rewrite_header Subject [SPAM]
SkipRBLChecks skip_rbl_checks 0
TrustedNetworks trusted_networks 127.
UseAutoWhitelist use_auto_whitelist 0
UseBayes use_bayes 0
Sensitivity required_hits medium


MYSQL

Usage

db configuration setprop mysqld variable value
Affected file: /etc/my.cnf
Variable Target Default
InnoDB InnoDB disabled
LocalNetworkingOnly LocalNetworkingOnly no


PHP

Usage

db configuration setprop php variable value
Affected file: /etc/php.ini
Variable Target Default
MaxExecutionTime max_execution_time 30
MemoryLimit memory_limit 32M
PostMaxSize post_max_size 20M
UploadMaxFilesize upload_max_filesize 10M
AllowUrlFopen allow_url_fopen Off


PPTPD

Usage

db configuration setprop pptpd variable value
Affected file: /etc/ppp/options.pptpd
Variable Target Default
debug debug no
Passive passive enabled


Affected file: /etc/pptpd.conf
Variable Target Default
debug debug no


PROFTPD

Usage

db configuration setprop ftp variable value
Affected file: /etc/proftpd.conf
Variable Target Default
DisableAnonymous DisableAnonymous no