Difference between revisions of "DB Variables Configuration"

From SME Server
Jump to navigationJump to search
(Modified headers, modified introduction and corrected some typos)
Line 1: Line 1:
 
'''Created by: [[User:PicsOne|PicsOne]] (Normando Hall)'''
 
'''Created by: [[User:PicsOne|PicsOne]] (Normando Hall)'''
  
−
== DB VARIABLES ==
+
== Database variables ==
  
 
{{drawBoxNote|content=Please feel free to modify or add info to this howto, and make corrections in typos, because I don't speak english very good.}}
 
{{drawBoxNote|content=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 [http://mirror.contribs.org/smeserver/contribs/gordonr/devguide/html/devguide.html#SME-INTERNALS SME Server Developer's Guide] to understand the template and DB process.
+
SME Server comes with the most used parameters set as variables in it's internal configuration databases. These variables are used to store values to be used in the final configuration files. Please, read the [http://mirror.contribs.org/smeserver/contribs/gordonr/devguide/html/devguide.html#SME-INTERNALS SME Server Developer's Guide] to understand the template and database process.
  
−
These variables are useful to configure your system simply.
+
These variables are useful to configure your system more easily, as you do not need to modify configuration files directly for most common cases. It also makes it possible to administrate the server through it's server-manager as the database variables are used to set and change configuration parameters, after changing them configuration files only have to be regenerated and affected services nee dto be restarted.
−
 
 
−
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.
 
Suppose you need to increase "memory-limit" in php.
Line 34: Line 17:
 
and then restart httpd service.
 
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.
+
{{drawBoxWarning|content=Database parameters are case sesitive and therefore it is is neccesarry to carefully mind there case when typing them at the server shell as no errors are given when you make a typo.}}
  
−
These variables are located in files. Again, refer to Gordon Dev Guide.
+
The database system is based on a flat file system, but you should never edit them directly. instead you can use the db command. More details on using the database system can be found in the [http://mirror.contribs.org/smeserver/contribs/gordonr/devguide/html/devguide.html#SME-INTERNALS SME Server Developer's Guide].
  
 +
=== Overview of database variables ===
 
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.
  
Line 49: Line 33:
 
All variable are refered to /etc/e-smith/templates/etc directory. If you want to extend this howto, you can add variables from /etc/e-smith/templates/home/httpd/html/horde dir (horde variables), or /etc/e-smith/templates/var/qmail (qmail variables) or /etc/e-smith/templates/var/service (service variables).
 
All variable are refered to /etc/e-smith/templates/etc directory. If you want to extend this howto, you can add variables from /etc/e-smith/templates/home/httpd/html/horde dir (horde variables), or /etc/e-smith/templates/var/qmail (qmail variables) or /etc/e-smith/templates/var/service (service variables).
  
−
 
+
==== AppleTalk (atalk) ====
−
 
 
−
 
 
−
===ATALK===
 
 
''Usage''
 
''Usage''
 
  db configuration setprop atalk variable value
 
  db configuration setprop atalk variable value
Line 68: Line 49:
  
  
−
===CLAMAV===
+
==== Clam AntiVirus (clamav) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop clamav variable value
 
  db configuration setprop clamav variable value
Line 204: Line 185:
  
  
−
===DHCPD===
+
==== DHCP daemon (dhcpd) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop dhcpd variable value
 
  db configuration setprop dhcpd variable value
Line 220: Line 201:
  
  
−
===FLEXBACKUP===
+
==== FlexBackup ====
 
''Usage''
 
''Usage''
 
  db configuration setprop flexbackup variable value
 
  db configuration setprop flexbackup variable value
Line 256: Line 237:
  
  
−
===HTTPD-ADMIN===
+
==== Apache server-manager (httpd-admin) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop httpd-admin variable value
 
  db configuration setprop httpd-admin variable value
Line 272: Line 253:
  
  
−
===MAIL-SPAMASSASSIN===
+
==== SpamAssasin ====
 
''Usage''
 
''Usage''
 
  db configuration setprop spamassassin variable value
 
  db configuration setprop spamassassin variable value
Line 324: Line 305:
  
  
−
===MYSQL===
+
==== MySQL (mysqld) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop mysqld variable value
 
  db configuration setprop mysqld variable value
Line 344: Line 325:
  
  
−
===PHP===
+
==== Php ====
 
''Usage''
 
''Usage''
 
  db configuration setprop php variable value
 
  db configuration setprop php variable value
Line 376: Line 357:
  
  
−
===PPTPD===
+
==== (pptpd) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop pptpd variable value
 
  db configuration setprop pptpd variable value
Line 408: Line 389:
  
  
−
===PROFTPD===
+
==== Pro FTP (proftpd) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop ftp variable value
 
  db configuration setprop ftp variable value
Line 424: Line 405:
  
  
−
===SAMBA===
+
==== Samba (smbd) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop smb variable value
 
  db configuration setprop smb variable value
Line 484: Line 465:
  
  
−
===SQUID===
+
==== Squid Proxy (squid) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop squid variable value
 
  db configuration setprop squid variable value
Line 508: Line 489:
  
  
−
===SSH===
+
==== SSH (sshd) ====
 
''Usage''
 
''Usage''
 
  db configuration setprop sshd variable value
 
  db configuration setprop sshd variable value

Revision as of 10:57, 31 March 2007

Created by: PicsOne (Normando Hall)

Database variables

Template:DrawBoxNote

SME Server comes with the most used parameters set as variables in it's internal configuration databases. These variables are used to store values to be used in the final configuration files. Please, read the SME Server Developer's Guide to understand the template and database process.

These variables are useful to configure your system more easily, as you do not need to modify configuration files directly for most common cases. It also makes it possible to administrate the server through it's server-manager as the database variables are used to set and change configuration parameters, after changing them configuration files only have to be regenerated and affected services nee dto be restarted.

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.

Template:DrawBoxWarning

The database system is based on a flat file system, but you should never edit them directly. instead you can use the db command. More details on using the database system can be found in the SME Server Developer's Guide.

Overview of database variables

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.

The variables included here are important for access from console, not through server-manager. For example the variable DomainMaster for samba is not important here, because this is set through server-mananger. On the other hand, the variable RecycleBin is important, because it is not accesible through server-manager.

Some configuration files get final variables not only from one DB key or template. This is the case of /etc/rc.d/init.d/masq configuration file. This file get variables from DB keys squid, your own key masq and others. An invert example is httpd-admin DB key. This key has a variable TCPPort and affect two files (/etc/httpd/admin-conf/httpd.conf and /etc/services).

All variable are refered to /etc/e-smith/templates/etc directory. If you want to extend this howto, you can add variables from /etc/e-smith/templates/home/httpd/html/horde dir (horde variables), or /etc/e-smith/templates/var/qmail (qmail variables) or /etc/e-smith/templates/var/service (service variables).

AppleTalk (atalk)

Usage 

db configuration setprop atalk variable value
Affected file: /etc/atalk/netatalk.conf
Variable Target Default
MaxClients AFPD_MAX_CLIENTS 20


Clam AntiVirus (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


DHCP daemon (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


Apache server-manager (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


SpamAssasin

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 (mysqld)

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


Pro FTP (proftpd)

Usage 

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


Samba (smbd)

Usage 

db configuration setprop smb variable value
Affected file: /etc/smb.conf
Variable Target Default
RecycleBin recycle disabled
ShadowCopy shadow_copy disabled
DeadTime deadtime 10080
DisplayCharSet display charset ISO8859-1
DosCharSet dos charset 850
LogonDrive logon drive Z
OpLocks oplocks enabled
OsLevel os level 65
ServerString server string SME Server
SMBPorts smb ports 139
UnixCharSet unix charset UTF8
UseClientDriver use client driver yes


Squid Proxy (squid)

Usage 

db configuration setprop squid variable value
Affected file: /etc/squid/squid.conf
Variable Target Default
SafePorts acl Safe_ports port 80
EnforceSafePorts EnforceSafePorts no
Transparent Transparent yes


SSH (sshd)

Usage 

db configuration setprop sshd variable value
Affected file: /etc/ssh/sshd_config
Variable Target Default
TCPPort Port 22
Protocol Protocol 2
UsePAM UsePAM no
MaxAuthTries MaxAuthTries 2
MaxStartups MaxStartups 10:30:60
PasswordAuthentication PasswordAuthentication no
PermitRootLogin PermitRootLogin no


Retrieved from "https://wiki.koozali.org/index.php?title=DB_Variables_Configuration&oldid=1671"