David. many thanks.
worked like a charm Randy At 07:50 AM 3/6/2002, you wrote: >I just posted to another thread on this eact problem issue. The example >MySQL realm in server.xml is wrong. MySQL uses an amperstand character (&) >between the user and password parameters in the URL. Here is the correct URL >for making a connection to a MySQL database: > >connectionURL="jdbc:mysql://crypton:3306/authority?user=tkadmin&password=tkadmin" > >& is used because XML standards require the & symbol be expressed this >way. > >Hope this helps you out. > >--David > >On Wednesday 06 March 2002 12:50 am, you wrote: > > This is a permissions problem on your system. The error means what it > > says. > > > > At 12:22 PM 3/5/02 -0800, you wrote: > > >Setting up Tomcat & Mysql is documented on the Tomcat > > >website. Look at the documentation link and then > > >under realms. There is a discussion of using database > > >for authentication and MySQL is the example they show > > >for the deployment descriptors. > > > > > >There is also an excellent book out called "JSP, > > >MYSQL, and Servlet Development" or something close. > > >It documents the process well too. > > > > > >Tim > > > > > >--- [EMAIL PROTECTED] wrote: > > > > Hi, > > > > > > > > I have been trying to setup JDBC Realm authen with > > > > mysql and have hit a > > > > dead end. > > > > I have been following the posts but my errors don't > > > > match what others are > > > > getting. > > > > I'm sure this is a config error on my part but I > > > > just can't seem to figure > > > > it out. > > > > > > > > > > > > When trying to startup Tomact 4 I get the following > > > > error in catalina.out I > > > > have also attached the > > > > relavant server.xml entries. > > > > > > > > > > > > SERVER.XML > > > > > > > > <Realm > > > > className="org.apache.catalina.realm.JDBCRealm" > > > > debug="99" > > > > driverName="org.gjt.mm.mysql.Driver" > > > > > >connectionURL="jdbc:mysql://crypton:3306/authority?user=tkadmin;password=t > > >kadmin" > > > > > > > userTable="users" > > > > userNameCol="user_name" > > > > userCredCol="user_pass" > > > > userRoleTable="user_roles" > > > > roleNameCol="role_name" /> > > > > > > > > > > > > CATALINA.OUT error > > > > > > > > Starting service Tomcat-Standalone > > > > Apache Tomcat/4.0.3 > > > > Catalina.start: LifecycleException: Exception > > > > opening database > > > > connection: jav > > > > a.sql.SQLException: Invalid authorization > > > > specification: Access denied for > > > > user: > > > > 'tkadmin;[EMAIL PROTECTED]' (Using password: > > > > NO) > > > > LifecycleException: Exception opening database > > > > connection: java.sql.SQLExcepti > > > > on: Invalid authorization specification: Access > > > > denied for user: > > > > 'tkadmin;passwo > > > > [EMAIL PROTECTED]' (Using password: NO) > > > > > > > > > > > > Thanks > > > > > > > > randy > > > > > > > > > > > > -- > > > > To unsubscribe: > > > > <mailto:[EMAIL PROTECTED]> > > > > For additional commands: > > > > <mailto:[EMAIL PROTECTED]> > > > > Troubles with the list: > > > > <mailto:[EMAIL PROTECTED]> > > > > > >__________________________________________________ > > >Do You Yahoo!? > > >Try FREE Yahoo! Mail - the world's greatest free email! > > >http://mail.yahoo.com/ > > > > > >-- > > >To unsubscribe: <mailto:[EMAIL PROTECTED]> > > >For additional commands: <mailto:[EMAIL PROTECTED]> > > >Troubles with the list: <mailto:[EMAIL PROTECTED]> > >-- >To unsubscribe: <mailto:[EMAIL PROTECTED]> >For additional commands: <mailto:[EMAIL PROTECTED]> >Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
