Package: gforge-ldap-openldap Version: 4.5.14-13 Severity: normal File: /usr/lib/gforge/bin/sql2ldif.pl Tags: patch
Hi Roland, previously, I think that user password were exported in the nss_passwd view. Currently, this is not the case, so that sql2ldif.pl doesn't get them. Please consider the attached patch, which gets the passwords from the nss_shadow view. Cheers, Julien -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (990, 'testing'), (500, 'unstable'), (500, 'stable'), (1, 'experimental') Architecture: sparc (sparc64) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.17-2-sparc64 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages gforge-ldap-openldap depends on: ii debconf [debconf-2.0] 1.5.5 Debian configuration management sy ii debianutils 2.17 Miscellaneous utilities specific t ii gforge-common 4.5.14-13 collaborative development tool - s ii gforge-db-postgresql [gforge- 4.5.14-13 collaborative development tool - d ii ldap-utils 2.3.27-1 OpenLDAP utilities ii libdbd-pg-perl 1.49-1 a PostgreSQL interface for Perl 5 ii libdbi-perl 1.52-1 Perl5 database interface by Tim Bu ii perl 5.8.8-6.1 Larry Wall's Practical Extraction ii slapd 2.3.27-1 OpenLDAP server (slapd) gforge-ldap-openldap recommends no packages.
--- sql2ldif.pl 2006-10-18 23:49:38.000000000 +0200 +++ sql2ldif.pl.new 2006-10-18 23:58:09.000000000 +0200 @@ -32,10 +32,10 @@ # We give user maximum of privileges assigned to one by groups ;-( my $query = " -SELECT nss_passwd.login,gecos,shell,passwd,uid,gid,email -FROM nss_passwd,mta_users -WHERE nss_passwd.login=mta_users.login -GROUP BY nss_passwd.login,gecos,shell,passwd,uid,gid,email +SELECT nss_passwd.login,gecos,shell,nss_shadow.passwd,uid,gid,email +FROM nss_passwd,nss_shadow,mta_users +WHERE nss_passwd.login=mta_users.login AND nss_passwd.login=nss_shadow.login +GROUP BY nss_passwd.login,gecos,shell,nss_shadow.passwd,uid,gid,email "; my $rel = $dbh->prepare($query); $rel->execute();
signature.asc
Description: Digital signature
