Difference between revisions of "DB Variables Configuration"

From SME Server
Jump to navigationJump to search
Line 39: Line 39:
 
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.
 
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 two columns. The first is the variable, the second is the target variable.
 
I organizing this long list with two columns. The first is the variable, the second is the target variable.
 +
 +
 +
 +
===ATALK===
 +
====Usage====
 +
db configuration setprop atalk variable value
 +
{| style="color:brown;background-color:#ffffcc;" border="1" cellpadding="5" cellspacing="0"
 +
|+Affect file: /etc/atalk/netatalk.con
 +
!Variable
 +
!Target
 +
|-
 +
|MaxClients
 +
|AFPD_MAX_CLIENTS
 +
|}
 +
  
 
===CLAMAV===
 
===CLAMAV===
Line 122: Line 137:
  
 
In configuration db has ScanRAR but not in templates!!!
 
In configuration db has ScanRAR but not in templates!!!
 +
 +
  
 
===PHP===
 
===PHP===

Revision as of 08:11, 30 March 2007

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 two columns. The first is the variable, the second is the target variable.


ATALK

Usage

db configuration setprop atalk variable value
Affect file: /etc/atalk/netatalk.con
Variable Target
MaxClients AFPD_MAX_CLIENTS


CLAMAV

Usage

db configuration setprop clamav variable value
Affect file: /etc/clamav.conf
Variable Target
ArchiveBlockEncrypted ArchiveBlockEncrypted
ArchiveBlockMax ArchiveBlockMax
ArchiveMaxCompressionRatio ArchiveMaxCompressionRatio
ArchiveMaxFiles ArchiveMaxFiles
ArchiveMaxFileSize ArchiveMaxFileSize
ArchiveMaxRecursion ArchiveMaxRecursion
Debug Debug
DetectBrokenExecutables DetectBrokenExecutables
IdleTimeout IdleTimeout
LeaveTemporaryFiles LeaveTemporaryFiles
LogClean LogClean
LogTime LogTime
LogVerbose LogVerbose
MaxConnectionQueueLength MaxConnectionQueueLength
MaxDirectoryRecursion MaxDirectoryRecursion
MaxThreads MaxThreads
ReadTimeout ReadTimeout
ScanArchive ScanArchive
ScanHTML ScanHTML
ScanMail ScanMail
ScanOLE2 ScanOLE2
ScanPE ScanPE
SelfCheck SelfCheck
StreamMaxLength StreamMaxLength

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