[firebird-support] Users for application

2016-06-22 Thread 'Daniel Miller' dmil...@amfes.com [firebird-support]
I don't know if this specific question has been asked - but searches haven't given me a close enough answer so hopefully this is a little new. Separate from security theories and considerations of "good practice", what, if any, benefits accrue from using multiple users when accessing a

Re: [firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello , > 22.06.2016 13:44, Martijn Tonies wrote: >> When connected to the database from another application, here: C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v -user sysdba -pas masterkey "e:\temp\2014 FB Conference.fdb" "e:\temp\2014 FB Conference.bak" >>> >>>

Re: [firebird-support] Re: gbak with -se switch?

2016-06-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Dmitry, When connected to the database from another application, here: C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v -user sysdba -pas masterkey "e:\temp\2014 FB Conference.fdb" "e:\temp\2014 FB Conference.bak" >>> >>> Hostless connection string, as I

[firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.06.2016 13:44, Martijn Tonies wrote: > >>> When connected to the database from another application, here: >>> C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v >>> -user sysdba -pas masterkey >>> "e:\temp\2014 FB Conference.fdb" "e:\temp\2014 FB Conference.bak" >> >>Don't you forget

[firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.06.2016 13:40, Dmitry Yemanov wrote: > Worth registering in the tracker. It seems it's already there: http://tracker.firebirdsql.org/browse/CORE-5263 Dmitry

Re: [firebird-support] Re: gbak with -se switch?

2016-06-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
>22.06.2016 12:14, 'Martijn Tonies (Upscene Productions)' >m.ton...@upscene.com >[firebird-support] wrote: >> When connected to the database from another application, here: >> C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v >> -user sysdba -pas masterkey >> "e:\temp\2014 FB

[firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.06.2016 13:14, Martijn Tonies wrote: > > When connected to the database from another application, here: > C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v >-user sysdba -pas masterkey >"e:\temp\2014 FB Conference.fdb" "e:\temp\2014 FB Conference.bak" Hostless connection string,

Re: [firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.06.2016 12:14, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > When connected to the database from another application, here: > C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v > -user sysdba -pas masterkey > "e:\temp\2014 FB Conference.fdb"

[firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.06.2016 12:49, 'Martijn Tonies wrote: > >> I understood you as that regular gbak does not work when the database is >> in use, so now you try the -se switch. > > That is correct, but as you can see, using -se resulted in an error. So what was the error using gbak without -se? And what was the

Re: [firebird-support] Re: gbak with -se switch?

2016-06-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Dmitry, >> As per original example: >> Here’s the command: >> C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -se service_mgr –v >> -user sysdba -pas masterkey >>"MARTIJN-WS-DEV/3054:e:\temp\2014 FB Conference.fdb" >>"e:\temp\2014 FB Conference.bak" >> >> In my book, this

Re: [firebird-support] Re: gbak with -se switch?

2016-06-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
>And no, I couldn't find this in the documentation. FYI: http://firebirdsql.org/manual/gbak-cmdline.html#gbak-cmdline-backup "-SE[RVICE] This switch causes gbak to backup a remote database via the service manager. This causes the backup file to be created on the remote server, so the path

[firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.06.2016 12:35, 'Martijn Tonies wrote: > > As per original example: > Here’s the command: > C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -se service_mgr –v > -user sysdba -pas masterkey >"MARTIJN-WS-DEV/3054:e:\temp\2014 FB Conference.fdb" >"e:\temp\2014 FB Conference.bak" >

RE: [firebird-support] Strange Behavior

2016-06-22 Thread 'Mihalache Bogdan' bogdan.mihala...@soter.ro [firebird-support]
Nope there is only one database in the server. -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, June 22, 2016 11:41 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Strange Behavior

[firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.06.2016 11:25, 'Martijn Tonies wrote: > > Firebird 3 fails to back up when the database is in use It does not, as long as you don't use a "hostless" connection string. Dmitry

Re: [firebird-support] gbak with -se switch?

2016-06-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.06.2016 10:25, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > any clue? Move "MARTIJN-WS-DEV/3054" from database path to service_mgr path. -- WBR, SD.

[firebird-support] gbak with -se switch?

2016-06-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hi all, I’m trying to back up a database using gbak and the –se switch. But can’t seem to get it working. Here’s the command: C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -se service_mgr –v -user sysdba -pas masterkey "MARTIJN-WS-DEV/3054:e:\temp\2014 FB Conference.fdb"

[firebird-support] Strange Behavior

2016-06-22 Thread 'Mihalache Bogdan' bogdan.mihala...@soter.ro [firebird-support]
Hello! We have a 64 bits firebirds 2.5.2 SC server on a linux machine. The stange behavior that i don`t understrans is the following : - I`ve Used Database WorkBench to update a value in a table from 0 to 1. - I`ve commited the transaction and the new value was visible from

Re: [firebird-support] Gbak restore hangs on "activating and creating deferred indexes"

2016-06-22 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi Normally our restored DB will be 40GB. Is there any reason we would need significantly more space than this when restoring? Secondly are there specific bugs in 2.5.4 which could result in this behaviour? If not I would guess the 2.5.5 would not fix this problem? Best regards Jardar On Wed,