Re: Q: DB-password clear text?
Michael, to prevent unauthorised pesonnel to look at the password you could probably unset the read flag of their group. Mariano On Tuesday 28 August 2001 22:38, Martin Man wrote: On Tue, Aug 28, 2001 at 11:21:45AM +0200, Enke Michael wrote: Hi! Is there a possibility or would it be easy to implement to have the DB password encrypted in some kind (in *.xsp or cocoon.xconf)? as long as the direct JDBC connection requires plaintext passwords (and yes all existing JDBC driver implementations require plaintext) it's absolutely useless to add encryption to another layer. anyway passwords are stored in a file on the server and JDBC connection is usually made via localhost loopback, therefore password sniffing is almost impossible and cocoon.xconf or whichever file the password actually contains is not readable by ordinary users via web... This doesn't mean a state of the art encryption (too complicated!?), but only that not everybody can have direct access to the database. don't get this, if there is a password that only admin knows, then anyone who does not know it does not have the access to the database or am I wrong ??? Regards, Michael rgds, martin - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: ./build.sh - permission denied
Hi there, use chmod +x build.sh. That should work. There seems to be somebody left who is using windows and is also a comitter ;-) Mariano On Friday 13 July 2001 12:19 pm, raghu wrote: Hello there, I am unable to build the cocoon2, i downloaded the cocoon-2.0-b1.tar from xml.apache.org, and untarred it in a directory. When i try to build using ./build.sh -Dinclude. i get permission denied, why is it so i am in the root while doing this. Can anybody help. Pleas. bye, raghu Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
To Eric Vernichon or Benjamin Pignier, other: please ignore
Hi there, sorry for disturbing the list with private mail, but I got an email regarding the list with an invalid sender address. I'm posting it here to get it back to the original sender. Sorry, Mariano Eric, if you read this mail ?!?! , please clean up your email account. I got this message, when replying to you: - The following addresses had permanent fatal errors - [EMAIL PROTECTED] (reason: 554 delivery error: dd Sorry, your message to [EMAIL PROTECTED] cannot be delivered. This account is over quota. - mta588.mail.yahoo.com) - Transcript of session follows - ... while talking to mx1.mail.yahoo.com.: DATA 554 delivery error: dd Sorry, your message to [EMAIL PROTECTED] cannot be delivered. This account is over quota. - mta588.mail.yahoo.com 554 5.0.0 [EMAIL PROTECTED]... Service unavailable Mariano -- Forwarded Message -- Subject: Re: Date: Wed, 11 Jul 2001 19:13:47 +0200 From: Mariano Kamp [EMAIL PROTECTED] To: benjamin pignier [EMAIL PROTECTED] Bonjour Benjamin or Eric? I managed to get esql working, but I am not an expert on this. It would make a lot of sense if you post your message on the users list again. There is a much wider audience. What you should do is, giving more informations. Nobody will be able to help you with the information you just gave me. Please look at the logfile cocoondir/WEB-INF/logs/cocoon.log and post thee messages on the list. Hope this helps. Au revoir, Mariano On Wednesday 11 July 2001 06:11 pm, benjamin pignier wrote: I've just read a reply you made in the discussion list [EMAIL PROTECTED]. I wonder if you could help me. I'm not able to configure Cocoon2 in order to connect to my database (postgres) using esql syntaxe. Or it might be a problem with my configuration of pooling connection because i don't know how to configure it in cocoon.conf. My configuration is redhat 7.0/tomcat3.21/cocoon2.0b1. Sincerely. Eric Vernichon ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com --- - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Is SQLTransformer gonna be there?..Re: SQL Transfomer
[..] Furthermore I like that SQL Transformer uses prepared statements. The only thing I don't like too much about SQL Transformer is that I can tweak really the element names of the generated output. I don't know exactly what you mean, can you be more specific about this? Yeah, I am talking about the generated element names. Meanwhile I checked the source code and found that you have this two parameters (doc-element, row-element), but these are not accessible from the sitemap. I send a suggestion as a patch to the developer list. Mariano - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [C2] Postgres with SQL - Transformer
Sven, thank you very much for your response. I see your point in polluting the code by providing the dynamic sql opportunity to and furthermore prepared statements are the way to go anyway. The exception says it's not implemented *yet*, so as we are just looking for *some* open source database to support, and I got mysql up and running yesterday ,it is not pressing us anymore. As mentioned earlier we are building a reporting system and performance is critical but transactions are not, so for the time being mysql will just do fine. Again, thanks for caring. Mariano On Thursday 28 June 2001 04:22 pm, Beauprez Sven wrote: Mariano, The latest version of the SQLTransformer (HEAD branch) uses prepared statements (for the queries) and callable statements (for stored procedures). It doesn't use the createStatement() on the connection object anymore. I removed it because i thought it would be an improvement to use prepared statements instead. (i thought all jdbc drivers implemented this, but it seems not all of them do :-( ) I think the code will get messy if i incorporate the old way also, i will try to find a compromise for this... Someone an idea? In the meantime, the old version of the SQLTransformer in the cocoon_20_branch still uses createStatement(), maybe you can use this one for now. Sven -Original Message- From: Mariano Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: [C2] Postgres with SQL - Transformer Hi there, I tried C2 with postgress, but postgres throws an exeption that prepareStatement() is not supported yet ;-( Is there any way to tell the SQL-Transformer not to prepare the Statements and use dynamic sql instead? Mariano - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Is SQLTransformer gonna be there?..Re: SQL Transfomer
I have the same question as guru man. When to use esql and when to use the sql transformer? Please correct my below described assumptions. I started with esql, but moved to the Sql-Transformer, because esql works on the generator level and I want to have a ReportDefintionxxx.xml as the first file in my pipeline/matcher. So Sql-Transformer seems more naturally to me. Actually I want to use a home grown Transformer that extracts some of the Data from ReportDefinition.xml and build a sql-statement which will then be transformed (executed) by the SQL-Transformer. This is because we want the ba people to give the opportunity to manage the reports in one file. I haven't seen any way to do that with esql, but it's also possibly that I missed the whole point. Wouldn't be the first time ;-) Furthermore I like that SQL Transformer uses prepared statements. The only thing I don't like too much about SQL Transformer is that I can tweak really the element names of the generated output. Mariano On Tuesday 26 June 2001 05:52 pm, you wrote: Mr. guru, If it is up to me, the SQLTransformer will never be depricated ;-). But the functionallity might slightly change and the implementation might be completly redone if necessary as long as the usage stays the same (i am not planning to change anything, but someone might be...). I never had any problems with the examples, it is very strange that the esql samples work and the sql-sample page not. If i am not mistaken, Vadim made a change to the SQLTransformer in cocoon_20_branch a few days ago, check again if you have the latest version and try again... If it doesn't work, try to describe your problem in more detail (what's the output, what's in the log file,...) Sven -Original Message- From: java guru [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 5:31 PM To: [EMAIL PROTECTED] Subject: Is SQLTransformer gonna be there?..Re: SQL Transfomer This may look like newbie question..but is SQLTransformer and taglib gonna continue or deprecated??? What about esql..what is the difference. And finally i could never run the sql-page.xml example from cocoon2 to work..i dont know whats the problem.i could run esql example successful.. Appreciating the response.. srini Do You Yahoo!? For regular News updates go to http://in.news.yahoo.com - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: [C2] Postgres with SQL - Transformer
Yeah, I tried it on both too and especially with mysql it was a breeze ;-) Mariano On Friday 29 June 2001 09:33 am, Beauprez Sven wrote: Mariano, I tested the SQLTransformer with mysql and oracle as underlying databases, it should work fine on both... If you need an open source database, i certainly recommend mysql. I use the following jdbc driver: http://mmmysql.sourceforge.net/ Sven -Original Message- From: Mariano Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 3:08 PM To: [EMAIL PROTECTED] Subject: Re: AW: [C2] Postgres with SQL - Transformer Hallo Carsten, thanks for answering my question and sorry for not being more specific in first place. Yes I am using connection pooling configured in cocoon.xconf, but the funny thing is I was also using connection pooling when using esql and that was working ok. I don't think that the problem is related to the avalon code. The stack trace showed that the exeception was raised in postgresql classes. Unfortunately I don't have access to the running system today, but if you want I can post it tomorrow. Well, yes and we need connection pooling and we also want to use an open source database besides oracle. As we are reporting data and don't need transactions I will have a look at mysql now. Bis bald, Mariano On Thursday 28 June 2001 02:49 pm, you wrote: Mariano Kamp wrote: Von: Mariano Kamp [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 28. Juni 2001 14:36 An: [EMAIL PROTECTED] Betreff: [C2] Postgres with SQL - Transformer Hi there, I tried C2 with postgress, but postgres throws an exeption that prepareStatement() is not supported yet ;-( Is there any way to tell the SQL-Transformer not to prepare the Statements and use dynamic sql instead? I am not quiet sure but I think the prepareStatement comes from the underlying Avalon databasesource code. Am I correct that you use preconfigured sql connections in the cocoon.xconf? If so the only solution is to don't use them and write your connection directly into the sitemap when the transformer is used: map:transform type=sql map:parameter name=dburl value=your db url/ map:parameter name=username value=your username/ map:parameter name=password value=your password/ /map:transform Using this no prepareStatement() is called (I hope) but the bad news: no connection pooling. Carsten Open Source GroupsunShine - b:Integrated Carsten Ziegeler, SN AG, Klingenderstrasse 5, D-33100 Paderborn www.sundn.de mailto: [EMAIL PROTECTED] Mariano - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[C2] Postgres with SQL - Transformer
Hi there, I tried C2 with postgress, but postgres throws an exeption that prepareStatement() is not supported yet ;-( Is there any way to tell the SQL-Transformer not to prepare the Statements and use dynamic sql instead? Mariano - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: [C2] Postgres with SQL - Transformer
Hallo Carsten, thanks for answering my question and sorry for not being more specific in first place. Yes I am using connection pooling configured in cocoon.xconf, but the funny thing is I was also using connection pooling when using esql and that was working ok. I don't think that the problem is related to the avalon code. The stack trace showed that the exeception was raised in postgresql classes. Unfortunately I don't have access to the running system today, but if you want I can post it tomorrow. Well, yes and we need connection pooling and we also want to use an open source database besides oracle. As we are reporting data and don't need transactions I will have a look at mysql now. Bis bald, Mariano On Thursday 28 June 2001 02:49 pm, you wrote: Mariano Kamp wrote: Von: Mariano Kamp [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 28. Juni 2001 14:36 An: [EMAIL PROTECTED] Betreff: [C2] Postgres with SQL - Transformer Hi there, I tried C2 with postgress, but postgres throws an exeption that prepareStatement() is not supported yet ;-( Is there any way to tell the SQL-Transformer not to prepare the Statements and use dynamic sql instead? I am not quiet sure but I think the prepareStatement comes from the underlying Avalon databasesource code. Am I correct that you use preconfigured sql connections in the cocoon.xconf? If so the only solution is to don't use them and write your connection directly into the sitemap when the transformer is used: map:transform type=sql map:parameter name=dburl value=your db url/ map:parameter name=username value=your username/ map:parameter name=password value=your password/ /map:transform Using this no prepareStatement() is called (I hope) but the bad news: no connection pooling. Carsten Open Source GroupsunShine - b:Integrated Carsten Ziegeler, SN AG, Klingenderstrasse 5, D-33100 Paderborn www.sundn.de mailto: [EMAIL PROTECTED] Mariano - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[C2] Problem with with transformer called more than once.
Hi there, I started using transformers and encounter some behaviour which I don't understand. If I call the transformer more than once or twice and encounter a NullPointer Exception. I don't have a clue why? I am using C2 from the current CVS. I attached the code and inlined the log and an extract from the sitemap. Mariano From sitemap.xmap. map:match pattern=pf.html map:generate src=exp1/PortfolioValuationDefinition.xml/ map:transform type=reportDefinition/ map:serialize/ /map:match from the log Works ok. == tc4/logs/catalina.out == startDocument() called.com.codamax.fidamax.transformer.ReportDefinitionTransfor mer@1efb45c2 startElement uri, name, raw:http://www.codamax.com/etl, report ,cetl:report startElement uri, name, raw:http://www.codamax.com/etl, title ,cetl:title endElement uri, name, raw:http://www.codamax.com/etl, title ,cetl:title startElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension startElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension startElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension startElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension endElement uri, name, raw:http://www.codamax.com/etl, report ,cetl:report end Document() called. getSQL() returned:SELECT countries.name AS C1, securities.value AS C2 FROM facts, countries, securities WHERE facts.fkcountry=countries.key AND facts.fksecurity=securities.key GROUP BY countries.name ORDER BY countries.name ASC, securities.value DESC ; SELECT countries.name AS C1, securities.value AS C2 FROM facts, countries, securities WHERE facts.fkcountry=countries.key AND facts.fksecurity=securities.key GROUP BY countries.name ORDER BY countries.name ASC, securities.value DESC ; startDocument() called.com.codamax.fidamax.transformer.ReportDefinitionTransfor mer@1d3d85c2 startElement uri, name, raw:http://www.codamax.com/etl, report ,cetl:report startElement uri, name, raw:http://www.codamax.com/etl, title ,cetl:title endElement uri, name, raw:http://www.codamax.com/etl, title ,cetl:title startElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension startElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension startElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension startElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, attribute ,cetl:attribute endElement uri, name, raw:http://www.codamax.com/etl, dimension ,cetl:dimension endElement uri, name, raw:http://www.codamax.com/etl, report ,cetl:report end Document() called. getSQL() returned:SELECT countries.name AS C1, securities.value AS C2 FROM facts, countries, securities WHERE facts.fkcountry=countries.key AND facts.fksecurity=securities.keyGROUP BY countries.name ORDER BY countries.name ASC, securities.value DESC ; SELECT countries.name AS C1, securities.value AS C2 FROM facts, countries, securities WHERE facts.fkcountry=countries.key AND facts.fksecurity=securities.key GROUP BY countries.name ORDER BY countries.name ASC, securities.value DESC ; == /opt/cocoon/WEB-INF/logs/cocoon.log == DEBUG 99375 [cocoon ] (HttpProcessor[8080][4]): getRealPath for /:
Re: sql sample throws blank page...newbie
Hi, have you checked the logfile (by default it is cocoon/WEB-INF/logs/cocoon.log)? I am also wondering how I can extract the exception from an esql query?!?! Mariano I am trying to get the sample sql link from welcome page work..the esql link works fine ... but the sql link throws blank page ( i mean the static content is coming up ) but not the database content.. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: C2 problem
I am new to C2 too, but keeping that in mind ... I always get this message, when I did an inpropriate change to sitemap.xmap. Sometimes I also get this message, when launching cocoon, but it goes away after it is started properly. If there is a syntax error in your sitemap.xmap, the log will tell you some lines above the exception. Mariano On Monday 18 June 2001 10:28 pm, you wrote: Johnny wrote: blahblahblah error! type internal-server-error message The sitemap handler's sitemap is not available. description org.apache.cocoon.ProcessingException: The sitemap handler's sitemap is not available. sender org.apache.cocoon.servlet.CocoonServlet source Cocoon servlet request-uri /cocoon/ exception org.apache.cocoon.ProcessingException: The sitemap handler's sitemap is not available. thats exactly the same problem i have. my server configuration worked with a c2 build from 2001/04/25 and i didnt changed it. the only thing that changed was cocoon. it seems to be an internal cocoon bug. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
