Re: [firebird-support] Re: Firebird SS in Mac OS X 10.7 (Lion)

[Paul Beach]

>

Actually thats incorrect. The builds for Firebird 2.1.4 SS have been rebuilt 
and 
re-released on SF to fix this problem. If you check the dates you will find 
that the 
SS builds are now dated August 26, 2011. 

You do not have to use 2.5... you just need to download the latest version of 
the
installable package.

Check the download links here.

http://www.ibphoenix.com/download/firebird/21
http://www.firebirdsql.org/en/firebird-2-1-4/


Paul

RE: [firebird-support] firebird 2.5.1 on Lion Server 10.7.2

[Paul Beach]

> Hi all,
>
> I am trying to run Firebird on a Mac. (OSX Lion Server 10.27.2, Filebird 
> 2.5.1). Actually, I tried CS and SS and both of
> them behave unstable. The server can run for awhile (several hours) before 
> crash. Interesting thing is that after the
> first crash the server does not work. 
>
> Does anybody knows how to make the thing work?

This is a pretty unhelpful posting. Define crash? What happens? What are you 
doing? Is there any info
via the CrashReporter... Did you have any earlier version of Firebird installed 
before installing
2.5.1? How did you remove it or did you upgrade in place?

Paul

[firebird-support] Re: Help, tunning database

[Paul Beach]

> Today, I faced same problem again, which is Firebird server became not
> responsive.
>
> Here are the latest settings :
> - win 7 64 bit
> - Firebirds 2.5.1 super server
> - page size 8192
> - page buffer 8192
> - no long transactions
> - temp cache limit set to 128MB
> - there are a few numbers errors in insert operations but all already 
> rollback.

<>

http://dyemanov.blogspot.fr/2012/03/firebird-vs-windows-file-system-caching.html

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

Fixed Firebird 2.5.2

Paul

[firebird-support] How To Build on OS X : Firebird Framework not found on Mavericks ?

[Paul Beach]

>

The -framework switch above is telling the linker to search for the firebird 
framework, which would normally be installed in
/Library/Frameworks...
Has he installed a copy of Firebird for MacOSX?

Paul

[firebird-support] Embedded on MacosX

[Paul Beach]

<>

by trying to pass -EMBEDDED to the compile line - No guarentees it will compile 
though.

Paul

[firebird-support] Re: [Mac][mavericks] build firebird server through macports?

[Paul Beach]

Marius,

> Here is the full name of the option --with-system-icu

Thats not the problem 

Regards
Paul 

[firebird-support] Firebird slowdowns while resources are available

[Paul Beach]

<<- fb_lock_print displays the following about the database:

LOCK_HEADER BLOCK
Version: 145, Active owner:  0, Length: 2097152, Used: 1335440
Flags: 0x0001
Enqs: 9993237, Converts:  93191, Rejects: 1417230, Blocks:  2
Deadlock scans:  0, Deadlocks:  0, Scan interval:  10
Acquires: 19972846, Acquire blocks:  0, Spin count:   0
Mutex wait: 0.0%
Hash slots: 1009, Hash lengths (min/avg/max):0/   2/   7
Remove node:  0, Insert queue:  0, Insert prior:  0
Owners (38):forward:  20824, backward: 872088
Free owners (126):  forward: 973360, backward: 728016
Free locks (370):   forward: 852200, backward: 195936
Free requests (12425):  forward: 614608, backward: 1230536
Lock Ordering: Enabled

Here I noted that the "rejects" field accounts for ~14% of "enqs"
field but unfortunately I don't know the exact meaning of these
values. I guess about 14% of the lock requests are rejected for some
reason but I might be completely wrong.

So the questions:

- How should the output of fb_lock_print interpreted in this case? Are
these numbers "wrong" in some sense? Can they be improved by some
parameter tuning?>>

Rejects = Lock requests that cannot be satisfied no big deal
No wait locks? Engine locks? I wouldn't worry about it.

Looking at your Lock Header - it looks fine. Your problem is elsewhere. 

Paul Beach
IBPhoenix

[firebird-support] Transaction statistics issue

[Paul Beach]

<>

No its a bug
http://tracker.firebirdsql.org/browse/CORE-3978

Regards
Paul

[firebird-support] firebird-support@yahoogroups.com

[Paul Beach]

Bryan,



http://www.ibphoenix.com/resources/documents/search/doc_26

Paul Beach
IBPhoenix

[firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

Bernd,

>do you have an idea, when the packager will be supported El Capitan or is any 
>other way manually to install firebird?

I am working on it.
The pkg installer is undergoing a complete re-write to comply with Flat Package 
Format.

Regards
Paul 

[firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

How to manually install Firebird on El Capitan, for those who need to know.

http://paulbeachsblog.blogspot.fr/2015/10/how-to-installupgrade-firebird-manually.html

Paul 

AW: [firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

Having identified and fixed a problem in file_params.h and Info.plist, we
now have a working prototype installer via pkgbuild, albeit very alpha, but 
its installing and working OK for me on El Capitan.

Hopefully I should have something constructive early next week.

Regards
Paul 

AW: [firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

And are now available for download.
http://sourceforge.net/projects/firebird/files/firebird-MacOS-X_darwin/2.5.4-Release/

Regards
Paul 

[firebird-support] Problem Firebird 2.5

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>


Usually caused (AFAIK) by a restore done with Firebird 2.1 or an earlier gbak, 
or if a Firebird 2.5 backup was
restored to Firebird 2.1, backed up and then restored on Firebird 2.5

On the original database you can do

DROP ROLE RDB$ADMIN;
COMMIT;

When you restore, gbak.exe should recreate the RDB$ADMIN role.

Paul

RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

"The clause can take an optional OF  to target updates
at specific cursor columns"

The Firebird Book Vol 2 p220

Regards
Paul

RE: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa

['Paul Beach' pabe...@waitrose.com [firebird-support]]

> The problem there would be that the BDE has reached its end of life for
> some years now.

The BDE was put on death row when IBX was made available, the same time 
Interbase 6.0 became available and Firebird
was open sourced. Some 16 years ago...

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

[firebird-support] Encryption on FB3

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<<2) Use the new FB 3 encrytion, we do not have any idea how to, is there any 
document we can read to start testing?>>

IBPhoenix have a working plugin thats available for use.
http://www.ibphoenix.com/products/software/encryptionplugin

Regards
Paul 

Re: [firebird-support] Number of concurrent user connections

['Paul Beach' pabe...@waitrose.com [firebird-support]]

>1024.

<>

Being pedantic - 2.5.3+ and 3.0+ http://tracker.firebirdsql.org/browse/CORE-4439
The limit applies to Windows... SS & SC. But not Classic.
This limit could be increased if needed. Its not a hard limit 

https://msdn.microsoft.com/en-us/library/windows/desktop/ms739169%28v=vs.85%29.aspx

Paul

RE: [firebird-support] On Connect triggers are dangerous, aren't they?

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

gbak -nodbtriggers - Suppresses Database Triggers from running [Firebird 2.1]

Regards
Paul Beach

Re: [firebird-support] Help: firebird and apache Processes doesn't die

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

SuperServer wil hold cached data as long as any connections exist. Only when 
the last "real" user disconnects
from the database will the cache be cleared.

Which two users are still connected to the database? CACHE WRITER and GARBAGE 
COLLECTOR?
If so then these should also finish with the last user connection.

Paul

Re: [firebird-support] Help: firebird and apache Processes doesn't die

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

The pseudo table MON$ATTACHMENTS will tell you.

Regards
Paul 

[firebird-support] Re: FB3 - Limbo and consistency check

['Paul Beach' pabe...@waitrose.com [firebird-support]]

>  Do you have reproducible example ? Could you send it to me (or regiser at 
> tracker), please ?

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

Regards
Paul 

[firebird-support] Potential Causes for Query to Slow Down

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

Garbage collection usually.

Regards
Paul Beach

RE: [firebird-support] RE: Firebird SuperClassic hangs

['Paul Beach' pabe...@waitrose.com [firebird-support]]

> Deadlock scans:289, Deadlocks:  1, Scan interval:  10

Is probably the culprit, 289 deadlock scans, one actual deadlock found

"Deadlock scans. The number of times that the lock manager walked a chain of 
locks and owners looking for deadlocks. The lock manager initiates a deadlock 
scan 
when a process has been waiting 10 seconds for a lock."

"Deadlocks.  The number of actual deadlocks found, A deadlock occurs when 
Process A, wants a lock on Resource 1 which is held in an incompatible mode 
by Process B and Process B wants a lock on some Resource 2 which is held in an 
incompatible mode by Process A.

"Each owner stands around glowering at the other and neither will do anything 
to improve the situation, so the lock manager returns a fatal error to one or 
the 
other. Deadlocks can also occur with a single resource if both owners start 
with 
read locks and request conversions to write locks. However, deadlocks always 
involve two owners (or two separate transactions)

Errors that are returned as "lock conflict" from "no wait" lock requests will 
not 
be recorded in the lock table as deadlocks because only one owner is waiting.

Errors returned as "deadlock" with a secondary message specifying "update 
conflicts 
with concurrent update" are not actual deadlocks either. What has happened in 
those 
cases is that one owner has modified (or erased) a record and moved on. Another 
concurrent owner has attempted to modify (or erase) the same record, noticed 
that the 
most recent version is one he can't see waited to find out how the other 
transaction 
ends up, and found to his disappointment, that the other transaction succeeded. 
In that case, our patient transaction can't modify the record because it can't 
find 
out what its late contemporary actually did."

"Scan interval.  The lock manager waits some period of time after a request 
starts 
waiting before it starts a deadlock scan.  The default interval is 10 seconds, 
which may be 
long considering the change in CPU performance since 1983. Deadlock scans 
should not be done 
whenever there's a wait because waiting is normal and scans are not free."

A deadlock scan would cause your server to hiccup while the lock manager tries 
to
find if there is a real deadlock within the lock manager. You might want to 
investigate 
why deadlock scans are being instigated..

With thanks to Ann Harrison :-)

Regards
Paul Beach

AW: [firebird-support] RE: Firebird SuperClassic hangs

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

Thats what a lock print is for - when it "hangs the next time" get a lock print
fb_lock_print -a -d database > lock.txt
Once you have it - you can analyse it.

https://www.ibphoenix.com/resources/documents/how_to/doc_402
http://www.ibphoenix.com/files/conf2011/Lock-Print-Yemanov-2011.pdf

Regards
Paul

RE: [firebird-support] Ask : firebird 1.5 to firebird 2.5

['Paul Beach' pabe...@waitrose.com [firebird-support]]

> If our software running on firebird 1.5 and now going to move over to
> firebird 2.5,
> technical-wise, what are the points we can convince people to change over?
> Can you kindly advise?

Have you tried reading the release notes?
https://www.firebirdsql.org/en/release-notes/

Regards
Paul

[firebird-support] internal firebird consistency check

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<<1. I got following error reported Firebird-3.0.2.32703_0_Win32 :
"internal firebird consistency check (cannot find record back version (291), 
file: vio.cpp line: 4676)">>

Try a gbak using something like the following
gbak -b -v -i -g copy1.fdb{path}copy1a.fbk
using the –g switch to signify "no garbage collection"

If this succeeds then you can restore the database without the corrupt record 
pointer.

Paul

[firebird-support] Re: nbackup : Error assessing database due a missing delta file

['Paul Beach' pabe...@waitrose.com [firebird-support]]

The Chequered Career of nBackup
By Helen Borrie

http://www.ibphoenix.com/resources/documents/search/doc_394

Regards
Paul Beach

Re: [firebird-support] permissions nbackup

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<<# ls -lart  /var/lib/firebird/system/security2.fdb
-rw--- 1 firebird firebird 1171456 Aug 14 14:25 
/var/lib/firebird/system/security2.fdb>>

Is this a distro specific install or the more generic Firebird one from 
SourceForge?
I ask, because on MacOS the default security is the following
-rw-r--r--   1 pbeach  staff   729088 Feb 15 16:54 security2.fdb
And on install I do not make any effort to change it.

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

Re: [firebird-support] permissions nbackup

['Paul Beach' pabe...@waitrose.com [firebird-support]]

Apologies, it does get changed, I was looking in the wrong place in the MacOS
installer...

SuperServer chmod 600 security2.fdb
Classic chmod 660 security2.fdb

Regards
Paul 

Re: [firebird-support] permissions nbackup

['Paul Beach' pabe...@waitrose.com [firebird-support]]

The default linux tar install has the following for security2.fdb amongst others

MakeFileFirebirdWritable() {
FileName=$1
chown $RunUser:$RunGroup $FileName

if [ "$RunUser" = "root" ]
# In that case we must open databases, locks, etc. to the world...
# That's a pity, but required if root RunUser choosen.
then
chmod a=rw $FileName
else
# This is good secure setting
chmod ug=rw,o= $FileName
fi

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

RE: [firebird-support] permissions nbackup

['Paul Beach' pabe...@waitrose.com [firebird-support]]

> its the generic one

For whatever linux distribution you are using..., its not
the projects build on SourceForge for example. I suspect some one (who
maintains Firebird for your Linux distro), may have been over zealous with the 
security.
Any user who is part of the group firebird should be able to use firebird in 
embedded
mode.

Regards
Paul


# ls -l /var/lib/firebird/system/security2.fdb
-rw--- 1 firebird firebird 1064960 Aug 14 16:34 
/var/lib/firebird/system/security2.fdb
# rpm -qa | grep fire
firebird-classic-common-2.5.5.26952.0-2.el6.x86_64
firebird-libfbembed-2.5.5.26952.0-2.el6.x86_64
firebird-classic-2.5.5.26952.0-2.el6.x86_64
firebird-libfbclient-2.5.5.26952.0-2.el6.x86_64
firebird-2.5.5.26952.0-2.el6.x86_64
firebird-filesystem-2.5.5.26952.0-2.el6.x86_64

RE: [firebird-support] file size and transactions

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

<>

Not really, 2 weeks or 2 months would be a huge time.

> I read somewhere that the "read only" transactions are absolutelly harmless 
> to the GC and sweeping. Is that so?

Read only transactions only physically have an impact on the TIP/Header 
page(s), however a long running read only transaction
will have the same effect as a long running read write transaction in that it 
will block GC and sweeps until it
commits.

Paul  

RE: [firebird-support] file size and transactions

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

 
> I read somewhere that the "read only" transactions are absolutelly harmless 
> to the GC and sweeping. Is that so?

>>Read only transactions only physically have an impact on the TIP/Header 
>>page(s), however a long running read only transaction
>>will have the same effect as a long running read write transaction in that it 
>>will block GC and sweeps until it
>>commits.

<>

Karol,

I was referring to the default transaction state of snapshot (repeatable 
read)
Other transaction states will have different effects. In your case
read commited needs only the newest record version (or record versions created 
by 
the transaction itself) so its not going to block anything.

Paul

RE: [firebird-support] Firebird 3 crashes, unable to capture crash dumps ( terminated abnormally (4294967295) )

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

>

Try following these instructions
http://www.ibphoenix.com/resources/documents/search/doc_35
Tracking Down Crashes on Windows Systems

Regards
Paul

RE: [firebird-support] Transaction Management Failing?

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

> > The logic is that straightforward. The InsertMyData inserts lines of an 
> > invoice or any
> > other customer transaction into ledgers, each identified by a transaction 
> > number. The
> > problem is that when the issue occurs, multiple copies of the data end up 
> > in the database,
> > which based on the above logic should not be possible.
>
>Not quite so. You don't write down what exception happen in exception 
> handler. If any
> exception happen between CommitTransaction and 'Done := true', you'll get 
> duplicates.
>You haven't described how InsertMyData works. If (by mistake) it uses 
> AutoCommit - the
> window where you logic can blow up is getting wider.
>
> > It’s a really difficult one as it is totally random.
>
>Still you can turn audit on and (even logs will be enormous) find out 
> exact sequence of
> events.

Dimitry is right, I would suggest implementing the trace and audit facility, 
find out when the errror
next occurs and start looking at exactly what is happening as far as the 
database is concerned.

https://firebirdsql.org/rlsnotesh/rnfb25-trace.html

I tracked down a problem on a  known accounting/inventory system using this 
feature, and proved there
was a logic problem within the client software.

Paul







++

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] Embedded FB3 was killed?

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

> >Read carefully "Remodelled Architecture" part.
> 
> As far as I understand that, I just call "fbclient.dll" as usual,
> and if the database path is a local file, "fbclient.dll" automagically
> calls "engine12.dll" (or whatever it needs) for the use as a local/
> embedded server. Correct?
> 
> Which leads my to the question: Which of the 274 files in the 3.0.2
> ZIP are necessary to be copied into the client's application directory
> in order to run the embedded server? (Of course, as few as possible...)

This might help
https://www.lawinegevaar.nl/firebird/jaybird_embedded_example.html
Jaybird with Firebird embedded example and the section Details on embedded use

Regards
Paul






++

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: Re[2]: {Disarmed} [firebird-support] Using FB2.5 with NFS for Virtualbox VM

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

<>

Simply put.

As long as the database on the NFS mount cannot be accessed by another Firebird 
server
on another system then you can use this "feature" (RemoteFileOpenAbility).

Regards
Paul

RE: [firebird-support] Issue with GBAK and upgrading old DB (1.5 -> 3.x)

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

<>

Please read

Upgrading from Firebird 1.5 to 2.5 and beyond (.pdf) (161.31K)
by Pavel Cisar

http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf

It will help...

Regards
Paul

RE: [firebird-support] Firebird database corrupt with wrong page type error on table

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

http://www.ibphoenix.com/resources/documents/how_to/doc_5

Regards
Paul

  -Original Message-
  From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
  Sent: 21 December 2017 13:14
  To: firebird-support@yahoogroups.com
  Subject: [firebird-support] Firebird database corrupt with wrong page type
error on table




  Hello everyone,



  During inserting data to a table I received an error on my application log
"database file appears corrupt (DB Path) wrong page type page 232333 is of
wrong type (expected 5, found 7)".



  On looking in FB log I got following  :



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB

  Data page 232331 (sequence 168514) is confuse d in table
TABLENAME (159)



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB

  Page 232333 wrong type (expected 5 encountered 7)



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB< /p>

  Data page 232333 (sequence 168515) is confused in table
TABLENAME (159)



  DEVMACHINE (Server)  Thu Dec 21 16:45:24 2017

  Database: DB

  Page 232317 is an orphan





  This is the first time I am seeing this error and don't know what has
caused it. Is there any precaution to avoid such kind of errors..?



  This database is around 3 years old and database maintenance activity is
not done on it.  Also, the said table has 5.4 million records in it.





  Thank you in advance J


  

RE: [firebird-support] info

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

Try the following...

Partner index description not found (175))

internal gds software consistency check (partner index description not found. 
Missing index for a primary or a foreign key. The problem may be caused by 
physical database corruption or by a bug.

Recovery process:

To find the missing index, use following SELECT statement:

select R.RDB$CONSTRAINT_NAME, R.RDB$INDEX_NAME as REFINDEXNAME,
   I.RDB$INDEX_NAME as REALINDEX, I.RDB$RELATION_NAME, I.RDB$INDEX_INACTIVE
from RDB$INDICES I RIGHT
JOIN RDB$RELATION_CONSTRAINTS R on I.RDB$INDEX_NAME = R.RDB$INDEX_NAME
where R.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
   or R.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
order by R.RDB$CONSTRAINT_NAME

The contraint that is missing an index (where column REALINDEX is empty) will 
be 
corrupted. Try and recreate this constraint.

Paul

RE: [firebird-support] info

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

> If I try the select, I don’t have any record where realindex is null 

Then I would next check the database for any possible problems... corruption 
etc.

http://www.ibphoenix.com/resources/documents/how_to/doc_5

Regards
Paul

RE: [firebird-support] "Over the wire" Connection Encryption: AES

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

<>

As far as I am aware the only current commercially available plugins for 
Firebird are for encryption.
If your customer is interested in such a plugin, we could probably develop one 
for them.

Regards
Paul

RE: [firebird-support] Restore firebird 1.5 backup into firebird 2.5.8 database with GBAK Fails

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

<>

Hmm, 2.5.8 was compiled on 10.13 with a macosx-version-min of 10.9 using clang 
17.3
However it looks like you have run into this particular issue...

it look s you need to update your OS to at least MacOS Sierra 10.12
As the function clock_gettime was not provided in earlier versions of OSX (El 
Capitain for example),

It looks like Apple have introduced the clock_gettime posix API in MacOSX 10.12
The configure script used to build firebird is detecting this and enable usage 
of it. 
Since you are running on 10.10, this functionality doesn't exist, so the 
linking at runtime fails. 

Depending on how critical this is, it might be possible to create a build of 
Fireird that 
defaults to the previous behaviour (pre 10.12) where configure does not detect 
the function 
_clock_gettime and uses firebirds own methods.


Paul

RE: [firebird-support] Does gstat "max version">1000 indicates about problems?

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

>

Two issues... 
1. Max versions = older versions of a record that will be tidied up by garbage 
collection at an
appropriate time, either by sweep (gfix -s), coperative garbage collection or 
by gbak when a
backup takes place.
Consider using the -g switch during backup to inhibit garbage collection and 
instead run sweeps 
regularly.

2. Errors in the firebird log = probable corruptions to the database...
Please read this.
http://www.ibphoenix.com/resources/documents/search/doc_5

Paul

RE: [firebird-support] Firebird log, error

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

What might be causing this, any ideas?
Server: Firebird 64bit classic on Ubuntu Linux (2.5.4.26856)
Client: Windows 10

After this error, the connection drops & client app hangs. 

Mar 24 15:05:58 kernel: [2481720.238260] fb_inet_server[10098]: segfault at 0 
ip 7f5cba31bb05 sp 7f5cb86d4b90 error 4 in 
libfbembed.so.2.5.6[7f5cba1bf000+4cd000]>>

#define EINTR4  /* Interrupted system call */
You need to capture a coredump on the server and analyse it.
https://www.ibphoenix.com/resources/documents/search/doc_36

regards
Paul

RE: [firebird-support] NVME drive optimize for firebird engine

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

<>

1. I don't understand how RAID 0 gives you redundancy...
"RAID 0 (also known as a stripe set or striped volume) splits ("stripes") data 
evenly across two or more disks, without parity information, redundancy, or 
fault tolerance. Since RAID 0 provides no fault tolerance or redundancy, the 
failure of one drive will cause the entire array to fail; as a result of having 
data striped across all disks, the failure will result in total data loss"

If you only have 2 disks surely RAID 1 will give you the redundancy you are 
looking for?

Consider the following...

You could buy a couple more disks and Use RAID 10
If you are using RAID1 or RAID5, consider RAID10 – it is 15-25% faster.
Check the BBU. If you are using a RAID controller, check that it has Backup 
Battery Unit (BBU) is 
installed and operational – some vendors do not provide BBU by default. Without 
BBU, 
the controller disables the cache, and RAID can be slow, even slower than usual 
SATA drives. 
Usually, you can check BBU status in the RAID configuration tool.
Set the write cache to write-back
If you are using RAID controller with installed BBU (and server with UPS), 
check that its cache is 
set to write-back (not write-through). «Write-back» enables write cache of the 
controller.
If you use a RAID controller, check that it has enabled the read cache. 

Paul

RE: [firebird-support] GET LINGER?

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

<>

AFAIK, you cannot "view" this setting however you can set it and adjust it 
using the following commands...
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-enhance-linger

Paul

RE: [firebird-support] GET LINGER?

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

Mark,

> You can use select rdb$linger from rdb$database

Neat, I didn't know about that. Thanks.

Paul

RE: [firebird-support] running Firebird without fbintl

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

<>

MacOS does not use a full icu implementation, so I doubt you are linking
against the system icu lib (/usr/lib/libicucore.dylib) unless of course
you are specifically requesting it. 

To be honest I doubt you could build Firebird if you hadn't installed 
a proper copy of icu from elsewhere.

Personally I expect the problem is elsewhere... 
Does it crash on 10.13 or on earlier versions of the OS?
Have you analysed a crash dump?
What happens if you use isql on your embedded version of Firebird?
What version of Firebird are you using?

Paul 

RE: [firebird-support] running Firebird without fbintl

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

And a couple of final questions, what optimisation level are you using during 
the build?
32bit or 64bit Firebird?

Paul

-Original Message-
From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com]
Sent: 05 July 2018 14:47
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] running Firebird without fbintl


  

<>

MacOS does not use a full icu implementation, so I doubt you are linking
against the system icu lib (/usr/lib/libicucore.dylib) unless of course
you are specifically requesting it. 

To be honest I doubt you could build Firebird if you hadn't installed 
a proper copy of icu from elsewhere.

Personally I expect the problem is elsewhere... 
Does it crash on 10.13 or on earlier versions of the OS?
Have you analysed a crash dump?
What happens if you use isql on your embedded version of Firebird?
What version of Firebird are you using?

Paul 

RE: [firebird-support] running Firebird without fbintl

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

<>

2.5.8 64bit Firebird now compiles with -O0 because of a problem with 
optimisation in fbintl that caused
Firebird to crash...

Paul

RE: [firebird-support] running Firebird without fbintl

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

>With GCC "-fvisibility=internal" can be used to suppress exporting of all 
> symbols.

We currently use -fvisibility-inlines-hidden and -fvisibility=hidden for 
clang...

Paul




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






++

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: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files

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

<< it may be worth considering and adjunct piece of software to Firebird, 
called "HqBird", which uses Firebird as its base database engine.  "HqBird" was 
designed for Firebird databases that are by necessity very large and require 
more power and capabilities than the standard version may offer.  A similar 
situation has arisen with the equally powerful PostgreSQL database engine where 
when extensive power is required, the EnterpriseDB database engine has been 
developed using PostgreSQL as a base.  EnterpriseDB can now provide Oracle-like 
capabilities at a fraction of the cost>>

Nice analogy, but not entirely accurate...

Paul

RE: [firebird-support] Re: Mailing list change?

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

> In principal I like your idea of a Firebird powered archive of Firebird 
> related emails.

http://www.ibphoenix.com/products/dvd/developer_dvd
"A browsable, search application for Windows and Linux for the whole of the 
Firebird Support and Developer Lists to date"

Regards
Paul

RE: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

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

<>

You can add your user to the firebird group (without using an 
ip address or local host you are effectively using firebird in local mode).
Addin your user to the firebird group means that you can access the tmp files
created when firebird starts up.

Or you can rm /tmp/firebird and then access firebird locally via your user
all the time. The new tmp files will be owned by you. Access remotely will be
a problem though.

Or use an ip address or localhost to create the database.

Paul

RE: [firebird-support] Re: Cannot create new database: "Can not access lock files directory /tmp/firebird/"

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

>

Or ifyou are seriously interested in Firebird 
http://www.ibphoenix.com/products/books/firebird_book

Paul

RE: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

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

> < command followed by the path and filename, hitting Enter and then typing in 
> my username and password (the only user is sysdba and I did change the 
> password) I get the following error message:
> Statement failed, SQLSTATE = 08006
> Can not access lock files directory /tmp/firebird/>>
> 
> [...]

It all depends on the path you provide in CREATE DATABASE. If it is just 
a local filesystem path, e.g. CREATE DATABASE "/somefolder/dbname.fdb", 
then the FB instance handling your request is running with your current 
user account (somewhat like embedded FB).
So, try what the rest of the error message suggests and do:
CREATE DATABASE "localhost:/somefolder/dbname.fdb" USER "SYSDBA" 
PASSWORD "yourpassword";
This way you access the FB server via the network stack and the request 
gets handled by the FB inet server, running with "firebird" account 
priviledges.

What I said, but better. Make sure somefolder has the privileges to allow
another user (firebird) to write to it and access it.

Regards
Paul

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

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

Et al,

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

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

Regards
Paul

RE: [firebird-support] Create sysdba user

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

> I there an easy way to create another user with same privileges and can 
> access all tables as SYSDBA?

https://firebirdsql.org/rlsnotesh/rnfb25-admin.html

Paul

RE: [firebird-support] INET/inet_error: read errno = 10054

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

> Does anybody know what causes this message in firebird.log?

INET/inet_error: read errno = 10054

Winsock.h

WSAECONNRESET 10054 Connection reset by peer.

An existing connection was forcibly closed by the remote host. This normally 
results if the peer application on the remote host is
suddenly stopped, the host is rebooted, the host or remote network interface is 
disabled, or the remote host uses a hard close (see
setsockopt for more information on the SO_LINGER option on the remote socket).

This error may also result if a connection was broken due to keep-alive 
activity detecting a failure while one or more operations
are in progress. Operations that were in progress fail with WSAENETRESET. 
Subsequent operations fail with WSAECONNRESET.

This happens if a sockets client is actively sending or receiving data to or 
from a Firebird Server, and the network connection is
lost. If a client crashes or a network error occurs (for example, an 
intermediate router goes down), the server has no way of
knowing this, unless it tries to use send(). In this case send fails with the 
WSAECONNRESET error.

How does an application know that the remote end has terminated the connection? 
The answer depends on whether the remote end
terminated the connection gracefully or abortively. If the termination was 
abortive, then send() and recv() calls will fail with the
error WSAECONNRESET.
So, in simpler terms the socket that is the end point of the other connection 
has gone. Either the Firebird server has crashed, or
the application using the Firebird client has disconnected abnormally (the 
application may also have crashed). You need to make a
new connection, as the existing connection(s) can no longer be used. If these 
are infrequent, there is probably nothing to worry
about, a client may have rebooted their system, or has been turned off without 
disconnecting from the database server. However if
they are frequent, then you need to look at what may be causing the 
disconnections, either in the application or on the network.

Regards
Paul

RE: [firebird-support] WireCrypt and win_sspi

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

<>

More info here: https://www.ibphoenix.com/files/Authentication_FB3.pdf

Paul

RE: [firebird-support] Re: WireCrypt and win_sspi

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

Daniel,

>><>is only possible for >>ServerAuth=SRP. Is this correnct? Or is there any kind 
>>of configuration to use WireCrypt with >>ServerAuth=win_sspi?>>

>More info here: https://www.ibphoenix.com/files/Authentication_FB3.pdf

<>

Yes, my reading of 

"Wirecrypt, which sets encryption across the wire. In the default installation 
it is set
as Required on the server side and Enabled on the V.3 client side. If you expect
applications to connect using the V.2 client, or the V.3 client with win_sspi, 
then it
should be downgraded to Enabled in the conf file on the server. The default on 
the
client side is Enabled, which is OK, so there is no need to reconfigure it 
there."

Also suggests that your conclusion is correct. 

Thats why I suggested reading the document. At the moment its the gospel on 
authentication in Firebird 3, cross checking on this to make sure I get..

a definitive WireCrypt with win_sspi-Authentification is not possible
Where Required = yes, enabled = no, and disabled = no
and if you do use win_sspi required will mean a failed connection

Regards
Paul

RE: [firebird-support] Apparently timeout on queries

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

> I would like to know if the Firebird have any kind of timeout on query 
> execution.

Firebird 4.0

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

Paul

RE: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

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

<>

http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf

Regards
Paul

RE: [firebird-support] Re: installing fb 1.5 in Mac Mojave

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

Did you actually use the original install script as instructed on the blog,
or did you just try and use launchctl?

Regards
Paul

RE: [firebird-support] Re: installing fb 1.5 in Mac Mojave

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

> yes, I follow the one in the blog and run the postinstall script under root 
> account

Then it should work OK... I am not aware of any major changes re. dscl, 
launchctl etc
that should stop it from working.

Paul

RE: [firebird-support] Transactions

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

Kevin,

You might want to read this...
https://www.ibphoenix.com/resources/documents/search/doc_67

Regards
Paul


-Original Message-
From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com]
Sent: 03 April 2019 06:37
To: Firebird Support
Subject: [firebird-support] Transactions


  
Greetings,

I’m sure this has been asked before - is there a knowledge base somewhere?

I’m trying to get a handle on transactions from gstat and I just want to make 
sure I’m reading this correctly. One of my installs is having some issues, 
Firebird 1.56, Classic Server. I have been reading Helen’s book, Chapter 25 - 
Overview of Transactions.

My app (a large one) is written in Delphi, using Devart’s IBDAC components.

Also, my end users tend to End Task on my app if a report doesn’t pop up 
immediately. I’ve tried to educate them. So with Classic (or Superserver I’m 
guessing) when the user kills a client app, I’m assuming it leaves not only a 
connection to the database active (as seen in Task Manager on the server) but 
also potentially one or more transactions active.

It appears from the book that I should be concerned with the gap between the 
OIT and the OAT and making sure they both move ahead. So from the gstat figures 
below, my app needs a bunch of improvements in transaction handling which I’m 
diving into as we speak.

4/1/2019 - before backup / restore
Oldest transaction 1388 (OIT)
Oldest active 812976 (OAT)
Oldest snapshot 811580
Next transaction 905141
Note: Performance was horrible on this day and usually is the first day of the 
month.

4/1/2109 - after backup / restore:
Oldest transaction 1294
Oldest active 1295
Oldest snapshot 1295
Next transaction 1298
Note: This looks perfect to me.

4/2/2019 - around mid-day:
Oldest transaction 1297
Oldest active 1298
Oldest snapshot 1295
Next transaction 56071
Note: Not good. OIT and OAT not moving forward.

4/2/2019 - around end of day:
Oldest transaction 1297
Oldest active 1298
Oldest snapshot 1295
Next transaction 91583
Note: Even worse. OIT and OAT not moving forward.

4/2/2019 - after backup and sweep:
Oldest transaction 1626
Oldest active 91623
Oldest snapshot 91623
Next transaction 91631
Question: I would’ve thought performing a sweep would’ve not only done garbage 
collection but also dealt with rolled-back transactions and remove “stumps” of 
deleted records (from the book) increasing the OIT.

4/2/2019 - after a 2nd sweep:
Oldest transaction 91631
Oldest active 91623
Oldest snapshot 91623
Next transaction 91632
Note: Now this is interesting. This looks pretty perfect to me. 
Questions: Why didn’t the first sweep give me this kind of result? And should I 
schedule two sweeps every night? 

Thanks in advance for any help here!

Best Regards,
Kevin

Some more background:

Batch file that does backup / sweep every night:

del "e:\fb databases\lumber\lumber_bu.log"
gbak -b -user SYSDBA -password masterkey "127.0.0.1:e:\fb 
databases\lumber\lumber.fdb" "e:\fb databases\lumber\lumber.fbk" -v -y "e:\fb 
databases\lumber\lumber_bu.log"
gfix -sweep -user sysdba -password masterkey "127.0.0.1:e:\fb 
databases\lumber\lumber.fdb"

Sweep batch file I run interactively:
e:
cd "e:\program files (x86)\firebird15\bin\"
gfix -sweep -user sysdba -password masterkey "127.0.0.1:e:\fb 
databases\lumber\lumber.fdb"
pause

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

RE: [firebird-support] Compling from source.

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

<<(phew...), but that's where the fun begins - I hit an error!


/usr/bin/ld: //usr/local/lib/libtommath.a(bn_mp_read_radix.o): relocation 
R_X86_64_32S against symbol `mp_s_rmap_reverse' can not be used when making a 
shared object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod.o): relocation 
R_X86_64_32 against symbol `mp_reduce' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod_fast.o): relocation 
R_X86_64_32 against symbol `mp_reduce_2k' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: final link failed: nonrepresentable section on output
collect2: error: ld returned 1 exit status
make[3]: *** [Makefile:305: 
/home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib/libfbclient.so.3.0.4] 
Error 1
make[3]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make[2]: *** [Makefile:180: master_process] Error 2
make[2]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make[1]: *** [Makefile:66: firebird] Error 2
make[1]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make: *** [Makefile:6: firebird] Error 2
[pol@UNKNOWN fb]$>>

at a guess it looks like the libtommath you installed wasn't build with =fPIC 
a must if you want to include its symbols in another shared library (Firebird)

Perhaps it would be easier if you used the configure command 
--with-builtin-libtommath?

Regards
Paul

RE: [firebird-support] Compling from source.

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

> at a guess it looks like the libtommath you installed wasn't build with =fPIC
> a must if you want to include its symbols in another shared library (Firebird)

> Perhaps it would be easier if you used the configure command 
> --with-builtin-libtommath?

<>

if you do a ./configure --help 
you will see that --with-builtin-libtommath "build libtommath library from the 
firebird tree"
This means the libtommath library should be built "within" firebird...
If you look in extern within your firebird code there should be a libtommath 
directory.
That code is used to build the libtommath library which will be linked into the 
firebird
shared library during compilation.

I know this works because there is no installed libtommath library on MacOS and 
I have to build
fireird this way so that firebird is dependent on some randomly installed 3rd 
party libtommath
library.

regards
Paul

RE: [firebird-support] Compling from source.

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

< ./configure --prefix=/home/pol/Downloads/sw/db/fb/inst 
> --with-builtin-libtommath
then
> make
Same failure as before (at bottom).
I totally get your point about it being to do with libtommath, that much is 
obvious from the error messages.
However, I have tried the solution proposed - i.e. using ./configure with the 
--wtih-builtin-libtommath flag.
Now, I need further assistance. This is failing. I am compiling on Fedora 29 
with Development Tools installed.
Where do I need to place, or what do I need to do, with the tommath 
code/library in order for  a simple compile to work?
Any assistance much appreciated. >>

Look very carefully at the error you are getting and you will notice that 
although
you are specifying --with-builtin-libtommath
its actually picking up the non fPIC lib in /usr/local/lib 

---> /usr/bin/ld: //usr/local/lib/libtommath.a
This is being picked up before the builtin one within extern
probably because of your library search paths

The correct library would be extern/libtommath/.libs for libtommath.so not 
libtommath.a
See gen/make.defaults

Paul




== Fails =



/usr/bin/ld: //usr/local/lib/libtommath.a(bn_mp_read_radix.o): relocation 
R_X86_64_32S against symbol `mp_s_rmap_reverse' can not be used when making a 
shared object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod.o): relocation 
R_X86_64_32 against symbol `mp_reduce' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod_fast.o): relocation 
R_X86_64_32 against symbol `mp_reduce_2k' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: final link failed: nonrepresentable section on output
collect2: error: ld returned 1 exit status
make[3]: *** [Makefile:305: 
/home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib/libfbclient.so.3.0.4] 
Error 1
make[3]: Leaving directory '/home/p ol/Downloads/sw/db/fb/gen'
make[2]: *** [Makefile:180: master_process] Error 2
make[2]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make[1]: *** [Makefile:66: firebird] Error 2
make[1]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make: *** [Makefile:6: firebird] Error 2

RE: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

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

<>

Yes, by default we build and install as a Framework on MacOS, which means
as part of the build process we finesse the locations of all the relevant 
libraries and
executables etc using the install_name_tool. If you look at the source code 
specifically 
posix/postfix.darwin, and you will need to do the same for all the 
libs/executables
you wish to use...

There was a script to do this in Firebird 2.x
See posix/builds/install/arch-specific/darwin/embed.darwin

Paul

RE: [firebird-support] Firebird upgrade advise

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

<>

This will help.

https://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf

Regards
Paul

RE: [firebird-support] Basic Re-Start

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

> 30.09.2019 14:27, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> > What the the link for downloading Embedded Firebird?
> 
>None. Read Firebird 3 Release Notes.

Or read this...
https://www.ibphoenix.com/files/Embedded_fb3.pdf

Regards
Paul






++

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] with wrong sql i get no exception or firebird error

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

< INSERT INTO LOG(WAS) VALUES ('blabla');
causes the error:
  Statement failed, SQLSTATE = 23000
  validation error for column "LOG"."ID", value "*** null ***"

if postet with the c++ code:
IBPP::Transaction _tr = IBPP::TransactionFactory(db);
IBPP::Statement st = IBPP::StatementFactory(db, _tr);
_tr->Start();
st->Prepare("INSERT INTO LOG(WAS) VALUES (?)");
st->Set(1, "blabla");
st->Execute();
_tr->Commit();

i get no error...nothing! No Record is created.
In other error cases i get an ibpp message with try catch IBPP::Exception& e  
somethin like.

*** IBPP::LogicException ***
Context: Statement::Set[char*]
Message: The statement does not take parameters.

but never the real firebird error.

How can get this errors?>>

Probably by using 
Class::SQLException

http://www.ibpp.org/reference/exceptions

Paul

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]

RE: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

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

Release Notes

"New ODS Number
Firebird 3.0 creates databases with an ODS (On-Disk Structure) version of 12. 
In the initial release, a database
with an older ODS cannot be opened by Firebird 3.0. In order to work with a 
database with an older ODS it will
be necessary to make a backup using gbak  under the older server and restore it 
with gbak on Firebird 3.
Note
A legacy provider for databases with ODS 8 to 11.2 is planned for a future 
sub-release"

Paul
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 25 June 2020 16:46
To: Firebird Support
Subject: [firebird-support] error when trying to open databases 2.5 on server 
3.0.5



Is it possible to open database 2.5.9 on servers 3.0.5?

when I try to open it with flamerobin it gives me the following error:
Context:Database::Connect
Message:isc_attach_database failed

SQL Message:-820
wrong or obsolete version

Engine Code :335544379
Engine Message:
unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2, support 
12.2
IProvider::attachDatabase failed when loading mapping cache

Is it possible to create databases on a 3.0.5 server with a user other than 
sysdba?

when i try in flamerobin create a database with another user it gives me the 
following error:
Context:Database::Create
Message:isc_dsql_execute_immediate failed

SQL Message:-551
This user not have privilege to perform this operation on this object

Engine Code :335544352
no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

[firebird-support] TCP connection issue

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>


INET/inet_error: read errno = 10054
Winsock.h
WSAECONNRESET 10054 Connection reset by peer.

An existing connection was forcibly closed by the remote host. This normally 
results if the peer application on the remote host is
suddenly stopped, the host is rebooted, the host or remote network interface is 
disabled, or the remote host uses a hard close (see
setsockopt for more information on the SO_LINGER option on the remote socket).

This error may also result if a connection was broken due to keep-alive 
activity detecting a failure while one or more operations
are in progress. Operations that were in progress fail with WSAENETRESET. 
Subsequent operations fail with WSAECONNRESET.
This happens if a sockets client is actively sending or receiving data to or 
from a Firebird Server, and the network connection is
lost. If a client crashes or a network error occurs (for example, an 
intermediate router goes down), the server has no way of
knowing this, unless it tries to use send(). In this case send fails with the 
WSAECONNRESET error.

How does an application know that the remote end has terminated the connection? 
The answer depends on whether the remote end
terminated the connection gracefully or abortively. If the termination was 
abortive, then send() and recv() calls will fail with the
error WSAECONNRESET.
So, in simpler terms the socket that is the end point of the other connection 
has gone. Either the Firebird server has crashed, or
the application using the Firebird client has disconnected abnormally (the 
application may also have crashed). You need to make a
new connection, as the existing connection(s) can no longer be used. If these 
are infrequent, there is probably nothing to worry
about, a client may have rebooted their system, or has been turned off without 
disconnecting from the database server. However if
they are frequent, then you need to look at what may be causing the 
disconnections, either in the application or on the network.

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

[firebird-support] Accessing/repairing embedded server database file

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

This is not due to file damage. Basically whoever created the database set up
a role as "SYSDBA" a well known trick to stop anybody accessing the database 
using the default security database and default user name and password.

<>

Nothing simple and straightforward comes to mind. If you want to acess the
database using Firebird's own tools, then you need to get rid of the SYSDBA
role first... or find out what the database owner username and password 
really is.

Paul

Re: [firebird-support] Accessing/repairing embedded server database file

['Paul Beach' pabe...@waitrose.com [firebird-support]]

>> Have you got any suggestions how to try to access/fix that file? I am not 
a 
>> Firebird expert, so I may have missed something (but I studied a lot of 
docs 
>> how to try to fix my problem).

> Nothing simple and straightforward comes to mind. If you want to acess the
> database using Firebird's own tools, then you need to get rid of the 
SYSDBA
> role first... or find out what the database owner username and password 
> really is.

<>

I am not aware of such a guide, but you might find something if you search
the internet hard enough. I can think of a few ways that it might be possible
but I would have to try them before I could confirm.

Regards
Paul 

RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2

['Paul Beach' pabe...@waitrose.com [firebird-support]]

The following will work.

cd /etc

vi services
change

gds_db 3051/udp
gds_db 3051/tcp

for example.

cd /Library/LaunchDaemons

launchctl unload org.firebird.gds.plist
launchctl load org.firebird.gds.plist

isql>connect 'localhost:/Users/whome/databases/test.fdb' user 'whoever' 
password 'whatever';

in another terminal window:

lsof -i:3051

Regards
Paul


> I am using firebird sql classic-server 2.5.3 under mac osx 10.10.2
> How can i change the remote-service-port (standard is 3050) to another one?
>
>
> i know, in windows and linux this setting is managed by an entry in 
> „firebird.conf"
>
>
> in osx there is also a „firebird.conf" in 
> /Library/Frameworks/Firebird.framework/A/Resources/English-lproj/var/
> but changes in this file:
> RemoteServiceName = gds_db
> RemoteServicePort = 5143
> have no result in firebird. the port is the same as before (3050)
>
>
> i have read the readme-file (firebird.conf.txt) in 
> /Library/Frameworks/Firebird.framework/A/Resources/doc
> But i only found this in „Darwin“ section:
>
>
> "Darwin on the other hand first checks the environment variable FIREBIRD.
> If not found, it [... John, please describe the „bundle" stuff here].
> As a last resort it too falls back to "/usr/local/firebird“.“
>
>
> It seems that this section is not complete written by the author.
> I have searched in internet many times for help but i have not found a answer 
> for this „problem“.
> (with the right knowledege not really a problem)
>
>
> in osx i have found two other files they are maybe used for configuring 
> firebird.
> „org.firebird.gdl.plist" and "StartupParameters.plist"
> but both file has other syntax so i cant adopt the settigs from firebird.conf 
> to this files.
>
>
> these files are:
> /Library/Frameworks/Firebird.framework/A/Resources/FirebirdSS/StartupParameters.plist
>
>
> {
>  Description = "Firebird SQL Database server";
>  Provides= ("Firebird Server");
>  Requires= ("DirectoryServices");
>  Uses= ("Disks", "NFS");
>  OrderPreference = "None";
> }
>
>
> and:
> /Library/LaunchDeamons/org.firebird.gdl.plist
>
>
> 
>  "http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
> 
> 
>   Disabled
>   
>   EnvironmentVariables
>   
>   PATH
>
> /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Se
> rver.app/Contents/ServerRoot/usr/sbin:/usr/local/sbin
>   
>   InetdCompatibility
>   
>   Wait
>   
>   
>   InitGroups
>   
>   Label
>   org.firebird.gds
>   OnDemand
>   
>   ProgramArguments
>   
>   
> /Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server
>   
>   Sockets
>   
>   Listeners
>   
>   SockFamily
>   IPv4
>   SockServiceName
>   gds_db
>   SockType
>   stream
>   
>   
>   UserName
>   firebird
> 
> 
>
>
> How can i configure the remote-service-port (standard is 3050) to another one?
>
>
> Thank You
> Regards
>
>
> René
>
>
> [colombe] computer und medien
>
>
> E-Mail: i...@colombe.biz
> Tel.:030 868 70 48 89
> mobil:  0179  249  48 89
> www.colombe.biz
>
>
>
>
>
>
>
>
> 
> Posted by: =?windows-1252?Q?Ren=E9_Colombe?= 
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>

RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2

['Paul Beach' pabe...@waitrose.com [firebird-support]]

I am on 10.10.2 and the instructions below worked for me without a problem...
I saw the port number switching from 3050 -> 3051

But you must:
launchctl unload org.firebird.gds.plist
launchctl load org.firebird.gds.plist
after changing the port no.

Paul



-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 04 March 2015 01:39
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2




hi paul,


thank your for help.


bevore my question i have changed the /etc/service file to this:


gds_db  5143/udp# gds_db (buhl)
gds_db  5143/tcp# gds_db (buhl)


(without „/„ like the other entrys in this file)


since this, firebird has stpped/started many times (reloading,reboot)
but firebird seems to ignore the etc/service file on my system. (?)


any other suggestions for osx 10.10. ?


regards
rené


Am 03.03.2015 um 11:47 schrieb 'Paul Beach' pabe...@waitrose.com 
[firebird-support] :


The following will work.

cd /etc

vi services
change

gds_db 3051/udp
gds_db 3051/tcp

for example.

cd /Library/LaunchDaemons

launchctl unload org.firebird.gds.plist
launchctl load org.firebird.gds.plist

isql>connect 'localhost:/Users/whome/databases/test.fdb' user 'whoever' 
password 'whatever';

in another terminal window:

lsof -i:3051

Regards
Paul

> I am using firebird sql classic-server 2.5.3 under mac osx 10.10.2
> How can i change the remote-service-port (standard is 3050) to another one?
>
>
> i know, in windows and linux this setting is managed by an entry in 
> „firebird.conf"
>
>
> in osx there is also a „firebird.conf" in 
> /Library/Frameworks/Firebird.framework/A/Resources/English-lproj/var/
> but changes in this file:
> RemoteServiceName = gds_db
> RemoteServicePort = 5143
> have no result in firebird. the port is the same as before (3050)
>
>
> i have read the readme-file (firebird.conf.txt) in 
> /Library/Frameworks/Firebird.framework/A/Resources/doc
> But i only found this in „Darwin“ section:
>
>
> "Darwin on the other hand first checks the environment variable FIREBIRD.
> If not found, it [... John, please describe the „bundle" stuff here].
> As a last resort it too falls back to "/usr/local/firebird“.“
>
>
> It seems that this section is not complete written by the author.
> I have searched in internet many times for help but i have not found a answer 
> for this „problem“.
> (with the right knowledege not really a problem)
>
>
> in osx i have found two other files they are maybe used for configuring 
> firebird.
> „org.firebird.gdl.plist" and "StartupParameters.plist"
> but both file has other syntax so i cant adopt the settigs from firebird.conf 
> to this files.
>
>
> these files are:
> /Library/Frameworks/Firebird.framework/A/Resources/FirebirdSS/StartupParameters.plist
>
>
> {
> Description = "Firebird SQL Database server";
> Provides = ("Firebird Server");
> Requires = ("DirectoryServices");
> Uses = ("Disks", "NFS");
> OrderPreference = "None";
> }
>
>
> and:
> /Library/LaunchDeamons/org.firebird.gdl.plist
>
>
> 
>  "http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
> 
> 
> Disabled
> 
> EnvironmentVariables
> 
> PATH
>
> /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Se
> rver.app/Contents/ServerRoot/usr/sbin:/usr/local/sbin
> 
> InetdCompatibility
> 
> Wait
> 
> 
> InitGroups
> 
> Label
> org.firebird.gds
> OnDemand
> 
> ProgramArguments
> 
> /Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server
> 
> Sockets
> 
> Listeners
> 
> SockFamily
> IPv4
> SockServiceName
> gds_db
> SockType
> stream
> 
> 
> UserName
> firebird
> 
> 
>
>
> How can i configure the remote-service-port (standard is 3050) to another one?
>
>
> Thank You
> Regards
>
>
> René
>
>
> [colombe] computer und medien

RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

Err yes. Just a bit.

<>

As it does for me.

<>

Nope. gds_db = interbase/firebird = 3050 as per IANA
http://linux.about.com/library/cmd/blcmdl5_services.htm

Regards
Paul

[firebird-support] How do I uninstall Firebird on Mac Yosemite?

['Paul Beach' pabe...@waitrose.com [firebird-support]]

> PLEASE HELP ME UNINSTALL FIREBIRD!!!

Open a terminal window...
vi remove.sh
copy and paste the following into the file

#!/bin/sh
echo "Launchctl"
launchctl unload /Library/LaunchDaemons/org.firebird.gds.plist
#echo "Clean User"
#dscl localhost -delete /Local/Default/Users/firebird
#echo "Clean Group"
#dscl localhost -delete /Local/Default/Groups/firebird
if [ -f "/Library/StartupItems/Firebird" ]; then
echo "Remove Superserver StartupItem"
rm -fr /Library/StartupItems/Firebird
fi
if [ -f "/Library/LaunchDemons/org.firebird.gds.plist" ]; then
echo "Remove Launchd"
launchctl unload /Library/LaunchDemons/org.firebird.gds.plist
rm /Library/LaunchDemons/org.firebird.gds.plist
fi
echo "Remove Framework"
rm -fr /Library/Frameworks/Firebird.framework
echo "Remove Receipt"
rm -fr /Library/Receipts/Firebird*.pkg
echo "Remove /tmp/firebird"
rm -fr /tmp/firebird

:wq
chmod 777 remove.sh
sudo remove.sh

should work.

Regards
Paul 

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

['Paul Beach' pabe...@waitrose.com [firebird-support]]

> Must I type "vi remove.sh" into the Terminal window first?

yes, you are in effect creating a shell file that can be excuted later.
before you paste the commands you will probably need to change vi into
insert mode 

:i

should do it.

Regards
Paul 

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

['Paul Beach' pabe...@waitrose.com [firebird-support]]

> And then do I hit Enter/Return when I have pasted that info into the Terminal 
> window? 

No, you exit vi using the command :wq

Regards
Paul 

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

> Is that correct?  Did it all work?

Yes.

> Also, under Users and Groups in Preferences, there is a 'Firebird Database' 
> User - that has login ability when I start my
computer.
> Do I just delete this from the Preferences, or will it be deleted when I 
> uninstall Firebird?

The script has also removed the Firebird user and group.
Firebird is no longer installed on your Mac.

Regards
Paul

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

['Paul Beach' pabe...@waitrose.com [firebird-support]]

Type 'sudo ./remove.sh' [Enter]
If you are in the same directory as the shell file.

Regards
Paul 

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

['Paul Beach' pabe...@waitrose.com [firebird-support]]

I tried it out and it said the following:


Ryans-MacBook-Pro:~ ryanashton1$ ./remove.sh
Launchctl
/Library/LaunchDaemons/org.firebird.gds.plist: Could not find specified service
Remove Framework
Remove Receipt
Remove /tmp/firebird


Then the sh file has done nearly all its job...
the comments you see above refer to the echo commands in the shell script
But I have just seen a small problem with why you still have a firebird user...

The original had the remove user/group commands commented out. Apologies. 

just type the following into the terminal and hit return
sudo dscl localhost -delete /Local/Default/Users/firebird
sudo dscl localhost -delete /Local/Default/Groups/firebird

The following script is now complete.

#!/bin/sh
echo "Launchctl"
launchctl unload /Library/LaunchDaemons/org.firebird.gds.plist
echo "Clean User"
dscl localhost -delete /Local/Default/Users/firebird
echo "Clean Group"
dscl localhost -delete /Local/Default/Groups/firebird
if [ -f "/Library/StartupItems/Firebird" ]; then
echo "Remove Superserver StartupItem"
rm -fr /Library/StartupItems/Firebird
fi
if [ -f "/Library/LaunchDemons/org.firebird.gds.plist" ]; then
echo "Remove Launchd"
launchctl unload /Library/LaunchDemons/org.firebird.gds.plist
rm /Library/LaunchDemons/org.firebird.gds.plist
fi
echo "Remove Framework"
rm -fr /Library/Frameworks/Firebird.framework
echo "Remove Receipt"
rm -fr /Library/Receipts/Firebird*.pkg
echo "Remove /tmp/firebird"
rm -fr /tmp/firebird


Paul

RE: [firebird-support] Re: FB 2.1 CS High FBLockPrint Mutex wait figure

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

Just as an FYI - Dimitry is *not* one of the IBSurgeon guys - he happens to be
the Firebird project's lead developer. You can find out a bit more on who
does what re. the project by looking here.

http://www.firebirdsql.org/en/team-members/

Regards
Paul

[firebird-support] Missing libfbembed.dylib on OSX releases

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<https://github.com/andrewleech/fdb_embedded
At the moment the setup script will download the required platforms binary 
release of firebird and cherry pick the required
libraries, update the dynamic library load path if required, and package it all 
up. If that fails it's downloads the source and
compiles firebird, before cherry picking the required libraries.
I've run into a little annoyance: none of the mac osx 2.5.4 releases appear to 
include the embedded library.
http://www.firebirdsql.org/en/firebird-2-5/#MacOSX
They only appear to have libfbclient.dylib. I'm pretty sure this isn't the 
embedded library lib renamed to client, it's too small
and it doesn't appear to work as such.
I can continue to compile from the source, but it's much faster to use the 
binary releases.>>

This should explain how it all works.

http://paulbeachsblog.blogspot.fr/2008/03/where-is-libfbclientdylib-on-macosx.html

Regards
Paul Beach

[firebird-support] Need Help

['Paul Beach' pabe...@waitrose.com [firebird-support]]

If by QBICSYSTEMS you mean QBIC III Systems Inc. then the database will be 
Firebird.

Regards
Paul 

RE: [firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

>

I am currently using 10.10.5 not 10.11 and I will not be upgrading to
10.11 yet as its only in late RC, but the release date is September 30, 2015
So when it goes GM I guess I get to install it and try and work out whats wrong,
and come up with a solution.

In terms of Firebird 3.0, Firebird compiles on MacOSX, but I have been waiting 
for
RC1 so all the 64bit txn id code is committed. When RC1 is tagged I will start
work on the MacOSX port and installer.


Currently this is how I install it:
Right Click on the pkg file, and choose open, then select open again
But I guess that mechanism won't work mow because of SIP, I did find this:

The supported way to disable System Integrity Protection in those cases where 
it’s truly
necessary is to boot into the Recovery partition and turn System Integrity 
Protection off
from there with the csrutil tool.

$ csrutil
usage: csrutil
Modify the System Integrity Protection configuration. All configuration changes 
apply to the entire machine.
Available commands:
disable
Disable the protection on the machine. Requires a reboot.
enable
Enable the protection on the machine. Requires a reboot.
status
Display the current configuration.

The kext-dev-mode and rootless boot-args are being removed from OS X El Capitan 
and will no longer work.

But reading further the sort of places that are protected are /System, /bin, 
/sbin and /usr
whilst we install into /Applications/Frameworks... So is there anything when 
you try to install it, where it
confirms that this is a SIP problem?

Paul

RE: [firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

<>

I suspect its not SIP, but the fact that we use an outdated package format. 
Looks like El Capitan has finally deprecated it.
I found this https://forums.developer.apple.com/thread/8676
Note the error message, they then switched from /var to /Applications and all 
was ok.
While we use /Library/Frameworks

Regards
Paul

RE: [firebird-support] Support for OS X 10.11 El Capitan

['Paul Beach' pabe...@waitrose.com [firebird-support]]

Timo,

<>.

Thanks - that tells me where to look and try and fix the problem.

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