Hi all,
we are testing Koha (3.16.01) with openldap and have an error with
extended patron attributes.
DBD::mysql::st execute failed: Unknown column 'preflang' in 'field list'
at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 320, <DATA> line 522.
'preflang' is one of our extended attributes.
Mapping in koha-conf.xml is done.
intranet-error.log (with debug) shows all attribs and values from ldap
incuding the extended ones without failure.
When it comes to update the extended fields, the error shows up.
[Wed Jul 23 17:00:13 2014] [error] [client 192.168.56.1] [Wed Jul 23
17:00:13 2014] mainpage.pl: DBD::mysql::st execute failed: Unknown
column 'preflang' in 'field list' at /usr/share/koha/lib/C4/Auth_with
[Wed Jul 23 17:00:13 2014] [error] [client 192.168.56.1] [Wed Jul 23
17:00:13 2014] mainpage.pl: DBD::mysql::st execute failed: Unknown
column 'preflang' in 'field list' at /usr/share/koha/lib/C4/Auth_with
Can anybody help?
We patched Auth_with_ldap.pm a bit, because passwords in our ldap are
stored with MD5. Maybe it is useful for others.
Insert at the top:
use Digest::MD5 qw(md5_base64);
Search for this line:
my $cmpmesg = $db->compare( $userldapentry, attr=>'userpassword',
value => $password );
exchange with this one
my $cmpmesg = $db->compare( $userldapentry, attr=>'userpassword',
value => "{MD5}".md5_base64($password)."==" );
Regards
--
Heiko Weier Technische Universität Hamburg-Harburg
Fachreferent Bibliothek
Tel.: 040-42878-3449 Denickestr. 22
Fax.: 040-42878-2527 21073 Hamburg
WWW : http://www.tub.tu-harburg.de
PGP Key
http://www.tub.tu-harburg.de/ext/keys/Heiko_Weier_pub.asc
D8DF 3FFD 3910 AB1C 12D2 940B 65B6 2A73 524A 2C1E
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
