Rudder

Dennis, I've been trying to reproduce this bug, without success.
Could you explain in detail what is not working for you?

Thanks

No matter which date I choose, I always get "No data available in table". How can I help you with more info?

Hum, that's weird.
Just to be sure, the format on the node inventory is like this one 2013-04-11 00:51 ?

And when you search, the format is like 10/04/2013 ?

(I'm suspecting a locale problem)

This is exactly what happens. Also, the calendar to choose from is (partly) in French.

What can I do to fix the locale problem?

I can see the following in the reports, since the Rudder server is a client as well. However, the reports doesn't say why it fails.

- Time zone  Error
  - Value  Message                                                           Status
    None   Time zone could not be set (localtime file could not be changed)  Error

Ha ? In which report do you find this message ?

I've opened a bug for the datepicker problem, which might or might not be related
http://www.rudder-project.org/redmine/issues/3425

- Rule: Global time settings
  - Directive: Global time settings
    - Component: Time zone
      - Value: None
      - Message: Time zone could not be set (localtime file could not be changed)
      - Status: Error

Did you also get that the calendar is (partly) in French?

Dennis Cabooter wrote:

[...]

Did you also get that the calendar is (partly) in French?

Yes, that's the ticket http://www.rudder-project.org/redmine/issues/3425
It may looks related, but not completly, hence the new ticket

Removing /etc/localtime makes the following error dissappear:

R: @@ntpConfiguration@@result_error@@87cd8f51-de03-43e4-88ea-bb4d55c27878@@342fc6d5-9399-4a93-87e0-9c7efd2d9727@@19@@Time 
zone@@None@@2013-04-1213:05:34+02:00##root@#Time zone could not be set (localtime file could not be changed)

After running cf-agent -KI a symlink is created:

lrwxrwxrwx 1 root root 25 Apr 12 11:07 /etc/localtime -> ../posix/Europe/Amsterdam

Running cf-agent -KI now produces the following output:

 -> Link /etc/localtime as promised
R: @@ntpConfiguration@@log_info@@87cd8f51-de03-43e4-88ea-bb4d55c27878@@342fc6d5-9399-4a93-87e0-9c7efd2d9727@@19@@Time zone@@None@@2013-04-12 
11:07:46+00:00##root@#Time zone was already set (localtime file didn't need changing)

I will create a separate issue from the last post, since it has nothing to do with this issue.

This separate issue mentioned here is awaiting a review.

Hello Dennis,

About your problem with search, could you please:

- validate that you have at least one accepted node with a value for "Inventory date" (on node detail, it's in tab "node summary", in "Rudder information" section) - that is just to be sure :)
- set Rudder log level to "debug" (change <root level="info"> to <root level="debug"> in /opt/rudder/etc/logback.xml
- restart Rudder, now you should be able to see how Rudder translate search into LDAP queries. For example, for a search with parameter "Node summaray, Last inventory date, =<, 23/09/2011", I see:

[2013-04-16 14:11:54] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [692208163279] Start search for { returnType:'NodeReturnType' with 'And' criteria [node.inventoryDate lteq 23/09/2011] }
[2013-04-16 14:11:54] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [692208163279] |- LDAPObjectType(ou=Nodes,ou=Accepted Inventories,ou=Inventories,cn=rudder-configuration,One,Some((inventoryDate<=20110922220000.000Z)),DNJoin,Set())
[2013-04-16 14:11:54] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [692208163279] |--- SearchRequest(baseDN='ou=Nodes,ou=Accepted Inventories,ou=Inventories,cn=rudder-configuration', scope=ONE, deref=NEVER, sizeLimit=1000, timeLimit=10, filter='(inventoryDate<=20110922220000.000Z)', attrs={policyServerId, osFullName, localAdministratorAccountName, cn, createTimestamp, agentName, ipHostNumber, publicKey, nodeId, nodeHostname, objectClass})
[2013-04-16 14:11:54] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [692208163279] |---- 1 result(s)
[2013-04-16 14:11:54] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [692208163279] `-> 1 results

When you have such a query log available, could you post it so that we can be sure that the date is correctly interpreted or if we see other strange things ?

Thanks for your help, I hope we will be able to find a solution soon.

[2013-05-07 11:41:33] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [181942231907] Start search for { returnType:'NodeReturnType' with 'And' criteria [node.inventoryDate eq 07/05/2013] }
[2013-05-07 11:41:33] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [181942231907] |- LDAPObjectType(ou=Nodes,ou=Accepted Inventories,ou=Inventories,cn=rudder-configuration,One,Some((inventoryDate=20130506220000.000Z)),DNJoin,Set())
[2013-05-07 11:41:33] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [181942231907] |--- SearchRequest(baseDN='ou=Nodes,ou=Accepted Inventories,ou=Inventories,cn=rudder-configuration', scope=ONE, deref=NEVER, sizeLimit=1000, timeLimit=10, filter='(inventoryDate=20130506220000.000Z)', attrs={policyServerId, osFullName, localAdministratorAccountName, cn, createTimestamp, agentName, ipHostNumber, publicKey, nodeId, nodeHostname, objectClass})
[2013-05-07 11:41:33] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [181942231907] |---- 0 result(s)
[2013-05-07 11:41:33] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [181942231907] `-> 0 results

This is the debug log if I use < instead of =

[2013-05-07 11:46:42] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [949770325652] Start search for { returnType:'NodeReturnType' with 'And' criteria [node.inventoryDate lt 07/05/2013] }
[2013-05-07 11:46:42] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [949770325652] |- LDAPObjectType(ou=Nodes,ou=Accepted Inventories,ou=Inventories,cn=rudder-configuration,One,Some((&(inventoryDate=*)(!(inventoryDate>=20130506220000.000Z)))),DNJoin,Set())
[2013-05-07 11:46:42] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [949770325652] |--- SearchRequest(baseDN='ou=Nodes,ou=Accepted Inventories,ou=Inventories,cn=rudder-configuration', scope=ONE, deref=NEVER, sizeLimit=1000, timeLimit=10, filter='(&(inventoryDate=*)(!(inventoryDate>=20130506220000.000Z)))', attrs={policyServerId, osFullName, localAdministratorAccountName, cn, createTimestamp, agentName, ipHostNumber, publicKey, nodeId, nodeHostname, objectClass})
[2013-05-07 11:46:42] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [949770325652] |---- 2 result(s)
[2013-05-07 11:46:42] DEBUG com.normation.rudder.services.queries.InternalLDAPQueryProcessor - [949770325652] `-> 2 results

Applied in changeset 97b5d1106a9a10a2f9cc830acfddb1e6b3095ec6.