Dovecot last_login plugin and Mysql

[David Mehler]

Hi,

Thanks for the pointing out of the oops! I missed that. Don't worry
that has been changed.

Any suggestions on my issue?

Thanks.
Dave.


On 4/28/17, David Mehler <dave.mehler at gmail.com> wrote:
> Hi,
>
> OOPS! I missed that one and it was big.
>
> Changing now.
>
> Thanks.
> Dave.
>
>
> On 4/28/17, Noel Butler <noel.butler at ausics.net> wrote:
>> ummmmmm
>>
>> It's usually a good idea to redact user and passwords for databases,
>> even if only local socket ;)
>>
>> I suggest you change it ASAP.
>>
>> On 29/04/2017 10:53, David Mehler wrote:
>>
>>> Hello,
>>>
>>> Here is the requested file:
>>>
>>> driver = mysql
>>> connect = host=/tmp/mysql.sock dbname=mail user=mail_admin
>>> password=MainBoard55
>>>
>>> # Last Login
>>> map {
>>> pattern = shared/last-login/$user
>>> table = virtual_users
>>> username_field = user
>>> value_field = lastlogin
>>> fields {
>>> user = $user
>>> }
>>> }
>>>
>>> Thanks.
>>> Dave.
>>>
>>> On 4/28/17, Aki Tuomi <aki.tuomi at dovecot.fi> wrote:
>>> On April 29, 2017 at 12:29 AM David Mehler <dave.mehler at gmail.com>
>>> wrote:
>>>
>>> Hello,
>>>
>>> Trying to implement lastlogin via mysql. I'm getting an unknown column
>>> username which I don't get. Here's the log:
>>>
>>> Apr 28 17:18:15 ohio dovecot: imap-login: Login:
>>> user=<user at example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1,
>>> mpid=16257, secured, session=<KxiSnEBOwUx/AAAB>
>>>
>>> Apr 28 17:18:15 ohio dovecot: dict(17099): Error: sql dict: commit
>>> failed: Unknown column 'username' in 'field list'
>>>
>>> Apr 28 17:18:15 ohio dovecot: imap(user at example.com): Error:
>>> dict-client: server returned failure: 1493414295 (reply took 0.026
>>> secs)
>>>
>>> Apr 28 17:18:15 ohio dovecot: imap(user at example.com): Error:
>>> last_login_dict: Failed to write value for user user at example.com
>>>
>>> You can configure all this in dovecot-dict-sql.conf, which you have not
>>> provided. The actual column names are defined there.
>>>
>>> Aki
>>
>> --
>> Kind Regards,
>>
>> Noel Butler
>>
>>  		This Email, including any attachments, may contain legally privileged
>> information, therefore remains confidential and subject to copyright
>> protected under international law. You may not disseminate, discuss, or
>> reveal, any part, to anyone, without the authors express written
>> authority to do so. If you are not the intended recipient, please notify
>> the sender then delete all copies of this message including attachments,
>> immediately. Confidentiality, copyright, and legal privilege are not
>> waived or lost by reason of the mistaken delivery of this message. Only
>> PDF [1] and ODF [2] documents accepted, please do not send proprietary
>> formatted documents
>>
>>
>>
>> Links:
>> ------
>> [1] http://www.adobe.com/
>> [2] http://en.wikipedia.org/wiki/OpenDocument
>