cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geoff Howard" <coc...@leverageweb.com>
Subject RE: newby with cocoon esql mysql linux
Date Wed, 18 Jun 2003 00:14:25 GMT
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:ntic@lespetitsdebrouillards.org]
> Sent: Tuesday, June 17, 2003 3:01 PM
> To: cocoon-users@xml.apache.org
> 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: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message