You have a typo in your SQL statement it should be ,sha not .sha
On 5/3/2016 1:07 PM, Carl Jeptha wrote:
Just tried to run it on the "Live" database, the simulation found all
the rows, but when I ran the query I got this error (still trying to see
what mus be changed):
|#1064 - You have an error
Just make sure it says:
WHERE password IS NULL OR password='';
With no space between the quote marks, this way it matches an empty string
On 05/03/2016 12:29 PM, Carl Jeptha wrote:
> Thank you,
> Due to changes I had to make to let password_query work, I think your "quick"
> version should be
The script I sent you should do the job of populating your cryptpwd column with
a SHA512-CRYPT version of the clearpwd column.
The only reason why you would bother with a perl script is to get a better
quality salt from /dev/urandom
If you don't care so much about the quality of the salt, you can
Oh, you uppercased PASSWORD again.
Change:
IF(cryptpwd IS NULL OR cryptpwd=' ', CONCAT('{PLAIN}',clearpwd), cryptpwd) AS
PASSWORD
To:
IF(cryptpwd IS NULL OR cryptpwd=' ', CONCAT('{PLAIN}',clearpwd), cryptpwd) AS
password
and again, try to understand what's going on here.
On 05/03/2016 08:0
Drop this from the end of your query:
AND cryptpwd = password ('%w')
and Steffen is right, it wouldn't hurt you to get a better understanding of the
principles at work here.
Nothing in this thread has had anything to do with dovecot so far.
On 05/03/2016 08:08 AM, Carl Jeptha wrote:
> 1. Auth
I want my director to do all authentication, but it ignores the nologin
and reason etc. fields returned by my director password_query
I have my director password_query returning proxy=y, password=X,
master=, pass=
It works fine, but even if nologin is Y and 'reason' is set, the user
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 3 May 2016, Carl Jeptha wrote:
OK QUERY is WORKING ("password_query" relies on having a field/column
"password', hence the addition under WHERE):
password_query = \
SELECT username AS USER, \
IF(cryptpwd IS NULL OR cryptpwd=' ', CONC
