Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug
Bug#: 123405
Alias:
Product:
Component:
Status: RESOLVED
Resolution: DUPLICATE of bug 120842
Assigned To: PAM Gentoo Team <pam-bugs@gentoo.org>
Hardware:
OS:
Version:
Priority:
Severity:
Reporter: Cyrius <cyrius@linog-consulting.com>
Add CC:
CC:
Remove selected CCs
URL:
Summary:
Status Whiteboard:
Keywords:

Filename Description Type Creator Created Size Actions
pam_mysql.tar.bz2 New ebuilds for 0.6.2 and 0.7_rc1 pam_mysql modules application/octet-stream Cyrius 2006-02-19 09:55 0000 3.42 KB Details
pam_mysql_v2.tar.bz2 New ebuilds for 0.6.2 and 0.7_rc1 pam_mysql modules application/octet-stream Cyrius 2006-02-19 13:40 0000 4.62 KB Details
pam_mysql-0.6.2.ebuild New ebuilds for 0.6.2 pam_mysql module text/plain Cyrius 2006-02-19 14:08 0000 2.68 KB Details
pam_mysql-0.6.2.patch 0.6.2 source code patch for sasl2 openssl integration patch Cyrius 2006-02-19 14:10 0000 2.62 KB Details | Diff
pam_mysql-0.6.2_v2.patch 0.6.2 source code patch for linking with pam librairies patch Cyrius 2006-02-19 14:11 0000 4.33 KB Details | Diff
pam_mysql-0.7_rc1.ebuild New ebuild 0.7_rc1 pam_mysql module text/plain Cyrius 2006-02-19 14:12 0000 2.95 KB Details
pam_mysql-0.7_rc1.patch 0.7_rc1 source code patch for sasl2 openssl ipv6 integration patch Cyrius 2006-02-19 14:13 0000 3.25 KB Details | Diff
pam_mysql-0.7_rc1_v2.patch 0.7_rc1 source code patch for linking with pam librairies patch Cyrius 2006-02-19 14:15 0000 4.87 KB Details | Diff
pam_mysql-0.6.2.patch 0.6.2 source code patch for sasl2 openssl integration patch Cyrius 2006-04-07 14:07 0000 2.22 KB Details | Diff
pam_mysql-0.6.2_v2.patch 0.6.2 source code patch for linking with pam librairies patch Cyrius 2006-04-07 14:08 0000 3.93 KB Details | Diff
pam_mysql-0.7_rc1.patch 0.7_rc1 source code patch for sasl2 openssl ipv6 integration patch Cyrius 2006-04-07 14:24 0000 2.67 KB Details | Diff
pam_mysql-0.7_rc1_v2.patch 0.7_rc1 source code patch for linking with pam librairies patch Cyrius 2006-04-07 14:25 0000 4.44 KB Details | Diff
Create a New Attachment (proposed patch, testcase, etc.) View All

Bug 123405 depends on: Show dependency tree
Bug 123405 blocks: 85787 104967 120842
Votes: 0    Show votes for this bug    Vote for this bug

Additional Comments: (this is where you put emerge --info)


Not eligible to see or edit group visibility for this bug.






View Bug Activity   |   Format For Printing   |   XML   |   Clone This Bug


Description:   Opened: 2006-02-19 09:54 0000
Hi,

   You will find on attachment the complete ebuilds of the 0.6.2 and 0.7_rc1 of
pam_mysql modules. I have tried to correct the lack of md5, openssl and sasl2
use.

   I've had some dependencies.

   Could it be possible for someone to test it please ?

Cyrius.

------- Comment #1 From Cyrius 2006-02-19 09:55:25 0000 -------
Created an attachment (id=80200) [details]
New ebuilds for 0.6.2 and 0.7_rc1 pam_mysql modules 

------- Comment #2 From Jakub Moc (RETIRED) 2006-02-19 10:12:01 0000 -------
Don't attach tarballs.

http://www.gentoo.org/proj/en/devrel/handbook/handbook.xml?part=2&chap=3#doc_chap2

Reopen with unified diffs against current ebuilds.

------- Comment #3 From Cyrius 2006-02-19 13:36:36 0000 -------
(From update of attachment 80200 [details])
Doesn't take in account pam librairies

------- Comment #4 From Cyrius 2006-02-19 13:40:16 0000 -------
Created an attachment (id=80217) [details]
New ebuilds for 0.6.2 and 0.7_rc1 pam_mysql modules 

Hi all,

  When doing ldd -r /lib/security/pam_mysql, we can see that the pam librairies
are not linked with pam_mysql.

  I hope to have corrected it.

  Could someone test thoses versions please ?


Cyrius

------- Comment #5 From Cyrius 2006-02-19 13:54:09 0000 -------
Oups, 

   Sorry Jakub. i didn't see it was closed.
   But there are Two ebuilds and source, acinclude.m4, configure.in code patch
in the tarball.
   Do you confirm me i have to create thoses attachments ?

Thanks in advance
       Cyrius

------- Comment #6 From Jakub Moc (RETIRED) 2006-02-19 14:06:41 0000 -------
Yeah, plaintext please...

------- Comment #7 From Cyrius 2006-02-19 14:07:35 0000 -------
(From update of attachment 80217 [details])
Tarball is forbiden

------- Comment #8 From Cyrius 2006-02-19 14:08:45 0000 -------
Created an attachment (id=80218) [details]
New ebuilds for 0.6.2 pam_mysql module

------- Comment #9 From Cyrius 2006-02-19 14:10:22 0000 -------
Created an attachment (id=80219) [details]
Source code patch for sasl2 openssl integration

You must put this patch in the files directiry

------- Comment #10 From Cyrius 2006-02-19 14:11:32 0000 -------
Created an attachment (id=80220) [details]
Source code patch for linking with pam librairies

To put in the files directory

------- Comment #11 From Cyrius 2006-02-19 14:12:46 0000 -------
Created an attachment (id=80221) [details]
New ebuild 0.7_rc1 pam_mysql module

------- Comment #12 From Cyrius 2006-02-19 14:13:48 0000 -------
Created an attachment (id=80222) [details]
0.7_rc1 source code patch for sasl2 openssl ipv6 integration

to put in the files directory

------- Comment #13 From Cyrius 2006-02-19 14:15:46 0000 -------
Created an attachment (id=80223) [details]
0.7_rc1 source code patch for linking with pam librairies

to put in the files directory

------- Comment #14 From Cyrius 2006-02-19 14:18:21 0000 -------
Hi,

   I've hadded thoses new ebuilds and patch wihtout the use of a tarball.

   Could someone test thoses ebuilds please ?

Cyrius

------- Comment #15 From Cyrius 2006-02-20 07:12:44 0000 -------
Hello All,

    I'm testing the 0.7_rc1 with postfix.
    I'm following thoses how to :
http://postfixwiki.org/index.php?title=Virtual_Users_and_Domains_with_Courier-IMAP_and_MySQL
http://gentoo-wiki.com/HOWTO_Linux_Virtual_Hosting_Server#Postfix

    With telnet testing all seems to be ok.
    Mysql is accessed, data retreived and translated.

I have tested only this configuration :

/etc/pam.d/smtp
auth       required     pam_nologin.so
auth       required     pam_mysql.so user=mailsql passwd=ebonzai02152006
host=localhost db=postfixdb_config table=mailbox usercolumn=username
passwdcolumn=password crypt=1
#auth       required     pam_unix.so
auth       required     pam_env.so # [1]

account    sufficient   pam_mysql.so user=mailsql passwd=xxxxxx host=localhost
db=postfixdb_config table=mailbox usercolumn=username passwdcolumn=password
crypt=1
account    required     pam_unix.so

No dump, No error message.
The parameter crypt put to 1 means using crypt function (see the README file)

Then, perhaps you can say it's ok for p

------- Comment #16 From Cyrius 2006-02-20 07:12:44 0000 -------
Hello All,

    I'm testing the 0.7_rc1 with postfix.
    I'm following thoses how to :
http://postfixwiki.org/index.php?title=Virtual_Users_and_Domains_with_Courier-IMAP_and_MySQL
http://gentoo-wiki.com/HOWTO_Linux_Virtual_Hosting_Server#Postfix

    With telnet testing all seems to be ok.
    Mysql is accessed, data retreived and translated.

I have tested only this configuration :

/etc/pam.d/smtp
auth       required     pam_nologin.so
auth       required     pam_mysql.so user=mailsql passwd=ebonzai02152006
host=localhost db=postfixdb_config table=mailbox usercolumn=username
passwdcolumn=password crypt=1
#auth       required     pam_unix.so
auth       required     pam_env.so # [1]

account    sufficient   pam_mysql.so user=mailsql passwd=xxxxxx host=localhost
db=postfixdb_config table=mailbox usercolumn=username passwdcolumn=password
crypt=1
account    required     pam_unix.so

No dump, No error message.
The parameter crypt put to 1 means using crypt function (see the README file)

Then, perhaps you can say it's ok for pĂ´rtage testing ?

Thanks,
   Cyrius




------- Comment #17 From Cyrius 2006-02-20 07:32:22 0000 -------
As i said, it works for me

------- Comment #18 From Cyrius 2006-02-20 07:38:06 0000 -------
0.6.2 version works too !

Cyrius

------- Comment #19 From Cyrius 2006-02-20 07:39:12 0000 -------
0.6.2 version works too !

cyrius

------- Comment #20 From Cyrius 2006-02-20 10:13:53 0000 -------
Hi,

To see the log generated by pam_mysql, switch the parameter verbose=1.

Then you will have in auth.log for an error (or message.log on very basic
install)this kind of log :

Feb 20 19:05:11 ebonzai saslauthd[27013]: pam_mysql - SELECT password FROM
mailbox WHERE username = 'toto@linogconsulting.org'
Feb 20 19:05:11 ebonzai saslauthd[27013]: pam_mysql - SELECT returned no
result.
Feb 20 19:05:11 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_check_passwd()
returning 1.
Feb 20 19:05:11 ebonzai saslauthd[27013]: pam_mysql - pam_sm_authenticate()
returning 10.
Feb 20 19:05:11 ebonzai saslauthd[27013]: DEBUG: auth_pam: pam_authenticate
failed: User not known to the underlying authentication module
Feb 20 19:05:11 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_release_ctx()
called.


And for a success :

Feb 20 19:11:46 ebonzai saslauthd[27013]: pam_mysql - SELECT password FROM
mailbox WHERE username = 'cyrius@linogconsulting.org'
Feb 20 19:11:46 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_sql_log()
called.
Feb 20 19:11:46 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_sql_log()
returning 0.
Feb 20 19:11:46 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_check_passwd()
returning 0.
Feb 20 19:11:46 ebonzai saslauthd[27013]: pam_mysql - pam_sm_authenticate()
returning 0.

Cyrius

------- Comment #21 From Cyrius 2006-02-20 10:25:01 0000 -------
Hi,

  For the sceptics men : Test with good user and bad password :
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - SELECT password FROM
mailbox WHERE username = 'cyrius@linogconsulting.org'
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_sql_log()
called.
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_sql_log()
returning 0.
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_check_passwd()
returning 6.
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - pam_sm_authenticate()
returning 7.
Feb 20 19:23:04 ebonzai saslauthd[27013]: DEBUG: auth_pam: pam_authenticate
failed: Authentication failure
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_release_ctx()
called.
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_destroy_ctx()
called.
Feb 20 19:23:04 ebonzai saslauthd[27013]: pam_mysql - pam_mysql_close_db()
called.
Feb 20 19:23:04 ebonzai saslauthd[27013]: do_auth         : auth failure:
[user=cyrius@linogconsulting.org] [service=smtp] [realm=linogconsulting.org]
[mech=pam] [reason=PAM auth error]

Cyrius

------- Comment #22 From Cyrius 2006-02-21 04:50:46 0000 -------
Hi,

I don't know what is the procedure. I have put this bugg as resolved/worksforme
but i don't know if it's the good way to do when i saw the three dependants
buggs still open. So, i will let the gentoo team decide.

regards,
   Cyrius

------- Comment #23 From Mike Green 2006-03-29 10:48:49 0000 -------
I installed using the 0.6.2 ebuild - authentication with md5 works for me. 
Thanks for the patches!  The only problem I noticed was that the configure
output indicates that sasl v1 headers are being used, v2 headers are actually
being used.

Any idea when this will be released, at least into ~x86?

------- Comment #24 From Cyrius 2006-04-07 14:05:05 0000 -------
(From update of attachment 80220 [details])
Contain absolute path

------- Comment #25 From Cyrius 2006-04-07 14:07:48 0000 -------
Created an attachment (id=84163) [details]
0.6.2 source code patch for sasl2 openssl integration

Having suppress absolute path

------- Comment #26 From Cyrius 2006-04-07 14:08:51 0000 -------
Created an attachment (id=84164) [details]
0.6.2 source code patch for linking with pam librairies

Having suppress absolute path

------- Comment #27 From Cyrius 2006-04-07 14:22:56 0000 -------
(From update of attachment 80222 [details])
It contains absolute path

------- Comment #28 From Cyrius 2006-04-07 14:24:49 0000 -------
Created an attachment (id=84168) [details]
0.7_rc1 source code patch for sasl2 openssl ipv6 integration

Having suppress absolute path

------- Comment #29 From Cyrius 2006-04-07 14:25:57 0000 -------
Created an attachment (id=84170) [details]
0.7_rc1 source code patch for linking with pam librairies

Having suppress absolute path

------- Comment #30 From Cyrius 2006-04-07 14:33:27 0000 -------
Hello Mike,

    Yes, thanks your apply, i saw there is a mistake into the patch part. I
have let the absolute path. Then in your patch.log, you will see that, in fact,
patches are not applied. I've corrected it and added the new corrected patches.

    It will be great if you could confirm the correction. 

    I have no idea on the ~x86 include date. I hope soon.

Regards,
    Cyrius


------- Comment #31 From Diego E. 'Flameeyes' Pettenò 2006-04-21 09:02:11 0000 -------
Marking dupe of the bump bug as it mostly requires a fresh support entirely.


*** This bug has been marked as a duplicate of 120842 ***

Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug