List Info

Thread: JDBC-cache sample
JDBC-cache sample
country flaguser name
United States		 2007-07-30 09:45:48 
I have been trying to run the jdbc-cache example from the
samples
directory. The cache creation tool isn't working, and as far
as I can
ascertain it appears to be a config issue.

As far as my back track goes, I started working through
Penrose, from
the top down. I am using the xml files straight from the
samples. The
only changes have been to connections.xml to point to my
database. I
have loaded the tables as per the sql scripts in those
directories.

Now tracing down, looking into source and source sync. The
issue is,
that its not finding any source-sync info. The whole reason
that the
cache tool doesn't work, is it doesn't find anything to
sync, so it
just exits (Gets as far as create ( CacheUtil.java ln 88),
and finds
the default partition, but then tries to find sourceSyncs
(ln 96), and
nothing is returned).

I started poking around, and I find line Sources.java ln 38.
Here is
trying to pull a parameter called "sync" from the
sourceConfig, but
never finds it. I started poking back trying to figure out
where it
loads the config for sources. I have found the
sources-digester-
rules.xml in partition. I see that there is no source-sync
section
like is present in the sources.xml. So I'm confused as to
how its ever
supposed to pick up sync.

The only thing I have noticed, is, if I add another entry
to
sources.xml like this:
<source name="users">
    <connection-name>MySQL</connection-name>
    <field name="username"
primaryKey="true"/>
    <field name="firstName"/>
    <field name="lastName"/>
    <field name="password"/>
    <parameter>
      <param-name>table</param-name>
      <param-value>users</param-value>
    </parameter>
  </source>


BUT change param-name from table to sync, it then picks up a
sync, but
still fails as its obviously wanting some other params. So
I'm very
confused... I hope you can clear this up.

Thanks
P.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "safehaus" group.
To post to this group, send email to safehausgooglegroups.com
To unsubscribe from this group, send email to
safehaus-unsubscribegooglegroups.com
For more options, visit this group at http://
groups.google.com/group/safehaus?hl=en
-~----------~----~----~----~------~----~------~--~---
Re: JDBC-cache sample
user name
 2007-07-30 13:18:57 

  


  

    
Paul,


&nbsp;


Apparently the jdbc_cache example is outdated, sorry about that. But before proceeding further I need to tell you what this example does. It basicaly replicates the data from a master source, presumably from a remote or slow system,&nbsp;into a cache database which is local and faster. This would be useful if you don't want to burden the master source with traffic from Penrose. If your master source is already fast enough and can handle Penrose traffic you probably don't need this.



 


It is also useful if you want to join serveral sources that don't support join operation natively, for example joining 2 ldap directories. This feature will replicate the entire content of your master sources into the cache database and perform the join operation there. If you want to join tables from the same RDBMS database you don't need this. Unlike the previous versions, Penrose 
1.2.x can perform the join operation on the database side.


&nbsp;


If that is what you want to do, here's how to set up the example:



 


1. Create a MySQL database called "example". This is the master database.


2. Run the create.sql included in the example under the sql folder to create the tables and triggers. If you are using a different database system, you need to modify the script for your database system.


3. Create a MySQL database called "jdbc". This is the cache database.


4. Add the following parameter in the "users" source (keep the original "table" parameter).


 


 &nbsp;  <parameter>
&nbsp; &nbsp; &nbsp; <param-name>sync</param-name>
&nbsp;   ;  <param-value>users_cache&lt;/param-value>
&nbsp; &nbsp; </parameter>


 &nbsp;  <parameter>
&nbsp; &nbsp; &nbsp; <param-name>changelog</param-name&gt;
 &nbsp;   ; <param-value>users_changelog</param-value>
 &nbsp;  </parameter>


 


These parameters tell Penrose to synchronize this source (i.e. users) with "users_cache&quot; source using the change log information stored in "users_changelog" table.&nbsp;You can do the same thing with the other sources if you want. You can remove the <source-sync> entries from 
sources.xml, they are no longer used.


5. Edit server.xml to install this partiiton.
6. Run this command to create the cache tables:


 


  ;  cache.bat -d create jdbc_cache


 


If it doesn't work with your database system, you can create the tables manually. See create-cache.sql.


7. To synchronize the cache, run:


&nbsp;


&nbsp; &nbsp; cache.bat -d sync jdbc_cache



You can use your own scheduler (e.g. cron) to run this command periodically.


8. Try to update the data in the master source, the changes should be picked up when you run the sync command.



 


Let me know if you have any questions.




-- 
Endi S. Dewata 




&nbsp;


On 7/30/07, Nuzz <identitysolutions.co.nz" target="_blank">paul.edwardsidentitysolutions.co.nz
> wrote: 


I have been trying to run the jdbc-cache example from the samples
directory. The cache creation tool isn't working, and as far as I can 

ascertain it appears to be a config issue.

As far as my back track goes, I started working through Penrose, from
the top down. I am using the xml files straight from the samples. The
only changes have been to 
connections.xml to point to my database. I
have loaded the tables as per the sql scripts in those directories.

Now tracing down, looking into source and source sync. The issue is,
that its not finding any source-sync info. The whole reason that the 

cache tool doesn't work, is it doesn't find anything to sync, so it
just exits (Gets as far as create ( CacheUtil.java ln 88), and finds
the default partition, but then tries to find sourceSyncs (ln 96), and 

nothing is returned).

I started poking around, and I find line Sources.java ln 38. Here is
trying to pull a parameter called "sync" from the sourceConfig, but
never finds it. I started poking back trying to figure out where it 

loads the config for sources. I have found the sources-digester-
rules.xml in partition. I see that there is no source-sync section
like is present in the sources.xml. So I'm confused as to how its ever
supposed to pick up sync. 


The only thing I have noticed, is, if I add another entry to
sources.xml like this:
<source name=";users";>
 ;  <connection-name&gt;MySQL</connection-name>
&nbsp;  <field name=";username&quot; primaryKey="true"/> 

 &nbsp; <field name=";firstName&quot;/>
  ; <field name=";lastName&quot;/>
&nbsp;  <field name=";password&quot;/>
&nbsp;  <parameter>
&nbsp; &nbsp;  <param-name>table</param-name>

 &nbsp; &nbsp; <param-value>users</param-value>;
 &nbsp; </parameter>
&lt;/source&gt;


BUT change param-name from table to sync, it then picks up a sync, but
still fails as its obviously wanting some other params. So I'm very 

confused... I hope you can clear this up.

Thanks
P.


--~--~---------~--~----~------------~-------~--~----~

You received this message because you are subscribed to the Google Groups "safehaus" group. 
 To post to this group, send email to safehausgooglegroups.com 
 To unsubscribe from this group, send email to safehaus-unsubscribegooglegroups.com 
 For more options, visit this group at http://groups.google.com/group/safehaus?hl=en 
 -~----------~----~----~----~------~----~------~--~---





  

  
  
   
     
    

  

    Re: JDBC-cache sample
  


  

     country flaguser name
United States		
     2007-07-31 09:58:17
  


  

    
Endi,

That worked great. I have the system up.

However I'm trying to do a bit of load testing with slamd.
Now, when I
try to connect with slamd, penrose seems to not like the
default
filter that slamd is supplying (I cannot see a way at the mo
of
changing what slamd is supplying - without recompiling
slamd). As far
as I'm aware, what slamd is supplying is correct ldap
syntax. I
believe that the filter slamd is supplying on connect is:
(|
(objectclass=*)(objectclass=ldapsubentry)), which by my way
of
thinking seems a bit stupid, as it should just take the
objectclass=*
for all, but it appears that penrose is getting rid of the
objectclass=*, and then it all fails.  Anyway heres what I'm
seeing:

[07/31/2007 10:46:29 DEBUG (PenroseSession.java:114)]
bind("uid=admin,ou=system", "secret")
[07/31/2007 10:46:29 WARN  (Session.java:242)] Bind
"uid=admin,ou=system".
[07/31/2007 10:46:29 DEBUG (Session.java:248)]
------------------------------------------------------------
----------------------
[07/31/2007 10:46:29 DEBUG (Session.java:249)] BIND:
[07/31/2007 10:46:29 DEBUG (Session.java:250)]  - Bind DN   
   :
uid=admin,ou=system
[07/31/2007 10:46:29 DEBUG (Session.java:251)]  - Bind
Password :
secret
[07/31/2007 10:46:29 DEBUG (Session.java:252)]
[07/31/2007 10:46:29 DEBUG (Session.java:254)] Controls: []
[07/31/2007 10:46:29 DEBUG (EventManager.java:86)] Firing
BeforeBind
event.
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:209)]
Comparing
passwords:
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:242)]
Supplied
[secret]
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:243)] Stored
[secret]
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:247)] Result:
true
[07/31/2007 10:46:29 DEBUG (Session.java:283)] Bound as root
user.
[07/31/2007 10:46:29 DEBUG (EventManager.java:86)] Firing
AfterBind
event.
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)]
Converting
filter: OR
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.BranchNode
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)]
Converting
filter: (objectclass=*)
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.PresenceNode
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)]
Converting
filter: (objectclass=ldapsubentry)
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.SimpleNode
[07/31/2007 10:46:29 DEBUG (FilterParser.java:223)] Parsing
filter
"objectclass=*"
[07/31/2007 10:46:29 DEBUG (FilterParser.java:237)] Filter:
[objectclass] [=] [*]
[07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed
filter:
null
[07/31/2007 10:46:29 DEBUG (FilterParser.java:223)] Parsing
filter
"objectclass=ldapsubentry"
[07/31/2007 10:46:29 DEBUG (FilterParser.java:237)] Filter:
[objectclass] [=] [ldapsubentry]
[07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed
filter:
(objectclass=ldapsubentry)
[07/31/2007 10:46:29 DEBUG (PenroseSession.java:269)]
search("ou=Users,dc=JDBC Cache,dc=Example,dc=com",
"(|
(objectclass=ldapsubentry))")
[07/31/2007 10:46:29 WARN  (Session.java:757)] Search
"ou=Users,dc=JDBC Cache,dc=Example,dc=com" with
scope base and filter
"(|(objectclass=ldapsubentry))"
[07/31/2007 10:46:29 DEBUG (Session.java:763)]
------------------------------------------------------------
----------------------
[07/31/2007 10:46:29 DEBUG (Session.java:764)] SEARCH:
[07/31/2007 10:46:29 DEBUG (Session.java:765)]  - Bind DN   
:
uid=admin,ou=system
[07/31/2007 10:46:29 DEBUG (Session.java:766)]  - Base DN   
:
ou=Users,dc=JDBC Cache,dc=Example,dc=com
[07/31/2007 10:46:29 DEBUG (Session.java:767)]  - Scope     
: base
[07/31/2007 10:46:29 DEBUG (Session.java:768)]  - Filter    
: (|
(objectclass=ldapsubentry))
[07/31/2007 10:46:29 DEBUG (Session.java:769)]  - Attributes
: [1.1]
[07/31/2007 10:46:30 DEBUG (Session.java:770)]
[07/31/2007 10:46:30 DEBUG (Session.java:772)] Controls: []
[07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing
BeforeSearch event.
[07/31/2007 10:46:30 DEBUG (HandlerManager.java:419)]
Requested: [1.1]
[07/31/2007 10:46:30 DEBUG (HandlerManager.java:485)]
Searching
ou=Users,dc=JDBC Cache,dc=Example,dc=com in
ou=Users,dc=JDBC
Cache,dc=Example,dc=com
[07/31/2007 10:46:30 DEBUG (ACLManager.java:167)] Checking
object "s"
permission
[07/31/2007 10:46:30 DEBUG (ACLManager.java:176)] Root user
=> SUCCESS
[07/31/2007 10:46:30 DEBUG (DefaultHandler.java:234)]
Searching
ou=Users,dc=JDBC Cache,dc=Example,dc=com with scope base
[07/31/2007 10:46:30 DEBUG (DefaultHandler.java:240)] Entry
"ou=Users,dc=JDBC Cache,dc=Example,dc=com" doesn't
match search
filter.
[07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:120)]
All
search threads have ended.
[07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:146)]
Found
successes: true
[07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing
AfterSearch
event.
[07/31/2007 10:46:30 DEBUG (PenroseSession.java:294)]
unbind()

On Jul 30, 2:18 pm, "Endi Sukma Dewata"
<end...gmail.com> wrote:
> Paul,
>
> Apparently the jdbc_cache example is outdated, sorry
about that. But before
> proceeding further I need to tell you what this example
does. It basicaly
> replicates the data from a master source, presumably
from a remote or slow
> system, into a cache database which is local and
faster. This would be
> useful if you don't want to burden the master source
with traffic from
> Penrose. If your master source is already fast enough
and can handle Penrose
> traffic you probably don't need this.
>
> It is also useful if you want to join serveral sources
that don't support
> join operation natively, for example joining 2 ldap
directories. This
> feature will replicate the entire content of your
master sources into the
> cache database and perform the join operation there. If
you want to join
> tables from the same RDBMS database you don't need
this. Unlike the previous
> versions, Penrose 1.2.x can perform the join operation
on the database side.
>
> If that is what you want to do, here's how to set up
the example:
>
> 1. Create a MySQL database called "example".
This is the master database.
> 2. Run the create.sql included in the example under the
sql folder to create
> the tables and triggers. If you are using a different
database system, you
> need to modify the script for your database system.
> 3. Create a MySQL database called "jdbc".
This is the cache database.
> 4. Add the following parameter in the "users"
source (keep the original
> "table" parameter).
>
>     <parameter>
>       <param-name>sync</param-name>
>      
<param-value>users_cache</param-value>
>     </parameter>
>     <parameter>
>       <param-name>changelog</param-name>
>      
<param-value>users_changelog</param-value>
>     </parameter>
>
> These parameters tell Penrose to synchronize this
source (i.e. users) with
> "users_cache" source using the change log
information stored in
> "users_changelog" table. You can do the same
thing with the other sources if
> you want. You can remove the <source-sync>
entries from sources.xml, they
> are no longer used.
> 5. Edit server.xml to install this partiiton.
> 6. Run this command to create the cache tables:
>
>     cache.bat -d create jdbc_cache
>
> If it doesn't work with your database system, you can
create the tables
> manually. See create-cache.sql.
> 7. To synchronize the cache, run:
>
>     cache.bat -d sync jdbc_cache
>
> You can use your own scheduler (e.g. cron) to run this
command periodically.
> 8. Try to update the data in the master source, the
changes should be picked
> up when you run the sync command.
>
> Let me know if you have any questions.
>
> --
> Endi S. Dewata
>
> On 7/30/07, Nuzz <paul.edwa...identitysolutions.co.nz>
wrote:
>
>
>
> > I have been trying to run the jdbc-cache example
from the samples
> > directory. The cache creation tool isn't working,
and as far as I can
> > ascertain it appears to be a config issue.
>
> > As far as my back track goes, I started working
through Penrose, from
> > the top down. I am using the xml files straight
from the samples. The
> > only changes have been to connections.xml to point
to my database. I
> > have loaded the tables as per the sql scripts in
those directories.
>
> > Now tracing down, looking into source and source
sync. The issue is,
> > that its not finding any source-sync info. The
whole reason that the
> > cache tool doesn't work, is it doesn't find
anything to sync, so it
> > just exits (Gets as far as create ( CacheUtil.java
ln 88), and finds
> > the default partition, but then tries to find
sourceSyncs (ln 96), and
> > nothing is returned).
>
> > I started poking around, and I find line
Sources.java ln 38. Here is
> > trying to pull a parameter called "sync"
from the sourceConfig, but
> > never finds it. I started poking back trying to
figure out where it
> > loads the config for sources. I have found the
sources-digester-
> > rules.xml in partition. I see that there is no
source-sync section
> > like is present in the sources.xml. So I'm
confused as to how its ever
> > supposed to pick up sync.
>
> > The only thing I have noticed, is, if I add
another entry to
> > sources.xml like this:
> > <source name="users">
> >   
<connection-name>MySQL</connection-name>
> >    <field name="username"
primaryKey="true"/>
> >    <field name="firstName"/>
> >    <field name="lastName"/>
> >    <field name="password"/>
> >    <parameter>
> >      <param-name>table</param-name>
> >      <param-value>users</param-value>
> >    </parameter>
> > </source>
>
> > BUT change param-name from table to sync, it then
picks up a sync, but
> > still fails as its obviously wanting some other
params. So I'm very
> > confused... I hope you can clear this up.
>
> > Thanks
> > P.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "safehaus" group.
To post to this group, send email to safehausgooglegroups.com
To unsubscribe from this group, send email to
safehaus-unsubscribegooglegroups.com
For more options, visit this group at http://
groups.google.com/group/safehaus?hl=en
-~----------~----~----~----~------~----~------~--~---




  


  

    
  

  
  
   
     
    

  

    Re: JDBC-cache sample
  


  

     user name

     2007-07-31 11:57:04
  


  

    

  


  

    
Paul,


&nbsp;


Please try replacing lib/penrose-server-1.2.4.jar with this:



 



Btw, in modules.xml there's already a module configured to synchronize the sources every 30 seconds. You can just use this instead of cron.



-- 
Endi S. Dewata 



 ;


On 7/31/07, Nuzz < paul.edwardsidentitysolutions.co.nz">paul.edwardsidentitysolutions.co.nz> wrote:


Endi,

That worked great. I have the system up.

However I'm trying to do a bit of load testing with slamd. Now, when I

try to connect with slamd, penrose seems to not like the default
filter that slamd is supplying (I cannot see a way at the mo of
changing what slamd is supplying - without recompiling slamd). As far
as I'm aware, what slamd is supplying is correct ldap syntax. I

believe that the filter slamd is supplying on connect is: (|
(objectclass=*)(objectclass=ldapsubentry)), which by my way of
thinking seems a bit stupid, as it should just take the objectclass=*
for all, but it appears that penrose is getting rid of the

objectclass=*, and then it all fails.&nbsp; Anyway heres what I'm seeing:

[07/31/2007 10:46:29 DEBUG (PenroseSession.java:114)]
bind("uid=admin,ou=system", "secret")
[07/31/2007 10:46:29 WARN  (
Session.java:242)] Bind
";uid=admin,ou=system&quot;.
[07/31/2007 10:46:29 DEBUG (Session.java:248)]
----------------------------------------------------------------------------------
[07/31/2007 10:46:29 DEBUG (
Session.java:249)] BIND:
[07/31/2007 10:46:29 DEBUG (Session.java:250)]&nbsp; - Bind DN &nbsp; &nbsp;   :
uid=admin,ou=system
[07/31/2007 10:46:29 DEBUG (Session.java:251)]&nbsp; - Bind Password :
secret
[07/31/2007 10:46:29 DEBUG (
Session.java:252)]
[07/31/2007 10:46:29 DEBUG (Session.java:254)] Controls: []
[07/31/2007 10:46:29 DEBUG (EventManager.java:86)] Firing BeforeBind
event.
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:209)] Comparing


passwords:
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:242)] Supplied
[secret]
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:243)] Stored
[secret]
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:247)] Result: true

[07/31/2007 10:46:29 DEBUG (Session.java:283)] Bound as root user.
[07/31/2007 10:46:29 DEBUG (EventManager.java:86)] Firing AfterBind
event.
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)] Converting

filter: OR
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.BranchNode
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)] Converting
filter: (objectclass=*)

[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.PresenceNode
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)] Converting
filter: (objectclass=ldapsubentry)

[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.SimpleNode
[07/31/2007 10:46:29 DEBUG (FilterParser.java:223)] Parsing filter
&quot;objectclass=*"
[07/31/2007 10:46:29 DEBUG (
FilterParser.java:237)] Filter:
[objectclass] [=] [*]
[07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed filter:
null
[07/31/2007 10:46:29 DEBUG (FilterParser.java:223)] Parsing filter
&quot;objectclass=ldapsubentry"

[07/31/2007 10:46:29 DEBUG (FilterParser.java:237)] Filter:
[objectclass] [=] [ldapsubentry]
[07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed filter:
(objectclass=ldapsubentry)
[07/31/2007 10:46:29 DEBUG (
PenroseSession.java:269)]
search("ou=Users,dc=JDBC Cache,dc=Example,dc=com", "(|
(objectclass=ldapsubentry))")
[07/31/2007 10:46:29 WARN  (Session.java:757)] Search
&quot;ou=Users,dc=JDBC Cache,dc=Example,dc=com" with scope base and filter

&quot;(|(objectclass=ldapsubentry))"
[07/31/2007 10:46:29 DEBUG (Session.java:763)]
----------------------------------------------------------------------------------
[07/31/2007 10:46:29 DEBUG (Session.java
:764)] SEARCH:
[07/31/2007 10:46:29 DEBUG (Session.java:765)]&nbsp; - Bind DN &nbsp; &nbsp;:
uid=admin,ou=system
[07/31/2007 10:46:29 DEBUG (Session.java:766)]&nbsp; - Base DN &nbsp; &nbsp;:
ou=Users,dc=JDBC Cache,dc=Example,dc=com
[07/31/2007 10:46:29 DEBUG (
Session.java:767)]  ;- Scope ; &nbsp; &nbsp; : base
[07/31/2007 10:46:29 DEBUG (Session.java:768)]&nbsp; - Filter&nbsp; &nbsp;  : (|
(objectclass=ldapsubentry))
[07/31/2007 10:46:29 DEBUG (Session.java:769)]&nbsp; - Attributes : [1.1]
[07/31/2007 10:46:30 DEBUG (
Session.java:770)]
[07/31/2007 10:46:30 DEBUG (Session.java:772)] Controls: []
[07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing
BeforeSearch event.
[07/31/2007 10:46:30 DEBUG (HandlerManager.java:419)] Requested: [
1.1]
[07/31/2007 10:46:30 DEBUG (HandlerManager.java:485)] Searching
ou=Users,dc=JDBC Cache,dc=Example,dc=com in ou=Users,dc=JDBC
Cache,dc=Example,dc=com
[07/31/2007 10:46:30 DEBUG (ACLManager.java:167)] Checking object "s&quot;

permission
[07/31/2007 10:46:30 DEBUG (ACLManager.java:176)] Root user => SUCCESS
[07/31/2007 10:46:30 DEBUG (DefaultHandler.java:234)] Searching
ou=Users,dc=JDBC Cache,dc=Example,dc=com with scope base

[07/31/2007 10:46:30 DEBUG (DefaultHandler.java:240)] Entry
&quot;ou=Users,dc=JDBC Cache,dc=Example,dc=com" doesn't match search
filter.
[07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:120)] All

search threads have ended.
[07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:146)] Found
successes: true
[07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing AfterSearch
event.
[07/31/2007 10:46:30 DEBUG (
PenroseSession.java:294)] unbind()

On Jul 30, 2:18 pm, "Endi Sukma Dewata&quot; < end...gmail.com">end...gmail.com> wrote:
>; Paul,
>
> Apparently the jdbc_cache example is outdated, sorry about that. But before

&gt; proceeding further I need to tell you what this example does. It basicaly
&gt; replicates the data from a master source, presumably from a remote or slow
> system, into a cache database which is local and faster. This would be

> useful if you don't want to burden the master source with traffic from
> Penrose. If your master source is already fast enough and can handle Penrose
&gt; traffic you probably don't need this.

&gt;
> It is also useful if you want to join serveral sources that don't support
&gt; join operation natively, for example joining 2 ldap directories. This
> feature will replicate the entire content of your master sources into the

> cache database and perform the join operation there. If you want to join
> tables from the same RDBMS database you don't need this. Unlike the previous
&gt; versions, Penrose 1.2.x can perform the join operation on the database side.

&gt;
> If that is what you want to do, here's how to set up the example:
&gt;
> 1. Create a MySQL database called "example". This is the master database.
> 2. Run the create.sql included in the example under the sql folder to create

&gt; the tables and triggers. If you are using a different database system, you
> need to modify the script for your database system.
&gt; 3. Create a MySQL database called "jdbc". This is the cache database.


> 4. Add the following parameter in the "users" source (keep the original
&gt; "table" parameter).
>
>  ; &nbsp; <parameter>
>; &nbsp; &nbsp; &nbsp; <param-name>sync</param-name>

>   ; &nbsp;  <param-value>users_cache&lt;/param-value>
>; &nbsp; &nbsp; </parameter>
&gt; &nbsp; &nbsp; <parameter>
>; &nbsp; &nbsp; &nbsp; <param-name>changelog</param-name&gt;
>&nbsp; &nbsp; &nbsp;  <param-value>users_changelog</param-value>

>&nbsp; &nbsp;  </parameter>
&gt;
> These parameters tell Penrose to synchronize this source (i.e. users) with
> "users_cache&quot; source using the change log information stored in
> "users_changelog" table. You can do the same thing with the other sources if

> you want. You can remove the <source-sync> entries from sources.xml, they
> are no longer used.
> 5. Edit server.xml to install this partiiton.
> 6. Run this command to create the cache tables:

>
>&nbsp; &nbsp;  cache.bat -d create jdbc_cache
>
> If it doesn't work with your database system, you can create the tables
>; manually. See create-cache.sql.
>; 7. To synchronize the cache, run:

>;
> ; &nbsp;  cache.bat -d sync jdbc_cache
>
> You can use your own scheduler (e.g. cron) to run this command periodically.
> 8. Try to update the data in the master source, the changes should be picked

&gt; up when you run the sync command.
&gt;
> Let me know if you have any questions.
>
> --
> Endi S. Dewata
>;
> On 7/30/07, Nuzz < paul.edwa...identitysolutions.co.nz">
paul.edwa...identitysolutions.co.nz> wrote:
>;
>
>
> > I have been trying to run the jdbc-cache example from the samples
&gt; > directory. The cache creation tool isn't working, and as far as I can

> > ascertain it appears to be a config issue.
>;
> > As far as my back track goes, I started working through Penrose, from
> > the top down. I am using the xml files straight from the samples. The

> > only changes have been to connections.xml to point to my database. I
> > have loaded the tables as per the sql scripts in those directories.
>
>; > Now tracing down, looking into source and source sync. The issue is,

> > that its not finding any source-sync info. The whole reason that the
> > cache tool doesn't work, is it doesn't find anything to sync, so it
> > just exits (Gets as far as create ( 
CacheUtil.java ln 88), and finds
> > the default partition, but then tries to find sourceSyncs (ln 96), and
> > nothing is returned).
>
> > I started poking around, and I find line Sources.java
 ln 38. Here is
> > trying to pull a parameter called "sync" from the sourceConfig, but
> > never finds it. I started poking back trying to figure out where it
> > loads the config for sources. I have found the sources-digester-

&gt; > rules.xml in partition. I see that there is no source-sync section
&gt; > like is present in the sources.xml. So I'm confused as to how its ever
> > supposed to pick up sync.
>
> > The only thing I have noticed, is, if I add another entry to

> > sources.xml like this:
> > <source name=";users";>
> >   ; <connection-name>MySQL</connection-name>
> >   ; <field name=";username&quot; primaryKey="true"/>

> >   ; <field name=";firstName&quot;/>
> >   ; <field name=";lastName&quot;/>
&gt; >   ; <field name=";password&quot;/>
&gt; >   ; <parameter&gt;
> >   ; &nbsp; <;param-name>table&lt;/param-name>

&gt; >   ; &nbsp; <;param-value>users&lt;/param-value>
&gt; >   ; </parameter&gt;
> > </source>
>
> > BUT change param-name from table to sync, it then picks up a sync, but

> > still fails as its obviously wanting some other params. So I'm very
> > confused... I hope you can clear this up.
>
&gt; > Thanks
>; > P.


--~--~---------~--~----~------------~-------~--~----~

You received this message because you are subscribed to the Google Groups "safehaus" group. 
 To post to this group, send email to safehausgooglegroups.com 
 To unsubscribe from this group, send email to safehaus-unsubscribegooglegroups.com 
 For more options, visit this group at http://groups.google.com/group/safehaus?hl=en 
 -~----------~----~----~----~------~----~------~--~---





  

  
  
   
     
    

  

    Re: JDBC-cache sample
  


  

     user name

     2007-07-31 13:38:49
  


  

    

  


  

    
Paul,


&nbsp;


If you want to test for speed, you might want to try using the simple handler, provided your mapping configuration meets the requirement. See this page:




 


To configure simple handler, add the following in server.xml:


 


<handler name=";SIMPLE&quot;>
&nbsp; <handler-class>org.safehaus.penrose.handler.simple.SimpleHandler</handler-class>
</handler>
 


Then edit your partition:


 


<partition name="jdbc_cache"; path="partitions/jdbc_cache";>
&nbsp; <handler-name>SIMPLE</handler-name>
</partition>;


-- 
Endi S. Dewata



 


On 7/31/07, Endi Sukma Dewata < endisdgmail.com">endisdgmail.com> wrote:



Paul,



 


Please try replacing lib/penrose-server-1.2.4.jar with this:



 


Btw, in modules.xml there's already a module configured to synchronize the sources every 30 seconds. You can just use this instead of cron.



-- 
Endi S. Dewata 





 


On 7/31/07, Nuzz <identitysolutions.co.nz" target="_blank">paul.edwardsidentitysolutions.co.nz
> wrote: 


Endi,

That worked great. I have the system up.

However I'm trying to do a bit of load testing with slamd. Now, when I 

try to connect with slamd, penrose seems to not like the default
filter that slamd is supplying (I cannot see a way at the mo of
changing what slamd is supplying - without recompiling slamd). As far
as I'm aware, what slamd is supplying is correct ldap syntax. I 

believe that the filter slamd is supplying on connect is: (|
(objectclass=*)(objectclass=ldapsubentry)), which by my way of
thinking seems a bit stupid, as it should just take the objectclass=*
for all, but it appears that penrose is getting rid of the 

objectclass=*, and then it all fails.&nbsp; Anyway heres what I'm seeing:

[07/31/2007 10:46:29 DEBUG (PenroseSession.java:114)]
bind("uid=admin,ou=system", "secret")
[07/31/2007 10:46:29 WARN  ( 
Session.java:242)] Bind
";uid=admin,ou=system&quot;.
[07/31/2007 10:46:29 DEBUG (Session.java:248)]
----------------------------------------------------------------------------------
[07/31/2007 10:46:29 DEBUG ( 
Session.java:249)] BIND:
[07/31/2007 10:46:29 DEBUG (Session.java:250)]&nbsp; - Bind DN &nbsp; &nbsp;   :
uid=admin,ou=system
[07/31/2007 10:46:29 DEBUG (Session.java:251)]&nbsp; - Bind Password :
secret
[07/31/2007 10:46:29 DEBUG ( 
Session.java:252)]
[07/31/2007 10:46:29 DEBUG (Session.java:254)] Controls: []
[07/31/2007 10:46:29 DEBUG (EventManager.java:86)] Firing BeforeBind
event.
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:209)] Comparing 

passwords:
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:242)] Supplied
[secret]
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:243)] Stored
[secret]
[07/31/2007 10:46:29 DEBUG (PasswordUtil.java:247)] Result: true 

[07/31/2007 10:46:29 DEBUG (Session.java:283)] Bound as root user.
[07/31/2007 10:46:29 DEBUG (EventManager.java:86)] Firing AfterBind
event.
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)] Converting

filter: OR
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.BranchNode
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)] Converting
filter: (objectclass=*) 

[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.PresenceNode
[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)] Converting
filter: (objectclass=ldapsubentry) 

[07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.SimpleNode
[07/31/2007 10:46:29 DEBUG (FilterParser.java:223)] Parsing filter
&quot;objectclass=*"
[07/31/2007 10:46:29 DEBUG ( 
FilterParser.java:237)] Filter:
[objectclass] [=] [*]
[07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed filter:
null
[07/31/2007 10:46:29 DEBUG (FilterParser.java:223)] Parsing filter
&quot;objectclass=ldapsubentry" 

[07/31/2007 10:46:29 DEBUG (FilterParser.java:237)] Filter:
[objectclass] [=] [ldapsubentry]
[07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed filter:
(objectclass=ldapsubentry)
[07/31/2007 10:46:29 DEBUG ( 
PenroseSession.java:269)]
search("ou=Users,dc=JDBC Cache,dc=Example,dc=com", "(|
(objectclass=ldapsubentry))")
[07/31/2007 10:46:29 WARN  (Session.java:757)] Search
&quot;ou=Users,dc=JDBC Cache,dc=Example,dc=com" with scope base and filter 

"(|(objectclass=ldapsubentry))";
[07/31/2007 10:46:29 DEBUG (Session.java:763)]
----------------------------------------------------------------------------------
[07/31/2007 10:46:29 DEBUG (Session.java
 :764)] SEARCH:
[07/31/2007 10:46:29 DEBUG (Session.java:765)]&nbsp; - Bind DN &nbsp; &nbsp;:
uid=admin,ou=system
[07/31/2007 10:46:29 DEBUG (Session.java:766)]&nbsp; - Base DN &nbsp; &nbsp;:
ou=Users,dc=JDBC Cache,dc=Example,dc=com
[07/31/2007 10:46:29 DEBUG ( 
Session.java:767)]&nbsp; - Scope ; &nbsp; &nbsp; : base
[07/31/2007 10:46:29 DEBUG (Session.java:768)]&nbsp; - Filter&nbsp; &nbsp;  : (|
(objectclass=ldapsubentry))
[07/31/2007 10:46:29 DEBUG (Session.java:769)]&nbsp; - Attributes : [1.1]
[07/31/2007 10:46:30 DEBUG ( 
Session.java:770)]
[07/31/2007 10:46:30 DEBUG (Session.java:772)] Controls: []
[07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing
BeforeSearch event.
[07/31/2007 10:46:30 DEBUG (HandlerManager.java:419)] Requested: [ 
1.1]
[07/31/2007 10:46:30 DEBUG (HandlerManager.java:485)] Searching
ou=Users,dc=JDBC Cache,dc=Example,dc=com in ou=Users,dc=JDBC
Cache,dc=Example,dc=com
[07/31/2007 10:46:30 DEBUG (ACLManager.java:167)] Checking object "s&quot; 

permission
[07/31/2007 10:46:30 DEBUG (ACLManager.java:176)] Root user => SUCCESS
[07/31/2007 10:46:30 DEBUG (DefaultHandler.java:234)] Searching
ou=Users,dc=JDBC Cache,dc=Example,dc=com with scope base

[07/31/2007 10:46:30 DEBUG (DefaultHandler.java:240)] Entry
&quot;ou=Users,dc=JDBC Cache,dc=Example,dc=com" doesn't match search
filter.
[07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:120)] All

search threads have ended.
[07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:146)] Found
successes: true
[07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing AfterSearch
event.
[07/31/2007 10:46:30 DEBUG ( 
PenroseSession.java:294)] unbind()

On Jul 30, 2:18 pm, "Endi Sukma Dewata&quot; <gmail.com" target="_blank">end...gmail.com
> wrote:
>; Paul,
>
> Apparently the jdbc_cache example is outdated, sorry about that. But before 
> proceeding further I need to tell you what this example does. It basicaly
&gt; replicates the data from a master source, presumably from a remote or slow

>; system, into a cache database which is local and faster. This would be 
> useful if you don't want to burden the master source with traffic from
> Penrose. If your master source is already fast enough and can handle Penrose

> traffic you probably don't need this.
>
> It is also useful if you want to join serveral sources that don't support
&gt; join operation natively, for example joining 2 ldap directories. This

>; feature will replicate the entire content of your master sources into the 
> cache database and perform the join operation there. If you want to join
> tables from the same RDBMS database you don't need this. Unlike the previous

> versions, Penrose 1.2.x can perform the join operation on the database side. 
>
> If that is what you want to do, here's how to set up the example:
&gt;
> 1. Create a MySQL database called "example". This is the master database.


> 2. Run the create.sql included in the example under the sql folder to create 
> the tables and triggers. If you are using a different database system, you
> need to modify the script for your database system.

> 3. Create a MySQL database called "jdbc". This is the cache database. 
> 4. Add the following parameter in the "users" source (keep the original
&gt; "table" parameter).

>
&gt; &nbsp; &nbsp; <parameter>
>; &nbsp; &nbsp; &nbsp; <param-name>sync</param-name> 
> ; &nbsp; &nbsp;  <param-value>users_cache&lt;/param-value>
>; &nbsp; &nbsp; </parameter>
&gt; &nbsp; &nbsp; <parameter>

&gt; &nbsp; &nbsp;   <param-name>changelog</param-name&gt;
>&nbsp; &nbsp; &nbsp;  <param-value>users_changelog</param-value> 
> ; &nbsp;  </parameter>
&gt;
> These parameters tell Penrose to synchronize this source (
i.e. users) with
> "users_cache&quot; source using the change log information stored in
> "users_changelog" table. You can do the same thing with the other sources if 
> you want. You can remove the <source-sync> entries from 
sources.xml, they
> are no longer used.
> 5. Edit server.xml to install this partiiton.
> 6. Run this command to create the cache tables: 
>
>  ; &nbsp; cache.bat -d create jdbc_cache
>
> If it doesn't work with your database system, you can create the tables

&gt; manually. See create-cache.sql.
>; 7. To synchronize the cache, run: 
>
>  ; &nbsp; cache.bat -d sync jdbc_cache
>
> You can use your own scheduler (e.g. cron) to run this command periodically.

> 8. Try to update the data in the master source, the changes should be picked 
> up when you run the sync command.
&gt;
> Let me know if you have any questions.
>
> --
> Endi S. Dewata

&gt;
> On 7/30/07, Nuzz <identitysolutions.co.nz" target="_blank"> paul.edwa...identitysolutions.co.nz> wrote:
>;

>
&gt;
> > I have been trying to run the jdbc-cache example from the samples
&gt; > directory. The cache creation tool isn't working, and as far as I can 
> > ascertain it appears to be a config issue.

&gt;
> > As far as my back track goes, I started working through Penrose, from
> > the top down. I am using the xml files straight from the samples. The 
> > only changes have been to connections.xml
 to point to my database. I
> > have loaded the tables as per the sql scripts in those directories.
>
>; > Now tracing down, looking into source and source sync. The issue is, 
> > that its not finding any source-sync info. The whole reason that the

> > cache tool doesn't work, is it doesn't find anything to sync, so it
> > just exits (Gets as far as create ( CacheUtil.java ln 88), and finds
> > the default partition, but then tries to find sourceSyncs (ln 96), and

> > nothing is returned).
>
> > I started poking around, and I find line Sources.java ln 38. Here is
> > trying to pull a parameter called "sync" from the sourceConfig, but
> > never finds it. I started poking back trying to figure out where it

> > loads the config for sources. I have found the sources-digester- 
> > rules.xml in partition. I see that there is no source-sync section
&gt; > like is present in the sources.xml. So I'm confused as to how its ever

>; > supposed to pick up sync.
>
> > The only thing I have noticed, is, if I add another entry to 
> > sources.xml like this:
> > <source name=";users";>
> >   ; <connection-name>MySQL</connection-name>

> >   ; <field name=";username&quot; primaryKey="true"/> 
> >   ; <field name=";firstName&quot;/>
> >   ; <field name=";lastName&quot;/>
&gt; >   ; <field name=";password&quot;/>

> >   ; <parameter&gt;
> >   ; &nbsp; <;param-name>table&lt;/param-name> 
> >   ; &nbsp; <;param-value>users&lt;/param-value>
&gt; >   ; </parameter&gt;
> > </source>

>;
> > BUT change param-name from table to sync, it then picks up a sync, but
> > still fails as its obviously wanting some other params. So I'm very
> > confused... I hope you can clear this up.

>
> > Thanks
>; > P.


--~--~---------~--~----~------------~-------~--~----~

You received this message because you are subscribed to the Google Groups "safehaus" group. 
 To post to this group, send email to safehausgooglegroups.com 
 To unsubscribe from this group, send email to safehaus-unsubscribegooglegroups.com 
 For more options, visit this group at http://groups.google.com/group/safehaus?hl=en 
 -~----------~----~----~----~------~----~------~--~---





  

  
  
   
     
    

  

    Re: JDBC-cache sample
  


  

     country flaguser name
United States		
     2007-08-01 14:05:42
  


  

    
Endi,

the patched jar hasn't fixed the objectclass=* problem.

P.

On Jul 31, 2:38 pm, "Endi Sukma Dewata"
<end...gmail.com> wrote:
> Paul,
>
> If you want to test for speed, you might want to try
using the simple
> handler, provided your mapping configuration meets the
requirement. See this
> page:h
ttp://docs.safehaus.org/display/PENROSE12/Handlers
>
> To configure simple handler, add the following in
server.xml:
>
> <handler name="SIMPLE">
>  
<handler-class>org.safehaus.penrose.handler.simple.Sim
pleHandler
> </handler-class>
> </handler>
>
> Then edit your partition:
>
> <partition name="jdbc_cache"
path="partitions/jdbc_cache">
>   <handler-name>SIMPLE</handler-name>
> </partition>
>
> --
> Endi S. Dewata
>
> On 7/31/07, Endi Sukma Dewata <end...gmail.com> wrote:
>
>
>
> > Paul,
>
> > Please try replacing lib/penrose-server-1.2.4.jar
with this:
>
> >http://builds.safehaus.org/penrose/PENRO
SE-SERVER12/penrose-server-1....
> > It should fix the missing objectClass=* filter.
>
> > Btw, in modules.xml there's already a module
configured to synchronize the
> > sources every 30 seconds. You can just use this
instead of cron.
>
> > --
> > Endi S. Dewata
>
> > On 7/31/07, Nuzz <paul.edwa...identitysolutions.co.nz> wrote:
>
> > > Endi,
>
> > > That worked great. I have the system up.
>
> > > However I'm trying to do a bit of load
testing with slamd. Now, when I
> > > try to connect with slamd, penrose seems to
not like the default
> > > filter that slamd is supplying (I cannot see
a way at the mo of
> > > changing what slamd is supplying - without
recompiling slamd). As far
> > > as I'm aware, what slamd is supplying is
correct ldap syntax. I
> > > believe that the filter slamd is supplying on
connect is: (|
> > > (objectclass=*)(objectclass=ldapsubentry)),
which by my way of
> > > thinking seems a bit stupid, as it should
just take the objectclass=*
> > > for all, but it appears that penrose is
getting rid of the
> > > objectclass=*, and then it all fails.  Anyway
heres what I'm seeing:
>
> > > [07/31/2007 10:46:29 DEBUG
(PenroseSession.java:114)]
> > > bind("uid=admin,ou=system",
"secret")
> > > [07/31/2007 10:46:29 WARN  (
Session.java:242)] Bind
> > > "uid=admin,ou=system".
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:248)]
>
> > >
------------------------------------------------------------
----------------------
> > > [07/31/2007 10:46:29 DEBUG (
Session.java:249)] BIND:
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:250)]  - Bind DN       :
> > > uid=admin,ou=system
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:251)]  - Bind Password :
> > > secret
> > > [07/31/2007 10:46:29 DEBUG (
Session.java:252)]
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:254)] Controls: []
> > > [07/31/2007 10:46:29 DEBUG
(EventManager.java:86)] Firing BeforeBind
> > > event.
> > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:209)] Comparing
> > > passwords:
> > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:242)] Supplied
> > > [secret]
> > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:243)] Stored
> > > [secret]
> > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:247)] Result: true
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:283)] Bound as root user.
> > > [07/31/2007 10:46:29 DEBUG
(EventManager.java:86)] Firing AfterBind
> > > event.
> > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:25)] Converting
> > > filter: OR
> > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:29)] Class:
> > >
org.apache.directory.shared.ldap.filter.BranchNode
> > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:25)] Converting
> > > filter: (objectclass=*)
> > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:29)] Class:
> > >
org.apache.directory.shared.ldap.filter.PresenceNode
> > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:25)] Converting
> > > filter: (objectclass=ldapsubentry)
> > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:29)] Class:
> > >
org.apache.directory.shared.ldap.filter.SimpleNode
> > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:223)] Parsing filter
> > > "objectclass=*"
> > > [07/31/2007 10:46:29 DEBUG (
FilterParser.java:237)] Filter:
> > > [objectclass] [=] [*]
> > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:262)] Parsed filter:
> > > null
> > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:223)] Parsing filter
> > > "objectclass=ldapsubentry"
> > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:237)] Filter:
> > > [objectclass] [=] [ldapsubentry]
> > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:262)] Parsed filter:
> > > (objectclass=ldapsubentry)
> > > [07/31/2007 10:46:29 DEBUG (
PenroseSession.java:269)]
> > > search("ou=Users,dc=JDBC
Cache,dc=Example,dc=com", "(|
> > > (objectclass=ldapsubentry))")
> > > [07/31/2007 10:46:29 WARN 
(Session.java:757)] Search
> > > "ou=Users,dc=JDBC
Cache,dc=Example,dc=com" with scope base and filter
> > > "(|(objectclass=ldapsubentry))"
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:763)]
>
> > >
------------------------------------------------------------
----------------------
> > > [07/31/2007 10:46:29 DEBUG (Session.java
:764)] SEARCH:
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:765)]  - Bind DN    :
> > > uid=admin,ou=system
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:766)]  - Base DN    :
> > > ou=Users,dc=JDBC Cache,dc=Example,dc=com
> > > [07/31/2007 10:46:29 DEBUG (
Session.java:767)]  - Scope      : base
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:768)]  - Filter     : (|
> > > (objectclass=ldapsubentry))
> > > [07/31/2007 10:46:29 DEBUG
(Session.java:769)]  - Attributes : [1.1]
> > > [07/31/2007 10:46:30 DEBUG (
Session.java:770)]
> > > [07/31/2007 10:46:30 DEBUG
(Session.java:772)] Controls: []
> > > [07/31/2007 10:46:30 DEBUG
(EventManager.java:236)] Firing
> > > BeforeSearch event.
> > > [07/31/2007 10:46:30 DEBUG
(HandlerManager.java:419)] Requested: [ 1.1]
> > > [07/31/2007 10:46:30 DEBUG
(HandlerManager.java:485)] Searching
> > > ou=Users,dc=JDBC Cache,dc=Example,dc=com in
ou=Users,dc=JDBC
> > > Cache,dc=Example,dc=com
> > > [07/31/2007 10:46:30 DEBUG
(ACLManager.java:167)] Checking object "s"
> > > permission
> > > [07/31/2007 10:46:30 DEBUG
(ACLManager.java:176)] Root user => SUCCESS
> > > [07/31/2007 10:46:30 DEBUG
(DefaultHandler.java:234)] Searching
> > > ou=Users,dc=JDBC Cache,dc=Example,dc=com with
scope base
> > > [07/31/2007 10:46:30 DEBUG
(DefaultHandler.java:240)] Entry
> > > "ou=Users,dc=JDBC
Cache,dc=Example,dc=com" doesn't match search
> > > filter.
> > > [07/31/2007 10:46:30 DEBUG
(HandlerSearchResponse.java:120)] All
> > > search threads have ended.
> > > [07/31/2007 10:46:30 DEBUG
(HandlerSearchResponse.java:146)] Found
> > > successes: true
> > > [07/31/2007 10:46:30 DEBUG
(EventManager.java:236)] Firing AfterSearch
> > > event.
> > > [07/31/2007 10:46:30 DEBUG (
PenroseSession.java:294)] unbind()
>
> > > On Jul 30, 2:18 pm, "Endi Sukma
Dewata" <end...gmail.com> wrote:
> > > > Paul,
>
> > > > Apparently the jdbc_cache example is
outdated, sorry about that. But
> > > before
> > > > proceeding further I need to tell you
what this example does. It
> > > basicaly
> > > > replicates the data from a master
source, presumably from a remote or
> > > slow
> > > > system, into a cache database which is
local and faster. This would be
>
> > > > useful if you don't want to burden the
master source with traffic from
> > > > Penrose. If your master source is
already fast enough and can handle
> > > Penrose
> > > > traffic you probably don't need this.
>
> > > > It is also useful if you want to join
serveral sources that don't
> > > support
> > > > join operation natively, for example
joining 2 ldap directories. This
> > > > feature will replicate the entire
content of your master sources into
> > > the
> > > > cache database and perform the join
operation there. If you want to
> > > join
> > > > tables from the same RDBMS database you
don't need this. Unlike the
> > > previous
> > > > versions, Penrose 1.2.x can perform the
join operation on the database
> > > side.
>
> > > > If that is what you want to do, here's
how to set up the example:
>
> > > > 1. Create a MySQL database called
"example". This is the master
> > > database.
> > > > 2. Run the create.sql included in the
example under the sql folder to
> > > create
> > > > the tables and triggers. If you are
using a different database system,
> > > you
> > > > need to modify the script for your
database system.
> > > > 3. Create a MySQL database called
"jdbc". This is the cache database.
> > > > 4. Add the following parameter in the
"users" source (keep the
> > > original
> > > > "table" parameter).
>
> > > >     <parameter>
> > > >      
<param-name>sync</param-name>
> > > >      
<param-value>users_cache</param-value>
> > > >     </parameter>
> > > >     <parameter>
> > > >      
<param-name>changelog</param-name>
> > > >      
<param-value>users_changelog</param-value>
> > > >     </parameter>
>
> > > > These parameters tell Penrose to
synchronize this source (i.e. users)
> > > with
> > > > "users_cache" source using the
change log information stored in
> > > > "users_changelog" table. You
can do the same thing with the other
> > > sources if
> > > > you want. You can remove the
<source-sync> entries from sources.xml,
> > > they
> > > > are no longer used.
> > > > 5. Edit server.xml to install this
partiiton.
> > > > 6. Run this command to create the cache
tables:
>
> > > >     cache.bat -d create jdbc_cache
>
> > > > If it doesn't work with your database
system, you can create the
> > > tables
> > > > manually. See create-cache.sql.
> > > > 7. To synchronize the cache, run:
>
> > > >     cache.bat -d sync jdbc_cache
>
> > > > You can use your own scheduler (e.g.
cron) to run this command
> > > periodically.
> > > > 8. Try to update the data in the master
source, the changes should be
> > > picked
> > > > up when you run the sync command.
>
> > > > Let me know if you have any questions.
>
> > > > --
> > > > Endi S. Dewata
>
> > > > On 7/30/07, Nuzz < paul.edwa...identitysolutions.co.nz> wrote:
>
> > > > > I have been trying to run the
jdbc-cache example from the samples
> > > > > directory. The cache creation tool
isn't working, and as far as I
> > > can
> > > > > ascertain it appears to be a config
issue.
>
> > > > > As far as my back track goes, I
started working through Penrose,
> > > from
> > > > > the top down. I am using the xml
files straight from the samples.
> > > The
> > > > > only changes have been to
>
> ...
>
> read more >>


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "safehaus" group.
To post to this group, send email to safehausgooglegroups.com
To unsubscribe from this group, send email to
safehaus-unsubscribegooglegroups.com
For more options, visit this group at http://
groups.google.com/group/safehaus?hl=en
-~----------~----~----~----~------~----~------~--~---




  


  

    
  

  
  
   
     
    

  

    Re: JDBC-cache sample
  


  

     user name

     2007-08-02 10:22:40
  


  

    

  


  

    
Paul,


&nbsp;


Could you run it in the debug mode and post the output? Thanks.


-- 
Endi S. Dewata 



 ;


On 8/1/07, Nuzz < paul.edwardsidentitysolutions.co.nz">paul.edwardsidentitysolutions.co.nz> wrote:


Endi,

the patched jar hasn't fixed the objectclass=* problem.

P.

On Jul 31, 2:38 pm, "Endi Sukma Dewata&quot; <
 end...gmail.com">end...gmail.com> wrote:
>; Paul,
>
> If you want to test for speed, you might want to try using the simple
>; handler, provided your mapping configuration meets the requirement. See this

>; page:http://docs.safehaus.org/display/PENROSE12/Handlers
&gt;
> To configure simple handler, add the following in server.xml:
>

&gt; <handler name=";SIMPLE&quot;>
>  ; <handler-class>org.safehaus.penrose.handler.simple.SimpleHandler
> </handler-class>;
> </handler>
>
> Then edit your partition:

>
>; <partition name=";jdbc_cache" path=";partitions/jdbc_cache">
> &nbsp; <handler-name>SIMPLE</handler-name>
> </partition>
&gt;
> --
> Endi S. Dewata

&gt;
> On 7/31/07, Endi Sukma Dewata < end...gmail.com">end...gmail.com> wrote:
>;
>
>
> > Paul,
>
> > Please try replacing lib/penrose-server-1.2.4.jar
 with this:
>
> >http://builds.safehaus.org/penrose/PENROSE-SERVER12/penrose-server-1....
&gt; > It should fix the missing objectClass=* filter.

>
> > Btw, in modules.xml there's already a module configured to synchronize the
> > sources every 30 seconds. You can just use this instead of cron.
>
> > --
> > Endi S. Dewata

&gt;
> > On 7/31/07, Nuzz < paul.edwa...identitysolutions.co.nz">paul.edwa...identitysolutions.co.nz> wrote:
>;
> > > Endi,
>
> > > That worked great. I have the system up.

>
> > > However I'm trying to do a bit of load testing with slamd. Now, when I
> > > try to connect with slamd, penrose seems to not like the default
&gt; > > filter that slamd is supplying (I cannot see a way at the mo of

> > > changing what slamd is supplying - without recompiling slamd). As far
> > > as I'm aware, what slamd is supplying is correct ldap syntax. I
> > > believe that the filter slamd is supplying on connect is: (|

> > > (objectclass=*)(objectclass=ldapsubentry)), which by my way of
> > > thinking seems a bit stupid, as it should just take the objectclass=*
> > > for all, but it appears that penrose is getting rid of the

> > > objectclass=*, and then it all fails.&nbsp; Anyway heres what I'm seeing:
&gt;
> > > [07/31/2007 10:46:29 DEBUG (PenroseSession.java:114)]
> > > bind(";uid=admin,ou=system&quot;, "secret")

> > > [07/31/2007 10:46:29 WARN  ( Session.java:242)] Bind
> > > "uid=admin,ou=system".
> > > [07/31/2007 10:46:29 DEBUG (Session.java:248)]
&gt;
> > > ----------------------------------------------------------------------------------

&gt; > > [07/31/2007 10:46:29 DEBUG ( Session.java:249)] BIND:
> > > [07/31/2007 10:46:29 DEBUG (Session.java:250)]&nbsp; - Bind DN &nbsp; &nbsp;   :
> > > uid=admin,ou=system
&gt; > > [07/31/2007 10:46:29 DEBUG (
Session.java:251)]  ;- Bind Password :
> > > secret
>; > > [07/31/2007 10:46:29 DEBUG ( Session.java:252)]
&gt; > > [07/31/2007 10:46:29 DEBUG (Session.java:254)] Controls: []
> > > [07/31/2007 10:46:29 DEBUG (
EventManager.java:86)] Firing BeforeBind
> > > event.
>; > > [07/31/2007 10:46:29 DEBUG (PasswordUtil.java:209)] Comparing
> > > passwords:
> > > [07/31/2007 10:46:29 DEBUG (
PasswordUtil.java:242)] Supplied
&gt; > > [secret]
&gt; > > [07/31/2007 10:46:29 DEBUG (PasswordUtil.java:243)] Stored
>; > > [secret]
&gt; > > [07/31/2007 10:46:29 DEBUG (PasswordUtil.java
:247)] Result: true
> > > [07/31/2007 10:46:29 DEBUG (Session.java:283)] Bound as root user.
> > > [07/31/2007 10:46:29 DEBUG (EventManager.java:86)] Firing AfterBind
> > > event.
>; > > [07/31/2007 10:46:29 DEBUG (
MinaFilterTool.java:25)] Converting
> > > filter: OR
> > > [07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
>; > > org.apache.directory.shared.ldap.filter.BranchNode
>; > > [07/31/2007 10:46:29 DEBUG (
MinaFilterTool.java:25)] Converting
> > > filter: (objectclass=*)
> > > [07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
>; > > org.apache.directory.shared.ldap.filter.PresenceNode

> > > [07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:25)] Converting
> > > filter: (objectclass=ldapsubentry)
> > > [07/31/2007 10:46:29 DEBUG (MinaFilterTool.java:29)] Class:
>; > > 
org.apache.directory.shared.ldap.filter.SimpleNode
&gt; > > [07/31/2007 10:46:29 DEBUG (FilterParser.java:223)] Parsing filter
>; > > "objectclass=*&quot;
> > > [07/31/2007 10:46:29 DEBUG ( 
FilterParser.java:237)] Filter:
&gt; > > [objectclass] [=] [*]
> > > [07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed filter:
&gt; > > null
> > > [07/31/2007 10:46:29 DEBUG (
FilterParser.java:223)] Parsing filter
>; > > "objectclass=ldapsubentry&quot;
> > > [07/31/2007 10:46:29 DEBUG (FilterParser.java:237)] Filter:
&gt; > > [objectclass] [=] [ldapsubentry]

> > > [07/31/2007 10:46:29 DEBUG (FilterParser.java:262)] Parsed filter:
&gt; > > (objectclass=ldapsubentry)
> > > [07/31/2007 10:46:29 DEBUG ( PenroseSession.java:269)]
> > > search(&quot;ou=Users,dc=JDBC Cache,dc=Example,dc=com", "(|

> > > (objectclass=ldapsubentry))";)
> > > [07/31/2007 10:46:29 WARN  (Session.java:757)] Search
>; > > "ou=Users,dc=JDBC Cache,dc=Example,dc=com" with scope base and filter

&gt; > > "(|(objectclass=ldapsubentry))"
&gt; > > [07/31/2007 10:46:29 DEBUG (Session.java:763)]
&gt;
> > > ----------------------------------------------------------------------------------

&gt; > > [07/31/2007 10:46:29 DEBUG (Session.java :764)] SEARCH:
&gt; > > [07/31/2007 10:46:29 DEBUG (Session.java:765)]&nbsp; - Bind DN &nbsp; &nbsp;:
> > > uid=admin,ou=system
&gt; > > [07/31/2007 10:46:29 DEBUG (
Session.java:766)]  ;- Base DN &nbsp; &nbsp;:
> > > ou=Users,dc=JDBC Cache,dc=Example,dc=com
> > > [07/31/2007 10:46:29 DEBUG ( Session.java:767)]&nbsp; - Scope ; &nbsp; &nbsp; : base
> > > [07/31/2007 10:46:29 DEBUG (
Session.java:768)]  ;- Filter&nbsp; &nbsp;  : (|
> > > (objectclass=ldapsubentry))
> > > [07/31/2007 10:46:29 DEBUG (Session.java:769)]&nbsp; - Attributes : [1.1]
> > > [07/31/2007 10:46:30 DEBUG ( Session.java
:770)]
> > > [07/31/2007 10:46:30 DEBUG (Session.java:772)] Controls: []
> > > [07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing
>; > > BeforeSearch event.
>; > > [07/31/2007 10:46:30 DEBUG (
HandlerManager.java:419)] Requested: [ 1.1]
> > > [07/31/2007 10:46:30 DEBUG (HandlerManager.java:485)] Searching
> > > ou=Users,dc=JDBC Cache,dc=Example,dc=com in ou=Users,dc=JDBC
> > > Cache,dc=Example,dc=com

> > > [07/31/2007 10:46:30 DEBUG (ACLManager.java:167)] Checking object "s&quot;
> > > permission
> > > [07/31/2007 10:46:30 DEBUG (ACLManager.java:176)] Root user => SUCCESS

> > > [07/31/2007 10:46:30 DEBUG (DefaultHandler.java:234)] Searching
> > > ou=Users,dc=JDBC Cache,dc=Example,dc=com with scope base
> > > [07/31/2007 10:46:30 DEBUG (DefaultHandler.java:240)] Entry

&gt; > > "ou=Users,dc=JDBC Cache,dc=Example,dc=com" doesn't match search
>; > > filter.
&gt; > > [07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:120)] All
> > > search threads have ended.

&gt; > > [07/31/2007 10:46:30 DEBUG (HandlerSearchResponse.java:146)] Found
> > > successes: true
> > > [07/31/2007 10:46:30 DEBUG (EventManager.java:236)] Firing AfterSearch
> > > event.

&gt; > > [07/31/2007 10:46:30 DEBUG ( PenroseSession.java:294)] unbind()
&gt;
> > > On Jul 30, 2:18 pm, "Endi Sukma Dewata&quot; < end...gmail.com">end...gmail.com> wrote:

&gt; > > > Paul,
>
> > > > Apparently the jdbc_cache example is outdated, sorry about that. But
> > > before
>; > > > proceeding further I need to tell you what this example does. It

> > > basicaly
&gt; > > > replicates the data from a master source, presumably from a remote or
> > > slow
> > > > system, into a cache database which is local and faster. This would be

>
> > > > useful if you don't want to burden the master source with traffic from
> > > > Penrose. If your master source is already fast enough and can handle
>; > > Penrose

> > > > traffic you probably don't need this.
>
> > > > It is also useful if you want to join serveral sources that don't
> > > support
&gt; > > > join operation natively, for example joining 2 ldap directories. This

>; > > > feature will replicate the entire content of your master sources into
> > > the
> > > > cache database and perform the join operation there. If you want to
> > > join

>; > > > tables from the same RDBMS database you don't need this. Unlike the
> > > previous
&gt; > > > versions, Penrose 1.2.x can perform the join operation on the database
&gt; > > side.

&gt;
> > > > If that is what you want to do, here's how to set up the example:
&gt;
> > > > 1. Create a MySQL database called "example". This is the master
>; > > database.


> > > > 2. Run the create.sql included in the example under the sql folder to
> > > create
>; > > > the tables and triggers. If you are using a different database system,
&gt; > > you

> > > > need to modify the script for your database system.
&gt; > > > 3. Create a MySQL database called "jdbc". This is the cache database.
> > > > 4. Add the following parameter in the "users" source (keep the

> > > original
&gt; > > > "table" parameter).
>
> > > >   ;  <parameter>
>; > > >   ; &nbsp;  <param-name>sync</param-name>
&gt; > > >   ; &nbsp;  <param-value>users_cache&lt;/param-value>

&gt; > > >   ;  </parameter>
&gt; > > >   ;  <parameter>
>; > > >   ; &nbsp;  <param-name>changelog</param-name&gt;
> > > >   ; &nbsp;  <param-value>users_changelog</param-value>

> > > >   ;  </parameter>
&gt;
> > > > These parameters tell Penrose to synchronize this source (i.e. users)
>; > > with
> > > > "users_cache&quot; source using the change log information stored in

> > > > "users_changelog" table. You can do the same thing with the other
> > > sources if
> > > > you want. You can remove the <source-sync> entries from sources.xml
,
> > > they
> > > > are no longer used.
> > > > 5. Edit server.xml to install this partiiton.
> > > > 6. Run this command to create the cache tables:
&gt;
> > > >   ;  
cache.bat -d create jdbc_cache
>
> > > > If it doesn't work with your database system, you can create the
> > > tables
>; > > > manually. See create-cache.sql.
>; > > > 7. To synchronize the cache, run:

>;
> > > >   ;  cache.bat -d sync jdbc_cache
>
> > > > You can use your own scheduler (e.g. cron) to run this command
&gt; > > periodically.
> > > > 8. Try to update the data in the master source, the changes should be

> > > picked
>; > > > up when you run the sync command.
&gt;
> > > > Let me know if you have any questions.
>
> > > > --
> > > > Endi S. Dewata

&gt;
> > > > On 7/30/07, Nuzz <  paul.edwa...identitysolutions.co.nz">paul.edwa...identitysolutions.co.nz> wrote:
>;
> > > > > I have been trying to run the jdbc-cache example from the samples

> > > > > directory. The cache creation tool isn't working, and as far as I
> > > can
> > > > > ascertain it appears to be a config issue.
>;
> > > > > As far as my back track goes, I started working through Penrose,

> > > from
> > > > > the top down. I am using the xml files straight from the samples.
&gt; > > The
> > > > > only changes have been to
>
&gt; ...
>

> read more >>




--~--~---------~--~----~------------~-------~--~----~

You received this message because you are subscribed to the Google Groups "safehaus" group. 
 To post to this group, send email to safehausgooglegroups.com 
 To unsubscribe from this group, send email to safehaus-unsubscribegooglegroups.com 
 For more options, visit this group at http://groups.google.com/group/safehaus?hl=en 
 -~----------~----~----~----~------~----~------~--~---




  

  
  
   
     
    

  

    Re: JDBC-cache sample
  


  

     country flaguser name
United States		
     2007-08-03 13:23:42
  


  

    
[08/03/2007 14:21:59 WARN  (PenroseJMXService.java:147)]
Listening to
port 1099 (RMI).
[08/03/2007 14:21:59 WARN  (PenroseJMXService.java:148)]
Listening to
port 40888 (RMI Transport).
[08/03/2007 14:21:59 WARN  (PenroseJMXService.java:160)]
Listening to
port 8112 (HTTP).
[08/03/2007 14:21:59 DEBUG (ServiceManager.java:78)]
Starting LDAP.
[08/03/2007 14:21:59 WARN  (MinaLDAPService.java:121)]
Listening to
port 10389 (LDAP).
[08/03/2007 14:21:59 FATAL (PenroseServer.java:248)] Server
is ready.
[08/03/2007 14:22:29 WARN  (SourceSyncModule.java:89)]
Synchronizing
DEFAULT/users.
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:790)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:791)] | Search
tracker
|
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:792)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:222)]
Authentication:
null
[08/03/2007 14:22:29 DEBUG (SourceRef.java:40)] Source ref
tracker
tracker:
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
sourceName
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
changeNumber
[08/03/2007 14:22:29 DEBUG (JDBCStatementBuilder.java:51)]
Generating
select statement.
[08/03/2007 14:22:29 DEBUG (JDBCFilterBuilder.java:76)]
Simple Filter:
sourceName = users
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:397)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] | select
distinct
tracker.sourceName, tracker.changeNumber from tracker tracke
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] | r where
sourceName
= ? order by sourceName                                   |
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:402)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:405)] |
Parameters:
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:410)] |  - 1 =
users
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:412)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:858)] Search
operation
completed.
[08/03/2007 14:22:29 DEBUG (ChangeLogUtil.java:84)]
Tracker:
sourceName=users
[08/03/2007 14:22:29 DEBUG (Attributes.java:177)]  -
sourceName: users
(String)
[08/03/2007 14:22:29 DEBUG (Attributes.java:177)]  -
changeNumber: 5
(Integer)
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:790)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:791)] | Search
users_changelog
|
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:792)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:222)]
Authentication:
null
[08/03/2007 14:22:29 DEBUG (SourceRef.java:40)] Source ref
users_changelog users_changelog:
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
changeNumber
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
changeTime
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
changeAction
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
changeUser
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
username
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
firstName
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
lastName
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]  - field
password
[08/03/2007 14:22:29 DEBUG (JDBCStatementBuilder.java:51)]
Generating
select statement.
[08/03/2007 14:22:29 DEBUG (JDBCFilterBuilder.java:76)]
Simple Filter:
changeNumber > 5
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:397)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] | select
distinct
users_changelog.changeNumber, users_changelog.changeTime, us
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] |
ers_changelog.changeAction, users_changelog.changeUser,
users_changelog.user |
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] | name,
users_changelog.firstName, users_changelog.lastName,
users_changelog.p
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] | assword
from
users_changelog users_changelog where changeNumber > ?
order by |
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] |
changeNumber
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:402)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:405)] |
Parameters:
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:410)] |  - 1 =
5
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:412)]
+-----------------------------------------------------------
-------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:858)] Search
operation
completed.
[08/03/2007 14:22:29 DEBUG (ChangeLogUtil.java:40)] There is
no new
changes.
[08/03/2007 14:22:39 DEBUG (PenroseBackend.java:101)]
openConnection(0)
[08/03/2007 14:22:39 DEBUG (PenroseSession.java:114)]
bind("uid=admin,ou=system", "secret")
[08/03/2007 14:22:39 WARN  (Session.java:242)] Bind
"uid=admin,ou=system".
[08/03/2007 14:22:39 DEBUG (Session.java:248)]
------------------------------------------------------------
----------------------
[08/03/2007 14:22:39 DEBUG (Session.java:249)] BIND:
[08/03/2007 14:22:39 DEBUG (Session.java:250)]  - Bind DN   
   :
uid=admin,ou=system
[08/03/2007 14:22:39 DEBUG (Session.java:251)]  - Bind
Password :
secret
[08/03/2007 14:22:39 DEBUG (Session.java:252)]
[08/03/2007 14:22:39 DEBUG (Session.java:254)] Controls: []
[08/03/2007 14:22:39 DEBUG (EventManager.java:86)] Firing
BeforeBind
event.
[08/03/2007 14:22:40 DEBUG (PasswordUtil.java:209)]
Comparing
passwords:
[08/03/2007 14:22:40 DEBUG (PasswordUtil.java:242)]
Supplied
[secret]
[08/03/2007 14:22:40 DEBUG (PasswordUtil.java:243)] Stored
[secret]
[08/03/2007 14:22:40 DEBUG (PasswordUtil.java:247)] Result:
true
[08/03/2007 14:22:40 DEBUG (Session.java:283)] Bound as root
user.
[08/03/2007 14:22:40 DEBUG (EventManager.java:86)] Firing
AfterBind
event.
[08/03/2007 14:22:40 DEBUG (MinaFilterTool.java:25)]
Converting
filter: OR
[08/03/2007 14:22:40 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.BranchNode
[08/03/2007 14:22:40 DEBUG (MinaFilterTool.java:25)]
Converting
filter: (objectclass=*)
[08/03/2007 14:22:40 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.PresenceNode
[08/03/2007 14:22:40 DEBUG (MinaFilterTool.java:25)]
Converting
filter: (objectclass=ldapsubentry)
[08/03/2007 14:22:40 DEBUG (MinaFilterTool.java:29)] Class:
org.apache.directory.shared.ldap.filter.SimpleNode
[08/03/2007 14:22:40 DEBUG (FilterParser.java:223)] Parsing
filter
"objectclass=*"
[08/03/2007 14:22:40 DEBUG (FilterParser.java:237)] Filter:
[objectclass] [=] [*]
[08/03/2007 14:22:40 DEBUG (FilterParser.java:262)] Parsed
filter:
null
[08/03/2007 14:22:40 DEBUG (FilterParser.java:223)] Parsing
filter
"objectclass=ldapsubentry"
[08/03/2007 14:22:40 DEBUG (FilterParser.java:237)] Filter:
[objectclass] [=] [ldapsubentry]
[08/03/2007 14:22:40 DEBUG (FilterParser.java:262)] Parsed
filter:
(objectclass=ldapsubentry)
[08/03/2007 14:22:40 DEBUG (PenroseSession.java:269)]
search("dc=JDBC
Cache,dc=Example,dc=com",
"(|(objectclass=ldapsubentry))")
[08/03/2007 14:22:40 WARN  (Session.java:757)] Search
"dc=JDBC
Cache,dc=Example,dc=com" with scope base and filter
"(|
(objectclass=ldapsubentry))"
[08/03/2007 14:22:40 DEBUG (Session.java:763)]
------------------------------------------------------------
----------------------
[08/03/2007 14:22:40 DEBUG (Session.java:764)] SEARCH:
[08/03/2007 14:22:40 DEBUG (Session.java:765)]  - Bind DN   
:
uid=admin,ou=system
[08/03/2007 14:22:40 DEBUG (Session.java:766)]  - Base DN   
: dc=JDBC
Cache,dc=Example,dc=com
[08/03/2007 14:22:40 DEBUG (Session.java:767)]  - Scope     
: base
[08/03/2007 14:22:40 DEBUG (Session.java:768)]  - Filter    
: (|
(objectclass=ldapsubentry))
[08/03/2007 14:22:40 DEBUG (Session.java:769)]  - Attributes
: [1.1]
[08/03/2007 14:22:40 DEBUG (Session.java:770)]
[08/03/2007 14:22:40 DEBUG (Session.java:772)] Controls: []
[08/03/2007 14:22:40 DEBUG (EventManager.java:236)] Firing
BeforeSearch event.
[08/03/2007 14:22:40 DEBUG (HandlerManager.java:419)]
Requested: [1.1]
[08/03/2007 14:22:40 DEBUG (HandlerManager.java:485)]
Searching
dc=JDBC Cache,dc=Example,dc=com in dc=JDBC
Cache,dc=Example,dc=com
[08/03/2007 14:22:40 DEBUG (ACLManager.java:167)] Checking
object "s"
permission
[08/03/2007 14:22:40 DEBUG (ACLManager.java:176)] Root user
=> SUCCESS
[08/03/2007 14:22:40 DEBUG (DefaultHandler.java:234)]
Searching
dc=JDBC Cache,dc=Example,dc=com with scope base
[08/03/2007 14:22:40 DEBUG (DefaultHandler.java:240)] Entry
"dc=JDBC
Cache,dc=Example,dc=com" doesn't match search filter.
[08/03/2007 14:22:40 DEBUG (HandlerSearchResponse.java:120)]
All
search threads have ended.
[08/03/2007 14:22:40 DEBUG (HandlerSearchResponse.java:146)]
Found
successes: true
[08/03/2007 14:22:40 DEBUG (EventManager.java:236)] Firing
AfterSearch
event.
[08/03/2007 14:22:40 DEBUG (PenroseSession.java:294)]
unbind()
[08/03/2007 14:22:40 WARN  (Session.java:910)] Unbind
"uid=admin,ou=system".
[08/03/2007 14:22:40 DEBUG (Session.java:916)]
------------------------------------------------------------
----------------------
[08/03/2007 14:22:40 DEBUG (Session.java:917)] UNBIND:
[08/03/2007 14:22:40 DEBUG (Session.java:918)]  - Bind DN:
uid=admin,ou=system
[08/03/2007 14:22:40 DEBUG (Session.java:919)]
[08/03/2007 14:22:40 DEBUG (Session.java:921)] Controls: []
[08/03/2007 14:22:40 DEBUG (EventManager.java:266)] Firing
BeforeUnbind event.
[08/03/2007 14:22:40 DEBUG (EventManager.java:266)] Firing
AfterUnbind
event.
[08/03/2007 14:22:40 DEBUG (MinaHandler.java:109)]
Connection reset by
peer
java.io.IOException: Connection reset by peer
        at sun.nio.ch.FileDispatcher.read0(Native Method)
        at
sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:21)
        at
sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233)
        at sun.nio.ch.IOUtil.read(IOUtil.java:200)
        at
sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:
207)
        at
org.apache.mina.transport.socket.nio.SocketIoProcessor.read(
SocketIoProcessor.java:
267)
        at
org.apache.mina.transport.socket.nio.SocketIoProcessor.proce
ss(SocketIoProcessor.java:
241)
        at
org.apache.mina.transport.socket.nio.SocketIoProcessor.acces
s
$500(SocketIoProcessor.java:44)
        at
org.apache.mina.transport.socket.nio.SocketIoProcessor
$Worker.run(SocketIoProcessor.java:559)
        at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservi
ngRunnable.java:
43)
        at java.lang.Thread.run(Thread.java:595)


On Aug 2, 11:22 am, "Endi Sukma Dewata"
<end...gmail.com> wrote:
> Paul,
>
> Could you run it in the debug mode and post the output?
Thanks.
>
> --
> Endi S. Dewata
>
> On 8/1/07, Nuzz <paul.edwa...identitysolutions.co.nz>
wrote:
>
>
>
> > Endi,
>
> > the patched jar hasn't fixed the objectclass=*
problem.
>
> > P.
>
> > On Jul 31, 2:38 pm, "Endi Sukma Dewata"
<end...gmail.com> wrote:
> > > Paul,
>
> > > If you want to test for speed, you might want
to try using the simple
> > > handler, provided your mapping configuration
meets the requirement. See
> > this
> > > page:h
ttp://docs.safehaus.org/display/PENROSE12/Handlers
>
> > > To configure simple handler, add the
following in server.xml:
>
> > > <handler name="SIMPLE">
> > >  
<handler-class>org.safehaus.penrose.handler.simple.Sim
pleHandler
> > > </handler-class>
> > > </handler>
>
> > > Then edit your partition:
>
> > > <partition name="jdbc_cache"
path="partitions/jdbc_cache">
> > >  
<handler-name>SIMPLE</handler-name>
> > > </partition>
>
> > > --
> > > Endi S. Dewata
>
> > > On 7/31/07, Endi Sukma Dewata <end...gmail.com> wrote:
>
> > > > Paul,
>
> > > > Please try replacing
lib/penrose-server-1.2.4.jar with this:
>
> > > >http://builds.safehaus.org/penrose/PENROSE
-SERVER12/penrose-server-1..
> > ..
> > > > It should fix the missing objectClass=*
filter.
>
> > > > Btw, in modules.xml there's already a
module configured to synchronize
> > the
> > > > sources every 30 seconds. You can just
use this instead of cron.
>
> > > > --
> > > > Endi S. Dewata
>
> > > > On 7/31/07, Nuzz <paul.edwa...identitysolutions.co.nz> wrote:
>
> > > > > Endi,
>
> > > > > That worked great. I have the
system up.
>
> > > > > However I'm trying to do a bit of
load testing with slamd. Now, when
> > I
> > > > > try to connect with slamd, penrose
seems to not like the default
> > > > > filter that slamd is supplying (I
cannot see a way at the mo of
> > > > > changing what slamd is supplying -
without recompiling slamd). As
> > far
> > > > > as I'm aware, what slamd is
supplying is correct ldap syntax. I
> > > > > believe that the filter slamd is
supplying on connect is: (|
> > > > >
(objectclass=*)(objectclass=ldapsubentry)), which by my way
of
> > > > > thinking seems a bit stupid, as it
should just take the
> > objectclass=*
> > > > > for all, but it appears that
penrose is getting rid of the
> > > > > objectclass=*, and then it all
fails.  Anyway heres what I'm seeing:
>
> > > > > [07/31/2007 10:46:29 DEBUG
(PenroseSession.java:114)]
> > > > >
bind("uid=admin,ou=system", "secret")
> > > > > [07/31/2007 10:46:29 WARN  (
Session.java:242)] Bind
> > > > > "uid=admin,ou=system".
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:248)]
>
> >
------------------------------------------------------------
----------------------
> > > > > [07/31/2007 10:46:29 DEBUG (
Session.java:249)] BIND:
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:250)]  - Bind DN       :
> > > > > uid=admin,ou=system
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:251)]  - Bind Password :
> > > > > secret
> > > > > [07/31/2007 10:46:29 DEBUG (
Session.java:252)]
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:254)] Controls: []
> > > > > [07/31/2007 10:46:29 DEBUG
(EventManager.java:86)] Firing BeforeBind
> > > > > event.
> > > > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:209)] Comparing
> > > > > passwords:
> > > > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:242)] Supplied
> > > > > [secret]
> > > > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:243)] Stored
> > > > > [secret]
> > > > > [07/31/2007 10:46:29 DEBUG
(PasswordUtil.java:247)] Result: true
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:283)] Bound as root user.
> > > > > [07/31/2007 10:46:29 DEBUG
(EventManager.java:86)] Firing AfterBind
> > > > > event.
> > > > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:25)] Converting
> > > > > filter: OR
> > > > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:29)] Class:
> > > > >
org.apache.directory.shared.ldap.filter.BranchNode
> > > > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:25)] Converting
> > > > > filter: (objectclass=*)
> > > > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:29)] Class:
> > > > >
org.apache.directory.shared.ldap.filter.PresenceNode
> > > > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:25)] Converting
> > > > > filter: (objectclass=ldapsubentry)
> > > > > [07/31/2007 10:46:29 DEBUG
(MinaFilterTool.java:29)] Class:
> > > > >
org.apache.directory.shared.ldap.filter.SimpleNode
> > > > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:223)] Parsing filter
> > > > > "objectclass=*"
> > > > > [07/31/2007 10:46:29 DEBUG (
FilterParser.java:237)] Filter:
> > > > > [objectclass] [=] [*]
> > > > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:262)] Parsed filter:
> > > > > null
> > > > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:223)] Parsing filter
> > > > >
"objectclass=ldapsubentry"
> > > > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:237)] Filter:
> > > > > [objectclass] [=] [ldapsubentry]
> > > > > [07/31/2007 10:46:29 DEBUG
(FilterParser.java:262)] Parsed filter:
> > > > > (objectclass=ldapsubentry)
> > > > > [07/31/2007 10:46:29 DEBUG (
PenroseSession.java:269)]
> > > > > search("ou=Users,dc=JDBC
Cache,dc=Example,dc=com", "(|
> > > > > (objectclass=ldapsubentry))")
> > > > > [07/31/2007 10:46:29 WARN 
(Session.java:757)] Search
> > > > > "ou=Users,dc=JDBC
Cache,dc=Example,dc=com" with scope base and
> > filter
> > > > >
"(|(objectclass=ldapsubentry))"
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:763)]
>
> >
------------------------------------------------------------
----------------------
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java :764)] SEARCH:
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:765)]  - Bind DN    :
> > > > > uid=admin,ou=system
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:766)]  - Base DN    :
> > > > > ou=Users,dc=JDBC
Cache,dc=Example,dc=com
> > > > > [07/31/2007 10:46:29 DEBUG (
Session.java:767)]  - Scope      : base
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:768)]  - Filter     : (|
> > > > > (objectclass=ldapsubentry))
> > > > > [07/31/2007 10:46:29 DEBUG
(Session.java:769)]  - Attributes : [1.1]
> > > > > [07/31/2007 10:46:30 DEBUG (
Session.java:770)]
> > > > > [07/31/2007 10:46:30 DEBUG
(Session.java:772)] Controls: []
> > > > > [07/31/2007 10:46:30 DEBUG
(EventManager.java:236)] Firing
> > > > > BeforeSearch event.
> > > > > [07/31/2007 10:46:30 DEBUG
(HandlerManager.java:419)] Requested: [
> > 1.1]
> > > > > [07/31/2007 10:46:30 DEBUG
(HandlerManager.java:485)] Searching
> > > > > ou=Users,dc=JDBC
Cache,dc=Example,dc=com in ou=Users,dc=JDBC
> > > > > Cache,dc=Example,dc=com
> > > > > [07/31/2007 10:46:30 DEBUG
(ACLManager.java:167)] Checking object
> > "s"
> > > > > permission
> > > > > [07/31/2007 10:46:30 DEBUG
(ACLManager.java:176)] Root user =>
> > SUCCESS
> > > > > [07/31/2007 10:46:30 DEBUG
(DefaultHandler.java:234)] Searching
> > > > > ou=Users,dc=JDBC
Cache,dc=Example,dc=com with scope base
> > > > > [07/31/2007 10:46:30 DEBUG
(DefaultHandler.java:240)] Entry
> > > > > "ou=Users,dc=JDBC
Cache,dc=Example,dc=com" doesn't match search
> > > > > filter.
> > > > > [07/31/2007 10:46:30 DEBUG
(HandlerSearchResponse.java:120)] All
> > > > > search threads have ended.
> > > > > [07/31/2007 10:46:30 DEBUG
(HandlerSearchResponse.java:146)] Found
> > > > > successes: true
> > > > > [07/31/2007 10:46:30 DEBUG
(EventManager.java:236)] Firing
> > AfterSearch
> > > > > event.
> > > > > [07/31/2007 10:46:30 DEBUG (
PenroseSession.java:294)] unbind()
>
> > > > > On Jul 30, 2:18 pm, "Endi
Sukma Dewata" <end...gmail.com> wrote:
> > > > > > Paul,
>
> > > > > > Apparently the jdbc_cache
example is outdated, sorry about that.
> > But
> > > > > before
> > > > > > proceeding further I need to
tell you what this example does. It
> > > > > basicaly
> > > > > > replicates the data from a
master source, presumably from a remote
> > or
> > > > > slow
> > > > > > system, into a cache database
which is local and faster. This
> > would be
>
> > > > > > useful if you don't want to
burden the master source with traffic
> > from
> > > > > > Penrose. If your master source
is already fast enough and can
> > handle
> > > > > Penrose
> > > > > > traffic you probably don't
need this.
>
> > > > > > It is also useful if you want
to join serveral sources that don't
> > > > > support
> > > > > > join operation natively, for
example joining 2 ldap directories.
> > This
> > > > > > feature will replicate the
entire content of your master sources
> > into
> > > > > the
> > > > > > cache database and perform the
join operation there. If you want
> > to
> > > > > join
> > > > > > tables from the same RDBMS
database you don't need this. Unlike
> > the
> > > > > previous
> > > > > > versions, Penrose 1.2.x can
perform the join operation on the
> > database
> > > > > side.
>
> > > > > > If that is what you want to
do, here's how to set up the example:
>
> > > > > > 1. Create a MySQL database
called "example". This is the master
> > > > > database.
> > > > > > 2. Run the create.sql included
in the example under the sql folder
> > to
> > > > > create
> > > > > > the tables and triggers. If
you are using a different database
> > system,
> > > > > you
> > > > > > need to modify the script for
your database system.
> > > > > > 3. Create a MySQL database
called "jdbc". This is the cache
> > database.
> > > > > > 4. Add the following parameter
in the "users" source (keep the
> > > > > original
> > > > > > "table" parameter).
>
> > > > > >     <parameter>
> > > > > >      
<param-name>sync</param-name>
> > > > > >      
<param-value>users_cache</param-value>
> > > > > >     </parameter>
> > > > > >     <parameter>
> > > > > >      
<param-name>changelog</param-name>
> > > > > >      
<param-value>users_changelog</param-value>
> > > > > >     </parameter>
>
> > > > > > These parameters tell Penrose
to synchronize this source (i.e.
> > users)
> > > > > with
> > > > > > "users_cache" source
using the change log information stored in
> > > > > > "users_changelog"
table. You can do the same thing with the other
> > > > > sources if
> > > > > > you want. You can remove the
<source-sync> entries from
> > sources.xml,
> > > > > they
> > > > > > are no longer used.
> > > > > > 5. Edit server.xml to install
this partiiton.
> > > > > > 6. Run this command
>
> ...
>
> read more >>


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "safehaus" group.
To post to this group, send email to safehausgooglegroups.com
To unsubscribe from this group, send email to
safehaus-unsubscribegooglegroups.com
For more options, visit this group at http://
groups.google.com/group/safehaus?hl=en
-~----------~----~----~----~------~----~------~--~---




  


  

    
  

  
  
   
     
    

  

    Re: JDBC-cache sample
  


  

     user name

     2007-08-03 15:38:27
  


  

    

  


  

    
Paul,


&nbsp;


I think I gave you the wrong file. Here is the right one:




 ;


On 8/3/07, Nuzz < paul.edwardsidentitysolutions.co.nz">paul.edwardsidentitysolutions.co.nz> wrote:


[08/03/2007 14:21:59 WARN  (PenroseJMXService.java:147)] Listening to
port 1099 (RMI).
[08/03/2007 14:21:59 WARN  (
PenroseJMXService.java:148)] Listening to
port 40888 (RMI Transport).
[08/03/2007 14:21:59 WARN  (PenroseJMXService.java:160)] Listening to
port 8112 (HTTP).
[08/03/2007 14:21:59 DEBUG (ServiceManager.java:78)] Starting LDAP.

[08/03/2007 14:21:59 WARN  (MinaLDAPService.java:121)] Listening to
port 10389 (LDAP).
[08/03/2007 14:21:59 FATAL (PenroseServer.java:248)] Server is ready.
[08/03/2007 14:22:29 WARN  (SourceSyncModule.java:89)] Synchronizing

DEFAULT/users.
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:790)]
+------------------------------------------------------------------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:791)] | Search

tracker
|
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:792)]
+------------------------------------------------------------------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:222)] Authentication:

null
[08/03/2007 14:22:29 DEBUG (SourceRef.java:40)] Source ref tracker
tracker:
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]&nbsp; - field sourceName
[08/03/2007 14:22:29 DEBUG (SourceRef.java:44)]&nbsp; - field changeNumber

[08/03/2007 14:22:29 DEBUG (JDBCStatementBuilder.java:51)] Generating
select statement.
[08/03/2007 14:22:29 DEBUG (JDBCFilterBuilder.java:76)] Simple Filter:
sourceName = users
[08/03/2007 14:22:29 DEBUG (
JDBCClient.java:397)]
+------------------------------------------------------------------------------
+
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] | select distinct
tracker.sourceName, tracker.changeNumber

 from tracker tracke |
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:400)] | r where sourceName
= ? order by sourceName  ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   |
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:402)]
+------------------------------------------------------------------------------

+
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:405)] |
Parameters:
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:410)] | &nbsp;- 1 =
users
|
[08/03/2007 14:22:29 DEBUG (JDBCClient.java:412)]
+------------------------------------------------------------------------------

+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:858)] Search operation
completed.
[08/03/2007 14:22:29 DEBUG (ChangeLogUtil.java:84)] Tracker:
sourceName=users
[08/03/2007 14:22:29 DEBUG (Attributes.java
:177)] &nbsp;- sourceName: users
(String)
[08/03/2007 14:22:29 DEBUG (Attributes.java:177)] &nbsp;- changeNumber: 5
(Integer)
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:790)]
+------------------------------------------------------------------------------

+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:791)] | Search
users_changelog
|
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:792)]
+------------------------------------------------------------------------------

+
[08/03/2007 14:22:29 DEBUG (JDBCAdapter.java:222)] Authentication:
null
[08/03/2007 14:22:29 DEBUG (SourceRef.java:40)] Source ref
users_changelog users_chan