You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Alexander Soudakov <so...@chem.psu.edu> on 2009/02/24 03:50:05 UTC

JDBCRealm authentication

Hi everybody,

I have a question about JDBCRealm authentication in Tomcat 5.5. I'm  
trying to use mysql database for authentication and I was wondering if  
it is possible to use just one single table with usernames, passwords  
and role names instead of two with usernames, passwords and with  
usernames, role names, as it is explained in the documentation. So, in  
the server.xml, in the JDBCRealm definition, I would use the same name  
for userTable and userRoleTable.

Thanks,
Alex

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Re: JDBCRealm authentication

Posted by Alexander Soudakov <so...@chem.psu.edu>.
Thanks, Troy,

It works indeed, but I understand why it is better to have two  
separate tables. Just needed to do it fast...

Thanks again,
Alex

On Feb 24, 2009, at 12:44 AM, Troy Davis wrote:

> Hi Alex,
>
> In most circumstances I would recommend otherwise, I've been  
> surprised by several apps I've written where users develop a need to  
> belong to multiple groups.
>
> But I've done the same thing for unusual circumstances, just give  
> the same table name for the realm's config values.
>
> HTH,
> Troy
>
>
>
> On Feb 23, 2009, at 9:50 PM, Alexander Soudakov <so...@chem.psu.edu>  
> wrote:
>
>> Hi everybody,
>>
>> I have a question about JDBCRealm authentication in Tomcat 5.5. I'm  
>> trying to use mysql database for authentication and I was wondering  
>> if it is possible to use just one single table with usernames,  
>> passwords and role names instead of two with usernames, passwords  
>> and with usernames, role names, as it is explained in the  
>> documentation. So, in the server.xml, in the JDBCRealm definition,  
>> I would use the same name for userTable and userRoleTable.
>>
>> Thanks,
>> Alex
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>

==================================
Alexander Soudackov
Research Assistant Professor
Department of Chemistry
Pennsylvania State University
104 Chemistry Bldg
University Park, PA 16802
----------------------------------
Phone:	(814) 865-1354
Fax: 	(814) 863-5319
E-mail: souda@chem.psu.edu
http://www.personal.psu.edu/avs10
==================================




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Re: JDBCRealm authentication

Posted by Troy Davis <tr...@editspot.com>.
Hi Alex,

In most circumstances I would recommend otherwise, I've been surprised  
by several apps I've written where users develop a need to belong to  
multiple groups.

But I've done the same thing for unusual circumstances, just give the  
same table name for the realm's config values.

HTH,
Troy



On Feb 23, 2009, at 9:50 PM, Alexander Soudakov <so...@chem.psu.edu>  
wrote:

> Hi everybody,
>
> I have a question about JDBCRealm authentication in Tomcat 5.5. I'm  
> trying to use mysql database for authentication and I was wondering  
> if it is possible to use just one single table with usernames,  
> passwords and role names instead of two with usernames, passwords  
> and with usernames, role names, as it is explained in the  
> documentation. So, in the server.xml, in the JDBCRealm definition, I  
> would use the same name for userTable and userRoleTable.
>
> Thanks,
> Alex
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org