OpenEMM 2013 WS GetSubscriber searching for customer 0?

[johanntagle]

Before anything, thank you for making this product open source. So far it has performed way better than a certain commercial product my company was using. I'm in the process of installing 2013 R2 on a new machine but would like to ask about this problem I'm encountering using Webservice 2.0 (on 2013 R1). I can successfully call ListMailings and ListMailinglists, so I my authentication looks okay, but when I call GetSubscriber, here's what I see in daily.log:

Code: Select all

2014-07-22 02:35:20,321: DEBUG [http-8080-4] org.agnitas.web.filter.OpenSessionInViewFilter - Using SessionFactory 'sessionFactory' for OpenSessionInViewFilter
2014-07-22 02:35:20,321: DEBUG [http-8080-4] org.agnitas.web.filter.OpenSessionInViewFilter - Opening single Hibernate Session in OpenSessionInViewFilter
2014-07-22 02:35:20,321: DEBUG [http-8080-4] org.springframework.ws.transport.http.WebServiceMessageReceiverHandlerAdapter - Accepting incoming [org.springframework.ws.transport.http.HttpServletConnection@b40a4b5] to [http://openemm.friendster.net:8080/openemm-ws2/]
2014-07-22 02:35:20,355: DEBUG [http-8080-4] org.springframework.ws.server.MessageTracing.received - Received request [<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins0="http://agnitas.org/ws/schemas" xmlns:sch="http://agnitas.org/ws/definitions" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><env:Header><wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"><wsse:UsernameToken xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="UsernameToken-1"><wsse:Username>ws-user</wsse:Username><wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">MzU2ZTEyYmQzMjEyOTY1MzNlMGM3YjUyYjVhYzg1OWQ5NTljMWNmNQ==
</wsse:Nonce><wsu:Created>2014-07-22T02:35:19Z</wsu:Created><wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordDigest">FQAYfFU0uDmctxjMe+2yItSmEQs=</wsse:Password></wsse:UsernameToken></wsse:Security></env:Header><env:Body><ins0:GetSubscriberRequest><sch:customerID>208539</sch:customerID></ins0:GetSubscriberRequest></env:Body></env:Envelope>]
2014-07-22 02:35:20,358: DEBUG [http-8080-4] org.agnitas.emm.springws.security.SpringDigestPasswordValidationCallbackHandler - Authentication success: org.springframework.security.providers.UsernamePasswordAuthenticationToken@b4ef6fe5: Principal: org.springframework.security.userdetails.User@ff827e00: Username: ws-user; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: USER_1; Password: [PROTECTED]; Authenticated: false; Details: null; Not granted any authorities
2014-07-22 02:35:20,358: DEBUG [http-8080-4] org.agnitas.emm.springws.endpoint.recipient.GetSubscriberEndpoint - Unmarshalled payload request to [org.agnitas.emm.springws.jaxb.GetSubscriberRequest@d34bd4b]
2014-07-22 02:35:20,360: INFO  [http-8080-4] org.agnitas.dao.impl.RecipientDaoImpl - getCustomerDataFromDb: SELECT * FROM customer_1_tbl WHERE customer_id=0
2014-07-22 02:35:20,360: DEBUG [http-8080-4] org.agnitas.emm.springws.endpoint.recipient.GetSubscriberEndpoint - Marshalling [org.agnitas.emm.springws.jaxb.GetSubscriberResponse@1b7a59c7] to response payload
2014-07-22 02:35:20,361: DEBUG [http-8080-4] org.springframework.ws.server.MessageTracing.sent - Sent response [<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><ns2:GetSubscriberResponse xmlns:ns2="http://agnitas.org/ws/schemas"><ns2:customerID>0</ns2:customerID></ns2:GetSubscriberResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>] for request [<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins0="http://agnitas.org/ws/schemas" xmlns:sch="http://agnitas.org/ws/definitions" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><env:Header><wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"><wsse:UsernameToken xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="UsernameToken-1"><wsse:Username>ws-user</wsse:Username><wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">MzU2ZTEyYmQzMjEyOTY1MzNlMGM3YjUyYjVhYzg1OWQ5NTljMWNmNQ==
</wsse:Nonce><wsu:Created>2014-07-22T02:35:19Z</wsu:Created><wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordDigest">FQAYfFU0uDmctxjMe+2yItSmEQs=</wsse:Password></wsse:UsernameToken></wsse:Security></env:Header><env:Body><ins0:GetSubscriberRequest><sch:customerID>208539</sch:customerID></ins0:GetSubscriberRequest></env:Body></env:Envelope>]
2014-07-22 02:35:20,361: DEBUG [http-8080-4] org.springframework.ws.transport.http.MessageDispatcherServlet - Successfully completed request
2014-07-22 02:35:20,362: DEBUG [http-8080-4] org.agnitas.web.filter.OpenSessionInViewFilter - Closing single Hibernate Session in OpenSessionInViewFilter

Why is it doing SELECT * FROM customer_1_tbl WHERE customer_id=0 ? What is wrong with my request format?

Thanks.

[johanntagle]

Okay I think I got it... my soap client didn't put the proper namespace.