Re: [Firebird-devel] Values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES
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
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
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
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
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
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
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
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
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
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