Loading ...
Sorry, an error occurred while loading the content.

About SMTP Auth with Mysql

Expand Messages
  • Vahriç Muhtaryan
    Hello, I have multiple database which have username and pass informations I would like to use postfix as a centeral smtp auth server for all but something I
    Message 1 of 14 , Nov 20, 2009
    • 0 Attachment

      Hello,

       

      I have multiple database which have username and pass informations

      I would like to use postfix as a centeral smtp auth server for all but something I can not do it

       

      log_level: 7

      pwcheck_method: auxprop

      auxprop_plugin: sql

      mech_list: plain login

      sql_engine: mysql

      sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)

      sql_user: postfix

      sql_passwd: your-password

      sql_database: postfix

      sql_select: select clear from postfix_smtp where email='%u@%r'

       

       

      if I write down only sql_hostnames:212.58.4.184 or sql_hostnames:212.58.4.247 its working, but when I try to use sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306) its not working

       

      From cyrus , I check that its okay and before I tested and it was working but right now no !

      http://asyd.net/docs/cyrus-options.html

      sql_hostnamesSQL plugin Comma separated list of SQL servers (in host[:port] format). none (engine dependent)

       

      any experiance about related issue ?

       

      Regards

      Vahric

    • Jerry
      On Fri, 20 Nov 2009 15:55:20 +0200 ... Maybe you should lose the opening/closing parentheses. -- Jerry postfix.user@yahoo.com TO REPORT A PROBLEM see
      Message 2 of 14 , Nov 20, 2009
      • 0 Attachment
        On Fri, 20 Nov 2009 15:55:20 +0200
        Vahriç Muhtaryan <vahric@...> replied:

        >Hello,
        >
        >
        >
        >I have multiple database which have username and pass informations
        >
        >I would like to use postfix as a centeral smtp auth server for all but
        >something I can not do it
        >
        >
        >
        >log_level: 7
        >
        >pwcheck_method: auxprop
        >
        >auxprop_plugin: sql
        >
        >mech_list: plain login
        >
        >sql_engine: mysql
        >
        >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
        >
        >sql_user: postfix
        >
        >sql_passwd: your-password
        >
        >sql_database: postfix
        >
        >sql_select: select clear from postfix_smtp where email='%u@%r'
        >
        >
        >
        >
        >
        >if I write down only sql_hostnames:212.58.4.184 or
        >sql_hostnames:212.58.4.247 its working, but when I try to use
        >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306) its not working
        >
        >
        >
        >From cyrus , I check that its okay and before I tested and it was
        >working but right now no !
        >
        >http://asyd.net/docs/cyrus-options.html
        >
        >sql_hostnamesSQL plugin Comma separated list of SQL servers (in
        >host[:port] format). none (engine dependent)
        >
        >
        >
        >any experiance about related issue ?


        Maybe you should lose the opening/closing parentheses.

        --
        Jerry
        postfix.user@...

        TO REPORT A PROBLEM see http://www.postfix.org/DEBUG_README.html#mail
        TO (UN)SUBSCRIBE see http://www.postfix.org/lists.html

        Ya know, Quaker Oats make you feel good twice!
      • Vahriç Muhtaryan
        I tried without parentheses like 212.58.4.184:3306,212.58.4.247:3306 Also tried like this 212.58.4.184:3306 212.58.4.247:3306 ... From:
        Message 3 of 14 , Nov 20, 2009
        • 0 Attachment
          I tried without parentheses like 212.58.4.184:3306,212.58.4.247:3306
          Also tried like this 212.58.4.184:3306 212.58.4.247:3306

          -----Original Message-----
          From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Jerry
          Sent: Friday, November 20, 2009 6:05 PM
          To: postfix-users@...
          Subject: Re: About SMTP Auth with Mysql

          On Fri, 20 Nov 2009 15:55:20 +0200
          Vahriç Muhtaryan <vahric@...> replied:

          >Hello,
          >
          >
          >
          >I have multiple database which have username and pass informations
          >
          >I would like to use postfix as a centeral smtp auth server for all but
          >something I can not do it
          >
          >
          >
          >log_level: 7
          >
          >pwcheck_method: auxprop
          >
          >auxprop_plugin: sql
          >
          >mech_list: plain login
          >
          >sql_engine: mysql
          >
          >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
          >
          >sql_user: postfix
          >
          >sql_passwd: your-password
          >
          >sql_database: postfix
          >
          >sql_select: select clear from postfix_smtp where email='%u@%r'
          >
          >
          >
          >
          >
          >if I write down only sql_hostnames:212.58.4.184 or
          >sql_hostnames:212.58.4.247 its working, but when I try to use
          >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306) its not working
          >
          >
          >
          >From cyrus , I check that its okay and before I tested and it was
          >working but right now no !
          >
          >http://asyd.net/docs/cyrus-options.html
          >
          >sql_hostnamesSQL plugin Comma separated list of SQL servers (in
          >host[:port] format). none (engine dependent)
          >
          >
          >
          >any experiance about related issue ?


          Maybe you should lose the opening/closing parentheses.

          --
          Jerry
          postfix.user@...

          TO REPORT A PROBLEM see http://www.postfix.org/DEBUG_README.html#mail
          TO (UN)SUBSCRIBE see http://www.postfix.org/lists.html

          Ya know, Quaker Oats make you feel good twice!
        • Patrick Ben Koetter
          ... 3306 is default for mysql. Try without. p@rick ... -- All technical questions asked privately will be automatically answered on the list and archived for
          Message 4 of 14 , Nov 20, 2009
          • 0 Attachment
            * Vahriç Muhtaryan <vahric@...>:
            > I tried without parentheses like 212.58.4.184:3306,212.58.4.247:3306
            > Also tried like this 212.58.4.184:3306 212.58.4.247:3306

            3306 is default for mysql. Try without.

            p@rick




            >
            > -----Original Message-----
            > From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Jerry
            > Sent: Friday, November 20, 2009 6:05 PM
            > To: postfix-users@...
            > Subject: Re: About SMTP Auth with Mysql
            >
            > On Fri, 20 Nov 2009 15:55:20 +0200
            > Vahriç Muhtaryan <vahric@...> replied:
            >
            > >Hello,
            > >
            > >
            > >
            > >I have multiple database which have username and pass informations
            > >
            > >I would like to use postfix as a centeral smtp auth server for all but
            > >something I can not do it
            > >
            > >
            > >
            > >log_level: 7
            > >
            > >pwcheck_method: auxprop
            > >
            > >auxprop_plugin: sql
            > >
            > >mech_list: plain login
            > >
            > >sql_engine: mysql
            > >
            > >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
            > >
            > >sql_user: postfix
            > >
            > >sql_passwd: your-password
            > >
            > >sql_database: postfix
            > >
            > >sql_select: select clear from postfix_smtp where email='%u@%r'
            > >
            > >
            > >
            > >
            > >
            > >if I write down only sql_hostnames:212.58.4.184 or
            > >sql_hostnames:212.58.4.247 its working, but when I try to use
            > >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306) its not working
            > >
            > >
            > >
            > >From cyrus , I check that its okay and before I tested and it was
            > >working but right now no !
            > >
            > >http://asyd.net/docs/cyrus-options.html
            > >
            > >sql_hostnamesSQL plugin Comma separated list of SQL servers (in
            > >host[:port] format). none (engine dependent)
            > >
            > >
            > >
            > >any experiance about related issue ?
            >
            >
            > Maybe you should lose the opening/closing parentheses.
            >
            > --
            > Jerry
            > postfix.user@...
            >
            > TO REPORT A PROBLEM see http://www.postfix.org/DEBUG_README.html#mail
            > TO (UN)SUBSCRIBE see http://www.postfix.org/lists.html
            >
            > Ya know, Quaker Oats make you feel good twice!
            >

            --
            All technical questions asked privately will be automatically answered on the
            list and archived for public access unless privacy is explicitely required and
            justified.

            saslfinger (debugging SMTP AUTH):
            <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
          • Vahriç Muhtaryan
            Hi, (212.58.4.184,212.58.4.247) not worked (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184 212.58.4.184:3306,212.58.4.247:3306 query
            Message 5 of 14 , Nov 21, 2009
            • 0 Attachment
              Hi,

              (212.58.4.184,212.58.4.247) not worked
              (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
              212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
              212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
              sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
              247

              Regards
              Vahric

              -----Original Message-----
              From: owner-postfix-users@...
              [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
              Sent: Friday, November 20, 2009 11:41 PM
              To: postfix-users@...
              Subject: Re: About SMTP Auth with Mysql

              * Vahriç Muhtaryan <vahric@...>:
              > I tried without parentheses like 212.58.4.184:3306,212.58.4.247:3306
              > Also tried like this 212.58.4.184:3306 212.58.4.247:3306

              3306 is default for mysql. Try without.

              p@rick




              >
              > -----Original Message-----
              > From: owner-postfix-users@...
              [mailto:owner-postfix-users@...] On Behalf Of Jerry
              > Sent: Friday, November 20, 2009 6:05 PM
              > To: postfix-users@...
              > Subject: Re: About SMTP Auth with Mysql
              >
              > On Fri, 20 Nov 2009 15:55:20 +0200
              > Vahriç Muhtaryan <vahric@...> replied:
              >
              > >Hello,
              > >
              > >
              > >
              > >I have multiple database which have username and pass informations
              > >
              > >I would like to use postfix as a centeral smtp auth server for all but
              > >something I can not do it
              > >
              > >
              > >
              > >log_level: 7
              > >
              > >pwcheck_method: auxprop
              > >
              > >auxprop_plugin: sql
              > >
              > >mech_list: plain login
              > >
              > >sql_engine: mysql
              > >
              > >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
              > >
              > >sql_user: postfix
              > >
              > >sql_passwd: your-password
              > >
              > >sql_database: postfix
              > >
              > >sql_select: select clear from postfix_smtp where email='%u@%r'
              > >
              > >
              > >
              > >
              > >
              > >if I write down only sql_hostnames:212.58.4.184 or
              > >sql_hostnames:212.58.4.247 its working, but when I try to use
              > >sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306) its not working
              > >
              > >
              > >
              > >From cyrus , I check that its okay and before I tested and it was
              > >working but right now no !
              > >
              > >http://asyd.net/docs/cyrus-options.html
              > >
              > >sql_hostnamesSQL plugin Comma separated list of SQL servers (in
              > >host[:port] format). none (engine dependent)
              > >
              > >
              > >
              > >any experiance about related issue ?
              >
              >
              > Maybe you should lose the opening/closing parentheses.
              >
              > --
              > Jerry
              > postfix.user@...
              >
              > TO REPORT A PROBLEM see http://www.postfix.org/DEBUG_README.html#mail
              > TO (UN)SUBSCRIBE see http://www.postfix.org/lists.html
              >
              > Ya know, Quaker Oats make you feel good twice!
              >

              --
              All technical questions asked privately will be automatically answered on
              the
              list and archived for public access unless privacy is explicitely required
              and
              justified.

              saslfinger (debugging SMTP AUTH):
              <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
            • Patrick Ben Koetter
              ... How did you test? Just in case you think it should query both servers at the same time: No, it s not supposed to do that. If the 1st server in the list is
              Message 6 of 14 , Nov 22, 2009
              • 0 Attachment
                * Vahriç Muhtaryan <vahric@...>:
                > Hi,
                >
                > (212.58.4.184,212.58.4.247) not worked
                > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                > 247

                How did you test?

                Just in case you think it should query both servers at the same time: No, it's
                not supposed to do that.

                If the 1st server in the list is inaccessible, it should try the second.

                Have you tested that?

                p@rick

                --
                All technical questions asked privately will be automatically answered on the
                list and archived for public access unless privacy is explicitely required and
                justified.

                saslfinger (debugging SMTP AUTH):
                <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
              • Vahriç Muhtaryan
                I hope that until find the right mailbox and pass it should query each setted mysql server but not ! For to be sure I m sending different mailbox name and
                Message 7 of 14 , Nov 22, 2009
                • 0 Attachment
                  I hope that until find the right mailbox and pass it should query each
                  setted mysql server but not !
                  For to be sure I'm sending different mailbox name and password and wait
                  postfix make query step by step but not.
                  I told you before with different syntax postfix do differnt actions
                  I don't know this is really postfix problem our cyrus problem but I couldn'T
                  find any solution
                  When you check cyrus docs my sytax is ok but its not working
                  İts drive me crazy

                  Regards
                  Vahric

                  -----Original Message-----
                  From: owner-postfix-users@...
                  [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                  Sent: Sunday, November 22, 2009 4:44 PM
                  To: postfix-users@...
                  Subject: Re: About SMTP Auth with Mysql

                  * Vahriç Muhtaryan <vahric@...>:
                  > Hi,
                  >
                  > (212.58.4.184,212.58.4.247) not worked
                  > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                  > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                  > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                  > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                  > 247

                  How did you test?

                  Just in case you think it should query both servers at the same time: No,
                  it's
                  not supposed to do that.

                  If the 1st server in the list is inaccessible, it should try the second.

                  Have you tested that?

                  p@rick

                  --
                  All technical questions asked privately will be automatically answered on
                  the
                  list and archived for public access unless privacy is explicitely required
                  and
                  justified.

                  saslfinger (debugging SMTP AUTH):
                  <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                • Vahriç Muhtaryan
                  Any postfix guy have a knowledge about this issue Really I would like to solve this and debug Actually smtp -v do not show the problem also verbose mode to for
                  Message 8 of 14 , Nov 24, 2009
                  • 0 Attachment
                    Any postfix guy have a knowledge about this issue
                    Really I would like to solve this and debug
                    Actually smtp -v do not show the problem also verbose mode to for sasl
                    Any idea ?

                    -----Original Message-----
                    From: owner-postfix-users@...
                    [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                    Sent: Sunday, November 22, 2009 11:21 PM
                    To: 'Patrick Ben Koetter'; postfix-users@...
                    Subject: RE: About SMTP Auth with Mysql

                    I hope that until find the right mailbox and pass it should query each
                    setted mysql server but not !
                    For to be sure I'm sending different mailbox name and password and wait
                    postfix make query step by step but not.
                    I told you before with different syntax postfix do differnt actions
                    I don't know this is really postfix problem our cyrus problem but I couldn'T
                    find any solution
                    When you check cyrus docs my sytax is ok but its not working
                    İts drive me crazy

                    Regards
                    Vahric

                    -----Original Message-----
                    From: owner-postfix-users@...
                    [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                    Sent: Sunday, November 22, 2009 4:44 PM
                    To: postfix-users@...
                    Subject: Re: About SMTP Auth with Mysql

                    * Vahriç Muhtaryan <vahric@...>:
                    > Hi,
                    >
                    > (212.58.4.184,212.58.4.247) not worked
                    > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                    > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                    > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                    > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                    > 247

                    How did you test?

                    Just in case you think it should query both servers at the same time: No,
                    it's
                    not supposed to do that.

                    If the 1st server in the list is inaccessible, it should try the second.

                    Have you tested that?

                    p@rick

                    --
                    All technical questions asked privately will be automatically answered on
                    the
                    list and archived for public access unless privacy is explicitely required
                    and
                    justified.

                    saslfinger (debugging SMTP AUTH):
                    <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                  • Patrick Ben Koetter
                    ... It is the Postfix smtpd-daemon and not the smtp-client. If you debug add -v to smtpd, not smtp. Download saslfinger and run it: saslfinger (debugging
                    Message 9 of 14 , Nov 24, 2009
                    • 0 Attachment
                      * Vahriç Muhtaryan <vahric@...>:
                      > Any postfix guy have a knowledge about this issue
                      > Really I would like to solve this and debug
                      > Actually smtp -v do not show the problem also verbose mode to for sasl
                      > Any idea ?

                      It is the Postfix smtpd-daemon and not the smtp-client. If you debug add "-v"
                      to smtpd, not smtp.

                      Download saslfinger and run it:

                      saslfinger (debugging SMTP AUTH):
                      <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>

                      Send debug output to the list.

                      > -----Original Message-----
                      > From: owner-postfix-users@...
                      > [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                      > Sent: Sunday, November 22, 2009 11:21 PM
                      > To: 'Patrick Ben Koetter'; postfix-users@...
                      > Subject: RE: About SMTP Auth with Mysql
                      >
                      > I hope that until find the right mailbox and pass it should query each
                      > setted mysql server but not !
                      > For to be sure I'm sending different mailbox name and password and wait
                      > postfix make query step by step but not.
                      > I told you before with different syntax postfix do differnt actions
                      > I don't know this is really postfix problem our cyrus problem but I couldn'T
                      > find any solution
                      > When you check cyrus docs my sytax is ok but its not working
                      > İts drive me crazy

                      Sorry, but I don't understand what you write.

                      p@rick





                      >
                      > Regards
                      > Vahric
                      >
                      > -----Original Message-----
                      > From: owner-postfix-users@...
                      > [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                      > Sent: Sunday, November 22, 2009 4:44 PM
                      > To: postfix-users@...
                      > Subject: Re: About SMTP Auth with Mysql
                      >
                      > * Vahriç Muhtaryan <vahric@...>:
                      > > Hi,
                      > >
                      > > (212.58.4.184,212.58.4.247) not worked
                      > > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                      > > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                      > > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                      > > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                      > > 247
                      >
                      > How did you test?
                      >
                      > Just in case you think it should query both servers at the same time: No,
                      > it's
                      > not supposed to do that.
                      >
                      > If the 1st server in the list is inaccessible, it should try the second.
                      >
                      > Have you tested that?
                      >
                      > p@rick
                      >
                      > --
                      > All technical questions asked privately will be automatically answered on
                      > the
                      > list and archived for public access unless privacy is explicitely required
                      > and
                      > justified.
                      >
                      > saslfinger (debugging SMTP AUTH):
                      > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                      >

                      --
                      All technical questions asked privately will be automatically answered on the
                      list and archived for public access unless privacy is explicitely required and
                      justified.

                      saslfinger (debugging SMTP AUTH):
                      <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                    • Vahriç Muhtaryan
                      Hello, You can find out related out below. Regards Vahric [root@postfix-auth1 ~]# ./saslfinger-1.0.3/saslfinger -s saslfinger - postfix Cyrus sasl
                      Message 10 of 14 , Nov 25, 2009
                      • 0 Attachment
                        Hello,

                        You can find out related out below.

                        Regards
                        Vahric

                        [root@postfix-auth1 ~]# ./saslfinger-1.0.3/saslfinger -s
                        saslfinger - postfix Cyrus sasl configuration Wed Nov 25 18:47:20 EET 2009
                        version: 1.0.2
                        mode: server-side SMTP AUTH

                        -- basics --
                        Postfix: 2.5.9
                        System: CentOS release 5.4 (Final)

                        -- smtpd is linked to --
                        libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003dfba00000)

                        -- active SMTP AUTH and TLS parameters for smtpd --
                        broken_sasl_auth_clients = yes
                        smtpd_sasl_auth_enable = yes


                        -- listing of /usr/lib64/sasl2 --
                        total 3500
                        drwxr-xr-x 2 root root 4096 Nov 22 23:17 .
                        drwxr-xr-x 55 root root 36864 Nov 21 04:03 ..
                        -rwxr-xr-x 1 root root 890 Sep 4 03:04 libanonymous.la
                        -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so
                        -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2
                        -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2.0.22
                        -rwxr-xr-x 1 root root 876 Sep 4 03:04 libcrammd5.la
                        -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so
                        -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2
                        -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2.0.22
                        -rwxr-xr-x 1 root root 899 Sep 4 03:04 libdigestmd5.la
                        -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so
                        -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2
                        -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2.0.22
                        -rwxr-xr-x 1 root root 939 Sep 4 03:04 libgssapiv2.la
                        -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so
                        -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2
                        -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2.0.22
                        -rwxr-xr-x 1 root root 883 Sep 4 03:04 libldapdb.la
                        -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so
                        -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2
                        -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2.0.22
                        -rwxr-xr-x 1 root root 862 Sep 4 03:04 liblogin.la
                        -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so
                        -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2
                        -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2.0.22
                        -rwxr-xr-x 1 root root 864 Sep 4 03:04 libntlm.la
                        -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so
                        -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2
                        -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2.0.22
                        -rwxr-xr-x 1 root root 862 Sep 4 03:04 libplain.la
                        -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so
                        -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2
                        -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2.0.22
                        -rwxr-xr-x 1 root root 936 Sep 4 03:04 libsasldb.la
                        -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so
                        -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2
                        -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2.0.22
                        -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                        -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so
                        -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2
                        -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2.0.22
                        -rw-r--r-- 1 root root 25 Mar 15 2007 Sendmail.conf
                        -rw-r--r-- 1 root root 280 Nov 22 23:17 smtpd.conf

                        -- listing of /usr/lib/sasl2 --
                        total 3440
                        drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                        drwxr-xr-x 50 root root 28672 Nov 20 13:43 ..
                        -rwxr-xr-x 1 root root 884 Sep 4 03:04 libanonymous.la
                        -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so
                        -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2
                        -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2.0.22
                        -rwxr-xr-x 1 root root 870 Sep 4 03:04 libcrammd5.la
                        -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so
                        -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2
                        -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2.0.22
                        -rwxr-xr-x 1 root root 893 Sep 4 03:04 libdigestmd5.la
                        -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so
                        -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2
                        -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2.0.22
                        -rwxr-xr-x 1 root root 933 Sep 4 03:04 libgssapiv2.la
                        -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so
                        -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2
                        -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2.0.22
                        -rwxr-xr-x 1 root root 877 Sep 4 03:04 libldapdb.la
                        -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so
                        -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2
                        -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2.0.22
                        -rwxr-xr-x 1 root root 856 Sep 4 03:04 liblogin.la
                        -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so
                        -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2
                        -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2.0.22
                        -rwxr-xr-x 1 root root 858 Sep 4 03:04 libntlm.la
                        -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so
                        -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2
                        -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2.0.22
                        -rwxr-xr-x 1 root root 856 Sep 4 03:04 libplain.la
                        -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so
                        -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2
                        -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2.0.22
                        -rwxr-xr-x 1 root root 930 Sep 4 03:04 libsasldb.la
                        -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so
                        -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2
                        -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2.0.22
                        -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                        -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so
                        -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2
                        -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2.0.22

                        -- listing of /etc/sasl2 --
                        total 16
                        drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                        drwxr-xr-x 82 root root 4096 Nov 25 18:20 ..




                        -- content of /usr/lib64/sasl2/smtpd.conf --
                        log_level: 7
                        pwcheck_method: auxprop
                        auxprop_plugin: sql
                        mech_list: plain login
                        sql_engine: mysql
                        sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
                        sql_user: --- replaced ---
                        sql_passwd: --- replaced ---
                        sql_database: postfix
                        sql_select: select clear from postfix_smtp where email='%u@%r'


                        -- active services in /etc/postfix/master.cf --
                        # service type private unpriv chroot wakeup maxproc command + args
                        # (yes) (yes) (yes) (never) (100)
                        smtp inet n - n - - smtpd
                        pickup fifo n - n 60 1 pickup
                        cleanup unix n - n - 0 cleanup
                        qmgr fifo n - n 300 1 qmgr
                        tlsmgr unix - - n 1000? 1 tlsmgr
                        rewrite unix - - n - - trivial-rewrite
                        bounce unix - - n - 0 bounce
                        defer unix - - n - 0 bounce
                        trace unix - - n - 0 bounce
                        verify unix - - n - 1 verify
                        flush unix n - n 1000? 0 flush
                        proxymap unix - - n - - proxymap
                        proxywrite unix - - n - 1 proxymap
                        smtp unix - - n - - smtp
                        relay unix - - n - - smtp
                        -o smtp_fallback_relay=
                        showq unix n - n - - showq
                        error unix - - n - - error
                        retry unix - - n - - error
                        discard unix - - n - - discard
                        local unix - n n - - local
                        virtual unix - n n - - virtual
                        lmtp unix - - n - - lmtp
                        anvil unix - - n - 1 anvil
                        scache unix - - n - 1 scache

                        -- mechanisms on localhost --
                        250-AUTH LOGIN PLAIN
                        250-AUTH=LOGIN PLAIN


                        -- end of saslfinger output --

                        -----Original Message-----
                        From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                        Sent: Tuesday, November 24, 2009 11:08 PM
                        To: postfix-users@...
                        Subject: Re: About SMTP Auth with Mysql

                        * Vahriç Muhtaryan <vahric@...>:
                        > Any postfix guy have a knowledge about this issue
                        > Really I would like to solve this and debug
                        > Actually smtp -v do not show the problem also verbose mode to for sasl
                        > Any idea ?

                        It is the Postfix smtpd-daemon and not the smtp-client. If you debug add "-v"
                        to smtpd, not smtp.

                        Download saslfinger and run it:

                        saslfinger (debugging SMTP AUTH):
                        <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>

                        Send debug output to the list.

                        > -----Original Message-----
                        > From: owner-postfix-users@...
                        > [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                        > Sent: Sunday, November 22, 2009 11:21 PM
                        > To: 'Patrick Ben Koetter'; postfix-users@...
                        > Subject: RE: About SMTP Auth with Mysql
                        >
                        > I hope that until find the right mailbox and pass it should query each
                        > setted mysql server but not !
                        > For to be sure I'm sending different mailbox name and password and wait
                        > postfix make query step by step but not.
                        > I told you before with different syntax postfix do differnt actions
                        > I don't know this is really postfix problem our cyrus problem but I couldn'T
                        > find any solution
                        > When you check cyrus docs my sytax is ok but its not working
                        > İts drive me crazy

                        Sorry, but I don't understand what you write.

                        p@rick





                        >
                        > Regards
                        > Vahric
                        >
                        > -----Original Message-----
                        > From: owner-postfix-users@...
                        > [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                        > Sent: Sunday, November 22, 2009 4:44 PM
                        > To: postfix-users@...
                        > Subject: Re: About SMTP Auth with Mysql
                        >
                        > * Vahriç Muhtaryan <vahric@...>:
                        > > Hi,
                        > >
                        > > (212.58.4.184,212.58.4.247) not worked
                        > > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                        > > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                        > > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                        > > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                        > > 247
                        >
                        > How did you test?
                        >
                        > Just in case you think it should query both servers at the same time: No,
                        > it's
                        > not supposed to do that.
                        >
                        > If the 1st server in the list is inaccessible, it should try the second.
                        >
                        > Have you tested that?
                        >
                        > p@rick
                        >
                        > --
                        > All technical questions asked privately will be automatically answered on
                        > the
                        > list and archived for public access unless privacy is explicitely required
                        > and
                        > justified.
                        >
                        > saslfinger (debugging SMTP AUTH):
                        > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                        >

                        --
                        All technical questions asked privately will be automatically answered on the
                        list and archived for public access unless privacy is explicitely required and
                        justified.

                        saslfinger (debugging SMTP AUTH):
                        <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                      • Patrick Ben Koetter
                        Vahriç, ... thanks for the debug output. Your config looks okay. Your problem is - as I understand it - you want Cyrus SASL to do something it can t do: 1. If
                        Message 11 of 14 , Nov 25, 2009
                        • 0 Attachment
                          Vahriç,

                          * Vahriç Muhtaryan <vahric@...>:
                          > You can find out related out below.

                          thanks for the debug output. Your config looks okay. Your problem is - as I
                          understand it - you want Cyrus SASL to do something it can't do:

                          1. If you list more than one host with $sql_hostnames then those hosts will be
                          queried in order listed from left to right.
                          2. The first host in the list that answers will be used. Any other host will
                          not be queried.
                          3. It is not possible to query all hosts at the same time.

                          So, if you want to query several MySQL servers at the same time, it cannot be
                          done. All I can think of is moving your data to one SQL server instance.

                          OTOH maybe you can use mysql-proxy <http://forge.mysql.com/wiki/MySQL_Proxy>,
                          configure that to transform the query to query both servers and let SASL query
                          the mysql-proxy.

                          HTH,

                          p@rick




                          > Regards
                          > Vahric
                          >
                          > [root@postfix-auth1 ~]# ./saslfinger-1.0.3/saslfinger -s
                          > saslfinger - postfix Cyrus sasl configuration Wed Nov 25 18:47:20 EET 2009
                          > version: 1.0.2
                          > mode: server-side SMTP AUTH
                          >
                          > -- basics --
                          > Postfix: 2.5.9
                          > System: CentOS release 5.4 (Final)
                          >
                          > -- smtpd is linked to --
                          > libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003dfba00000)
                          >
                          > -- active SMTP AUTH and TLS parameters for smtpd --
                          > broken_sasl_auth_clients = yes
                          > smtpd_sasl_auth_enable = yes
                          >
                          >
                          > -- listing of /usr/lib64/sasl2 --
                          > total 3500
                          > drwxr-xr-x 2 root root 4096 Nov 22 23:17 .
                          > drwxr-xr-x 55 root root 36864 Nov 21 04:03 ..
                          > -rwxr-xr-x 1 root root 890 Sep 4 03:04 libanonymous.la
                          > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so
                          > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2
                          > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2.0.22
                          > -rwxr-xr-x 1 root root 876 Sep 4 03:04 libcrammd5.la
                          > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so
                          > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2
                          > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2.0.22
                          > -rwxr-xr-x 1 root root 899 Sep 4 03:04 libdigestmd5.la
                          > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so
                          > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2
                          > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2.0.22
                          > -rwxr-xr-x 1 root root 939 Sep 4 03:04 libgssapiv2.la
                          > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so
                          > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2
                          > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2.0.22
                          > -rwxr-xr-x 1 root root 883 Sep 4 03:04 libldapdb.la
                          > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so
                          > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2
                          > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2.0.22
                          > -rwxr-xr-x 1 root root 862 Sep 4 03:04 liblogin.la
                          > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so
                          > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2
                          > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2.0.22
                          > -rwxr-xr-x 1 root root 864 Sep 4 03:04 libntlm.la
                          > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so
                          > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2
                          > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2.0.22
                          > -rwxr-xr-x 1 root root 862 Sep 4 03:04 libplain.la
                          > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so
                          > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2
                          > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2.0.22
                          > -rwxr-xr-x 1 root root 936 Sep 4 03:04 libsasldb.la
                          > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so
                          > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2
                          > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2.0.22
                          > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                          > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so
                          > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2
                          > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2.0.22
                          > -rw-r--r-- 1 root root 25 Mar 15 2007 Sendmail.conf
                          > -rw-r--r-- 1 root root 280 Nov 22 23:17 smtpd.conf
                          >
                          > -- listing of /usr/lib/sasl2 --
                          > total 3440
                          > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                          > drwxr-xr-x 50 root root 28672 Nov 20 13:43 ..
                          > -rwxr-xr-x 1 root root 884 Sep 4 03:04 libanonymous.la
                          > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so
                          > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2
                          > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2.0.22
                          > -rwxr-xr-x 1 root root 870 Sep 4 03:04 libcrammd5.la
                          > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so
                          > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2
                          > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2.0.22
                          > -rwxr-xr-x 1 root root 893 Sep 4 03:04 libdigestmd5.la
                          > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so
                          > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2
                          > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2.0.22
                          > -rwxr-xr-x 1 root root 933 Sep 4 03:04 libgssapiv2.la
                          > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so
                          > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2
                          > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2.0.22
                          > -rwxr-xr-x 1 root root 877 Sep 4 03:04 libldapdb.la
                          > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so
                          > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2
                          > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2.0.22
                          > -rwxr-xr-x 1 root root 856 Sep 4 03:04 liblogin.la
                          > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so
                          > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2
                          > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2.0.22
                          > -rwxr-xr-x 1 root root 858 Sep 4 03:04 libntlm.la
                          > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so
                          > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2
                          > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2.0.22
                          > -rwxr-xr-x 1 root root 856 Sep 4 03:04 libplain.la
                          > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so
                          > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2
                          > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2.0.22
                          > -rwxr-xr-x 1 root root 930 Sep 4 03:04 libsasldb.la
                          > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so
                          > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2
                          > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2.0.22
                          > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                          > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so
                          > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2
                          > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2.0.22
                          >
                          > -- listing of /etc/sasl2 --
                          > total 16
                          > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                          > drwxr-xr-x 82 root root 4096 Nov 25 18:20 ..
                          >
                          >
                          >
                          >
                          > -- content of /usr/lib64/sasl2/smtpd.conf --
                          > log_level: 7
                          > pwcheck_method: auxprop
                          > auxprop_plugin: sql
                          > mech_list: plain login
                          > sql_engine: mysql
                          > sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
                          > sql_user: --- replaced ---
                          > sql_passwd: --- replaced ---
                          > sql_database: postfix
                          > sql_select: select clear from postfix_smtp where email='%u@%r'
                          >
                          >
                          > -- active services in /etc/postfix/master.cf --
                          > # service type private unpriv chroot wakeup maxproc command + args
                          > # (yes) (yes) (yes) (never) (100)
                          > smtp inet n - n - - smtpd
                          > pickup fifo n - n 60 1 pickup
                          > cleanup unix n - n - 0 cleanup
                          > qmgr fifo n - n 300 1 qmgr
                          > tlsmgr unix - - n 1000? 1 tlsmgr
                          > rewrite unix - - n - - trivial-rewrite
                          > bounce unix - - n - 0 bounce
                          > defer unix - - n - 0 bounce
                          > trace unix - - n - 0 bounce
                          > verify unix - - n - 1 verify
                          > flush unix n - n 1000? 0 flush
                          > proxymap unix - - n - - proxymap
                          > proxywrite unix - - n - 1 proxymap
                          > smtp unix - - n - - smtp
                          > relay unix - - n - - smtp
                          > -o smtp_fallback_relay=
                          > showq unix n - n - - showq
                          > error unix - - n - - error
                          > retry unix - - n - - error
                          > discard unix - - n - - discard
                          > local unix - n n - - local
                          > virtual unix - n n - - virtual
                          > lmtp unix - - n - - lmtp
                          > anvil unix - - n - 1 anvil
                          > scache unix - - n - 1 scache
                          >
                          > -- mechanisms on localhost --
                          > 250-AUTH LOGIN PLAIN
                          > 250-AUTH=LOGIN PLAIN
                          >
                          >
                          > -- end of saslfinger output --
                          >
                          > -----Original Message-----
                          > From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                          > Sent: Tuesday, November 24, 2009 11:08 PM
                          > To: postfix-users@...
                          > Subject: Re: About SMTP Auth with Mysql
                          >
                          > * Vahriç Muhtaryan <vahric@...>:
                          > > Any postfix guy have a knowledge about this issue
                          > > Really I would like to solve this and debug
                          > > Actually smtp -v do not show the problem also verbose mode to for sasl
                          > > Any idea ?
                          >
                          > It is the Postfix smtpd-daemon and not the smtp-client. If you debug add "-v"
                          > to smtpd, not smtp.
                          >
                          > Download saslfinger and run it:
                          >
                          > saslfinger (debugging SMTP AUTH):
                          > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                          >
                          > Send debug output to the list.
                          >
                          > > -----Original Message-----
                          > > From: owner-postfix-users@...
                          > > [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                          > > Sent: Sunday, November 22, 2009 11:21 PM
                          > > To: 'Patrick Ben Koetter'; postfix-users@...
                          > > Subject: RE: About SMTP Auth with Mysql
                          > >
                          > > I hope that until find the right mailbox and pass it should query each
                          > > setted mysql server but not !
                          > > For to be sure I'm sending different mailbox name and password and wait
                          > > postfix make query step by step but not.
                          > > I told you before with different syntax postfix do differnt actions
                          > > I don't know this is really postfix problem our cyrus problem but I couldn'T
                          > > find any solution
                          > > When you check cyrus docs my sytax is ok but its not working
                          > > İts drive me crazy
                          >
                          > Sorry, but I don't understand what you write.
                          >
                          > p@rick
                          >
                          >
                          >
                          >
                          >
                          > >
                          > > Regards
                          > > Vahric
                          > >
                          > > -----Original Message-----
                          > > From: owner-postfix-users@...
                          > > [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                          > > Sent: Sunday, November 22, 2009 4:44 PM
                          > > To: postfix-users@...
                          > > Subject: Re: About SMTP Auth with Mysql
                          > >
                          > > * Vahriç Muhtaryan <vahric@...>:
                          > > > Hi,
                          > > >
                          > > > (212.58.4.184,212.58.4.247) not worked
                          > > > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                          > > > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                          > > > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                          > > > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                          > > > 247
                          > >
                          > > How did you test?
                          > >
                          > > Just in case you think it should query both servers at the same time: No,
                          > > it's
                          > > not supposed to do that.
                          > >
                          > > If the 1st server in the list is inaccessible, it should try the second.
                          > >
                          > > Have you tested that?
                          > >
                          > > p@rick
                          > >
                          > > --
                          > > All technical questions asked privately will be automatically answered on
                          > > the
                          > > list and archived for public access unless privacy is explicitely required
                          > > and
                          > > justified.
                          > >
                          > > saslfinger (debugging SMTP AUTH):
                          > > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                          > >
                          >
                          > --
                          > All technical questions asked privately will be automatically answered on the
                          > list and archived for public access unless privacy is explicitely required and
                          > justified.
                          >
                          > saslfinger (debugging SMTP AUTH):
                          > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                          >

                          --
                          state of mind
                          Digitale Kommunikation

                          http://www.state-of-mind.de

                          Franziskanerstraße 15 Telefon +49 89 3090 4664
                          81669 München Telefax +49 89 3090 4666

                          Amtsgericht München Partnerschaftsregister PR 563
                        • Vahriç Muhtaryan
                          Thanks for answer I will check mysql proxy ... From: owner-postfix-users@postfix.org [mailto:owner-postfix-users@postfix.org] On Behalf Of Patrick Ben Koetter
                          Message 12 of 14 , Nov 25, 2009
                          • 0 Attachment
                            Thanks for answer I will check mysql proxy

                            -----Original Message-----
                            From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                            Sent: Wednesday, November 25, 2009 11:06 PM
                            To: postfix-users@...
                            Subject: Re: About SMTP Auth with Mysql

                            Vahriç,

                            * Vahriç Muhtaryan <vahric@...>:
                            > You can find out related out below.

                            thanks for the debug output. Your config looks okay. Your problem is - as I
                            understand it - you want Cyrus SASL to do something it can't do:

                            1. If you list more than one host with $sql_hostnames then those hosts will be
                            queried in order listed from left to right.
                            2. The first host in the list that answers will be used. Any other host will
                            not be queried.
                            3. It is not possible to query all hosts at the same time.

                            So, if you want to query several MySQL servers at the same time, it cannot be
                            done. All I can think of is moving your data to one SQL server instance.

                            OTOH maybe you can use mysql-proxy <http://forge.mysql.com/wiki/MySQL_Proxy>,
                            configure that to transform the query to query both servers and let SASL query
                            the mysql-proxy.

                            HTH,

                            p@rick




                            > Regards
                            > Vahric
                            >
                            > [root@postfix-auth1 ~]# ./saslfinger-1.0.3/saslfinger -s
                            > saslfinger - postfix Cyrus sasl configuration Wed Nov 25 18:47:20 EET 2009
                            > version: 1.0.2
                            > mode: server-side SMTP AUTH
                            >
                            > -- basics --
                            > Postfix: 2.5.9
                            > System: CentOS release 5.4 (Final)
                            >
                            > -- smtpd is linked to --
                            > libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003dfba00000)
                            >
                            > -- active SMTP AUTH and TLS parameters for smtpd --
                            > broken_sasl_auth_clients = yes
                            > smtpd_sasl_auth_enable = yes
                            >
                            >
                            > -- listing of /usr/lib64/sasl2 --
                            > total 3500
                            > drwxr-xr-x 2 root root 4096 Nov 22 23:17 .
                            > drwxr-xr-x 55 root root 36864 Nov 21 04:03 ..
                            > -rwxr-xr-x 1 root root 890 Sep 4 03:04 libanonymous.la
                            > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so
                            > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2
                            > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2.0.22
                            > -rwxr-xr-x 1 root root 876 Sep 4 03:04 libcrammd5.la
                            > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so
                            > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2
                            > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2.0.22
                            > -rwxr-xr-x 1 root root 899 Sep 4 03:04 libdigestmd5.la
                            > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so
                            > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2
                            > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2.0.22
                            > -rwxr-xr-x 1 root root 939 Sep 4 03:04 libgssapiv2.la
                            > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so
                            > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2
                            > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2.0.22
                            > -rwxr-xr-x 1 root root 883 Sep 4 03:04 libldapdb.la
                            > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so
                            > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2
                            > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2.0.22
                            > -rwxr-xr-x 1 root root 862 Sep 4 03:04 liblogin.la
                            > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so
                            > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2
                            > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2.0.22
                            > -rwxr-xr-x 1 root root 864 Sep 4 03:04 libntlm.la
                            > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so
                            > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2
                            > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2.0.22
                            > -rwxr-xr-x 1 root root 862 Sep 4 03:04 libplain.la
                            > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so
                            > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2
                            > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2.0.22
                            > -rwxr-xr-x 1 root root 936 Sep 4 03:04 libsasldb.la
                            > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so
                            > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2
                            > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2.0.22
                            > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                            > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so
                            > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2
                            > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2.0.22
                            > -rw-r--r-- 1 root root 25 Mar 15 2007 Sendmail.conf
                            > -rw-r--r-- 1 root root 280 Nov 22 23:17 smtpd.conf
                            >
                            > -- listing of /usr/lib/sasl2 --
                            > total 3440
                            > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                            > drwxr-xr-x 50 root root 28672 Nov 20 13:43 ..
                            > -rwxr-xr-x 1 root root 884 Sep 4 03:04 libanonymous.la
                            > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so
                            > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2
                            > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2.0.22
                            > -rwxr-xr-x 1 root root 870 Sep 4 03:04 libcrammd5.la
                            > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so
                            > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2
                            > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2.0.22
                            > -rwxr-xr-x 1 root root 893 Sep 4 03:04 libdigestmd5.la
                            > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so
                            > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2
                            > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2.0.22
                            > -rwxr-xr-x 1 root root 933 Sep 4 03:04 libgssapiv2.la
                            > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so
                            > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2
                            > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2.0.22
                            > -rwxr-xr-x 1 root root 877 Sep 4 03:04 libldapdb.la
                            > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so
                            > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2
                            > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2.0.22
                            > -rwxr-xr-x 1 root root 856 Sep 4 03:04 liblogin.la
                            > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so
                            > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2
                            > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2.0.22
                            > -rwxr-xr-x 1 root root 858 Sep 4 03:04 libntlm.la
                            > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so
                            > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2
                            > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2.0.22
                            > -rwxr-xr-x 1 root root 856 Sep 4 03:04 libplain.la
                            > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so
                            > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2
                            > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2.0.22
                            > -rwxr-xr-x 1 root root 930 Sep 4 03:04 libsasldb.la
                            > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so
                            > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2
                            > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2.0.22
                            > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                            > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so
                            > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2
                            > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2.0.22
                            >
                            > -- listing of /etc/sasl2 --
                            > total 16
                            > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                            > drwxr-xr-x 82 root root 4096 Nov 25 18:20 ..
                            >
                            >
                            >
                            >
                            > -- content of /usr/lib64/sasl2/smtpd.conf --
                            > log_level: 7
                            > pwcheck_method: auxprop
                            > auxprop_plugin: sql
                            > mech_list: plain login
                            > sql_engine: mysql
                            > sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
                            > sql_user: --- replaced ---
                            > sql_passwd: --- replaced ---
                            > sql_database: postfix
                            > sql_select: select clear from postfix_smtp where email='%u@%r'
                            >
                            >
                            > -- active services in /etc/postfix/master.cf --
                            > # service type private unpriv chroot wakeup maxproc command + args
                            > # (yes) (yes) (yes) (never) (100)
                            > smtp inet n - n - - smtpd
                            > pickup fifo n - n 60 1 pickup
                            > cleanup unix n - n - 0 cleanup
                            > qmgr fifo n - n 300 1 qmgr
                            > tlsmgr unix - - n 1000? 1 tlsmgr
                            > rewrite unix - - n - - trivial-rewrite
                            > bounce unix - - n - 0 bounce
                            > defer unix - - n - 0 bounce
                            > trace unix - - n - 0 bounce
                            > verify unix - - n - 1 verify
                            > flush unix n - n 1000? 0 flush
                            > proxymap unix - - n - - proxymap
                            > proxywrite unix - - n - 1 proxymap
                            > smtp unix - - n - - smtp
                            > relay unix - - n - - smtp
                            > -o smtp_fallback_relay=
                            > showq unix n - n - - showq
                            > error unix - - n - - error
                            > retry unix - - n - - error
                            > discard unix - - n - - discard
                            > local unix - n n - - local
                            > virtual unix - n n - - virtual
                            > lmtp unix - - n - - lmtp
                            > anvil unix - - n - 1 anvil
                            > scache unix - - n - 1 scache
                            >
                            > -- mechanisms on localhost --
                            > 250-AUTH LOGIN PLAIN
                            > 250-AUTH=LOGIN PLAIN
                            >
                            >
                            > -- end of saslfinger output --
                            >
                            > -----Original Message-----
                            > From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                            > Sent: Tuesday, November 24, 2009 11:08 PM
                            > To: postfix-users@...
                            > Subject: Re: About SMTP Auth with Mysql
                            >
                            > * Vahriç Muhtaryan <vahric@...>:
                            > > Any postfix guy have a knowledge about this issue
                            > > Really I would like to solve this and debug
                            > > Actually smtp -v do not show the problem also verbose mode to for sasl
                            > > Any idea ?
                            >
                            > It is the Postfix smtpd-daemon and not the smtp-client. If you debug add "-v"
                            > to smtpd, not smtp.
                            >
                            > Download saslfinger and run it:
                            >
                            > saslfinger (debugging SMTP AUTH):
                            > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                            >
                            > Send debug output to the list.
                            >
                            > > -----Original Message-----
                            > > From: owner-postfix-users@...
                            > > [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                            > > Sent: Sunday, November 22, 2009 11:21 PM
                            > > To: 'Patrick Ben Koetter'; postfix-users@...
                            > > Subject: RE: About SMTP Auth with Mysql
                            > >
                            > > I hope that until find the right mailbox and pass it should query each
                            > > setted mysql server but not !
                            > > For to be sure I'm sending different mailbox name and password and wait
                            > > postfix make query step by step but not.
                            > > I told you before with different syntax postfix do differnt actions
                            > > I don't know this is really postfix problem our cyrus problem but I couldn'T
                            > > find any solution
                            > > When you check cyrus docs my sytax is ok but its not working
                            > > İts drive me crazy
                            >
                            > Sorry, but I don't understand what you write.
                            >
                            > p@rick
                            >
                            >
                            >
                            >
                            >
                            > >
                            > > Regards
                            > > Vahric
                            > >
                            > > -----Original Message-----
                            > > From: owner-postfix-users@...
                            > > [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                            > > Sent: Sunday, November 22, 2009 4:44 PM
                            > > To: postfix-users@...
                            > > Subject: Re: About SMTP Auth with Mysql
                            > >
                            > > * Vahriç Muhtaryan <vahric@...>:
                            > > > Hi,
                            > > >
                            > > > (212.58.4.184,212.58.4.247) not worked
                            > > > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                            > > > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                            > > > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                            > > > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                            > > > 247
                            > >
                            > > How did you test?
                            > >
                            > > Just in case you think it should query both servers at the same time: No,
                            > > it's
                            > > not supposed to do that.
                            > >
                            > > If the 1st server in the list is inaccessible, it should try the second.
                            > >
                            > > Have you tested that?
                            > >
                            > > p@rick
                            > >
                            > > --
                            > > All technical questions asked privately will be automatically answered on
                            > > the
                            > > list and archived for public access unless privacy is explicitely required
                            > > and
                            > > justified.
                            > >
                            > > saslfinger (debugging SMTP AUTH):
                            > > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                            > >
                            >
                            > --
                            > All technical questions asked privately will be automatically answered on the
                            > list and archived for public access unless privacy is explicitely required and
                            > justified.
                            >
                            > saslfinger (debugging SMTP AUTH):
                            > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                            >

                            --
                            state of mind
                            Digitale Kommunikation

                            http://www.state-of-mind.de

                            Franziskanerstraße 15 Telefon +49 89 3090 4664
                            81669 München Telefax +49 89 3090 4666

                            Amtsgericht München Partnerschaftsregister PR 563
                          • Vahriç Muhtaryan
                            Hello, One more info, maybe we can solve the source of the problem When I use related syntax sql_hostnames: (212.58.4.247:3306,212.58.4.245:3306) I got related
                            Message 13 of 14 , Dec 1, 2009
                            • 0 Attachment
                              Hello,

                              One more info, maybe we can solve the source of the problem

                              When I use related syntax

                              sql_hostnames: (212.58.4.247:3306,212.58.4.245:3306)

                              I got related error and next server are queried. interesting, looks like sasl or postfix I don't know which one but they care about ":"

                              Nov 23 23:27:52 localhost postfix/smtpd[4325]: sql plugin could not connect to host (212.58.4.247

                              Regards
                              Vahric

                              -----Original Message-----
                              From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                              Sent: Thursday, November 26, 2009 9:04 AM
                              To: 'Patrick Ben Koetter'; postfix-users@...
                              Subject: RE: About SMTP Auth with Mysql

                              Thanks for answer I will check mysql proxy

                              -----Original Message-----
                              From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                              Sent: Wednesday, November 25, 2009 11:06 PM
                              To: postfix-users@...
                              Subject: Re: About SMTP Auth with Mysql

                              Vahriç,

                              * Vahriç Muhtaryan <vahric@...>:
                              > You can find out related out below.

                              thanks for the debug output. Your config looks okay. Your problem is - as I
                              understand it - you want Cyrus SASL to do something it can't do:

                              1. If you list more than one host with $sql_hostnames then those hosts will be
                              queried in order listed from left to right.
                              2. The first host in the list that answers will be used. Any other host will
                              not be queried.
                              3. It is not possible to query all hosts at the same time.

                              So, if you want to query several MySQL servers at the same time, it cannot be
                              done. All I can think of is moving your data to one SQL server instance.

                              OTOH maybe you can use mysql-proxy <http://forge.mysql.com/wiki/MySQL_Proxy>,
                              configure that to transform the query to query both servers and let SASL query
                              the mysql-proxy.

                              HTH,

                              p@rick




                              > Regards
                              > Vahric
                              >
                              > [root@postfix-auth1 ~]# ./saslfinger-1.0.3/saslfinger -s
                              > saslfinger - postfix Cyrus sasl configuration Wed Nov 25 18:47:20 EET 2009
                              > version: 1.0.2
                              > mode: server-side SMTP AUTH
                              >
                              > -- basics --
                              > Postfix: 2.5.9
                              > System: CentOS release 5.4 (Final)
                              >
                              > -- smtpd is linked to --
                              > libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003dfba00000)
                              >
                              > -- active SMTP AUTH and TLS parameters for smtpd --
                              > broken_sasl_auth_clients = yes
                              > smtpd_sasl_auth_enable = yes
                              >
                              >
                              > -- listing of /usr/lib64/sasl2 --
                              > total 3500
                              > drwxr-xr-x 2 root root 4096 Nov 22 23:17 .
                              > drwxr-xr-x 55 root root 36864 Nov 21 04:03 ..
                              > -rwxr-xr-x 1 root root 890 Sep 4 03:04 libanonymous.la
                              > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so
                              > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2
                              > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2.0.22
                              > -rwxr-xr-x 1 root root 876 Sep 4 03:04 libcrammd5.la
                              > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so
                              > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2
                              > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2.0.22
                              > -rwxr-xr-x 1 root root 899 Sep 4 03:04 libdigestmd5.la
                              > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so
                              > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2
                              > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2.0.22
                              > -rwxr-xr-x 1 root root 939 Sep 4 03:04 libgssapiv2.la
                              > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so
                              > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2
                              > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2.0.22
                              > -rwxr-xr-x 1 root root 883 Sep 4 03:04 libldapdb.la
                              > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so
                              > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2
                              > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2.0.22
                              > -rwxr-xr-x 1 root root 862 Sep 4 03:04 liblogin.la
                              > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so
                              > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2
                              > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2.0.22
                              > -rwxr-xr-x 1 root root 864 Sep 4 03:04 libntlm.la
                              > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so
                              > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2
                              > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2.0.22
                              > -rwxr-xr-x 1 root root 862 Sep 4 03:04 libplain.la
                              > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so
                              > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2
                              > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2.0.22
                              > -rwxr-xr-x 1 root root 936 Sep 4 03:04 libsasldb.la
                              > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so
                              > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2
                              > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2.0.22
                              > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                              > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so
                              > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2
                              > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2.0.22
                              > -rw-r--r-- 1 root root 25 Mar 15 2007 Sendmail.conf
                              > -rw-r--r-- 1 root root 280 Nov 22 23:17 smtpd.conf
                              >
                              > -- listing of /usr/lib/sasl2 --
                              > total 3440
                              > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                              > drwxr-xr-x 50 root root 28672 Nov 20 13:43 ..
                              > -rwxr-xr-x 1 root root 884 Sep 4 03:04 libanonymous.la
                              > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so
                              > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2
                              > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2.0.22
                              > -rwxr-xr-x 1 root root 870 Sep 4 03:04 libcrammd5.la
                              > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so
                              > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2
                              > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2.0.22
                              > -rwxr-xr-x 1 root root 893 Sep 4 03:04 libdigestmd5.la
                              > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so
                              > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2
                              > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2.0.22
                              > -rwxr-xr-x 1 root root 933 Sep 4 03:04 libgssapiv2.la
                              > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so
                              > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2
                              > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2.0.22
                              > -rwxr-xr-x 1 root root 877 Sep 4 03:04 libldapdb.la
                              > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so
                              > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2
                              > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2.0.22
                              > -rwxr-xr-x 1 root root 856 Sep 4 03:04 liblogin.la
                              > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so
                              > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2
                              > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2.0.22
                              > -rwxr-xr-x 1 root root 858 Sep 4 03:04 libntlm.la
                              > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so
                              > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2
                              > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2.0.22
                              > -rwxr-xr-x 1 root root 856 Sep 4 03:04 libplain.la
                              > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so
                              > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2
                              > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2.0.22
                              > -rwxr-xr-x 1 root root 930 Sep 4 03:04 libsasldb.la
                              > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so
                              > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2
                              > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2.0.22
                              > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                              > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so
                              > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2
                              > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2.0.22
                              >
                              > -- listing of /etc/sasl2 --
                              > total 16
                              > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                              > drwxr-xr-x 82 root root 4096 Nov 25 18:20 ..
                              >
                              >
                              >
                              >
                              > -- content of /usr/lib64/sasl2/smtpd.conf --
                              > log_level: 7
                              > pwcheck_method: auxprop
                              > auxprop_plugin: sql
                              > mech_list: plain login
                              > sql_engine: mysql
                              > sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
                              > sql_user: --- replaced ---
                              > sql_passwd: --- replaced ---
                              > sql_database: postfix
                              > sql_select: select clear from postfix_smtp where email='%u@%r'
                              >
                              >
                              > -- active services in /etc/postfix/master.cf --
                              > # service type private unpriv chroot wakeup maxproc command + args
                              > # (yes) (yes) (yes) (never) (100)
                              > smtp inet n - n - - smtpd
                              > pickup fifo n - n 60 1 pickup
                              > cleanup unix n - n - 0 cleanup
                              > qmgr fifo n - n 300 1 qmgr
                              > tlsmgr unix - - n 1000? 1 tlsmgr
                              > rewrite unix - - n - - trivial-rewrite
                              > bounce unix - - n - 0 bounce
                              > defer unix - - n - 0 bounce
                              > trace unix - - n - 0 bounce
                              > verify unix - - n - 1 verify
                              > flush unix n - n 1000? 0 flush
                              > proxymap unix - - n - - proxymap
                              > proxywrite unix - - n - 1 proxymap
                              > smtp unix - - n - - smtp
                              > relay unix - - n - - smtp
                              > -o smtp_fallback_relay=
                              > showq unix n - n - - showq
                              > error unix - - n - - error
                              > retry unix - - n - - error
                              > discard unix - - n - - discard
                              > local unix - n n - - local
                              > virtual unix - n n - - virtual
                              > lmtp unix - - n - - lmtp
                              > anvil unix - - n - 1 anvil
                              > scache unix - - n - 1 scache
                              >
                              > -- mechanisms on localhost --
                              > 250-AUTH LOGIN PLAIN
                              > 250-AUTH=LOGIN PLAIN
                              >
                              >
                              > -- end of saslfinger output --
                              >
                              > -----Original Message-----
                              > From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                              > Sent: Tuesday, November 24, 2009 11:08 PM
                              > To: postfix-users@...
                              > Subject: Re: About SMTP Auth with Mysql
                              >
                              > * Vahriç Muhtaryan <vahric@...>:
                              > > Any postfix guy have a knowledge about this issue
                              > > Really I would like to solve this and debug
                              > > Actually smtp -v do not show the problem also verbose mode to for sasl
                              > > Any idea ?
                              >
                              > It is the Postfix smtpd-daemon and not the smtp-client. If you debug add "-v"
                              > to smtpd, not smtp.
                              >
                              > Download saslfinger and run it:
                              >
                              > saslfinger (debugging SMTP AUTH):
                              > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                              >
                              > Send debug output to the list.
                              >
                              > > -----Original Message-----
                              > > From: owner-postfix-users@...
                              > > [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                              > > Sent: Sunday, November 22, 2009 11:21 PM
                              > > To: 'Patrick Ben Koetter'; postfix-users@...
                              > > Subject: RE: About SMTP Auth with Mysql
                              > >
                              > > I hope that until find the right mailbox and pass it should query each
                              > > setted mysql server but not !
                              > > For to be sure I'm sending different mailbox name and password and wait
                              > > postfix make query step by step but not.
                              > > I told you before with different syntax postfix do differnt actions
                              > > I don't know this is really postfix problem our cyrus problem but I couldn'T
                              > > find any solution
                              > > When you check cyrus docs my sytax is ok but its not working
                              > > İts drive me crazy
                              >
                              > Sorry, but I don't understand what you write.
                              >
                              > p@rick
                              >
                              >
                              >
                              >
                              >
                              > >
                              > > Regards
                              > > Vahric
                              > >
                              > > -----Original Message-----
                              > > From: owner-postfix-users@...
                              > > [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                              > > Sent: Sunday, November 22, 2009 4:44 PM
                              > > To: postfix-users@...
                              > > Subject: Re: About SMTP Auth with Mysql
                              > >
                              > > * Vahriç Muhtaryan <vahric@...>:
                              > > > Hi,
                              > > >
                              > > > (212.58.4.184,212.58.4.247) not worked
                              > > > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                              > > > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                              > > > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                              > > > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                              > > > 247
                              > >
                              > > How did you test?
                              > >
                              > > Just in case you think it should query both servers at the same time: No,
                              > > it's
                              > > not supposed to do that.
                              > >
                              > > If the 1st server in the list is inaccessible, it should try the second.
                              > >
                              > > Have you tested that?
                              > >
                              > > p@rick
                              > >
                              > > --
                              > > All technical questions asked privately will be automatically answered on
                              > > the
                              > > list and archived for public access unless privacy is explicitely required
                              > > and
                              > > justified.
                              > >
                              > > saslfinger (debugging SMTP AUTH):
                              > > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                              > >
                              >
                              > --
                              > All technical questions asked privately will be automatically answered on the
                              > list and archived for public access unless privacy is explicitely required and
                              > justified.
                              >
                              > saslfinger (debugging SMTP AUTH):
                              > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                              >

                              --
                              state of mind
                              Digitale Kommunikation

                              http://www.state-of-mind.de

                              Franziskanerstraße 15 Telefon +49 89 3090 4664
                              81669 München Telefax +49 89 3090 4666

                              Amtsgericht München Partnerschaftsregister PR 563
                            • Patrick Ben Koetter
                              Vahriç, ... Cyrus SASL cannot do what you want. Stop wasting everybodys time with your experiments . If you want Cyrus SASL to query all servers in a row sit
                              Message 14 of 14 , Dec 1, 2009
                              • 0 Attachment
                                Vahriç,

                                * Vahriç Muhtaryan <vahric@...>:
                                > One more info, maybe we can solve the source of the problem
                                >
                                > When I use related syntax
                                >
                                > sql_hostnames: (212.58.4.247:3306,212.58.4.245:3306)
                                >
                                > I got related error and next server are queried. interesting, looks like sasl or postfix I don't know which one but they care about ":"
                                >
                                > Nov 23 23:27:52 localhost postfix/smtpd[4325]: sql plugin could not connect to host (212.58.4.247

                                Cyrus SASL cannot do what you want.

                                Stop wasting everybodys time with your 'experiments'. If you want Cyrus SASL
                                to query all servers in a row sit down and program it yourself.

                                p@rick




                                >
                                > Regards
                                > Vahric
                                >
                                > -----Original Message-----
                                > From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                                > Sent: Thursday, November 26, 2009 9:04 AM
                                > To: 'Patrick Ben Koetter'; postfix-users@...
                                > Subject: RE: About SMTP Auth with Mysql
                                >
                                > Thanks for answer I will check mysql proxy
                                >
                                > -----Original Message-----
                                > From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                                > Sent: Wednesday, November 25, 2009 11:06 PM
                                > To: postfix-users@...
                                > Subject: Re: About SMTP Auth with Mysql
                                >
                                > Vahriç,
                                >
                                > * Vahriç Muhtaryan <vahric@...>:
                                > > You can find out related out below.
                                >
                                > thanks for the debug output. Your config looks okay. Your problem is - as I
                                > understand it - you want Cyrus SASL to do something it can't do:
                                >
                                > 1. If you list more than one host with $sql_hostnames then those hosts will be
                                > queried in order listed from left to right.
                                > 2. The first host in the list that answers will be used. Any other host will
                                > not be queried.
                                > 3. It is not possible to query all hosts at the same time.
                                >
                                > So, if you want to query several MySQL servers at the same time, it cannot be
                                > done. All I can think of is moving your data to one SQL server instance.
                                >
                                > OTOH maybe you can use mysql-proxy <http://forge.mysql.com/wiki/MySQL_Proxy>,
                                > configure that to transform the query to query both servers and let SASL query
                                > the mysql-proxy.
                                >
                                > HTH,
                                >
                                > p@rick
                                >
                                >
                                >
                                >
                                > > Regards
                                > > Vahric
                                > >
                                > > [root@postfix-auth1 ~]# ./saslfinger-1.0.3/saslfinger -s
                                > > saslfinger - postfix Cyrus sasl configuration Wed Nov 25 18:47:20 EET 2009
                                > > version: 1.0.2
                                > > mode: server-side SMTP AUTH
                                > >
                                > > -- basics --
                                > > Postfix: 2.5.9
                                > > System: CentOS release 5.4 (Final)
                                > >
                                > > -- smtpd is linked to --
                                > > libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003dfba00000)
                                > >
                                > > -- active SMTP AUTH and TLS parameters for smtpd --
                                > > broken_sasl_auth_clients = yes
                                > > smtpd_sasl_auth_enable = yes
                                > >
                                > >
                                > > -- listing of /usr/lib64/sasl2 --
                                > > total 3500
                                > > drwxr-xr-x 2 root root 4096 Nov 22 23:17 .
                                > > drwxr-xr-x 55 root root 36864 Nov 21 04:03 ..
                                > > -rwxr-xr-x 1 root root 890 Sep 4 03:04 libanonymous.la
                                > > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so
                                > > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2
                                > > -rwxr-xr-x 1 root root 15880 Sep 4 03:05 libanonymous.so.2.0.22
                                > > -rwxr-xr-x 1 root root 876 Sep 4 03:04 libcrammd5.la
                                > > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so
                                > > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2
                                > > -rwxr-xr-x 1 root root 19264 Sep 4 03:05 libcrammd5.so.2.0.22
                                > > -rwxr-xr-x 1 root root 899 Sep 4 03:04 libdigestmd5.la
                                > > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so
                                > > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2
                                > > -rwxr-xr-x 1 root root 48520 Sep 4 03:05 libdigestmd5.so.2.0.22
                                > > -rwxr-xr-x 1 root root 939 Sep 4 03:04 libgssapiv2.la
                                > > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so
                                > > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2
                                > > -rwxr-xr-x 1 root root 28096 Sep 4 03:05 libgssapiv2.so.2.0.22
                                > > -rwxr-xr-x 1 root root 883 Sep 4 03:04 libldapdb.la
                                > > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so
                                > > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2
                                > > -rwxr-xr-x 1 root root 17736 Sep 4 03:05 libldapdb.so.2.0.22
                                > > -rwxr-xr-x 1 root root 862 Sep 4 03:04 liblogin.la
                                > > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so
                                > > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2
                                > > -rwxr-xr-x 1 root root 16448 Sep 4 03:05 liblogin.so.2.0.22
                                > > -rwxr-xr-x 1 root root 864 Sep 4 03:04 libntlm.la
                                > > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so
                                > > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2
                                > > -rwxr-xr-x 1 root root 32704 Sep 4 03:05 libntlm.so.2.0.22
                                > > -rwxr-xr-x 1 root root 862 Sep 4 03:04 libplain.la
                                > > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so
                                > > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2
                                > > -rwxr-xr-x 1 root root 16416 Sep 4 03:05 libplain.so.2.0.22
                                > > -rwxr-xr-x 1 root root 936 Sep 4 03:04 libsasldb.la
                                > > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so
                                > > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2
                                > > -rwxr-xr-x 1 root root 893304 Sep 4 03:05 libsasldb.so.2.0.22
                                > > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                                > > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so
                                > > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2
                                > > -rwxr-xr-x 1 root root 24808 Sep 4 03:05 libsql.so.2.0.22
                                > > -rw-r--r-- 1 root root 25 Mar 15 2007 Sendmail.conf
                                > > -rw-r--r-- 1 root root 280 Nov 22 23:17 smtpd.conf
                                > >
                                > > -- listing of /usr/lib/sasl2 --
                                > > total 3440
                                > > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                                > > drwxr-xr-x 50 root root 28672 Nov 20 13:43 ..
                                > > -rwxr-xr-x 1 root root 884 Sep 4 03:04 libanonymous.la
                                > > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so
                                > > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2
                                > > -rwxr-xr-x 1 root root 14372 Sep 4 03:04 libanonymous.so.2.0.22
                                > > -rwxr-xr-x 1 root root 870 Sep 4 03:04 libcrammd5.la
                                > > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so
                                > > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2
                                > > -rwxr-xr-x 1 root root 16832 Sep 4 03:04 libcrammd5.so.2.0.22
                                > > -rwxr-xr-x 1 root root 893 Sep 4 03:04 libdigestmd5.la
                                > > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so
                                > > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2
                                > > -rwxr-xr-x 1 root root 47172 Sep 4 03:04 libdigestmd5.so.2.0.22
                                > > -rwxr-xr-x 1 root root 933 Sep 4 03:04 libgssapiv2.la
                                > > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so
                                > > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2
                                > > -rwxr-xr-x 1 root root 26496 Sep 4 03:04 libgssapiv2.so.2.0.22
                                > > -rwxr-xr-x 1 root root 877 Sep 4 03:04 libldapdb.la
                                > > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so
                                > > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2
                                > > -rwxr-xr-x 1 root root 15484 Sep 4 03:04 libldapdb.so.2.0.22
                                > > -rwxr-xr-x 1 root root 856 Sep 4 03:04 liblogin.la
                                > > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so
                                > > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2
                                > > -rwxr-xr-x 1 root root 14752 Sep 4 03:04 liblogin.so.2.0.22
                                > > -rwxr-xr-x 1 root root 858 Sep 4 03:04 libntlm.la
                                > > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so
                                > > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2
                                > > -rwxr-xr-x 1 root root 31548 Sep 4 03:04 libntlm.so.2.0.22
                                > > -rwxr-xr-x 1 root root 856 Sep 4 03:04 libplain.la
                                > > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so
                                > > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2
                                > > -rwxr-xr-x 1 root root 14848 Sep 4 03:04 libplain.so.2.0.22
                                > > -rwxr-xr-x 1 root root 930 Sep 4 03:04 libsasldb.la
                                > > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so
                                > > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2
                                > > -rwxr-xr-x 1 root root 905200 Sep 4 03:04 libsasldb.so.2.0.22
                                > > -rwxr-xr-x 1 root root 878 Sep 4 03:04 libsql.la
                                > > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so
                                > > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2
                                > > -rwxr-xr-x 1 root root 23080 Sep 4 03:04 libsql.so.2.0.22
                                > >
                                > > -- listing of /etc/sasl2 --
                                > > total 16
                                > > drwxr-xr-x 2 root root 4096 Nov 20 13:43 .
                                > > drwxr-xr-x 82 root root 4096 Nov 25 18:20 ..
                                > >
                                > >
                                > >
                                > >
                                > > -- content of /usr/lib64/sasl2/smtpd.conf --
                                > > log_level: 7
                                > > pwcheck_method: auxprop
                                > > auxprop_plugin: sql
                                > > mech_list: plain login
                                > > sql_engine: mysql
                                > > sql_hostnames: (212.58.4.184:3306,212.58.4.247:3306)
                                > > sql_user: --- replaced ---
                                > > sql_passwd: --- replaced ---
                                > > sql_database: postfix
                                > > sql_select: select clear from postfix_smtp where email='%u@%r'
                                > >
                                > >
                                > > -- active services in /etc/postfix/master.cf --
                                > > # service type private unpriv chroot wakeup maxproc command + args
                                > > # (yes) (yes) (yes) (never) (100)
                                > > smtp inet n - n - - smtpd
                                > > pickup fifo n - n 60 1 pickup
                                > > cleanup unix n - n - 0 cleanup
                                > > qmgr fifo n - n 300 1 qmgr
                                > > tlsmgr unix - - n 1000? 1 tlsmgr
                                > > rewrite unix - - n - - trivial-rewrite
                                > > bounce unix - - n - 0 bounce
                                > > defer unix - - n - 0 bounce
                                > > trace unix - - n - 0 bounce
                                > > verify unix - - n - 1 verify
                                > > flush unix n - n 1000? 0 flush
                                > > proxymap unix - - n - - proxymap
                                > > proxywrite unix - - n - 1 proxymap
                                > > smtp unix - - n - - smtp
                                > > relay unix - - n - - smtp
                                > > -o smtp_fallback_relay=
                                > > showq unix n - n - - showq
                                > > error unix - - n - - error
                                > > retry unix - - n - - error
                                > > discard unix - - n - - discard
                                > > local unix - n n - - local
                                > > virtual unix - n n - - virtual
                                > > lmtp unix - - n - - lmtp
                                > > anvil unix - - n - 1 anvil
                                > > scache unix - - n - 1 scache
                                > >
                                > > -- mechanisms on localhost --
                                > > 250-AUTH LOGIN PLAIN
                                > > 250-AUTH=LOGIN PLAIN
                                > >
                                > >
                                > > -- end of saslfinger output --
                                > >
                                > > -----Original Message-----
                                > > From: owner-postfix-users@... [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                                > > Sent: Tuesday, November 24, 2009 11:08 PM
                                > > To: postfix-users@...
                                > > Subject: Re: About SMTP Auth with Mysql
                                > >
                                > > * Vahriç Muhtaryan <vahric@...>:
                                > > > Any postfix guy have a knowledge about this issue
                                > > > Really I would like to solve this and debug
                                > > > Actually smtp -v do not show the problem also verbose mode to for sasl
                                > > > Any idea ?
                                > >
                                > > It is the Postfix smtpd-daemon and not the smtp-client. If you debug add "-v"
                                > > to smtpd, not smtp.
                                > >
                                > > Download saslfinger and run it:
                                > >
                                > > saslfinger (debugging SMTP AUTH):
                                > > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                                > >
                                > > Send debug output to the list.
                                > >
                                > > > -----Original Message-----
                                > > > From: owner-postfix-users@...
                                > > > [mailto:owner-postfix-users@...] On Behalf Of Vahriç Muhtaryan
                                > > > Sent: Sunday, November 22, 2009 11:21 PM
                                > > > To: 'Patrick Ben Koetter'; postfix-users@...
                                > > > Subject: RE: About SMTP Auth with Mysql
                                > > >
                                > > > I hope that until find the right mailbox and pass it should query each
                                > > > setted mysql server but not !
                                > > > For to be sure I'm sending different mailbox name and password and wait
                                > > > postfix make query step by step but not.
                                > > > I told you before with different syntax postfix do differnt actions
                                > > > I don't know this is really postfix problem our cyrus problem but I couldn'T
                                > > > find any solution
                                > > > When you check cyrus docs my sytax is ok but its not working
                                > > > İts drive me crazy
                                > >
                                > > Sorry, but I don't understand what you write.
                                > >
                                > > p@rick
                                > >
                                > >
                                > >
                                > >
                                > >
                                > > >
                                > > > Regards
                                > > > Vahric
                                > > >
                                > > > -----Original Message-----
                                > > > From: owner-postfix-users@...
                                > > > [mailto:owner-postfix-users@...] On Behalf Of Patrick Ben Koetter
                                > > > Sent: Sunday, November 22, 2009 4:44 PM
                                > > > To: postfix-users@...
                                > > > Subject: Re: About SMTP Auth with Mysql
                                > > >
                                > > > * Vahriç Muhtaryan <vahric@...>:
                                > > > > Hi,
                                > > > >
                                > > > > (212.58.4.184,212.58.4.247) not worked
                                > > > > (212.58.4.184:3306,212.58.4.247:3306)query arrive to 4.247 but not to 184
                                > > > > 212.58.4.184:3306,212.58.4.247:3306 query arrive to 4.184 but not to 247
                                > > > > 212.58.4.184:3306 212.58.4.247:3306 query arrive to 4.184 but not to 247
                                > > > > sql_hostnames: 212.58.4.184 212.58.4.247 query arrive to 4.184 but not to
                                > > > > 247
                                > > >
                                > > > How did you test?
                                > > >
                                > > > Just in case you think it should query both servers at the same time: No,
                                > > > it's
                                > > > not supposed to do that.
                                > > >
                                > > > If the 1st server in the list is inaccessible, it should try the second.
                                > > >
                                > > > Have you tested that?
                                > > >
                                > > > p@rick
                                > > >
                                > > > --
                                > > > All technical questions asked privately will be automatically answered on
                                > > > the
                                > > > list and archived for public access unless privacy is explicitely required
                                > > > and
                                > > > justified.
                                > > >
                                > > > saslfinger (debugging SMTP AUTH):
                                > > > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                                > > >
                                > >
                                > > --
                                > > All technical questions asked privately will be automatically answered on the
                                > > list and archived for public access unless privacy is explicitely required and
                                > > justified.
                                > >
                                > > saslfinger (debugging SMTP AUTH):
                                > > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
                                > >
                                >
                                > --
                                > state of mind
                                > Digitale Kommunikation
                                >
                                > http://www.state-of-mind.de
                                >
                                > Franziskanerstraße 15 Telefon +49 89 3090 4664
                                > 81669 München Telefax +49 89 3090 4666
                                >
                                > Amtsgericht München Partnerschaftsregister PR 563
                                >
                              Your message has been successfully submitted and would be delivered to recipients shortly.