Difference between revisions of "Talk:DB Variables Configuration"

From SME Server
Jump to navigationJump to search
(Few tidies, couple of questions.)
Line 3: Line 3:
 
=== Setting db variables to default values ===
 
=== Setting db variables to default values ===
 
Any db variable that has a default value can be reset to the default by deleting the variable entirely, then re-initializing the default database values as follows:
 
Any db variable that has a default value can be reset to the default by deleting the variable entirely, then re-initializing the default database values as follows:
  config delprop key prop
+
  config delprop <key> <prop>
 
  /etc/e-smith/events/actions/initialize-default-databases
 
  /etc/e-smith/events/actions/initialize-default-databases
  
==== Delete or reset a property value ====
+
==== Delete a property value ====
To delete a property value or reset to empty issue one of the following commands
+
To delete the property
 +
db accounts delprop <key> <prop>
 +
 
 +
==== Reset a property value ====
 +
To reset to an empty value
 +
db accounts setprop <key> <prop> <nowiki>''</nowiki>
 +
 
 +
{{Warning box|Database parameters are case sensitive so take great care when typing at the server shell because no error messages are given should you make a mistake.}}
 +
 
 +
----
 +
Angle brackets around the key and prop markers.<br />
 +
Split delete and reset.<br ?>
 +
English corrections.<br />
  
To reset to a empty value
+
Questions:<br />
db accounts setprop key prop <nowiki>''</nowiki>
+
Does initialize-default-databases only set the defaults on poperties that are missing? If so I think that needs to be stated, I'd not want to set the entire db to defaults...
or
+
 
To delete the property
+
The angle brackets is how I always indicate that something is a marker rather than what you actually type. What is the contribs.org style?
db accounts delprop key prop
 
  
{{Warning box|Database parameters are case sensitive so take great care when typing at the server shell because no error messages are given should you make a typo.}}
+
"config ..."  or "db accounts ...", let's be consistent please. "db accounts ..." would only work if the <key> <prop> is in the accounts db wouldn't it? "config ..." works across all the db's doesn't it?<br />
 +
[[User:Allsorts|Allsorts]] ([[User talk:Allsorts|talk]]) 19:02, 13 February 2013 (MST)

Revision as of 04:02, 14 February 2013

Following section to with new para to replace current text

Setting db variables to default values

Any db variable that has a default value can be reset to the default by deleting the variable entirely, then re-initializing the default database values as follows:

config delprop <key> <prop>
/etc/e-smith/events/actions/initialize-default-databases

Delete a property value

To delete the property

db accounts delprop <key> <prop>

Reset a property value

To reset to an empty value

db accounts setprop <key> <prop> ''


Warning.png Warning:
Database parameters are case sensitive so take great care when typing at the server shell because no error messages are given should you make a mistake.



Angle brackets around the key and prop markers.
Split delete and reset.
English corrections.

Questions:
Does initialize-default-databases only set the defaults on poperties that are missing? If so I think that needs to be stated, I'd not want to set the entire db to defaults...

The angle brackets is how I always indicate that something is a marker rather than what you actually type. What is the contribs.org style?

"config ..." or "db accounts ...", let's be consistent please. "db accounts ..." would only work if the <key> <prop> is in the accounts db wouldn't it? "config ..." works across all the db's doesn't it?
Allsorts (talk) 19:02, 13 February 2013 (MST)