Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
> 12.02.2014 23:03, Vlad Khorsun wrote: >> Probably. But it is easy to isolate your application from customer's >> environment >> and make it use your private copy of fbclient.dll + firebird.msg. > > Yes. And as the result to get "private environment" incompatible with the > rest of > system that leads to application failure. This is the task for your installer to make your application's environment to be compatible with already installed other software. Because nobody knows needs of your application except of you. > The simplest example: if I provide application with private copy of FB 2.5 > client, it > will fail to work with FB 3.0 set by default. So, provide application with private copy of FB3 client (if you are claim to be compatible with fb3), what is the problem ? > Let alone MSVC runtime issues and the fact that the customer may not using > Firebird at all. Again, this is task for you and your installer to check what Firebird version is already used and so on. Please, provide real sample of the task you can't solve using existing facilities and we will think how to improve it. But stop make false statements. Regards, Vlad -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution ofpackage-based stored procedure
> Hello, > > when I execute a stored procedure which is part of a package with e.g.: > > select * from pkg_schema.s_user_tables; > > I guess, it would make sense to also have the package name somewhere in > the trace output for the EXECUTE_PROCEDURE_* event. Does this make sense? Good point. I think it makes sense. I'll look at it (a bit later). Would you like to see procedure name prefixed with package name (PACKAGE.PROCEDURE) or is there better suggestions ? Regards, Vlad -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution ofpackage-based stored procedure
13.02.2014 12:23, Vlad Khorsun wrote: > > Good point. I think it makes sense. I'll look at it (a bit later). Would you > like to > see procedure name prefixed with package name (PACKAGE.PROCEDURE) This would be consistent with the rest of the codebase, so IMHO it should be done this way. Dmitry -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] pyfirebirdsql can't authenticate with Firebird 3.0 (SRP issues)
On 02/13/14 04:52, Hajime Nakagami wrote:
> Thanks Marius and others.
>
> I'm trying to implement SRP protocol by pure python.
> But something wrong in my python codes, I know.
>
> I have found RemotePassword::getUserHash() return different value with
> getUserHash() in srp.py.
> https://github.com/nakagami/pyfirebirdsql/blob/master/firebirdsql/srp.py#L143
>
> For example ...
>
> [Modified source:firebird/src/auth/SecureRemotePassword/srp.cpp]
> BigInteger RemotePassword::getUserHash(const char* account, const char*
> salt, const char* password)
> {
> hash.reset();
> hash.process(account);
> hash.process(":");
> hash.process(password);
> UCharBuffer hash1;
> hash.getHash(hash1);
> dumpIt("getUserHash() account", account);
> dumpIt("getUserHash() salt", salt);
> dumpIt("getUserHash() password", password);
> dumpIt("getUserHash() hash1", hash1);
>
> hash.reset();
> hash.process(salt);
> hash.process(hash1);
> UCharBuffer hash2;
> hash.getHash(hash2);
> dumpIt("getUserHash() hash2", hash2);
> BigInteger rc;
> hash.getInt(rc);
> dumpIt("getUserHash() rc", rc);
>
> return rc;
> }
>
> [Result]
> getUserHash() account: 'SYSDBA'
> getUserHash() salt:
> '2E26880300079A478A70002D1A697900026E1601C00054F'
> getUserHash() password: 'masterkey'
> getUserHash() hash1
> e3 95 79 9c 56 52 aa a4 53 62 73 a2 0a a7 40 e2 46 83 5c c4
> getUserHash() hash2
> 98 0c 1c 90 a1 be 65 5f 31 09 3f 56 a9 ef 5c e7 c0 4b 26 2f
> getUserHash() rc: '4DD084A42814499F781537C24753291235DE797C'
>
>
> I think rc seems to be
> 980c1c90a1be655f31093f56a9ef5ce7c04b262f(868036694467267200852895567621828944633719891503L)
> But it is '4DD084A42814499F781537C24753291235DE797C' (equal to
> 0x4DD084A42814499F781537C24753291235DE797C ?)
>
> I don't realize how to convert from hash2 to rc.
> Please let me know the algorithm
>
You should not call Sha1::getSomething() more than once - it's
destructive operation.
Look here. Mentioned fragment of code is:
BigInteger rc;
hash.getInt(rc);
dumpIt("getUserHash::rc", rc);
hash.getInt(rc);
dumpIt("getUserHash::rc", rc);
Output:
getUserHash::rc: '980C1C90A1BE655F31093F56A9EF5CE7C04B262F'
getUserHash::rc: '4DD084A42814499F781537C24753291235DE797C'
It's not hard to make it be callable many times but I see no actual need.
A.
--
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 0:38, Leyne, Sean wrote: > How so, you create your own install which create a \client folder underneath > your application folder. > > You can install: > > - your application into the application folder > - firebird.msg into the application folder > - FBCLient.dll into the application\client folder You forgot couple of things: - MSVC runtime required by fbclient.dll - configuration file compatible with target server of unknown version which can be on completely different host > Then your application can load the fbclient using the application as the > starting point. Right. But I don't like support job. Now, when I see a "client library cannot be loaded" or "unavailable database" problem, I can say "it is Firebird install problem, go to Firebird support". If I had provided my own copy of Firebird client, I would have to investigate every case when "my" client cannot be loaded on customer's OS or is unable to work with customer's server. Too much dumb work in an alien language. -- WBR, SD. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4337) gfix makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
gfix makes "reconnect" when it is removed from mon$attachments by delete
command (issued in another window)
---
Key: CORE-4337
URL: http://tracker.firebirdsql.org/browse/CORE-4337
Project: Firebird Core
Issue Type: Bug
Components: GFIX
Affects Versions: 3.0 Alpha 2
Reporter: Pavel Zotov
Attachments:
gdb-gfix-unsuccessful-detach-via-delete-from-mon_attachments.zip,
trace-when-gfix-unsuccessful-detach-via-delete-from-mon_attachments.zip
Scenario.
1) create new database with default page size (4096), make FW = OFF
2) run the following DDL (exactly in NON-interactive mode, i.e. ISQL
path/database -i script.sql):
recreate table t(id int primary key, s01 varchar(36) , s02 varchar(36) , s03
varchar(36) );
commit;
create index t_s01 on t(s01);
create index t_s02 on t(s02);
create index t_s03 on t(s03);
commit;
set term ^;
execute block as
begin
begin
execute statement 'create sequence g';
when any do begin end
end
end^
set term ;^
alter sequence g restart with 0;
commit;
-- 5'000'000 ==> 1700Mb, ~7 min
set stat on;
set term ^;
execute block as
declare n int = 500;
begin
while (n>0) do
insert into t(id, s01, s02, s03)
values( :n +iif( mod(:n,1000)=0, 0*gen_id(g,1000), 0),
uuid_to_char(gen_uuid()),
uuid_to_char(gen_uuid()),
uuid_to_char(gen_uuid())
) returning :n-1 into n;
end^
set term ;^
set echo on;
commit;
select count(*) from t;
delete from t;
commit;
set echo off;
show version;
show database;
set echo on;
exit;
/* this script leads to lot of garbage versions that should be removed later by
gfix -sweep */
3) create simple script to non-interactive gathering of stack trace info (I
gave name "gdb_backtrace_batch.script" to it):
thread apply all bt full
quit
yes
4) create auxiliary .sql script that will attempt to remove attach of gfix from
mon$attachments:
-- file: gfixkill_eb.sql
set list on;
select * from mon$database;
commit;
set term ^;
execute block returns(dts_before timestamp, deleted_attach_id int , dts_after
timestamp) as
begin
dts_before=cast('now' as timestamp);
deleted_attach_id=-1; -- if remains to this value then no gfix attachment was
found
for
select mon$attachment_id
from mon$attachments
where mon$remote_process containing 'gfix'
into
deleted_attach_id
as cursor
tcur
do
delete from mon$attachments where current of tcur;
dts_after=cast('now' as timestamp);
suspend;
end^
set term ;^
set stat off;
set echo on;
show database;
commit;
exit;
5) create main .sh (to be run under linux shell):
# file: gfixtest.sh
clear
fbhome=/opt/fb30trnk
fbport=
fbname=firebird
dbname=/var/db/fb30/gfixtest30.fdb
gdb_batch_file=./gdb_backtrace_batch.script
delay=20
i=1
killall -9 gfix 2>/dev/null
echo $(echo -n $(date +'%Y-%m-%d %H:%M:%S.%N')|cut -c1-24) sweep starting:
set -x
###
$fbhome/bin/gfix -sweep localhost/$fbport:$dbname &
###
set +x
fbpid=$(ps aux|grep /opt/fb30trnk/bin/firebird|grep -v grep|awk '{print $2}')
gfixpid=$(ps aux|grep $fbhome/bin/gfix|grep -v "defunct\|grep"|awk '{print $2}')
echo +++
echo alive \"gfix -sweep\" process: $gfixpid, firebird process: $fbpid
echo +++
ps $gfixpid
echo gather initial stacktrace of running gfix...
gdb -q -x $gdb_batch_file $fbhome/bin/gfix $gfixpid 1>logs/gfix_started_$(date
+'%y%m%d_%H%M%S').gdb.txt 2>&1
gdb -q -x $gdb_batch_file $fbhome/bin/$fbname $fbpid
1>logs/firebird_when_gfix_started_$(date +'%y%m%d_%H%M%S').gdb.txt 2>&1
echo done:
ls -l logs/*.gdb.txt
while :
do
gfixpid=$(ps aux|grep $fbhome/bin/gfix|grep -v "defunct\|grep"|awk '{print
$2}')
echo . . . . . . . . . . . iter N $i . . . . . . . . . . . . . .
echo before isql: alive gfix process: \>\>\> $gfixpid \<\<\<
echo $(echo -n $(date +'%Y-%m-%d %H:%M:%S.%N')|cut -c1-24) now wait $delay
seconds before killing it...
sleep $delay
echo
echo $(echo -n $(date +'%Y-%m-%d %H:%M:%S.%N')|cut -c1-24) attempt to detach
gfix process...
set -x
$fbhome/bin/isql localhost/$fbport:$dbname -i gfixkill_eb.sql
set +x
echo $(echo -n $(date +'%Y-%m-%d %H:%M:%S.%N')|cut -c1-24) result of attempt
$i to detach gfix: check that there is NO alive gfix pid:
# again!
gfixpid=$(ps aux|grep $fbhome/bin/gfix|grep -v "defunct\|grep"|awk '{print
$2}')
if [ -n "$gfixpid" ]; then
echo after isql: alive gfix process: \>\>\> $gfixpid \<\<\<
echo $(echo -n $(date +'%Y-%m-%d %H:%M:%S.%N')|cut -c1-24) starting gather
stacktrace for gfix and firebird processes.
gdb4gfixlog=logs/gfix_alive_$(date +'%y%m%d_%H%M%S').gdb.txt
gdb4fblog
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 9:19, Vlad Khorsun wrote: > Please, provide real sample of the task you can't solve using existing > facilities and we will > think how to improve it. As I wrote in ticket: fbclient.dll installed into system directory produces unreadable error messages because of absence firebird.msg nearby. Firebird installer provides no way to make client library available for loading by LoadLibrary() without full path AND keep error messages produces by it readable WITHOUT breaking up any other existing Firebird installation. -- WBR, SD. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
On Thursday 13 February 2014 16:39:41 Dimitry Sibiryakov wrote: > 13.02.2014 9:19, Vlad Khorsun wrote: > > Please, provide real sample of the task you can't solve using > > existing facilities and we will think how to improve it. > >As I wrote in ticket: fbclient.dll installed into system directory > produces unreadable error messages because of absence firebird.msg nearby. >Firebird installer provides no way to make client library available for > loading by LoadLibrary() without full path AND keep error messages produces > by it readable WITHOUT breaking up any other existing Firebird > installation. Have you tried setting FIREBIRD_MSG? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 19:39, Dimitry Sibiryakov wrote: > As I wrote in ticket: fbclient.dll installed into system directory produces > unreadable > error messages because of absence firebird.msg nearby. Do you mean really unreadable or actually readable but prefixed with "cannot locate firebird.msg"? Example maybe? Dmitry -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
> 13.02.2014 0:38, Leyne, Sean wrote: > > How so, you create your own install which create a \client folder > underneath your application folder. > > > > You can install: > > > > - your application into the application folder > > - firebird.msg into the application folder > > - FBCLient.dll into the application\client folder > >You forgot couple of things: > > - MSVC runtime required by fbclient.dll There is a distributable for that, which can be incorporated into a install kit. > - configuration file compatible with target server of unknown version which > can be on completely different host I have never had to modify a config file in order to use a remote server. > > Then your application can load the fbclient using the application as the > starting point. > >Right. But I don't like support job. This sounds like "sour grapes" -- that is what a developer is supposed to do! Sean P.S.Technically, Firebird project does not provide a client-only install kit. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 16:51, Dmitry Yemanov wrote: > Do you mean really unreadable or actually readable but prefixed with > "cannot locate firebird.msg"? Example maybe? Actually, half-readable. There may be meaningfil lines as well as prefixed with "can't format message". Example: unknown ISC error 335544973 can't format message 13:1 -- message file C:\Program Files (x86)\IBPhoenix\firebird.msg not found -- WBR, SD. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 16:48, Paul Reeves wrote: > Have you tried setting FIREBIRD_MSG? Do you mean from my application before calling LoadLibrary()? No. I have no idea what value I would have to assign to it. -- WBR, SD. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 16:56, Leyne, Sean wrote: > There is a distributable for that, which can be incorporated into a install > kit. This is the way to nowhere. And at the end of this way is staying Exadata: rented black box with no access to inside. Unfortunately, the nature of my application does not allow such solution. > I have never had to modify a config file in order to use a remote server. Be prepared for changes after migration to 3.0. >> >Right. But I don't like support job. > This sounds like "sour grapes" -- that is what a developer is supposed to do! May be. But I prefer to hunt my own bugs only, not bugs in third-party libraries. That's why my installer installs only my software. -- WBR, SD. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution ofpackage-based stored procedure
>> Good point. I think it makes sense. I'll look at it (a bit later). Would you >> like to >> see procedure name prefixed with package name (PACKAGE.PROCEDURE) > > This would be consistent with the rest of the codebase, so IMHO it > should be done this way. Sounds good. Thank you, Thomas -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
On Thursday 13 February 2014 17:06:32 Dimitry Sibiryakov wrote: > 13.02.2014 16:48, Paul Reeves wrote: > > Have you tried setting FIREBIRD_MSG? > >Do you mean from my application before calling LoadLibrary()? Yes. >No. I have no idea what value I would have to assign to it. I'm still not quite sure what the actual real world problem is that you are trying to solve, but if it is a problem I would solve it by shipping a copy of firebird.msg with the application. Then if it proves impossible to locate the installed copy of firebird.msg I would set the env var. to the one shipped with my application. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
> 13.02.2014 16:51, Dmitry Yemanov wrote:
>> Do you mean really unreadable or actually readable but prefixed with
>> "cannot locate firebird.msg"? Example maybe?
>
> Actually, half-readable. There may be meaningfil lines as well as prefixed
> with "can't
> format message". Example:
>
> unknown ISC error 335544973
> can't format message 13:1 -- message file C:\Program Files
> (x86)\IBPhoenix\firebird.msg
> not found
ISC error code 335544973 is isc_bad_epb_form ("Unrecognized events block").
Its facility code is 0 (JRD). Text messages for all errors of facility 0 are
included into
firebird.dll and used if firebird.msg is not found.
This error code (isc_bad_epb_form) was intorduced in FB 2.5 and it means
you are
used older fbclient.dll with your application when obtained this error from
Firebrid server.
Also it means that firebird.msg corresponding to your old client library also
have no
text for this error and even if it would be found (as you wish here) it give
you nothing in
this case.
Regards,
Vlad
PS "can't format message 13:1 ... "you got when you are try to get SQL code.
This is generic "Firebird error" message which you can append to any "unknown"
error ;)
--
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
> 13.02.2014 9:19, Vlad Khorsun wrote: >> Please, provide real sample of the task you can't solve using existing >> facilities and we will >> think how to improve it. > > As I wrote in ticket: fbclient.dll installed into system directory produces > unreadable > error messages because of absence firebird.msg nearby. 1. Microsoft explicitly prohibited to put anything into system folders (since Vista, iirc). So forget about this (Firebird files in system folders), period. 2. Do you have *real* sample of what you *can not* do using existing well known ways ? So far i see only what you *do not want* to do. I can suggest you to hire programmer in this case :) > Firebird installer provides no way to make client library available for > loading by > LoadLibrary() without full path AND keep error messages produces by it > readable WITHOUT > breaking up any other existing Firebird installation. Write your own installer or improve Firebird installer in a way you need. Lucky you - it is written not using "alien language" Regards, Vlad -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 22:02, Vlad Khorsun wrote: > This error code (isc_bad_epb_form) was intorduced in FB 2.5 and it means > you are > used older fbclient.dll with your application when obtained this error from > Firebrid server. > Also it means that firebird.msg corresponding to your old client library also > have no > text for this error and even if it would be found (as you wish here) it give > you nothing in > this case. At first, this message was produced by 2.5 client. At second, the message become completely readable after copying firebird.msg _by hand_ because instclient didn't do that automatically. At last, thanks, I already know how to decode such cryptic messages. The ticket says exactly "WTF I have to decrypt it from sources". -- WBR, SD. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution ofpackage-based stored procedure
>>> Good point. I think it makes sense. I'll look at it (a bit later). Would >>> you like to >>> see procedure name prefixed with package name (PACKAGE.PROCEDURE) >> >> This would be consistent with the rest of the codebase, so IMHO it >> should be done this way. > Sounds good. Check next snapshot build, please Regards, Vlad -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 22:11, Vlad Khorsun wrote: > 1. Microsoft explicitly prohibited to put anything into system folders (since > Vista, iirc). Proof, please. "Not recommended" and "explicitly prohibited" - two big differences, you know. System folder is the only place where a _shared_ (do you remember what word "shared" means?..) library with corresponding bitness can be found by windows automatically, without ugly hacks. Once again: keeping _shared_ library in application folder is not an option. > 2. Do you have*real* sample of what you*can not* do using existing well > known ways ? If you mean "using well known workarounds", then - no, I can workaround every bug. But it will be ugly and fail in well predictable cases. -- WBR, SD. -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4338) Max Size of VARCHAR / CHAR in Table ad StoredProcedure
Max Size of VARCHAR / CHAR in Table ad StoredProcedure -- Key: CORE-4338 URL: http://tracker.firebirdsql.org/browse/CORE-4338 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.2 Update 1 Environment: Windows 7 SP1 64 Bit Reporter: Firebird User unter Windows7 Priority: Critical Max Size in Table: VARCHAR(32765) / CHAR(32767) As Parameter of StoredProcedure: VARCHAR(8191) / CHAR(8191) So it is not possible to write a StoredProcedure which fills the table if a large Size is used.StoredProcedure Parameter must have the same size as in table columns. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Created: (CORE-4336) Firebird.msg is not installed with client
13.02.2014 22:02, Vlad Khorsun wrote: This error code (isc_bad_epb_form) was intorduced in FB 2.5 and it means you are used older fbclient.dll with your application when obtained this error from Firebrid server. Also it means that firebird.msg corresponding to your old client library also have no text for this error and even if it would be found (as you wish here) it give you nothing in this case. At first, this message was produced by 2.5 client. You are wrong, as usual. I've attached a tiny project (written not using "alien language" - special for you) and you can try by yourself: - compile fberrors.dpr (i've used old good D6) - put into folder with fberrors.exe fbclient.dll from Firebird 2.1 and rename it into fbclient.21.dll - put into folder with fberrors.exe fbclient.dll from Firebird 2.5 and rename it into fbclient.25.dll - make sure you have no fbclient.dll in the PATH - go to console and run fberrors.exe 3 times as shown below: 1. D:\Borland\Delphi6\Projects\FBClient>fberrors.exe 335544973 Library "fbclient.dll" failed to load: The specified module could not be found 2. D:\Borland\Delphi6\Projects\FBClient>fberrors.exe 335544973 fbclient.21.dll Loaded library: D:\Borland\Delphi6\Projects\FBClient\fbclient.21.dll unknown ISC error 335544973 can't format message 13:1 -- message file D:\Borland\Delphi6\Projects\firebird.msg not found 3. D:\Borland\Delphi6\Projects\FBClient>fberrors.exe 335544973 fbclient.25.dll Loaded library: D:\Borland\Delphi6\Projects\FBClient\fbclient.25.dll Unrecognized events block can't format message 13:1 -- message file D:\Borland\Delphi6\Projects\firebird.msg not found And show us what you see At second, the message become completely readable after copying firebird.msg _by hand_ because instclient didn't do that automatically. You not only used old fbclient, you also put newer firebird.msg - congratulations ! At last, thanks, I already know how to decode such cryptic messages. The ticket says exactly "WTF I have to decrypt it from sources". Are you still so proud by yourself ? Regards, Vlad PS For those who have no Delphi or who not understand Pascal\ISC API - attached project does the following: - load library by second argument (or just "fbclient.dll" if second argument is omitted) - prints full name with path of just loaded library - create status-vector with single error code (by first argument) - interpret error code and print corresponding text message - extarct SQL code and print corresponding text message fberrors.dpr Description: Binary data -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4339) ALIAS NAME LENGTH LIMITATION
ALIAS NAME LENGTH LIMITATION Key: CORE-4339 URL: http://tracker.firebirdsql.org/browse/CORE-4339 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Reporter: Tim Kelly Just tried porting my database to Firebird 3. I ran into a problem with alias lengths. This length was not enforced in Firebird 2.5 (perhaps it was a bug that it was allowed) , anyhow now they are restricted: Is this by enforcement by design? Either way it could represent a serious porting issue. Best solution: Support CORE-749... long overdue ;) Firebird 3.0: SELECT * FROM RDB$DATABASE A123456789012345678901234567890; Dynamic SQL Error -SQL error code = -104 -Name longer than database column size Firebird 2.5: SELECT * FROM RDB$DATABASE A123456789012345678901234567890; $DESCRIPTION RDB$RELATION_ID RDB$SECURITY_CLASS RDB$CHARACTER_SET_NAME === == == 4538 NONE -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4340) Restore fails if one stored procedure is incorrect
Restore fails if one stored procedure is incorrect -- Key: CORE-4340 URL: http://tracker.firebirdsql.org/browse/CORE-4340 Project: Firebird Core Issue Type: Bug Components: GBAK Environment: All environements Reporter: Robert Gilland GBAK restore will fail if one procedure is incorrect, this means backups that were thought to be good cannot be used. Also grave possibility of complete loss of data. I recommend any metadata that cannot be committed be "skipped" during the restore. Thus allowing the database to be usable after the restore. The "skipped" metadata should be identified in the restore logs. I just spent an entire day looking for an incorrect procedure! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
