[firebird-support] Re: replying...

[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...

[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

[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






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] permissions nbackup

[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






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] permissions nbackup

[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.
   Security database is small enough for gbak too.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] permissions nbackup

[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 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-to-
> specify-in-crontab-by-what-user-to-run-script
>
>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/
> resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] permissions nbackup

[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 to change current user to root or firebird?

That's a bit off the point, isn't it? I manage a couple of databases 
located on servers I don't have root accounts on, and it's possible, 
although more complicated. So, su-ing is not always an option.

reagrds
Tomasz






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] permissions nbackup

[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-to-specify-in-crontab-by-what-user-to-run-script


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] permissions nbackup

['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 pity, but required if root RunUser choosen.
then
chmod a=rw $FileName
else
# This is good secure setting
chmod ug=rw,o= $FileName
fi

Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32

Re: [firebird-support] permissions nbackup

[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:

> 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.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/
> resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] permissions nbackup

[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.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] permissions nbackup

['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

['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-r--r--   1 pbeach  staff   729088 Feb 15 16:54 security2.fdb
And on install I do not make any effort to change it.

Regards
Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32

Re: [firebird-support] permissions nbackup

[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
[firebird-support]  wrote:

>
>
> 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 /
> security database directly, would you?
> On the other hand, in what way does it stop you from using nbackup? I
> suppose what you actually need to do is to backup / restore a normal
> database, not the system-wide security db.
>
> regards
> Tomasz
> 
>

Re: [firebird-support] permissions nbackup

[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 / 
security database directly, would you?
On the other hand, in what way does it stop you from using nbackup? I 
suppose what you actually need to do is to backup / restore a normal 
database, not the system-wide security db.

regards
Tomasz

[firebird-support] permissions nbackup

[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*