Re: [firebird-support] backup security3.fdb

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

I do not understand problem asked aboutSecurity3.fdb.It is normal database same 
as others. If you know how to backup any database no difference for 
security3.fdbRegards,Karol Bieniaszewski
null

Re: [firebird-support] backup security3.fdb

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.12.2019 12:30, ehmmm.fireb...@seznam.cz [firebird-support] wrote:
> Not good:  :)

   In this case nbackup is your only way.


-- 
   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] backup security3.fdb

[ehmmm.fireb...@seznam.cz [firebird-support]]

Not good:  :)





root@tux:/opt/firebird# gbak -b -se inet://127.0.0.1/service_mgr security.db
sss.fbk -user sysdba -password masterkey
gbak: ERROR:no permission for remote access to database security.db
gbak: ERROR:    Exiting before completion due to errors
gbak:Exiting before completion due to errors





If I enable RemoteAccess in databases.conf then it works.

But anyway thank you for your answer.

I've never used "-se" parameter.





Jakub






-- Původní e-mail --
Od: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
Komu: firebird-support@yahoogroups.com
Datum: 10. 12. 2019 11:31:38
Předmět: Re: [firebird-support] backup security3.fdb 
"10.12.2019 08:58, ehmmm.fireb...@seznam.cz [firebird-support] wrote: 
> Please, what is the best way? 

Try "gbak -se inet://server/serice_mgr security.db d:\backup\security.bak -
user sysdba 
-pass masterkey". 

-- 
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] backup security3.fdb

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.12.2019 08:58, ehmmm.fireb...@seznam.cz [firebird-support] wrote:
> Please, what is the best way?

   Try "gbak -se inet://server/serice_mgr security.db d:\backup\security.bak 
-user sysdba 
-pass masterkey".

-- 
   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/

[firebird-support] backup security3.fdb

[ehmmm.fireb...@seznam.cz [firebird-support]]

Hello,

I'm trying to find out how to backup security DB in Firebird 3.

I  googled that in Firebird 2 it was possible via Service Manager.

And for Firebird 3 I  found if "Firebird 3.0.3 Release Notes" that I can 
enable RemoteAccess for security3.fdb in databases.conf, but I don't like 
this option very much.

Also there was somewhere written that I can "establish a direct, embedded 
connection to the security database".

But I'm not sure I can do this with Firebird in SuperServer mode.

Please, what is the best way?





Best regards,

Jakub

RE: [firebird-support] backup on amd64 restore on raspberry pi 3

['Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]]

Et al,

> on https://www.ibphoenix.com/resources/documents/general/doc_323
> "Rows are restricted to 32767 bytes."

That doc has now been updated to reflect all versions of Firebird upto Firebird 
3.

Regards
Paul

Re: [firebird-support] backup on amd64 restore on raspberry pi 3

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 25-8-2018 20:46, pab...@adinet.com.uy [firebird-support] wrote:
> Mark, checking on max row size I find :
> 
> on https://www.ibphoenix.com/resources/documents/general/doc_323
> "Rows are restricted to 32767 bytes."
> 
> on https://www.firebirdsql.org/en/firebird-technical-specifications/
> "Maximum row size     64 KB"
> 
> Counting first reference, I'm out of bounds big time ...
> 
> CREATE TABLE TABLALOG
> (
>    NID ENTERO NOT NULL,
>    NUSUARIO ENTERO NOT NULL,
>    TSINGRESO T_STAMP,
>    DALCANCE CHAR_255CI,
>    DAPP CHAR_50CI,
>    OEVENTO CLA_SHORT,
>    DIPV4 CHAR_15,
>    DIPV6 CHAR_50,
>    DHOST CHAR_255CI,
>    DENTIDAD CHAR_50CI,
>    OACCION CHAR_50CI,
>    DCONTENIDO VARCHAR(32765),
>    CONSTRAINT PK_TABLALOG PRIMARY KEY (NID)
> );
> 
> Where domains are:
> ENTERO integer
> T_TAMP is a timestamp
> CHAR_255CI varchar(255) AI_CI
> CHAR_50 varchar(50) AI_CI
> CHAR_15 varchar(15) AI_CI
> CLA_SHORT short
> 
> Database is generated as ISO-8859-1, so using 2 bytes per char, I think
> I'm past all bounds..

You are not, ISO-8859-1 is a single byte character set, so your row is 
33526 bytes, which is far below 64kb.

> I recreated the varchar(32765) attribute to varchar(255), backuped an 
> restored. The error now shows on another table which has more than 32767 
> bytes (another log table, almost identical):
> gbak:    restoring index PK_ERRORLOG
> gbak:restoring data for table ERRORLOG
> gbak: ERROR:message length error (encountered -32512, expected 33024)
> gbak: ERROR:gds_$send failed
> gbak:Exiting before completion due to errors
> 
> 
> I guess I must use a 32 kbytes max instead of 64kbytes, right?

I'm not sure how and why you made the leap from me telling that this 
seems to be a mixup in signed and unsigned integers, from thinking that 
this has to do with row sizes. It doesn't.

This would indicate a bug in the gbak on the raspberry pi port. Either 
with using wrong integer sizes (16 bit vs 32 bit) or wrong integers 
(signed vs unsigned).

Report a bug in the tracker or to the downstream maintainer of the 
Raspberry Pi port you're using (as the Firebird project itself doesn't 
produce that port AFAIK).

> How two byte per char count here ?
> 
> Is the limit for record declaration or actual record size ?
> 
> I'm worried that server didn't yelled at me when generating/altering 
> database ddl .

If you created a row that was too wide, the server would let you know.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] backup on amd64 restore on raspberry pi 3

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 24-8-2018 18:31, pab...@adinet.com.uy [firebird-support] wrote:
> As I could backup and restore databases from and to firebird 3 on the 
> same running platform, next step is apply it to raspberry pi.
> 
> I'm getting the following when restoring the same backup file wich 
> should be "transportable by default" :
> 
> gbak:opened file  mybackup-file.fbk
> gbak:transportable backup -- data in XDR format
> gbak:        backup file is compressed
> gbak:backup version is 10
> gbak:created database mydb, page_size 8192 bytes
> gbak:started transaction
> ...
> gbak:    restoring index RDB$PRIMARY1
> gbak:restoring data for table PLG$SRP
> gbak:   2 records restored
> gbak:    restoring index PK_TABLALOG
> gbak:    restoring index FK_TABLALOG_USUARIO
> gbak:restoring data for table TABLALOG
> gbak: ERROR:message length error (encountered -31984, expected 33552)
> gbak: ERROR:gds_$send fa iled
> gbak:Exiting before completion due to errors
> 
> Are format in these platforms compatible ? Both are, at least, little 
> endian.

It looks like a mix up of signed and unsigned 16 bit ints. -31984 is a 
signed 16 bit int as hex 0x8310, and as unsigned 16 bit int, that is 33552.

> Restoring file from v2.5 backup, gets the same problem .
> 
> Maybe I stop amd64 server and copy live db to rpi ?

Probably not. The database can use platform specific representations of 
data, and index values depend on the installed ICU version.

-- 
Mark Rotteveel

Re: [firebird-support] Backup Firebird 3.0.2 database using Service Manager

[pierr...@gmail.com [firebird-support]]

Will you believe me I I tell you I Read Quite Every Fucking 
[Manual/ReleaseNotes/ReadmeInDocFolder/Code] before asking ?
 

 I already clicked the "Send" button while I remembered having read that line 
some minutes ago :
 

 https://github.com/FirebirdSQL/firebird/blob/master/src/burp/burp.cpp#L297 
https://github.com/FirebirdSQL/firebird/blob/master/src/burp/burp.cpp#L297

Re: [firebird-support] Backup Firebird 3.0.2 database using Service Manager

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

09.10.2017 16:08, pierr...@gmail.com [firebird-support] wrote:
> If I try to use a remote connection to service_mgr

   RTFM -expected_db.


-- 
   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/

[firebird-support] Backup Firebird 3.0.2 database using Service Manager

[pierr...@gmail.com [firebird-support]]

Hi there,
 

 I'm desperately trying to backup a Firebird 3.0.2 database using UIB 
TUIBackup. My database is configured as this in databases.conf

 

 # security.db = $(dir_secDb)/security3.fdb
# {
#   RemoteAccess = false
#   DefaultDbCachePages = 50
# }

#
# My Databases
#
config = C:/ProgramData/PrYCorp/config.fdb
{
  SecurityDatabase = config
}
 

 I access this database using a TCPIP connection with this connection string : 
inet4://localhost/config
 

 I want to perform a database backup using UIB/TUIBackup. As I can't find a way 
to perform this backup I'm debugging SPB creation using fbsvcmgr :
 

 The only combination that works is :
 

 C:\>fbsvcmgr service_mgr -user DBOWNER -password ownerpasswd -action_backup 
-dbname config -bkp_file c:\programdata\prycorp\temp\config.fbk
 

 But that do not work when my application is connected to the database, I get 
this error :
 

 I/O error during "CreateFile (open)" operation for file "config"
-Error while trying to open file
-The process can not access this file because it is used by another process.
-Exiting before completion due to errors
 

 If I try to use a remote connection to service_mgr :
 

 C:\>fbsvcmgr localhost:service_mgr -user DBOWNER -password ownerpasswd 
-action_backup -dbname config -bkp_file c:\programdata\prycorp\temp\config.fbk
Error occurred during login, please check server firebird.log for details
 

 This is the error in Firebird.log :
 

 PIERRE-VMMon Oct 09 15:58:59 2017
Authentication error
I/O error during "CreateFile (open)" operation for file "C:\PROGRAM FILES 
(X86)\FIREBIRD30\SECURITY3.FDB"
Error while trying to open file
Le fichier spécifié est introuvable. 

 

 I do not deploy security3.fdb as it's not needed for normal database operation.
 

 Same with :
 

 C:\>fbsvcmgr localhost:service_mgr -user DBOWNER -password ownerpasswd 
-action_backup -dbname inet4://localhost/config -bkp_file 
c:\programdata\prycorp\temp\config.fbk
Error occurred during login, please check server firebird.log for details

C:\>fbsvcmgr service_mgr -user DBOWNER -password ownerpasswd -action_backup 
-dbname inet4://localhost/config -bkp_file 
c:\programdata\prycorp\temp\config.fbk
unavailable database
-Exiting before completion due to errors
 

 This switch combinations works with gbak (while the database is occupied by my 
application) :
 

 C:\> gbak -b -se localhost:service_mgr -user DBOWNER -password ownerpasswd 
config c:\programdata\prycorp\temp\config.fbk
 

 Question is : how to replicate this very last gbak command using either 
fbsvcmgr or the Firebird service API ?
 

 Many thanks for your help, regards,
 

 -- 
Pierre Yager
 Crisalid

 

[firebird-support] Backup & restore without dump using service manager

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Hi,

is there a way to backup and restore a database using the service manager?

The documentation gives example without service manager:
tux> gbak -backup emptest stdout | gbak -replace stdin emptest_2

But that needs to open the database in exclusive mode.

I've tried the following code but got errors:
tux> gbak -b -user sysdba -password masterkey -se localhost/3050:service_mgr 
/srv/firebird/db01.fdb stdout | gbak -replace stdin /srv/firebird/test.fdb
tux> gbak: ERROR:expected backup description record
tux> gbak:Exiting before completion due to errors

Regards,
Martin

RE: [firebird-support] Backup file padding

['Robert Harris' rob...@zzyzxl.com [firebird-support]]

Hi Dimitry,
  Cannot be 100% certain but 512 bytes was typically the sector size of hard
drives when gbak was written. Each sector contains only a single packet of
data, be-it 1 byte or 512 bytes. Reading/Writing data with the size of a
sector typically offers much better performance in terms of speed. Much the
same as memory alignment within an application. Also, writing pages of a
variable length means that internally a chain has to be managed, much like a
linked list, with pages of a known size chunks of data can be read using
single C fread statements which specify the block size.


Regards,

Robert


Robert Harris
Chief Technical Officer
Zzyzxl Ltd.

Web:  www.zzyzxl.com
email: rob...@zzyzxl.com

Main Office: 353 (0)45 864485
Support: 353 (0)45 864484
Cell: 353 (0)87 6676534

 

-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 25 September 2017 15:46
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Backup file padding

   Hello.

   What is the purpose of backup file being padded by zeros up to 512 bytes
block?

--
   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] Backup in embedded mode using C API - authentication problem

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.05.2016 22:08, Bunth Tamás btom...@gmail.com [firebird-support] wrote:
> It seems to me that firebird looks for the user name in the security2.fdb
> file, which shouldn't be used in an embedded server. What am I missing?

   There is no embedded server on Linux. You are trying to use Classic Server.

-- 
   WBR, SD.

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

[Bunth Tamás btom...@gmail.com [firebird-support]]

On 23 May 2016 at 21:01, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote

> >You don't need password, but user name must be.
>
When I add "SYSDBA" as a user name to the spb of isc_service_attach, I got
the following error:

*I/O error during "open" operation for file
"/usr/local/firebird/security2.fdb"
*Error while trying to open file
*No such file or directory
caused by
'isc_service_attach'

It seems to me that firebird looks for the user name in the security2.fdb
file, which shouldn't be used in an embedded server. What am I missing?

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.05.2016 20:37, Bunth Tamás btom...@gmail.com [firebird-support] wrote:
> As far as I know,
> I shouldn't pass username/password in the spb to isc_service_attach() in 
> embedded mode.

   You don't need password, but user name must be.

-- 
   WBR, SD.

[firebird-support] Backup in embedded mode using C API - authentication problem

[Bunth Tamás btom...@gmail.com [firebird-support]]

Hi,


I want to make a backup (.fbk) from a local database (.fdb). As far as I
know,
I shouldn't pass username/password in the spb to isc_service_attach() in
embedded mode. However,
I got an error during retrieving information with isc_service_query:


*Unable to perform operation.  You must be either SYSDBA or owner of the
database
*Exiting before completion due to errors
caused by
'isc_service_query'


So is it possible to backup a database in embedded mode?


Thank you,
Tamás Bunth

Re: [firebird-support] Backup with admin rights is prohibited?

[Gabor Boros gaborbo...@yahoo.com [firebird-support]]

2016. 04. 25. 13:27 keltezéssel, 'Thomas Steinmaurer' 
t...@iblogmanager.com [firebird-support] írta:
You forgot to mention role ADMIN in the command line.
>>>
>>> With "gbak -B -T -USER MYADMIN -ROLE RDB$ADMIN MYDB /home/user/MYDB.bak"
>>> got the same error.
>>
>> Other idea?
>
> Honestly, IMHO, if the user MYADMIN is a member of the RDB$ADMIN role in 
> MYDB, then your gbak call should work.

Works now. The correct command is:

gbak -B -T -USER MYADMIN -ROLE 'RDB$ADMIN' MYDB /home/user/MYDB.bak

So the role apostrophes.

Gabor






++

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] Backup with admin rights is prohibited?

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

> 2016. 04. 22. 15:57 keltezéssel, Gabor Boros gaborbo...@yahoo.com 
> [firebird-support] írta:
>> 2016. 04. 22. 15:37 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
>> [firebird-support] írta:
>>> 22.04.2016 15:34, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote:
 Now tried to do a backup (gbak -B -T
 -USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either
 SYSDBA or owner of the database".
>>>
>>>You forgot to mention role ADMIN in the command line.
>>
>> With "gbak -B -T -USER MYADMIN -ROLE RDB$ADMIN MYDB /home/user/MYDB.bak"
>> got the same error.
> 
> Other idea?

Honestly, IMHO, if the user MYADMIN is a member of the RDB$ADMIN role in MYDB, 
then your gbak call should work.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

Re: [firebird-support] Backup with admin rights is prohibited?

[Gabor Boros gaborbo...@yahoo.com [firebird-support]]

2016. 04. 22. 15:57 keltezéssel, Gabor Boros gaborbo...@yahoo.com 
[firebird-support] írta:
> 2016. 04. 22. 15:37 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] írta:
>> 22.04.2016 15:34, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote:
>>> Now tried to do a backup (gbak -B -T
>>> -USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either
>>> SYSDBA or owner of the database".
>>
>>You forgot to mention role ADMIN in the command line.
>
> With "gbak -B -T -USER MYADMIN -ROLE RDB$ADMIN MYDB /home/user/MYDB.bak"
> got the same error.

Other idea?

Gabor






++

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] Backup with admin rights is prohibited?

[Gabor Boros gaborbo...@yahoo.com [firebird-support]]

2016. 04. 22. 15:37 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] írta:
> 22.04.2016 15:34, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote:
>> Now tried to do a backup (gbak -B -T
>> -USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either
>> SYSDBA or owner of the database".
>
>You forgot to mention role ADMIN in the command line.

With "gbak -B -T -USER MYADMIN -ROLE RDB$ADMIN MYDB /home/user/MYDB.bak" 
got the same error.

Gabor






++

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] Backup with admin rights is prohibited?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

22.04.2016 15:34, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote:
> Now tried to do a backup (gbak -B -T
> -USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either
> SYSDBA or owner of the database".

   You forgot to mention role ADMIN in the command line.

-- 
   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/

[firebird-support] Backup with admin rights is prohibited?

[Gabor Boros gaborbo...@yahoo.com [firebird-support]]

Hi All,

I have a 3.0 database with self security database. Use an admin user 
(CREATE USER MYADMIN PASSWORD 'mypassword' GRANT ADMIN ROLE;) for daily 
admin work without any problem. Now tried to do a backup (gbak -B -T 
-USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either 
SYSDBA or owner of the database". But with SYSDBA (gbak -B -T -USER 
SYSDBA MYDB /home/user/MYDB.bak) the backup created successfully. This 
is very strange. Because the database created with MYOWNER user (and 
SELECT DISTINCT RDB$OWNER_NAME AS DATABASE_OWNER FROM RDB$RELATIONS 
WHERE (RDB$SYSTEM_FLAG = 1) give back MYOWNER correctly) and SYSDBA not 
exist anywhere(security3.fdb deleted after install).

Gabor






++

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] Backup Restore NOT NULL Columns

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello Thomas.

Please see my answer to Dimitry.

Thanks for your answer.

Hugo


On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com 
[firebird-support] wrote:


Hugo,

 Hello.

 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD
 NEW_COLUMN INTEGER NOT NULL). There were already some records in the
 table. FB didn´t raise any warning or exception.
 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise
 any warning or exception.
 3- I tried to restore the backup file to a new MYDB.FDB and FB raises
 and error: gbak: ERROR:validation error for column NAME, value *** 
null

 ***

 Let´s accept than the step 3 is coherent.

 So, why can I execute step 1 without troubles?

 Well, someone can tell me to use -no_validity to restore the database.
 Ok, it works. But, the column that should be NOT NULL will change,
 without warning, and I have to check my tables after restoring DB.

 I am using FB 2.5 and I tried using FB 3.0 too.

 Is it as I described or there is another way to treat this?

http://tracker.firebirdsql.org/browse/CORE-1748

See Dmitry's InterBase legacy comment.

I for one would simply reject adding new NOT NULL fields on a table 
with data if there is no DEFAULT clause provided.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.




--


Atenciosamente,

Hugo Eyng

Re: [firebird-support] Backup Restore NOT NULL Columns

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello Thomas.

I saw Dimtry´s comment.

About the DEFAULT CLAUSE, even provided, it acts only on new rows and 
not on preexisting rows. Is this true?


Hugo


On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com 
[firebird-support] wrote:


Hugo,

 Hello.

 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD
 NEW_COLUMN INTEGER NOT NULL). There were already some records in the
 table. FB didn´t raise any warning or exception.
 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise
 any warning or exception.
 3- I tried to restore the backup file to a new MYDB.FDB and FB raises
 and error: gbak: ERROR:validation error for column NAME, value *** 
null

 ***

 Let´s accept than the step 3 is coherent.

 So, why can I execute step 1 without troubles?

 Well, someone can tell me to use -no_validity to restore the database.
 Ok, it works. But, the column that should be NOT NULL will change,
 without warning, and I have to check my tables after restoring DB.

 I am using FB 2.5 and I tried using FB 3.0 too.

 Is it as I described or there is another way to treat this?

http://tracker.firebirdsql.org/browse/CORE-1748

See Dmitry's InterBase legacy comment.

I for one would simply reject adding new NOT NULL fields on a table 
with data if there is no DEFAULT clause provided.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.




--


Atenciosamente,

Hugo Eyng

[firebird-support] Backup Restore NOT NULL Columns

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello.

1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD 
NEW_COLUMN INTEGER NOT NULL). There were already some records in the 
table. FB didn´t raise any warning or exception.
2 - I created a backup file from MYDB.FDB using gbak.  FB didn´t raise 
any warning or exception.
3- I tried to restore the backup file to a new MYDB.FDB and FB raises 
and error: gbak: ERROR:validation error for column NAME, value *** null 
***

Let´s accept than the step 3 is coherent.

So, why can I execute step 1 without troubles?

Well, someone can tell me to use -no_validity to restore the database. 
Ok, it works. But, the column that should be NOT NULL will change, 
without warning, and I have to check my tables after restoring DB.

I am using FB 2.5 and I tried using FB 3.0 too.

Is it as I described or there is another way to treat this?

-- 


Atenciosamente,

Hugo Eyng







++

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] Backup Restore NOT NULL Columns

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

Hugo,

 Hello.
 
 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD 
 NEW_COLUMN INTEGER NOT NULL). There were already some records in the 
 table. FB didn´t raise any warning or exception.
 2 - I created a backup file from MYDB.FDB using gbak.  FB didn´t raise 
 any warning or exception.
 3- I tried to restore the backup file to a new MYDB.FDB and FB raises 
 and error: gbak: ERROR:validation error for column NAME, value *** null 
 ***
 
 Let´s accept than the step 3 is coherent.
 
 So, why can I execute step 1 without troubles?
 
 Well, someone can tell me to use -no_validity to restore the database. 
 Ok, it works. But, the column that should be NOT NULL will change, 
 without warning, and I have to check my tables after restoring DB.
 
 I am using FB 2.5 and I tried using FB 3.0 too.
 
 Is it as I described or there is another way to treat this?

http://tracker.firebirdsql.org/browse/CORE-1748

See Dmitry's InterBase legacy comment.


I for one would simply reject adding new NOT NULL fields on a table with data 
if there is no DEFAULT clause provided.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

[firebird-support] Backup/Restore Required ???

[t...@camalot.ca [firebird-support]]

Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3?

I have done it here without any issues so far, but thought I better ask the 
question.

Todd Brasseur
Compass Municipal Services Inc.

Re: [firebird-support] Backup/Restore Required ???

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 14 Nov 2014 08:08:59 -0800, t...@camalot.ca [firebird-support]
firebird-support@yahoogroups.com wrote:
 Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3?
 
 I have done it here without any issues so far, but thought I better ask
 the question.

It isn't technically necessary when moving from 2.5.2 to 2.5.3, but it is
necessary when moving from 2.5.1 (!). The release notes say this:
http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes253.html#notes-253

Between 'major' versions of Firebird (eg 2.0 to 2.1 to 2.5) it is not
required to backup/restore, but you need to do it to upgrade the database
to access some of the new features. To Firebird 3 you will always need to
do a backup and restore because older database structure versions are not
supported.

Mark

Re: [firebird-support] Backup/Restore Required ???

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

 Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3?

Usually this is not needed when the ODS version hasn't been changed 
(between maintenance releases), but there is a special situation when 
coming from 2.5.1:
http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes253.html#notes-253

So, if your database was previously created with 2.5.2 or 2.5.0 then you 
are fine. If the database has been created with 2.5.1 then consider the 
warning in the link above.


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.



 I have done it here without any issues so far, but thought I better ask
 the question.

 Todd Brasseur
 Compass Municipal Services Inc.

 

[firebird-support] Backup

[Art McCabe]

I am trying to make a backup of our database that is on a Unix box, from my 
windows computer.

I have used: Firebird Maestro, IP Firebird Database Manager, Firebird SQL 
Studio.
I am not sure if I am doing something wrong, or just not possible.

When I run the backup from these tools, and select the database and final 
location and press start, it looks like it is going thru a backup process, but 
the fbk file is not created on my computer.

I am new to firebird and the GUI Tools that may be available. 


Any assistance is appreciated.

 
Art

Re: [firebird-support] Backup

[Alexandre Benson Smith]

Em 7/3/2014 14:13, Art McCabe escreveu:




I am trying to make a backup of our database that is on a Unix box, 
from my windows computer.


I have used: Firebird Maestro, IP Firebird Database Manager, Firebird 
SQL Studio.

I am not sure if I am doing something wrong, or just not possible.

When I run the backup from these tools, and select the database and 
final location and press start, it looks like it is going thru a 
backup process, but the fbk file is not created on my computer.


I am new to firebird and the GUI Tools that may be available.

Any assistance is appreciated.

Art



I don't know any of these tools...

But I strongly suggest that you use the native firebird applications

use gbak for back-up (it's on the installation directory under the bin 
folder)


the most simple way is:

gbak IP_OF_THE_SERVER:NAME_OF_YOUR_DATABASE NAME_OF_BACKUP_FILE -user 
sysdba -password masterkey -v


of course change the password for the one you defined.

the -v switch is optional, but I think it will hep you once it will show 
the progress


see you !

Re: [firebird-support] Backup

[artmccabe]

Thank you, I used the gbak to run the backup and that worked.






Art





From: Alexandre Benson Smith
Sent: ‎Friday‎, ‎March‎ ‎7‎, ‎2014 ‎2‎:‎09‎ ‎PM
To: firebird-support@yahoogroups.com




  





Em 7/3/2014 14:13, Art McCabe escreveu:







I am trying to make a backup of our database that is on a Unix box, from my 
windows computer.




I have used: Firebird Maestro, IP Firebird Database Manager, Firebird SQL 
Studio.

I am not sure if I am doing something wrong, or just not possible.




When I run the backup from these tools, and select the database and final 
location and press start, it looks like it is going thru a backup process, but 
the fbk file is not created on my computer.




I am new to firebird and the GUI Tools that may be available. 





Any assistance is appreciated.




 

Art


I don't know any of these tools...

But I strongly suggest that you use the native firebird applications

use gbak for back-up (it's on the installation directory under the bin folder)

the most simple way is:

gbak IP_OF_THE_SERVER:NAME_OF_YOUR_DATABASE NAME_OF_BACKUP_FILE -user sysdba 
-password masterkey -v

of course change the password for the one you defined.

the -v switch is optional, but I think it will hep you once it will show the 
progress

see you !

[firebird-support] Backup over network

[Robert martin]

Hi

I have a utility app that backs up an exiting fdb file, compresses it 
and then FTPs it to a web server.  Has worked great for years but now 
the client needs it (the app) run from another machine.  The App and Db 
are still on the old machine, the app is however run across the network. 
  The app appears to freeze, I am pretty sure that's because the backup 
fails.

I am using the IBOBackupServer for backing up.

Is there anyway / work around I can use to allow the client to run the 
app over the network?

Thanks
Rob

Re: [firebird-support] Backup Database

[Norman Dunbar]

On 22/05/13 21:13, Marco Sucuzhañay wrote:
 Dear,
 How to generate a cold backup of the database, thanks

You can download a PDF manual for the gbak application at 
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-gbak.pdf

Before backing up: 
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-prereqs

A simple cold backup: 
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-simple
 
note the warning just above it about restoring a backup directly to the 
source database please!

or:

A remote backup: 
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-remote

or:

A remote backup over ssh: 
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-remote-ssh

HTH.

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767

Re: [firebird-support] Backup Firebird Error

[Ann Harrison]

On Wed, May 22, 2013 at 4:20 PM, Marco Sucuzhañay 
msucuzhanay.act...@gmail.com wrote:

 When generating a backup of the database shows me the message:

 gbak: ERROR database file appears corrupt()
 gbak: ERROR wrong page type
 gbak: ERROR page 2401 is of wrong type
 gbak: ERROR gds_$get_setment failed
 gbak: Existing before completion due to errors


Hmm.  The first thing I would try is a backup with the -g option.  The
problem may be in an old version.  If so, disabling garbage collection will
let gbak avoid the bad page reference.

My second thought would be that 2401 is a strange number.  From the
ERROR gds_$get_segment error, it appears to be the middle of a large blob.
 So I'd be willing to guess that there's something wrong with the blob
itself and the page reference is just wrong.  How big is the database?
What's the page size?  Is 24 million and one a reasonable page number?  If
not, you may want to try IBFirstAid to see if it can identify the bad blob.

While I was waiting, I'd try using the -v switch on gbak to figure out
which table has the record with the bad blob.  Then probe around and see if
I can identify the bad record.

Good luck,

Ann


[Non-text portions of this message have been removed]

[firebird-support] Backup Firebird Error

[Marco Sucuzhañay]

When generating a backup of the database shows me the message:

gbak: ERROR database file appears corrupt()
gbak: ERROR wrong page type
gbak: ERROR page 2401 is of wrong type
gbak: ERROR gds_$get_setment failed
gbak: Existing before completion due to errors

as I can fix

--


[Non-text portions of this message have been removed]

Re: [firebird-support] Backup Firebird Error

[Helen Borrie]

At 08:20 a.m. 23/05/2013, Marco Sucuzhañay wrote:
When generating a backup of the database shows me the message:

gbak: ERROR database file appears corrupt()
gbak: ERROR wrong page type
gbak: ERROR page 2401 is of wrong type
gbak: ERROR gds_$get_setment failed
gbak: Existing before completion due to errors

It is possible that the database file is not corrupt, but contains a database 
with the wrong on-disk format for the version of gbak you are trying to use.

Go to the /bin/ directory of your Firebird installation and run gstat -h:

gstat -h /full/path/to/your/database

The attribute you want to look at is ODS version.
-- if it is 10.0 then you need gbak from the Fb 1.0 installation
-- if it is 10.1 then you need gbak from the Fb 1.5 installation
-- if it is 11.0 then you need gbak from Fb 2.0 installation
-- if it is 11.1 then you need gbak from Fb 2.1 installation
-- if it is 11.2 then you need gbak from Fb 2.5 installation

Once you have a backup file made by the proper version of gbak, you can use a 
later version of gbak to restore the database - then, the restored database 
will have the ODS that matches you server version.


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of The Firebird Book and The Firebird Book Second Edition
http://www.firebird-books.net
__ 

Re: [firebird-support] Backup Firebird Error

[Marco Sucuzhañay]

Thanks for the reply, the problem appears to me to create a backup of the
database, which has 650 Gigas hot, I can do it in COLD backup?

2013/5/22 Helen Borrie hele...@iinet.net.au

 **


  At 08:20 a.m. 23/05/2013, Marco Sucuzhañay wrote:
 When generating a backup of the database shows me the message:
 
 gbak: ERROR database file appears corrupt()
 gbak: ERROR wrong page type
 gbak: ERROR page 2401 is of wrong type
 gbak: ERROR gds_$get_setment failed
 gbak: Existing before completion due to errors

 It is possible that the database file is not corrupt, but contains a
 database with the wrong on-disk format for the version of gbak you are
 trying to use.

 Go to the /bin/ directory of your Firebird installation and run gstat -h:

 gstat -h /full/path/to/your/database

 The attribute you want to look at is ODS version.
 -- if it is 10.0 then you need gbak from the Fb 1.0 installation
 -- if it is 10.1 then you need gbak from the Fb 1.5 installation
 -- if it is 11.0 then you need gbak from Fb 2.0 installation
 -- if it is 11.1 then you need gbak from Fb 2.1 installation
 -- if it is 11.2 then you need gbak from Fb 2.5 installation

 Once you have a backup file made by the proper version of gbak, you can
 use a later version of gbak to restore the database - then, the restored
 database will have the ODS that matches you server version.

 Helen Borrie, Support Consultant, IBPhoenix (Pacific)
 Author of The Firebird Book and The Firebird Book Second Edition
 http://www.firebird-books.net
 __

  




-- 

*A.C.T.I.V.A.
Business Consulting  and TIC.*

Sucuzhañay Lema Marco Vinicio
Móvil:  09 2 432 945 / 08 3 015 499
Home: 02 2 611 885
Quito - Ecuador


[Non-text portions of this message have been removed]





++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

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

++
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:
http://docs.yahoo.com/info/terms/

Re: [firebird-support] Backup Firebird Error

[fabianoaspro]

Yes
Em 22/05/2013 19:30, Marco Sucuzhañay msucuzhanay.act...@gmail.com
escreveu:

 Thanks for the reply, the problem appears to me to create a backup of the
 database, which has 650 Gigas hot, I can do it in COLD backup?

 2013/5/22 Helen Borrie hele...@iinet.net.au

  **
 
 
   At 08:20 a.m. 23/05/2013, Marco Sucuzhańay wrote:
  When generating a backup of the database shows me the message:
  
  gbak: ERROR database file appears corrupt()
  gbak: ERROR wrong page type
  gbak: ERROR page 2401 is of wrong type
  gbak: ERROR gds_$get_setment failed
  gbak: Existing before completion due to errors
 
  It is possible that the database file is not corrupt, but contains a
  database with the wrong on-disk format for the version of gbak you are
  trying to use.
 
  Go to the /bin/ directory of your Firebird installation and run gstat -h:
 
  gstat -h /full/path/to/your/database
 
  The attribute you want to look at is ODS version.
  -- if it is 10.0 then you need gbak from the Fb 1.0 installation
  -- if it is 10.1 then you need gbak from the Fb 1.5 installation
  -- if it is 11.0 then you need gbak from Fb 2.0 installation
  -- if it is 11.1 then you need gbak from Fb 2.1 installation
  -- if it is 11.2 then you need gbak from Fb 2.5 installation
 
  Once you have a backup file made by the proper version of gbak, you can
  use a later version of gbak to restore the database - then, the restored
  database will have the ODS that matches you server version.
 
  Helen Borrie, Support Consultant, IBPhoenix (Pacific)
  Author of The Firebird Book and The Firebird Book Second Edition
  http://www.firebird-books.net
  __
 
 
 



 --

 *A.C.T.I.V.A.
 Business Consulting  and TIC.*

 Sucuzhańay Lema Marco Vinicio
 Móvil:  09 2 432 945 / 08 3 015 499
 Home: 02 2 611 885
 Quito - Ecuador


 [Non-text portions of this message have been removed]



 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu.  Try Knowledgebase and FAQ links !

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

 ++
 Yahoo! Groups Links






[Non-text portions of this message have been removed]

[firebird-support] Backup Firebird 2.5

[Marco Sucuzhañay]

Dear,
as I can create a backup of a database of 600G of imformation if I have a
main base and several secondary bases, ie BASEDEDATOS_1.FDB,
BASEDEDATOS_2.FDB, BASEDEDATOS_3.FDB, this set of files make up a single
database.
The need to do it in hot backup, without lowering the services do not affect
users, thanks


[Non-text portions of this message have been removed]

[firebird-support] Backup problem when different client libraries connected to DB?

[Benton Quest]

Hi there,

We have a Linux server (64 bits OS) running Firebird 1.5.6 (32 bits) serving a 
2GB Firebird database. We have a variety of legacy and recent client 
applications connecting to the database, some using Borland's BDE, other use 
the Firebird DotNet provider, we have IBExpert and some others clients use Zeos 
components. At any given moment we have around 100 concurrent users connected 
to the database.

I've noticed that when I run a backup from the Linux console using gbak, the 
backup does not end normally, it crashes with an error message. But if I try 
the backup after hours when only two or three users connected to the database, 
the backup ends normally.

We have a second Windows 2008 server running a similar setup(Fb 1.5.6, around 
100 client connections, 2GB+ database.) In this server, IBexpert does not have 
any problems backing up the database, regardless of the number users connected 
to it.

I can't recall where did I read that the problem might lie in the connection 
libraries, IIRC, if there are many different client libraries connected, the 
linux libraries used by gbak might have a problem backing up the database. 
Might this be the case here?

Any thoughts or opinions are welcome.

Best Regards,

-Jorge
P.S. We know we should upgrade to Fb 2.5, unfortunately our main legacy system 
does not support it right now. We have a migration plan for the next 6 months 
to accomplish this though.

Re: [firebird-support] Backup and restore of users

[Tomasz Tyrakowski]

gbak -B /opt/firebird/security2.fdb ./security2.fbk

works as well. Restoring requires two steps: restore to an alternate 
location (gbak -C security2.fbk somefolder/security2.fdb), then stop the 
server (SS) or close connections (CS) and copy the restored 
security2.fdb to the proper location in FB directory. AFAIR, a similar 
procedure is required when upgrading from pre-2.x FB (it's mentioned in 
the section Security in Firebird 2 (All Platforms) in Firebird 2 
Migration  Installation here:
http://www.firebirdsql.org/file/documentation/release_notes/html/install210.html
but without details).

regards
Tomasz

W dniu 2012-03-07 17:47, Milan Babuskov pisze:
 Aldo Caruso wrote:
 Which are the steps to follow to backup and restore database users and
 passwords ?

 I usually just stop the server and copy security2.fdb file. Unlike the
 databases, it is rarely written to. I mean, how often do you open new
 user accounts.



-- 
__--==--__
__--== Tomasz Tyrakowski==--__
__--==SOL-SYSTEM==--__
__--== http://www.sol-system.pl ==--__
__--==--__

Re: [firebird-support] Backup and restore of users

[Thomas Steinmaurer]

Hello Tomasz,

 gbak -B /opt/firebird/security2.fdb ./security2.fbk

 works as well. Restoring requires two steps: restore to an alternate
 location (gbak -C security2.fbk somefolder/security2.fdb), then stop the
 server (SS) or close connections (CS) and copy the restored
 security2.fdb to the proper location in FB directory. AFAIR, a similar
 procedure is required when upgrading from pre-2.x FB (it's mentioned in
 the section Security in Firebird 2 (All Platforms) in Firebird 2
 Migration  Installation here:
 http://www.firebirdsql.org/file/documentation/release_notes/html/install210.html
 but without details).

Starting with Firebird 2, the security database can't be accessed by a 
regular/direct database connection anymore. Accessing is only possible 
via the Services Manager. Thus, you need to use the -se switch when 
backing up the security database. At least on Windows. Can't test your 
above gbak call under Linux right now.


-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/

Re: [firebird-support] Backup and restore of users

[Aldo Caruso]

Thanks all of you for your help.
Aldo Caruso

El 08/03/12 07:04, Tomasz Tyrakowski escribió:

 I had run it just before posting, on one of our servers. Debian 6, FB
 2.5.0 CS. Worked all right.
 You're right about Windows. Just checked it and got no permission for
 direct access to security database. I haven't thought about testing it
 on Windows - sorry Aldo, my solution only half-works.

 regards
 Tomasz

 On 2012-03-08 10:54, Thomas Steinmaurer wrote:
  Hello Tomasz,
 
  gbak -B /opt/firebird/security2.fdb ./security2.fbk
 
  works as well. Restoring requires two steps: restore to an alternate
  location (gbak -C security2.fbk somefolder/security2.fdb), then 
 stop the
  server (SS) or close connections (CS) and copy the restored
  security2.fdb to the proper location in FB directory. AFAIR, a similar
  procedure is required when upgrading from pre-2.x FB (it's mentioned in
  the section Security in Firebird 2 (All Platforms) in Firebird 2
  Migration Installation here:
  
 http://www.firebirdsql.org/file/documentation/release_notes/html/install210.html
  but without details).
 
  Starting with Firebird 2, the security database can't be accessed by a
  regular/direct database connection anymore. Accessing is only possible
  via the Services Manager. Thus, you need to use the -se switch when
  backing up the security database. At least on Windows. Can't test your
  above gbak call under Linux right now.
 
 

 -- 
 __--==--__
 __--== Tomasz Tyrakowski ==--__
 __--== SOL-SYSTEM ==--__
 __--== http://www.sol-system.pl ==--__
 __--==--__

 


[Non-text portions of this message have been removed]

Re: [firebird-support] Backup and restore of users

[Milan Babuskov]

Aldo Caruso wrote:
 Which are the steps to follow to backup and restore database users and 
 passwords ?

I usually just stop the server and copy security2.fdb file. Unlike the 
databases, it is rarely written to. I mean, how often do you open new 
user accounts.

-- 
Milan Babuskov

==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==

Re: [firebird-support] Backup-Restore, without killing existing attachments.

[Elmar Haneke]

 I have a question on backup/restore.

 Think of a firebird classic on a linux box.

 -Do a backup with existing attachments
 -After backup, Rename the old gdb file to something else
 -Restore the backup file with the original gdb name.

You have to kill all connected clients before starting backup and you
have to prevent them from reconnecting until restore is complete. Else
at least the updates done while backup/restore are lost.

In Addition existing connections should prevent you from renaming the
database.

As an alternative you should consider if restorerename is really
required. Just run the backup and do an restore to an dummy database to
verify backup file. It is not required to rebild database on each backup.


Elmar

[firebird-support] Backup error

[Si Carter]

Hi,

Does anybody have any idea what could cause the following error on
backup using FB2.5

regards

Si

*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed

SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code: 335544333
Engine Message :
internal Firebird consistency check (wrong record length (183), file:
vio.cpp line: 1139)
gds_$receive failed

Re: [firebird-support] Backup error

[Alexey Kovyazin]

   Hello,

This is a database corruption, most likely caused by bad RAM.
Another reason could be accessing Firebird database with wrong version 
of engine (InterBase? old Firebird?).

Download free FBFirstAID version, check your database and send log for 
free investigation to our support team: support at ib-aid.com.com
We'll check it.

Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)


 Hi,

 Does anybody have any idea what could cause the following error on
 backup using FB2.5

 regards

 Si

 *** IBPP::SQLException ***
 Context: ServiceImpl::Wait
 Message: isc_service_query failed

 SQL Message : -902
 Unsuccessful execution caused by a system error that precludes
 successful execution of subsequent statements

 Engine Code : 335544333
 Engine Message :
 internal Firebird consistency check (wrong record length (183), file:
 vio.cpp line: 1139)
 gds_$receive failed

 



[Non-text portions of this message have been removed]

Re: [firebird-support] Backup error

[Si Carter]

Thanks, I will look into this

rgds

Si

On 17 January 2012 08:30, Alexey Kovyazin a...@ib-aid.com wrote:

Hello,

 This is a database corruption, most likely caused by bad RAM.
 Another reason could be accessing Firebird database with wrong version of
 engine (InterBase? old Firebird?).

 Download free FBFirstAID version, check your database and send log for
 free investigation to our support team: support at ib-aid.com.com
 We'll check it.

 Regards,
 Alexey Kovyazin
 IBSurgeon (www.ib-aid.com)




 Hi,

 Does anybody have any idea what could cause the following error on
 backup using FB2.5

 regards

 Si

 *** IBPP::SQLException ***
 Context: ServiceImpl::Wait
 Message: isc_service_query failed

 SQL Message : -902
 Unsuccessful execution caused by a system error that precludes
 successful execution of subsequent statements

 Engine Code : 335544333
 Engine Message :
 internal Firebird consistency check (wrong record length (183), file:
 vio.cpp line: 1139)
 gds_$receive failed
  





[Non-text portions of this message have been removed]





++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

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

++
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:
http://docs.yahoo.com/info/terms/

Re: [firebird-support] backup very slow and how often sweep a database ? - Email found in subject

[Vander Clock Stephane]

I thing i found how it's happen !!

The command for user is -user and for the no reserver is -use and if i 
make no mistake both use the -u shortcut !
i m sure it's happen somewhat like this :(

stéphane


On 12/23/2011 10:13 AM, Thomas Steinmaurer wrote:

  As i say in my previous message (as always half of my messages never
  appear in this forum)
  I really not understand why my database become NO RESERVE :(

 Perhaps by accident via your access components?

 -- 
 With regards,
 Thomas Steinmaurer (^TS^)
 Firebird Technology Evangelist

 http://www.upscene.com/
 http://www.firebirdsql.org/en/firebird-foundation/

  i never do this ! and i don't know for how many time it's like this ...
  but really strange
 
  On 12/23/2011 12:15 AM, Leyne, Sean wrote:
 
  Dmitry,
 
  Next, your database have NO RESERVE flag turned on.
  This is BAD, since you speaking about updates.
 
  Good catch! I completely missed that!
 
  I agree, this is VERY BAD!
 
  Sean
 
 
 
 
  [Non-text portions of this message have been removed]
 
 
 
  
 
  ++
 
  Visit http://www.firebirdsql.org and click the Resources item
  on the main (top) menu. Try Knowledgebase and FAQ links !
 
  Also search the knowledgebases at http://www.ibphoenix.com
 
  ++
  Yahoo! Groups Links
 
 
 

 


[Non-text portions of this message have been removed]

RE: Re[2]: [firebird-support] backup very slow and how often sweep a database ? - Email found in subject

[Leyne, Sean]

Dmitry,

 Next, your database have NO RESERVE flag turned on.
 This is BAD, since you speaking about updates.

Good catch!  I completely missed that!

I agree, this is VERY BAD!


Sean

Re: [firebird-support] backup very slow and how often sweep a database ? - Email found in subject

[Vander Clock Stephane]

i agree tooo (thanks again seam)

As i say in my previous message (as always half of my messages never 
appear in this forum)
I really not understand why my database become NO RESERVE :(

i never do this ! and i don't know for how many time it's like this ... 
but really strange

On 12/23/2011 12:15 AM, Leyne, Sean wrote:

 Dmitry,

  Next, your database have NO RESERVE flag turned on.
  This is BAD, since you speaking about updates.

 Good catch! I completely missed that!

 I agree, this is VERY BAD!

 Sean

 


[Non-text portions of this message have been removed]

Re: [firebird-support] backup very slow and how often sweep a database ? - Email found in subject

[Vander Clock Stephane]

but i connect throught the api and only throught the API :(
it's really strange  anyway i will investigate more carefully
also i use before FB 2.5.1 the snapshot version of firebird ...
anyway i know it now i will take care of it

thanks for all

On 12/23/2011 10:13 AM, Thomas Steinmaurer wrote:

  As i say in my previous message (as always half of my messages never
  appear in this forum)
  I really not understand why my database become NO RESERVE :(

 Perhaps by accident via your access components?

 -- 
 With regards,
 Thomas Steinmaurer (^TS^)
 Firebird Technology Evangelist

 http://www.upscene.com/
 http://www.firebirdsql.org/en/firebird-foundation/

  i never do this ! and i don't know for how many time it's like this ...
  but really strange
 
  On 12/23/2011 12:15 AM, Leyne, Sean wrote:
 
  Dmitry,
 
  Next, your database have NO RESERVE flag turned on.
  This is BAD, since you speaking about updates.
 
  Good catch! I completely missed that!
 
  I agree, this is VERY BAD!
 
  Sean
 
 
 
 
  [Non-text portions of this message have been removed]
 
 
 
  
 
  ++
 
  Visit http://www.firebirdsql.org and click the Resources item
  on the main (top) menu. Try Knowledgebase and FAQ links !
 
  Also search the knowledgebases at http://www.ibphoenix.com
 
  ++
  Yahoo! Groups Links
 
 
 

 


[Non-text portions of this message have been removed]

Re: [firebird-support] backup very slow and how often sweep a database ?

[Thomas Steinmaurer]

 it's a disaster  i disable the gfix -sweep every night and launch it
 only when the difference between oldest transaction and next transaction
 is  20 000 but this become true only after 5 hours :( so at the end
 everyday the difference between oldest transaction and next transaction
 grow by more than 20 000 :(

 i can not run gfix everyday, it's took hours to finish :(

 what i can do ?

Find the reason why you produce such a transaction gap within 5 hours. 
Is it just the OIT which is behind or OAT as well? What's the output of 
gstat -h?

If OAT as well, then you have a long-running transaction or using commit 
retaining over and over again.

If you are using Firebird 2.1, then use the MON% tables to investigate 
running transactions. If you are using Firebird 2.5, then use the MON% 
tables and/or the Trace API to investigate the problem.

Regards,
^TS^


 stéphane

 On 12/20/2011 8:41 PM, Ann Harrison wrote:

 Stéphane,

 the probleme is that the sweep can take up to 5 hours to finish and the
 backup up to 12 hours to finish :(
 i know that in the backup i don't put the -g params (inhibit garbage
 collection) but someone say me that
 the -g do something else that the gfix.exe -sweep doesn't do ...

 As others have said, sweep does something that gbak doesn't. Specifically,
 sweep resets the oldest interesting transaction - the first
 transaction in the
 system that may have rolled back leaving changes in the database. Keeping
 that number accurate was very important a decade ago when memory was
 expensive and rare and Firebird did not automatically undo changes when
 a transaction rolled back leaving the server alive.

 When reading records, Firebird must check the state of transactions newer
 than the oldest interesting. At startup, Firebird produces a bit
 vector of those
 transactions where each pair of bits indicates the transactions state:
 rolled back,
 committed, limbo, or active. The shorter the vector, the better, but
 64K bits
 isn't as interesting as it was a decade ago.

 now i need to know, how often i need to launch the gfix.exe -sweep and
 the gbak.exe -B without the -g params ? everydays seam not anymore
 possible because of the time taken
 by these process...

 one time a month ?

 Backup as often as lets you sleep at night. Sweep once a week if possible,
 once a month if not.

 Good luck,

 Ann




 [Non-text portions of this message have been removed]



 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu.  Try Knowledgebase and FAQ links !

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

 ++
 Yahoo! Groups Links

Re: [firebird-support] backup very slow and how often sweep a database ?

[Vander Clock Stephane]

On 12/21/2011 12:08 PM, Thomas Steinmaurer wrote:

  it's a disaster  i disable the gfix -sweep every night and launch it
  only when the difference between oldest transaction and next transaction
  is 20 000 but this become true only after 5 hours :( so at the end
  everyday the difference between oldest transaction and next transaction
  grow by more than 20 000 :(
 
  i can not run gfix everyday, it's took hours to finish :(
 
  what i can do ?

 Find the reason why you produce such a transaction gap within 5 hours.
 Is it just the OIT which is behind or OAT as well? What's the output of
 gstat -h?


ok, i think i found ... few hours ago the difference
between OIT and next transaction was 50 000 but
now i try again gstat -h and the difference if only 5 ...

Database header page information:
 Flags   0
 Checksum12345
 Generation  1003772708
 Page size   8192
 ODS version 11.2
 Oldest transaction  1003732753
 Oldest active   1003732754
 Oldest snapshot 1003732754
 Next transaction1003732757
 Bumped transaction  1
 Sequence number 0
 Next attachment ID  39942
 Implementation ID   26
 Shadow count0
 Page buffers0
 Next header page0
 Database dialect3
 Creation date   Oct 30, 2011 2:23:04
 Attributes  force write, no reserve

 Variable header data:
 Sweep interval: 0
 *END*

i don't do any long transaction on the server but this is hard
to know if one select or update was not long to return as lot of 
application are
connected to the database, but all application use the same procedure
to select or update the data :

procedure doSQL
begin
   StartTransaction
   Try
 select or update data
 committransaction
   except
 rollbacktransaction
   end;
end;

for now the only explanation i see is that we do very lot of transaction 
(average 225 / Secondes is it lot ?)
on the server and this why 2 sean to be too little ... with around 
19 millions transactions by days
i thing i must use much more than 2 (1 million?)

How much transaction by second can firebird can handle ?


thanks for all
 


[Non-text portions of this message have been removed]

Re: [firebird-support] backup very slow and how often sweep a database ?

[Vander Clock Stephane]

 That's quite a number, when running in 24x7 mode! Although due to the
 example above, it seems you do explicit transaction management. So,
 either you still use automcommit somewhere, which results in a new
 transaction for every piece of work, our you have a lot of connections
 and work to be done by explicit transactions.

 I really think that you are using autocommit as well. The least
 expensive transactions are READ COMMIT READ ONLY, so basically make use
 of at least read-only transactions, when you are selecting stuff from
 the database and don't write.


not really autocommit, but i don't let any transaction open.
when the code need some data, he call a global procedure that will gave
him the data he need. the procedure will open (and close) an transaction
each time and query the fb server.

now i can open a transaction when each thead start and close it when each
thead end but i always hear that transaction must be short as possible :(

stéphane


[Non-text portions of this message have been removed]

[firebird-support] backup very slow and how often sweep a database ?

[Vander Clock Stephane]

Hello,

Everyday i sweep the database and i backup it

gfix.exe -sweep

and just after a backup like this :

gbak.exe -B -t -v -z

the probleme is that the sweep can take up to 5 hours to finish and the 
backup up to 12 hours to finish :(
i know that in the backup i don't put the -g params (inhibit garbage 
collection) but someone say me that
the -g do something else that the gfix.exe -sweep doesn't do ...

now i need to know, how often i need to launch the gfix.exe -sweep and
the gbak.exe -B without the -g params ? everydays seam not anymore 
possible because of the time taken
by these process...

one time a month ?

  thanks by advance for you help
stéphane

Re: SV: [firebird-support] backup very slow and how often sweep a database ?

[Vander Clock Stephane]

no off course it's disabled :)

On 12/20/2011 6:42 PM, Poul Dige wrote:

 How large is your DB?

 And just a thought: is auto sweep enabled on your database? I mean: 
 could it by accident run an automatic sweep already when you start 
 your own?

 Kind regards
 Poul


 Fra: firebird-support@yahoogroups.com 
 mailto:firebird-support%40yahoogroups.com 
 [mailto:firebird-support@yahoogroups.com 
 mailto:firebird-support%40yahoogroups.com] På vegne af Vander Clock 
 Stephane
 Sendt: 20. december 2011 08:22
 Til: firebird-support@yahoogroups.com 
 mailto:firebird-support%40yahoogroups.com
 Emne: [firebird-support] backup very slow and how often sweep a 
 database ?



 Hello,

 Everyday i sweep the database and i backup it

 gfix.exe -sweep

 and just after a backup like this :

 gbak.exe -B -t -v -z

 the probleme is that the sweep can take up to 5 hours to finish and the
 backup up to 12 hours to finish :(
 i know that in the backup i don't put the -g params (inhibit garbage
 collection) but someone say me that
 the -g do something else that the gfix.exe -sweep doesn't do ...

 now i need to know, how often i need to launch the gfix.exe -sweep and
 the gbak.exe -B without the -g params ? everydays seam not anymore
 possible because of the time taken
 by these process...

 one time a month ?

 thanks by advance for you help
 stéphane


 [Non-text portions of this message have been removed]

 


[Non-text portions of this message have been removed]