Hi Luca,
1. You can use any attribute you want, but you need to use the right string
description (maybe the SQL field with the table name according to the
metadata sent back by the SQL engine)
2. Yes, but you need to add the support for log4j-over-slf4j so that iBatis
can log through the existing logging api :
Add the following dependency to LSC pom.xml and rebuild :
</dependency>
<groupId>org.slf4j</groupId>
<artifactId>log4j-over-slf4j</artifactId>
<version>1.6.2</version>
</dependency>
Then modify logback.xml to log all the com.ibatis.* messages :
<logger name="com.ibatis" level="DEBUG">
<appender-ref ref="CONSOLE"/>
</logger>
Regards,
Le lundi 2 juillet 2012, Azzalini Luca a écrit :
> Hi Sebastien and everybody,
>
> I realized that my previous email was a little involved, but it
> basically boils down to two fundamental questions:
>
> 1. Is there any limitation on the attributes that I can choose as
> pivot? What I see is that using "mail" do work, while using
> "sAMAccountName" doesn't, but I dont' understand why.
> 2. How can I enable debug output of SQL generated by iBATIS?
>
> Thanks a lot for any help
> -Luca
>
>
>
>
> On 29/06/2012 15:58, Luca Azzalini wrote:
> > Hi Sebastien
> >
> > thanks a lot for your quick feedback.
> >
> > The configuration you suggested didn't work for me at first attempt. I
> > had to change:
> >
> > <mainIdentifier>"mail="+srcBean.getDatasetFirstValueById("mail") +
> > ",ou=People,dc=lsc-project,dc=org"</mainIdentifier>
> >
> > to
> >
> > <mainIdentifier>srcBean.getMainIdentifier()</mainIdentifier>
> >
> > With this modification, it works like a charm!
> >
> > However, using mail as the pivot attribute doesn't fit my needs. I
> > changed the configuration in order to use sAMAccountName, in a
> > consistently way. But after that I got the wrong behaviour I described
> > in my first email.
> >
> > Then I tried with pivot=cn and it works! But obviously cn cannot be
> > used in a real scenario.
> >
> > The other options left would be to use objectGUID or objectSid, but
> > I'm facing problem with those too (encoding related).
> >
> > I think I could debug the problems with sAMAccountName if I could see
> > the SQL generated by iBATIS. I tried to follow some instruction I
> > found in public forums (basically setting some log4j.properties file
> > in the classpath) but that didn't work.
> >
> > Do you have any clue on why using sAMAccountName gives these problems?
> > Can you tell me how to see the generated SQL?
> >
> > Thanks again!
> >
> > -Luca
> >
> >
> > ______________________________________________________________________
> > Disclaimer:This email and any attachments are sent in strictest
> > confidence for the sole use of the addressee and may contain legally
> > privileged, confidential, and proprietary data. If you are not the
> > intended recipient, please advise the sender by replying promptly to
> > this email and then delete and destroy this email and any attachments
> > without any further use, copying or forwarding
> > _______________________________________________________________
> > Ldap Synchronization Connector (LSC) - http://lsc-project.org
> >
> > lsc-users mailing list
> > [email protected] <javascript:;>
> > http://lists.lsc-project.org/listinfo/lsc-users
> >
>
>
>
> --
> *Luca Azzalini *| Senior Consultant | NTT DATA Italia
> Viale della Repubblica, 12, 31020 Villorba (TV) | Tel: +39 0422 2511 |
> Fax: +39 0422 251 251 | [email protected] <javascript:;> | Learn
> more at
> www.nttdata.com/it
>
> ______________________________________________________________________
> Disclaimer:This email and any attachments are sent in strictest confidence
> for the sole use of the addressee and may contain legally privileged,
> confidential, and proprietary data. If you are not the intended recipient,
> please advise the sender by replying promptly to this email and then delete
> and destroy this email and any attachments without any further use, copying
> or forwarding
> _______________________________________________________________
> Ldap Synchronization Connector (LSC) - http://lsc-project.org
>
> lsc-users mailing list
> [email protected] <javascript:;>
> http://lists.lsc-project.org/listinfo/lsc-users
>
--
Sebastien BAHLOUL
IAM / Security specialist
Ldap Synchronization Connector : http://lsc-project.org
Blog : http://sbahloul.wordpress.com/
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
