5,576
edits
Changes
From SME Server
Jump to navigationJump to search→db command tutorial
/sbin/e-smith/db dbfile delprop key prop1 [prop2] [prop3] ...
/sbin/e-smith/db dbfile delprop key prop1 [prop2] [prop3] ...
Note that on a properly setup sme7.x (path wise) you do not need to include the
{{Note box|Note that on a properly setup SME Server (path wise) you do not need to include the
/sbin/e-smith/ part.
/sbin/e-smith/ part, only use db since you are in the Path of your environment}}
===Only for the configuration database===
db configuration
db configuration
is
is
config
config
Note this only applies to this one often used database file, all others must be referred to using the format
Note this only applies to this one often used database file, all others must be referred to using the format
db dbname xxxx yyyy zzzz
db dbname xxxx yyyy zzzz
/home/e-smith/db
/home/e-smith/db
===Auto completion===
Like in every Linux shell you can use the TAB key when you use the command line to auto complete or propose all available answers
===Examples===
Here are a few examples to demonstrate usage and syntax correlation
Here are a few examples to demonstrate usage and syntax correlation
db dbname show
db dbname show
Using real db names - for the database in /home/e-smith/db/configuration
Using real db names - for the database in /home/e-smith/db/configuration
db configuration show
db configuration show
db configuration show |more
db configuration show |less
db configuration keys
db configuration keys |less
* An example for the imap service
* An example for the imap service
and subfolders and template fragments applicable to particular /etc/file.conf configuration files.
and subfolders and template fragments applicable to particular /etc/file.conf configuration files.
===show all available database===
===show all available databases===
To show a list of existing databases do
To show a list of existing databases do
cd /home/e-smith/db
cd /home/e-smith/db
ls -al
ls -al
which gives something like for offical databases
which gives something like for official databases
total 304
total 304
-rw-r----- 1 root admin 1921 f�vr. 18 2014 accounts
-rw-r----- 1 root admin 1921 f�vr. 18 2014 accounts
-rw-r--r-- 1 root admin 0 f�vr. 2 2013 backups
-rw-r--r-- 1 root admin 0 f�vr. 2 2013 backups
-rw-r----- 1 root admin 8816 nov. 4 19:38 configuration
-rw-r----- 1 root admin 8816 nov. 4 19:38 configuration
-rw-r----- 1 root admin 361 f�vr. 2 2013 domains
-rw-r----- 1 root admin 361 f�vr. 2 2013 domains
-rw-r----- 1 root admin 816 f�vr. 7 2013 hosts
-rw-r----- 1 root admin 816 f�vr. 7 2013 hosts
drwxr-x--- 2 root ldap 4096 f�vr. 22 2013 ldap
drwxr-x--- 2 root ldap 4096 f�vr. 22 2013 ldap
-rw-r----- 1 root admin 3098 f�vr. 2 2013 mailpatterns
-rw-r----- 1 root admin 3098 f�vr. 2 2013 mailpatterns
drwxr-x--- 2 root root 4096 avril 27 2014 mysql
drwxr-x--- 2 root root 4096 avril 27 2014 mysql
drwxr-xr-x 2 root root 4096 nov. 3 21:42 navigation
drwxr-xr-x 2 root root 4096 nov. 3 21:42 navigation
-rw-r----- 1 root admin 299 f�vr. 2 2013 networks
-rw-r----- 1 root admin 299 f�vr. 2 2013 networks
-rw-r----- 1 root admin 0 mars 11 2010 portforward_tcp
-rw-r----- 1 root admin 0 mars 11 2010 portforward_tcp
-rw-r----- 1 root admin 0 mars 11 2010 portforward_udp
-rw-r----- 1 root admin 0 mars 11 2010 portforward_udp
-rw-r----- 1 root admin 271 f�vr. 2 2013 spamassassin
-rw-r----- 1 root admin 271 f�vr. 2 2013 spamassassin
-rw-r--r-- 1 root root 201371 nov. 4 04:04 yum_available
-rw-r--r-- 1 root root 201371 nov. 4 04:04 yum_available
-rw-r--r-- 1 root root 37419 nov. 4 04:04 yum_installed
-rw-r--r-- 1 root root 37419 nov. 4 04:04 yum_installed
-rw-r----- 1 root admin 4459 f�vr. 18 2014 yum_repositories
-rw-r----- 1 root admin 4459 f�vr. 18 2014 yum_repositories
-rw-r--r-- 1 root root 70 nov. 4 04:04 yum_updates
-rw-r--r-- 1 root root 70 nov. 4 04:04 yum_updates
