search for: nullif

...tabase extra fields currently aren't much use inside SQL queries? All boolean fields like nologin/nodelay/nopassword are set if the column is present in the returned query, regardless of value (including NULL) For example, say you have a query like: password_query = SELECT hash AS password, NULLIF(active = 1, 'y') AS nologin FROM users WHERE name = '%u' Then nologin will always be set for this account, there's no realistic way to toggle the flag. Has anyone come across any workarounds for this problem that don't sacrifice efficiency by performing multiple lookups...

Hi, I have a current auth database using mysql with a "password" column in plain text. The config has "default_pass_scheme = PLAIN" specified In preparation for a more adaptable system I changed a password entry from "asdf" to "{PLAIN}asdf", but now auth fails. Works fine if I change it back to just "asdf". (I don't believe it's a

.... What am I doing wrong if the keys are the same and explicite string works while variable doesn''t? Can you explain me that and write how to solve that problem? Thanks in advance, greetz -- K.O.N.L.I.N. konlin@post.pl Kinetic Organism Normally for Logical Infiltration and Nullification, "Day after day, love turns grey Like the skin of a dying man"

...uot; in a similar way, except that instead of not returning a row when "access" is zero, I return the "nologin" extra field (along with a "reason" field). The MySQL query for this is slightly tricky, but it works: password_query = SELECT username AS user, password, NULLIF(access != 0, 1) AS nologin, 'Access not allowed for this account' AS reason FROM mailbox WHERE username = '%u' While this second query works correctly with IMAP and POP authentication, it does not work with Postfix SMTP AUTH. Assuming the password is correct, the user is authent...

...he can keep listening but is not allowed to talk. Now, while the user is muted, I can not read any DTMF tones in the AGI background script. "Okay," you might say, "the user is muted. It makes sense that his DTMF tones do not come through." But I say, "the muting, i.e. the nullification of any incoming audio is done somewhere within Asterisk, why is the DTMF tone detection not done _before_ the incoming audio is thrown away?" So, basically, my question is, how can I have a muted participant in a meetme conference that can still control his listening experience via DTM...

...hich returns a plain >> password.? Actually since it's DB driven I have already returned all the >> information needed to auth the user on the proxying machine >> >> The password query is the same on both sides and it looks like: >> >> password_query = SELECT NULLIF(mail_host, '%l') as proxy, >> NULLIF(mail_host, '%l') as host, \ >>? ? ???email as user, password, \ > Add: ..., password, password as pass, .. > > Aha - this is the master login stuff.? That does kind of make sense.? Quite subtle mind Thanks for replying Ed...

...hich returns a plain >> password.? Actually since it's DB driven I have already returned all the >> information needed to auth the user on the proxying machine >> >> The password query is the same on both sides and it looks like: >> >> password_query = SELECT NULLIF(mail_host, '%l') as proxy, >> NULLIF(mail_host, '%l') as host, \ >>? ? ???email as user, password, \ > Add: ..., password, password as pass, .. > > Aha - this is the master login stuff.? That does kind of make sense.? Quite subtle mind Thanks for replying Ed...