BaseX-Talk May 2012

basex-talk@mailman.uni-konstanz.de

48 participants
64 discussions

restxq and DB access
by Gilles CARRY 15 May '12

15 May '12

Hello, I'm trying to use restxq to generate web report from a DB and I just don't understand where to put the xqueries in the xqm files. Is there any example for this? In my configuration, I have this URL: http://httpserverIP:8080/BaseX72/rest/ showing: <rest:databases resources="2"> <rest:database resources="1" size="3827564582">logs</rest:database> <rest:database resources="1" size="102453817">streams</rest:database> </rest:databases> And http://httpserverIP:8080/BaseX72/restxq/ showing the page: Welcome to the RESTXQ Service bla... bla... But I can't find the way to have an xqm page that queries the above DBs (logs or stream). What shall I do to access data from the xqm files? It may be so obvious that I can't see it. ;-) Thanks, Cheers, Gilles.

2 1

Error using transform method (XSLT Module)
by Anand Chiney 14 May '12

14 May '12

Hi there, I am using BaseX 7.2 Beta. I am trying to extract certain XML Documents from the DB and then applying the XSLT to convert these docs to HTML. Following is the query, which I am typing in Editor - let $in := /Chapters let $style := doc('C:\Program Files\BaseX\data\chapter.xslt') return <Chapters>{( xslt:transform($in, $style), xslt:transform($in, $style) )}</Chapters> I am getting error message - *Error: [FODC0002] "" (Line 34): </head> found, </meta> expected.* First I thought that, <META> tag might be compulsory. So I added the same to the XSLT file. Still error.... What does it means? Am I doing anything wrong? The XSLT works correctly when used individually with Java code. Ready to sent the XML and XSLT File.... -- Regards Have a nice day :) Anand C

4 4

custom separator in CSV mode
by Fabrice Etanchaud 14 May '12

14 May '12

Dear all at BaseX, first of all, thank you for your fantastic job, BaseX changed my life ! Do you plan to let users set a custom separator when importing in CSV mode ? (the comma, semicolon, or tab are too restrictive) best regards Fabrice ETANCHAUD Senior Software Engineer edital Berkenlaan 1 B-1831 Brussels, Belgium <skype:fabrice.etanchaud?call> +32 2 716 32 32 general +32 2 716 32 20 fax fetanchaud(a)edital.com corsearch.com <http://www.corsearch.com/> | edital.com <http://www.edital.com/> <outbind://899-00000000E439C83B50BF17409D8C27B7AE0425AF07005AA868536216F 543BAB9422EAEA5338B00000011020900005AA868536216F543BAB9422EAEA5338B00000 13AA36B0000/cid:image001.gif@01CC0F02.2C91B6C0> Confidentiality Notice: This email and its attachments (if any) contain confidential information of the sender. The information is intended only for the use by the direct addressees of the original sender of this email. If you are not an intended recipient of the original sender (or responsible for delivering the message to such person), you are hereby notified that any review, disclosure, copying, distribution or the taking of any action in reliance of the contents of and attachments to this email is strictly prohibited. If you have received this email in error, please immediately notify the sender at the address shown herein and permanently delete any copies of this email (digital or paper) in your possession.

2 3

feedback for RESTXQ and pure XML
by Philippe Rathé 13 May '12

13 May '12

Hello, I would like to know best practices for using RESTXQ for pure XML Web services, in my case AtomPub. First I was surprised that using "rest:produces" in the following line did not produces the specified media-type. But instead "application/xml" %rest:produces("application/atomsvc+xml") What was necessary was to use 'output:media-type("application/atomsvc+xml")' in addition. Why that? Here is the working annotation and code I am talking about: declare %rest:path("/service") %rest:GET %rest:produces("application/atomsvc+xml") %output:method("xml") %output:omit-xml-declaration("no") %output:media-type("application/atomsvc+xml") function page:service() { <service xmlns="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom"> <workspace> </workspace> </service> }; I would like to know if I should not use the namespace "page" in order to generate my responses knowing that I will produce only XML responses. Is it appropriate for XML services? Would it be better to create a namespace or a XQuery module in order not to repeat myself in the many annotations I will have to create? I would not know where to start in order to use RESTXQ with my own module or namespace. Any suggestions are welcome. Thanks, - Philippe

2 3

REST Insert Problem
by khaled refai 13 May '12

13 May '12

String st = "<query xmlns='http://basex.org/rest'>"+ "<text> insert node <user> <name>qusai</name> "+ "<username>qu</username> <password>qu</password>"+ " </user> into //elib/users</text>"+ "<parameter name='wrap' value='yes'/></query>" conn = (HttpURLConnection) url.openConnection(); conn.setDoOutput(true); conn.setRequestMethod("POST"); conn.setRequestProperty("Content-Type", "application/xml"); conn.setRequestProperty("Authorization", "Basic " + encoded); out = conn.getOutputStream(); out.write(res.getBytes("UTF-8")); out.close(); System.out.println(conn.getResponseMessage()); *and the result from server is : Bad Request* *????* *any answer* * *

2 3

nessus report caused an error
by Brown, David (SSC-A) 13 May '12

13 May '12

I am trying to convert a nessus file to a more useful report, something like this: Severity, Finding, Hosts, Associated CVEs Critical, RHSA-2012-0465: libsmbclient, (ip1, ip2), CVE-20xx-yyyy Query: for $x in //Report/ReportHost/ReportItem let $finding := string-join(data($x/cve),", ") where $x/risk_factor = "Critical" group by $finding order by $finding return for $x in //Report/ReportHost/ReportItem let $finding1 := string-join(data($x/cve),", ") let $host := data($x/../@name) where $finding1=$finding group by $finding1 order by $finding1 return <finding> <cve>{$finding1}</cve> <host>{$host}</host> </finding> Error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.2.1 Java: Oracle Corporation, 1.7.0 OS: Windows 7, amd64 Stack Trace: java.lang.ClassCastException: org.basex.query.item.DBNodeSeq cannot be cast to org.basex.query.item.ANode org.basex.query.path.AxisPath.iter(AxisPath.java:273) org.basex.query.QueryContext.iter(QueryContext.java:275) org.basex.query.flwor.For$1.init(For.java:120) org.basex.query.flwor.For$1.next(For.java:84) org.basex.query.flwor.GFLWOR.iter(GFLWOR.java:320) org.basex.query.flwor.GFLWOR.iter(GFLWOR.java:295) org.basex.query.QueryContext.iter(QueryContext.java:275) org.basex.query.expr.ParseExpr.value(ParseExpr.java:69) org.basex.query.QueryContext.value(QueryContext.java:286) org.basex.query.flwor.Order.add(Order.java:76) org.basex.query.flwor.GroupPartition.ret(GroupPartition.java:148) org.basex.query.flwor.GFLWOR.iter(GFLWOR.java:302) org.basex.query.QueryContext.iter(QueryContext.java:275) org.basex.query.QueryContext.iter(QueryContext.java:229) org.basex.query.QueryContext.execute(QueryContext.java:448) org.basex.query.QueryProcessor.execute(QueryProcessor.java:94) org.basex.core.cmd.AQuery.query(AQuery.java:86) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:325) org.basex.core.Command.exec(Command.java:304) org.basex.core.Command.execute(Command.java:76) org.basex.gui.GUI.exec(GUI.java:390) org.basex.gui.GUI$6.run(GUI.java:342) v/r, David Brown Fully Qualified Navy Certification Agent LSS Certified Blackbelt, CISSP, NSA-IAM/IEM, MSCIS SPAWARSYSCEN ATLANTIC ISS LOB SSC Lead Email: <mailto:david.k.brown1@navy.mil> david.k.brown1(a)navy.mil Phone: 843.218.6227 DSN: 588.6227 Fax: 843.218.5461 "Let us not look back in anger or forward in fear, but around in awareness." James Thurber

2 1

BaseXHTTP
by Philippe Rathé 13 May '12

13 May '12

Hello, can someone point me to instructions for running the http web server? org.basex.BaseXHTTP was not in the OSX BaseX distribution so I cloned basex-api and packaged it with maven. But I didn't know of the dependencies to include in the command line. I had finally the server started but it logs errors and does not answer on port 1984. Are there any instructions? Thanks.

2 2

Too Many Open Files
by Andreas Rulle 11 May '12

11 May '12

Hello BaseX-Experts! Let me first thank you who drive this fantastic BaseX project! For the use of BaseX as a backend to a soap-webservice project we have seen very encouraging load test results. On the systems that is intended to become productive very soon we see on a daily basis (on two database engines behind a load balancer) the following messages that terminate the execution of the Basex-server. Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.2 Java: Sun Microsystems Inc., 1.6.0_20 OS: Linux, amd64 Stack Trace: java.net.SocketException: Too many open files java.net.PlainSocketImpl.socketAccept(Native Method) java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:375) java.net.ServerSocket.implAccept(ServerSocket.java:470) java.net.ServerSocket.accept(ServerSocket.java:438) org.basex.BaseXServer.run(BaseXServer.java:164) java.lang.Thread.run(Thread.java:636) The error message occurs when there are no client requests to the server. The load balancer might do some pinging. Any feedback and hint to this message is highly welcome! With best regards, Andreas -- Nexoma GmbH Theodorus Weg 7 59755 Arnsberg Geschäftsführer: Guido Sauerland Sitz der Gesellschaft: Arnsberg Registergericht: Arnsberg, HRB 9365

2 2

Re: [basex-talk] Too Many Open Files
by Andreas Rulle 11 May '12

11 May '12

Hello Stefan, thank you for your quick response. For testing purposes the basex database is started within a screen and in this screen the number of open files has been set as recommended by you. It remains the vague feeling that this might only cure a symptom ... With best regards, Andreas > Hi Andreas, > > enter ulimit -n in the shell. It's probably 1024. > You can set it higher with ulimit -n 4096. But this works just for > one session. To make it persistent edit /etc/profile > > Kind regards, > > Stefan > > > > -- Nexoma GmbH Theodorus Weg 7 59755 Arnsberg Geschäftsführer: Guido Sauerland Sitz der Gesellschaft: Arnsberg Registergericht: Arnsberg, HRB 9365

2 2

Preferred way to run BaseX as service on Debian
by Manuel Bernhardt 11 May '12

11 May '12

Hi, is there perhaps an init.d script somewhere already in order to launch basexserver as a service on Debian? So far it looks as though there isn't one in the Debian package, so I'm thinking of adding a line to rc.local to run it on startup. Also, from what I gathered, basex is now only available in sid, is that correct? I installed it on squeeze by downloading the deb, there's just one dependency on java-wrappers that I needed to install by hand. Thanks, Manuel

4 4

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk May 2012