Changes

== Database 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 expand this howto, and make corrections in typos, because I don't speak English very well.}}

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.

SME Server comes with the most used parameters set as variables in its 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 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.

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 administer the server through its server-manager as the database variables are used to set and change configuration parameters.  After editing, the configuration files must be regenerated and affected services need to be restarted.

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

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

You only execute this sentences:

You only need to execute these commands at the server console:

  db configuration setprop php MemoryLimit 64M

  db configuration setprop php MemoryLimit 64M

The first line changes the value for the memory limit of PHP, the second line regenerates the configuration file and the last line will reload Apache (and subsequently also PHP as this is configured as a module of Apache).

The first line changes the value for the memory limit of PHP, the second line regenerates the configuration file and the last line will reload Apache (and subsequently also PHP as this is configured as a module of Apache).

{{drawBoxWarning|content=Database parameters are case sensitive 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.}}

{{drawBoxWarning|content=Database parameters are case sensitive and therefore it is is neccessary to carefully mind their case when typing them at the server shell as no error messages are given when you make a typo.}}

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].

The database system is based on a flat file system, but you should never edit them directly. Instead you should 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 ===

=== Overview of database variables ===

The next section descibes the standard variables defined on SME Server. Of course you can update this list with new standard variables in future SME Server versions.

The next section describes the standard variables defined on SME Server. Please update this list with new standard variables in future SME Server 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.

I am 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.

A lot of the variables can be set using the server-manager but some can not. For example the variable DomainMaster for samba is not important here, because this can be set through server-mananger. On the other hand, the variable RecycleBin is important, because it is not accesible through the server-manager.

A lot of the variables can be set using the server-manager but some can not. For example the variable DomainMaster for samba is not important here, because this can be set through server-manager. On the other hand, the variable RecycleBin is important, because it is not accessible through the server-manager.

Configuration files can use database values from one configuration key only, but can also use multiple keys. The latter is the case for the /etc/rc.d/init.d/masq configuration file. This file takes it values from multiple database keys such as squid and masq.

Configuration files may use database values from a single configuration key, or may use multiple keys. The latter is the case for the /etc/rc.d/init.d/masq configuration file. This file takes it values from multiple database keys such as squid and masq.

It is also possible that multiple configuration files are using the same key, and example of this is the httpd-admin key. This key has a variable TCPPort which is used in multiple files (/etc/httpd/admin-conf/httpd.conf and /etc/services).

It is also possible that multiple configuration files use the same key. An example of this is the httpd-admin key. This key has a variable TCPPort which is used in multiple files (/etc/httpd/admin-conf/httpd.conf and /etc/services).