Changes

Jump to navigation Jump 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

Navigation menu