Re: [vchkpw] integrated qmail-vpopmail-mysql with squid-mysql,pureftp-mysql, samba-mysql
I've looked into this also, but I haven't gotten any further than the research phase. From what I've found, you might want to start with Samba+LDAP, and add qmail+ldap to that. OR, while looking for the samba+LDAP+PDC docs, I came across this at RedHat: http://rhems.sourceforge.net/rhldc.htm Interoperability between RHSD projects such as the RHSD Email Server and the RHSD Domain Controller will allow for use of Single-Sign On. RHSD also utilizes IETF Standardized projects and therefore will be compatible with any Directory system compatible with LDAP v.3. You might want to start there. (I just may revisit that myself sooner than later :) Rick On Wed, 2002-10-16 at 06:05, anton heryanto wrote: Hello all thanks for the open source project I'm campus network administrator and I try to implement single-sign on with auth backend using mysql database!!! I have searched server that we need that using mysql as auth module for *nix and windows desktop and found : mail server -- qmail + vpopmail+mysql ftp server -- pureftp + mysql proxy server -- squid+mysql domain logon \ file server samba +mysql -- only work for 2.0.x , 2.2.x still on progress (by Jelmer Vernooij) print server/ web server -- apache+mod_auth_mysql - but I have a difficulty, because each server use their own mysql database, table and password encryption, I want to that all server use same database and table and if could be use same password encryption method . first I want to combine mail+proxy using same database and other after that... so I using vpopmail database for squid_mysql to authenticate, thing that I need to ask is there anybody know how to read password from mysql database to fit on dialog box that given by browser username and password I have successes, but using vpopmail+ clear password, and I want to try using password that have encrypted So how read encrypted password that generate by vpopmail And for later I want to change vpopmail encryption method to use samba (NT) encryption In which part of source that I should to change. Sorry, for my bad English thanks for all of you attention and help Regards Anton :-)
Re: [vchkpw] integrated qmail-vpopmail-mysql with squid-mysql,pureftp-mysql,samba-mysql
Rick Romero wrote: On Wed, 2002-10-16 at 08:11, anton heryanto wrote: Rick Romero wrote: I'm sorry, I thought you were just looking for information on doing single sign-on. I have not attempted to do any of that yet. But you'll have to give more information than you have. How did you create your users? Samba? Vpopmail? i create user using vpasswd and qmailadmin and keep ini mysql database and i want to use this vpopmail database for squid mysql auth module i haven't implement samba+mysql --- :-) I'm not familiar with squid, but I'd do this: 1. make sure squid is using the same database/table as vpopmail 2. make sure squid is looking at the right columns for the username password. I believe, by default, the database is 'vpopmail', and the table is 'vpopmail'. The columns are setup as so: pw_name | pw_domain| pw_passwd | pw_uid | pw_gid | pw_gecos| pw_dir | pw_shell | pw_clear_passwd | I think it's pretty straight forward. Add the necessary squid columns to the vpopmail table, and tell squid to use pw_name and pw_clear_passwd to auth, if you can. i have do this, and i successes but ionly if i use the clear password and only username and password field, thing that I want to know is how to read vpopmail password encryption using mysql query :-) Your best resource for where to do that in Squid would be the Squid list.. But then, I would recommend also taking a look at what samba requires. You wouldn't want to spend time hacking up Squid auth, only to find that it doesn't work with Samba. (I would think Squid would be the easiest to integrate) yea, you right i have think it too, and next i want to vpopmail using samba (NT) encryption method, because it come from windows and cannot be change !! Please reply to the list, while I try to be helpful, I'm not necessarily knowledgeable, and peer review can hopefully correct any mistakes I may make (or give you a different road to follow). thank's a lot for you attention and advice (btw sorry my english very bad :-[ ) Rick snip