Re: [firebird-support] Install a DB Firebird on a web site

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

On 27/03/2019 12:01, 'Stellarancia.com' ni...@stellarancia.com 
[firebird-support] wrote:
> I was thinking of moving the database Firebird from the computer to a
> Web site, to allow all one connection directed by app.
> Ithink this is possible for Firebird, but I have not succeeded in
> finding the way to install Firebird on a site or to find a site that can
> manage the Firebird driver.

If your delphi application is designed for multiple clients to access 
the same database, then it is just a matter of making the database 
accessible on the internet. That does not involve a website, but it does 
open the database to scrutiny by anybody else on the internet.

My own websites use Firebird as a tool to store the data that is 
displayed on the website, but is only accessible by the local copy of 
PHP, while another application has BuilderC clients spread across 
multiple locations all accessing the one copy of Firebird one a closed 
network.

As Mark says, what are you actually trying to achieve?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk






++

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] Text search ...

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

On 14/03/2019 13:20, Steve Wiser st...@specializedbusinesssoftware.com 
[firebird-support] wrote:
> Sorry, to be more clear we used lucene outside of firebird.  We also 
> happened to store specific information about the files in firebird.  I 
> stayed away from the lucene within firebird approach because the 
> libraries seemed out of date and I wasn't sure on support.

Having to live with the MySQL on the wordpress sites I don't want to add 
to that mess with more large databases that I can't back up easily. So 
the key here is to move things to a Firebird base where the nightly 
backup just happens without any disruption to the websites ;)

Does not leave many options ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Text search ...

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

On 13/03/2019 14:01, Steve Wiser st...@specializedbusinesssoftware.com 
[firebird-support] wrote:
> We have used tesseract-ocr 
It can be quite amazing what one misses even searching for something 
specific. This has thrown up a couple of add-ons that look interesting 
as well. Just have to fight SUSE to get them installed ... just a pity 
once again it's google who are funding things ... now to see if I can 
get ocrfeeder package for suse!

> lucene (plus firebird for the index data) 
> for this in the past.  It works pretty well, but not completely out of 
> the box -- you will have to tweak the image a bit.
I've looked at lucene in the past and did have a trial configuration set 
up at one time, but support seems to be rather out of date? And .net 
seems to get mixed in ...
I'm a little loathed to add Java into the mix anyway, but all the 
popular full text options seem to be Java based :(

https://firebirdsql.org/en/sphinx-full-text-search/ seems to be a dead 
end for Firebird if what I'm reading on V3 is correct re MySQL native 
access.

http://www.firebirdfaq.org/faq328/ links are somewhat tired and out of 
date. I have used IB_FTS in the past, but not being windows based these 
days I'm only using IBObjects on a dwindling number of legacy systems 
and even those will need to be moved to web based sooner rather than 
later. I need something that plays nicely with PHP7 ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Text search ...

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

On 13/03/2019 02:35, Andrew Lowe a...@wht.com.au [firebird-support] wrote:
> Maybe you might want to have a look at Zotero. It does a lot of stuff
> with pdf's, databases etc.

That is working on a different part of the problem although it might 
have provided pointers except for one thing ... "But if you value a 
built-in PDF reader, Zotero may not be the best tool for you." Basically 
it 'suffers' from the same problem I'm trying to address. We have the 
pdf's and in the case of some sites we can even access the original 
source used to create them. Google and Bing crawl the pdf's but using 
them to provide search results is not acceptable for my local council 
clients so we need a 'local' search facility.

BUGGER that was working fine yesterday !!!
https://northwaypc.org.uk/fisheye/gallery/75 is an example, but just 
found the dreaded 'white screen' on looking at a volume ... and the 
minutes and agendas galleries are not working either ... This site was 
fine yesterday and 'I've' not changed anything in my sleep :( Now to 
debug that ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

[firebird-support] Text search ...

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

I've got a few of sites where I've got a growing number of pdf files 
which it would be nice to actually index the content. First problem is 
obviously the different qualities of pdf, and I've had finereader 
deployed in some cases to provide OCRed copies of the original, with the 
usual variable success. The question is just what is the best base to be 
working towards. I'm currently working on the basis that we store the 
original file, and I create thumbnails of the front page so I'm now 
looking to striping the raw text. Anybody been there already? Any 
suggestions for Linux based solutions ...

The current indexing process is pulling a list of words from the 
document and building a manual index. It was first working pre-Firebird 
and has not changed so is there a better was with FB3?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: ODP: [firebird-support] Silly selection problem ...

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

On 04/03/2019 15:56, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> You can do this without window function also in FB<3, but less efective. 
> Do simple 2 subselects in your select.

Can you explain how?
Without the full window scan LAG and LEAD gave NULL ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Silly selection problem ...

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

On 02/03/2019 16:50, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
>> OK another reason for moving over to FB3 ...
>> LEAD and LAG working nicely ...
> Except it's only half the solution:(
> I was hoping to avoid traversing the parent gallery ... it would be nice
> to just return a single record with the target content id.

OK got an encapsulated solution so don't need to download the whole tree

WITH TREE AS
( SELECT ITEM_CONTENT_ID,
LAG( ITEM_CONTENT_ID) OVER (ORDER BY ITEM_POSITION) AS PRE,
LEAD( ITEM_CONTENT_ID ) OVER (ORDER BY ITEM_POSITION) AS POST
FROM FISHEYE_GALLERY_IMAGE_MAP
WHERE GALLERY_CONTENT_ID = :parent_id
ORDER BY ITEM_POSITION )
SELECT PR.PRE, PR.POST FROM TREE PR
WHERE PR.ITEM_CONTENT_ID = :content_id

I think the next step is to also generate the :parent_id in the query 
but I now need to migrate the production site to FB3 so I can use what I 
already have :(

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Silly selection problem ...

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

On 02/03/2019 16:24, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
> On 02/03/2019 16:06, Lester caineles...@lsces.co.uk  [firebird-support]
> wrote:
>> In the past ( 20 years ago;)  ) I would simply have added a second
>> position column which is consecutive numbers and reordered them when
>> changes are made, but I'm wondering if with all the things that have
>> been added since then has provided an SQL means of returning the before
>> and after value directly from the current data?
> OK another reason for moving over to FB3 ...
> LEAD and LAG working nicely ...

Except it's only half the solution :(
I was hoping to avoid traversing the parent gallery ... it would be nice 
to just return a single record with the target content id.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Silly selection problem ...

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

On 02/03/2019 16:06, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
> In the past ( 20 years ago;)  ) I would simply have added a second
> position column which is consecutive numbers and reordered them when
> changes are made, but I'm wondering if with all the things that have
> been added since then has provided an SQL means of returning the before
> and after value directly from the current data?

OK another reason for moving over to FB3 ...
LEAD and LAG working nicely ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

[firebird-support] Silly selection problem ...

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

I think I will probably have to add some extra logic into this problem, 
but it SHOULD be simple enough ...

Table with three fields - Gallery_No, Image_No, Item_position

A gallery can consist of any number of images but we normally only 
display a selection of up to 30. Item_position is a FLOAT which allows 
several styles ordering, with one style 'page.pos' so one can group 
pictures to a variable length page. The bottom line here is that 
'Item_position' is not sequential ... and that is the rub. I now need to 
identify the record before and the record after for a library system 
where each gallery is a collection of pdf articles and the client would 
like to be able to navigate back and forward through each volume.

In the past ( 20 years ago ;) ) I would simply have added a second 
position column which is consecutive numbers and reordered them when 
changes are made, but I'm wondering if with all the things that have 
been added since then has provided an SQL means of returning the before 
and after value directly from the current data?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] FB3 stability ...

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

On 25/02/2019 14:06, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
> A search for firebird on Leap 15.1 packages does not even give a result
> and across all versions only returns the PHP clients. But I know I've
> seen a repo for databases with 3.0.4 in ... so now to find where it is
>  OH and reset everything so that PHP works after the upgrade!

OK just for the record
https://download.opensuse.org/repositories/server:/database/
but since I presume FB4 will appear there at some point I've locked the 
7 packages SUSE listed to version 3.0.4 ... along with Flamerobin.

And 
https://download.opensuse.org/repositories/devel:/languages:/php:/php72/ 
looks like it protects from later versions of PHP and I've got the 
development web service updated.

Now to work out why I can't see TV on the right hand monitor ... I had 
the news channel up before lunch! ... And have another go at Mercurial ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] FB3 stability ...

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

On 25/02/2019 12:21, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> Or you could just try it to see if it helps. You have repeatedly posted
> similar problems over the last few months, and I don't get the
> impression you made any progress on it.

I have been making progress, but mainly getting the development platform 
working again on Leap 15.0 ... As it happens 15.1 does nothing for 
Firebird ... it still has 3.0.2 as the best version available. 15.1 has 
done nothing to fix the graphics problems either. The 4 screens come up 
in the wrong order and while I could move cables around there are other 
two screen machines in parallel and the 'new' suse default means the 
pairs end up split. Why can't they simply leave working hardware alone 
 but then one is expected to buy new kit every year or so? I've been 
using this monitor and KVM setup for several years and apart from an 
extender playing up which I've NOW sorted while waiting on 15.1 it works 
fine ...

SO ... since as has been said on the dev list RPM's from Firebird were 
dropped, just what is the best way to upgrade from 3.0.2 while 
maintaining compatibility with the SUSE infrastructure. At the end of 
the day this is about producing a crib sheet I can rely on to upgrade 
all of the machines and keep them as identical as possible. Much as I 
used to do for w2k servers all those years ago!

A search for firebird on Leap 15.1 packages does not even give a result 
and across all versions only returns the PHP clients. But I know I've 
seen a repo for databases with 3.0.4 in ... so now to find where it is 
 OH and reset everything so that PHP works after the upgrade!

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] FB3 stability ...

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

On 25/02/2019 11:34, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> On 25-2-2019 12:22, Lester Caine les...@lsces.co.uk [firebird-support]
> wrote:
>> OK ... Have development system upgraded and currently running SUSE Leap
>> 15.0 out of the box so ...
>>
>> Firebird 3.0.2
>> PHP 7.2.5
>> Nginx 1.14.0 ( Apache is locked out )
> 
> 3.0.3 fixed 87 issues, 3.0.4 fixed 74 issues (based on tickets closed in
> the tracker). If you have stability issues with 3.0.2, your first stop
> should be to upgrade to 3.0.4.

A question perhaps for SUSE as to why the current stable build only has 
3.0.2? I don't want to switch on the development repo's as they DO cause 
problems with things, but switching JUST 3.0.4 is what I though I had 
done on the other machine yet it's still got a 3.0.2 client ...

The SUSE side have said Leap15.1 Beta may be my best option as they 
admit problems with some legacy parts of 15.0 ... tha is if it will 
actually run on my hardware which has run 13.1 for many years perfectly.

>> Getting the following randomly ...
>>
>> Warning: fbird_connect(): Your user name and password are not defined.
>> Ask your database administrator to set up a Firebird login. Install
>> incomplete, please read the Compatibility chapter in the release notes
>> for this version in
>> /srv/website/externals/adodb/drivers/adodb-firebird.inc.php on line 69
>   >
>> But a reload works fine and navigating around currently is also fine.
>> The first question is just how should one replace the SUSE style of
>> package management to just replace a single element such as Firebird ...
>> and will that help anyway?
> 
> No clue why you'd get that error randomly, but I guess it doesn't apply
> a stable AuthClient setting (maybe something is depending on load order
> of libraries, etc?). To avoid that error itself, initialize the security
> database for SRP by creating a SRP user (and if you don't want to use
> it: drop that user again).

ALL I have enabled in the config file is Legacy ... srp is not listed at 
all, so why should creating an srp user be necessary? I've not looked to 
that side at all yet ... just more reading for something I don't see the 
need to use. Anyway have a 15.1 disk ready to run ... so off-line for a 
bit again ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

[firebird-support] FB3 stability ...

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

OK ... Have development system upgraded and currently running SUSE Leap 
15.0 out of the box so ...

Firebird 3.0.2
PHP 7.2.5
Nginx 1.14.0 ( Apache is locked out )

Getting the following randomly ...

Warning: fbird_connect(): Your user name and password are not defined. 
Ask your database administrator to set up a Firebird login. Install 
incomplete, please read the Compatibility chapter in the release notes 
for this version in 
/srv/website/externals/adodb/drivers/adodb-firebird.inc.php on line 69

But a reload works fine and navigating around currently is also fine. 
The first question is just how should one replace the SUSE style of 
package management to just replace a single element such as Firebird ... 
and will that help anyway?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: Strange behavior on very large table

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

On 22/02/2019 04:33, my...@techsol.org [firebird-support] wrote:
>  >Given that this table is "temporary" storage, one supposes that you
> are deleting rows from it regularly. Do you happen to be deleting
> 900,000 rows each day before you load up the latest batch of 900,000?

How much information is static between cycles? Does all the data NEED to 
be in the one table? Can you re-configure so that this action becomes 
'add new table' ... 'drop old table' ... which will be a lot tidier anyway.

I had a system loading a previous days actions which initially just kept 
adding and keeping history, and with a more modern processor and SSD 
disk we would probably get away with it today ;) But back then it got to 
a point where the table was too big, and we dropped to just maintaining 
a months worth live with every day in it's own table and only the 
summary tables maintaining the historic counts. All the historic data is 
still available and if there was a need it might be interesting to put 
it all back together into one table ... if I could get past the 'data 
protection' restrictions :( I am actually expecting a request to make 
sure it is all destroyed but it's not directly identifying people from 
20 years ago.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: ODP: [firebird-support] Built in RegEx Capability?

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

On 12/02/2019 16:36, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> Select
> D.NAZWA
> , SUBSTRING(D.NAZWA FROM POSITION('V', D.NAZWA)+1 FOR POSITION('p', 
> D.NAZWA)-3) AS V
> , SUBSTRING(D.NAZWA FROM POSITION('p', D.NAZWA)+1 FOR POSITION(' ', 
> SUBSTRING(D.NAZWA FROM POSITION('p', D.NAZWA)))-2) AS P
> from
> (SELECT 'V12 p234 The state of the nation.pdf' AS NAZWA FROM  
> RDB$DATABASE) D

Moved over to FB3 server now and this works on a few edge cases which 
the regex fails on, such as 2 spaces before the 'p', but it also throws 
errors where the p element is broken - negative offset.

Nothing is easy :( But I think I can combine to two and populate the new 
'V' and 'P' fields.

Part of the problem is being able to list the records properly and if 
one was starting from scratch they would probably be '0's padded numbers 
but this data has been built up over years and there is no easy way to 
rename all the files now ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Built in RegEx Capability?

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

On 11/02/2019 22:22, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
> 11.02.2019 22:18, Lester caineles...@lsces.co.uk  [firebird-support] wrote:
>> Ideally I need to extract the 'V' element and the 'p' element into their
>> own fields so I can look up Volume '12' and page '234' or list all the
>> pdf's for Volume '12' in page order.
> You could use "Regular expression SUBSTRING" described in
> firebird3/doc/README.substring_similar.txt.

Would help if we did not have to rely on a variable target :(

I've got 
https://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes253.html#rnfb25-dml-regex
 
which the FB3 release notes link back to ...

AH ... on a linux installation for SUSE it's hidden in 
/usr/share/doc/packages/firebird/sql.extensions but it's even less 
helpful than the online page.

None of the examples show pulling the 'content of the second match' to 
insert in an update statement? They all seem to be returns for Boolean 
operations?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk






++

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: Built in RegEx Capability?

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

On 11/02/2019 22:51, blackfalconsoftw...@outlook.com [firebird-support] 
wrote:
> It may be more convenient to pull out data via a Regex expression in SQL 
> code but it is rather redundant since all of the major development 
> languages already support extensive Regex pattern matching capabilities...

20 years ago I'd just have rolled a UDF to give me the two values which 
I could then use in the database. It looks like I still need to do that. 
Or as you say cycle all the data through PHP ... which messes up simply 
upgrading the databases via a local script.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

[firebird-support] Built in RegEx Capability?

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

I have some data in a table which I need to 'pull apart'. It's 
essentially a ID for a reference but it's not as tidy as I would like 
because of the variable length and a little variable in case although 
the format is consistent.

V p .pdf
For example 'V12 p234 The state of the nation.pdf'

Ideally I need to extract the 'V' element and the 'p' element into their 
own fields so I can look up Volume '12' and page '234' or list all the 
pdf's for Volume '12' in page order.

I can run it through PHP and RegEx the text and push the new fields 
back, but is it possible to do this in a query in Firebird. I THINK what 
I'm seeing is that I could search for matching patterns but not actually 
extract the match to a new field?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Consecutive values from different fields

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

On 24/01/2019 07:50, 'Autoneer' myauton...@gmail.com [firebird-support] 
wrote:
> I have never worked with a recursive cte before and have no idea on how 
> to go about this.

Personally I'd start by reordering the data to a single field ... It's 
easy enough to DISPLAY a week at a time working from a table that has 
single day records. The one can more easily scan the data for 
'consecutive days' and also make calculations on 'hours' so giving the 
right breaks between driving sessions.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk






++

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] Consecutive values from different fields

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

On 24/01/2019 07:50, 'Autoneer' myauton...@gmail.com [firebird-support] 
wrote:
> I have never worked with a recursive cte before and have no idea on how 
> to go about this.

Personally I'd start by reordering the data to a single field ... It's 
easy enough to DISPLAY a week at a time working from a table that has 
single day records. The one can more easily scan the data for 
'consecutive days' and also make calculations on 'hours' so giving the 
right breaks between driving sessions.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk






++

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] Falling at second hurdle ...

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

On 17/01/2019 21:11, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
> But PHP gives
> fbird_connect(): Incompatible wire encryption levels requested on client
> and server
> That is PHP on the same machine as FB3

Sorted ...
I've update from 3.0.2 to 3.0.4 from the suse:database repo and rebooted 
the machine which seems to have sorted the problem. I probably need to 
work out what I have lost, but nothing Firebird wise goes outside the 
local network, only the PHP pages are seen from outside and 
https://lsces.co.uk/ is working ... now just need to test out a few of 
the more challenging web database stuff before moving the other databases.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Falling at second hurdle ...

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

On 17/01/2019 20:36, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
>> WHAT am I not reading here?
> I'd suggest to explicitly specify the user manager plugin you want to
> use instead of leaving it to the specific configuration (doing this will
> also detect problems if an expected user manager is not installed or not
> the first in the list).
> 
> Eg, use
> create user sysdba password '..' using plugin Legacy_UserManager;
Statement failed, SQLSTATE = 23000
add record error
-violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table 
"PLG$USERS"
-Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')

> Note: this requires that specified plugin is listed in the UserManager
> config in firebird.conf.
WireCrypt = Disabled
AuthServer = Legacy_Auth, Srp, WinSspi
AuthClient = Legacy_Auth, Srp, Win_Sspi
UserManager = Legacy_UserManager

> Also, what is the output of `select SEC$USER_NAME, SEC$PLUGIN from
> SEC$USERS`?
Got two users currently
SYSDBA  Legacy_UserManager
LSCES   Legacy_UserManager

AH ... strip the unused modes ...
AuthServer = Legacy_Auth
AuthClient = Legacy_Auth
And I can access it from Flamerobin on the development machine.

But PHP gives
fbird_connect(): Incompatible wire encryption levels requested on client 
and server
That is PHP on the same machine as FB3

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Falling at second hurdle ...

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

On 17/01/2019 20:13, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
> On 17/01/2019 19:34, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] wrote:
>> 17.01.2019 20:11, Lester caineles...@lsces.co.uk  [firebird-support] wrote:
>>> So what can I do next to get this to work?
>>  You can read Release Notes for Firebird 3.0, chapter "Compatibility 
>> Issues" including
>> "Embedded Connections" and "Initializing Security Database".
>>  Also reading text of "an add record error" can provide a clue.
>>  Remember, that in embedded mode password is not checked, but user name 
>> is still
>> applied, so you must use "-u SYSDBA" when connecting to a database for 
>> creating SYSDBA
>> user (sounds funny, I know).
> 
> Personally I would rather NOT have the Embedded Connection insecurity
> but that side of things is working and I have a restored database.
> 
> Given the 'Important' notice on the top of the 'Initializing the
> Security Database' I skipped to the next section, and the various
> changes have been made. And I think are right.
> 
> Now I'm being told that perhaps the legacy user has not been set, but
> now I can run the scripts on 'Initializing the Security Database'
> 
> create user SYSDBA password 'SomethingCryptic';
> gives
> Statement failed, SQLSTATE = 23000
> add record error
> -violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table
> "PLG$USERS"
> -Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')
> 
> WHAT am I not reading here?

Just to complete what I CAN do
Flamerobin is giving
Engine Code: 335544472
Engine Message :
Your user name and password are not defined. Ask your database 
administrator to set up a Firebird login.
Install incomplete, please read the Compatibility chapter in the release 
notes for this version

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk






++

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] Falling at second hurdle ...

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

On 17/01/2019 19:34, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
> 17.01.2019 20:11, Lester caineles...@lsces.co.uk  [firebird-support] wrote:
>> So what can I do next to get this to work?
> You can read Release Notes for Firebird 3.0, chapter "Compatibility 
> Issues" including
> "Embedded Connections" and "Initializing Security Database".
> Also reading text of "an add record error" can provide a clue.
> Remember, that in embedded mode password is not checked, but user name is 
> still
> applied, so you must use "-u SYSDBA" when connecting to a database for 
> creating SYSDBA
> user (sounds funny, I know).

Personally I would rather NOT have the Embedded Connection insecurity 
but that side of things is working and I have a restored database.

Given the 'Important' notice on the top of the 'Initializing the 
Security Database' I skipped to the next section, and the various 
changes have been made. And I think are right.

Now I'm being told that perhaps the legacy user has not been set, but 
now I can run the scripts on 'Initializing the Security Database'

create user SYSDBA password 'SomethingCryptic';
gives
Statement failed, SQLSTATE = 23000
add record error
-violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table 
"PLG$USERS"
-Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')

WHAT am I not reading here?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk






++

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] Falling at second hurdle ...

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

On 17/01/2019 18:40, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
> On 17/01/2019 16:27, Mark rotteveelm...@lawinegevaar.nl  
> [firebird-support] wrote:
>> On 17-1-2019 11:59, Lester caineles...@lsces.co.uk  [firebird-support]
>> wrote:
>>> On 17/01/2019 10:51, liviusliviusliviusliv...@poczta.onet.pl
>>> [firebird-support] wrote:
>>>> I suppose you have missed previous point at
>>>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat.html
>>>>
>>>> Look for
>>>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-initsec.html
>>> "This initialization is not required and should NOT be performed if you
>>> have configured the server to use legacy (pre-Firebird 3 style)
>>> authentication and user management."
>>>
>>> So is that not the case?
>> On Windows, you will only get that error if SRP authentication is
>> attempted while SRP has not been initialized in the security database.
>>
>> However, if I had to guess, it may be possible that the security
>> database in your install was not initialized for Legacy_Auth (on
>> Windows, the security database contains a default Legacy_Auth sysdba).
>>
>> It may be possible that you will first need to ensure that a legacy
>> authentication user is created to initialize the security database properly.
> No windows in this equation, but I don't know what the SUSE install
> actually did. So where do I find out how to check this? It's created the
> crib for the legacy ... AH that must be an old one! SYSDBA.password is
> from August:(
> 
> Right had to add firebird-examples to get employee database, and isql-fb
> is the right access package, but
> create user SYSDBA password 'SomethingCryptic'; gives me an add record
> error, so presumably SYSDBA already exists? At least I've altered the
> password, but I'm not getting a request to enter it when opening
> employee again ...
> 
> Flamerobin knows if FB3 is running or not ...
> 
> It can see the old databases but of cause they need updating to 12.0. I
> still remember when I could open old databases. I suppose the next thing
> to try is to restore one to see what isql-fb says ... except it's been
> years since I did that from the command line ...

This is getting annoying now ... gbak worked and I've got a new copy of 
the data ... isql-fb can access it and read the data ... but no request 
for a password.
Access from PHP gives me
fbird_connect(): Install incomplete, please read the Compatibility 
chapter in the release notes for this version

So what can I do next to get this to work?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Falling at second hurdle ...

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

On 17/01/2019 16:27, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> On 17-1-2019 11:59, Lester Caine les...@lsces.co.uk [firebird-support]
> wrote:
>> On 17/01/2019 10:51, liviuslivius liviusliv...@poczta.onet.pl
>> [firebird-support] wrote:
>>> I suppose you have missed previous point at
>>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat.html
>>>
>>> Look for
>>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-initsec.html
>>
>> "This initialization is not required and should NOT be performed if you
>> have configured the server to use legacy (pre-Firebird 3 style)
>> authentication and user management."
>>
>> So is that not the case?
> 
> On Windows, you will only get that error if SRP authentication is
> attempted while SRP has not been initialized in the security database.
> 
> However, if I had to guess, it may be possible that the security
> database in your install was not initialized for Legacy_Auth (on
> Windows, the security database contains a default Legacy_Auth sysdba).
> 
> It may be possible that you will first need to ensure that a legacy
> authentication user is created to initialize the security database properly.

No windows in this equation, but I don't know what the SUSE install 
actually did. So where do I find out how to check this? It's created the 
crib for the legacy ... AH that must be an old one! SYSDBA.password is 
from August :(

Right had to add firebird-examples to get employee database, and isql-fb 
is the right access package, but
create user SYSDBA password 'SomethingCryptic'; gives me an add record 
error, so presumably SYSDBA already exists? At least I've altered the 
password, but I'm not getting a request to enter it when opening 
employee again ...

Flamerobin knows if FB3 is running or not ...

It can see the old databases but of cause they need updating to 12.0. I 
still remember when I could open old databases. I suppose the next thing 
to try is to restore one to see what isql-fb says ... except it's been 
years since I did that from the command line ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

[firebird-support] Falling at second hurdle ...

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

OK, hitting a brick wall using older server setups with things that are 
considered essential these days no longer working, and the fixes 
requiring a full upgrade.

Servers are running SUSE42.3 with Nginx/PHP7.0/FB2.5 and reliant on 
Letsecrypt for certificates, but trying to run a renew yesterday as I 
needed some revised certs failed. This is not unusual for Letsecrypt 
even with the 'no upgrade' option and the supported certbot version is 
far behind ... but the other machines it's running fine! ... so looked 
to upgrade to SUSE15.0. Only problem, it ignored the lock on PHP7.0 and 
FB2.5 and upgraded both to 7.2 and 3. certbot has at least updataed the 
certs but still will not create the one I wanted yesterday morning but 
I'm used to that aggro ... it will just run http for now!

Needing sites back up again I switched over to a backup FB2.5 server and 
spent a few hours clearing all the crap that PHP7.2 introduced. There is 
NO need to complain about numbers not being the right type when the 
language has worked fine for 20 years without strict typing :(

Now the REAL problem. I have FB3.0.2 installed by SUSE. Needed to start 
it manually, but I also need to restore Legacy authentication. The ONLY 
user is PHP and so I don't want any extra user access, just using 
Flamerobin as the backup access if there are problems that can't be 
fixed via the PHP interface. But currently I can't 'Retrieve Server 
Version' on Flamerobin as it says check 'Compatibility Issues' ... I've 
run through 
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-legacyauth.html
 
and yes stop/started firebird service ... but no joy. I've been at this 
point before an gave up, just switching back to 2.5 but I think I'm 
forced to persevere this time ... how do I get Flamerobin to connect ... 
given that the target machine is text only and I'm using Flamerobin from 
an FB2.5 machine since I still need access to both versions.

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] concat a integer variable to a varchar

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

On 05/01/2019 11:23, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
>>> RTFM == Read The Fucking Manual, which - to me - is similar to saying
>>> "You're an idiot and why the fuck are you bothering us with this simple
>>> question.".
>>  In my time "F" stayed for "Following" but the world obviously is 
>> changing.
> As far as I'm aware, RTFM has always meant Read The Fucking Manual; see
> alsohttps://en.wikipedia.org/wiki/RTFM. I have never heard of the F
> used with the meaning Following.

You beat me to it Mark ... even google simply brings up the same text.

Dimitry given that access to much of the documentation is not as easy as 
one may perhaps like, a link to an example of how it should be done 
would have been more useful. This is the support list after all and even 
just supplying a corrected copy of the problem line would be more 
helpful ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Converting dates and the ISO-8601 format

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

On 10/11/2018 11:19, i...@synapsesoftware.co.uk [firebird-support] wrote:
> Fantastic! Works a treat! Wow, wonder how many other people are going to 
> be tripped up by this ! ?

There is a list for firebird users on php firebird-...@yahoogroups.com

It is true that Firebird does not perhaps get the love it deserves when 
using it with PHP and there are a few niggles that have crept in over 
the years as how PHP handles data has been changed. We *DO* need a few 
more people who can handle the complexities of C and changes to the 
interface to bring both the original ibase driver and the less flexible 
pdo_firebird driver up to PHP7 standards. The PHP developers keep 
threatening to drop them all together! So as a starting point, we could 
do with a bit more activity on the firebird-php list ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: Server crash when no more space for the database

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

On 07/11/2018 07:51, hv...@users.sourceforge.net [firebird-support] wrote:
>  > While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space
>  > for the database the server crashed. See the attachment. Is it a known
>  > limitation (not fixed in 2.5 because it's too old) or a bug?
> 
>    There should be no crash. Errors - yes, crash - no.
> Attached log is truncated and i see no message about crash there.

I'm still running many sites on 20Gb hard disks ... I get plenty of 
warning when the OS ... Linux or Windows ... is running low on disk 
space and need to wipe all the crud from the system logs. The first 
problem is normally the OS screwing up rather than the applications 
particularly with windows but in the log provided the first error has 
already flagged the problem ... so why has it not been acted on? 
Continuing to try to do things after the ERROR has been raised is the 
problem and in my book has little option but to crash at some point?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Server crash when no more space for the database

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

On 06/11/2018 17:07, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space
> for the database the server crashed. See the attachment. Is it a known
> limitation (not fixed in 2.5 because it's too old) or a bug?

Where would you suggest the computer stores the data if there is no more 
space? Need to ensure there is sufficient free space on the disk for the 
operating system to work, and then some more spare space for applications?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: Sequential auto incremental numbering

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

On 03/09/18 07:29, 'Christian Giesen' ch...@xt.co.za [firebird-support] 
wrote:
>    NextInvNo = (SELECT MAX(INVOICE_NO) FROM INVOICE) + 1;

Christian ... there was many years ago a very nice article on this very 
problem. The whole reason that will not work is when two or more people 
are adding invoices at the same time! My own system generates ticket 
numbers which ideally should not have gaps but if two counters press 
'add ticket' at the same time they both see the same 'NextInvNo' ... 
I've added a couple of solutions which almost get it right, but just 
occasionally ... like once every few months ... we get two tickets with 
the same number created within 0.0001 second of one another -  what are 
the chances of that - obviously not zero :(

Now a unique index should prevent that but in my case the ticket numbers 
start at 1 every day across multiple sites so the index has to combine 
several things and I never did work out who to handle the clash event. 
In your case you can make the index unique, but need to handle if two 
invoices are created at the same time ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: Sequential auto incremental numbering

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

On 03/09/18 10:36, Svein Erling Tysvær setys...@gmail.com 
[firebird-support] wrote:
> I think the article Lester refers to may be the 'An auditable series of 
> numbers' article which can be found on 
> http://www.ibobjects.com/TechInfo.html.

THAT is the one ... did not think t check IBObjects archive ...

> Den man. 3. sep. 2018 kl. 09:58 skrev Lester Caine les...@lsces.co.uk 
>  [firebird-support] 
>  >:
> 
> On 03/09/18 07:29, 'Christian Giesen' ch...@xt.co.za
>  [firebird-support]
> wrote:
>  >    NextInvNo = (SELECT MAX(INVOICE_NO) FROM INVOICE) + 1;
> 
> Christian ... there was many years ago a very nice article on this very
> problem. The whole reason that will not work is when two or more people
> are adding invoices at the same time! My own system generates ticket
> numbers which ideally should not have gaps but if two counters press
> 'add ticket' at the same time they both see the same 'NextInvNo' ...
> I've added a couple of solutions which almost get it right, but just
> occasionally ... like once every few months ... we get two tickets with
> the same number created within 0.0001 second of one another -  what are
> the chances of that - obviously not zero :(
> 
> Now a unique index should prevent that but in my case the ticket
> numbers
> start at 1 every day across multiple sites so the index has to combine
> several things and I never did work out who to handle the clash event.
> In your case you can make the index unique, but need to handle if two
> invoices are created at the same time ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

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

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

On 11/08/18 08:29, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
>> Another concern is the consideration of moving the current forum's data
>> into a new forum's format.
> Migrating the archive to a new platform is in my opinion not a
> requirement. We will however need to preserve that archive in some form.
> That way, old discussions etc can still be found in search engines like
> Google.

groups.io offers a transfer service but since they charge based on the 
volume of material, the question is if large projects transferring in 
would hit the chargeable bands quickly. But even moving messages messes 
up the current indexing on google and bing.

Personally I'm not bothered by the search engines as they have not been 
producing sensible results for a long time UNLESS you already know the 
right questions to ask ... which normally means you know the answer 
already. I run searches locally on my email archive and at least have 
the option to tidy that where we have poor material from the past. 
Stripping poor quoting and leaving the useful material. Something that 
the search engines can't help with.

The problem these days is that differing opinions are driving many 
areas, and things seem to change daily affecting things one has been 
doing for a long time. I'm stuck with using Thunderbird simply because 
it can handle the 20+ years of history, although it has been through 
stages when newbies tried to kill off the archival side as 'pointless'. 
YES 99% of the material will probably never be accessed again and I 
should perhaps wipe it, but I'm still dealing with clients who I first 
spoke to in the 80's and their messages are still relevant today and 
while I probably only access a few times a year, it's nice to be able to!

I've said this before but still nothing has changed. It would be nice if 
there was a Firebird powered framework that handled this email traffic 
and linked it with other views of the material. Then the website could 
provide a tidy access to the whole of the archive. It's what I've been 
trying to achieve with my own framework since I switched from C++ to 
PHP, but all the time spent trying to keep up with at times unnecessary 
changes to the rest of the infrastructure has prevented it happening 
YET. Latest problem, Plasma/KDE/Linux was working fine last week, today 
something is leaking memory related to something called 'Baloo' and my 
30Gb of free memory disappears and the desktop becomes unusable. It's 
just happened again while typing this ... so more time to be wasted again :(

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

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

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

On 11/08/18 09:42, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> I'm actually thinking about an accessible archive so they old post
> remain available in some form. But creating a 'just-in-case' backup is
> good idea.
> 
> I'm going to play at that

I have been trying since 2000 :)

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Mailing list change?

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

On 09/08/18 16:42, DougC d...@moosemail.net [firebird-support] wrote:
> In light of the current problem of duplicate messages being sent out, 
> I'd like to bring up the idea of changing platforms from the Yahoo 
> Groups platform. Many other mailing lists I receive used to use Yahoo 
> Groups but have moved elsewhere over the past few years due to recurring 
> issues with Yahoo. I think the Firebird lists are the only ones I 
> subscribe to that have not done this.
> 
> How should we explore this? I this idea of interest to other subscribers 
> or admins?

While yahoo has it's problems, it's use 'email only' works for many of 
us and I for one have dropped lists which have moved to other more web 
based services. I like the way I can come down in the morning and see 
what needs to be dealt with. Even duplicate messages are easy to spot 
and remove leaving me with a tidy archive that goes back to late 90's on 
some lists.

While groups.io have a price list it's not something I will be looking 
to transfer to. All to easy for them to start charging for every list at 
some point ... I've simply dropped the lists that have moved ...

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

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

On 18/07/18 09:50, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> I suggest you take this question to the firebird-devel mailing list as
> it concerns an unreleased version. Questions on FB4 are off topic here.

Although the corner cutting being taken in the current implementation 
should be more widely known! Timezone information will be restricted to 
minute accuracy and not able to handle all transitions correctly! This 
is a major limitation in my book and makes it useless for my own 
historic material!

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] hosting on linux questions

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

On 14/07/18 16:05, Issam Boughanmi amigof...@gmail.com 
[firebird-support] wrote:
> i want to setup a vps to host my web site / application using existing 
> firebird databases
> 
> 1- after some search , it seems that the recommended linux distribution 
> for a web server is centos 7, then ubuntu .
> any feedbacks , recommendations, ideas on this please , and how it 
> behave with firebird ?
I'm still running Suse13.1 on production servers, but have Suse42.3 
configured on the replacement machines. Running basically 'out of the 
box' without any extra packages added, and I'm running nginx, PHP and 
Firebird.

> 2 - i am not really  a linux user , what is the best place/directory  to 
> put the fdb databases ?
I've always worked off /srv so have /srv/firebird/ for the 
databases and /srv/website/ for the web stuff. I also have a cron 
job running which backs up each database every night and stores 5 
backups with the website ... and then mirrors the changes to that to a 
backup machine.

> 3 - i have several databases for differents custumers (20 / 30 or more), 
> can a single firebird server handle many databases correctly ?
No problem ... and a lot easier than the mess MySQL creates when trying 
to isolate multiple users ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Auto-increment generating old ID's for insertion

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

On 03/04/18 06:19, 'Joje' j...@codework-solutions.com [firebird-support] 
wrote:
> SET GENERATOR _ID_GEN TO 16594028

Of cause you only need that to fix the current problem. A set query 
should not exist in the normal code.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Auto-increment generating old ID's for insertion

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

On 02/04/18 13:11, 'Joje' j...@codework-solutions.com [firebird-support] 
wrote:
> I have issue where auto-increment of ID column is generating older ID’s 
> that is already used in table.
> 
> Currently, my transaction table has around 16 million rows and *ID of 
> last inserted row is 16,594,027*.  While the *generator ID its 
> 16,593,965*.  As you can see the generator is generating ID’s that is 
> already present in table which causes *violation of PRIMARY or UNIQUE 
> KEY constraint "INTEG_105"*error on that table.
> 
> I managed to fix this issue, recently I am facing it frequently on this 
> transaction table, majority of the tables had number of records are more 
> than 2 million or there is connectivity issues with DB.
> 
> Now, I am wondering is this related to Firebird DB or is there any other 
> issue.

Assuming that the ID is generated via the normal Firebird method, then 
there is a generator linked with the auto-increment. If the generator 
has been reset for some reason this would explain the current problem. 
Simply setting the generator above the current highest value will fix 
this. However we do need to check out just how the new value is 
generated as well.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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 accounts package ...

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

On 03/02/18 08:53, Lester Caine les...@lsces.co.uk [firebird-support] wrote:
> Anybody got an accounting package powered by Firebird?

OK after some work I've got kMyMoney installed with MySQL and Postgres 
drivers, but there is no pre-compiled Firebird driver for qt4-sql for 
SUSE. Anybody built it or got some pointers to get me down the right 
route to compile it for build 4.8.6 of Qt4 ?

I'm actually having trouble getting the right source file set although 
I've got 4.8.7 source and can see the right files for the plugin ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] Firebird accounts package ...

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

Anybody got an accounting package powered by Firebird? My sage setup 
which I've used for many years has screwed up the database last year and 
while it's possible I can pay to recover it, it's time for a tidy-up of 
15 years of data anyway. I've got CVS dumps of the current 15 years of 
history and I've webERP fired up and looking at the database abstraction 
in that, but anything else around? From the accounting side I'm no 
longer VAT registered so a lot of the need for a full accounting package 
has gone as well, it's just nice to have the supplier and customer 
history, something Sage is not particularly good at anyway ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] What is currently available ...

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

On 07/09/17 11:04, Lester Caine les...@lsces.co.uk [firebird-support] wrote:
> Having be reliant on Interbase and then Firebird since the 90's I have a
> lot of client data stored which I can rely on being available. Early
> systems still use the windows based builder 6 code for some areas, but
> on the whole access is via web based interfaces. I've used PHP5 since
> before it's initial release, and I've many sites working stably and
> reliably under Apache or Nginx into Firebird. I have been maintaining
> ADOdb as much as I can and have a framework which is fairly up to date
> with PHP7.1 but many of my live sites are still running on older
> versions of the stack and framework. The problem is where to go next ...
> 
> I'm running a couple of wordpress sites, but they need MySQL (MariaDB
> being used) and I have OSM services running which need a Postgresql and
> there is little chance of moving them onto Firebird so is it time to
> throw in the towel and move everything over to something that is getting
> more support? I had tikiwiki running with Firebird before forking that
> to a more flexible code base, but tiki as it is now has lost much of
> it's cross database support. TYPO3 looked like an option, but recent
> 'improvement' have lost the Firebird/Interbase port. Is it time to even
> ditch PHP and move to something a lot more stable?
> 
> Just what is currently available as a web site stack on to of Firebird.

Nobody using Firebird for web site content?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] What is currently available ...

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

Having be reliant on Interbase and then Firebird since the 90's I have a
lot of client data stored which I can rely on being available. Early
systems still use the windows based builder 6 code for some areas, but
on the whole access is via web based interfaces. I've used PHP5 since
before it's initial release, and I've many sites working stably and
reliably under Apache or Nginx into Firebird. I have been maintaining
ADOdb as much as I can and have a framework which is fairly up to date
with PHP7.1 but many of my live sites are still running on older
versions of the stack and framework. The problem is where to go next ...

I'm running a couple of wordpress sites, but they need MySQL (MariaDB
being used) and I have OSM services running which need a Postgresql and
there is little chance of moving them onto Firebird so is it time to
throw in the towel and move everything over to something that is getting
more support? I had tikiwiki running with Firebird before forking that
to a more flexible code base, but tiki as it is now has lost much of
it's cross database support. TYPO3 looked like an option, but recent
'improvement' have lost the Firebird/Interbase port. Is it time to even
ditch PHP and move to something a lot more stable?

Just what is currently available as a web site stack on to of Firebird.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Spatial extensions...

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

On 26/08/17 17:01, prosse...@yahoo.com [firebird-support] wrote:
> 
> I'm bored and need a challenge... I'd really like to add spatial support
> to firebird so how do I sign up?   I've been programming in C, C++ and
> Delphi for 30 years and now I can write what I want to write!

It would be nice NOT to have to use postgres/postgis when everthing else
is on Firebird ;)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

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

On 26/04/17 16:34, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
> If Firebird were to convert a record from its stored format through each 
> intervening format, the result would be more logical but it would be a change 
> to a behavior that's over 30 years old. And there are advantages to the 
> current behavior.  If you alter a table in a way that invalidates existing 
> values, another alter table can undo the damage.  
That I think is my main 'objection' here ... having databases that
predate the arrival of Firebird ... if the change to metadata results in
a conflict, then *I* expect to resolve the conflict. Just as if I have
added just a NOT NULL and now need to populate the null fields.

>> The argument that other engines put forward is this idea that a record
>> does not need to store a full set of fields, some can be 'virtual' and
>> only exist when something is stored in them. I HOPE that this is not
>> something that Firebird plans to adopt? In my book the 'original value'
>> is always 'NULL' unless other rules require something replaces it, and
>> an empty field magically showing some default value is not a safe way of
>> working.
> Firebird doesn't store null fields, instead it stores an array of bits that 
> indicate whether or not a field is null.  Between that, compression, and 
> computed fields, there's a lot of magic going on. 
The field in the record indicates if it is null or not, and the metadata
indicates if that field is allowed to be flagged as null. The magic I'm
flagging here is if the field metadata provides a default value, and the
field does not actually store that value, but rather a new flag which
says 'default'. DEFAULT NOT NULL magically displays the current default
value for a null flagged field, while DEFAULT needs the extra flag to
distinguish between a null value and a default one. Returning to the 30
year old standard, once YOU have updated the table with a new value that
will be locked down in the stored records and the idea that a change to
the DEFAULT value will also change OLD default records is simply not
consistent with the way Firebird works?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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 2.5 - Alter table - drop default - bug or feature

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

On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> The SQL standard is quite clear at what needs to happen: adding a new 
> column with a default should behave as if that column has existed from 
> the original create table (btw: irrespective of the NOT NULL constraint, 
> something that if I'm not mistaken also Firebird doesn't do correctly).

Exactly the problem in my book. If you add 'DEFAULT' without a 'NOT
NULL', then in my book the unpopulated fields should remain NULL unless
I populate them. When you now add creating the field later then things
should be consistent but there is no consistent way of handling things
based on the SQL standard inconsistencies.

> This has the effect that all existing records should get the default 
> value as if they had that value from the start (either stored or 
> virtual). It also means that a subsequent alteration of the default (new 
> value or dropping the default), should not lead to changes to the value 
> of those rows that existed before the column was added with; the columns 
> need to retain the original default.

The argument that other engines put forward is this idea that a record
does not need to store a full set of fields, some can be 'virtual' and
only exist when something is stored in them. I HOPE that this is not
something that Firebird plans to adopt? In my book the 'original value'
is always 'NULL' unless other rules require something replaces it, and
an empty field magically showing some default value is not a safe way of
working.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

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

On 25/04/17 12:51, Maxi maxiroba...@gmail.com [firebird-support] wrote:
> I expect the value assigned by DEFAULT  when I add the new field is
> still there.

There has been various discussions on this area ...

If you add 'NOT NULL' to an existing field, then you need to populate
the existing fields with a value in the absence of a default. In my book
the existing records start the update for adding a new field with simple
new null records, and FROM A GOOD PRACTICE VIEW I would expect to
populate these empty fields under my control, so the idea that adding
the 'DEFAULT' to a field THEN populates existing fields 'magically' is
wrong, and the way the 'magic' bit would work depends on the order you
process things anyway.

It's not a 'bug' but rather preference and I'm with SET that the process
should include a managed UPDATE rather than a magic one ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] ezSQL/Wordpress

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

On 09/03/17 11:23, 'Alan McDonald' a...@meta.com.au [firebird-support]
wrote:
> I use ezSQL with Firebird
> Excellent, as long as you use my version :-0
> Happy to give it to you
Yes please - thought someone would have used it ;)

> I use it in conjunction with ez_results - grid browser - my version - also 
> you can have
I only need it to drop into wordpress and see what the damage is to make
it work with Firebird. My own systems have been based on ADOdb for
years. Just expanding the framework with a more powerful form system
with better browser end validation to replace the old server based
validation :)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] ezSQL/Wordpress

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

I've picked up a client who has his website on wordpress which is MySQL
only. The database is only 60Mb as a raw SQL dump but still took the
best part of an hour to restore via 'mysql-workbench' so not the best
response for backup between machines.

Now I though ezSQL supported Firebird? I'll clone it from github later
and see which is in history, but has anybody looked at this area recently?

It will probably be faster and easier simply to move the wordpress
content over to my own framework. At least I can also then address all
the todo items a hell of a lot quicker, but there are a number of
potential clients and moving all is impractical, so fixing the wordpress
seems the better option.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Migrating a 2.5 server

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

On 07/02/17 08:14, Luke Crooks l...@solentwholesale.com
[firebird-support] wrote:
> When running the 2.5 server on our Windows DC and having clients access
> from the local network, performance was very slow (almost unusable). We
> are using a safescan product (Time Attendance +) which uses a firebird
> database. So to combat this, I first tried serving the file locally on a
> machine and accessing it this way, no performance issues here.
> 
> So I then had the idea that it could be that our windows server has to
> much load already, so I installed firebird on our onsite dedicated SQL
> server (this server is much quicker by comparison, 8 cores, 32GB of ram
> and runs postgres for us with loads of resources to spare). So I
> installed firebird on this SQL server (FreeBSD), configured the software
> to point to the new database, and yet again the performance is awful,
> does anyone have an idea what might be causing such slow speeds when
> connecting to a database locally? I can't see the firewall blocking
> anything and have given full access to port 3050, thanks.

I have a similar sort of legacy product which started life on a local
windows box at each site and eventually progressed to running via a
remote Linux server with local windows clients. Some sites we had
problems with slow connection times, and it was invariably due to the
network configuration. Looking up IP addresses from machine names which
is not something that should be a problem, but switching those sites to
use static IP addresses invariably sorted things out.

But since TA+ seems to be running as a windows client application, it
may be having fun with some of the more recent developments in Windows
OS. So what version of Windows are you running on? I would expect
Safescan to provide updates to cope with the M$ aspects of their product
since they are charging for it ;) My client interfaces moved to web
based 15 odd years ago to remove THAT management problem ... and
Firebird continues to provide a response time in the fractions of a
second on my systems.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Time zones

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

On 12/01/17 14:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Can someone point me in the right direction please?

There have been many attempts to justify storing a time stamp complete
with timezone directly in a time field, but the real answer is that it
is always wrong. Store location data in addition to a UTC time stamp and
that way you can always display a correct time, and more importantly
correctly move a time when passing over a DST change. The one thing that
is missing from the 'offset' supplied by a browser is any means of
identifying if the offset will be the same next month. You need to know
the correct time zone and not just the current offset which is why a
time with an offset may be wrong half of the year.

Another piece of the jigsaw is the problem of identifying what the
current offset data is in relation to a timezone. If you have created a
UTC normalized time and have a timezone which gives you an offset, then
the DST rules change, you will only know of the change if you have
recorded the version of the rule set you normalised the time with, and
the current rule set. So timezone/version is the additional data that
should be recorded once working with UTC normalized times.

And if you are running a system supporting several time zones then the
server clock should always be set to UTC time. Trying to calculate UTC
then Local time from a server time that may also have DST variations
creates no end3of edge cases :) Store all times as UTC unless you are
ONLY working with one timezone, but even that is tricky if your time
zone uses DST ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Overflow problem

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

On 25/11/16 14:11, fabia...@itbizolutions.com.au [firebird-support] wrote:
> Are you trying to store details of the American public debt? or the world's 
> public debt? Just kiding Not

See other post ;)
It is vulnerability to overflow edge cases that are the potential
problem - especially in MySQL and I believe much less so in Firebird

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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] Overflow problem

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

On 25/11/16 13:56, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 2016-11-25 12:40, Lester Caine les...@lsces.co.uk [firebird-support] 
> wrote:
>> > Nothing to do with Firebird but can anybody explain why the numbers in
>> > 'SELECT FIRST 102121121121212 SKIP 3574239239242420' would be a problem
>> > in MySQL or is it some other vulnerability the original sQL injection
>> > was trying to hit. I know I need to add limit checks in the code which
>> > reprocessed the SQL but it quite happily 'white screens' the vast
>> > majority of MySQL injection attempts so I'm just need to make sure 
>> > there
>> > is nothing that WOULD affect Firebird adversely.
> That number is too big to fit in an int, could explain the problem
> 
> BTW: You might want to look for other solutions if you need to skip and 
> fetch that many records, it is not really efficient ;)

You are missing the point Mark ... This SQL has come about from a PHP
SQL injection attack. I don't need it to 'work'. I was trying to get a
handle on the vulnerability they were trying to exploit on MySQL incase
the results may be a problem. The ACTUAL SQL is only spanning a few
hundred pages and is handled via parameters. This SQL was the result of
manually added SQL in the raw fields.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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] Overflow problem

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

Nothing to do with Firebird but can anybody explain why the numbers in
'SELECT FIRST 102121121121212 SKIP 3574239239242420' would be a problem
in MySQL or is it some other vulnerability the original sQL injection
was trying to hit. I know I need to add limit checks in the code which
reprocessed the SQL but it quite happily 'white screens' the vast
majority of MySQL injection attempts so I'm just need to make sure there
is nothing that WOULD affect Firebird adversely.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Digest Number 9396 (Temporary Tables)

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

On 22/11/16 07:09, tiberiu_horv...@yahoo.com [firebird-support] wrote:
> I have code that uses temporary tables in at least 30 places in my
> programs. This is the way I did complicated queries. Most of these
> procedures are written 10 years ago (Interbase, Firebird 1.0). I cannot
> change everything (replace every query that uses temporary tables),
> cannot do this without proper testing. 

A lot of my code is come up on 20 years old and in the IB/FB1 days it
was a case that one had to build temporary tables in order to speed up
some report processes. Today those queries are a lot more efficient
using CTE queries ad removing the need for managing temporary tables. I
totally accept that the time taken to undertake changes may seem a waste
when things are working, but it is worth the time to pick them off over
time ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] problem - change autoincrement fields to identity fields

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

On 18/11/16 11:03, Nico Speleers - Carfac BVBA nico.spele...@carfac.com
[firebird-support] wrote:
> But I want to use identity fields because such fields don't uses a generator 
> and a trigger.

Putting this a different way ... the correct way of ensuring where
multiple users are adding records which require a unique ID, SQL
introduced SEQUENCE which is the same thing as the Interbase generator
which pre-dates it. So a reliable 'identity' or 'auto-increment' field
is simply a wrapper for sequence or generator. I prefer access to the
trigger to allow more than a simple 'get next number' but if you prefer
to hid it fine. That is all you are doing by changing the code used ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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] Missing something ...

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

OK I've put a new machine together using the latest builds via SUSE
which has given me Nginx, PHP7 and Firebird3. Firebird is working
locally and after a couple of problems Nginx and PHP7 are talking since
they package manager did not complete the configuration.

Now I need to configure FB3 so that it can be accessed from the other
machines on the network which are still running 2.1 and 2.5 and will be
for some time to come. I've done the 'Legacy Authentication' settings,
but I'm still not able to log in from FlameRobin on another machine.

It's a little confusing since SYSDBA existed and I've reset the password
to one of my normal ones (suse is using isql-fb to avoid clash with
mysql) but I'm getting to the point where I need something working and
the 'improvements' in FB3 seem to be fighting against that. :( I've gone
through the same setup on a machine which has a desktop, but flamerobin
dies on that machine so I'm no further forward ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Vulnerability

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

On 27/09/16 19:01, Carlos Mazariegos carlosemazarieg...@gmail.com
[firebird-support] wrote:
> The vulnerability that reported Palo Alto is:
>  
> 
>   * *Unique Threat Id:* 31633
>   * *Descriptión:* Ther exists a buffer overflow vulnerability in
> Borland Interbase server.

Which has nothing to do with Firebird and it's CURRENT code base!

http://www.h-online.com/security/news/item/Buffer-overflow-vulnerability-in-Firebird-database-733053.html
was cleared in early versions of Firebird 2.0

An other overflow was cleared in 2.1 and back ported to 2.0.4
http://www.h-online.com/security/news/item/Vulnerability-in-Firebird-database-735909.html


But this is all several years out of data. I don't know of any CURRENT
vulnerability still awaiting fixing in the ode base.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

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

On 13/09/16 11:09, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> I tried to create new topic in firebird-php but it is getting list, not
> visible. :((

On all the yahoo lists the fist posts are moderated. It's up now ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

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

On 13/09/16 06:30, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> But it looks like from the Yii2 code that select and insert...returning
> is handled alike in the PHP Data Objects. Can it be possible that
> Firebird PDO driver deviates from the official PDO interface. Who
> develops pdo_firebird.dll and is it possible to adapt is behavior?

As Helen has indicated firebird-php list is the right place for
discussions on the php drivers, but we COULD do with the help of the
wider Firebird community in improving and more critically ensuring
firebird drivers remain available in php.

There is currently no official maintainer of the drivers and personally
I don't use the PDO version simply because the PDO architecture was
always wrong. The interbase generic driver still works fine, but with
FB3 out it is probably time to finally split the firebird version to
it's own package. Something that needs help from the 'c' coders more
than the 'php' ones :(

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Transaction in limbo

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

On 19/07/16 11:14, michael.vilhelm...@microcom.dk [firebird-support] wrote:
> As I read about 2 phase commits, its about 2 databases. We do not use
> more than one
Application with two connections to the same database? That may not be
so easy to spot if you don't have full access to the code.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

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

On 11/03/16 13:06, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> As quoted in the documentation in my previous mail, Windows only guarantees 
> updates of the timestamps when the handle is closed.

Which has been the case in windows for 20 years. It is only M$ who could
'fix' this, but as said updating the file details for every write will
only further slow the process.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] FirebridSQL and Log´s

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

On 12/02/16 19:14, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> I am thinking about the better/faster/easier way to log changes made in 
> records on the tables of my DB.
> 
> Could someone share experience (good or bad)? Any suggestion?

http://www.upscene.com/database_auditing/firebird_and_interbase/ works
perfectly and well worth the money ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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 3.0 RC1 - SQL optimization help

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

On 24/01/16 08:04, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr
[firebird-support] wrote:
> I needed some time to understand (at least try to understand) your post. 
> Please, note that my SQL knowledge is very limited. I really don’t know 
> internals of database any system. Though, I need to develop an application 
> which can use Firebird, Interbase, MSSQL, MySQL, Oracle. Some of users 
> databases may be Firebird, others MSSQL, and an Oracle maybe. User decides 
> what to use.

I currently develop projects using PHP which users access via a web
browser. I've used a library called ADOdb since day one, and this
massages a large section of the SQL into a format that can be used by
any of the large number of databases it supports. It also has a meta
data management tool that allows a generic table description to be used
to provide metadata changes cross database. All one has to ensure is
that field and table names are not reserved words across all the
database engines that are being used.

It may not be something you can use, but it will provide an insight as
to how it can be done.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] The PHP default transaction

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

On 21/01/16 10:44, Tim Ward t...@telensa.com [firebird-support] wrote:
> (1) Is this likely to be the "default transaction" that PHP creates for 
> a connection if you don't do an explicit start transaction? Ie, does PHP 
> create the default transaction for a connection even if you never use it 
> (rather than create it on first use, as one might have hoped)?
> 
> (2) What, if anything, is the import of a transaction being marked 
> "inactive"? Does an "inactive" transaction still freeze the various 
> transaction counters and hold up garbage collection?
> 
> (3) If the answer to (2) is that the existence of this transaction *is* 
> a potential performance problem, I imagine I can get rid of it simply by 
> doing "ibase_commit();" at the start of the PHP script?

Sorry Tim ... have been out and about and needed to sit down to expand
on this. Should probably be a discussion for the firebird-php list, but
I think we do need some help from the 'experts' to establish what the
default setup on the PHP driver should be. The PDO driver seems to have
a few problems as well, but I don't find that as flexible due to it's
trying to make even databases without transactions look like ones that
do have them.

I've been using ADOdb since day one for my abstraction layer and this
has allowed borrowing from projects that were only written for other
engines. I've also ported a few bits to Firebird simply by converting
them to ADOdb. I've got a ported version of the adodb-firebird driver
which also uses the fbird_ aliases and is better matched to the firebird
metadata SQL

My starting point ... which seems to work
$this->ibasetrans = IBASE_WAIT | IBASE_REC_VERSION | IBASE_COMMITTED;
Rather than the default
IBASE_WRITE | IBASE_CONCURRENCY | IBASE_WAIT

But I would appreciate some feedback as to how this fits with later
versions of Firebird. I was running fb1.0 and 1.5 when I started using
this :)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Extract seconds from timestamp

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

On 06/01/16 08:37, 'Bogdan' bog...@mordicom.si [firebird-support] wrote:
> I wonder if this is an error or sql srandard:
> 
> select cast(extract(second from cast('12.12.2016 23:59:59:9000' as
> timestamp)) as integer) from rdb$database

http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-extract.html
Check the notes;)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] 2 servers acessing one database

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

On 16/12/15 15:19, Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support] wrote:
> What I mean is using 2 servers to connect to the same DB.
> This DB is in a shared disk that both servers can access.
> So I would have, for example, 100 clients connecting on server 1, another 100 
> clients on server 2, but both accessing the same shared database.

The quick answer is no, since one server instance must be able to manage
access to the data, so access on shared devices is specifically blocked.
In the situation you describe we have each server providing it's own
copy of the data, but most users are only reading the data, so making
sure a write is replicated across both is easy.

Just what are you managing data wise as that will determine just what
advise to give next?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: How to make Sphinx work with Firebird on Linux?

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

On 13/11/15 14:22, hv...@users.sourceforge.net [firebird-support] wrote:
> Patch was updated but not announced:
> 
> http://web.firebirdsql.org/download/sphinx/
> 
> You should get Sphinx sources, apply patch and make by yourself on CentOS

Little problem Vlad ... 2.2.9 is not actually available, not tried yet
but will the patch work with 2.2.10?

http://sphinxsearch.com/downloads/release/
Archive jumps to 2.2.8 :(

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: How to make Sphinx work with Firebird on Linux?

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

On 13/11/15 16:23, hv...@users.sourceforge.net [firebird-support] wrote:
>> ---In firebird-support@yahoogroups.com,  wrote :
>>
>> On 13/11/15 14:22, hvlad@...  [firebird-support] wrote:
> 
> > > Patch was updated but not announced:
> > > 
> > > http://web.firebirdsql.org/download/sphinx/
> > >
> > > You should get Sphinx sources, apply patch and make by yourself on
> CentOS
> 
> > Little problem Vlad ... 2.2.9 is not actually available, not tried yet
> 
>> but will the patch work with 2.2.10?
> 
>   I'll check but i don't expect issues with sorce code patch. What could
> be a problem - not updated
> patch for Linux build.

OK source code patch worked OK even with the different file offsets, but
the firebird.linux.patch is a little more problematic.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

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

On 22/09/15 10:31, Glenn Thomas Hvidsten g...@vensafe.no
[firebird-support] wrote:
> Thanks for all the suggestions so far.
> We have already put some of our clients computers on UPS. I'm still 
> interested in other settings we can enable (or disable) to make the database 
> server more robust without having to add a UPS.

This brings back a few memories from 20 years ago. Has a site that kept
loosing the whole days data after working perfectly during the day, and
printing off the reports. This was back in Interbase days ;) It took a
couple of weeks and a bit of luck to spot the cleaner pulling the plug
marked 'do not remove' so she could plug in her vacuum! She just reached
around the corner without even looking and pulled the first plug she
felt. Pigging annoying, and a hard wired supply was arranged, but why
did ALL the data go you should be asking? Windows was caching the writes
to disk and did not ACTUALLY write anything until the program was
closed! EVEN with 'forced writes' switched on. Forget which version of
windows now but probably W3.1. We added some extra code and started
closing the program after a report run and things were then stable
enough that one could pull the plug during the day and restart without
only an occasional corruption.

We moved most sites onto XP early on in it's life, and that just ran and
ran even with the occasional power loss. Would I trust modern windows to
be as reliable ... NO ... since moving to W7 sites all have at least one
problem a month even with UPS's! I've had to repair a database more than
once and have lost data so I think at least on Windows one is stuck with
the risk ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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 Server on Windows 10

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

On 11/09/15 21:29, Mike Ro miker...@gmail.com [firebird-support] wrote:
>> On a more radical solution, try installing your firebirdsql to a
>> folder NOT in Program Files. 
>>
> Yes, this solves it!
> 
> So it is definitely a permissions thing, but I haven't been able to find
> out what yet.

Interesting. Seems I did the right thing without knowing ...
I've always put apache, php and firebird in their ow base directory
'c:\Network' originally to get away from the proelms cayse by the
'space' in 'Program Files'. But I've obviously it a winning setup
because the W10 install just worked for me!

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: Hex string literal, blob not supported for conversion?

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

On 31/08/15 16:07, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support] wrote:
> Nevertheless, the parameter is BLOB. Why is one blob conversion supported,
> but an other, that looks the same to the user, fails?

Martijn ... I always thought that the 'blob' in a function had to be an
existing blob element i.e. a field in an existing table, so trying to
upload a static variable in the first example is wrong as it does not
exist as a blob, while your insert is converting the static variable
into a format that can be stored in the identified blob. Your blob
function needs the field name of the blob you want to work with?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: Using events with php

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

On 26/08/15 19:48, dmil...@amfes.com [firebird-support] wrote:
 You're correct - but I'm trying to follow an example I saw.

I think what you are missing perhaps is that the added ID on the example
is allowing the client to only monitor events for a particular ID. So
the client asks to see 'changes_for_fred' rather than seeing
'changes_for' and then having to ask the database who it was intended
for ... which is what the second example does.

You need to know the full name of each of the event you are looking for.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk






++

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: ODP: [firebird-support] Taking database back from v2.5 ODS11.2 to v2.1 ODS11.1

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

On 07/08/15 06:30, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
 Why do you need to go back?

There is still a lot of code in use that will not run with 2.5 and
running both versions can be a bit of a nightmare. I've restored on the
wrong machine myself while looking to do some data processing locally
and had to roll back for the site.

Neil ... you are using the right process, and I'm not sure why your
particular error. The one's I've hit just needed some data deleting
after saving as insert statements which can be reapplied on the 2.1
build. It does sound as if you have done something to the database which
is V2.5 specific which will be more of a problem to role back :(

I still have V1.5 on one site simply because it does it's job :)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Proper way for copy data from big table

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

On 19/06/15 14:20, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
 SELECT FIRST 100 SKIP 0 * FROM SOURCE_TABLE -we got 100 reads - ok
 SELECT FIRST 100 SKIP 100  * FROM SOURCE_TABLE -we got 200
 reads - not ok
 SELECT FIRST 100 SKIP 200  * FROM SOURCE_TABLE -we got 300
 reads - not ok worser and worser (slower and slower)

Why would you expect any better when you are reading the data raw, and
it has to count all of the records you want to skip.

You need an index of some sort on the data so that there is at least
some way of finding a record in the middle of the list. A simple
generator based ID number, or a timestamp is all you need to reduce the
time taken to find the starting point of the block you want to use.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] Dragging things up to date ...

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

OK just been going around in circles trying to find notes on converting
from NONE to UTF8 and not getting anywhere ...

Historically I've always been happy with NONE, but these days all the
web site traffic is UTF8 so I think it's time to start tidying up, and
so I THINK I need to switch the default to UTF8. Although the UTF8 data
seems to be getting stored fine under NONE ... or has that just been
luck until now. All the metadata is simple 7 bit ASCII, so it's only
text content that matters.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] performance on calculated fields - performance question

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

On 29/04/15 21:40, shg_siste...@yahoo.com.ar [firebird-support] wrote:
 With 40.000 records, I have no problem with this. But do you think it
 will be very bad as the customers keep growing?
 
 I mean, generally speaking, it's expensive (regarding to the speed) to
 have calculated fields??

The calculated fields don't actually exist in the database. They are
created when a record is accessed. What would be better in your case is
to create the calculated field in a trigger and add it to the record.
That way the data can be indexed and searched like any other field.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Revert DB to previous version

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

On 18/03/15 17:37, sboyd...@gmail.com [firebird-support] wrote:
 If I understand what you are saying, you want me to copy gbak.exe for
 2.0.5 to the 2.1 system and use the 2.0.5 gbak to back up the 2.1
 database using the 2.1 Firebird service. Correct?

Spot on ...
But it will not work if you have added any '2.1' features since it was
upgraded. If only data has been played with it shouldd work fine.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] I don´t receive my messages

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

On 20/01/15 19:49, Eduardo guse...@gmail.com [firebird-support] wrote:
 Yesterday I sent an e-mail to the list but I didn´t receive it. I
 received other mails from the list but didn´t receive my own message.
 
 Today I received an answer to my message and I sent a new mail. Again I
 didn´t received my own message.

There are various switches on the yahoogroups but while other services
do have a switch for mirroring your own posts I don't think that has
made it to yahoogroups yet. So as others have indicated it may be your
email client which is modifying behaviour. Presumably you can see the
messages in the on-line listing.

CURRENTLY I have an irritating problem with Thunderbird where on some
yahoo lists it correctly displays the sender in the from column, but on
this and a number of lists all I get is the list name 'firebird-support'
against every message. The format of the header was changed with one of
the 'upgrades' to yahoo last year but I've still not worked out how to
fix Thunderbird, and from other lists I have had the information that
THEIR copies of Thunderbird give names fine.

This is not a simple - so and so is wrong - problem ... and I now have
alternate email addresses to get around some of the niggles.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Stability on newer windows ...

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

On 24/11/14 11:59, marcus mar...@antiphasis.net [firebird-support] wrote:
 I did a full backup and restore to the databases but JUSThad
  
  WDZP (Server) Mon Nov 24 10:26:52 2014
  Database: HISTORY
  internal gds software consistency check (cannot find tip page (165),
  file: tra.cpp line: 2494)
 Such errors will more like point to
 - problems with the harddisk
 - problems with cache logic
 - problems with the hdd/raid controller
 than Windows Updates.
 Or were there active connections while installing updates and rebooting
 the computer?

Still nursing this machine and I am perhaps coming around to a hardware
fault although everything tests OK.

I'm getting
gds__detatch: Unsuccessful detach from database
with a large batch of 10054 error all with the same timestamp.

Happened twice today, but there were security related entries in the
event log at the same time. It's that this suddenly started on the 11th
after many months of perfect performance.

Now - 10054 I keep thinking of as a network error, but it's reset
connections! Why would there be so many when I only have a small number
of users? Looks like the problem is between Firebird and Apache/PHP as
the connections do not seem to be clearing ... I'd not even thought to
check that since I've not changed MY software since the machine was set
up. PHP should be reusing the same connection so there should never be
more than a few active users.

At last something to work with, and since I can restart Apache during
the day I can perhaps prevent a hickup when perhaps there are too many
connections.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Stability on newer windows ...

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

On 19/11/14 18:18, Fabiano Kureck - Desenvolvimento SCI
fabi...@sci10.com.br [firebird-support] wrote:
 Try using the 32 bit version of Firebird, maybe this can help you.

Run 32bit Firebird 2.1.6 with 32bit apache and php but it is unfortunate
a 64bit version of Windows7 which is all that was available at the time :(

SINCE last week, there have been a number of windows updates culminating
in a 151Mb download from the 11th Nov which is titled 'System Update
Readiness Tool' and is described as being designed to fix problems with
the update process which has resulted in problem with updates getting
stuck! Exactly the problem we have been having and date wise this fits
as well. Took 25 minutes to run it and now the 'update' status is
actually showing 'up to date' which it last did a month ago.

I did a full backup and restore to the databases but JUSThad

WDZP (Server)   Mon Nov 24 10:26:52 2014
Database: HISTORY
internal gds software consistency check (cannot find tip page (165),
file: tra.cpp line: 2494)

This is the first message since it reset on Saturday!

I am now looking to put new hardware in, but WHAT should I put on it
software wise to be sure of stability. If we did not need the
announcements it would be Linux, but on this site I am stuck with
windows of some sort :(

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] Stability on newer windows ...

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

My systems have run for many years on XP and W2k without any problems,
but now I'm being forced to upgrade systems on sites to a later version
of windows, I'm hitting problems. I'm having to live with both Windows 7
and 8.1, fortunately 8 is black listed like vista. I've had problems
with windows update and still have two machines which are 'stuck' at an
old update, but reason for message ...

One of my customers has FB2.1 running on W7 which was upgraded last year
and has a clean firebird log up until 10th November when it started to
grow hourly ...

Various errors including
gds__detach: Unsuccessful detach from database
10053, 10054 and 10061

Machine has been rebooted, databases backed up and restored, apart from
an update for IE10 which will not install everything is up to date.

ANY ideas ... bearing in mind I have to get their IT department to do
anything security wise.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Stability on newer windows ...

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

On 19/11/14 17:15, Fabiano Kureck - Desenvolvimento SCI
fabi...@sci10.com.br [firebird-support] wrote:
 
 Currently, FB 2.1 is lo longer supported as older OSs. Maybe your
 problem was corrected in a newer FB version as FB 2.5.3 (that corrects a
 bug of caching on 64 bit Windows by example).
 IMHO, you need to switch to the lasted Firebird (2.5.3) and try again.

Should have added that I am now unable to recompile the code base for
the application software and that will not work with 2.5 :( It has been
working fine for a year now and it's only the last few days that this
problem has arisen. The ONLY change is pigging 'windows update' and I've
finally had an OK to disable them since the machines have no internet
access anyway and even IE10 is not needed on the machines.

 My systems have run for many years on XP and W2k without any problems,
 but now I'm being forced to upgrade systems on sites to a later version
 of windows, I'm hitting problems. I'm having to live with both Windows 7
 and 8.1, fortunately 8 is black listed like vista. I've had problems
 with windows update and still have two machines which are 'stuck' at an
 old update, but reason for message ...

 One of my customers has FB2.1 running on W7 which was upgraded last year
 and has a clean firebird log up until 10th November when it started to
 grow hourly ...

 Various errors including
 gds__detach: Unsuccessful detach from database
 10053, 10054 and 10061

 Machine has been rebooted, databases backed up and restored, apart from
 an update for IE10 which will not install everything is up to date.

 ANY ideas ... bearing in mind I have to get their IT department to do
 anything security wise.


-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] Hack attempts ...

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

One of my sites is being hit with an attempt to hack into it or at least
that is what I assume. The following SQL is being added where they think
it will get processed

+AND+(SELECT+8041+FROM(SELECT+COUNT(%2A),CONCAT(0x3a6f79753a,(SELECT+(CASE+WHEN+(8041%3D8041)+THEN+1+ELSE+0+END)),0x3a70687a3a,floor(rand(0)%2A2))x+FROM+INFORMATION_SCHEMA.CHARACTER_SETS+GROUP+BY+x)a)+AND+(7609%3D7609
---probably truncated?

I can see traffic about INFORMATION_SCHEMA.CHARACTER_SETS being missing
and people needing to update to MySQL 5, but I am a little curious as to
what this is trying to achieve?

Needless to say my framework does not allow any injections like this to
be processed anyway. It's just creating a lot of traffic on the error
log and if it persists I'll add some handling and create a page saying
why Firebird does not suffer from that vulnerability ;)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: Hack attempts ...

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

On 20/09/14 10:51, map...@gmail.com [firebird-support] wrote:
 
 Seems to be an automated bot that tries to takeover the server something
 inspired by sqlmap
 
 https://github.com/sqlmapproject/sqlmap
 
 or phpmvs 
 http://sourceforge.net/projects/phpmvs/
 
 some of the takeover attempts are useless on a firebird system 
 
 sqlmapproject/sqlmap
 https://github.com/sqlmapproject/sqlmap/blob/master/plugins/dbms/firebird/takeover.py

Interesting ...
Of cause it fails miserably when it's injecting into parameters anyway :)

Since it claims to be able to identify Firebird has anybody actually
seen it do anything but cause error messages? It obviously has no idea
what underlies the sites it's trying to hack?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

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

On 14/09/14 09:25, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
 And still both myapp.exe and IB_SQL.exe give Database unavailable
  message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :(

 Ok, so you don't have the error with your own application (myapp.exe), 
 but with IB_SQL.exe? Is your own application running at that time? What 
 is IB_SQL.exe?

IB_SQL is the IBObjects admin tool ...

Adam - try Flamerobin http://www.flamerobin.org/ ... this is a little
more helpful in it's error messages. But I do wonder if you have another
fbclient.dll  that is being found first. I only ever run server
versions, but sometimes it plays up when an older client is found.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

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

On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote:
 Engine Code  :335544721
 Engine Message:
 Unable to complete network request to host localhost
 Failed to establish connection.
 
 So yes FlameRobin provides more information but still I cannot
 understand why

This means that your machine does not have the network configured
properly. Quite a common problem with windows these days. SO the next
question is ... is this machine actually on a network? If so
http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does
may help ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

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

On 14/09/14 13:20, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
 On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] 
 wrote:
 On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote:
 Engine Code  :335544721
 Engine Message:
 Unable to complete network request to host localhost
 Failed to establish connection.

 So yes FlameRobin provides more information but still I cannot
 understand why

 This means that your machine does not have the network configured
 properly. Quite a common problem with windows these days.
 
 A common problem? I don't actually think so. The question you link to 
 below is also not very informative; and that is problem is probably more 
 related to the fact that by default localhost resolves to ::1 (IPv6) 
 instead of 127.0.0.1 (IPv4).

That 'localhost' has been a recurring problem in the past is a simple
fact. I've got notes on this list from many years back about trying the
machines IP address rather than localhost when there are windows
connection problems.

   SO the next
 question is ... is this machine actually on a network? If so
 http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does
 may help ...
 
 The original question is about use of embedded. The fact that it is 
 attempting to connect through localhost means that a hostname 
 (localhost) is included in the connection string, which results in 
 fbembed.dll acting as a normal fbclient, instead of using its internal 
 server to access the database.
 
 The real question is if this happens because the application itself 
 specifies the hostname, or because the connection component 
 automatically adds localhost if no hostname is specified.

Adam had switched to Flamerobin and it was this which gave the more
useful error report. Flamerobin certainly defaults to using localhost so
the alternative track IS the alternate ways of accessing 'embedded', and
I thought Flamerobin tested them - but obviously I'm mistaken? I did
think localhost would access a local embedded client? But it has been
some considerable time since I actually used it.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

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

On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote:
 1 - Running my app results in the following error message:
 
 [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll].
 Hint: check it is in the PATH or application EXE directories, and has
 x86 bitness.
 
 I've checked and it is in both the PATH and app EXE directory.
 Not at all sure how to check that it has x86 bitness.

OK the other windows problem creeping in ...
You said originally 'Windows 8' which I would anticipate being 64 bit?
If the test application was compiled as '64bit' then you will also need
a 64bit version of Firebird. Otherwise you need the 32bit build ...
which may account for your earlier results as the deleted versions may
have been the right 'bittyness' and being picked up rather then the
renamed embedded one in your folder :(

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

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

On 14/09/14 14:00, Adam adam...@gmail.com [firebird-support] wrote:
 Otherwise you need the 32bit build ...
 which may account for your earlier results as the deleted versions may
 have been the right 'bittyness' and being picked up rather then the
 renamed embedded one in your folder :(
 
 Right on the money Lester ell done. As I just tried the win32
 embeded and it works as expected. Although now I need to getFlame Robin
 working and I just posted in my previous reply a question on this.

I'm not sure on that one so I'll leave it to someone else to answer. I
only run with a server setup, and Firebird is normally on a Linux box
these days, but there is no reason that an embedded client could not run
with a database as long as the server is not also accessing the same
database file. It's the access that is restricted to a single user in
the embedded case.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

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

On 14/09/14 14:34, Adam adam...@gmail.com [firebird-support] wrote:
 Just tested it and all works fine. FlameRobin uses the FireBird running
 in background process and yes as long as the database is not being
 concurrently accessed all works fine.
 
 Thank you o much for giving your time to my problem, much appreciated.

We do need to do some more up to date beginners guides for the windows
stuff. My last one was done for 32 bit XP :)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] Strange date values

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

I thought I'd save some time by spending some money on XMLWizard to do
some CSV imports of data sets ... rather than pulling together my own
PHP scripts. It seems to work well enough on Windows, but I could not
get the Linux version working.

But the problem I've found is that while the date import is set to Y-m-d
and the raw data is in exactly the same format, evey date value is
displaying with the month replaced by a capital N - I did not even think
that Firebird could do that? Running into 2.5.2 on one of the Linux
boxes. Have reported it to GuacoSoft but I wonder if the problem is with
Flamerobin displaying it?

OK - thinking out loud works ... the date format on this machine was set
to Y-N-D rather than Y-M-D ... fixed that now :)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Data Partitioning with Firebird

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

On 06/08/14 02:41, Nigel Weeks nigel.we...@karbonit.com.au
[firebird-support] wrote:
 I've been using Firebird for years, but mainly keeping a very low profile.
 
 I'm planning a Health Informatics project with the University of
 Tasmania, and as I've used Firebird to power all the other projects, I'm
 planning on using it again.
 
 The question I have is about data partitioning across servers.
 Essentially, we're wanting 10 servers to handle the backend - not
 because it can't do it with one, but we need to show that the DB can
 scale (investors love clusters).
 
 Initially, as every table is based on bigint primary keys, I could have
 server 0 handling every record ending in a zero(0,10,20,etc), with
 duplicated table structures on top.
 
 The middle layer handles the MapReduce, determining which server to ask
 for data, and combining data sets(reducing) for the app on top. (No,
 it's not BigData, just an entity mapping layer).
 
 When it comes to data partitioning across servers, what other strategies
 have people done?

I keep looking at this problem and always seem to come back to a 2 level
system. Sort of like 'telephone directory' and 'data store'. All servers
have the telephone directory, and the primary key for each entry is
essentially two 32 bit numbers creating the BIGINT value. That should
cope with just about anything? The telephone directory has all the
lookup data such as National Insurance number, passport number and the
like, and once you have the primary key then you know where to go to
pick up the rest of the data. It is a 'cloud' in the sense that every
service point will have it's own local data archive, and that can be
replicated to other data stores and the 'telephone directory' will know
if there are alternate copies of the data that can be accessed should
the primary one be off line.

I think that Firebird's backup strengths makes this something Firebird
should excel at? Replicating or simply cloning material as required?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Re: AV in fbembed.dll_unloaded

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

On 02/08/14 14:11, tobias_subscri...@tgtools.com [firebird-support] wrote:
 Wow, many thanks! I can't believe it ... and there is not a trace of
 this in IBO? Very strange ... so I need to grab IBO's DLL handle and get
 the function address myself, OK ... I can do it ... but I am still shocked.

Tobias
Most of us are using firebird with servers, so we don't need to worry
about starting and stopping it. As far as I was aware, all that is
needed with IBO is to close the connection to the database before
closing the program. So if something has changed with 2.5 we may not
even have found it yet ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

[firebird-support] Yahoo broken again?

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

I've just been trying to access the list on-line, but it would seem
yahoo have broken everything again? Keeps coming back that the redirect
can not complete?

Is the 'VISIT YOUR GROUP' below working for anybody?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Yahoo broken again?

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

On 27/06/14 09:16, Lester Caine les...@lsces.co.uk [firebird-support] wrote:
 I've just been trying to access the list on-line, but it would seem
 yahoo have broken everything again? Keeps coming back that the redirect
 can not complete?
 
 Is the 'VISIT YOUR GROUP' below working for anybody?

OK - logged out of yahoo an back in and I could get at groups again :)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Database Too Large.

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

On 27/06/14 08:43, 'stefano.mala...@gmail.com' stefano.mala...@gmail.com
[firebird-support] wrote:
 i run SAM Brodcaster (Webradio Automation Software) with firebird
 database. I've a big problem because SAMDB.FDB increase day after day in
 an exaggerated way.
 After 150 days of running the db size is 200 Mb !! Someone in SAM
 Broadcaster forum said to me that is a garbage problem..
Well adding 200Mb each day should not cause a problem.

 Because if i need to restart my program it freeze when reading a Db so
 large. So i need to ricreate a new one looosing all of my data !!!
 The correct dbsize is about 7/10 Mb !
 Could you tell me how can i do to decrease the db size ??
 There is a tool to delete the garbage data..?
You do not say what software you are using to access the database. It's
this which is leaving older records which are not being allowed to clear.
I presume if you do a backup and restore you end up with a 10Mb
database? A bigger database size is not a problem if the older records
are allowed to be reused, a growing database can be tidied but it's the
accessing software that actually needs fixing.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] loading data from a .csv file?

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

I process mine through php ;) 
Although I have dropped mysql data as simple insert  data.
It would perhaps be nice as an option in flamerobin

Sent from my android device so the quoting is crap!

-Original Message-
From: Alan Shank li...@notoriousshankbrothers.com [firebird-support] 
firebird-support@yahoogroups.com
To: firebird-support@yahoogroups.com
Sent: Thu, 22 May 2014 20:46
Subject: [firebird-support] loading data from a .csv file?

Is there some way to load data into a table in Firebird, like LOAD DATA 
INFILE... in Mysql? I have comma-delimited files from Mysql that I want 
to load into Firebird tables.


I have Firebird2.5-super on Ubuntu 14.04, 64-bit.
Thanks,
Alan Shank
Woodland, CA



Posted by: Alan Shank li...@notoriousshankbrothers.com


++

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

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

++
Yahoo Groups Links