Turns out it was the {ldap_CaseTableNames} that did the trick. I'm kinda a
newbie to LDAP - is that LDAP specific or is that a function of your
extension to the DBI?
Thanks for your support!
Regards,
Dave
On Thu, Apr 17, 2008 at 11:39 PM, Jim Turner via RT <
bug-DBD-LDAP@rt.cpan.org> wrote:
>
> <URL:
http://rt.cpan.org/Ticket/Display.html?id=35045 >
>
> Hi, Thanks for using DBD::LDAP. I don't currently have access to a
> working LDAP server to test your configuration on, but looking at what
> you've got, try this:
>
> 1) Does your "top" table work? If so, try adding a "ldap_CaseTableNames
> => 1" to your ->connect() function - ie.
> DBI->connect("DBI:LDAP:ldapdb",'admin','<somepassword>',
> {ldap_CaseTableNames => 1})...
>
> 2) I'm now sure if my mail pgm wrapped your configuration file or not,
> but if not, you need to make sure that each "table" is defined on a single
> line.
>
> 3) I just looked at the old configuration file I used to use (where I
> used to work) and it looked like you should change your table line to look
> like this:
>
> Folks:ou=Users,
> :objectclass=inetOrgPerson:cn:cn,sn,ou,title,telephonenumber,description,objectclass,dn:objectclass=top|person|organizationalPerson:ldap_scope=>'sub'
>
> You might add this table line and try it as well:
>
> root:::cn
>
> See if any of these suggestions works for you.
>
> Jim Turner
>
> David Dulong via RT <bug-DBD-LDAP@rt.cpan.org> wrote:
> Mon Apr 14 21:59:23 2008: Request 35045 was acted upon.
> Transaction: Ticket created by djdulong
> Queue: DBD-LDAP
> Subject: No Such Table Bug
> Broken in: 0.09
> Severity: Important
> Owner: Nobody
> Requestors: djdulong@gmail.com
> Status: new
> Ticket
>
>
> There seems to be a bug when just trying to query a table.
>
> My setup is:
>
> OS: Windows Visa Home Premium
>
> This is perl, v5.10.0 built for MSWin32-x86-multi-thread
> (with 3 registered patches, see perl -V for more detail)
>
> Copyright 1987-2007, Larry Wall
>
> Binary build 1002 [283697] provided by ActiveState
>
http://www.ActiveState.com <
http://www.activestate.com/>
> Built Jan 10 2008 11:00:53
>
> Perl may be copied only under the terms of either the Artistic License
> or the
> GNU General Public License, which may be found in the Perl 5 source kit.
>
> Complete documentation for Perl, including FAQ lists, should be found on
> this system using "man perl" or "perldoc perl". If you have access to
> the
> Internet, point your browser at
http://www.perl.org/, the Perl Home
> Page.
> ======================
>
> LDAP Server is Novell eDirectory 8.8 on openSuSE 10 (2.6 kernel).
>
> ====================
>
> when I run the attached .PL script, here's the output (including my
> debug):
>
> 3
> Folks
> top
> Test
> DBD::LDAP::db prepare warning: at ldap.pl line 24, line 4.
>
> Oops! The following error occurred when processing your request:
>
> No such table. ()
>
> Here's some more information to help you:
>
> file: folks
> None
>
> DBD::LDAP::st execute failed: -524:No such table. at ldap.pl line 26,
> l
> ine 4.
> Cannot execute: -524:No such table. at ldap.pl line 26, line 4.
>
> I am reasonably sure my ldb file is correct based on the
> documentation. What other info can I provide you?
>
> Regards,
> Dave
>
> 10.0.1.50;389:o=home:cn=*,
> top:::o
> Test:ou=Users:(objectclass=*):cn:cn,sn,ou,title,telephonenumber,description,objectclass,dn:objectclass=top|person|organizationalPerson:
> ldap_scope => "sub"
> Folks:ou=Users:(objectclass=inetOrgPerson):cn:cn,sn,ou,title,telephonenumber,description,objectclass,dn:objectclass=top|person|organizationalPerson:
> ldap_scope => "sub"
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
> now.
>
> Hi, Thanks for using DBD::LDAP. I don't currently have access to a
> working LDAP server to test your configuration on, but looking at what
> you've got, try this:
>
> 1) Does your "top" table work? If so, try adding a "ldap_CaseTableNames
> => 1" to your ->connect() function - ie.
> DBI->connect("DBI:LDAP:ldapdb",'admin','<somepassword>',
> {ldap_CaseTableNames => 1})...
>
> 2) I'm now sure if my mail pgm wrapped your configuration file or not,
> but if not, you need to make sure that each "table" is defined on a single
> line.
>
> 3) I just looked at the old configuration file I used to use (where I
> used to work) and it looked like you should change your table line to look
> like this:
>
> Folks:ou=Users,
> :objectclass=inetOrgPerson:cn:cn,sn,ou,title,telephonenumber,description,objectclass,dn:objectclass=top|person|organizationalPerson:ldap_scope=>'sub'
>
> You might add this table line and try it as well:
>
> root:::cn
>
> See if any of these suggestions works for you.
>
> Jim Turner
>
> *David Dulong via RT <bug-DBD-LDAP@rt.cpan.org>* wrote:
>
>
> Mon Apr 14 21:59:23 2008: Request 35045 was acted upon.
> Transaction: Ticket created by djdulong
> Queue: DBD-LDAP
> Subject: No Such Table Bug
> Broken in: 0.09
> Severity: Important
> Owner: Nobody
> Requestors: djdulong@gmail.com
> Status: new
> Ticket
>
>
> There seems to be a bug when just trying to query a table.
>
> My setup is:
>
> OS: Windows Visa Home Premium
>
> This is perl, v5.10.0 built for MSWin32-x86-multi-thread
> (with 3 registered patches, see perl -V for more detail)
>
> Copyright 1987-2007, Larry Wall
>
> Binary build 1002 [283697] provided by ActiveState
>
http://www.ActiveState.com <
http://www.activestate.com/>
> Built Jan 10 2008 11:00:53
>
> Perl may be copied only under the terms of either the Artistic License
> or the
> GNU General Public License, which may be found in the Perl 5 source kit.
>
> Complete documentation for Perl, including FAQ lists, should be found on
> this system using "man perl" or "perldoc perl". If you have access to
> the
> Internet, point your browser at
http://www.perl.org/, the Perl Home
> Page.
> ======================
>
> LDAP Server is Novell eDirectory 8.8 on openSuSE 10 (2.6 kernel).
>
> ====================
>
> when I run the attached .PL script, here's the output (including my
> debug):
>
> 3
> Folks
> top
> Test
> DBD::LDAP::db prepare warning: at ldap.pl line 24, line 4.
>
> Oops! The following error occurred when processing your request:
>
> No such table. ()
>
> Here's some more information to help you:
>
> file: folks
> None
>
> DBD::LDAP::st execute failed: -524:No such table. at ldap.pl line 26,
> l
> ine 4.
> Cannot execute: -524:No such table. at ldap.pl line 26, line 4.
>
> I am reasonably sure my ldb file is correct based on the
> documentation. What other info can I provide you?
>
> Regards,
> Dave
>
> 10.0.1.50;389:o=home:cn=*,
> top:::o
> Test:ou=Users:(objectclass=*):cn:cn,sn,ou,title,telephonenumber,description,objectclass,dn:objectclass=top|person|organizationalPerson:
> ldap_scope => "sub"
> Folks:ou=Users:(objectclass=inetOrgPerson):cn:cn,sn,ou,title,telephonenumber,description,objectclass,dn:objectclass=top|person|organizationalPerson:
> ldap_scope => "sub"
>
>
> ------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
> now.<
http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>
>
>
>
