Re: dovecot sha512-crypt database storage

[LuKreme]

On Mar 11, 2018, at 10:19, David Mehler  wrote:
> Other suggestions welcome.

Does the account you are using have access to write the new passwords?> Doe s 
the command work from the command line or phpmyadmin?

-- 
My main job is trying to come up with new and innovative and effective ways to 
reject even more mail. I'm up to about 97% now.

Re: dovecot sha512-crypt database storage

[David Mehler]

Hello,

Yes I am referencing my virtual users table.

Other suggestions welcome.

Thanks.
Dave.


On 3/11/18, @lbutlr  wrote:
> On 2018-03-10 (16:48 MST), David Mehler  wrote:
>>
>> Thanks. That query doesn't return any parse errors but it does say
>> that it can't save the password.
>
> Are you referencing the right table in your database?
>
> --
> It is the business of the future to be dangerous.
>
>

Re: dovecot sha512-crypt database storage

[@lbutlr]

On 2018-03-10 (16:48 MST), David Mehler  wrote:
> 
> Thanks. That query doesn't return any parse errors but it does say
> that it can't save the password.

Are you referencing the right table in your database?

-- 
It is the business of the future to be dangerous.

Re: dovecot sha512-crypt database storage

[David Mehler]

Hi,

Thanks. That query doesn't return any parse errors but it does say
that it can't save the password.

Any ideas?

Thanks.
Dave.


On 3/10/18, David Mehler  wrote:
> Hello,
>
> Thanks. Trying that query adapted to my database table and getting an
> error can not save password, any ideas?
>
> When you made your initial database tables how did you set up the
> password field and in MySQL how did you make it?
>
> I'm trying to figure out what is different about your setup than mine.
>
> Thanks.
> Dave.
>
>
> On 3/10/18, Thore Bödecker  wrote:
>> Hey,
>>
>> using the roundcube password plugin allows you to specify arbitrary
>> statements for password_query.
>>
>> I'm using SHA512-CRYPT too and this is my $config['password_query']:
>>
>> "UPDATE vhostapi_prod.mail_accounts SET
>> password=CONCAT(_utf8'{SHA512-CRYPT}',ENCRYPT(_utf8%p,CONCAT(_utf8'$6$',
>> SUBSTRING(SHA(RAND()), -16 WHERE email=%u LIMIT 1"
>>
>>
>> Cheers,
>> Thore
>>
>> On 10.03.18 - 16:00, David Mehler wrote:
>>> Hello,
>>>
>>> I've got dovecot authenticating to a MySQL database. I've got a field
>>> varchar(128) called password. Whenever I create a password I use
>>> doveadm pw as in:
>>>
>>> doveadm pw -s sha512-crypt
>>>
>>> now i'd like to get MySQL to make a dovecot-specific password. My goal
>>> is to eventually have roundcube's password plugin working with this
>>> MySQL database to change the password.
>>>
>>> Thanks.
>>> Dave.
>>
>> --
>>
>>
>

Re: dovecot sha512-crypt database storage

[Thore Bödecker]

Hey,

using the roundcube password plugin allows you to specify arbitrary
statements for password_query.

I'm using SHA512-CRYPT too and this is my $config['password_query']:

"UPDATE vhostapi_prod.mail_accounts SET 
password=CONCAT(_utf8'{SHA512-CRYPT}',ENCRYPT(_utf8%p,CONCAT(_utf8'$6$', 
SUBSTRING(SHA(RAND()), -16 WHERE email=%u LIMIT 1"


Cheers,
Thore

On 10.03.18 - 16:00, David Mehler wrote:
> Hello,
> 
> I've got dovecot authenticating to a MySQL database. I've got a field
> varchar(128) called password. Whenever I create a password I use
> doveadm pw as in:
> 
> doveadm pw -s sha512-crypt
> 
> now i'd like to get MySQL to make a dovecot-specific password. My goal
> is to eventually have roundcube's password plugin working with this
> MySQL database to change the password.
> 
> Thanks.
> Dave.

-- 



signature.asc
Description: PGP signature

dovecot sha512-crypt database storage

[David Mehler]

Hello,

I've got dovecot authenticating to a MySQL database. I've got a field
varchar(128) called password. Whenever I create a password I use
doveadm pw as in:

doveadm pw -s sha512-crypt

now i'd like to get MySQL to make a dovecot-specific password. My goal
is to eventually have roundcube's password plugin working with this
MySQL database to change the password.

Thanks.
Dave.