DataSourceRealm documentation

[Carol Cheung]

Hi,

I'm reading about DataSourceRealm at
http://tomcat.apache.org/tomcat-5.5-doc/realm-howto.html
and step 2 under "Quick Start" is confusing.

It says "Configure a database username and password for use by Tomcat ..."
What does this mean? What should the username and password be and where
should they be located so that they are configured for use by Tomcat?

There's no username or password specified in the example Realm element
under the DataSourceRealm section.

Thanks,
Carol

---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Caldarale, Charles R]

> From: Carol Cheung [mailto:cacheung@...]
> Subject: DataSourceRealm documentation
>
> It says "Configure a database username and password for use
> by Tomcat ..."
> What does this mean? What should the username and password be
> and where
> should they be located so that they are configured for use by Tomcat?

You appear to have skipped over this rather critical step:

"3. Configure a JNDI named JDBC DataSource for your database. Refer to the JNDI DataSource Example HOW-TO for information on how to configure a JNDI named JDBC DataSource."

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.

---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[awarnier]

Carol Cheung wrote:

> Hi,
>
> I'm reading about DataSourceRealm at
> http://tomcat.apache.org/tomcat-5.5-doc/realm-howto.html
> and step 2 under "Quick Start" is confusing.
>
> It says "Configure a database username and password for use by Tomcat ..."
> What does this mean? What should the username and password be and where
> should they be located so that they are configured for use by Tomcat?
>
> There's no username or password specified in the example Realm element
> under the DataSourceRealm section.
>

Keep looking around there.  I can't tell you where exactly anymore, but
I was browsing that a few days ago and I remember seeing a place where
they described what the table should be named, what the columns should
be, etc..  (or else they are just talking there of the
"tomcat-users.xml" file in the conf directory.)
Of course you can pick any name and password value you choose, as long
as that user is given the appropriate role for your application (e.g.
"manager" for the Manager application).

André

P.S. The above is all I think I know about this theme.


---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Steve Ochani]

On 21 Jul 2008 at 17:37, Carol Cheung wrote:

Date sent:       Mon, 21 Jul 2008 17:37:29 -0400
From:           Carol Cheung <cacheung@...>
Subject:         DataSourceRealm documentation
To:             Tomcat Users List <users@...>
Send reply to:   Tomcat Users List <users@...>

> Hi,
>
> I'm reading about DataSourceRealm at
> http://tomcat.apache.org/tomcat-5.5-doc/realm-howto.html
> and step 2 under "Quick Start" is confusing.
>
> It says "Configure a database username and password for use by
> Tomcat ..."
> What does this mean? What should the username and password be and
> where
> should they be located so that they are configured for use by
> Tomcat?
>

It means make a username/password (account) on the database server. The complete
sentence is:

"Configure a database username and password for use by Tomcat, that has at least read
only access to the tables described above. (Tomcat will never attempt to write to these
tables.)"



-Steve O.

> There's no username or password specified in the example Realm
> element
> under the DataSourceRealm section.
>
> Thanks,
> Carol
>
> --------------------------------------------------------------------
> -
> To start a new topic, e-mail: users@...
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>

---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Caldarale, Charles R]

> From: André Warnier [mailto:aw@...]
> Subject: Re: DataSourceRealm documentation
>
> Of course you can pick any name and password value you choose, as long
> as that user is given the appropriate role for your application (e.g.
> "manager" for the Manager application).

The OP is not asking about the userid and password clients use to access an app but rather the userid and password Tomcat uses to access the database containing client userid and passwords.  The database credentials are specified in an appropriate <Resource> element.

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.

---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[awarnier]

Caldarale, Charles R wrote:
>> From: André Warnier [mailto:aw@...]
>> Subject: Re: DataSourceRealm documentation
>>

> The OP is not asking about the userid and password clients use to access an app but rather the userid and password Tomcat uses to access the database containing client userid and passwords.  The database credentials are specified in an appropriate <Resource> element.
>
>  - Chuck
>
Oops, sorry.  I have seen the error of my ways, and by now I think the
OP has seen his too.

---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Sameer Acharya]

It means that on whichever database you are using to store your authentication information  you need to create a user id and password for Tomcat to connect to it and then read the information.

Your database doc. will give instructions on creating user/pass on it. For eg. you can create user/password as tcuser/mypassword.

You then need to configure a Datasource in Tomcat which can be used by Tomcat to connect to this database and read the proper tables for authentication. Read the Datasource related docs.

http://tomcat.apache.org/tomcat-5.5-doc/config/realm.html

These instructions are for authentication information stored in a relational database that can be accessed by proper JDBC driver an example would be MySQL.

If you are storing authentication information in LDAP server then read that section.

-Sameer


--- On Tue, 7/22/08, Carol Cheung <cacheung@...> wrote:

> From: Carol Cheung <cacheung@...>
> Subject: DataSourceRealm documentation
> To: "Tomcat Users List" <users@...>
> Date: Tuesday, July 22, 2008, 3:07 AM
> Hi,
>
> I'm reading about DataSourceRealm at
> http://tomcat.apache.org/tomcat-5.5-doc/realm-howto.html
> and step 2 under "Quick Start" is confusing.
>
> It says "Configure a database username and password
> for use by Tomcat ..."
> What does this mean? What should the username and password
> be and where
> should they be located so that they are configured for use
> by Tomcat?
>
> There's no username or password specified in the
> example Realm element
> under the DataSourceRealm section.
>
> Thanks,
> Carol
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@...
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail:
> users-help@...

     

---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Pid-2]

Carol Cheung wrote:
> Hi,
>
> I'm reading about DataSourceRealm at
> http://tomcat.apache.org/tomcat-5.5-doc/realm-howto.html
> and step 2 under "Quick Start" is confusing.
>
> It says "Configure a database username and password for use by Tomcat ..."
> What does this mean? What should the username and password be and where
> should they be located so that they are configured for use by Tomcat?

It means that you need to configure a DataSource for use by the Realm.

> There's no username or password specified in the example Realm element
> under the DataSourceRealm section.

Correct, just the reference to the DataSource.

p


> Thanks,
> Carol
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@...
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>


---------------------------------------------------------------------
To start a new topic, e-mail: users@...
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...