- BaseX-Talk - mailman.uni-konstanz.de

webapp/static
by Hans-Juergen Rennau 07 Jan '22

07 Jan '22

Hello, dear BaseX team, one question concerning folder $BASEX/webapp/static. Given an HTML page created by a query via REST or RESTXQ execution. It seems to me that referenced resources (e.g. link/@href or img/@src) must be located in that folder or a subfolder of it, and the reference must be "../static/foo.css" or "../static/path/to/subfolder/foo.css", examples: <link rel="stylesheet" type="text/css" href="../static/foo.css"/><link rel="stylesheet" type="text/css" href="../static/foo/foo.css"/> At least I did not succeed with any other locations, specified by full path or by relative path, assuming different context paths (e.g. the folder containing the query producing the HTML, or $BASEX/bin, or $BASEX). My QUESTION: is that correct, if not - what are the rules? Many thanks,Hans-Jürgen PS: Apologies if this is documented, but I failed to find it, and the complete PDF contains a single occurrence of string "/static" which does not apply.

2 1

RESTXQ generated HTML - unexpected behaviour
by Hans-Juergen Rennau 07 Jan '22

07 Jan '22

Hello, I face a problem with RESTXQ of a fairly general character, as it seems to me. When the XQuery functions of a RESTXQ application construct HTML pages, I expect these pages to behave exactly as a static page with the same content would behave. But sometimes this is not the case. As an attachment I send an example. The "webapp" folder contains an XQuery module with a RESTXQ function [2], and the "html" folder contains an HTML page [3] which is identical to the page generated by the RESTXQ function [4]. This page has been copied from [1], and it demonstrates auto completion in an input field. However, auto completion works only when calling the HTML file; it does not work when calling the RESTXQ application. In both cases, the HTML page references a JS file as well as a CSS file, located in a sibling folder "static". An alert box as well as the appearance of the page prove that JS and CSS are found and used in both cases. And yet the behaviour is different ... ~~~ This problem appears to me important, as the trust in RESTXQ would be damaged if the generated HTML "may or may not" behave as it should. On the other hand, if the reason of the problem is understood and a workaround is available, all would be well. Kind regards,Hans-Jürgen [1] https://www.w3schools.com/howto/howto_js_autocomplete.asp [2] $demo-autocomplete/webapp/autocomplete/demo-autocomplete.xq [3] $demo-autocomplete/html/demo-autocomplete.html [4] The contents of the HTML file have been created by (1) entering into a browser the URL of the RESTXQ application (localhost:8984/demo-autocomplete), (2) selecting from the context menu "Show source code", (3) copying the source code into the empty HTML file, (4) replacing <script .../> with <script...></script>. [5] How to reproduce the problem:a. Unzip the archiveb. Call $demo-autocomplete/html/demo-autocomplete.html - after acknowledging the alert box which shows that the imported JS function has been called, enter into the input field letter "a" - a list of completions appears.c. Install the RESTXQ application: copy folder $demo-autocomplete/webapp/autocomplete into the webapp folder of a BaseX instance, and copy the files $demo-autocomplete/webapp/static/* into $BASEX/webapp/static.d. Enter in a browser "localhost:8984/demo-autocomplete" - after acknowledging the alert box, enter into the input field letter "a" - no list of completions appears.

2 4

Re: [basex-talk] Copy data from MariaDB into BaseX
by Christian Grün 23 Dec '21

23 Dec '21

Thanks. Does the query do what you are looking for? On Tue, Dec 21, 2021 at 12:47 PM <benengbers(a)dds.nl> wrote: > > Christian Grün schreef op 21-12-2021 10:18: > > Hi Ben, > > > return db:add($db, $doc, $table || '.xml') > > > > Could you give us little examples for <DB-name>, <DB-schema> and > > <table-name> ? > > > > Best, > > Christian > > To the best of my knowledge in MySQL and/or MariaDB DB-name and > DB-schema are identical? The schema-name I use is 'Innovate'. > Table-names are > +--------------------+ > | Tables_in_Innovate | > +--------------------+ > | Dienst | > | Mdw_Probleem | > | Mdw_Wens | > | Medewerker | > | Medewerker_dienst | > | Probleem | > | Wens | > +--------------------+ > > Ben > PS.I hope you'll see this reply. Since a few days all mail from > basex-talk is refused by Thunderbird. At least I don't see them anymore > ....

2 5

Copy data from MariaDB into BaseX
by Ben Engbers 21 Dec '21

21 Dec '21

Hi, After completing my work on the R-client, I started working on a Prolog-client. Long ago I wrote an application in SWI-Prolog which operated on data from a MySQL-database. (In the meantime I changed from MySQL to MariaDb). My goal is to write a new version of that application but now based on data which is stored in Basex. In the basexgui, I created an empty database "MariaBases" The following code can be used to select data in MariaDb: sql:init("org.mariadb.jdbc.Driver"), let $con := sql:connect('jdbc:mariadb://localhost:3306/<DB-name>', '<user>', '<password>') return sql:execute($con, "select * from Mdw_Wens") returns: <sql:row xmlns:sql="http://basex.org/modules/sql"> <sql:column name="ID">1</sql:column> <sql:column name="Medewerker_ID">5</sql:column> <sql:column name="Wens_ID">1</sql:column> </sql:row> Is it possible to change the query-statement in such a way that the results are added to MariaBases/<DB-schema>/<table-name>? -- Ben Engbers

2 1

BaseX 9.6.4: Tweaks, Fixes & Thank Yous
by Christian Grün 17 Dec '21

17 Dec '21

Dear all, We conclude this year with yet another release of BaseX, our XML framework, database and XQuery processor [1]. The new version contains new performance tweaks and minor bug fixes, the details of which can be examined on our GitHub page [2]. As we’ve got numerous inquiries regarding Log4j: I can comfort you that BaseX is not affected by the vulnerabilities. We have our own logging mechanism, which has no built-in code execution features. The same applies to the Jetty web server. Log4j once again demonstrates that Open Source is everywhere, and that it takes valuable time and resources to build professional and secure software. We send out a big thank you to those of you who are (and have been) supporting us by paying for maintenance, sponsoring new features and giving donations. It’s you who is keeping BaseX both alive and up to date! Have a good time, Christian [1] https://basex.org [2] https://github.com/BaseXdb/basex/commits/master

4 4

Email.jar module documentation
by Eliúd Santiago Meza y Rivera 16 Dec '21

16 Dec '21

Hi, Sorry for ask, but where I can find or read more about email.jar module documentation?, I'm working for a personal project and beside to send e-mail, I need to read some emails, or is there another options to do this task. Cheers. Eliud Meza

2 1

Log4j vulnerability CVE-2021-44228
by Marc Coenegracht 13 Dec '21

13 Dec '21

Does Basex (9.x or 8.x) use Log4j in any of its components? If not, should one still worry about the JRE? Regards, Marc

3 4

Changing BaseX GUI preferences is not restored after restart
by Kristian Kankainen 13 Dec '21

13 Dec '21

Hello, I have a strange behaviour with BaseX on MacOS X. I have multiple downloads of BaseX ZIP edition on my mac. They are in different folders. When I start the BaseX GUI from one of these folders (either with opening the basex.jar or running the bin/basexgui script) and inspect the Preferences General tab, I see the Database and Repository paths stating the wrong paths. Trying to open a database yields in a message stating there are no databases and asks whether I want to create one (I choose not to). If I choose the correct paths to the database and repository folders and choose quit from the menu and start the GUI again, then the values have been reverted to the old and wrong ones. Is there a way I can change these paths? Best regards, Kristian Kankainen

2 2

How can I find the document a specific node belongs to?
by Timothée 12 Dec '21

12 Dec '21

Hello, I am trying to build a web application, powered by data served through BaseX. One of the use cases I have is that I want to find all "documents" that match a xquery. I have the following in a RESTXQ file: declare %rest:path("filter_by_author") %rest:GET %rest:query-param("name", "{$name}") function page:by_author($name as xs:string) { let $docs := db:node-id(db:open("sp")//head/meta[@name='author' and contains(lower-case(@content), lower-case(web:decode-url($name)))]) return <response> {for $node_id in distinct-values($docs) return <title value="{$node_id}" />} </response> }; As expected, this does not work because it returns the node IDs. How can I get the "document ID" or "document path" from a node? I understand XQuery does not know about files in a collection (I found the following thread / message in the archives about it: https://mailman.uni-konstanz.de/pipermail/basex-talk/2010-July/000499.html) - but is there a "db" function that would allow me to do it? Thanks for your help, - Tim

2 2

Authentication in server protocol
by Ben Engbers 08 Dec '21

08 Dec '21

Hi Christian, All my previous packages for RBaseX were based on using a blocking socket. Every attempt to use a non-blocking socket failed because I couldn't authenticate. In R each read-operation on a blocking socket uses a timeout of at least 1 second. Consequence was that executing 53 tests on my pacakge took at least 116 seconds on my machine. I finally managed to use a non-blocking socket. Execution of the same tests now take 3.8 seconds. It showed that the crucial needed step was to introduce a sleep/wait between sending the authentication nonce and checking the statusbyte: code <- md5(paste(md5(code), nonce, sep = "")) %>% charToRaw() # send username + code auth <- c(charToRaw(username), as.raw(0x00), code, as.raw(0x00)) writeBin(auth, private$conn) ==> Sys.sleep(.1) Accepted <- readBin(conn, what = "raw", n = 1) ==0 My knowledge of working with sockets is limited so maybe you can answer my question. Does the need of using a sleep means I need to fix a bug in the R code or should I use a setting in BaseX that takes into account the required delay? Ben Engbers

3 2