BaseX-Talk

basex-talk@mailman.uni-konstanz.de

8 participants
5255 discussions

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

Re: [basex-talk] BaseX-Talk Digest, Vol 144, Issue 4
by Rob Stapper 08 Dec '21

08 Dec '21

Hi Bachir, I’m afraid I’m not much of a help because the whole docker-sharade is new to me. I did encounter the same problems as you. Can’t say that it is a bug , it is more the combination: OS, docker and BaseX concerning ownership of the mounted docker files. I got it running by logging in as superuser in the docker container as described in previous mail and running: - docker exec -u 0 -it <myrunningcontainer> bash - chown -R basex:basex basex This changed the ownership of the file for me. I also optimized the database-files through the BaseX’s DBA-webapplication. This is all the help I can get you. Have fun, Rob Sent from Mail for Windows From: basex-talk-request(a)mailman.uni-konstanz.de Sent: Wednesday, December 8, 2021 12:00 PM To: basex-talk(a)mailman.uni-konstanz.de Subject: BaseX-Talk Digest, Vol 144, Issue 4 Send BaseX-Talk mailing list submissions to basex-talk(a)mailman.uni-konstanz.de To subscribe or unsubscribe via the World Wide Web, visit https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk or, via email, send a message with subject or body 'help' to basex-talk-request(a)mailman.uni-konstanz.de You can reach the person managing the list at basex-talk-owner(a)mailman.uni-konstanz.de When replying, please edit your Subject line so it is more specific than "Re: Contents of BaseX-Talk digest..." Today's Topics: 1. reply to 2. docker basexhttp wrong owner of /srv/basex/* (scbh) (Rob Stapper) 2. Re: reply to 2. docker basexhttp wrong owner of /srv/basex/* (scbh) (scbh) ---------------------------------------------------------------------- Message: 1 Date: Tue, 7 Dec 2021 12:37:00 +0100 From: Rob Stapper <r.stapper(a)lijbrandt.nl> To: "basex-talk(a)mailman.uni-konstanz.de" <basex-talk(a)mailman.uni-konstanz.de> Subject: [basex-talk] reply to 2. docker basexhttp wrong owner of /srv/basex/* (scbh) Message-ID: <fe337fd0-5751-11ec-aee6-005056998788(a)smtp.kpnmail.nl> Content-Type: text/plain; charset="utf-8" Hi Bach, Login as super-user[1] in your running container to change ownerschip. [1] docker exec -u 0 -it <myrunningcontainer> bash Succes, Rob Sent from Mail for Windows -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

1 0

reply to 2. docker basexhttp wrong owner of /srv/basex/* (scbh)
by Rob Stapper 07 Dec '21

07 Dec '21

Hi Bach, Login as super-user[1] in your running container to change ownerschip. [1] docker exec -u 0 -it <myrunningcontainer> bash Succes, Rob Sent from Mail for Windows -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk