Re: [Firebird-devel] Values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES

2021-05-08 Thread Alex Peshkoff via Firebird-devel

On 5/8/21 3:10 PM, Mark Rotteveel wrote:

On 08-05-2021 13:55, Mark Rotteveel wrote:

Where can I find the values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES.

I assume it's a bitset, so which bits map to which privilege?


After some experimentation, it looks like the bit positions map to the 
RDB$TYPE for RDB$SYSTEM_PRIVILEGES, meaning that bit 0 is unused.


If this is incorrect, let me know.



Correct, just one small addition - system privileges are defined in 
src/jrd/SystemPrivileges.h, later they are copied to RDB$TYPES.





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Linux installer and system library directory

2021-05-08 Thread Dimitry Sibiryakov

08.05.2021 16:51, Alex Peshkoff via Firebird-devel wrote:
Does all that mean that we have problems finding a directory where to create soft link to 
fbclient?

If yes - do you have suggestion how to find that (primary lib) directory better?


  We should leave creation of links to ldconfig, IMHO, because it knows where 
to create them.

--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Linux installer and system library directory

2021-05-08 Thread Alex Peshkoff via Firebird-devel
Does all that mean that we have problems finding a directory where to 
create soft link to fbclient?
If yes - do you have suggestion how to find that (primary lib) directory 
better?

If yes - why not just fix installer?




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] Usage of dynamic libncurses versus static termcap

2021-05-08 Thread Adriano dos Santos Fernandes
Hi!

Usage of dynamic libncurses is problematic in Firebird, as it not always
match the versions available in Linux distributions.

Current FB 4.0-RC1 does not install in Ubuntu 18.04 LTS, which is not
the latest, but still supported.

I'm definitively not an expert on these libraries, but I tried to link
it statically and still have editline working (build and test done in
same system - Ubuntu 20.04).

Official FB 4.0-RC1 isql depends on:
libncurses.so.6 => /lib/x86_64-linux-gnu/libncurses.so.6
(0x7fcd0995d000)

With the attached patch, I avoided that dependency.


Adriano
diff --git a/configure.ac b/configure.ac
index 0a3de368ac..ef5fc0c980 100644
--- a/configure.ac
+++ b/configure.ac
@@ -862,9 +862,9 @@ dnl Check for libraries
 AC_SEARCH_LIBS(dlopen, dl)
 AC_CHECK_LIB(m, main)
 if test "$EDITLINE_FLG" = "Y"; then
-	AC_CHECK_LIB(curses, tgetent, TERMLIB=curses, \
-		AC_CHECK_LIB(ncurses, tgetent, TERMLIB=ncurses, \
-			AC_CHECK_LIB(termcap, tgetent, TERMLIB=termcap, \
+	AC_CHECK_LIB(termcap, tgetent, TERMLIB=:libtermcap.a, \
+		AC_CHECK_LIB(curses, tgetent, TERMLIB=curses, \
+			AC_CHECK_LIB(ncurses, tgetent, TERMLIB=ncurses, \
 AC_CHECK_LIB(tinfo, tgetent, TERMLIB=tinfo, \
 	AC_MSG_ERROR(termcap support not found)
 	AC_SUBST(TERMLIB)
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES

2021-05-08 Thread Mark Rotteveel

On 08-05-2021 13:55, Mark Rotteveel wrote:

Where can I find the values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES.

I assume it's a bitset, so which bits map to which privilege?


After some experimentation, it looks like the bit positions map to the 
RDB$TYPE for RDB$SYSTEM_PRIVILEGES, meaning that bit 0 is unused.


If this is incorrect, let me know.

Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] Values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES

2021-05-08 Thread Mark Rotteveel

Where can I find the values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES.

I assume it's a bitset, so which bits map to which privilege?

Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Meaning of RDB$ACTIVE_FLAG and RDB$AUTO_ENABLE of RDB$PUBLICATIONS

2021-05-08 Thread Mark Rotteveel

On 08-05-2021 13:22, Dimitry Sibiryakov wrote:

08.05.2021 13:02, Mark Rotteveel wrote:
As to RDB$AUTO_ENABLE, I have no clue, and I can't find anything 
related to this in the release notes. Is this reserved for future use?


   Quote from README.replication:


-- to replicate all tables (including the ones created later):
ALTER DATABASE INCLUDE ALL TO PUBLICATION


-- to disable replication of all tables (including the ones created 
later):

ALTER DATABASE EXCLUDE ALL FROM PUBLICATION


   It must be this flag.



Thanks, it looks like you're right. I hadn't connected the dots between 
those two.


Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Meaning of RDB$ACTIVE_FLAG and RDB$AUTO_ENABLE of RDB$PUBLICATIONS

2021-05-08 Thread Dimitry Sibiryakov

08.05.2021 13:02, Mark Rotteveel wrote:
As to RDB$AUTO_ENABLE, I have no clue, and I can't find anything related to this in the 
release notes. Is this reserved for future use?


  Quote from README.replication:


-- to replicate all tables (including the ones created later):
ALTER DATABASE INCLUDE ALL TO PUBLICATION



-- to disable replication of all tables (including the ones created later):
ALTER DATABASE EXCLUDE ALL FROM PUBLICATION


  It must be this flag.

--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] Meaning of RDB$ACTIVE_FLAG and RDB$AUTO_ENABLE of RDB$PUBLICATIONS

2021-05-08 Thread Mark Rotteveel
What is the meaning of RDB$ACTIVE_FLAG and RDB$AUTO_ENABLE of 
RDB$PUBLICATIONS, and what are their possible values?


For RDB$ACTIVE_FLAG I assume it is whether the publication is disabled 
or enabled with values 0 or 1. Is that correct.


As to RDB$AUTO_ENABLE, I have no clue, and I can't find anything related 
to this in the release notes. Is this reserved for future use?


Mark

--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Linux installer and system library directory

2021-05-08 Thread Dimitry Sibiryakov

08.05.2021 04:11, Adriano dos Santos Fernandes wrote:

But my machine is also using 20.10 and does not have that directory.


  cat /etc/ld.so.conf.d/*
  man ldconfig

--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel