[commits] [Wiki] changed: SQLAuthHowTo

[Michael Rubinsky]

mrubinsk  Sat, 12 May 2012 02:23:27 +0000

Modified page: http://wiki.horde.org/SQLAuthHowTo
New Revision:  26
Change log:  More appropriate, generic steps.

@@ -32,14 +32,12 @@
  * Log in to Horde as an administrative user
  * Navigate: Administration -> Setup -> Horde, and select the  
Authentication tab.
  * Switch the authentication backend driver to "SQL authentication  
w/custom-made queries"
  * Set the phptype setting to "!MySQL"
-* Set the protocol setting to "TCP/IP"
-* Leave port as the default "3306"
-* Set the hostspec to "localhost" (or to your SQL host if it is not  
on the same machine)
-* Set the username and password paramters to the SQL database  
username and password you set when creating the database
-* Set the encryption to use to store the password in the table to  
crypt-md5 (is this correct?)
-* Set the database field to the one defined when you configured  
dovecot's SQL database (in this case, we will use "users" like on the  
dovecot website)
+* Set the protocol values appropriately for your situation.
+* Set the username and password parameters to the SQL database  
username and password you set when creating the database.
+* Set the database field to the name of the database that contains  
the credential data - in this example, "users".
+* Choose the appropriate encryption algorithm for your authentication  
data. This obviously should match the algorithm that was used to  
create any existing credentials.

  If you are not using domains, then use the following queries:

  * For query_auth, enter: {{SELECT * FROM users WHERE userid = \L AND  
password = MD5(\P);}}