Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Dimitry Sibiryakov
Alex Peshkoff via Firebird-devel wrote 13.12.2021 11:14: I suppose DS meant something like this: # ./isql -user guest employee Database: employee, User: GUEST SQL> select sum_args(1,2,3) from rdb$database; Statement failed, SQLSTATE = 28000 no permission for EXECUTE access to FUNCTION SUM_ARGS

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Alex Peshkoff via Firebird-devel
On 12/13/21 12:56, Adriano dos Santos Fernandes wrote: On 12/12/2021 14:55, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 12.12.2021 18:52: If it does not return sensitive information, I see no problem in add it to examples UDR project. With a check for SYSDBA I see no

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Alex Peshkoff via Firebird-devel
On 12/13/21 14:00, Dimitry Sibiryakov wrote: Vlad Khorsun wrote 13.12.2021 11:53: 13.12.2021 12:45, Dimitry Sibiryakov пишет: Vlad Khorsun wrote 13.12.2021 10:32: Our IFirebirdConf implementation is not generic enough to provide way to get value of any known setting as string.    IMHO it

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Dimitry Sibiryakov
Vlad Khorsun wrote 13.12.2021 10:32: Our IFirebirdConf implementation is not generic enough to provide way to get value of any known setting as string. IMHO it is ok for such UDR to return only subset of known parameters converting them into strings by hand. -- WBR, SD.

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Adriano dos Santos Fernandes
On 13/12/2021 07:14, Alex Peshkoff via Firebird-devel wrote: >> The problem is that if it's available in the server, it can be declared >> in all databases. > > But since v.3 we have control on access to UDR. I suppose DS meant > something like this: > > # ./isql -user guest employee > Database:

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Dimitry Sibiryakov
Adriano dos Santos Fernandes wrote 13.12.2021 12:17: Database administrator does not always have access to full server. And database developers create code (or declare external routines) in database. In well organized environment they don't. Developers just prepare script that is applied

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Vlad Khorsun
13.12.2021 12:45, Dimitry Sibiryakov пишет: Vlad Khorsun wrote 13.12.2021 10:32: Our IFirebirdConf implementation is not generic enough to provide way to get value of any known setting as string.   IMHO it is ok for such UDR to return only subset of known parameters converting them into

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Dimitry Sibiryakov
Vlad Khorsun wrote 13.12.2021 11:53: 13.12.2021 12:45, Dimitry Sibiryakov пишет: Vlad Khorsun wrote 13.12.2021 10:32: Our IFirebirdConf implementation is not generic enough to provide way to get value of any known setting as string.    IMHO it is ok for such UDR to return only subset of

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Adriano dos Santos Fernandes
On 12/12/2021 14:55, Dimitry Sibiryakov wrote: > Alex Peshkoff via Firebird-devel wrote 12.12.2021 18:52: >>> >>> If it does not return sensitive information, I see no problem in add >>> it to examples UDR project. >> >> With a check for SYSDBA I see no security risk with this UDR > >   Isn't

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Vlad Khorsun
11.12.2021 23:01, Alex Peshkoff via Firebird-devel wrote: I see no big use in full support of v.3. Requested UDR is trivial but I highly displike requirement of keeping it in std distro of firebird. I see no problem to add such UDR into samples but, unfortunately, it can't be implemented

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Dimitry Sibiryakov
Alex Peshkoff via Firebird-devel wrote 13.12.2021 12:05:   Don't forget about subj: this UDR is needed only to let QA suite to check exact parameters of Firebird config. It does need "any known setting". As soon as we put it into our std distro (even as an exanple) it's loosing that

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-13 Thread Alex Peshkoff via Firebird-devel
Gabor, please check FB5 installer on aarch64. A. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-13 Thread Gabor Boros
2021.12.13. 18:34 keltezéssel, Alex Peshkoff via Firebird-devel írta: Gabor, please check FB5 installer on aarch64. A. Build 84656f1 from scratch and the installation works as expected. After that connection works from a remote client (before and after rebooted the server too). Gabor