tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcel Bariou" <bar...@brasnah.com>
Subject Re: Connecting to mysql - Server configuration denies accessto data source
Date Wed, 30 Oct 2002 20:43:54 GMT
Wiith correct privileges on MySQL, I can't login. May be a bad definition of
ResourceLink attribut, look to my current post.

Marcel
----- Original Message -----
From: Jean-Luc BEAUDET <beaudet@cyber.kodak.com>
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
Sent: Wednesday, October 30, 2002 3:33 PM
Subject: Re: Connecting to mysql - Server configuration denies accessto data
source


>   Well i don't have all the whole pb cause i just set up my brand new
> netscape....
>
> It seems yu got in troubles with connection to mysql database. I just
> made it yesterday night to have my Tomcat's manager properly set up...
>
> First make yur database and tables. I can give yu a .sql script.
> Second, under sql admin, create a user who'll handle this database:
>  user: tomcat, password: tompass.
> They are many ways to do it, but on i use to is - assuming the db is
> called tomcatusers -
>
> GRANT ALL PRIVILEGES ON tomcatusers.* TO tomcat@localhost IDENTIFIED BY
> 'tompass';
>
> If all is OK, yu can then test it with:
>
> shell# mysql -u tomcat -p
> password:
> bla bla ../..
> mysql> connect tomcatusers;
> bla bla ../..
> mysql>mysql> show tables;
> +-----------------------+
> | Tables_in_tomcatusers |
> +-----------------------+
> | roles                 |
> | user_roles            |
> | users                 |
> +-----------------------+
> 3 rows in set (0.00 sec)
>
> mysql>
>
> After that, yu have to modify the server.xml according to the Tomcat's
doc.
>
>
> For instance:
>       <!-- Because this Realm is here, an instance will be shared
> globally -->
>       <!-- <Realm className="org.apache.catalina.realm.MemoryRealm" /> -->
>       <!-- Test with a JDBCRealm connected to a MySQL DataBase -->
>       <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
>              driverName="org.gjt.mm.mysql.Driver"
>              connectionURL="jdbc:mysql://localhost/tomcatusers"
>              connectionName="tomcat" connectionPassword="tompass"
>              userTable="users" userNameCol="user_name"
> userCredCol="user_pass"
>              userRoleTable="user_roles" roleNameCol="role_name" />
>
> Hope this help.
>
> JLB :O)
>
> Sam Taylor wrote:
>
> >you might also want to check that you haven't exceeded your max
connections
> >to mysql...
> >
> > -----Original Message-----
> >From: Larry Meadors [mailto:Larry.Meadors@plumcreek.com]
> >Sent: Wednesday, October 30, 2002 8:31 AM
> >To: tomcat-user@jakarta.apache.org
> >Subject: RE: Connecting to mysql - Server configuration denies accessto
data
> >source
> >
> >I got this a long time ago, so if I am wrong, sorry.
> >
> >Look in the user table in mysql, and you will find that each user is
> >associated with a host. The user you have in your datasource gets a
> >hostname added to it (i.e., lmeadors@mylinuxbox instead of just
> >lmeadors) and that combination is not valid in your mysql user table.
> >
> >Thanks for the reminder, I have a mysql database to setup today. ;-)
> >
> >Larry
> >
> >PS: BTW,
> > John is right - please be more specific in your posts, you will
> >get much better responses.
> >
> >
> >>>>JTurner@AAS.com 10/30/02 06:06 AM >>>
> >>>>
> >
> >Has anybody seen what?  Please be more specific.
> >
> >John
> >
> >>-----Original Message-----
> >>From: Kevin Passey [mailto:kpassey@kdpsoftware.co.uk]
> >>Sent: Wednesday, October 30, 2002 6:50 AM
> >>To: Tomcat Users List (E-mail)
> >>Subject: Connecting to mysql - Server configuration denies access to
> >>data source
> >>
> >>
> >>Has anybody seen this.
> >>
> >>I've set the mysql tables correctly.
> >>
> >>Can anybody shed any light on this.
> >>
> >>Thanks
> >>
> >>Kevin Passey
> >>KDP Software Limited
> >>Tel: 01273 712830
> >>Fax: 08700 510103
> >>mailto:kpassey@kdpsoftware.co.uk
> >>http://www.kdpsoftware.co.uk
> >>
> >>--
> >>To unsubscribe, e-mail:
> >><mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> >>For ad
> >>ditional commands, e-mail:
> >><mailto:tomcat-user-help@jakarta.apache.org>
> >>
> >
> >--
> >To unsubscribe, e-mail:
> ><mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> >For additional commands, e-mail:
> ><mailto:tomcat-user-help@jakarta.apache.org>
> >
> >
> >
> >--
> >To unsubscribe, e-mail:
> ><mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> >For additional commands, e-mail:
> ><mailto:tomcat-user-help@jakarta.apache.org>
> >
> >
> >
> >
> >--
> >To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> >For additio
> >nal commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>
> >
> >
>
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>
>
>
>


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message