How to know Table name used with column names where user login & passwords are stored in KOHA.
Hi Would you please guide me how to know Table name used with column names where user login & passwords are stored. This is needed to configure Ezproxy authentication through Koha Also How much previlege may be given to access to Koha Database to a user My Koha Details Koha version: 3.12.02.000 OS version ('uname -a'): Linux library 2.6.32-5-amd64 #1 SMP Fri May 10 08:43:19 UTC 2013 x86_64 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (x86_64) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU Thank you Abdullah al-Modabber New Delhi http://library.sau.ac.in
Hello Abdullah, you will find all informations in the table 'borrowers', the fieldnames describes the information. The user password in the field 'password' is encrypted. I hope this is usefull for you. Greetings Sebastian Am Dienstag, 11. November 2014, 23:18:48 schrieb Abdullah Al-Modabber:
Hi
Would you please guide me how to know
Table name used with column names where user login & passwords are stored.
This is needed to configure Ezproxy authentication through Koha
Also How much previlege may be given to access to Koha Database to a user
My Koha Details
Koha version: 3.12.02.000 OS version ('uname -a'): Linux library 2.6.32-5-amd64 #1 SMP Fri May 10 08:43:19 UTC 2013 x86_64 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .
MySQL version: mysql Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (x86_64) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU
Thank you
Abdullah al-Modabber New Delhi http://library.sau.ac.in _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- mailto: sebastian.krieg@tuz-eisenach.de
Abdullah Al-Modabber schreef op di 11-11-2014 om 23:18 [-0800]:
Table name used with column names where user login & passwords are stored.
This is needed to configure Ezproxy authentication through Koha
It's not very likely that ezproxy can handle Koha's encrypted password storage directly, especially as you may have two schemes in simultaneous use depending on the age of your system. I think ezproxy can authenticate by SIP2 though, perhaps that should be used instead. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Hi, On Wed, Nov 12, 2014 at 2:28 PM, Robin Sheat <robin@catalyst.net.nz> wrote:
I think ezproxy can authenticate by SIP2 though, perhaps that should be used instead.
Indeed, it can use SIP2. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
participants (4)
-
Abdullah Al-Modabber -
Galen Charlton -
Robin Sheat -
Sebastian Krieg