Thank you for submitting your request to Quest Software Technical Support. We are unable to process your request because our records indicate that you are not registered for Technical Support.
To register, logon to our Supportlink web site http://www.quest.com/support , and self-register from the web. Or, you can phone Quest at one of the numbers below to register. Once you have registered, you can submit your request within Supportlink, by email at [EMAIL PROTECTED], by phone at one of the numbers below. Please do not reply to this email. If this is an URGENT matter please contact Quest Technical Support via telephone at one of the numbers listed below. Thank you, Quest Software Technical Support www.quest.com/support Quest Software Technical Support - Canada 902.442.5700 Quest Software Technical Support - United Kingdom 44.1628.601007 Quest Software Technical Support - United States 949.754.8000 > --------------------Original Message-------------------- > From: "Scott Stewart" [mailto:[EMAIL PROTECTED] > Sent: Fri, 22 Aug 2003 10:13:07 -0400 > To: 'Tomcat Users List' [EMAIL PROTECTED] > Subject: RE: DataSourceRealm with MySQL > > I believe the dataSourceName attribute in your <Realm> definition needs to > exactly match the name given to your <Resource> element defined within your > <GlobalNamingResources>. Therefore, you may want to change your > dataSourceName to just read "jdbc/authority". > > Thanks, > > Scott Stewart > [Manager, Software Development] > [EMAIL PROTECTED] > > work: (407) 515-8656 > cell : (407) 435-1036 > fax : (407) 515-9001 > > ClearSky Mobile Media, Inc. > 56 E. Pine Street Suite 200 > Orlando, FL 32801 > USA > > > > > > -----Original Message----- > From: Steve Wilkinson [mailto:[EMAIL PROTECTED] > Sent: Friday, August 22, 2003 8:13 AM > To: [EMAIL PROTECTED] > Subject: DataSourceRealm with MySQL > > > Hi, > > I'm struggling with creating a DataSourceRealm with MySQL. > I'm running Tomcat 4.1.27-LE-jdk14 on Windows2K > > First, I can get the following example to work: > http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how > to.html > > So, I don't think it's a MySQL thing. > > I've tried the settings from Scott Stewart's email and it doesn't work: > http://www.mail-archive.com/[EMAIL PROTECTED]/msg99745.html > > Here is my server.xml: > > ------------------------------ server.xml ------------------------- > <Server port="8005" shutdown="SHUTDOWN" debug="0"> > > > <Listener > className="org.apache.catalina.mbeans.ServerLifecycleListener" > debug="0"/> > <Listener > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" > debug="0"/> > > <GlobalNamingResources> > <Resource > name="jdbc/authority" > type="javax.sql.DataSource" > auth="Container"/> > > <ResourceParams name="jdbc/authority"> > <parameter> > <name>username</name> > <value>mysql</value> > </parameter> > <parameter> > <name>password</name> > <value>mysql</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.mysql.jdbc.Driver</value> > </parameter> > <parameter> > <name>url</name> > <value> > jdbc:mysql://localhost:3306/authority?autoReconnect=true > </value> > </parameter> > <parameter> > <name>removeAbandoned</name> > <value>true</value> > </parameter> > <parameter> > <name>removeAbandonedTimeout</name> > <value>60</value> > </parameter> > <parameter> > <name>logAbandoned</name> > <value>true</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>100</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>10000</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > </ResourceParams> > > </GlobalNamingResources> > > <Service name="Tomcat-Standalone"> > > <Connector className="org.apache.coyote.tomcat4.CoyoteConnector" > port="8080" minProcessors="5" maxProcessors="75" > enableLookups="true" redirectPort="8443" > acceptCount="100" debug="0" connectionTimeout="20000" > useURIValidationHack="false" disableUploadTimeout="true" /> > > <Engine name="Standalone" defaultHost="localhost" debug="99"> > > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="catalina_log." suffix=".txt" > timestamp="true"/> > > <Realm className="org.apache.catalina.realm.DataSourceRealm" > debug="99" > dataSourceName="java:/comp/env/jdbc/authority" > userTable="users" > userNameCol="user_name" > userCredCol="user_pass" > userRoleTable="user_roles" > roleNameCol="role_name"/> > > <Host name="localhost" debug="99" appBase="webapps" > unpackWARs="true" autoDeploy="true"> > > <Valve > className="org.apache.catalina.valves.AccessLogValve" > directory="logs" prefix="localhost_access_log." > suffix=".txt" > pattern="common" resolveHosts="false"/> > > <Logger > className="org.apache.catalina.logger.FileLogger" > directory="logs" prefix="localhost_log." > suffix=".txt" > timestamp="true"/> > > </Host> > > </Engine> > > </Service> > > </Server> > > --------------------------------------------------------------------- > Here is the error message I get from Tomcat when I use my server.xml above: > > ServerLifecycleListener: Can't create mbean for realm > org.apache.catalina.realm. > [EMAIL PROTECTED] > > Note, I was able to the the JDBCRealm working fine. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
