So the most honest and straightforward thing would be to call this
2.5.3 and everything that comes later will then be 2.5.4 and so on.
You make a good point. The only problem is that 2.5.3 has been available as a
rolling snapshot release for a while now and a lot of fixes in the tracker
are
What’s the point of the rename? It seems to only break existing code
and documentation.
aliases.conf name does not reflect what for this file can be used in
fb3. In addition to defining aliases for databases it now supports
per-database configuration parameters. We (I and Dmitry) failed to
It's up to you to decide. You may move local settings to mydb.conf and
then #include it into databases.conf. But databases.conf is still
necessary to make the server aware of pre-configured databases.
Can you give me/us an idea of what the things are that can be
configured in these files?
Try this on a UTF8 database:
select
case when 'Übergeek' collate unicode_ci_ai like 'ÜB%' collate unicode_ci_ai
then '=' else '' end as test_1,
case when 'Übergeek' collate unicode_ci_ai like 'üb%' collate unicode_ci_ai
then '=' else '' end as test_2,
case when 'Fußball' collate
I'd prefer to have an option to use UTF-16 (treated as a 2-byte
character set with surrogate pairs) as that will only halve the
maximum allowed number of characters.
The maximum allowed number of characters in Unicode is about 1
Million. Which can be perfectly represented by either UTF-8 or
In the FB3 Release Notes the chapter about Increased Password Length
speaks of a maximum of 20 *bytes*. The second blue box in this chapter
then asks:
Why is the password effectively limited to 20 *characters*?
It is unclear from this documentation if this is about bytes or
characters. What
What about character set used for storing passwords - this question
makes no sense, passwords are not stored, hashes for them are stored
instead. One may use non-ascii characters for apsswords, but in beta2
this will cause troubles when using services. Currently in SVN this is
fixed, in
> reading Paul's "instsvc and ServerMode" got me thinking whether we even
> need the `instsvc` executable? The installer can install the services
> directly and for batch files we can use PowerShell and the New-Service
> etc. cmdlets. This will save some kB from the package. And also it will
>
>> I use instsvc a lot. It is simple, small and does the job. Why drop
>> it and replace it with something that's probably more complicated
>> to use?
>
> What do you use it for?
On my development machine I have several different versions of
Firebird (2.1, 2.5, 3.0 when I find the time to test it
>> Is there a way to restore my database without the need to use another
>> security database? Thereby keeping XYZ as the owner? I don't see there
>> is anything in GBAK that could create the new owner user during the
>> restore.
>Restore it in embedded mode using user name XYZ (password is
>>Try to set option IPv6V6Only to true in firebird.conf and see if it
>>makes any difference.
> This directive affects only listening sockets (i.e. a server) and would
> actually do the exact opposite: make the server listening on (default)
> address :: accept only IPv6 connections (to
> However, the new fbclient (3.0.0.31529) connecting to old Firebird
> servers (2.5 and earlier) is also taking 1 second (compared to +/- 25-30
> milliseconds with Firebird 3 beta 1 fbclient and 15 milliseconds with
> Firebird 2.5.3 fbclient), so we do have a problem.
I just tested the new 3.0.0
--- Alex Peshkoff
> Stefan, I've made a test. It's dev-build therefore it's not too fast but
> look here:
> [...]
> I do not notice 3.0 client to work slower.
Sorry, I forgot to mention that I mean Windows, not Linux.
--- Michal Kubecek
> Do you see the same delay when identifying the server
>>> I can confirm that: using a 3.0 fbclient to connect to a *remote* 2.5
>>> server is quick. The problem seems to be related to the local machine
>>> (I didn't manage to switch IPv6 off for my localhost on Windows).
>
>>Just add (uncomment) following line at System32\drivers\etc\hosts:
>
>>
> 26.04.2016 12:01, Stefan Heymann wrote:
>> So I think Michael's idea to expand the URL type database strings is a
>> good idea:
>No, it is just a workaround.
>Good solution will be to connect to all host addresses at once using
> connection that is
> esta
> 25.04.2016 22:34, Michal Kubecek wrote:
>> No, that's not the reason. If everything works the way it's supposed to,
>> the connection fails within one roundtrip and client doesn't have to
>> wait for a full second. For :: address, there is even less reason for
>> having to wait for a timeout.
>If a server has both IPv4 and IPv6 addresses, there can be four cases:
> 1) Firebird doesn't listen on both of them
> 2) Firebird listens on IPv4 only
> 3) Firebird listens on IPv6 only
> 4) Firebird listens on both
>Whatever priority you set up, in one case of four you'll get slow
>
> It seems that your problem is due to slow host name to IP address
> resolution (i.e. DNS), not with Firebird functionality.
But my 2.5 fbclient does not show this delay. So I don't assume there
is a problem with IP resolution.
> For Windows, the policy table seems to be managed with netsh
> Try to set option IPv6V6Only to true in firebird.conf and see if it makes
> any difference.
I copied a firebird.conf from Fb3 to the client folder, changed that
to true (1). There's no difference. Still that second.
Regards
Stefan
> Sean, can you confirm that there is no delay when using 3.0 fbclient
> with remote 2.5 server?
I can confirm that: using a 3.0 fbclient to connect to a *remote* 2.5
server is quick. The problem seems to be related to the local machine
(I didn't manage to switch IPv6 off for my localhost on
> Ok, that did the trick. I can now also confirm that connecting to a
> Firebird 2.5 server is quick when IPv6 is inactive on localhost.
Now that the technical reasons for this one-second delay are
clarified: is there something that can/will be done to improve the
situation? Do I need to open a
> 1) Install FB3.0.2 64bit with default settings (port 3050, service name
> DefaultInstance)
Try to use instreg to un-register the 64-bit installation from the
Registry. If you have more that one database on one server it's best
to have none of them being registered in the Registry.
Regards
> ON CLIENT:
> expected: if port is not specified (like localhost:alias) use 3050
> real: if port is not specified (like localhost:alias) use config or 3050
I don't know how you come to this expectation. My expectation is what
you describe als "real" :-)
As my clients usually don't come with a
more like their
CURRENT_xxx siblings.
Regards
Stefan
--
Stefan Heymann, Tübingen, Germany
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
it.
http://tracker.firebirdsql.org/browse/CORE-3900
Regards
Stefan
--
Stefan Heymann, Tübingen, Germany
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> AuthServer = "Legacy_Auth, Srp, Win_Sspi" instead of "Srp"
> AuthClient = "Legacy_Auth, Srp, Win_Sspi" instead of "Srp, Srp256, Win_Sspi,
> Legacy_Auth"
> UserManager = "Legacy_UserManager, Srp" instead of "Srp"
I don't think it is a good idea to activate the legacy authentication
by default,
servers
over the years and admin privileges were never a problem.
It's quite the opposite: for me, an installation that does NOT ask for
admin privileges is highly suspicious ...
Regards
Stefan
--
Stefan Heymann, Tübingen, Germany
Firebird-Devel mailing list, web interface at
https://lists.sou
> Not reproduced on linux:
> # ./isql -z
> ISQL Version: LI-T4.0.0.1976 Firebird 4.0 Beta 2
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> CREATE DATABASE 'test32.fdb' PAGE_SIZE 32768;
> SQL> show db;
> Database: test32.fdb
> Owner: SYSDBA
> PAGE_SIZE 32768
Emil also used
Fabiano,
> I never had a problem with this behavior, since it was just a matter of
> waiting for the end of the process, [...]
The end of the process is not the end of output, which is buffered. You should
probably continue to read from STDOUT or STDERR after the process has finished.
Best
> fixed
> https://github.com/FirebirdSQL/firebird/issues/7184
Wow, that was quick. That problem has been around since at least 3.0.0.
Regards
Stefan
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
me as a Windows user this would be much more logical (the 86 comes from the
80*86 processor, the 64 comes from 64 bits, so it's not consistent from the
beginning).
Best Regards
Stefan
--
Stefan Heymann, Tübingen, Germany
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>> > I'd like to suggest you use win32 and win64 instead of x86 and x64. Or, it
>> > you want to keep the "windows" prefix, use window-32 and windows-64.
>> > For me as a Windows user this would be much more logical (the 86 comes
>> > from the 80*86 processor, the 64 comes from 64 bits, so
Components: Charsets/Collation
Affects Versions: 2.5.2 Update 1
Environment: Tested on Windows7 Pro, Firebird 2.5.2-upd1
Reporter: Stefan Heymann
The UNICODE_CI_AI collation treats the Sharp-s character (U+00DF) incorrectly.
This character (used in German language
33 matches
Mail list logo
