Main Page » Mailing List » January 2015

DBA users permissions

Tuesday, 6 January 2015 · 4 messages · last reply 9 Jan 2015
JC
Jérôme Chauveau6 Jan 2015 16:48 #
Hi, Here a "bug" I found (tested with the last release snapshot of the day) when using the DBA frontend (my BaseX server is embedded in a Tomcat ): a - I created a new user "myUser" from the DBA frontend b - I granted this one on a DB with local READ permissions Everything was fine until I restarted my Tomcat: the myUser's privileges has been reset to NONE. Hope this feedback helps. Regards. Jérôme.
-- Jérôme Chauveau - SAIC-CERTIC - Campus 4 Université de Caen Basse-Normandie
CG
Christian Grün8 Jan 2015 14:54 #
Hi Jérôme, I have just uploaded a new snapshot; could you try it? If it does not solve the problem, I would be interested to hear if… * the users.xml file is created, or modified, after creating a new user * if yes, if this file is changed after granting the read permission * if yes, if the read permission can be found in that file Thanks in advance, Christian [1] http://files.basex.org/releases/latest
Quoted text · Jérôme Chauveau · 25 lines
On Tue, Jan 6, 2015 at 4:48 PM, Jérôme Chauveau <jerome.chauveau at unicaen.fr> wrote: > Hi, > > Here a "bug" I found (tested with the last release snapshot of the day) when > using the DBA frontend (my BaseX server is embedded in a Tomcat ): > > a - I created a new user "myUser" from the DBA frontend > b - I granted this one on a DB with local READ permissions > > > Everything was fine until I restarted my Tomcat: the myUser's privileges has > been reset to NONE. > > Hope this feedback helps. > > Regards. > > Jérôme. > > > -- > Jérôme Chauveau - SAIC-CERTIC - Campus 4 > Université de Caen Basse-Normandie >
JC
Jérôme Chauveau9 Jan 2015 12:59 #
Hi, My current snapshot is the BaseX80-20150108.170819 one. I deployed its war version in my Tomcat server. Now, i get errors with the command line client too: 1 - basex war deploiement. No db, no users.xml 2 - With the command line client:
Quoted text · Christian Grün · 3 lines
> create database plop_db > create user plop (users.xml created) > grant read on plop_db to plop (users.xml modified with read
permissions for plop on plop_db [1])
Quoted text · Christian Grün · 1 line
>show users on plop_db
Username Permission --------------------
Quoted text · Christian Grün · 2 lines
plop read > exit
3 - Tomcat restart 4 - With the command line client:
Quoted text · Christian Grün · 1 line
> show users on plop_db
Username Permission -------------------- plop none while the users.xml did not change [1]
-------------------------------------------------------
[1]:
<user name="plop" permission="none">
     <password algorithm="digest">
       <hash>c3211e9a5166ba8e4d3221e797fe5096</hash>
     </password>
     <password algorithm="salted-sha256">
       <salt>...</salt>
       <hash>...</hash>
     </password>
     <database pattern="plop_db" permission="read"/>
   </user>
-------------------------------------------------------
How could my client return "none" permission while the users.xml file
contains "read" ones?
Could you advice me on which stable version (on user permission managment) i should use ? Hope this helps. Regards. Jérôme
Quoted text · Christian Grün · 42 lines
Le 08/01/2015 14:54, Christian Grün a écrit : > Hi Jérôme, > > I have just uploaded a new snapshot; could you try it? > > If it does not solve the problem, I would be interested to hear if… > > * the users.xml file is created, or modified, after creating a new user > * if yes, if this file is changed after granting the read permission > * if yes, if the read permission can be found in that file > > Thanks in advance, > Christian > > [1] http://files.basex.org/releases/latest > > > On Tue, Jan 6, 2015 at 4:48 PM, Jérôme Chauveau > <jerome.chauveau at unicaen.fr> wrote: >> Hi, >> >> Here a "bug" I found (tested with the last release snapshot of the day) when >> using the DBA frontend (my BaseX server is embedded in a Tomcat ): >> >> a - I created a new user "myUser" from the DBA frontend >> b - I granted this one on a DB with local READ permissions >> >> >> Everything was fine until I restarted my Tomcat: the myUser's privileges has >> been reset to NONE. >> >> Hope this feedback helps. >> >> Regards. >> >> Jérôme. >> >> >> -- >> Jérôme Chauveau - SAIC-CERTIC - Campus 4 >> Université de Caen Basse-Normandie >>
-- Jérôme Chauveau - SAIC-CERTIC - Campus 4 Université de Caen Basse-Normandie
CG
Christian Grün9 Jan 2015 13:34 #
Jérôme, Thanks again for reporting this. I was first misled by the assumption that the problem was due to Tomcat (which I haven't tested so far), but I now noticed it was due to the parser that reads the users.xml file.
Quoted text · Jérôme Chauveau · 2 lines
> Could you advice me on which stable version (on user permission managment) i > should use ?
With 8.0, many things in user management have changed under the hood. BaseX 8.0 will be out in appr. one month. We do our best to keep the current snapshot stable. The fix is available since the latest update [1]. Best, Christian PS: Long live Charlie Hebdo [1] http://files.basex.org/releases/latest
Quoted text · Jérôme Chauveau · 109 lines
On Fri, Jan 9, 2015 at 12:59 PM, Jérôme Chauveau <jerome.chauveau at unicaen.fr> wrote: > Hi, > > My current snapshot is the BaseX80-20150108.170819 one. > I deployed its war version in my Tomcat server. > > Now, i get errors with the command line client too: > > 1 - basex war deploiement. No db, no users.xml > 2 - With the command line client: > > create database plop_db > > create user plop (users.xml created) > > grant read on plop_db to plop (users.xml modified with read > permissions for plop on plop_db [1]) > >show users on plop_db > Username Permission > -------------------- > plop read > > exit > 3 - Tomcat restart > 4 - With the command line client: > > show users on plop_db > Username Permission > -------------------- > plop none > > while the users.xml did not change [1] > > ------------------------------------------------------- > [1]: > <user name="plop" permission="none"> > <password algorithm="digest"> > <hash>c3211e9a5166ba8e4d3221e797fe5096</hash> > </password> > <password algorithm="salted-sha256"> > <salt>...</salt> > <hash>...</hash> > </password> > <database pattern="plop_db" permission="read"/> > </user> > ------------------------------------------------------- > How could my client return "none" permission while the users.xml file > contains "read" ones? > > Could you advice me on which stable version (on user permission managment) i > should use ? > > Hope this helps. > > Regards. > > Jérôme > > > > > Le 08/01/2015 14:54, Christian Grün a écrit : > >> Hi Jérôme, >> >> I have just uploaded a new snapshot; could you try it? >> >> If it does not solve the problem, I would be interested to hear if… >> >> * the users.xml file is created, or modified, after creating a new user >> * if yes, if this file is changed after granting the read permission >> * if yes, if the read permission can be found in that file >> >> Thanks in advance, >> Christian >> >> [1] http://files.basex.org/releases/latest >> >> >> On Tue, Jan 6, 2015 at 4:48 PM, Jérôme Chauveau >> <jerome.chauveau at unicaen.fr> wrote: >>> >>> Hi, >>> >>> Here a "bug" I found (tested with the last release snapshot of the day) >>> when >>> using the DBA frontend (my BaseX server is embedded in a Tomcat ): >>> >>> a - I created a new user "myUser" from the DBA frontend >>> b - I granted this one on a DB with local READ permissions >>> >>> >>> Everything was fine until I restarted my Tomcat: the myUser's privileges >>> has >>> been reset to NONE. >>> >>> Hope this feedback helps. >>> >>> Regards. >>> >>> Jérôme. >>> >>> >>> -- >>> Jérôme Chauveau - SAIC-CERTIC - Campus 4 >>> Université de Caen Basse-Normandie >>> > > > -- > Jérôme Chauveau - SAIC-CERTIC - Campus 4 > Université de Caen Basse-Normandie >

Written for BaseX 7.9. BaseX may have changed since: please check the current documentation.

« Feature request: RNG and Schematron validationStoring sequences of atomic type into BaseX ? »
⚡Generated with XQuery