Re: [firebird-support] Timestamp in different regions

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

 Hello Zoran

Witch Component do you useing in Delphi FireDAC?

Are you shure, that that your clients uses the right client-library 
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5

What FB Version do you use?

Best Regards
Gregor



Sent from Yahoo Mail. Get the app


 On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' 
zoran...@gmail..com [firebird-support]  
wrote:  
 
     


Thank you, Karol.

  

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement.

 

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

  

  

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

  

  

I do not suppose that this is Firebird message.

This looks like client program message. 

 

regards,

Karol Bieniaszewski

  

  

Firebird 3.0.5, Delphi 10.3.3

  

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

  

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

  

Does anyone experience this, or am I missing something here?_,

  

Thank you

Zoran


  #yiv7077494043 #yiv7077494043 -- #yiv7077494043ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7077494043 
#yiv7077494043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7077494043 
#yiv7077494043ygrp-mkp #yiv7077494043hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7077494043 #yiv7077494043ygrp-mkp #yiv7077494043ads 
{margin-bottom:10px;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad 
{padding:0 0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad p 
{margin:0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad a 
{color:#ff;text-decoration:none;}#yiv7077494043 #yiv7077494043ygrp-sponsor 
#yiv7077494043ygrp-lc {font-family:Arial;}#yiv7077494043 
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc #yiv7077494043hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7077494043 
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc .yiv7077494043ad 
{margin-bottom:10px;padding:0 0;}#yiv7077494043 #yiv7077494043actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7077494043 
#yiv7077494043activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7077494043
 #yiv7077494043activity span {font-weight:700;}#yiv7077494043 
#yiv7077494043activity span:first-child 
{text-transform:uppercase;}#yiv7077494043 #yiv7077494043activity span a 
{color:#5085b6;text-decoration:none;}#yiv7077494043 #yiv7077494043activity span 
span {color:#ff7900;}#yiv7077494043 #yiv7077494043activity span 
.yiv7077494043underline {text-decoration:underline;}#yiv7077494043 
.yiv7077494043attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7077494043 .yiv7077494043attach div a 
{text-decoration:none;}#yiv7077494043 .yiv7077494043attach img 
{border:none;padding-right:5px;}#yiv7077494043 .yiv7077494043attach label 
{display:block;margin-bottom:5px;}#yiv7077494043 .yiv7077494043attach label a 
{text-decoration:none;}#yiv7077494043 blockquote {margin:0 0 0 
4px;}#yiv7077494043 .yiv7077494043bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7077494043 
.yiv7077494043bold a {text-decoration:none;}#yiv7077494043 dd.yiv7077494043last 
p a {font-family:Verdana;font-weight:700;}#yiv7077494043 dd.yiv7077494043last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7077494043 
dd.yiv7077494043last p span.yiv7077494043yshortcuts 
{margin-right:0;}#yiv7077494043 div.yiv7077494043attach-table div div a 
{text-decoration:none;}#yiv7077494043 div.yiv7077494043attach-table 
{width:400px;}#yiv7077494043 div.yiv7077494043file-title a, #yiv7077494043 
div.yiv7077494043file-title a:active, #yiv7077494043 
div.yiv7077494043file-title a:hover, #yiv7077494043 div.yiv7077494043file-title 
a:visited {text-decoration:none;}#yiv7077494043 div.yiv7077494043photo-title a, 
#yiv7077494043 div.yiv7077494043photo-title a:active, #yiv7077494043 
div.yiv7077494043photo-title a:hover, #yiv7077494043 
div.yiv7077494043photo-title a:visited {text-decoration:none;}#yiv7077494043 
div#yiv7077494043ygrp-mlmsg #yiv7077494043ygrp-msg p a 
span.yiv7077494043yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7077494043 
.yiv7077494043green {color:#628c2a;}#yiv7077494043 .yiv7077494043MsoNormal 
{margin:0 0 0 0;}#yiv7077494043 o {font-size:0;}#yiv7077494043

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Thankfully I moved from D1 to D3 many years ago.

So now just need to get to FB3.


Cheers,
Kevin





 

> On Apr 30, 2020, at 7:37 AM, 'Jason (PN)' ja...@jac2.co.uk [firebird-support] 
>  wrote:
> 
> Hi Kevin,
> 
> Can I ask what dialect you are going from and to?
> 
> Sorry I don’t have an opinion on P1 vs P2. Do you know why P1 is recommended 
> over P2?
> 
> As you may have guessed, I have this same thing to do 1.5.6 D1 -> ?.
> 
> Thanks,
> 
> Jason
> 
> From: firebird-support@yahoogroups.com 
> <mailto:firebird-support@yahoogroups.com>  <mailto:firebird-support@yahoogroups.com>> 
> Sent: 30 April 2020 15:23
> To: Firebird Support  <mailto:firebird-support@yahoogroups.com>>
> Subject: [firebird-support] FB1 to FB3
> 
> Greetings!
> 
> Process 1:
> Via a script, I have successfully exported and migrated all data and objects 
> from a FB1 database to FB3.
> Creating the objects originally had just a few errors but those have been 
> fixed and it now goes across cleanly, no errors. 
> This process has been the one most widely recommended.
> 
> Process 2:
> With the corrected database that goes cleanly to FB3, I tried the following:
> 1. Backup the database with FB1.
> 2. Restore the database with FB3.
> 3. Executed two of IB Expert’s functions: a) Recompile all Procedures and b) 
> Recompile all Triggers. (No errors)
> 4. Performed a backup / restore with no errors.
> 
> My question: is Process 2 an acceptable path? The only reason I ask is one of 
> my customers has many millions of records and I believe Process 2 will save 
> me a weekend of work. (My next step is to benchmark how long Process 1 will 
> take for this customer’s database).
> 
> Many Thanks!
> 
> Kevin
> 
> [Non-text portions of this message have been removed]
> 
> [Non-text portions of this message have been removed]
> 
> 
> 



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

Re: [firebird-support] Timestamp in different regions

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

30.04.2020 17:30, 'Zoran' zoran...@gmail.com [firebird-support] wrote:
> What I was hopping for is if someone with Delphi background can shed some 
> light on Delphi 
> handling this situation.

   Usually such situations are handled by debugging. You use debugging version 
of VCL and 
RTL, enable break on exception and look at the piece of code where the error 
has happened.

-- 
   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] Timestamp in different regions

['Zoran' zoran...@gmail.com [firebird-support]]

Thank you, Karol.

 

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement.

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

 

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

 

  

I do not suppose that this is Firebird message.

This looks like client program message. 

 

regards,

Karol Bieniaszewski

 

 

Firebird 3.0.5, Delphi 10.3.3

 

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

 

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

 

Does anyone experience this, or am I missing something here?_,

 

Thank you

Zoran

ODP: [firebird-support] Timestamp in different regions

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

I do not suppose that this is Firebird message.
This looks like client program message. 

regards,
Karol Bieniaszewski

ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

I suppose you have two different queries – one with where clause and one 
without on one of the tables involved in the query.
Are you sure that the queries are the same?

But also it is quite usual that after new data changes the plan is about to 
change.
Is this true for your case that some table got more records after fill then 
previously second table?
Especially this one?:

You can try also modify your query to have static plan (some +0) or update 
index statistics after some count of operations.

Regards,
Karol Bieniaszewski


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

Re: [firebird-support] FB1 to FB3

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

Step 1 is better if you are going from dialect 1 to 3, mostly due to
the difference in the numerics internal storage.

I see no problem with any of the approaches.

I would add that, imho, step 4 in process 2 is not really necessary,
unless you want to reset the metadata versions count of the objects
from 1 to 0.

Also, about step 3, you can prepare a script with "create or alter"
statements of your procedures, triggers, etc. and run it using any
tool or even isql.

[]s
Carlos
Migration Guide to FB 3
http://www.firebirdnews.org/migration-guide-to-firebird-3/


KSKSRScfs> Greetings!

KSKSRScfs> Process 1:
KSKSRScfs> Via a script, I have successfully exported and migrated
KSKSRScfs> all data and objects from a FB1 database to FB3.
KSKSRScfs> Creating the objects originally had just a few errors but
KSKSRScfs> those have been fixed and it now goes across cleanly, no errors.
KSKSRScfs> This process has been the one most widely recommended.

KSKSRScfs> Process 2:
KSKSRScfs> With the corrected database that goes cleanly to FB3, I tried the 
following:
KSKSRScfs> 1. Backup the database with FB1.
KSKSRScfs> 2. Restore the database with FB3.
KSKSRScfs> 3. Executed two of IB Expert’s functions: a) Recompile all
KSKSRScfs> Procedures and b) Recompile all Triggers.  (No errors)
KSKSRScfs> 4. Performed a backup / restore with no errors.

KSKSRScfs> My question:  is Process 2 an acceptable path?  The only
KSKSRScfs> reason I ask is one of my customers has many millions of
KSKSRScfs> records and I believe Process 2 will save me a weekend of
KSKSRScfs> work.  (My next step is to benchmark how long Process 1
KSKSRScfs> will take for this customer’s database).


KSKSRScfs> Many Thanks!

KSKSRScfs> Kevin

[firebird-support] Timestamp in different regions

['Zoran' zoran...@gmail.com [firebird-support]]

Firebird 3.0.5, Delphi 10.3.3

 

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

 

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

 

Does anyone experience this, or am I missing something here?_,

 

Thank you

Zoran

___

RE: [firebird-support] FB1 to FB3

['Jason (PN)' ja...@jac2.co.uk [firebird-support]]

Hi Kevin,

Can I ask what dialect you are going from and to?

 

Sorry I don’t have an opinion on P1 vs P2.  Do you know why P1 is recommended 
over P2?

 

As you may have guessed, I have this same thing to do 1.5.6 D1 -> ?.

 

Thanks,

Jason

 

From: firebird-support@yahoogroups.com  
Sent: 30 April 2020 15:23
To: Firebird Support 
Subject: [firebird-support] FB1 to FB3

 

  

Greetings!

Process 1:
Via a script, I have successfully exported and migrated all data and objects 
from a FB1 database to FB3.
Creating the objects originally had just a few errors but those have been fixed 
and it now goes across cleanly, no errors. 
This process has been the one most widely recommended.

Process 2:
With the corrected database that goes cleanly to FB3, I tried the following:
1. Backup the database with FB1.
2. Restore the database with FB3.
3. Executed two of IB Expert’s functions: a) Recompile all Procedures and b) 
Recompile all Triggers. (No errors)
4. Performed a backup / restore with no errors.

My question: is Process 2 an acceptable path? The only reason I ask is one of 
my customers has many millions of records and I believe Process 2 will save me 
a weekend of work. (My next step is to benchmark how long Process 1 will take 
for this customer’s database).

Many Thanks!

Kevin

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





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

[firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Greetings!

Process 1:
Via a script, I have successfully exported and migrated all data and objects 
from a FB1 database to FB3.
Creating the objects originally had just a few errors but those have been fixed 
and it now goes across cleanly, no errors.  
This process has been the one most widely recommended.

Process 2:
With the corrected database that goes cleanly to FB3, I tried the following:
1. Backup the database with FB1.
2. Restore the database with FB3.
3. Executed two of IB Expert’s functions: a) Recompile all Procedures and b) 
Recompile all Triggers.  (No errors)
4. Performed a backup / restore with no errors.

My question:  is Process 2 an acceptable path?  The only reason I ask is one of 
my customers has many millions of records and I believe Process 2 will save me 
a weekend of work.  (My next step is to benchmark how long Process 1 will take 
for this customer’s database).


Many Thanks!

Kevin




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

Re: ODP: ODP: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Maybe it's worth noting that if I execute that exact query in 
FlameRobin, while the batch is running and suffering 50+ second 
execution time, FlameRobin gets it executed in 2-4 seconds every single 
time.

Weird.

I'll try to rewrite the query using execute block, a temporary table or 
something like that, to reduce query complexity.

Kjell

Den 2020-04-30 kl. 13:04, skrev Kjell Rilbe 
kjell.ri...@marknadsinformation.se [firebird-support]:
>
> Yes, but the transaction just wasn't there.
>
> I did let it run during the night. Here are FBMonitor diagrams from
> about 1 hour before slowdown up to now:
> https://cdn.mise.se/FirebirdDiagrams.png
>
> The vertical line in each diagram marks the time of slowdown (at about
> 22:05 last night).
>
> The upper left diagram shows in red that I accidentally left a
> transaction open in FlameRobin at about 20:50, which does not correlate
> to the time of slowdown. I committed it at 7:43 this morning.
>
> The I/O activity diagram shows that the cache activity goes up
> significantly at this time, while disk reads drop slightly. Disk writes
> drop a bit earlier. Nothing significant seems to happen with these
> params at the time of slowdown, except that there's a spike of disk
> reads at that moment. Noting noteworthy in any other diagrams as far as
> I can see.
>
> Looking in the statement history from FBMonitor, for the SQL query of
> interest, I see a significant change in the statistics and execution
> plan at the time of slowdown.
>
> ===Before slowdown===
> Fetches lies around 150 GB
> Table scan lies around 94-95 %
> Sequential reads lies around 2.3 million
> Indexed reads lies around 130 thousand
> Fragment reads lies around 650
>
> ===After slowdown===
> Fetches lies around 1.17 TB (up a factor 8)
> Table scan lies around 24 (down 70 %)
> Sequential reads lies around 4.7 million (up a factor 2)
> Indexed reads lies around 14.7 million (up a factor 113)
> Fragment reads lies around 2300 (up a factor 3.5)
>
> The execution plan (new format, but unfortunately truncated) changes
> from this:
>
> === BEFORE SLOWDOWN ===
>
> Select Expression
>     -> Singularity Check
>     -> Aggregate
>     -> Nested Loop Join (inner)
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "UHANT
> FTGOMSAR2" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningsåDBN" Range
> Scan (full match)
>     -> Filter
>     -> Table "År" as "UHANT AR2" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_År" Unique Scan
> Select Expression
>     -> Filter
>     -> Table "Uppgiftsspärr" as "SP2" Access By ID
>     -> Bitmap
>     -> Index "IX_Uppgiftsspärr_Uppgi60J" Range Scan (full
> match)
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Filter
>     -> Table "Uppgiftshanterare" as "UHANT2" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_Uppgiftshanterare" Unique Scan
>     -> Filter
>     -> Table "Uppgiftsspärr" as "SP2" Access By ID
>     -> Bitmap
>     -> Index "IX_Uppgiftsspärr_Uppgi8MK" Range Scan
> (full match)
> Select Expression
>     -> Filter
>     -> Table "Uppgiftshållare" as "UH2" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_Uppgiftshållare" Unique Scan
> Select Expression
>     -> Unique Sort (record length: 484, key length: 20)
>     -> Filter
>     -> Nested Loop Join (outer)
>     -> Nested Loop Join (outer)
>     -> Nested Loop Join (inner)
>     -> Nested Loop Join (inner)
>     -> Unique Sort (record length: 322, key
> length: 112)
>     -> Union
>     -> Nested Loop Join (inner)
>     -> Table "TmpFKExportId" as
> "UHANT L" Full Scan
>     -> Filter
>     -> Table "Företag" as
> "UHANT F" Access By ID
>     -> Bitmap
>     -> Index
> "IX_PK_Företag&qu

Re: ODP: ODP: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

mpFKExportId" Unique Scan
     -> Filter
     -> Table 
"Uppgiftshanterare" as "UHANT UHANT" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Uppgiftshanterare" Unique Scan
     -> Filter
     -> Table "Företag" as 
"UHANT F" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Företag" Unique Scan
     -> Nested Loop Join (inner)
     -> Table "TmpFKExportId" as 
"UHANT L" Full Scan
     -> Filter
     -> Table "Företag" as 
"UHANT F" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Företag" Unique Scan
     -> Filter
     -> Table "ITmiljö" as 
"UHANT ITMILJ" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_ITmiljö" Unique Scan
     -> Filter
     -> Table 
"Uppgiftshanterare" as "UHANT UHANT" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Uppgiftshanterare" Unique Scan
     -> Nested Loop Join (inner)
     -> Table "Befattningsinnehav" 
as "UHANT BI" Full Scan
     -> Filter
     -> Table "TmpFKExportId" as 
"UHANT L" Access By ID
     -> Bitmap
     -> Index 
"PK_TmpFKExportId" Unique Scan
     -> Filter
     -> Table 
"Uppgiftshanterare" as "UHANT UHANT" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Uppgiftshanterare" Unique Scan
     -> Filter
     -> Table "Företag" as 
"UHANT F" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Företag" Unique Scan
     -> Nested Loop Join (inner)
     -> Table "Befattningsinnehav" 
as "UHANT BI" Full Scan
     -> Filter
     -> Table "TmpFKExportId" as 
"UHANT L" Access By ID
     -> Bitmap
     -> Index 
"PK_TmpFKExportId" Unique Scan
     -> Filter
     -> Table "Person" as "UHANT 
P" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Person" Unique Scan
     -> Filter
     -> Table 
"Uppgiftshanterare" as "UHANT UHANT" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Uppgiftshanterare" Unique Scan
     -> Filter
     -> Table "Företag" as 
"UHANT F" Access By ID
     -> Bitmap
     -> Index 
"IX_PK_Företag" Unique Scan
     -> Filter
     -> Table "Uppgiftshållare" as "UH" 
Access By ID
     -> Bitmap
     -> Index 
"IX_Uppgiftshållare_HanDS2" Range Scan (full match)
     -> Filter
     -> Table "Uppgift" as "UPG" Access By ID
     -> Bitmap
     -> Index "IX_Uppgift_Hållare" Range 
Scan (full match)
     -> Filter
     -> Filter
     -> Table "Uppgiftsspärr" as "SPUHANT" 
Access By ID

=== AFTER SLOWDOWN ===

What might cause this sudden and "permanent" change in choise of query plan?

Regards,
Kjell

Den 2020-04-29 kl. 19:12, skrev Karol Bieniaszewski 
liviusliv...@poczta.onet.pl [firebird-support]:
>
> Simply run query with join two tables MON$ATATACHEMENTS and 
> MON$TRANSACTIONS – you can also be interested with joining with 
> MON$STATEMENTS
>
> And then you can see which attachement consume this transaction (you 
> can retrive IP port and proces ID (PID)
>
> Pozdrawiam,
>
> Karol Bieniaszewski
>
> 


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

Re: [firebird-support] Firebird 2.5 and CentOS 7.7

[Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]]

Are you using EPEL package ?
or Firebird project binaries ?

There is a compilation issue in Epel package since 2.5.8, and nobody
understand exactly what
fbintl from 2.5.7 package is ok

cf https://bugzilla.redhat.com/show_bug.cgi?id=1636177
and http://tracker.firebirdsql.org/browse/CORE-5925

but you can use firebird 3
https://copr.fedorainfracloud.org/coprs/makowski/firebird/

Re[2]: [firebird-support] Firebird 2.5 and CentOS 7.7

['P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support]]

Dmitry

these are results of ldd

[root@server intl]# ldd /usr/lib64/firebird/intl/fbintl.so
linux-vdso.so.1 =>  (0x7fff8a979000)
libicuuc.so.50 => /usr/lib64/libicuuc.so.50 (0x7fedb5de9000)
libicudata.so.50 => /usr/lib64/libicudata.so.50 (0x7fedb4816000)
libicui18n.so.50 => /usr/lib64/libicui18n.so.50 (0x7fedb4417000)
libdl.so.2 => /usr/lib64/libdl.so.2 (0x7fedb4213000)
libncurses.so.5 => /usr/lib64/libncurses.so.5 (0x7fedb3fec000)
libtinfo.so.5 => /usr/lib64/libtinfo.so.5 (0x7fedb3dc2000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x7fedb3abb000)
libm.so.6 => /usr/lib64/libm.so.6 (0x7fedb37b9000)
libgcc_s.so.1 => /usr/lib64/libgcc_s.so.1 (0x7fedb35a3000)
libpthread.so.0 => /usr/lib64/libpthread.so.0 (0x7fedb3387000)
libc.so.6 => /usr/lib64/libc.so.6 (0x7fedb2fb9000)
/lib64/ld-linux-x86-64.so.2 (0x7fedb6439000)
[root@server intl]# ldd /usr/lib64/firebird/intl/fbintl
linux-vdso.so.1 =>  (0x7fff085d7000)
libicuuc.so.50 => /usr/lib64/libicuuc.so.50 (0x7f8ad16ec000)
libicudata.so.50 => /usr/lib64/libicudata.so.50 (0x7f8ad0119000)
libicui18n.so.50 => /usr/lib64/libicui18n.so.50 (0x7f8acfd1a000)
libdl.so.2 => /usr/lib64/libdl.so.2 (0x7f8acfb16000)
libncurses.so.5 => /usr/lib64/libncurses.so.5 (0x7f8acf8ef000)
libtinfo.so.5 => /usr/lib64/libtinfo.so.5 (0x7f8acf6c5000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x7f8acf3be000)
libm.so.6 => /usr/lib64/libm.so.6 (0x7f8acf0bc000)
libgcc_s.so.1 => /usr/lib64/libgcc_s.so.1 (0x7f8aceea6000)
libpthread.so.0 => /usr/lib64/libpthread.so.0 (0x7f8acec8a000)
libc.so.6 => /usr/lib64/libc.so.6 (0x7f8ace8bc000)
/lib64/ld-linux-x86-64.so.2 (0x7f8ad1d3c000)


Fabio Codebue


P-SOFT di Codebue Fabio

Via Nuova n. 9 - 24060 Tavernola B.sca (BG)

P.I. 03624950162

C.F. CDBFBA72A11C618T

Mobile: +39.348.3515786

Fax: +39.030.5100306

Web: http://www.p-soft.biz <http://www.p-soft.biz/>



pec: amministrazi...@pec.p-soft.biz
cod.intermediario SDI: KRRH6B9



-- Messaggio originale --
Da: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 


A: firebird-support@yahoogroups.com
Inviato: 29/04/2020 16:11:44
Oggetto: Re: [firebird-support] Firebird 2.5 and CentOS 7.7


29.04.2020 15:40, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz 
[firebird-support] wrote:

 Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so'

 Some ideas?


   Check dependencies using ldd.

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

ODP: ODP: [firebird-support] SQL slower after N executions?

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Simply run query with join two tables MON$ATATACHEMENTS and MON$TRANSACTIONS – 
you can also be interested with joining with MON$STATEMENTS
And then you can see which attachement consume this transaction (you can 
retrive IP port and proces ID (PID)

Pozdrawiam,
Karol Bieniaszewski

Re: [firebird-support] Firebird 2.5 and CentOS 7.7

[Emil Totev em...@tot-consult.com [firebird-support]]

This is a known problem with the EPEL rpms.
Workarounds include using the rpm packages for superclassic, which don't
have the problem, or installing the project-provided rpms (which install
under /opt). It *might* also work if you replace that specific file with
the one from the EPEL rpm from 2.5.7 (the problem appeared in 2.5.8).

Good luck!

Re: ODP: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Thanks,

I tried firing up Gregor Kobler's FBMonitor (similar to the old but dead 
Sinatica Monitor).

I found that OAT is 222085103 while OIT and OST (what's that?) is 
261140768 and growing. I assume the OAT must have got stuck somehow 
quite a while back, since it's so far behind the others. The machine was 
rebooted for upgrades rather recently, and I can't see any stuck 
transactions, so the OAT must be a zombie one.

No auto sweep (interval set to 0), so I'm trying a manual sweep now. 
Guess I should schedule that weekly or something.

I couldn't see anything interesting happening with the trans numbers 
when I exited the batch app. Will restart it after the manual sweep and 
see if anything interesting shows up. The slowdown, if still there, 
would probably happen after I go to sleep, so I'll have to follow up 
tomorrow.

Other info about the database, in case it says anything:

Page size: 16384
ODS: 12.0
Page buffers: 614400 (roughly 9.5 Gbyte)
Sweep interval: 0 (like I mentioned)
Forced writes: off (yes, I know the risks)

 From databases.conf:
DefaultDbCachePages = 600K (same as Page buffers above, of course)
FileSystemCacheThreshold = 1000K

 From firebird.conf:
FileSystemCacheSize = 40
TempCacheLimit = 4G
MaxUnflushedWrites = 100
MaxUnflushedWriteTime = 60
ServerMode = Super

All other performance params default. Some auth and access restriction 
params are non default, but I assume that's irrelevant.

System has 40 Gbyte RAM and the temp disks have 70+ Gbyte free.

Regards,
Kjell

Den 2020-04-29 kl. 14:00, skrev Karol Bieniaszewski 
liviusliv...@poczta.onet.pl [firebird-support]:

> Hi
>
> There are many possibilities without access i can only hint you:
>
> Look at MON$Tranasctions maybe you have active one which stop garbage 
> collecion.
>
> Look also at sort buffer setting if firebird.conf
>
> Look at settings about buffers in database itself (gfix -h show you 
> value).
>
> Look also at automatic sweep settings (also gfix -h show you value).
>
> Update Firebird to most recent version official is 3.0.5 but i use 
> most recent snapshot without problems.
>
> More can be tell after some details provided.
>
> regards,
>
> Karol Bieniaszewski
>
> 


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

Re: [firebird-support] Firebird 2.5 and CentOS 7.7

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

29.04.2020 15:40, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz 
[firebird-support] wrote:
> Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so'
> 
> Some ideas?

   Check dependencies using ldd.

-- 
   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] Firebird 2.5 and CentOS 7.7

['P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support]]

We are trying to install Firebird 2.5.9 Super Server on  Linux  Server 
CentOS (Linux release 7.7.1908 (Core))
IT doen't start because it can't load moduloe 
/usr/lib64/firebird/intl/fbintl.so


Into to the log file we read:

Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so'

Some ideas?

Fabio Codebue


P-SOFT di Codebue Fabio

Via Nuova n. 9 - 24060 Tavernola B.sca (BG)

P.I. 03624950162

C.F. CDBFBA72A11C618T

Mobile: +39.348.3515786

Fax: +39.030.5100306

Web: http://www.p-soft.biz 



pec: amministrazi...@pec.p-soft.biz
cod.intermediario SDI: KRRH6B9

Re: [firebird-support] SQL slower after N executions?

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

I don't know why things slow down, Kjell, if the batch job updates records,
I guess it could be related to there being lots of versions of some records
and that garbage are only collected after your application ends (it sounds
plausible if transactions are still open when you "Stopping the batch and
restarting it, with the app still open". Maybe you should check if there's
a large gap between oldest and next transaction when you stop the batch
(similar to Karols first recommendation)? Another thing that would not harm
is to change from

  where Ar."Årtal" = ( select max( Ar2."Årtal" )
  from "FöretagOmsättningsår" FtgOmsar2
  inner join "År" Ar2 on Ar2.."ECO_ID" =
FtgOmsar2."Omsättningsår"
  where FtgOmsar2."Företag" = F."ECO_ID" )

to
 where not exists ( select 1
from "FöretagOmsättningsår" FtgOmsar2
inner join "År" Ar2 on Ar2.."ECO_ID" =
FtgOmsar2."Omsättningsår"
where FtgOmsar2."Företag" = F."ECO_ID"
  and Ar."Årtal" < Ar2."Årtal" )

in the second part of your query. This will probably not help with the
slowdown, but it should not be slower than your max( and it may be slightly
quicker (although the table names "FöretagOmsättningsår" and "År" does
indicate these are tiny tables).

Set

ons. 29. apr. 2020 kl. 13:44 skrev Kjell Rilbe
kjell.ri...@marknadsinformation.se [firebird-support] <
firebird-support@yahoogroups.com>:

> Hi,
>
> I have a batch job that among other things executes a certain SQL query
> to load some data.
>
> This query takes about 10-12 seconds the first ~320 times, but then
> suddenly takes ~45-50 seconds every time.
>
> Any idea what could be causing this?
>
> The query is rather long, see below. Firebird 3.0.4 on Windows Server
> 2016 64 bit. App is ASP Framework using FirebirdSql.Data.FirebirdClient
> 7.1.1.0.
>
> I can't see any other operations slowing down at the same point in time.
> I can't see any particular change in the app's memory usage (it varies
> up and down both before and after the time of slowdown). I did try a
> change of Firebird's cache settings (more page buffers), but it didn't
> seem to have any effect (yes I did restart FB service to ensure changes
> took effect). Windows file system cache doesn't seem to hit the roof at
> this particular time, so I see no connection there.
>
> Stopping the batch and restarting it, with the app still open, doesn't
> help, but restarting the entire app leads to the shorter execution time
> again.
>
> Each execution of this SQL query is done in a new connection (not
> pooled). Before this SQL, the same connection is also used to empty the
> table "TmpFKExportId" and then fill it with some new data, a simple list
> of 250 bigints).
>
> The app does do other DB work that spans multiple executions of this SQL
> query, using a separate connection. Those operations do not exhibit any
> noticable slowdown.
>
> I'm at a loss... Any suggestions of things to try are most welcome!
>
> SQL:
>
> select distinct Upg."ECO_ID", Upg."ECO_TYPE"
> from (
>  select 'Företag' "Bärartyp", F."ECO_ID" "Bärare", Uhant."ECO_ID"
>  from "Företag" F
>  inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>  inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
> F."Uppgiftshanterare"
>  union
>  select 'FöretagOmsättningsår' "Bärartyp", FtgOmsar."ECO_ID"
> "Bärare", Uhant."ECO_ID"
>  from "Företag" F
>  inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>  inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag" =
> F."ECO_ID"
>  inner join "År" Ar on Ar."ECO_ID" = FtgOmsar."Omsättningsår"
>  inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
> FtgOmsar."Uppgiftshanterare"
>  where Ar."Årtal" = (
>  select max(Ar2."Årtal")
>  from "FöretagOmsättningsår" FtgOmsar2
>  inner join "År" Ar2 on Ar2.."ECO_ID" = FtgOmsar2."Omsättningsår"
>  where FtgOmsar2."Företag" = F."ECO_ID"
>)
>  union
>  select 'ITmiljö' "Bärartyp", ITmilj."ECO_ID" "Bärare", Uhant."ECO_ID"

ODP: [firebird-support] SQL slower after N executions?

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Hi

There are many possibilities without access i can only hint you:
Look at MON$Tranasctions maybe you have active one which stop garbage collecion.
Look also at sort buffer setting if firebird.conf
Look at settings about buffers in database itself (gfix -h show you value).
Look also at automatic sweep settings (also gfix -h show you value).
Update Firebird to most recent version official is 3.0.5 but i use most recent 
snapshot without problems.

More can be tell after some details provided.

regards,
Karol Bieniaszewski

[firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Hi,

I have a batch job that among other things executes a certain SQL query 
to load some data.

This query takes about 10-12 seconds the first ~320 times, but then 
suddenly takes ~45-50 seconds every time.

Any idea what could be causing this?

The query is rather long, see below. Firebird 3.0.4 on Windows Server 
2016 64 bit. App is ASP Framework using FirebirdSql.Data.FirebirdClient 
7.1.1.0.

I can't see any other operations slowing down at the same point in time. 
I can't see any particular change in the app's memory usage (it varies 
up and down both before and after the time of slowdown). I did try a 
change of Firebird's cache settings (more page buffers), but it didn't 
seem to have any effect (yes I did restart FB service to ensure changes 
took effect). Windows file system cache doesn't seem to hit the roof at 
this particular time, so I see no connection there.

Stopping the batch and restarting it, with the app still open, doesn't 
help, but restarting the entire app leads to the shorter execution time 
again.

Each execution of this SQL query is done in a new connection (not 
pooled). Before this SQL, the same connection is also used to empty the 
table "TmpFKExportId" and then fill it with some new data, a simple list 
of 250 bigints).

The app does do other DB work that spans multiple executions of this SQL 
query, using a separate connection. Those operations do not exhibit any 
noticable slowdown.

I'm at a loss... Any suggestions of things to try are most welcome!

SQL:

select distinct Upg."ECO_ID", Upg."ECO_TYPE"
from (
     select 'Företag' "Bärartyp", F."ECO_ID" "Bärare", Uhant."ECO_ID"
     from "Företag" F
     inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
     inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" = 
F."Uppgiftshanterare"
     union
     select 'FöretagOmsättningsår' "Bärartyp", FtgOmsar."ECO_ID" 
"Bärare", Uhant."ECO_ID"
     from "Företag" F
     inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
     inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag" = 
F."ECO_ID"
     inner join "År" Ar on Ar."ECO_ID" = FtgOmsar."Omsättningsår"
     inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" = 
FtgOmsar."Uppgiftshanterare"
     where Ar."Årtal" = (
     select max(Ar2."Årtal")
     from "FöretagOmsättningsår" FtgOmsar2
     inner join "År" Ar2 on Ar2.."ECO_ID" = FtgOmsar2."Omsättningsår"
     where FtgOmsar2."Företag" = F."ECO_ID"
   )
     union
     select 'ITmiljö' "Bärartyp", ITmilj."ECO_ID" "Bärare", Uhant."ECO_ID"
     from "Företag" F
     inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
     inner join "ITmiljö" ITmilj on ITmilj."ECO_ID" = F."ITmiljö"
     inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" = 
ITmilj."Uppgiftshanterare"
     union
     select 'Befattningsinnehav' "Bärartyp", BI."ECO_ID" "Bärare", 
Uhant."ECO_ID"
     from "Företag" F
     inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
     inner join "Befattningsinnehav" BI on BI."Företag" = F."ECO_ID"
     inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" = 
BI."Uppgiftshanterare"
     union
     select 'Person' "Bärartyp", P."ECO_ID" "Bärare", Uhant."ECO_ID"
     from "Företag" F
     inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
     inner join "Befattningsinnehav" BI on BI."Företag" = F."ECO_ID"
     inner join "Person" P on P."ECO_ID" = BI."Person"
     inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" = 
P."Uppgiftshanterare"
   ) Uhant
inner join "Uppgiftshållare" UH on UH."Hanterare" = Uhant."ECO_ID"
inner join "Uppgift" Upg on Upg."Hållare" = UH."ECO_ID"
left join "Uppgiftsspärr" SpUhant on SpUhant."Uppgiftshanterare" = 
Uhant."ECO_ID" and Uhant."Bärartyp" in ('Epostadress', 'Person')
left join "Uppgiftsspärr" SpUH on SpUH."Uppgiftshållare" = UH."ECO_ID"
where Upg."TogsBort" is null
   and SpUhant."ECO_ID" is null
   and SpUH."ECO_ID" is null
   and not exists (
     select 1
     from "Uppgiftshållare" UH2
     where UH2."ECO_ID" = Upg."RelateradHållare"
   and (
     exists (
   select 1
   from "Uppgiftsspärr" Sp2
   where Sp2."Uppgiftshållare" = UH2."ECO_ID"
     )
     or exists (
   select 1
   from "Uppgiftsspärr" Sp2
   inner join "Uppgiftshanterare" Uhant2 on Uhant2."ECO_ID" = 
Sp2."Uppgiftshanterare"
   where Uhant2."ECO_ID" = UH2."Hanterare"
     )
   )
   )

Mvh,
Kjell



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

Re: [firebird-support] How to inspect nbak state of a Firebird database

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Excellent! Thanks!

Feel free to anser that in StackOverflow too (link below). If not, I 
will do it myself after testing it and mark my own answer as the correct 
one.

Regards,
Kjell

Den 2020-04-22 kl. 10:08, skrev 'Paul Beach' pbe...@mail.ibphoenix.com 
[firebird-support]:

>
> MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge.
>
> Regards
> Paul
>
> -Original Message-----
> From: firebird-support@yahoogroups.com 
> [mailto:firebird-support@yahoogroups.com]
> Sent: 22 April 2020 09:56
> To: Firebird Forum
> Subject: [firebird-support] How to inspect nbak state of a Firebird 
> database
>
> Is there a way in C# to inspect the nbak state of a Firebird database?
>
> The state in the database header would be set to |nbak_state_diff| or
> |nbak_state_normal|. But how do I actually read this value?
>
> https://stackoverflow.com/questions/61359915/how-to-inspect-nbak-state-of-a-firebird-database
>



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

RE: [firebird-support] How to inspect nbak state of a Firebird database

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

MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge.

Regards
Paul

-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 22 April 2020 09:56
To: Firebird Forum
Subject: [firebird-support] How to inspect nbak state of a Firebird database


  
Is there a way in C# to inspect the nbak state of a Firebird database?

The state in the database header would be set to |nbak_state_diff| or 
|nbak_state_normal|. But how do I actually read this value?

https://stackoverflow.com/questions/61359915/how-to-inspect-nbak-state-of-a-firebird-database

Regards,
Kjell

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

[firebird-support] How to inspect nbak state of a Firebird database

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Is there a way in C# to inspect the nbak state of a Firebird database?

The state in the database header would be set to |nbak_state_diff| or 
|nbak_state_normal|. But how do I actually read this value?

https://stackoverflow.com/questions/61359915/how-to-inspect-nbak-state-of-a-firebird-database

Regards,
Kjell



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

ODP: [firebird-support] Re: Explicit Login with Windows Domain username

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Hi

Ask self – do you have Windows Domain supported 2 passwords? No. You can have 2 
different autentication methods.
On Firebird3 you have autentication plugins. You can implement one self or use 
apropiate design on your rest service.

Better to not allow all users to have same password is to redesign you REST 
service.
You should have login method on your rest service and user should recive token. 
And he/she should comunicate with this token in new requestes to other rest 
methods.
I can only hint to also use hmac with this token design to do not allow someone 
to recive token only and override user privileges.

Regards,
Karol Bieniaszewski

[firebird-support] Re: Explicit Login with Windows Domain username

['Nikolaus Kern' parzival1...@gmx.at [firebird-support]]

Hello,

 

I posted a similar question on 20. September 2017 how to login with a
windows domain username without using trusted authentication. At this time
the answer was: ist not possible or you have to  In the meanwhile I have
some customers with FB 3.x and recognized that trusted authentication is
dependent on the EF and .net provider and not in place yet.

 

For that reason I tried following steps:

1.  My domain user is called BAURADAR\NIKOLAUS
2.  Firebird 2.5.9

a.  I logged in: isql localhost/3060:b58 -u "DOMAIN\TEST44" -p test -r
BAURADAR_ADMIN
b.  It worked !

3.  Firebird 3.0.5

a.  isql localhost:oberrater -u "BAURADAR\TEST" -p test -R
BAURADAR_ADMIN
b.  It worked as well

4.  I check the current user with:

a.  show users;
b.  select current_user from rdb$DATABASE;

 

What do I want to achieve:

I.  Automatic login with Windows Domain account without the need for a
password. This is the level of security with FB2.5.x and trusted
authentication
II. Explicit login with any Windows domain account with a specific
password via a REST Service

 

In order to get this working on FB3.x I need to setup all Firebird users
with Windows Domain Accounts with the same default password.

 

Questions:

1.  As far as I see this the objective I. is in conflict with objective
II. Or is there a parameter to login without password check?
2.  Is the use of special german characters (like ÄÖÜ) possible with
Firebird Usernames? Also in as a Windows Domain Username like
"BAURADR\OBERMÜLLER“? 

 

Thanks in advance

 

Niko

 

 

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

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

18.04.2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support] wrote:
> But Like I said Errors where produced with restoring, like size error

   A new feature for you to learn: copy-paste from console window to mail 
client.


-- 
   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] Re: Technical IT specialist Firebird corruption

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

On 18-04-2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support] 
wrote:
> 
> 
> Yes sorry, this is from Linux. Since I'm a Linux Enthusiast . I did that 
> script, but it did produce errors.
> 
> http://www.firebirdfaq.org/faq141/ This is the backup script I used.
> 
> This page I used  for the restore string 
> http://www.destructor.de/firebird/gbak.htm. But Like I said Errors where 
> produced with restoring, like size error

Please be explicit with what you tried and the exact errors you get.

Mark

-- 
Mark Rotteveel

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

Yes sorry, this is from Linux. Since I'm a Linux Enthusiast . I did that 
script, but it did produce errors.


http://www.firebirdfaq.org/faq141/ This is the backup script I used.

This page I used  for the restore string 
http://www.destructor.de/firebird/gbak.htm. But Like I said Errors where 
produced with restoring, like size error


On 17/04/2020 17:22, John vdW j...@jvdw.nl [firebird-support] wrote:


For gbak on a windows machine:

"c:\Program files\Firebird\Firebird_2_5\bin\gbak" -c -v -user SYSDBA 
-pas masterkey backupfilename.fbk targetfilename.fdb


-c to create a new file
-v to be verbose and show on screen what's happening
- user and password


Op 18-04-2020 om 17:58 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
The Firebird version was not tampered with in this fault. Although 
what's I thought was strange is the support person uninstalled 
Firebird then re-installed. I never saw him going to Microsoft 
service file to stop Firebird.


Could someone give me the script to restore a .fbk file. I kept on 
getting a file size error.


On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote:


Actually I meant the Firebird Server version. Are they the same on 
Linux and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write 
into an existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the 
server or database on Windows before copying it to Linux. Did you 
do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database,
from
Windows to the Linux file system through Windows. Deactivate
Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the
Linux
computer.
There is something in there software to me that has changed
that somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes
from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

For gbak on a windows machine:

"c:\Program files\Firebird\Firebird_2_5\bin\gbak" -c -v -user SYSDBA 
-pas masterkey backupfilename.fbk targetfilename.fdb


-c to create a new file
-v to be verbose and show on screen what's happening
- user and password


Op 18-04-2020 om 17:58 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:



The Firebird version was not tampered with in this fault. Although 
what's I thought was strange is the support person uninstalled 
Firebird then re-installed. I never saw him going to Microsoft service 
file to stop Firebird.


Could someone give me the script to restore a .fbk file. I kept on 
getting a file size error.


On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote:


Actually I meant the Firebird Server version. Are they the same on 
Linux and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write into 
an existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the 
server or database on Windows before copying it to Linux. Did you 
do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the
Linux
computer.
There is something in there software to me that has changed
that somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes
from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

The Firebird version was not tampered with in this fault. Although 
what's I thought was strange is the support person uninstalled Firebird 
then re-installed. I never saw him going to Microsoft service file to 
stop Firebird.


Could someone give me the script to restore a .fbk file. I kept on 
getting a file size error.


On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote:


Actually I meant the Firebird Server version. Are they the same on 
Linux and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write into 
an existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:
I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the 
server or database on Windows before copying it to Linux. Did you do 
that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the Linux
computer.
There is something in there software to me that has changed that
somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes
from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

Actually I meant the Firebird Server version. Are they the same on Linux 
and Windows?


GBak is designed to make a backup on the fly, even with many users 
connected and using the database. No need to shut down.


Make sure the gbak-restore creates a new file and does not write into an 
existing database file.





Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk 
[firebird-support]:



I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the 
Linux server through Samba will be the exact version as the one 
running correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the server 
or database on Windows before copying it to Linux. Did you do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support.
https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the Linux
computer.
There is something in there software to me that has changed that
somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes from
not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

I agree with the version, as the company comes out with different 
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would 
create a fault even though no one was working on the database?
Because I did try making sure the Client program running from the Linux 
server through Samba will be the exact version as the one running 
correctly from Windows XP, which works.
Still showing it's corrupted, according to the support person from 
Delfin company.



On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote:
In your description you did not include a step to shutdown the server 
or database on Windows before copying it to Linux. Did you do that?


Doug C.


 On Fri, 17 Apr 2020 05:21:03 -0400 *Shane 
delphi_ric...@yahoo.co.uk [firebird-support] 
* wrote 


I've been dealing with this company support. https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from
Windows to the Linux file system through Windows. Deactivate Linux
firebird 2.5 first then replace the database. Reactivate the
database on
Linux. Then start a Windows program that communicates with the
database
from an IP address.
The software developer has somehow put a hook in the software.
That if
the path has changed the database needs to be reset, as in
re-registered.
The big frustration I'm having is the file I'm copying is not
corrupt.
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the Linux
computer.
There is something in there software to me that has changed that
somehow
won't see the Database correctly.

Really hope someone could halp clarify why the database goes from not
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[DougC d...@moosemail.net [firebird-support]]

In your description you did not include a step to shutdown the server or 
database on Windows before copying it to Linux. Did you do that?



Doug C.



 On Fri, 17 Apr 2020 05:21:03 -0400 Shane delphi_ric...@yahoo.co.uk 
[firebird-support]  wrote 


 I've been dealing with this company support. https://www.delter.co.za/
 I'm an IT professional. Support Windows, Linux, Apple Mac.
 I have a technical question. When I copy a firebird database, from 
 Windows to the Linux file system through Windows. Deactivate Linux 
 firebird 2.5 first then replace the database. Reactivate the database on 
 Linux. Then start a Windows program that communicates with the database 
 from an IP address.
 The software developer has somehow put a hook in the software. That if 
 the path has changed the database needs to be reset, as in re-registered.
 The big frustration I'm having is the file I'm copying is not corrupt. 
 But when I'm starting it from the Linux server. It corrupt.
 This is according to the support person from delfin.
 Originally the firebird database was working perfectly on the Linux 
 computer.
 There is something in there software to me that has changed that somehow 
 won't see the Database correctly.
 
 Really hope someone could halp clarify why the database goes from not 
 corrupt from Windows to corrupt on Linux.
 
 Kind Regards
 Shane

Re: [firebird-support] Technical IT specialist Firebird corruption

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

On 17-04-2020 13:35, Nick Upson nick.up...@gmail.com [firebird-support] 
wrote:
> I've had a similar issue when the database code was looking for custom 
> UDF's that had not been installed on the destination, in some ways that 
> can appear as corruption even though it isn't

In Firebird itself that would result in an error like "invalid request - 
 is not defined - module name or entrypoint could not be 
found" error.

Unless of course the application in question is hiding that error and 
returning unclear errors.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Technical IT specialist Firebird corruption

[Nick Upson nick.up...@gmail.com [firebird-support]]

I've had a similar issue when the database code was looking for custom
UDF's that had not been installed on the destination, in some ways that can
appear as corruption even though it isn't
--
Nick


On Fri, 17 Apr 2020 at 12:15, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]  wrote:

>
>
> On 18-04-2020 12:19, Shane delphi_ric...@yahoo.co.uk [firebird-support]
> wrote:
> > The scenario that I've setup is Opensuse is the main OS. I'm running
> > Windows XP on a VirtualBox. So within Windows XP I communicate to the
> > Linux OS through samba, copying to the folder the database is running. I
> > do the systemctl stop to Firebird on the Linux Server then restart after
> > it's finished copying .
>
> What exactly are you copying? How are you moving the database from
> Windows to Linux, what are the exact steps and commands used? If you
> were using gbak to backup and restore, there would be no need to stop
> Firebird on your Linux server. So it sounds like you are copying the
> database file itself, instead of using gbak to back it up on Windows and
> then - using gbak - restore it on Linux.
>
> > I did use the gbak on all the backups. I even tried Flamerobin to
> > restore resent backups. which it didn't give any errors.
> > But it does want to be registered and the Defin support person says it
> > corrupted!!!
>
> Then possibly this might be a problem with the application and not so
> much with the database. You would need to contact support of your
> application for more help.
>
> Mark
> --
> Mark Rotteveel
> 
>

Re: [firebird-support] Technical IT specialist Firebird corruption

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

On 18-04-2020 12:19, Shane delphi_ric...@yahoo.co.uk [firebird-support] 
wrote:
> The scenario that I've setup is Opensuse is the main OS. I'm running 
> Windows XP on a VirtualBox. So within Windows XP I communicate to the 
> Linux OS through samba, copying to the folder the database is running. I 
> do the systemctl stop to Firebird on the Linux Server then restart after 
> it's finished copying .

What exactly are you copying? How are you moving the database from 
Windows to Linux, what are the exact steps and commands used? If you 
were using gbak to backup and restore, there would be no need to stop 
Firebird on your Linux server. So it sounds like you are copying the 
database file itself, instead of using gbak to back it up on Windows and 
then - using gbak - restore it on Linux.

> I did use the gbak on all the backups. I even tried Flamerobin to 
> restore resent backups. which it didn't give any errors.
> But it does want to be registered and the Defin support person says it 
> corrupted!!!

Then possibly this might be a problem with the application and not so 
much with the database. You would need to contact support of your 
application for more help.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

Maybe there is a version issue? If you can connect to the restored database 
through Flamerobin and browse the tables, then there's probably nothing wrong 
with the database. But if the clientprogram and it's library expect a certain 
version and the version is different, they may respond with a generic error 
like "database corrupted"


Sent from my iPhone

> On 17 Apr 2020, at 11:17, Shane delphi_ric...@yahoo.co.uk [firebird-support] 
>  wrote:
> 
>  
> 
> Thank you very much for the quick reply.
> 
> The scenario that I've setup is Opensuse is the main OS. I'm running Windows 
> XP on a VirtualBox. So within Windows XP I communicate to the Linux OS 
> through samba, copying to the folder the database is running. I do the 
> systemctl stop to Firebird on the Linux Server then restart after it's 
> finished copying .
> 
> I did use the gbak on all the backups. I even tried Flamerobin to restore 
> resent backups. which it didn't give any errors.
> But it does want to be registered and the Defin support person says it 
> corrupted!!!
> 
> If I think of a different scenario were I use an Accounting program called 
> Turbocash. Take the firebird database copy it to a linux file system. Use 
> Playonlinux to open Turbocash and open the database that I've copied from 
> Windows. It works 100% and I can move it back from Linux to Windows without 
> any fault.
> 
> 
> On 17/04/2020 10:56, John vdW j...@jvdw.nl [firebird-support] wrote:
>> Shane,
>> 
>> AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird database 
>> from one computer to another, especially from one OS to a different OS.
>> 
>> Use the Gbak tool on the original machine to create a backup file.
>> 
>> Use the GBak tool on the target machine to restore the backupfile to a FB 
>> database.
>> 
>> Good luck!
>> John
>> 
>> Op 17-04-2020 om 10:47 schreef Shane Richmond delphi_ric...@yahoo.co.uk 
>> [firebird-support]:
>>> I see the Group is on Yahoo. Which I have also an account for a very long 
>>> time.
>>> 
>>> 
>>> I've been dealing with this company support. https://www.delter.co.za/
>>> I'm an IT professional. Support Windows, Linux, Apple Mac.
>>> I have a technical question. When I copy a firebird database, from Windows 
>>> to the Linux file system through Windows. Deactivate Linux firebird 2.5 
>>> first then replace the database. Reactivate the database on Linux. Then 
>>> start a Windows program that communicates with the database from an IP 
>>> address.
>>> The software developer has somehow put a hook in the software. That if the 
>>> path has changed the database needs to be reset, as in re-registered. 
>>> The big frustration I'm having is the file I'm copying is not corrupt. But 
>>> when I'm starting it from the Linux server. It corrupt.
>>> This is according to the support purson from delfin.
>>> Originally the firebird database was working perfectly on the Linux 
>>> computer.
>>> There is something in there software to me that has changed that somehow 
>>> won't see the Database correctly.
>>> 
>>> Really hope someone could halp clarify why the database goes from not 
>>> corrupt from Windows to corrupt on Linux.
>>> 
>>> Kind Regards
>>> Shane
>>> 
>> 
> 
> 
> 
> 

[firebird-support] Re: Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

I've been dealing with this company support. https://www.delter.co.za/
I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from 
Windows to the Linux file system through Windows. Deactivate Linux 
firebird 2.5 first then replace the database. Reactivate the database on 
Linux. Then start a Windows program that communicates with the database 
from an IP address.
The software developer has somehow put a hook in the software. That if 
the path has changed the database needs to be reset, as in re-registered.
The big frustration I'm having is the file I'm copying is not corrupt. 
But when I'm starting it from the Linux server. It corrupt.
This is according to the support person from delfin.
Originally the firebird database was working perfectly on the Linux 
computer.
There is something in there software to me that has changed that somehow 
won't see the Database correctly.

Really hope someone could halp clarify why the database goes from not 
corrupt from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] Technical IT specialist Firebird corruption

[Shane delphi_ric...@yahoo.co.uk [firebird-support]]

Thank you very much for the quick reply.

The scenario that I've setup is Opensuse is the main OS. I'm running 
Windows XP on a VirtualBox. So within Windows XP I communicate to the 
Linux OS through samba, copying to the folder the database is running. I 
do the systemctl stop to Firebird on the Linux Server then restart after 
it's finished copying .


I did use the gbak on all the backups. I even tried Flamerobin to 
restore resent backups. which it didn't give any errors.
But it does want to be registered and the Defin support person says it 
corrupted!!!


If I think of a different scenario were I use an Accounting program 
called Turbocash. Take the firebird database copy it to a linux file 
system. Use Playonlinux to open Turbocash and open the database that 
I've copied from Windows. It works 100% and I can move it back from 
Linux to Windows without any fault.



On 17/04/2020 10:56, John vdW j...@jvdw.nl [firebird-support] wrote:


Shane,

AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird 
database from one computer to another, especially from one OS to a 
different OS.


Use the Gbak tool on the original machine to create a backup file.

Use the GBak tool on the target machine to restore the backupfile to a 
FB database.


Good luck!
John

Op 17-04-2020 om 10:47 schreef Shane Richmond 
delphi_ric...@yahoo.co.uk [firebird-support]:
I see the Group is on Yahoo. Which I have also an account for a very 
long time.



I've been dealing with this company support. 
https://www.delter.co.za/ <https://www.delter.co.za/>

I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from 
Windows to the Linux file system through Windows. Deactivate Linux 
firebird 2.5 first then replace the database. Reactivate the database 
on Linux. Then start a Windows program that communicates with the 
database from an IP address.
The software developer has somehow put a hook in the software. That 
if the path has changed the database needs to be reset, as in 
re-registered.
The big frustration I'm having is the file I'm copying is not 
corrupt. But when I'm starting it from the Linux server. It corrupt.

This is according to the support purson from delfin.
Originally the firebird database was working perfectly on the Linux 
computer.
There is something in there software to me that has changed that 
somehow won't see the Database correctly.


Really hope someone could halp clarify why the database goes from not 
corrupt from Windows to corrupt on Linux.


Kind Regards
Shane

Re: [firebird-support] Technical IT specialist Firebird corruption

[John vdW j...@jvdw.nl [firebird-support]]

Shane,

AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird database 
from one computer to another, especially from one OS to a different OS.


Use the Gbak tool on the original machine to create a backup file.

Use the GBak tool on the target machine to restore the backupfile to a 
FB database.


Good luck!
John

Op 17-04-2020 om 10:47 schreef Shane Richmond delphi_ric...@yahoo.co.uk 
[firebird-support]:



I see the Group is on Yahoo. Which I have also an account for a very 
long time.



I've been dealing with this company support. https://www.delter.co.za/ 
<https://www.delter.co.za/>

I'm an IT professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from 
Windows to the Linux file system through Windows. Deactivate Linux 
firebird 2.5 first then replace the database. Reactivate the database 
on Linux. Then start a Windows program that communicates with the 
database from an IP address.
The software developer has somehow put a hook in the software. That if 
the path has changed the database needs to be reset, as in re-registered.
The big frustration I'm having is the file I'm copying is not corrupt. 
But when I'm starting it from the Linux server. It corrupt.

This is according to the support purson from delfin.
Originally the firebird database was working perfectly on the Linux 
computer.
There is something in there software to me that has changed that 
somehow won't see the Database correctly.


Really hope someone could halp clarify why the database goes from not 
corrupt from Windows to corrupt on Linux.


Kind Regards
Shane

[firebird-support] Technical IT specialist Firebird corruption

[Shane Richmond delphi_ric...@yahoo.co.uk [firebird-support]]

I see the Group is on Yahoo. Which I have also an account for a very long time.

I've been dealing with this company support. https://www.delter.co.za/I'm an IT 
professional. Support Windows, Linux, Apple Mac.
I have a technical question. When I copy a firebird database, from Windows to 
the Linux file system through Windows. Deactivate Linux firebird 2.5 first then 
replace the database. Reactivate the database on Linux. Then start a Windows 
program that communicates with the database from an IP address.
The software developer has somehow put a hook in the software. That if the path 
has changed the database needs to be reset, as in re-registered.
The big frustration I'm having is the file I'm copying is not corrupt. But when 
I'm starting it from the Linux server. It corrupt.
This is according to the support purson from delfin.
Originally the firebird database was working perfectly on the Linux computer.
There is something in there software to me that has changed that somehow won't 
see the Database correctly.

Really hope someone could halp clarify why the database goes from not corrupt 
from Windows to corrupt on Linux.

Kind Regards
Shane

Re: [firebird-support] List Users after CREATE/DROP USER without commit

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

On 11-04-2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> Hi @all!
> 
> I'm trying to implement some sort of user manager into an app and want
> to use the firebird-users and roles as user and authentification
> source (using FB 3).
> 
> Most of it works perfectly. There's just one little problem:
> If I create or drop a user via CREATE USER or DROP USER and do a
> "SELECT * FROM SEC$USERS" afterwards the change is not visible - the
> new user is missing, the dropped user is still in the list.
> 
> I'm using the same transaction for all the commands but still I have
> to issue a COMMIT for seeing the changes in the user list.
> 
> Now I'd love to use the transaction-mechanism for giving the user of
> my app a possibility to revoke the changes made.
> 
> Can this be achived somehow?

No, it cannot. Creation of the user happens in a different database, and 
changes in that database aren't visible until the commit happens (at 
which time the commit in the security database happens as well).

Mark
-- 
Mark Rotteveel

Re: [firebird-support] List Users after CREATE/DROP USER without commit

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

11.04.2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> Now I'd love to use the transaction-mechanism for giving the user of
> my app a possibility to revoke the changes made.
> 
> Can this be achived somehow?

   User management is outside of database and performed in an autonomous 
transaction. To 
see results of the query you, probably, have to use read-committed isolation 
level.


-- 
   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] List Users after CREATE/DROP USER without commit

[Lukas Gradl fireb...@ssn.at [firebird-support]]

Hi @all!

I'm trying to implement some sort of user manager into an app and want  
to use the firebird-users and roles as user and authentification  
source (using FB 3).

Most of it works perfectly. There's just one little problem:
If I create or drop a user via CREATE USER or DROP USER and do a  
"SELECT * FROM SEC$USERS" afterwards the change is not visible - the  
new user is missing, the dropped user is still in the list.

I'm using the same transaction for all the commands but still I have  
to issue a COMMIT for seeing the changes in the user list.

Now I'd love to use the transaction-mechanism for giving the user of  
my app a possibility to revoke the changes made.

Can this be achived somehow?

Any tips welcome,

Lukas

Re: [firebird-support] Forgot sysdba password

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

On 2020-04-09 18:05, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>> Hi
>> 
>> Simply replace security3.fdb by ine from the zip install and
>> initialize sysdba
> 
> Doing that will lose all other users in the security database, so that
> is not a good idea.
> 
> Instead, stop Firebird server, and use
> 
> isql -user sysdba employee
> 
> and then
> 
> alter user sysdba password 'new password';
> commit;
> exit;

And of course, start Firebird server again.

Mark

Re: [firebird-support] Forgot sysdba password

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

On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> Hi
> 
> Simply replace security3.fdb by ine from the zip install and
> initialize sysdba

Doing that will lose all other users in the security database, so that 
is not a good idea.

Instead, stop Firebird server, and use

isql -user sysdba employee

and then

alter user sysdba password 'new password';
commit;
exit;

Mark

Re: [firebird-support] Forgot sysdba password

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

09.04.2020 06:47, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] 
wrote:
> What I'd like to do is to reset the pw to something known

   Connect to any database in embedded mode with user name SYSDBA (without 
password) and 
use ALTER USER query.


-- 
   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] Forgot sysdba password

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

HiSimply replace security3.fdb by ine from the zip install and initialize 
sysdbaRegards,Karol Bieniaszewski
null

[firebird-support] Forgot sysdba password

[Andrea Raimondi andrea.raimo...@gmail.com [firebird-support]]

Hi!

I have googled around a bit but can't seem to find anything simple to sort
this problem out.
I may have to reinstall the thing altogether.

What I'd like to do is to reset the pw to something known (for, I am fairly
sure I can't just recover it, it'll need to be reset).

Suggestions?

[firebird-support] Re: Re: error during the registratione of data on 2.5 FB database. SOLVED

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He, Mark, You are reason (as always *_*)
I've made many changes in the source code, but the result is not changed.
After checking the default values for all the fileds in the table, I've
discovered that many fields of type smallint have a default setted to
'' (char void) rather then 0 (zero)... what a stupid!!!
The error is referred to fields not inserted in the comand line INSERT, for
which Firebird has considered the default '' rather then 0.
Thanks for interest. More attention from me would not have made lose 4 days
to me and precious time to you.
Best regards.

Antonio BIANCA

- - - - - - - - -

Il 04/04/2020 10:57, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] ha scritto:

>
> On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com
> [firebird-support] wrote:
> > He,
> > I've an error that I don't undestrand.
> > I use Delphi 7 environment to create my applications, Zeos components
> > for connections and Firebird 2.5 Superserver for database management.
> > To register the data, my App uses the processor component; the
> > Connection.Autocommit  parameter is set to False.
> > My App inserts numerous lines of data to be recorded in the Process
> > component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT
> > INTO ZXD...'; UPDATE FGH SET ...'; and so on);
> > at the end, it adds the command "COMMIT;", then call "PARSE", and 
> "EXECUTE".
> > The lines 4 and 5 of the processor script contains the data mistaken,
> > but I don't undestand where is the eror.
> > The exception raised by the server is:
> > ---
> > SQL Error:  conversion error from string "". Error Code: -413. Overflow
> > occurred during data type conversion.
> > The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ,
> > MESE, ANNO)
> > VALUES (30030003004601, 3, 46, 1, 03, 2020)
> > ;
> > --
> - - - - - - - - - - - - - - - - - -
> Do you have a trigger on the table? Given the STATO column has a default
> of '', maybe a trigger tries to convert that to a number somewhere?
>
> Also, are you absolutely sure this is the statement that causes the
> problem. Your trying to execute a script, which Firebird itself does not
> support, so your component is doing some transformations, which might
> mean that the error is not on the line that you think it is. Try
> executing a single statement instead of a script.
>
> I'd recommend trying to reproduce it in ISQL, and if possible provide us
> with a minimum reproducible example
>
> Mark
> -- 
> Mark Rotteveel
>
>






++

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] error during the registratione of data on 2.5 FB database

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

On 04-04-2020 13:01, 'Stellarancia.com' ni...@stellarancia.com 
[firebird-support] wrote:
> No, there is not a trigger.
> 
> You say than the error is referred to another part (with mistaken value)
> of the entire script... but the compiler reports me the part that
> (maybe) run ok?!? How this is possible?

That is not what I said. Please read what I wrote again.

> Ok, print the script and study it.

I suggest that you do the work to make it as easy for us to help you. 
That means creating a minimal reproducible example that does not require 
any other tools than ISQL to reproduce the problem. Very likely while 
doing that, you will already find the problem yourself.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] error during the registratione of data on 2.5 FB database

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

No, there is not a trigger.

You say than the error is referred to another part (with mistaken value) 
of the entire script... but the compiler reports me the part that 
(maybe) run ok?!? How this is possible?

Ok, print the script and study it.

Antonio Bianca


Il 04/04/2020 10:57, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] ha scritto:
>
> On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com
> [firebird-support] wrote:
> > He,
> > I've an error that I don't undestrand.
> > I use Delphi 7 environment to create my applications, Zeos components
> > for connections and Firebird 2.5 Superserver for database management.
> > To register the data, my App uses the processor component; the
> > Connection.Autocommit  parameter is set to False.
> > My App inserts numerous lines of data to be recorded in the Process
> > component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT
> > INTO ZXD...'; UPDATE FGH SET ...'; and so on);
> > at the end, it adds the command "COMMIT;", then call "PARSE", and 
> "EXECUTE".
> > The lines 4 and 5 of the processor script contains the data mistaken,
> > but I don't undestand where is the eror.
> > The exception raised by the server is:
> > ---
> >
> > SQL Error:  conversion error from string "". Error Code: -413. Overflow
> > occurred during data type conversion.
> > The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ,
> > MESE, ANNO)
> > VALUES (30030003004601, 3, 46, 1, 03, 2020)
> > ;
> >
> > --
> > This is the table declaration:
> > --
> Do you have a trigger on the table? Given the STATO column has a default
> of '', maybe a trigger tries to convert that to a number somewhere?
>
> Also, are you absolutely sure this is the statement that causes the
> problem. Your trying to execute a script, which Firebird itself does not
> support, so your component is doing some transformations, which might
> mean that the error is not on the line that you think it is. Try
> executing a single statement instead of a script.
>
> I'd recommend trying to reproduce it in ISQL, and if possible provide us
> with a minimum reproducible example
>
> Mark
> -- 
> Mark Rotteveel
>
>

Re: [firebird-support] error during the registratione of data on 2.5 FB database

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

On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia.com 
[firebird-support] wrote:
> He,
> I've an error that I don't undestrand.
> I use Delphi 7 environment to create my applications, Zeos components
> for connections and Firebird 2.5 Superserver for database management.
> To register the data, my App uses the processor component; the
> Connection.Autocommit  parameter is set to False.
> My App inserts numerous lines of data to be recorded in the Process
> component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT
> INTO ZXD...'; UPDATE FGH SET ...'; and so on);
> at the end, it adds the command "COMMIT;", then call "PARSE", and "EXECUTE".
> The lines 4 and 5 of the processor script contains the data mistaken,
> but I don't undestand where is the eror.
> The exception raised by the server is:
> ---
> 
> SQL Error:  conversion error from string "". Error Code: -413. Overflow
> occurred during data type conversion.
> The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ,
> MESE, ANNO)
> VALUES (30030003004601, 3, 46, 1, 03, 2020)
> ;
> 
> --
> This is the table declaration:
> --
> 
> CREATE TABLE ANA_DIPE_PRESORD
> (
>     COD_REC Bigint NOT NULL,
>     ANNO Smallint DEFAULT 0,
>     MESE Smallint DEFAULT 0,
>     MATR Smallint DEFAULT 0,
>     DATORE Smallint DEFAULT 0,
>     POSIZ Smallint DEFAULT 0,
>     STATO Char(1) DEFAULT ''
>     CONSTRAINT PK_DIPPPREORD
>       PRIMARY KEY (COD_REC)
> );
> 
> CREATE UNIQUE INDEX IND_ANADPPREORD_COD ON ANA_DIPE_PRESORD (COD_REC);
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
>    ON ANA_DIPE_PRESORD TO  SYSDBA WITH GRANT OPTION;
> 
> --
> 
> The Table has no trigger, no generators, no stored procedures connected.
> The data in "COD_REC" must be unique.
> 
> No data are sent as  '' (void string), neither any value is sent as
> "Quoted string",
> because they are all of type smallint (and bigint).
> I'm going crazy.
> It's stupid, but I've changed the value for field 'MESE' from '03' to
> '3', but the result is the same.
> What can be the reason?
> Thanks for reply.

Do you have a trigger on the table? Given the STATO column has a default 
of '', maybe a trigger tries to convert that to a number somewhere?

Also, are you absolutely sure this is the statement that causes the 
problem. Your trying to execute a script, which Firebird itself does not 
support, so your component is doing some transformations, which might 
mean that the error is not on the line that you think it is. Try 
executing a single statement instead of a script.

I'd recommend trying to reproduce it in ISQL, and if possible provide us 
with a minimum reproducible example

Mark
-- 
Mark Rotteveel

[firebird-support] error during the registratione of data on 2.5 FB database

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He,
I've an error that I don't undestrand.
I use Delphi 7 environment to create my applications, Zeos components 
for connections and Firebird 2.5 Superserver for database management.
To register the data, my App uses the processor component; the 
Connection.Autocommit  parameter is set to False.
My App inserts numerous lines of data to be recorded in the Process 
component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT 
INTO ZXD...'; UPDATE FGH SET ...'; and so on);
at the end, it adds the command "COMMIT;", then call "PARSE", and "EXECUTE".
The lines 4 and 5 of the processor script contains the data mistaken, 
but I don't undestand where is the eror.
The exception raised by the server is:
---

SQL Error:  conversion error from string "". Error Code: -413. Overflow 
occurred during data type conversion.
The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ, 
MESE, ANNO)
VALUES (30030003004601, 3, 46, 1, 03, 2020)
;

--
This is the table declaration:
--

CREATE TABLE ANA_DIPE_PRESORD
(
   COD_REC Bigint NOT NULL,
   ANNO Smallint DEFAULT 0,
   MESE Smallint DEFAULT 0,
   MATR Smallint DEFAULT 0,
   DATORE Smallint DEFAULT 0,
   POSIZ Smallint DEFAULT 0,
   STATO Char(1) DEFAULT ''
   CONSTRAINT PK_DIPPPREORD
     PRIMARY KEY (COD_REC)
);

CREATE UNIQUE INDEX IND_ANADPPREORD_COD ON ANA_DIPE_PRESORD (COD_REC);
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
  ON ANA_DIPE_PRESORD TO  SYSDBA WITH GRANT OPTION;

--

The Table has no trigger, no generators, no stored procedures connected. 
The data in "COD_REC" must be unique.

No data are sent as  '' (void string), neither any value is sent as 
"Quoted string",
because they are all of type smallint (and bigint).
I'm going crazy.
It's stupid, but I've changed the value for field 'MESE' from '03' to 
'3', but the result is the same.
What can be the reason?
Thanks for reply.

Antonio BIANCA








++

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] Potential for improvements / optimization for the use case below?

[Patrick Marten patrick_mar...@yahoo.com [firebird-support]]

 Thank you for your reply, Lester.
I came across CTE during my research, but wasn't sure it was the right thing 
for this case. Looked more detailed into it and came up with this:
with TOTAL_STOCKS as (
  select PRODUCTID,
 STORAGE_AREA_ID_SOURCE,
 sum(AMOUNT) as TOTAL_STOCK
  from STOCK_RECORDS
  where STOCK_RELEVANT = -1
  group by PRODUCTID, STORAGE_AREA_ID_SOURCE
)
select sr.ID,
   sr.STORAGE_AREA_ID_SOURCE,
   sr.INSERTDATE,
   sr.EDITDATE,
   sr.PRODUCTID,
   sr.RECORD_DATE,
   sr.DELIVERYPOSID as POSID,
   sr.INSTANCE_TYPE,
   sr.INSTANCE_ID,
   abs(sr.AMOUNT) as AMOUNT,
   sr.STORAGE_AREA_ID_SOURCE,
   ts.TOTAL_STOCK as RESULTING_AMOUNT
from STOCK_RECORDS sr
 left join TOTAL_STOCKS ts
   on sr.STORAGE_AREA_ID_SOURCE = ts.STORAGE_AREA_ID_SOURCE and 
sr.PRODUCTID = ts.PRODUCTID
where sr.INSTANCE_TYPE = 2
If that's correct, then there is still one thing I have trouble with: the 
sum(AMOUNT) aka RESULTING_AMOUNT has to be based on the field EDITDATE, i.e. I 
need an amount for each row, which was the TOTAL AMOUNT back then, i.e. prior 
to EDITDATE in the said row. There are actually some more criteria to exclude 
some rows, but if there is a solution for EDITDATE, that would be similar for 
the rest.
If I do 

with TOTAL_STOCKS as (
  select PRODUCTID,
 STORAGE_AREA_ID_SOURCE,
 sum(AMOUNT) as TOTAL_STOCK
  from STOCK_RECORDS
  where STOCK_RELEVANT = -1 and EDITDATE <= :EDITDATE   group by PRODUCTID, 
STORAGE_AREA_ID_SOURCE
)
That would apply to all rows. If I pass PRODUCTID and STORAGE_AREA_ID_SOURCE as 
parameters as well, that wouldn't be a full view of data to work with.
Where would I put the EDITDATE part, when using CTE?

Re: [firebird-support] Potential for improvements / optimization for the use case below?

[Lester Caine les...@lsces.uk [firebird-support]]

On 02/04/2020 08:12, Patrick Marten patrick_mar...@yahoo.com 
[firebird-support] wrote:
> There was an other procedure that took long, and I was able to 
> drasticaly improve it by adding one multi-segment index, but all my 
> attempts to do the same in the case above didn't have much impact so far.

Just a quick reply while passing ... CTE

https://firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-select-cte
 
for example.

Use the 'with' section to produce a view of the data that you need to 
work with, and then the select section can include the 'sum' on the 
already filtered data.

I'm working with tables that are in the millions now but the reports are 
now as fast as they were when we only had tens of thousands ... I'm 
summing the current day or week from many years of live data.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.uk/wiki/Contact
L.S.Caine Electronic Services - https://lsces.uk
Model Engineers Digital Workshop - https://medw.uk
Rainbow Digital Media - https://rainbowdigitalmedia.uk

[firebird-support] Potential for improvements / optimization for the use case below?

[Patrick Marten patrick_mar...@yahoo.com [firebird-support]]

Greetings,

I've the following table:

CREATE TABLE STOCK_RECORDS 
(
  ID                                    INTEGER                    NOT NULL,
  LOCATION                            SMALLINT,
  INSERTUSER                        SMALLINT                    DEFAULT 0,    
<-- FOREIGN KEY CONSTRAINT
  INSERTDATE                        TIMESTAMP,
  EDITUSER                            SMALLINT                    DEFAULT 0,    
<-- FOREIGN KEY CONSTRAINT
  EDITDATE                            TIMESTAMP,
  PRODUCTID                            INTEGER,                                 
   <-- FOREIGN KEY CONSTRAINT
  RECORD_DATE                        TIMESTAMP,
  RECORD_TYPE                        SMALLINT                    DEFAULT 0,
  STORAGE_AREA_ID_SOURCE        INTEGER,                                    <-- 
FOREIGN KEY CONSTRAINT
  STORAGE_AREA_ID_TARGET        INTEGER,                                    <-- 
FOREIGN KEY CONSTRAINT
  INVENTORYPOSID                    INTEGER,                                    
<-- FOREIGN KEY CONSTRAINT
  PURCHASEORDERPOSID                INTEGER,                                    
<-- FOREIGN KEY CONSTRAINT
  DELIVERYPOSID                    INTEGER,                                    
<-- FOREIGN KEY CONSTRAINT
  INVOICEPOSID                        INTEGER,                                  
  <-- FOREIGN KEY CONSTRAINT
  INSTANCE_TYPE                    SMALLINT,
  INSTANCE_ID                        INTEGER,
  AMOUNT                                DOUBLE PRECISION,
  RESULTING_AMOUNT                DOUBLE PRECISION,
  NOTES                                VARCHAR(   255),
  STOCK_RELEVANT                    BOOLEAN
);

ALTER TABLE STOCK_RECORDS ADD CONSTRAINT PK_STOCK_RECORDS PRIMARY KEY(ID);
CREATE GENERATOR STOCK_RECORDS_PRIMARYKEY;

CREATE ASC INDEX STOCK_RECORDS_LOCATION ON STOCK_RECORDS (LOCATION);
CREATE ASC INDEX STOCK_RECORDS_RECORD_DATE ON STOCK_RECORDS (RECORD_DATE);
CREATE ASC INDEX STOCK_RECORDS_RECORD_TYPE ON STOCK_RECORDS (RECORD_TYPE);
CREATE ASC INDEX STOCK_RECORDS_INSTANCE_TYPE ON STOCK_RECORDS (INSTANCE_TYPE);

The domain "BOOLEAN" is defined like this:
CREATE DOMAIN BOOLEAN AS SMALLINT  DEFAULT 0 CHECK (VALUE IN (-1, 0)) NOT NULL;

In an update procedure I'm doing the following by using IBOjects:


IBOQueryStockRecords.ReadOnly := False;
IBOQueryStockRecords.RequestLive := True;

IBOQueryStockRecords.Close;
IBOQueryStockRecords.SQL.Clear;
IBOQueryStockRecords.SQL.Add('select ID, EDITDATE, PRODUCTID, DELIVERYPOSID as 
POSID, abs(AMOUNT) as AMOUNT, RESULTING_AMOUNT from MOV_STOCK_RECORDS where 
(INSTANCE_TYPE = 2)');
IBOQueryStockRecords.Open;

if not (IBOQueryStockRecords.Bof and IBOQueryStockRecords.Eof) then begin
    with IBCursorResultingStock do begin
        Close;
        SQL.Clear;
        SQL.Add('select sum(AMOUNT) as GESAMTBESTAND from MOV_STOCK_RECORDS 
where (ID > 0) and (PRODUCTID = :PRODUCTID) and (STORAGE_AREA_ID_SOURCE = 
:STORAGE_AREA_ID_SOURCE) and (STOCK_RELEVANT = -1)');
        SQL.Add('and ((DELIVERYPOSID <> :DELIVERYPOSID) or DELIVERYPOSID is 
null)');
        SQL.Add('and (EDITDATE <= :EDITDATE)');
        Prepare;
    end;

    IBOQueryStockRecords.First;
    while not IBOQueryStockRecords.Eof do begin
        with IBCursorResultingStock do begin
            Close;
            ParamByName('PRODUCTID').AsInteger := 
IBOQueryStockRecords.FieldByName('PRODUCTID').AsInteger;
            ParamByName('STORAGE_AREA_ID_SOURCE').AsInteger := 1;
            ParamByName('DELIVERYPOSID').AsInteger := 
IBOQueryStockRecords.FieldByName('POSID').AsInteger;
            ParamByName('EDITDATE').AsDateTime := 
IBOQueryStockRecords.FieldByName('EDITDATE').AsDateTime;
            Open;
            First;

            if not (Bof and Eof) then begin
                ResStockAmount := Fields[0].AsFloat;
            end;
        end;

        if IBOQueryStockRecords.FieldByName('RESULTING_AMOUNT').AsFloat <> 
ResStockAmount then begin
            IBOQueryStockRecords.Edit;
            IBOQueryStockRecords.FieldByName('RESULTING_AMOUNT').AsFloat := 
ResStockAmount;
            IBOQueryStockRecords.Post;
        end;

        IBOQueryStockRecords.Next;
    end;
end;

For ca. 100k records as the result of the select statement of 
IBOQueryStockRecords updating the values takes very long. I also tried to use 
an IB_Script rather than editing the records directly, but this didn't change 
much. Apparently selecting the sum of AMOUNT with IBCursorResultingStock is 
what adds in execution time of the procedure the most.

Do you guys see any potential for improvement by adding some indexes or 
something?
There was an other procedure that took long, and I was able to drasticaly 
improve it by adding one multi-segment index, but all my attempts to do the 
same in the case above didn't have much impact so far.
Best regards,Patrick

[firebird-support] Re: Firebird vs Intebase

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Mark Rotteveel m...@lawinegevaar.nl [firebird-support] a écrit :
> On 26-03-2020 11:37, Dimitry Sibiryakov s...@ibphoenix.com 
> [firebird-support] wrote:
>> 26.03.2020 11:35, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] 
>> wrote:
>>> Form Embarcadero marketing matriel
>> 
>> Already was discussed here a couple of months ago. Look into archives.
>
> Which archives?

news (port:119)
news.gmane.io/gmane.comp.db.firebird.user

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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] Firebird vs Intebase

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

On 26-03-2020 11:37, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
> 26.03.2020 11:35, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] 
> wrote:
>> Form Embarcadero marketing matriel
> 
> Already was discussed here a couple of months ago. Look into archives.

Which archives?

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Firebird vs Intebase

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

26.03.2020 11:35, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] 
wrote:
> Form Embarcadero marketing matriel

   Already was discussed here a couple of months ago. Look into archives.

-- 
   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] Firebird vs Intebase

[Tommi Prami tommi.pr...@suonentieto.fi [firebird-support]]

Form Embarcadero marketing matriel, has there been any tests lately? Early on 
FB was faster I think.
(https://community.idera.com/developer-tools/b/blog/posts/interbase-isv-database-comparison)

InterBase v FirebirdFirebird

Summary: InterBase is faster, vastly more scalable, is packed with superior 
disaster recovery and data protection compliance features that are key to 
maintaining both you and your customer's reputations. Additionally, Change 
Views adds a zero cost and highly scalable replication engine API that reduces 
significantly both data movement and replication licensing costs for the lowest 
total cost of ownership.

-Tee-

Re: [firebird-support] Firebird 4.0.0-1436 beta 1

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

Thanks a lot. Now it works.
Gregor



Sent from Yahoo Mail. Get the app 

On Wednesday, March 25, 2020, 2:27:12 PM GMT+1, Mark Rotteveel 
m...@lawinegevaar.nl [firebird-support]  
wrote:  
 
     
On 2020-03-25 13:24, Gregor Kobler gregorkob...@yahoo.com 
[firebird-support] wrote:
> Hello Mark
> 
> Yes I am aware of that, but I have no experience with the snapshots.
> How do I make the current snapshot work. I run the file
> "Install_service.bat". The Firebird service is running, but when I try
> to connect, the following message appears
> 
> Install incomplete, please read the Compatibility chapter in the
> release notes for this version.

That is because your security database hasn't been initialized yet for 
the SRP authentication plugin. This isn't new, the same error would 
occur with Firebird 3.

To fix this you need to create a SRP user. To do that, stop the firebird 
service, run

isql -user sysdba employee
create user sysdba password '';
exit;

And start the Firebird service again.

Mark

  #yiv2216239056 #yiv2216239056 -- #yiv2216239056ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2216239056 
#yiv2216239056ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2216239056 
#yiv2216239056ygrp-mkp #yiv2216239056hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2216239056 #yiv2216239056ygrp-mkp #yiv2216239056ads 
{margin-bottom:10px;}#yiv2216239056 #yiv2216239056ygrp-mkp .yiv2216239056ad 
{padding:0 0;}#yiv2216239056 #yiv2216239056ygrp-mkp .yiv2216239056ad p 
{margin:0;}#yiv2216239056 #yiv2216239056ygrp-mkp .yiv2216239056ad a 
{color:#ff;text-decoration:none;}#yiv2216239056 #yiv2216239056ygrp-sponsor 
#yiv2216239056ygrp-lc {font-family:Arial;}#yiv2216239056 
#yiv2216239056ygrp-sponsor #yiv2216239056ygrp-lc #yiv2216239056hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2216239056 
#yiv2216239056ygrp-sponsor #yiv2216239056ygrp-lc .yiv2216239056ad 
{margin-bottom:10px;padding:0 0;}#yiv2216239056 #yiv2216239056actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2216239056 
#yiv2216239056activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2216239056
 #yiv2216239056activity span {font-weight:700;}#yiv2216239056 
#yiv2216239056activity span:first-child 
{text-transform:uppercase;}#yiv2216239056 #yiv2216239056activity span a 
{color:#5085b6;text-decoration:none;}#yiv2216239056 #yiv2216239056activity span 
span {color:#ff7900;}#yiv2216239056 #yiv2216239056activity span 
.yiv2216239056underline {text-decoration:underline;}#yiv2216239056 
.yiv2216239056attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2216239056 .yiv2216239056attach div a 
{text-decoration:none;}#yiv2216239056 .yiv2216239056attach img 
{border:none;padding-right:5px;}#yiv2216239056 .yiv2216239056attach label 
{display:block;margin-bottom:5px;}#yiv2216239056 .yiv2216239056attach label a 
{text-decoration:none;}#yiv2216239056 blockquote {margin:0 0 0 
4px;}#yiv2216239056 .yiv2216239056bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2216239056 
.yiv2216239056bold a {text-decoration:none;}#yiv2216239056 dd.yiv2216239056last 
p a {font-family:Verdana;font-weight:700;}#yiv2216239056 dd.yiv2216239056last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2216239056 
dd.yiv2216239056last p span.yiv2216239056yshortcuts 
{margin-right:0;}#yiv2216239056 div.yiv2216239056attach-table div div a 
{text-decoration:none;}#yiv2216239056 div.yiv2216239056attach-table 
{width:400px;}#yiv2216239056 div.yiv2216239056file-title a, #yiv2216239056 
div.yiv2216239056file-title a:active, #yiv2216239056 
div.yiv2216239056file-title a:hover, #yiv2216239056 div.yiv2216239056file-title 
a:visited {text-decoration:none;}#yiv2216239056 div.yiv2216239056photo-title a, 
#yiv2216239056 div.yiv2216239056photo-title a:active, #yiv2216239056 
div.yiv2216239056photo-title a:hover, #yiv2216239056 
div.yiv2216239056photo-title a:visited {text-decoration:none;}#yiv2216239056 
div#yiv2216239056ygrp-mlmsg #yiv2216239056ygrp-msg p a 
span.yiv2216239056yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2216239056 
.yiv2216239056green {color:#628c2a;}#yiv2216239056 .yiv2216239056MsoNormal 
{margin:0 0 0 0;}#yiv2216239056 o {font-size:0;}#yiv2216239056 
#yiv2216239056photos div {float:left;width:72px;}#yiv2216239056 
#yiv2216239056photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2216239056 
#yiv2216239056photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2216239056
 #yiv2216239056reco-category {font-size:77%;}#yiv2216239056 
#yiv2216239056reco-desc {font-size:77%;}#yiv2216239056 .yiv2216239056replbq 
{margin:4px;}#yiv2216239056 #yiv2216239056ygrp-actbar div a:first-child 
{margin-right:

Re: [firebird-support] Firebird 4.0.0-1436 beta 1

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

On 2020-03-25 13:24, Gregor Kobler gregorkob...@yahoo.com 
[firebird-support] wrote:
> Hello Mark
> 
> Yes I am aware of that, but I have no experience with the snapshots.
> How do I make the current snapshot work. I run the file
> "Install_service.bat". The Firebird service is running, but when I try
> to connect, the following message appears
> 
> Install incomplete, please read the Compatibility chapter in the
> release notes for this version.

That is because your security database hasn't been initialized yet for 
the SRP authentication plugin. This isn't new, the same error would 
occur with Firebird 3.

To fix this you need to create a SRP user. To do that, stop the firebird 
service, run

isql -user sysdba employee
create user sysdba password '';
exit;

And start the Firebird service again.

Mark

Re: [firebird-support] Firebird 4.0.0-1436 beta 1

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

25.03.2020 13:24, Gregor Kobler gregorkob...@yahoo.com [firebird-support] wrote:
> How do I make the current snapshot work. I run the file 
> "Install_service.bat". The 
> Firebird service is running, but when I try to connect, the following message 
> appears
> 
> Install incomplete, please read the Compatibility chapter in the release 
> notes for this 
> version.

   Try to read Release Notes for Firebird 3.0.

-- 
   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] Firebird 4.0.0-1436 beta 1

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

Hello Mark

Yes I am aware of that, but I have no experience with the snapshots. How do I 
make the current snapshot work. I run the file "Install_service.bat". The 
Firebird service is running, but when I try to connect, the following message 
appears

Install incomplete, please read the Compatibility chapter in the release notes 
for this version.
Gregor



Sent from Yahoo Mail. Get the app 

On Wednesday, March 25, 2020, 1:06:35 PM GMT+1, Mark Rotteveel 
m...@lawinegevaar.nl [firebird-support]  
wrote:  
 
     
On 2020-03-24 10:47, Gregor Kobler gregorkob...@yahoo.com 
[firebird-support] wrote:
> Hello
> 
> I try a little bit with the FB4 beta 1
> 
> two errors i got
> 1. When i try to connect with my 64Bit program and using the
> fbclient.dll (64Bit) my program crashes! when i use the 64bit dll from
> FB3 it works, also when i use the 32bit version with my 32bit program.
> I used the dll from "C:\Program Files\Firebird\Firebird_4_0"
> 
> 2. When i try to execute a SQL-Statement like "select * from
> mon$database" if got the follow error with EMS-Firebird Manager
> Unknown SQL Data type (32754).
> 
> And my program catches a exception with eurekalog like the follow
> 2.5 Type : EIBNativeException
> 2.6 Message : [FireDAC][Phys][FB]Incorrect values within SQLDA
> structure.
> 
> Has somebody a tip? Thanks

If you want to test Firebird 4, consider using one of the snapshots. 
Firebird 4 beta 1 is already a year old, so testing against it is not 
really of value to the project, because chances are high some problems 
are already fixed, and you might miss different, new problems.

Mark

  #yiv0697466060 #yiv0697466060 -- #yiv0697466060ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0697466060 
#yiv0697466060ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0697466060 
#yiv0697466060ygrp-mkp #yiv0697466060hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0697466060 #yiv0697466060ygrp-mkp #yiv0697466060ads 
{margin-bottom:10px;}#yiv0697466060 #yiv0697466060ygrp-mkp .yiv0697466060ad 
{padding:0 0;}#yiv0697466060 #yiv0697466060ygrp-mkp .yiv0697466060ad p 
{margin:0;}#yiv0697466060 #yiv0697466060ygrp-mkp .yiv0697466060ad a 
{color:#ff;text-decoration:none;}#yiv0697466060 #yiv0697466060ygrp-sponsor 
#yiv0697466060ygrp-lc {font-family:Arial;}#yiv0697466060 
#yiv0697466060ygrp-sponsor #yiv0697466060ygrp-lc #yiv0697466060hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0697466060 
#yiv0697466060ygrp-sponsor #yiv0697466060ygrp-lc .yiv0697466060ad 
{margin-bottom:10px;padding:0 0;}#yiv0697466060 #yiv0697466060actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0697466060 
#yiv0697466060activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0697466060
 #yiv0697466060activity span {font-weight:700;}#yiv0697466060 
#yiv0697466060activity span:first-child 
{text-transform:uppercase;}#yiv0697466060 #yiv0697466060activity span a 
{color:#5085b6;text-decoration:none;}#yiv0697466060 #yiv0697466060activity span 
span {color:#ff7900;}#yiv0697466060 #yiv0697466060activity span 
.yiv0697466060underline {text-decoration:underline;}#yiv0697466060 
.yiv0697466060attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0697466060 .yiv0697466060attach div a 
{text-decoration:none;}#yiv0697466060 .yiv0697466060attach img 
{border:none;padding-right:5px;}#yiv0697466060 .yiv0697466060attach label 
{display:block;margin-bottom:5px;}#yiv0697466060 .yiv0697466060attach label a 
{text-decoration:none;}#yiv0697466060 blockquote {margin:0 0 0 
4px;}#yiv0697466060 .yiv0697466060bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0697466060 
.yiv0697466060bold a {text-decoration:none;}#yiv0697466060 dd.yiv0697466060last 
p a {font-family:Verdana;font-weight:700;}#yiv0697466060 dd.yiv0697466060last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0697466060 
dd.yiv0697466060last p span.yiv0697466060yshortcuts 
{margin-right:0;}#yiv0697466060 div.yiv0697466060attach-table div div a 
{text-decoration:none;}#yiv0697466060 div.yiv0697466060attach-table 
{width:400px;}#yiv0697466060 div.yiv0697466060file-title a, #yiv0697466060 
div.yiv0697466060file-title a:active, #yiv0697466060 
div.yiv0697466060file-title a:hover, #yiv0697466060 div.yiv0697466060file-title 
a:visited {text-decoration:none;}#yiv0697466060 div.yiv0697466060photo-title a, 
#yiv0697466060 div.yiv0697466060photo-title a:active, #yiv0697466060 
div.yiv0697466060photo-title a:hover, #yiv0697466060 
div.yiv0697466060photo-title a:visited {text-decoration:none;}#yiv0697466060 
div#yiv0697466060ygrp-mlmsg #yiv0697466060ygrp-msg p a 
span.yiv0697466060yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0697466060 
.yiv0697466060green {color:#628c

Re: [firebird-support] Firebird 4.0.0-1436 beta 1

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

On 2020-03-24 10:47, Gregor Kobler gregorkob...@yahoo.com 
[firebird-support] wrote:
> Hello
> 
> I try a little bit with the FB4 beta 1
> 
> two errors i got
> 1. When i try to connect with my 64Bit program and using the
> fbclient.dll (64Bit) my program crashes! when i use the 64bit dll from
> FB3 it works, also when i use the 32bit version with my 32bit program.
> I used the dll from "C:\Program Files\Firebird\Firebird_4_0"
> 
> 2. When i try to execute a SQL-Statement like "select * from
> mon$database" if got the follow error with EMS-Firebird Manager
> Unknown SQL Data type (32754).
> 
> And my program catches a exception with eurekalog like the follow
>   2.5 Type  : EIBNativeException
>   2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA
> structure.
> 
> Has somebody a tip? Thanks

If you want to test Firebird 4, consider using one of the snapshots. 
Firebird 4 beta 1 is already a year old, so testing against it is not 
really of value to the project, because chances are high some problems 
are already fixed, and you might miss different, new problems.

Mark

Re: [firebird-support] Re: Firebird 4.0.0-1436 beta 1

[DougC d...@moosemail.net [firebird-support]]

Please move messages about Firebird 4 (and any unreleased version) to 
developers mailing list!

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> SET BIND OF  TIME ZONE  TO  LEGACY ;

for more complete information on "bind", the documentation is here

https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.set_bind.md

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> But the new field typ Timestamp_tz are a bigger problem. So i think, we 
> running into a compatibility problem with older developer systems. I use 
> Delphi Rio 10.3.3 with FireDAC, but its not possible for me to compile a 
> running program right now?!

but if, of course, the development team has everything planned :-)

SET BIND OF  TIME ZONE  TO  LEGACY ;

SQL_TIMESTAMP_TZ ->SQL_TIMESTAMP

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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] Re: Firebird 4.0.0-1436 beta 1

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

There are no an installer for Built 1815, and I don't have any exprerience how 
to make a snapshot running.
Also i din't find any solution at the web. Could you explain me that.
The fbclient.dll Built 1815-64bit works with beta 1.
But the new field typ Timestamp_tz are a bigger problem. So i think, we running 
into a compatibility problem with older developer systems. I use Delphi Rio 
10.3.3 with FireDAC, but its not possible for me to compile a running program 
right now?!
Best RegardsGregor



Sent from Yahoo Mail. Get the app 

On Tuesday, March 24, 2020, 1:04:41 PM GMT+1, Norbert Saint Georges 
n...@tetrasys.eu [firebird-support]  wrote:  
 
 Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the fbclient.dll 
> (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also 
> when i use the 32bit version with my 32bit program. I used the dll from 
> "C:\Program Files\Firebird\Firebird_4_0"
>
> 2. When i try to execute a SQL-Statement like "select * from mon$database" if 
> got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754).
>
> And my program catches a exception with eurekalog like the follow
>   2.5 Type  : EIBNativeException
>   2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA 
> structure.
>
> Has somebody a tip? Thanks
>
> Gregor

after a test with the compiled version of the day, indeed, there is the 
following error if we do not use the 1815 version of fbclient

"Unsuccessful execution caused by system error that does not preclude 
successful execution of subsequent statements.
Invalid clumplet buffer structure: path length doesn't match with 
clumplet."

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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



  

[firebird-support] فتح باب الالتحاق بالجامعات البريطانية لدرجة البكالوريوس في مجالات الادارة ونظم المعلومات

[غادة الرفاعى ghada.elref...@yahoo.com [firebird-support]]

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

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the fbclient.dll 
> (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also 
> when i use the 32bit version with my 32bit program. I used the dll from 
> "C:\Program Files\Firebird\Firebird_4_0"
>
> 2. When i try to execute a SQL-Statement like "select * from mon$database" if 
> got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754).
>
> And my program catches a exception with eurekalog like the follow
>   2.5 Type  : EIBNativeException
>   2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA 
> structure.
>
> Has somebody a tip? Thanks
>
> Gregor

after a test with the compiled version of the day, indeed, there is the 
following error if we do not use the 1815 version of fbclient

"Unsuccessful execution caused by system error that does not preclude 
successful execution of subsequent statements.
Invalid clumplet buffer structure: path length doesn't match with 
clumplet."

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Newest version of what? EMS? FDAC?  Or FB4?

sources of FB4 :-)

as a working client with FB4 currently, there is RedDatabase from 
RedSoft (https://reddatabase.ru/downloads/redexpert/)

or IBExpert (https://www.ibexpert.net/downloadcenter/)
all other utilities tested to date generate compatibility errors.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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] Re: Firebird 4.0.0-1436 beta 1

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

Hello Norbert
Newest version of what? EMS? FDAC?  Or FB4?

Thx Gregor

Sent from Yahoo Mail. Get the app 

On Tuesday, March 24, 2020, 11:02:39 AM GMT+1, Norbert Saint Georges 
n...@tetrasys.eu [firebird-support]  wrote:  
 
 Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the fbclient.dll 
> (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also 
> when i use the 32bit version with my 32bit program. I used the dll from 
> "C:\Program Files\Firebird\Firebird_4_0"
>
> 2. When i try to execute a SQL-Statement like "select * from mon$database" if 
> got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754).
>
> And my program catches a exception with eurekalog like the follow
>   2.5 Type  : EIBNativeException
>   2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA 
> structure.
>
> Has somebody a tip? Thanks
>
> Gregor

32754 = SQL_TIMESTAMP_TZ and EMS and FireDAC does not recognize it yet.
You are interested in doing the test with a version compiled with the 
latest sources

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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



  

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the fbclient.dll 
> (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also 
> when i use the 32bit version with my 32bit program. I used the dll from 
> "C:\Program Files\Firebird\Firebird_4_0"
>
> 2. When i try to execute a SQL-Statement like "select * from mon$database" if 
> got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754).
>
> And my program catches a exception with eurekalog like the follow
>   2.5 Type  : EIBNativeException
>   2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA 
> structure.
>
> Has somebody a tip? Thanks
>
> Gregor

32754 = SQL_TIMESTAMP_TZ and EMS and FireDAC does not recognize it yet.
You are interested in doing the test with a version compiled with the 
latest sources

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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] Firebird 4.0.0-1436 beta 1

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

Hello

I try a little bit with the FB4 beta 1

two errors i got
1. When i try to connect with my 64Bit program and using the fbclient.dll 
(64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also 
when i use the 32bit version with my 32bit program. I used the dll from 
"C:\Program Files\Firebird\Firebird_4_0"

2. When i try to execute a SQL-Statement like "select * from mon$database" if 
got the follow error with EMS-Firebird Manager
Unknown SQL Data type (32754).

And my program catches a exception with eurekalog like the follow
  2.5 Type  : EIBNativeException
  2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA 
structure.

Has somebody a tip? Thanks

Gregor

Re: [firebird-support] Firebird and Sam Broadcaster

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

On 22-03-2020 03:06, Audio Buff npage@gmail.com [firebird-support] 
wrote:
> During the install of Sam Broadcaster, there are a few database options,
> Firebird being named as the most simple to get started. I used the Firebird
> version from the official archive, the latest version.
> When selecting Firebird with default options with in the Sam Broadcaster,
> it errors;
> 
> [image: image.png]
> I've combed through all  that I can find in Sam Broadcast forums. Any help
> here would be amazing. Thanks.

This list filters out attachments. Please provide the error message as 
text, or link to the image hosted elsewhere.

Mark
-- 
Mark Rotteveel

[firebird-support] Firebird and Sam Broadcaster

[Audio Buff npage....@gmail.com [firebird-support]]

During the install of Sam Broadcaster, there are a few database options,
Firebird being named as the most simple to get started. I used the Firebird
version from the official archive, the latest version.
When selecting Firebird with default options with in the Sam Broadcaster,
it errors;

[image: image.png]
I've combed through all  that I can find in Sam Broadcast forums. Any help
here would be amazing. Thanks.


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

Re: [firebird-support] error: -901: invalid BLOB ID

[Pro Turm protu...@mailbox.org [firebird-support]]

> On March 20, 2020 11:16 AM Dimitry Sibiryakov 
> > What could be the possible reasons for getting this error?
> 
>BLOB id must be used in the same transaction where it was obtained.

And if the BLOB id is the same all over one transaction ?

Re: [firebird-support] error: -901: invalid BLOB ID

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

20.03.2020 09:29, Pro Turm protu...@mailbox.org [firebird-support] wrote:
> What could be the possible reasons for getting this error?

   BLOB id must be used in the same transaction where it was obtained.


-- 
   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] error: -901: invalid BLOB ID

[Pro Turm protu...@mailbox.org [firebird-support]]

What could be the possible reasons for getting this error?

error: -901: invalid BLOB ID

10x in advance!

[firebird-support] الحصول على البكالوريوس من خلال التعليم الإلكتروني فى الجامعات البريطانية

[غادة الرفاعى ghada.elref...@yahoo.com [firebird-support]]

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

Re: [firebird-support] problemtic User management on firebird 3

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

The problem is that the order of clauses in your create database 
statement is wrong. The USER  and PASSWORD  clauses must 
follow *immediately* after the `CREATE `. See also [1]. 
I'm unsure why this doesn't produce a different error though. As a 
secondary problem, in a create database clause, the password *must* be 
enclosed in single quotes.

Also, granting a user admin role in the security database, only makes 
that user admin in the security database. It does not grant global admin 
rights (which is why you need to grant create database as well). As 
documented in [2]:
"""
If the GRANT ADMIN ROLE clause is specified, the new user account is 
created with the privileges of the RDB$ADMIN role in the security 
database (security2.fdb). It allows the new user to manage user accounts 
from any regular database he logs into, but it does not grant the user 
any special privileges on objects in those databases.
"""

So, steps to do this:

D:\DevSoft\Firebird\Firebird-3.0.5.33220-0_x64>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:employee' user sysdba password 'masterkey';
Database: 'localhost:employee', User: SYSDBA
SQL> create user macky password '1234' grant admin role;
SQL> grant create database to user macky;
SQL> commit;
SQL> create database 'localhost:e:\db\testcreatedb.fdb' user macky 
password '1234' default character set utf8;
SQL>

[1]: 
https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-db.html
[2]: 
https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-auth.html#fblangref25-security-auth-create-user

On 14-03-2020 18:07, Yannis Kozikopoulos jk...@freemail.gr 
[firebird-support] wrote:
> this is a new installation no existing databases no legacy code to support.
> 
> After installing the 64bit server on windows 7 machine file name
> Firebird-3.0.5.33220_0_x64.exe then do the following
> 
> c:> "c:\Program Files\Firebird\3_0\isql.exe"
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> connect localhost:employee user sysdba password masterkey;
> Database: localhost:employee, User: SYSDBA
> SQL> create user macky password '1234' grant admin role;
> SQL>quit;
> 
> now I'm not interested in using sysdba for anything else just create my
> own super user and use that for everything.
> so next step create a new database
> 
> c:> "c:\Program Files\Firebird\3_0\isql.exe"
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> create database 'localhost:D:\data\firebird\macky.fdb' default
> character set utf8 user macky password 1234;
> Statement failed, SQLSTATE = 28000
> Your user name and password are not defined. Ask your database
> administrator to set up a Firebird login.
> SQL>quit;
> 
> What the F? ok lets test that
> 
> c:> "c:\Program Files\Firebird\3_0\isql.exe"
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> connect localhost:employee user macky password 1234;
> Database: localhost:employee, User: MACKY
> SQL> select Sec$User_name from sec$users;
> 
> SEC$USER_NAME
> ===
> MACKY
> 
> SQL> quit;
> 
> erm there is something I'm missing here lets try to grant the database
> create rights to the macky
> 
> C:> "c:\Program Files\Firebird\3_0\isql.exe"
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> connect localhost:employee user sysdba password masterkey;
> Database: localhost:employee, User: SYSDBA
> SQL> grant create database to macky;
> Statement failed, SQLSTATE = 0A000
> unsuccessful metadata update
> -GRANT failed
> -feature is not supported
> -Only grants to USER or ROLE are supported for CREATE DATABASE
> SQL> grant create database to user macky;
> SQL>quit;
> 
> OK now that should do the trick, lets test it.
> 
> C:> "c:\Program Files\Firebird\3_0\isql.exe"
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> create database 'localhost:D:\data\firebird\macky.fdb' default
> character set utf8 user macky password 1234;
> Statement failed, SQLSTATE = 28000
> Your user name and password are not defined. Ask your database
> administrator to set up a Firebird login.
> SQL>
> 
> I give up. any idea what I'm doing wrong here? for now I'm going to use
> one of the free gui admin tools in embedded mode but if the user
> management and stored proc thingy doesn't get better any time soon I'll
> drop firebird altogether.
> 
> thank you for your time. Your efforts are greatly appreciated regardless
> of outcome.

-- 
Mark Rotteveel

[firebird-support] problemtic User management on firebird 3

[Yannis Kozikopoulos jk...@freemail.gr [firebird-support]]

this is a new installation no existing databases no legacy code to support.

After installing the 64bit server on windows 7 machine file name 
Firebird-3.0.5.33220_0_x64.exe then do the following

c:> "c:\Program Files\Firebird\3_0\isql.exe"
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect localhost:employee user sysdba password masterkey;
Database: localhost:employee, User: SYSDBA
SQL> create user macky password '1234' grant admin role;
SQL>quit;

now I'm not interested in using sysdba for anything else just create my 
own super user and use that for everything.
so next step create a new database

c:> "c:\Program Files\Firebird\3_0\isql.exe"
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'localhost:D:\data\firebird\macky.fdb' default 
character set utf8 user macky password 1234;
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database 
administrator to set up a Firebird login.
SQL>quit;

What the F? ok lets test that

c:> "c:\Program Files\Firebird\3_0\isql.exe"
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect localhost:employee user macky password 1234;
Database: localhost:employee, User: MACKY
SQL> select Sec$User_name from sec$users;

SEC$USER_NAME
===
MACKY

SQL> quit;

erm there is something I'm missing here lets try to grant the database 
create rights to the macky

C:> "c:\Program Files\Firebird\3_0\isql.exe"
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect localhost:employee user sysdba password masterkey;
Database: localhost:employee, User: SYSDBA
SQL> grant create database to macky;
Statement failed, SQLSTATE = 0A000
unsuccessful metadata update
-GRANT failed
-feature is not supported
-Only grants to USER or ROLE are supported for CREATE DATABASE
SQL> grant create database to user macky;
SQL>quit;

OK now that should do the trick, lets test it.

C:> "c:\Program Files\Firebird\3_0\isql.exe"
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'localhost:D:\data\firebird\macky.fdb' default 
character set utf8 user macky password 1234;
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database 
administrator to set up a Firebird login.
SQL>

I give up. any idea what I'm doing wrong here? for now I'm going to use 
one of the free gui admin tools in embedded mode but if the user 
management and stored proc thingy doesn't get better any time soon I'll 
drop firebird altogether.

thank you for your time. Your efforts are greatly appreciated regardless 
of outcome.

Re: [firebird-support] Ubuntu 3.0.5 version

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

On 13-03-2020 14:49, Jorge Andres Brugger jorge.brug...@gmail.com 
[firebird-support] wrote:
> Mariuz's Ubuntu repository contains version 3.0.5.33100 and was released 
> in October 2019. The official version on the Firebird website is 
> 3.0.5.33220, released in January 2020. This is ok in terms of stability, 
> if I want to use the Ubuntu package?

No, 3.0.5.33100 is an unreleased snapshot version of 3.0.5 and that 
means that by definition it is unstable. There were 120 builds between 
that snapshot and the official 3.0.5 release (3.0.5.33220), that is a 
lot of builds and a lot of changes and fixes.

Also, build 33100 is from February 2, 2019[1], not from October 2019, so 
it is a lot older than you think.

Mark

  [1]: 
https://github.com/FirebirdSQL/firebird/commit/51e28472f78e109fc1475799a3c12f5d2f900f69
-- 
Mark Rotteveel

Re: [firebird-support] mapping destroyed by backup / restore

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

This sounds like a bug to me. Can you create bug report in the tracker 
at http://tracker.firebirdsql.org/browse/CORE

Mark

On 09-03-2020 03:50, FSPAPA INCA Team i...@foodstuffs-si.co.nz 
[firebird-support] wrote:
> 
> 
> Hi – I have another question re user mapping…
> 
> If I create a new database with a user->role mapping, I can back up and 
> restore it and the mapping is still present.
> 
> But if I back up the new copy and restore that, the mapping is gone… is 
> there an issue with the procedure I'm using or is this a bug?
> 
> (for context, we have Firebird databases here that have inherited a 
> regular backup/restore cycle from when we were using InterBase 5 or 6… 
> apparently they had a tendency to slow down if not refreshed this way, 
> but that is from before my time!)
> 
> Here's a demonstration using Firebird 3.0.5:
> 
> _1. Create database with mapping_
> 
> PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe
> 
> Use CONNECT or CREATE DATABASE to specify a database
> 
> SQL> create role foo;
> 
> SQL> create mapping sjd_foo using plugin win_sspi from user 
> "foodstuff\pgmrsd1" to role foo;
> 
> SQL> exit;
> 
> _2. Check mapping___
> 
> PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe 
> C:\temp\mapping-backup-restore\FOO.FDB
> 
> Database: C:\temp\mapping-backup-restore\FOO.FDB, User: PGMRSD1
> 
> SQL> show users;
> 
> Users in the database
> 
>    1 #PGMRSD1
> 
> SQL> show roles;
> 
>     FOO
> 
> SQL> show mapping;
> 
> SJD_FOO USING PLUGIN WIN_SSPI FROM USER foodstuff\pgmrsd1 TO ROLE FOO
> 
> *** Global mapping ***
> 
> TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER TO USER
> 
> SQL> exit;
> 
> _3. Back up database – verbose output shows mapping saved___
> 
> PS C:\Users\PGMRSD1> c:\apps\firebird\gbak.exe -v -stat tdrw -b 
> C:\temp\mapping-backup-restore\FOO.FDB 
> C:\temp\mapping-backup-restore\FOO.FDB.bak
> 
> gbak: time delta  reads  writes
> 
> gbak:    0.104  0.104 40  0 readied database 
> C:\temp\mapping-backup-restore\FOO.FDB for backup
> 
> gbak:    0.107  0.002  0  0 creating file 
> C:\temp\mapping-backup-restore\FOO.FDB.bak
> 
> gbak:    0.112  0.004  0  0 starting transaction
> 
> gbak:    0.115  0.003 21  1 database 
> C:\temp\mapping-backup-restore\FOO.FDB has a page size of 8192 bytes.
> 
> gbak:    0.118  0.003  0  0 writing domains
> 
> gbak:    0.122  0.003  6  0 writing shadow files
> 
> gbak:    0.123  0.001  0  0 writing character sets
> 
> gbak:    0.125  0.001  0  0 writing collations
> 
> gbak:    0.127  0.001  1  0 writing tables
> 
> gbak:    0.128  0.001  0  0 writing types
> 
> gbak:    0.131  0.002  5  0 writing filters
> 
> gbak:    0.132  0.001  2  0 writing id generators
> 
> gbak:    0.134  0.001  3  0 writing exceptions
> 
> gbak:    0.135  0.001  2  0 writing functions
> 
> gbak:    0.137  0.001  2  0 writing stored procedures
> 
> gbak:    0.139  0.002  2  0 writing packages
> 
> gbak:    0.141  0.001  2  0 writing triggers
> 
> gbak:    0.143  0.002  0  0 writing trigger messages
> 
> gbak:    0.145  0.002 12  0 writing security classes
> 
> gbak:    0.148  0.002  2  0 writing table constraints
> 
> gbak:    0.150  0.002  0  0 writing referential constraints
> 
> gbak:    0.152  0.002  1  0 writing check constraints
> 
> gbak:    0.154  0.001  0  0 writing SQL roles
> 
> gbak:    0.155  0.001  0  0 writing SQL role: FOO
> 
> gbak:    0.157  0.002  0  0 writing names mapping
> 
> gbak:    0.159  0.001  3  0 writing map for SJD_FOO
> 
> gbak:    0.199  0.002    104  1 total statistics
> 
> _4. Restore database – verbose output shows mapping preserved___
> 
> PS C:\Users\PGMRSD1> c:\apps\firebird\gbak.exe -v -stat tdrw -c 
> C:\temp\mapping-backup-restore\FOO.FDB.bak 
> C:\temp\mapping-backup-restore\BAR.FDB
> 
> gbak: time delta  reads  writes
> 
> gbak:    0.004  0.004  0  0 opened file 
> C:\temp\mapping-backup-restore\FOO.FDB.bak
> 
> gbak:    0.219  0.214  0  0 transportable backup -- data in XDR 
> format
> 
> gbak:    0.222  0.002  0  0 backup file is compressed
> 
> gbak:    0.224  0.001  0  0 backup version is 10
> 
> gbak:    0.362  0.137  0    666 created database 
> C:\temp\mapping-backup-restore\BAR.FDB, page_size 8192 bytes
> 
> gbak:    0.365  0.003  0  2 started transaction
> 
>

ODP: [firebird-support] Re: is it possible to drop all indexes, except those related to PKand FK?

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Hi

If you join with contraints you have better control.
An personally i prefere easier way, like simple select.
If you really need to delete all instead of PK and FK you should not exclude 
uniques as you ommit custom unique indexes.

SELECT
'DROP INDEX ' || TRIM(I.RDB$INDEX_NAME) || ';', RC.RDB$CONSTRAINT_TYPE
FROM
RDB$INDICES I
LEFT JOIN RDB$RELATION_CONSTRAINTS RC ON RC.RDB$CONSTRAINT_NAME = 
I.RDB$INDEX_NAME
WHERE
I.RDB$SYSTEM_FLAG <> 1
AND RC.RDB$CONSTRAINT_TYPE NOT IN ('PRIMARY KEY', 'FOREIGN KEY') 
–eventually add also ‘UNIQUE’ here if you really need

regards,
Karol Bieniaszewski

[firebird-support] Ubuntu 3.0.5 version

[Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support]]

Mariuz's Ubuntu repository contains version 3.0.5.33100 and was released in
October 2019. The official version on the Firebird website is 3.0.5.33220,
released in January 2020. This is ok in terms of stability, if I want to
use the Ubuntu package?
Thanks

[firebird-support] Re: is it possible to drop all indexes, except those related to PK and FK?

[hamacker sirhamac...@gmail.com [firebird-support]]

response to my self, is it correct?

execute block
  returns (drop_index_name varchar(31), dropped boolean) as
declare variable doit boolean;
declare variable stmt varchar(2048);
begin
  dropped=false; -- test before
  for
select i.rdb$index_name
from rdb$indices i
where
  (i.rdb$system_flag<>1)
  and (i.rdb$unique_flag<>1)
  and (rdb$foreign_key is null) into :drop_index_name do
   begin
 stmt='drop index '||:drop_index_name||';';
 if (dropped) then
   execute statement :stmt;
 suspend;
   end
end


Em qui., 12 de mar. de 2020 às 17:59, hamacker 
escreveu:

>
> Is it possible to drop all indexes, except those related to PK and FK?
>
> I would like to do a test and recreate them by script.
>
>

[firebird-support] is it possible to drop all indexes, except those related to PK and FK?

[hamacker sirhamac...@gmail.com [firebird-support]]

Is it possible to drop all indexes, except those related to PK and FK?

I would like to do a test and recreate them by script.

RE: [firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

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

"The mappings in our database survive one cycle of this but disappear on the 
second cycle (tested using gbak from Firebird 3.0.5). 
Changing the backup procedure only hides this issue (if you actually have to 
restore a backup then you're halfway there…)"Go to the Firebird bug tacker and 
create ticket there with description and 
sample.tracker.firebirdsql.orgRegards,Karol Bieniaszewski
null

[firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

[FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]]

Haha, no problem, glad I could help :)

I have noticed a couple of gotchas to watch out for with this feature though…

You can have different groups/users mapped to different roles, but if a user 
matches multiple mappings the connection will fail:
PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe localhost/3051:inca
Statement failed, SQLSTATE = 08004
Multiple maps found for FOODSTUFF\APP_INCA_SupportINCA
Use CONNECT or CREATE DATABASE to specify a database
SQL>

It seems to me like it would be all too easy to accidentally lock out users 
belonging to multiple groups this way.
Specifying the desired role name when connecting doesn't help.  It also doesn't 
help if one of the mapped roles doesn't exist in the database you're connecting 
to (ie different roles for same user in different dbs).

Also, we have a system here that regularly backs up databases then restores the 
backup to live (I think this was recommended practice way back in the days of 
InterBase 5 or 6).
The mappings in our database survive one cycle of this but disappear on the 
second cycle (tested using gbak from Firebird 3.0.5).
Changing the backup procedure only hides this issue (if you actually have to 
restore a backup then you're halfway there…)

So for now my team is considering these restrictions:

  1.  Only map users, not groups, so as to make mapping conflicts easier to 
avoid.  A convention that sets a unique mapping name for each user could help.
  2.  Make all mappings global, so they are not part of db backups.  The 
security db could be backed up as is rather than using gbak, and it's also 
feasible to store the entire security db setup as an sql script.  Especially 
mappings, which don't contain passwords.


From: firebird-support@yahoogroups.com 
Sent: Wednesday, 11 March 2020 9:05 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] AW: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?


Thank You very very much and sorry for this stupid mistake.
Now it works as expected.

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 6. März 2020 04:46
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] RE: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?



Aha, you've got a typo!

In your create mapping statement (and verified by the output of show mapping), 
you have "WINSSPI" instead of "WIN_SSPI".
I encountered the same issue when I accidentally typed "WIN_SPPI"..
It seems that the plugin name is not validated against those currently 
available (possibly for good reason) and the mapping is happily created and 
then ignored.

Regards
Steve


From: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com> 
mailto:firebird-support@yahoogroups.com>>
Sent: Friday, 6 March 2020 1:38 AM
To: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>
Subject: [firebird-support] AW: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?


I can’t get it to work…

The user “MYDOMAIN\ADMINISTRATOR” is a member of the AD group 
“MYDOMAIN\MY_GROUP”
ROLE_TEST was created using this statement: CREATE ROLE ROLE_TEST;
The mapping was created with the following statement: CREATE MAPPING MY_MAPPING 
USING PLUGIN WinSSPI FROM GROUP "MYDOMAIN\MY_GROUP" TO ROLE ROLE_TEST;

Here is my isql output:



C:\Program Files\Firebird\Firebird_3_0>isql.exe localhost:c:\database\test.fdb
Database: localhost:c:\database\test.fdb, User: MYDOMAIN\ADMINISTRATOR


SQL> show version;
ISQL Version: WI-V3.0.5.33220 Firebird 3.0


SQL> select current_user, current_role from rdb$database;

USER ROLE
=== ===
UNITEL\ADMINISTRATOR NONE


SQL> show mapping;
MY_MAPPING USING PLUGIN WINSSPI FROM GROUP MYDOMAIN\MY_GROUP TO ROLE ROLE_TEST

*** Global mapping ***
TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER TO USER



Any idea?

Von: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com> 
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2020 21:13
An: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>
Betreff: [firebird-support] RE: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?



Hi Mathias

I did not have to recreate my database with FB 3.0.5. The before/after example 
was around upgrading the server only, with no database changes.
(my database was created in FB 3.0.4 / ODS 12 with schema/data migrated across 
from an ancient InterBase 7.5.1 db, and is still on sql dialect 1)

Here's another example with more detail including the mapping statements as 
requested.

Role (pre-existing):
create role inca;

Mappings:
create global mapping trusted_auth using plugin win_sspi from any user to user;
cr

Re: [firebird-support] Re: Cannot delete Firebird database file as it is in use by the application..

[Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]]

Thank you very much for all your replies.

I will try the "Clear Pools" option with the Firebird ADO.NET provider first.

If that doesn't work, I have come up with the idea to start a small, external 
process that will check for the release of the file by the application and then 
delete it...

Thank you again...  

Steve Naidamast
  Sr. Software Engineer
  blackfalconsoftw...@outlook.com

[firebird-support] Cannot delete Firebird database file as it is in use by the application..

[Elmar Haneke el...@haneke.de [firebird-support]]

> As a result, I have no idea why the Firebird FDB database file is
> still being used by the master application.
>
> Does anyone have any ideas as to how I can get around this so I can
> complete the delete process?


If all connections are properly closed you should be able to drop
database using firebird API, this should be possible even if deleting by
direct filesystem delete is not possible.


Elmar







++

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] Re: Cannot delete Firebird database file as it is in use by the application..

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

On 2020-03-10 22:04, Steve Naidamast blackfalconsoftw...@outlook.com 
[firebird-support] wrote:
> Hello...
> 
>  I am developing a security extension, which is used as a loaded
> assembly to my main application, all of which use the Firebird
> Embedded Edition 2.59 for my application's database.
> 
>  As part of my security processes, I compress the file upon exiting
> the application.  When the compression process is completed, I want to
> delete the Firebird FDB database file.  However, I cannot do this as
> the Firebird database file is in use by the application.
> 
>  I have checked all of my data access coding and in every case the
> associated database connection is being properly closed upon
> completion of any database access method.
> 
>  As a result, I have no idea why the Firebird FDB database file is
> still being used by the master application.
> 
>  Does anyone have any ideas as to how I can get around this so I can
> complete the delete process?

IIRC, you are programming in C#, right? The Firebird ADO.net provider 
uses a connection pool, so although the logical connection used by your 
application maybe closed, the physical connection is still open. You can 
close unused connections in the pool using FbConnection.ClearAllPools() 
(or alternatively, use the connection property to not pool the 
connections).

Mark

Re: [firebird-support] Firebird client connection timeout

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

On 2020-03-10 20:14, Andrei Luís compuvale.softw...@gmail.com 
[firebird-support] wrote:
> Hummm, I think Dimitry is right. I made some tests here on client
> side:
> 
> server IP:   10.0.2.2
> path: d:\database.fdb
> 
> Using connection string: 10.0.2.2:d:\database.fdb  Correct IP and
> correct path, the connect is made instantly
> 
> Using connection string: 10..0.2.2:d:\data.fdb  Correct IP and wrong
> path, instantly my application recognizes the error, and a error
> message appears.
> 
>  Using connection string: 10.0.2.21:d:\database.fdb Wrong  IP and
> correct path, the application freezes for about 45 seconds, and just
> after that the error message appears.
> 
> So, even though this is not a Firebird issue, do anyone has a tip to
> solve this delay on windows? Should it be set on the server or on the
> clients?
> 
> Thanks in advance.

Maybe this can help: 
https://serverfault.com/questions/193160/which-is-the-default-tcp-connect-timeout-in-windows

Mark

AW: [firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

['Mathias Pannier (unitel)' pann...@ubsysteme.de [firebird-support]]

> Though it might be helpful if a warning was issued when specifying an unknown 
> plugin name.

This would be a nice feature. A check if the domain/group was correct is also 
desirable.

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 6. März 2020 10:24
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] RE: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?



On 2020-03-06 04:46, FSPAPA INCA Team 
i...@foodstuffs-si.co.nz<mailto:i...@foodstuffs-si.co.nz>
[firebird-support] wrote:
> Aha, you've got a typo!
>
> In your create mapping statement (and verified by the output of show
> mapping), you have "WINSSPI" instead of "WIN_SSPI".
> I encountered the same issue when I accidentally typed "WIN_SPPI".
> It seems that the plugin name is not validated against those currently
> available (possibly for good reason) and the mapping is happily
> created and then ignored.

Good find! I assume plugin names are not validated because available
plugins depend on configuration and available plugins on connect time,
and for example global mappings don't necessarily know which actual
plugins are available when connecting to a specific database. Though it
might be helpful if a warning was issued when specifying an unknown
plugin name.

Mark

ub.unitel GmbH, Schulstraße 16, 06792 Sandersdorf-Brehna
Geschaeftsfuehrung Klaus Richter, Olaf Meyer
Amtsgericht Stendal
HRB 26389 FA Bitterfeld Steuernr. 116/107/08597 Ust.identNr. DE815796778
Deutsche Bank IBAN DE53 86070024 0 6143234 00
Kreissparkasse Anhalt-Bitterfeld IBAN DE69 80053722 0 3050326 82
_
Dieses E-Mail ist nur für den Empfänger bestimmt, an den es gerichtet
ist und kann vertrauliches bzw. unter das Berufsgeheimnis fallendes
Material enthalten. Jegliche darin enthaltene Ansicht oder Meinungs-
äußerung ist die des Autors und stellt nicht notwendigerweise die
Ansicht oder Meinung von ub.unitel GmbH dar.
Sind Sie nicht der Empfänger, so haben Sie diese E-Mail irrtümlich
erhalten und jegliche Verwendung, Veröffentlichung, Weiterleitung,
Abschrift oder jeglicher Druck dieser E-Mail ist strengstens untersagt.
_

[firebird-support] AW: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

['Mathias Pannier (unitel)' pann...@ubsysteme.de [firebird-support]]

Thank You very very much and sorry for this stupid mistake.
Now it works as expected.

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 6. März 2020 04:46
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] RE: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?



Aha, you've got a typo!

In your create mapping statement (and verified by the output of show mapping), 
you have "WINSSPI" instead of "WIN_SSPI".
I encountered the same issue when I accidentally typed "WIN_SPPI"..
It seems that the plugin name is not validated against those currently 
available (possibly for good reason) and the mapping is happily created and 
then ignored.

Regards
Steve


From: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com> 
mailto:firebird-support@yahoogroups.com>>
Sent: Friday, 6 March 2020 1:38 AM
To: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>
Subject: [firebird-support] AW: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?


I can’t get it to work…

The user “MYDOMAIN\ADMINISTRATOR” is a member of the AD group 
“MYDOMAIN\MY_GROUP”
ROLE_TEST was created using this statement: CREATE ROLE ROLE_TEST;
The mapping was created with the following statement: CREATE MAPPING MY_MAPPING 
USING PLUGIN WinSSPI FROM GROUP "MYDOMAIN\MY_GROUP" TO ROLE ROLE_TEST;

Here is my isql output:



C:\Program Files\Firebird\Firebird_3_0>isql.exe localhost:c:\database\test.fdb
Database: localhost:c:\database\test.fdb, User: MYDOMAIN\ADMINISTRATOR


SQL> show version;
ISQL Version: WI-V3.0.5.33220 Firebird 3.0


SQL> select current_user, current_role from rdb$database;

USER ROLE
=== ===
UNITEL\ADMINISTRATOR NONE


SQL> show mapping;
MY_MAPPING USING PLUGIN WINSSPI FROM GROUP MYDOMAIN\MY_GROUP TO ROLE ROLE_TEST

*** Global mapping ***
TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER TO USER



Any idea?

Von: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com> 
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2020 21:13
An: firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>
Betreff: [firebird-support] RE: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?



Hi Mathias

I did not have to recreate my database with FB 3.0.5. The before/after example 
was around upgrading the server only, with no database changes.
(my database was created in FB 3.0.4 / ODS 12 with schema/data migrated across 
from an ancient InterBase 7.5.1 db, and is still on sql dialect 1)

Here's another example with more detail including the mapping statements as 
requested.

Role (pre-existing):
create role inca;

Mappings:
create global mapping trusted_auth using plugin win_sspi from any user to user;
create mapping inca_inca using plugin win_sspi from group 
"foodstuff\APP_INCA_SupportINCA" to role inca;

Connection (note that the role is not specified, I'm not sure if it's specified 
but in practice it seems that if a role is available it will be used):
PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe localhost/3051:inca
Database: localhost/3051:inca, User: FOODSTUFF\PGMRSD1, Role: INCA

SQL> show mapping;
INCA_INCA USING PLUGIN WIN_SSPI FROM GROUP foodstuff\APP_INCA_SupportINCA TO 
ROLE INCA
*** Global mapping ***
TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER TO USER

SQL> select current_user, current_role from rdb$database;
USER ROLE
======= ===
FOODSTUFF\PGMRSD1 INCA

SQL>

Regards
Steve

From: 
firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com%3cmailto:firebird-support@yahoogroups.com>>
 
mailto:firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com%3cmailto:firebird-support@yahoogroups.com>>>
Sent: Tuesday, 3 March 2020 7:52 PM
To: 
firebird-support@yahoogroups.com<mailto:firebird-supp...@yahoogroups..com<mailto:firebird-support@yahoogroups.com%3cmailto:firebird-supp...@yahoogroups..com>>
Subject: [firebird-support] AW: How can I use/map Active Directory Groups 
within my Firebird in Trusted Authentication mode?


Thank you.

Perhaps I have to recreate the Database with FB 3.0.5?

Can You show me Your Create Mapping Statement?
Does You access your database with Your Windows Account AND the Firebird ROLE?

Regards
Mathias

Von: 
firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com%3cmailto:firebird-support@yahoogroups.com>>
 [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2020 03:42
An: 
firebird-support@yahoogroups.com<mailto:firebird-supp