Perfect
Sent from Yahoo Mail. Get the app
On Wednesday, July 27, 2016 8:28 AM, "ehmmm.fireb...@seznam.cz
[firebird-support]" <firebird-support@yahoogroups.com> 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]
<firebird-support@yahoogroups.com>
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:#0000ff;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 .yiv5635814332attach img
{border:none;padding-right:5px;}#yiv5635814332 .yiv5635814332attach label
{display:block;margin-bottom:5px;}#yiv5635814332 .yiv5635814332attach label a
{text-decoration:none;}#yiv5635814332 blockquote {margin:0 0 0
4px;}#yiv5635814332 .yiv5635814332bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5635814332
.yiv5635814332bold a {text-decoration:none;}#yiv5635814332 dd.yiv5635814332last
p a {font-family:Verdana;font-weight:700;}#yiv5635814332 dd.yiv5635814332last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5635814332
dd.yiv5635814332last p span.yiv5635814332yshortcuts
{margin-right:0;}#yiv5635814332 div.yiv5635814332attach-table div div a
{text-decoration:none;}#yiv5635814332 div.yiv5635814332attach-table
{width:400px;}#yiv5635814332 div.yiv5635814332file-title a, #yiv5635814332
div.yiv5635814332file-title a:active, #yiv5635814332
div.yiv5635814332file-title a:hover, #yiv5635814332 div.yiv5635814332file-title
a:visited {text-decoration:none;}#yiv5635814332 div.yiv5635814332photo-title a,
#yiv5635814332 div.yiv5635814332photo-title a:active, #yiv5635814332
div.yiv5635814332photo-title a:hover, #yiv5635814332
div.yiv5635814332photo-title a:visited {text-decoration:none;}#yiv5635814332
div#yiv5635814332ygrp-mlmsg #yiv5635814332ygrp-msg p a
span.yiv5635814332yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5635814332
.yiv5635814332green {color:#628c2a;}#yiv5635814332 .yiv5635814332MsoNormal
{margin:0 0 0 0;}#yiv5635814332 o {font-size:0;}#yiv5635814332
#yiv5635814332photos div {float:left;width:72px;}#yiv5635814332
#yiv5635814332photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5635814332
#yiv5635814332photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5635814332
#yiv5635814332reco-category {font-size:77%;}#yiv5635814332
#yiv5635814332reco-desc {font-size:77%;}#yiv5635814332 .yiv5635814332replbq
{margin:4px;}#yiv5635814332 #yiv5635814332ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5635814332 #yiv5635814332ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5635814332
#yiv5635814332ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5635814332
#yiv5635814332ygrp-mlmsg select, #yiv5635814332 input, #yiv5635814332 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5635814332
#yiv5635814332ygrp-mlmsg pre, #yiv5635814332 code {font:115%
monospace;}#yiv5635814332 #yiv5635814332ygrp-mlmsg *
{line-height:1.22em;}#yiv5635814332 #yiv5635814332ygrp-mlmsg #yiv5635814332logo
{padding-bottom:10px;}#yiv5635814332 #yiv5635814332ygrp-msg p a
{font-family:Verdana;}#yiv5635814332 #yiv5635814332ygrp-msg
p#yiv5635814332attach-count span {color:#1E66AE;font-weight:700;}#yiv5635814332
#yiv5635814332ygrp-reco #yiv5635814332reco-head
{color:#ff7900;font-weight:700;}#yiv5635814332 #yiv5635814332ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5635814332 #yiv5635814332ygrp-sponsor
#yiv5635814332ov li a {font-size:130%;text-decoration:none;}#yiv5635814332
#yiv5635814332ygrp-sponsor #yiv5635814332ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5635814332
#yiv5635814332ygrp-sponsor #yiv5635814332ov ul {margin:0;padding:0 0 0
8px;}#yiv5635814332 #yiv5635814332ygrp-text
{font-family:Georgia;}#yiv5635814332 #yiv5635814332ygrp-text p {margin:0 0 1em
0;}#yiv5635814332 #yiv5635814332ygrp-text tt {font-size:120%;}#yiv5635814332
#yiv5635814332ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5635814332
