Re: [firebird-support] from FB 2.5.2 to 2.5.6 and C application
Can you create a bug on http://tracker.firebirdsql.org/browse/CORE
Mark
On 27-7-2016 08:28, ehmmm.fireb...@seznam.cz [firebird-support] wrote:
>
>
> Adding some notes:
>
> Examples stat3.e and stat5.e from /opt/firebird/examples/stat/ don't
> work, while stat2.e works.
> I'm getting the same -901 "request synchronization error".
>
> Steps to reproduce:
>
> Extract somewhere FirebirdCS-2.5.6.27020-0.i686.tar.gz
> "su" to be root.
> Run install.sh, creates backup, ask for password.
> Replace /opt/firebird/security2.fdb with symlink to reallife security2.fdb.
> Get /etc/init.d/firebird from somewhere.
> service firebird start
>
> cd /opt/firebird/examples/stat
> cp ../include/example.h .
> /opt/firebird/bin/gpre -d employee.fdb stat2.e
> export ISC_USER=sysdba
> export ISC_PASSWORD=...
> export ISC_DATABASE=employee.fdb
> cc -lfbclient stat2.c -o stat2
> ./stat2
> (Same for stat3.e and stat5.e)
>
> Like I said, in FB 2.5.6 stat3 and stat5 throw error.
> If I do the same with FB 2.5.5 then these examples work.
>
>
> -- Původní zpráva --
> Od: ehmmm.fireb...@seznam.cz [firebird-support]
>
> Komu: firebird-support@yahoogroups.com
> Datum: 26. 7. 2016 20:46:58
> Předmět: [firebird-support] from FB 2.5.2 to 2.5.6 and C application
>
>
>
>
> Hi,
> we have server with Debian 6.0 squeeze and there we have Firebird
> 2.5.2 (superclassic) which sometimes hangs and I don't know why.
> So my idea was to install there FB 2.5.6.
> I downloaded FB 2.5.6 superclassic i686 (debian is amd64 but
> previous firebird seems to be i686 so I decided to continue using
> i686) tar.gz, extracted it and executed install.sh.
> I think I was quite successful. I didn't make backups of *.fdb
> files, I only copied older security2.fdb into /opt/firebird and
> copied some init script from /opet/firebird/misc into /etc/init.d
> My PHP webapges work well, my Python apps work well, FlameRobin
> works well.
> The only problem I have with some old C programs running on the same
> server, precompiled via GPRE utility.
> These C apps fail for example on then line (just example) EXEC SQL
> FETCH cur_al...:
>
> int i, id, status;
>
> EXEC SQL CONNECT DB USER '...' PASSWORD '...';
> EXEC SQL SET TRANSACTION READ WRITE WAIT ISOLATION LEVEL READ COMMITTED;
>
> EXEC SQL DECLARE cur_al CURSOR FOR SELECT id_blabla, status FROM blabla;
>
> EXEC SQL OPEN cur_al;
> while(SQLCODE == 0) {
> EXEC SQL FETCH cur_al INTO :id, :status;
> if (SQLCODE == 0) { ... }
> }
>
> EXEC SQL CLOSE cur_al;
>
> ...
>
> It throws error -901 and messages "Unsuccessful execution caused by
> system error that does not preclude successful execution of
> subsequent statements" and "request synchronization error".
>
> I'm not author of these C apps and I'm not very skilled in C on
> linux, I only found some Makefile so I tried run "make". But it
> didn't help.
>
> What should I try? Should I look somewhere for some libraries?
>
> The most interesting for me is that when I download and install FB
> 2.5.5 or 2.5.4 (I must admit that upgrading/downgrading firebird
> inside 2.5.x is quite easy) then these C apps seems to work
> correctly. (?) Is there any explanation for this?
>
> =
>
>
>
>
> =
--
Mark Rotteveel
Re: [firebird-support] from FB 2.5.2 to 2.5.6 and C application
Perfect
Sent from Yahoo Mail. Get the app
On Wednesday, July 27, 2016 8:28 AM, "ehmmm.fireb...@seznam.cz
[firebird-support]" wrote:
Adding some notes:
Examples stat3.e and stat5.e from /opt/firebird/examples/stat/ don't work,
while stat2.e works.
I'm getting the same -901 "request synchronization error".
Steps to reproduce:
Extract somewhere FirebirdCS-2.5.6.27020-0.i686.tar.gz
"su" to be root.
Run install.sh, creates backup, ask for password.
Replace /opt/firebird/security2.fdb with symlink to reallife security2.fdb.
Get /etc/init.d/firebird from somewhere.
service firebird start
cd /opt/firebird/examples/stat
cp ../include/example.h .
/opt/firebird/bin/gpre -d employee.fdb stat2.e
export ISC_USER=sysdba
export ISC_PASSWORD=...
export ISC_DATABASE=employee.fdb
cc -lfbclient stat2.c -o stat2
./stat2
(Same for stat3.e and stat5.e)
Like I said, in FB 2.5.6 stat3 and stat5 throw error.
If I do the same with FB 2.5.5 then these examples work.
-- Původní zpráva --
Od: ehmmm.fireb...@seznam.cz [firebird-support]
Komu: firebird-support@yahoogroups.com
Datum: 26. 7. 2016 20:46:58
Předmět: [firebird-support] from FB 2.5.2 to 2.5.6 and C application
Hi,
we have server with Debian 6.0 squeeze and there we have Firebird 2.5.2
(superclassic) which sometimes hangs and I don't know why.
So my idea was to install there FB 2.5.6.
I downloaded FB 2.5.6 superclassic i686 (debian is amd64 but previous firebird
seems to be i686 so I decided to continue using i686) tar.gz, extracted it and
executed install.sh.
I think I was quite successful. I didn't make backups of *.fdb files, I only
copied older security2.fdb into /opt/firebird and copied some init script from
/opet/firebird/misc into /etc/init.d
My PHP webapges work well, my Python apps work well, FlameRobin works well.
The only problem I have with some old C programs running on the same server,
precompiled via GPRE utility.
These C apps fail for example on then line (just example) EXEC SQL FETCH
cur_al...:
int i, id, status;
EXEC SQL CONNECT DB USER '...' PASSWORD '...';
EXEC SQL SET TRANSACTION READ WRITE WAIT ISOLATION LEVEL READ COMMITTED;
EXEC SQL DECLARE cur_al CURSOR FOR SELECT id_blabla, status FROM blabla;
EXEC SQL OPEN cur_al;
while(SQLCODE == 0) {
EXEC SQL FETCH cur_al INTO :id, :status;
if (SQLCODE == 0) { ... }
}
EXEC SQL CLOSE cur_al;
...
It throws error -901 and messages "Unsuccessful execution caused by system
error that does not preclude successful execution of subsequent statements" and
"request synchronization error".
I'm not author of these C apps and I'm not very skilled in C on linux, I only
found some Makefile so I tried run "make". But it didn't help.
What should I try? Should I look somewhere for some libraries?
The most interesting for me is that when I download and install FB 2.5.5 or
2.5.4 (I must admit that upgrading/downgrading firebird inside 2.5.x is quite
easy) then these C apps seems to work correctly. (?) Is there any explanation
for this?
=
= #yiv5635814332 #yiv5635814332 -- #yiv5635814332ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5635814332
#yiv5635814332ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5635814332
#yiv5635814332ygrp-mkp #yiv5635814332hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5635814332 #yiv5635814332ygrp-mkp #yiv5635814332ads
{margin-bottom:10px;}#yiv5635814332 #yiv5635814332ygrp-mkp .yiv5635814332ad
{padding:0 0;}#yiv5635814332 #yiv5635814332ygrp-mkp .yiv5635814332ad p
{margin:0;}#yiv5635814332 #yiv5635814332ygrp-mkp .yiv5635814332ad a
{color:#ff;text-decoration:none;}#yiv5635814332 #yiv5635814332ygrp-sponsor
#yiv5635814332ygrp-lc {font-family:Arial;}#yiv5635814332
#yiv5635814332ygrp-sponsor #yiv5635814332ygrp-lc #yiv5635814332hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5635814332
#yiv5635814332ygrp-sponsor #yiv5635814332ygrp-lc .yiv5635814332ad
{margin-bottom:10px;padding:0 0;}#yiv5635814332 #yiv5635814332actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5635814332
#yiv5635814332activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5635814332
#yiv5635814332activity span {font-weight:700;}#yiv5635814332
#yiv5635814332activity span:first-child
{text-transform:uppercase;}#yiv5635814332 #yiv5635814332activity span a
{color:#5085b6;text-decoration:none;}#yiv5635814332 #yiv5635814332activity span
span {color:#ff7900;}#yiv5635814332 #yiv5635814332activity span
.yiv5635814332underline {text-decoration:underline;}#yiv5635814332
.yiv5635814332attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5635814332 .yiv5635814332attach div a
{text-decoration:none;}#yiv5635814332 .yiv5635814332atta
Re: [firebird-support] from FB 2.5.2 to 2.5.6 and C application
Adding some notes:
Examples stat3.e and stat5.e from /opt/firebird/examples/stat/ don't work,
while stat2.e works.
I'm getting the same -901 "request synchronization error".
Steps to reproduce:
Extract somewhere FirebirdCS-2.5.6.27020-0.i686.tar.gz
"su" to be root.
Run install.sh, creates backup, ask for password.
Replace /opt/firebird/security2.fdb with symlink to reallife security2.fdb.
Get /etc/init.d/firebird from somewhere.
service firebird start
cd /opt/firebird/examples/stat
cp ../include/example.h .
/opt/firebird/bin/gpre -d employee.fdb stat2.e
export ISC_USER=sysdba
export ISC_PASSWORD=...
export ISC_DATABASE=employee.fdb
cc -lfbclient stat2.c -o stat2
./stat2
(Same for stat3.e and stat5.e)
Like I said, in FB 2.5.6 stat3 and stat5 throw error.
If I do the same with FB 2.5.5 then these examples work.
-- Původní zpráva --
Od: ehmmm.fireb...@seznam.cz [firebird-support]
Komu: firebird-support@yahoogroups.com
Datum: 26. 7. 2016 20:46:58
Předmět: [firebird-support] from FB 2.5.2 to 2.5.6 and C application
"
Hi,
we have server with Debian 6.0 squeeze and there we have Firebird 2.5.2
(superclassic) which sometimes hangs and I don't know why.
So my idea was to install there FB 2.5.6.
I downloaded FB 2.5.6 superclassic i686 (debian is amd64 but previous
firebird seems to be i686 so I decided to continue using i686) tar.gz,
extracted it and executed install.sh.
I think I was quite successful. I didn't make backups of *.fdb files, I only
copied older security2.fdb into /opt/firebird and copied some init script
from /opet/firebird/misc into /etc/init.d
My PHP webapges work well, my Python apps work well, FlameRobin works well.
The only problem I have with some old C programs running on the same server,
precompiled via GPRE utility.
These C apps fail for example on then line (just example) EXEC SQL FETCH cur
_al...:
int i, id, status;
EXEC SQL CONNECT DB USER '...' PASSWORD '...';
EXEC SQL SET TRANSACTION READ WRITE WAIT ISOLATION LEVEL READ COMMITTED;
EXEC SQL DECLARE cur_al CURSOR FOR SELECT id_blabla, status FROM blabla;
EXEC SQL OPEN cur_al;
while(SQLCODE == 0) {
EXEC SQL FETCH cur_al INTO :id, :status;
if (SQLCODE == 0) { ... }
}
EXEC SQL CLOSE cur_al;
...
It throws error -901 and messages "Unsuccessful execution caused by system
error that does not preclude successful execution of subsequent statements"
and "request synchronization error".
I'm not author of these C apps and I'm not very skilled in C on linux, I
only found some Makefile so I tried run "make". But it didn't help.
What should I try? Should I look somewhere for some libraries?
The most interesting for me is that when I download and install FB 2.5.5 or
2.5.4 (I must admit that upgrading/downgrading firebird inside 2.5.x is
quite easy) then these C apps seems to work correctly. (?) Is there any
explanation for this?
=
"=
[firebird-support] from FB 2.5.2 to 2.5.6 and C application
Hi,
we have server with Debian 6.0 squeeze and there we have Firebird 2.5.2
(superclassic) which sometimes hangs and I don't know why.
So my idea was to install there FB 2.5.6.
I downloaded FB 2.5.6 superclassic i686 (debian is amd64 but previous
firebird seems to be i686 so I decided to continue using i686) tar.gz,
extracted it and executed install.sh.
I think I was quite successful. I didn't make backups of *.fdb files, I only
copied older security2.fdb into /opt/firebird and copied some init script
from /opet/firebird/misc into /etc/init.d
My PHP webapges work well, my Python apps work well, FlameRobin works well.
The only problem I have with some old C programs running on the same server,
precompiled via GPRE utility.
These C apps fail for example on then line (just example) EXEC SQL FETCH cur
_al...:
int i, id, status;
EXEC SQL CONNECT DB USER '...' PASSWORD '...';
EXEC SQL SET TRANSACTION READ WRITE WAIT ISOLATION LEVEL READ COMMITTED;
EXEC SQL DECLARE cur_al CURSOR FOR SELECT id_blabla, status FROM blabla;
EXEC SQL OPEN cur_al;
while(SQLCODE == 0) {
EXEC SQL FETCH cur_al INTO :id, :status;
if (SQLCODE == 0) { ... }
}
EXEC SQL CLOSE cur_al;
...
It throws error -901 and messages "Unsuccessful execution caused by system
error that does not preclude successful execution of subsequent statements"
and "request synchronization error".
I'm not author of these C apps and I'm not very skilled in C on linux, I
only found some Makefile so I tried run "make". But it didn't help.
What should I try? Should I look somewhere for some libraries?
The most interesting for me is that when I download and install FB 2.5.5 or
2.5.4 (I must admit that upgrading/downgrading firebird inside 2.5.x is
quite easy) then these C apps seems to work correctly. (?) Is there any
explanation for this?
=
