Re: Antwort: Re: getAuthenticatedUser()
Robert Lee <[email protected]> Thu, 11 Apr 2013 10:43:50 -0400
| Newsgroups | gmane.comp.jakarta.turbine.user |
|---|---|
| Message-ID | <[email protected]> |
--------------080503020203000002090401 Content-Type: multipart/alternative; boundary="------------040009090701000503020305" --------------040009090701000503020305 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit No I didn't try it, but I did try using fulcrum to get at the permissions and other tables. The problem was not with the connection, but with commenting out #services.SecurityService.user.class = org.apache.turbine.services.security.torque.TorqueUser #services.SecurityService.group.class = org.apache.turbine.services.security.torque.TorqueGroup #services.SecurityService.permission.class = org.apache.turbine.services.security.torque.TorquePermission #services.SecurityService.role.class = org.apache.turbine.services.security.torque.TorqueRole I had put so much in the TR.props that I was trying to get back to a minimum. On 4/8/2013 11:33 AM, Georg Kallidis wrote: > strange, just an idea: Have you tried to add the parameter > useConfigs=3-0-Compat to mysql connection.url? > > > > Von: Robert Lee <[email protected]> > > An: Turbine Users List <[email protected]>, > > Datum: 08.04.2013 15:28 > > Betreff: Re: getAuthenticatedUser() > > > > > > > Thanks, I will continue looking at this. > The section that I am concerned about is the one with the null username; > 2013-04-07 19:08:08,658 [http-bio-80-exec-13] DEBUG > org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, > TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, > TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, > TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, > TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA > FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' > 2013-04-07 19:08:08,662 [http-bio-80-exec-13] DEBUG > org.apache.torque.util.BasePeer - Elapsed time=4 ms > 2013-04-07 19:08:08,673 [http-bio-80-exec-13] DEBUG > org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, > TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, > TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, > TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, > TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA > FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='' > 2013-04-07 19:08:08,673 [http-bio-80-exec-13] DEBUG > org.apache.torque.util.BasePeer - Elapsed time=0 ms > 2013-04-07 19:13:45,884 [http-bio-80-exec-19] DEBUG > org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, > TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, > TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, > TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, > TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA > FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' > 2013-04-07 19:13:45,889 [http-bio-80-exec-19] DEBUG > org.apache.torque.util.BasePeer - Elapsed time=5 ms > 2013-04-07 19:13:45,898 [http-bio-80-exec-19] DEBUG > org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, > TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, > TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, > TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, > TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA > FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' > 2013-04-07 19:13:45,899 [http-bio-80-exec-19] DEBUG > org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, > TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, > TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, > TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, > TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA > FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' > 2013-04-07 19:13:45,900 [http-bio-80-exec-19] DEBUG > org.apache.torque.util.BasePeer - Elapsed time=1 ms > 2013-04-07 19:13:45,901 [http-bio-80-exec-19] DEBUG > org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, > TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, > TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, > TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, > TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA > FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' > On 4/8/2013 2:32 AM, Thomas Vandahl wrote: > Hi Robert, > > On 07.04.2013 17:58, Robert Lee wrote: > thrown from TorqueUserManager at accountExists(user.getName > ()); > > public boolean accountExists(User user) > throws DataBackendException > { > return accountExists(user.getName()); > } > > If I dig further down in this code I get a call to > UserPeerManager.doSelect(Criteria) which directly calls the user > peer class method doSelect() via reflection. So everything looks > fine here. > > The error message you get comes from a BasePeer.doSelect(). I > cannot see a call to this method in the stack trace you mention. > > You may want to bump up the log level of the Turbine and Torque > loggers to DEBUG to see what really happens. > > Bye, Thomas. > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > --------------040009090701000503020305 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#FFFFFF"> No I didn't try it, but I did try using fulcrum to get at the permissions and other tables. The problem was not with the connection,<br> but with commenting out<br> <small>#services.SecurityService.user.class = org.apache.turbine.services.security.torque.TorqueUser <br> #services.SecurityService.group.class = org.apache.turbine.services.security.torque.TorqueGroup <br> #services.SecurityService.permission.class = org.apache.turbine.services.security.torque.TorquePermission <br> #services.SecurityService.role.class = org.apache.turbine.services.security.torque.TorqueRole </small><br> <br> I had put so much in the TR.props that I was trying to get back to a minimum.<br> <br> <div class="moz-cite-prefix">On 4/8/2013 11:33 AM, Georg Kallidis wrote:<br> </div> <blockquote cite="mid:OFE77C14EF.76A47B04-ONC1257B47.0054FEFD-C1257B47.00557C94@cedis.fu-berlin.de" type="cite"> <pre wrap="">strange, just an idea: Have you tried to add the parameter useConfigs=3-0-Compat to mysql connection.url? Von: Robert Lee <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]"><[email protected]></a> An: Turbine Users List <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]"><[email protected]></a>, Datum: 08.04.2013 15:28 Betreff: Re: getAuthenticatedUser() Thanks, I will continue looking at this. The section that I am concerned about is the one with the null username; 2013-04-07 19:08:08,658 [http-bio-80-exec-13] DEBUG org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' 2013-04-07 19:08:08,662 [http-bio-80-exec-13] DEBUG org.apache.torque.util.BasePeer - Elapsed time=4 ms 2013-04-07 19:08:08,673 [http-bio-80-exec-13] DEBUG org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='' 2013-04-07 19:08:08,673 [http-bio-80-exec-13] DEBUG org.apache.torque.util.BasePeer - Elapsed time=0 ms 2013-04-07 19:13:45,884 [http-bio-80-exec-19] DEBUG org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' 2013-04-07 19:13:45,889 [http-bio-80-exec-19] DEBUG org.apache.torque.util.BasePeer - Elapsed time=5 ms 2013-04-07 19:13:45,898 [http-bio-80-exec-19] DEBUG org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' 2013-04-07 19:13:45,899 [http-bio-80-exec-19] DEBUG org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' 2013-04-07 19:13:45,900 [http-bio-80-exec-19] DEBUG org.apache.torque.util.BasePeer - Elapsed time=1 ms 2013-04-07 19:13:45,901 [http-bio-80-exec-19] DEBUG org.apache.torque.util.SQLBuilder - SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE TURBINE_USER.LOGIN_NAME='user' On 4/8/2013 2:32 AM, Thomas Vandahl wrote: Hi Robert, On 07.04.2013 17:58, Robert Lee wrote: thrown from TorqueUserManager at accountExists(user.getName ()); public boolean accountExists(User user) throws DataBackendException { return accountExists(user.getName()); } If I dig further down in this code I get a call to UserPeerManager.doSelect(Criteria) which directly calls the user peer class method doSelect() via reflection. So everything looks fine here. The error message you get comes from a BasePeer.doSelect(). I cannot see a call to this method in the stack trace you mention. You may want to bump up the log level of the Turbine and Torque loggers to DEBUG to see what really happens. Bye, Thomas. --------------------------------------------------------------------- To unsubscribe, e-mail: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> For additional commands, e-mail: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> --------------------------------------------------------------------- To unsubscribe, e-mail: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> For additional commands, e-mail: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> --------------------------------------------------------------------- To unsubscribe, e-mail: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> For additional commands, e-mail: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> </pre> </blockquote> <br> </body> </html> --------------040009090701000503020305-- --------------080503020203000002090401 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------080503020203000002090401--