[firebird-support] Re: replying...

2017-08-14 Thread hele...@iinet.net.au [firebird-support]
If you are talking about the web interface, I think you type your reply where indicated and then press Reply or Send. Testing it now - pressing Send.

[firebird-support] replying...

2017-08-14 Thread prosse...@yahoo.com [firebird-support]
When I press reply I can't type anything in! And I want to thank someone for sorting out my udf problem!

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
> Absolutely right. My point was having root should is not crucial. It should read: having root is not crucial Typing and having dinner at the same time is not healthy for your stomach and for your readers. Apologies. Tomasz ---

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 14.08.2017 at 18:03, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > If you have sysdba permissions, you can do nbackup via services. > Security database is small enough for gbak too. Absolutely right. My point was having root should is not crucial. regards Tomasz

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.08.2017 18:00, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > I manage a couple of databases > located on servers I don't have root accounts on, and it's possible, > although more complicated. If you have sysdba permissions, you can do nbackup via services. Secu

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Nick Upson n...@telensa.com [firebird-support]
yes, I can place the call to nbackup in a crontab for firebird or root, that seems to be the only way On 14 August 2017 at 16:51, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.08.2017 17:44, Nick Upson n...@telensa.com [firebird-support] wrote: > > because this is from cro

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 14.08.2017 at 17:41, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.08.2017 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: >> if I do nbackup . it fails, telling me I cannot access the security2.fdb >> (as a normal >> user) > > Why can't you use su

RE: [firebird-support] permissions nbackup

2017-08-14 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]
> its the generic one For whatever linux distribution you are using..., its not the projects build on SourceForge for example. I suspect some one (who maintains Firebird for your Linux distro), may have been over zealous with the security. Any user who is part of the group firebird should be abl

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 14.08.2017 at 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: > if I do nbackup . it fails, telling me I cannot access the > security2.fdb (as a normal user) According to nbackup manual https://www.firebirdsql.org/manual/nbackup-functions-params.html for backing up (-B) you n

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.08.2017 17:44, Nick Upson n...@telensa.com [firebird-support] wrote: > because this is from cron, so key-based auth is out and I don't want to put > passwords / > keys on the server According to google you don't need password for cron jobs: https://stackoverflow.com/questions/8475694/how-t

Re: [firebird-support] permissions nbackup

2017-08-14 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]
The default linux tar install has the following for security2.fdb amongst others MakeFileFirebirdWritable() { FileName=$1 chown $RunUser:$RunGroup $FileName if [ "$RunUser" = "root" ] # In that case we must open databases, locks, etc. to the world... # That's a pi

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Nick Upson n...@telensa.com [firebird-support]
because this is from cron, so key-based auth is out and I don't want to put passwords / keys on the server I can run from a root cron, with possible su to firebird, but was hoping for something better On 14 August 2017 at 16:41, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: >

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.08.2017 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: > if I do nbackup . it fails, telling me I cannot access the security2.fdb > (as a normal > user) Why can't you use su to change current user to root or firebird? -- WBR, SD. --

Re: [firebird-support] permissions nbackup

2017-08-14 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]
Apologies, it does get changed, I was looking in the wrong place in the MacOS installer... SuperServer chmod 600 security2.fdb Classic chmod 660 security2.fdb Regards Paul

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Nick Upson n...@telensa.com [firebird-support]
its the generic one # ls -l /var/lib/firebird/system/security2.fdb -rw--- 1 firebird firebird 1064960 Aug 14 16:34 /var/lib/firebird/system/security2.fdb # rpm -qa | grep fire firebird-classic-common-2.5.5.26952.0-2.el6.x86_64 firebird-libfbembed-2.5.5.26952.0-2.el6.x86_64 firebird-classic-2.5

Re: [firebird-support] permissions nbackup

2017-08-14 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]
<<# ls -lart /var/lib/firebird/system/security2.fdb -rw--- 1 firebird firebird 1171456 Aug 14 14:25 /var/lib/firebird/system/security2.fdb>> Is this a distro specific install or the more generic Firebird one from SourceForge? I ask, because on MacOS the default security is the following -rw

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Nick Upson n...@telensa.com [firebird-support]
if I do nbackup . it fails, telling me I cannot access the security2.fdb (as a normal user) I would have expected the file to have group rw enabled so that permitted users can be a member of group firebird to do this On 14 August 2017 at 16:16, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [f

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 14.08.2017 at 15:51, Nick Upson n...@telensa.com [firebird-support] wrote: > I'm looking at using nbackup but the file permissions on security2.fdb mean > only firebird or root can do so, is that the way it is supposed to be? Definitely. You wouldn't like any third party to access the password

[firebird-support] permissions nbackup

2017-08-14 Thread Nick Upson n...@telensa.com [firebird-support]
Hi I'm looking at using nbackup but the file permissions on security2.fdb mean only firebird or root can do so, is that the way it is supposed to be? *# ls -lart /var/lib/firebird/system/security2.fdb* *-rw--- 1 firebird firebird 1171456 Aug 14 14:25 /var/lib/firebird/system/security2.fdb*