You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Robert Lee <Ro...@rcn.com> on 2013/04/07 17:58:32 UTC
getAuthenticatedUser()
I removed the UserPeer class in TR.props that you mentioned. The call
still fails.
I have attached the MySQL log at the bottom of this and all the select
fields are filled in as you suggest.
But I am still uncertain of how to proceed further.
The following is the trace back from my failed call to
getAuthenticatedUser()
mycode.java
import org.apache.turbine.om.security.User;
User AuthUser = TurbineSecurity.getAuthenticatedUser("user", "password");
thrown from TorqueUserManager at accountExists(user.getName());
public boolean accountExists(User user)
throws DataBackendException
{
return accountExists(user.getName());
}
thrown from TorqueUserManager at if(!accountExists(user))
public void authenticate(User user, String password)
throws PasswordMismatchException, UnknownEntityException,
DataBackendException
{
if (!accountExists(user))
{
throw new UnknownEntityException("The account '" +
user.getName() + "' does
not exist");
}
// log.debug("Supplied Pass: " + password);
// log.debug("User Pass: " + user.getPassword());
/*
* Unix crypt needs the existing, encrypted password text as
* salt for checking the supplied password. So we supply it
* into the checkPassword routine
*/
if (!TurbineSecurity.checkPassword(password, user.getPassword()))
{
throw new PasswordMismatchException("The passwords do not
match");
}
}
thrown from TorqueUserManager at authenticate(userName)
public User retrieve(String userName, String password)
throws PasswordMismatchException, UnknownEntityException,
DataBackendException
{
User user = retrieve(userName);
authenticate(user, password);
return user;
}
thrown from the TurbineSecurity at getUserManager().retrieve(username,
password)
public User getAuthenticatedUser(String username, String password)
throws DataBackendException, UnknownEntityException,
PasswordMismatchException
{
return getUserManager().retrieve(username, password);
}
thrown from TurbineSecurity at
getService().getAuthenticatedUser(username, password)
public static User getAuthenticatedUser(String username, String password)
throws DataBackendException, UnknownEntityException,
PasswordMismatchException
{
return getService().getAuthenticatedUser(username, password);
}
I believe that I am having a problem with retrieve or retrieveList
(neither of which thow an error) in TorqueUserManager
public User retrieve(String userName)
throws UnknownEntityException, DataBackendException
{
Criteria criteria = new Criteria();
criteria.add(UserPeerManager.getNameColumn(), userName);
List users = retrieveList(criteria);
if (users.size() > 1)
{
throw new DataBackendException(
"Multiple Users with same username '" + userName + "'");
}
if (users.size() == 1)
{
return (User) users.get(0);
}
throw new UnknownEntityException("Unknown user '" + userName +
"'");
}
public List retrieveList(Object criteria)
throws DataBackendException
{
if (criteria instanceof Criteria)
{
Criteria c = (Criteria)criteria;
for (Iterator keys = c.keySet().iterator(); keys.hasNext(); )
{
String key = (String) keys.next();
// set the table name for all attached criterion
Criteria.Criterion[] criterion =
c.getCriterion(key).getAttachedCriterion();
for (int i = 0; i < criterion.length; i++)
{
if (StringUtils.isEmpty(criterion[i].getTable()))
{
criterion[i].setTable(UserPeerManager.getTableName());
}
}
}
List users = null;
try
{
users = UserPeerManager.doSelect(c);
}
catch (Exception e)
{
throw new DataBackendException("Failed to retrieve
users", e);
}
return users;
}
If I execute the following code, which is based on these routines:
List users = null;
if(TurbineSecurity.accountExists("user"))
{
log.trace("isAuthorized(PipelineData)
TurbineSecurity.acccountExists=true");
Criteria criteria = new Criteria();
criteria.add(UserPeerManager.getNameColumn(), "user");
//criteria.addSelectColumn("*");
log.trace("isAuthorized(PipelineData)
criteria.getDbName()="+criteria.getDbName()+",
getTable="+criteria.getSelectColumns());
log.trace("isAuthorized(PipelineData)
keyset="+criteria.keySet().toString());
String query = BasePeer.createQueryString(criteria);
log.trace("isAuthorized(PipelineData) query="+query);
for(Iterator keys =
criteria.keySet().iterator();keys.hasNext();)
{
String key = (String) keys.next();
log.trace("isAuthorized(PipelineData) key="+key+",
Table="+UserPeerManager.getTableName());
Criteria.Criterion[] criterion =
criteria.getCriterion(key).getAttachedCriterion();
log.trace("isAuthorized(PipelineData)
criterion.length="+criterion.length);
for(int i=0; i < criterion.length; i++)
{
if(StringUtils.isEmpty(criterion[i].getTable()))
{
log.trace("isAuthorized(PipelineData) setting Table["+i+"]");
criterion[i].setTable(UserPeerManager.getTableName());
}
}
users = UserPeerManager.doSelect(criteria);
log.trace("isAuthorized(PipelineData)
UserPeerManager.doSelect(Criteria) size="+users.size());
log.trace("isAuthorized(PipelineData)
UserPeerManager.doSelect(Criteria) users.toString()="+users.toString());
for(Iterator userx = users.iterator();
userx.hasNext(); )
{
User usr = (User)userx.next();
if(usr != null)
{
log.trace("isAuthorized(PipelineData) usr.next()="+usr.toString());
log.trace("isAuthorized(PipelineData)
usr="+usr.getId()+",N="+usr.getName()+", P="+usr.getPassword());
}
else
{
log.trace("isAuthorized(PipelineData) usr==null");
}
}
}
I get the following tracelog:
isAuthorized(PipelineData) TurbineSecurity.acccountExists=true
isAuthorized(PipelineData) criteria.getDbName()=TurbineTest, getTable=[]
isAuthorized(PipelineData) keyset=[TURBINE_USER.LOGIN_NAME]
isAuthorized(PipelineData) query=SELECT FROM TURBINE_USER WHERE
TURBINE_USER.LOGIN_NAME='user'
isAuthorized(PipelineData) key=TURBINE_USER.LOGIN_NAME, Table=TURBINE_USER
isAuthorized(PipelineData) criterion.length=1
isAuthorized(PipelineData) UserPeerManager.doSelect(Criteria) size=1
isAuthorized(PipelineData) UserPeerManager.doSelect(Criteria)
users.toString()=[null]
isAuthorized(PipelineData) usr==null
isAuthorized(PipelineData) UserPeerManager.doSelect(critera) size=1
isAuthorized(PipelineData) TurbineSecurity.getUser("user") returns null
isAuthorized ERROR=null
org.apache.turbine.services.security.torque.TorqueUserManager:accountExists(84)
org.apache.turbine.services.security.torque.TorqueUserManager:authenticate(349)
org.apache.turbine.services.security.torque.TorqueUserManager:retrieve(269)
org.apache.turbine.services.security.BaseSecurityService:getAuthenticatedUser(684)
org.apache.turbine.services.security.TurbineSecurity:getAuthenticatedUser(263)
com.in10Software.TurbineTest.modules.screens.TurbineTestSecureScreen:isAuthorized(122)
There is no SELECT column list in the generated statement
However, I have probably missed something because I get the following
trace from SQL.
| event_time | user_host |
thread_id | server_id | command_type | argument |
| 2013-04-07 11:34:47 | [Turbine] @ localhost [127.0.0.1] |
235 | 0 | Connect | Turbine@localhost on TurbineTest
| 2013-04-07 11:34:47 | Turbine[Turbine] @ localhost [127.0.0.1] |
235 | 0 | Query | /* mysql-connector-java-5.1.21 (
Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variabl
e_name ='language' OR Variable_name = 'net_write_timeout' OR
Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout'
OR Variable_name = 'character_set_client' OR Variable_name = 'chara
cter_set_connection' OR Variable_name = 'character_set' OR Variable_name
= 'character_set_server' OR Variable_name = 'tx_isolation' OR
Variable_name = 'transaction_isolation' OR Variable_name = 'chara
cter_set_results' OR Variable_name = 'timezone' OR Variable_name =
'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name =
'lower_case_table_names' OR Variable_name = 'max_allowed_packet'
OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode'
OR Variable_name = 'query_cache_type' OR Variable_name =
'query_cache_size' OR Variable_name = 'init_connect' |
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
235 | 0 | Query | /* mysql-connector-java-5.1.21 (
Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increm
ent_increment
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
235 | 0 | Query | SHOW COLLATION
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
235 | 0 | Query | SET NAMES latin1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
235 | 0 | Query | SET character_set_results = NULL
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
235 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
235 | 0 | Quit |
| 2013-04-07 11:34:48 | [Turbine] @ localhost [127.0.0.1] |
236 | 0 | Connect | Turbine@localhost on TurbineTest
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | /* mysql-connector-java-5.1.21 (
Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variabl
e_name ='language' OR Variable_name = 'net_write_timeout' OR
Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout'
OR Variable_name = 'character_set_client' OR Variable_name = 'chara
cter_set_connection' OR Variable_name = 'character_set' OR Variable_name
= 'character_set_server' OR Variable_name = 'tx_isolation' OR
Variable_name = 'transaction_isolation' OR Variable_name = 'chara
cter_set_results' OR Variable_name = 'timezone' OR Variable_name =
'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name =
'lower_case_table_names' OR Variable_name = 'max_allowed_packet'
OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode'
OR Variable_name = 'query_cache_type' OR Variable_name =
'query_cache_size' OR Variable_name = 'init_connect' |
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | /* mysql-connector-java-5.1.21 (
Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increm
ent_increment
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SHOW COLLATION
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET NAMES latin1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET character_set_results = NULL
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT TURBINE_USER.USER_ID,
TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USE
R.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 WH
ERE TURBINE_USER.LOGIN_NAME='user'
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT TURBINE_USER.USER_ID,
TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USE
R.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 WH
ERE TURBINE_USER.LOGIN_NAME='user'
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT TURBINE_USER.USER_ID,
TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USE
R.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 WH
ERE TURBINE_USER.LOGIN_NAME='user'
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT TURBINE_USER.USER_ID,
TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USE
R.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 WH
ERE TURBINE_USER.LOGIN_NAME='user'
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT Family.Family_ID, Family.Name
FROM Family
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT TURBINE_ROLE.ROLE_ID,
TURBINE_ROLE.ROLE_NAME FROM TURBINE_PERMISSION, TURBINE_ROLE_PERM
ISSION, TURBINE_ROLE WHERE
TURBINE_PERMISSION.PERMISSION_ID=TURBINE_ROLE_PERMISSION.PERMISSION_ID
AND TURBINE_ROLE_PERMISSION.ROLE_ID=TURBINE_ROLE.ROLE_ID
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT 1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SET autocommit=1
| 2013-04-07 11:34:48 | Turbine[Turbine] @ localhost [127.0.0.1] |
236 | 0 | Query | SELECT TURBINE_USER.USER_ID,
TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE, TURBINE_USE
R.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 WH
ERE TURBINE_USER.LOGIN_NAME='user'
Re: Antwort: Re: getAuthenticatedUser()
Posted by Robert Lee <Ro...@rcn.com>.
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 <Ro...@rcn.com>
>
> An: Turbine Users List <us...@turbine.apache.org>,
>
> 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: user-unsubscribe@turbine.apache.org
> For additional commands, e-mail: user-help@turbine.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@turbine.apache.org
> For additional commands, e-mail: user-help@turbine.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@turbine.apache.org
> For additional commands, e-mail: user-help@turbine.apache.org
>
>
>
Antwort: Re: getAuthenticatedUser()
Posted by Georg Kallidis <ge...@cedis.fu-berlin.de>.
strange, just an idea: Have you tried to add the parameter
useConfigs=3-0-Compat to mysql connection.url?
Von: Robert Lee <Ro...@rcn.com>
An: Turbine Users List <us...@turbine.apache.org>,
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: user-unsubscribe@turbine.apache.org
For additional commands, e-mail: user-help@turbine.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@turbine.apache.org
For additional commands, e-mail: user-help@turbine.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@turbine.apache.org
For additional commands, e-mail: user-help@turbine.apache.org
Re: getAuthenticatedUser()
Posted by Thomas Vandahl <tv...@apache.org>.
On 08.04.2013 15:27, Robert Lee wrote:
> The section that I am concerned about is the one with the null username;
[...]
> 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=''
This belongs to the getAnonymousUser() call. No need to worry, this is
perfecly fine.
Bye, Thomas.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@turbine.apache.org
For additional commands, e-mail: user-help@turbine.apache.org
Re: getAuthenticatedUser()
Posted by Robert Lee <Ro...@rcn.com>.
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: user-unsubscribe@turbine.apache.org
> For additional commands, e-mail: user-help@turbine.apache.org
>
>
>
Re: getAuthenticatedUser()
Posted by Thomas Vandahl <tv...@apache.org>.
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: user-unsubscribe@turbine.apache.org
For additional commands, e-mail: user-help@turbine.apache.org