From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.2.3 (2007-08-08) on sa.int.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-1.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=3.2.3 To: ALT Linux sysadmin discuss Organization: Tyumen State University References: <200802040944.17661.myjamm@gmail.com> From: "Vladimir V. Kamarzin" In-Reply-To: <200802040944.17661.myjamm@gmail.com> (JaMm's message of "Mon, 4 Feb 2008 09:44:17 +1000") User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.5-b28 (linux) Date: Tue, 05 Feb 2008 12:15:29 +0500 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" X-Virus-Scanned: Scanned by clamav Subject: Re: [Sysadmins] =?iso-8859-5?q?cyrus-sasl2_pam_mysql_=DD=D5_=D0=E3=E2?= =?iso-8859-5?b?1d3i2OTY5tjg49Xi?= X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.9 Precedence: list Reply-To: ALT Linux sysadmin discuss List-Id: ALT Linux sysadmin discuss List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 05 Feb 2008 07:17:56 -0000 Archived-At: List-Archive: --=-=-= Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable >>>>> On 04 Feb 2008 at 04:44 "J" =3D=3D JaMm writes: mysql>> select * from accountuser; J> +-----------+---------------+--------+-------------+ J> | username =A0| password =A0 =A0 =A0| prefix | domain_name | J> +-----------+---------------+--------+-------------+ J> | cyrus =A0 =A0 | M.QD4KWNL1YNo | =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0 = =A0 | J> | test@test | 123 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 =A0| =A0 =A0 =A0 = =A0 =A0 =A0 | J> | test =A0 =A0 =A0| 123 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 =A0| =A0 =A0 = =A0 =A0 =A0 =A0 | J> | tst =A0 =A0 =A0 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 =A0| =A0 = =A0 =A0 =A0 =A0 =A0 | J> +-----------+---------------+--------+-------------+ --=-=-= Content-Type: text/plain; charset=iso-8859-5 Content-Transfer-Encoding: quoted-printable =BF=DE=E1=DC=DE=E2=E0=D5=DB =E1=D2=DE=EE =D4=E0=D5=D2=DD=EE=EE =D8=DD=E1=E2= =D0=DB=DB=EF=E6=D8=EE web-cyradm, =E2=D0=D1=DB=D8=E6=D0 accountuser =E2=D0= =DC =D2=EB=D3=DB=EF=D4=D8=E2 =D2=DE=E2 =E2=D0=DA: mysql> select * from accountuser; +-----------+---------------+--------+-------------+ | username | password | prefix | domain_name | +-----------+---------------+--------+-------------+ | cyrus | vjD5UKrOWumxs | | | | xxxx0002 | 95LtBJGNVP9wc | xxxx | x.ru | | xxxx0001 | cfS0NnZc/dezU | xxxx | x.ru | | xxxx0005 | 82mRPY2JJo6r6 | xxxx | x.ru | | xxxx0004 | 0aZQ4HovNwio2 | xxxx | x.ru | +-----------+---------------+--------+-------------+ 5 rows in set (0.06 sec =CE=D7=D5=E0=EB =D7=D0=D2=DE=D4=D8=DB=D8=E1=EC =E1=E0=D5=D4=E1=E2=D2=D0=DC= =D8 web-cyradm. =BD=D0 =D2=E1=EF=DA=D8=D9 =E1=DB=E3=E7=D0=D9: # cat /etc/pam.d/imap #%PAM-1.0 #auth include system-auth #account include system-auth auth sufficient pam_mysql.so user=3Dmail passwd=3Dxxxxxx host=3Dlocalhost = db=3Dmail table=3Daccountuser usercolumn=3Dusername passwdcolumn=3Dpassword= crypt=3D1 logtable=3Dlog logmsgcolumn=3Dmsg logusercolumn=3Duser loghostco= lumn=3Dhost logpidcolumn=3Dpid logtimecolumn=3Dtime #auth sufficient pam_unix_auth.so account required pam_mysql.so user=3Dmail passwd=3Dxxxxx host=3Dlocalhost d= b=3Dmail table=3Daccountuser usercolumn=3Dusername passwdcolumn=3Dpassword = crypt=3D1 logtable=3Dlog logmsgcolumn=3Dmsg logusercolumn=3Duser loghostcol= umn=3Dhost logpidcolumn=3Dpid logtimecolumn=3Dtime #account sufficient pam_unix_acct.so --=20 vvk Russian Postfix irc: irc.freenode.net #postfix-ru --=-=-=--