Re: Migration from unix accounts to mysql db.

From: Andreas Winkelmann (no email)
Date: Sun Apr 08 2007 - 18:09:15 EDT

  • Next message: Daniel L. Miller: "Bypass spam check for qualified senders"

    On Sunday 08 April 2007 23:28, Sebastian Sala wrote:

    > I want to migrate from unix user accounts to mysql but i have a little
    > problem and i do not know how to solve it.
    > The problem is in password migration. I don't have any idea how to
    > collect them in plain text so i can place them in mysql db.
    > I think i should sniff the network traffic for couple of days and catch
    > passwords for pop3 logins. Maybe there are some tools which can do that.
    > Or maybe there is another way.

    Cyrus-SASL can do that.

    pwcheck_method: auxprop saslauthd
    mech_list: plain login
    auxprop_plugin: sql
    sql_engine: mysql
    sql_hostnames: ....
    sql_user: ...
    sql_passwd: ...
    sql_database: ...
    sql_select: SELECT pw FROM users WHERE....
    sql_insert: INSERT INTO users (user, realm, pw) VALUES ('%u', '%r', '%v')
    sql_update: UPDATE users SET ....
    auto_transition: yes

    This will create/update a SQL-Entry after each successfull Userlogon. After
    you have the Entries for all Users, remove auto_transition, saslauthd and
    add "digest-md5 cram-md5" to the mech_list Option.

    -- 
    	Andreas
    

  • Next message: Daniel L. Miller: "Bypass spam check for qualified senders"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD