[horde] mysql ssl help!

[Nicolás Valera]

On 06/03/2013 10:30 AM, Michael J Rubinsky wrote:
>
> Quoting Nicolás Valera <nvalera at gmail.com>:
>
>> Hi,
>>
>> I'm trying to configure horde authentication with mysql and ssl but
>> doesn't work.
>>
>> although the horde user in the database has "require ssl" the
>> connections are established without encryption (verified with wireshark)
>>
>> $conf['auth']['params']['username'] = 'horde';
>> $conf['auth']['params']['password'] = 'xxx';
>> $conf['auth']['params']['hostspec'] = 'xxx.example.com';
>> $conf['auth']['params']['port'] = 3306;
>> $conf['auth']['params']['protocol'] = 'tcp';
>> $conf['auth']['params']['database'] = 'xxx';
>> $conf['auth']['params']['charset'] = 'utf-8';
>> $conf['auth']['params']['ssl'] = true;
>> $conf['auth']['params']['ca'] = '/var/www/horde/config/ca-cert.pem';
>> $conf['auth']['params']['phptype'] = 'mysqli';
>> $conf['auth']['params']['driverconfig'] = 'custom';
>> $conf['auth']['params']['table'] = 'users';
>> $conf['auth']['params']['username_field'] = 'email';
>> $conf['auth']['params']['password_field'] = 'password';
>> $conf['auth']['params']['encryption'] = 'crypt-md5';
>> $conf['auth']['params']['show_encryption'] = false;
>> $conf['auth']['driver'] = 'sql';
>
> $conf['sql']['ssl'] and $conf['sql']['ca']
>
>

Mike, thanks for the quick answer but still doesn't work :(

$conf['sql']['ssl'] = true;
$conf['sql']['ca'] = '/var/www/horde/config/ca-cert.pem';