this sounds like a connection permission on mysql's end. what host permission have you granted the user? Can you connect via jdbc from the same machine usinga a simple jdbc test case?
The mysql manual covers this config in pretty good detail. Geoff Howard > -----Original Message----- > From: ntic [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 3:01 PM > To: [EMAIL PROTECTED] > Subject: newby with cocoon esql mysql linux > > > Hello, > I've got some trouble with my cocoon configuration. > I've got : > mysql ver. 3.23.54 > the driver is mysql-connector-java-3.0.8-stable-bin.jar in > webapps/cocoon/WEB-INF/lib/ > cocoon 2.0.4 > > my sitemap.xmap file contain : > > *<map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";> > <map:components> > <map:generators> > <map:generator name="serverpages" > src="org.apache.cocoon.generation.ServerPagesGenerator"/> > </map:generators> > <map:serializers> > <map:serializer name="xml" mime-type="text/xml" > src="org.apache.cocoon.serialization.XMLSerializer"/> > </map:serializers> > <map:matchers default="wildcard"> > <map:matcher name="wildcard" > src="org.apache.cocoon.matching.WildcardURIMatcher"/> > </map:matchers> > </map:components> > <map:pipelines> > <map:pipeline> > <map:match pattern="*.xsp"> > <map:generate type="serverpages" src="{1}.xsp"/> > <map:serialize type="xml"/> > </map:match> > </map:pipeline> > </map:pipelines> > </map:sitemap> > * > the web.xml contain : > * <init-param> > <param-name>load-class</param-name> > <param-value> > org.hsqldb.jdbcDriver > com.mysql.jdbc.Driver > </param-value> > </init-param> > * > the cocoon.xconf contain : > * <datasources> > <jdbc logger="core.datasources.personnel" name="personnel"> > <pool-controller max="10" min="5"/> > <dburl>jdbc:hsqldb:hsql://localhost:9002</dburl> > <user>sa</user> > <password/> > </jdbc> > <jdbc name="ma_table_tbl" logger="core.datasources.ma_table_tbl"> > <pool-controller min="5" max="10"/> > <dburl>jdbc:mysql://localhost/ma_table_tbl</dburl> > <user>username</user> > <password>password</password> > </jdbc> > </datasources> > * > my xsp file contains : > *<?xml version="1.0" encoding="iso-8859-1"?> > <xsp:page language="java" xmlns:xsp="http://apache.org/xsp"; > xmlns:esql="http://apache.org/cocoon/SQL/v2";> > <liste_mc> > <esql:connection> > <esql:driver>com.mysql.jdbc.Driver</esql:driver> > <esql:dburl>jdbc:mysql://localhost/ma_table_tbl</esql:dburl> > <esql:username>username</esql:username> > <esql:password>password</esql:password> > <esql:execute-query> > <esql:query> > SELECT type FROM type_tbl > </esql:query> > <esql:results> > <esql:row-results> > <type><esql:get-string column="type"/></type> > </esql:row-results> > </esql:results> > > <esql:error-results><erreure>erreure</erreure></esql:error-results> > <esql:no-results><pasres>no result</pasres></esql:no-results> > </esql:execute-query> > </esql:connection> > </liste_mc> > </xsp:page> > * > The query works properly when i use it in command-line, the cocoon-xsp > work properly (i try it with a script of factorial calculus). > The problem is tha there is no connection to my database (the > long-format log of mysql is not informed of this kind of connection) and > the WEB-INF/log/error.log says : > > *ERROR (2003-06-17) 19:34.44:382 [core.manager] > (/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap > org.apache.cocoon.ProcessingException: Exception in > ServerPagesGenerator.generate(): java.lang.RuntimeException: Error > opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server > configuration denies access to data source > at > org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP > agesGenerator.java:270) > * > > I search the web and the mail archive but i don't find any response. > I search the answer since three days and i become to be a little bit > upset... > If someone can help me.. > thx a lot > Alex > > > --------------------------------------------------------------------- > 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]
