Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Paul D. <pau...@ut...> - 2016-06-05 00:47:18
|
Thanks, I'll try Firebird 3. It's affordable. Paul On 6/4/2016 6:46 AM, Mark Rotteveel wrote: > On 18-5-2016 19:23, Paul Dryden wrote: >> Forsome reason on my system aliases don't work. Now I have to go into >> each app and change the alias to the actual path name. Any reason or >> solution for this? > This sounds like a question that should be posted to firebird-support > instead. Did you by any chance upgrade to Firebird 3? In Firebird 3 > aliases.conf no longer exists, it was replaced by databases.conf (see > http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-aliasesconf.html) > > Mark |
|
From: Paul E. <pa...@em...> - 2016-06-04 21:17:28
|
You need the .NET components for firebird (package you can install in VS using the package manager). And if you want to use firebird like other sources of data in VS, then you need to install the Firebird DDEX provider; there's installation files for that on the Firebird site. > On 3 Jun 2016, at 22:07, Dominique Louis <sav...@gm...> wrote: > > Hi All, > I used FireBird as a stand alone Desktop DB many years ago and would like to use it again now in a new project. > > I'm trying to find information about embedding the latest 3.x release into my Desktop Application on Windows and Mac. I plan to use C#/.NET and share as much of the data access layer as possible. > > I found http://www.firebirdsql.org/manual/ufb-cs-embedded.html, but was unable to find fbembed.dll in any of the zip files or installations for 3.x, so am unsure if this documentation is up to date or not. > > Can anyone provide links or information about best practises with the above in mind? > > > Thanks, > > > D. > ------------------------------------------------------------------------------ > What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic > patterns at an interface-level. Reveals which users, apps, and protocols are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mark R. <ma...@la...> - 2016-06-04 12:46:31
|
On 18-5-2016 19:23, Paul Dryden wrote: > Forsome reason on my system aliases don't work. Now I have to go into > each app and change the alias to the actual path name. Any reason or > solution for this? This sounds like a question that should be posted to firebird-support instead. Did you by any chance upgrade to Firebird 3? In Firebird 3 aliases.conf no longer exists, it was replaced by databases.conf (see http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-aliasesconf.html) Mark -- Mark Rotteveel |
|
From: Dominique L. <sav...@gm...> - 2016-06-03 21:07:13
|
Hi All, I used FireBird as a stand alone Desktop DB many years ago and would like to use it again now in a new project. I'm trying to find information about embedding the latest 3.x release into my Desktop Application on Windows and Mac. I plan to use C#/.NET and share as much of the data access layer as possible. I found http://www.firebirdsql.org/manual/ufb-cs-embedded.html, but was unable to find fbembed.dll in any of the zip files or installations for 3.x, so am unsure if this documentation is up to date or not. Can anyone provide links or information about best practises with the above in mind? Thanks, D. |
|
From: Jiří Č. <ji...@ci...> - 2016-05-29 13:10:35
|
Worth reading, if you want to understand why I am so slow to jump onto .NET Core support. http://www.aaronstannard.com/dotnetcore-boil-ocean/ -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: <dmu...@nu...> - 2016-05-25 15:01:14
|
I will be back in the office on Wednesday, May 25th. Dan |
|
From: livioc (JIRA) <tr...@fi...> - 2016-05-25 14:58:28
|
exception when using a boolean parameter with an embedded v2.5 server
---------------------------------------------------------------------
Key: DNET-683
URL: http://tracker.firebirdsql.org/browse/DNET-683
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.0.5.0, 5.0.0.0
Environment: .net 4.6.1 application on windows x32 with embedded v.5
Reporter: livioc
Assignee: Jiri Cincura
executing a query with an explicit typed boolean parameter will generate this exception
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -804
Incorrect values within SQLDA structure ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -804
Incorrect values within SQLDA structure
at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] statusVector) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:line 365
at FirebirdSql.Data.Client.Native.FesStatement.Execute() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 384
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1221
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 527
note:with expicit typed parameter i mean:
cmd.Parameters.Add("@value", FbDbType.Boolean);
cmd.Parameters[0].Value = true;
note2:i'm sending a pull request to github with a failing test for that
--
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
|
|
From: <dmu...@nu...> - 2016-05-24 11:18:47
|
I will be back in the office on Wednesday, May 25th. Dan |
|
From: Michał Z. (J. <tr...@fi...> - 2016-05-24 11:16:03
|
NET Core port
-------------
Key: DNET-682
URL: http://tracker.firebirdsql.org/browse/DNET-682
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Reporter: Michał Ziemski
Assignee: Jiri Cincura
NET Core RC2 was released recently.
I'd be great to have a build of NET Provider targeting one of the net platform standards:
https://github.com/dotnet/corefx/blob/master/Documentation/architecture/net-platform-standard.md
that would be able to run in the new environment.
The API exposed by NET Core is somewhat different then the Framework.
Few example:
- ICloneable is no more (this could be easiliy solved by removing that from the implemented interfaces list)
- serialization was scrapped (there are some stubs available in System.Runtime.Serialization.Primitives)
There are may other issues. Sometimes easily solved by referencing a relevant CoreFX assembly (ie System.Data.Common, System.ComponentModel.Primitives, etc ):
https://github.com/dotnet/corefx
others regretfully require some more sophisticated changes.
There are also some points that are simply not availabe (AFAIK):
- distributed transactions
--
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
|
|
From: <dmu...@nu...> - 2016-05-24 06:49:43
|
I will be back in the office on Wednesday, May 25th. Dan |
|
From: Jiří Č. <ji...@ci...> - 2016-05-24 06:46:37
|
More info: http://blog.cincura.net/233562-ado-net-provider-5-0-5-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: livioc (JIRA) <tr...@fi...> - 2016-05-19 14:49:05
|
the provider passes the windows username and not the userid of connection string to the embedded server
-------------------------------------------------------------------------------------------------------
Key: DNET-681
URL: http://tracker.firebirdsql.org/browse/DNET-681
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.0.0.0
Environment: .net 4.6.1 application with the provider 5.0.0.0, i tried different embedded 2.5.* versions on both x32/64 and windows 7/10 and i had always the same error
Reporter: livioc
Assignee: Jiri Cincura
Priority: Critical
the new version( 5.0.0.0) uses the windows identity as username to log to the embedded server, not the user specified in the connection string
note: i got the username used to login with the query 'SELECT CURRENT_USER FROM RDB$DATABASE'
--
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
|
|
From: <dmu...@nu...> - 2016-05-19 12:36:30
|
I will be back in the office on Wednesday, May 25th. Dan |
|
From: Геннадий З. <zab...@gm...> - 2016-05-19 12:33:42
|
I can confirm. Same issue here. Steps: run Update-Package FirebirdSql.Data.FirebirdClient in package manager console On 18 May 2016 at 15:57, livioc (JIRA) <tr...@fi...> wrote: > cannot connect to an embedded db with the 5.0.0.0 > ------------------------------------------------- > > Key: DNET-680 > URL: http://tracker.firebirdsql.org/browse/DNET-680 > Project: .NET Data provider > Issue Type: Bug > Components: ADO.NET Provider > Affects Versions: 5.0.0.0 > Environment: .net 4.6.1 application with the provider 5.0.0.0, i tried different embedded 2.5.* versions on both x32/64 and windows 7/10 and i had always the same error > Reporter: livioc > Assignee: Jiri Cincura > Priority: Critical > > > i use this connection string > <add name="DbConnection" connectionString="Database=databasealiasname;ServerType=1;User=sysdba;Charset=WIN1252" providerName="FirebirdSql.Data.FirebirdClient"/> > and in the alias.conf i have the full file path > databasealiasname= C:\ProgramData\database.fdb > > when i update the provider from 4.10 to 5 i get this exception when opening the connection > FirebirdSql.Data.FirebirdClient.FbException (0x80004005): no permission for read-write access to database *** ---> no permission for read-write access to database *** > at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:line 182 > at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 202 > at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 106 > at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 221 > at FirebirdSql.Data.FirebirdClient.FbConnection.Open() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:line 534 > > > with another app i get the exception only when doing the first query > FirebirdSql.Data.FirebirdClient.FbException: no permission for read/select access to TABLE *** ---> FirebirdSql.Data.Common.IscException: no permission for read/select access to TABLE *** > at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:line 375 > at FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 302 > at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1169 > at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1192 > at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 527 > > -- > 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 > > > > ------------------------------------------------------------------------------ > Mobile security can be enabling, not merely restricting. Employees who > bring their own devices (BYOD) to work are irked by the imposition of MDM > restrictions. Mobile Device Manager Plus allows you to control only the > apps on BYO-devices by containerizing them, leaving personal data untouched! > https://ad.doubleclick.net/ddm/clk/304595813;131938128;j > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Paul D. <pau...@ut...> - 2016-05-18 17:58:12
|
Forsome reason on my system aliases don't work. Now I have to go into each app and change the alias to the actual path name. Any reason or solution for this? Paul Dryden, University of Utah |
|
From: <dmu...@nu...> - 2016-05-18 13:26:39
|
I will be back in the office on Wednesday, May 25th. Dan |
|
From: livioc (JIRA) <tr...@fi...> - 2016-05-18 12:58:08
|
cannot connect to an embedded db with the 5.0.0.0
-------------------------------------------------
Key: DNET-680
URL: http://tracker.firebirdsql.org/browse/DNET-680
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.0.0.0
Environment: .net 4.6.1 application with the provider 5.0.0.0, i tried different embedded 2.5.* versions on both x32/64 and windows 7/10 and i had always the same error
Reporter: livioc
Assignee: Jiri Cincura
Priority: Critical
i use this connection string
<add name="DbConnection" connectionString="Database=databasealiasname;ServerType=1;User=sysdba;Charset=WIN1252" providerName="FirebirdSql.Data.FirebirdClient"/>
and in the alias.conf i have the full file path
databasealiasname= C:\ProgramData\database.fdb
when i update the provider from 4.10 to 5 i get this exception when opening the connection
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): no permission for read-write access to database *** ---> no permission for read-write access to database ***
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:line 182
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 202
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 106
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 221
at FirebirdSql.Data.FirebirdClient.FbConnection.Open() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:line 534
with another app i get the exception only when doing the first query
FirebirdSql.Data.FirebirdClient.FbException: no permission for read/select access to TABLE *** ---> FirebirdSql.Data.Common.IscException: no permission for read/select access to TABLE ***
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:line 375
at FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 302
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1169
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1192
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 527
--
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
|
|
From: Jiří Č. <ji...@ci...> - 2016-05-17 09:23:13
|
More info: http://blog.cincura.net/233561-ado-net-provider-5-0-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Kyle G. <ky...@in...> - 2016-05-04 18:56:38
|
Thank you, I can connect and now have rights. I will try to follow your advice to sculpt a user (or role) with just the necessary rights. Meanwhile, I have a couple of questions (should I start a different thread?) The created user appears to belong to the server, not the database, correct? I can create a role, will it belong to the server or the database? The role assignment appears to be assigned per database (but still must be passed in the connection string) During application development, I often recreate the entire database via isql script. It appears I should add some script lines to (create and?) assign the role to the user that will be used in the connection string, correct? and one last question, I don't see much about database "owners". Is that simply the account that was used to connect when the create database command is issued? Thanks, --- Kyle Green On 2016-05-04 04:29, Mark Rotteveel wrote: > On 2016-05-03 23:45, Kyle Green wrote: >> Thank you, I have done as you suggested, and the connection string >> works! >> >> However the user I created has no permissions, not even select >> permissions: >> >> my log shows 5/3/2016 3:36:11 PM: no permission for SELECT access to >> TABLE BLOGS ( and for every other attempt to access data) >> >> I had named my User "LegacyUser" (was that a mistake?). Then, while >> attached to the database through FlameRobin, ran these: >> >> GRANT rdb$admin TO USER LegacyUser; >> >> Above did not allow access, so I tried this: >> >> ALTER USER LegacyUser GRANT ADMIN ROLE; >> >> Even after this, the error at the top still appears. >> >> I have always used SYSDBA account for my web applications, so I have >> no experience with user accounts. >> >> What might be missing? > > You could just create a legacy SYSDBA (it might already exist, in which > case you just need to change the password). However using SYSDBA for a > (web) application is a bad idea, because it has all rights on all > databases on the Firebird server. You should create a user that has the > minimal rights necessary for your application to work. > > As to the specific problem : roles are only applied when you specify > them on connect in the connection string (for Firebird .net provider > property: Role=RDB$ADMIN) or - since 3.0 - after connect with SET ROLE. > No role specified means that you only get the rights assigned to PUBLIC > and the user itself. > > For RDB$ADMIN specifically, you can enable auto admin mapping, which > means that the user will get the role implicitly when logged in. See > http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-auth.html#fblangref25-security-autoadminmapping > > But I'd strongly advise you to create a specific role with only the > necessary rights. > > Mark > > ------------------------------------------------------------------------------ > Find and fix application performance issues faster with Applications > Manager > Applications Manager provides deep performance insights into multiple > tiers of > your business applications. It resolves application problems quickly > and > reduces your MTTR. Get your free trial! > https://ad.doubleclick.net/ddm/clk/302982198;130105516;z > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mark R. <ma...@la...> - 2016-05-04 11:29:12
|
On 2016-05-03 23:45, Kyle Green wrote: > Thank you, I have done as you suggested, and the connection string > works! > > However the user I created has no permissions, not even select > permissions: > > my log shows 5/3/2016 3:36:11 PM: no permission for SELECT access to > TABLE BLOGS ( and for every other attempt to access data) > > I had named my User "LegacyUser" (was that a mistake?). Then, while > attached to the database through FlameRobin, ran these: > > GRANT rdb$admin TO USER LegacyUser; > > Above did not allow access, so I tried this: > > ALTER USER LegacyUser GRANT ADMIN ROLE; > > Even after this, the error at the top still appears. > > I have always used SYSDBA account for my web applications, so I have > no experience with user accounts. > > What might be missing? You could just create a legacy SYSDBA (it might already exist, in which case you just need to change the password). However using SYSDBA for a (web) application is a bad idea, because it has all rights on all databases on the Firebird server. You should create a user that has the minimal rights necessary for your application to work. As to the specific problem : roles are only applied when you specify them on connect in the connection string (for Firebird .net provider property: Role=RDB$ADMIN) or - since 3.0 - after connect with SET ROLE. No role specified means that you only get the rights assigned to PUBLIC and the user itself. For RDB$ADMIN specifically, you can enable auto admin mapping, which means that the user will get the role implicitly when logged in. See http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-auth.html#fblangref25-security-autoadminmapping But I'd strongly advise you to create a specific role with only the necessary rights. Mark |
|
From: LtColRDSChauhan <rds...@gm...> - 2016-05-04 01:43:31
|
> > Subject: Re: [Firebird-net-provider] Connection to Firebird 3 With > Legacy Authentication Fails > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Message-ID: <572...@la...> > Content-Type: text/plain; charset=utf-8; format=flowed > > On 29-4-2016 08:26, LtColRDSChauhan wrote: > > Mark, > > Could trace your: > > https://github.com/FirebirdSQL/jaybird/wiki/Jaybird-and-Firebird-3 > > It covers everything except for SEC$USER_NAME, SEC$NAME_PART. > > As far as I know doing things for SEC$USER_NAME, SEC$NAME_PART should > not be necessary for 'normal' Firebird 2.5 database upgraded to Firebird > 3. It seems very specific for your database or maybe if you downgraded a > Firebird 3 database to 2.5 and then back to 3 (?). > > Mark > You are correct, Mark. Thanks a lot. Rajiv |
|
From: Kyle G. <ky...@in...> - 2016-05-03 22:45:23
|
Thank you, I have done as you suggested, and the connection string works! However the user I created has no permissions, not even select permissions: my log shows 5/3/2016 3:36:11 PM: no permission for SELECT access to TABLE BLOGS ( and for every other attempt to access data) I had named my User "LegacyUser" (was that a mistake?). Then, while attached to the database through FlameRobin, ran these: GRANT rdb$admin TO USER LegacyUser; Above did not allow access, so I tried this: ALTER USER LegacyUser GRANT ADMIN ROLE; Even after this, the error at the top still appears. I have always used SYSDBA account for my web applications, so I have no experience with user accounts. What might be missing? Thanks --- Kyle Green On 2016-05-03 11:01, Mark Rotteveel wrote: > See http://stackoverflow.com/q/36752916/466862 [3] > > In short edit Firebird.conf > Add Legacy_Auth to AuthServer. > Set WireCrypt to Enabled > Add Legacy_UserManager to UserManager > > Create a user for legacy authentication. > > Mark > > Mark > > ----- Bericht beantwoorden ----- > Van: "Kyle Green" <ky...@in...> > Aan: <fir...@li...> > Onderwerp: [Firebird-net-provider] Fb 3 connection string upgrade > Datum: di, mei 3, 2016 19:38 > > I have rebuilt my Fb 2.5 database as Fb 3.0, and have upgraded to the > current provider. > > Now I am trying to make the web app which previously used Fb2.5 work. I > am able to connect via isql, and by FlameRobin. > > Connection Failed to Open for ConnectionString: > > Database=d:dbFbDataMyDb.fdb;user=SYSDBA;password=masterkey;DataSource=localhost;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection Lifetime=0;Connection Timeout=15; > > Exception: > > FirebirdSql.Data.FirebirdClient.FbException (0x80004005): connection > rejected by remote interface ---> connection rejected by remote > interface > > at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() > at > FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) > at > FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) > at > FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) > at FirebirdSql.Data.FirebirdClient.FbConnection.Open() > > The original string failed also: > > Database=d:dbFbDataMyDb.fdb;user=SYSDBA;password=masterkey;server=MyServer;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection Lifetime=0;Connection Timeout=15; > > firebird.conf is default with ServerMode - Classic > > databases.conf is default > > How can I get this to work? > > Thanks! > > -- > Kyle Green > > ------------------------------------------------------------------------------ > Find and fix application performance issues faster with Applications Manager > Applications Manager provides deep performance insights into multiple tiers of > your business applications. It resolves application problems quickly and > reduces your MTTR. Get your free trial! > https://ad.doubleclick.net/ddm/clk/302982198;130105516;z [1] > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider [2] > > ------------------------------------------------------------------------------ > Find and fix application performance issues faster with Applications Manager > Applications Manager provides deep performance insights into multiple tiers of > your business applications. It resolves application problems quickly and > reduces your MTTR. Get your free trial! > https://ad.doubleclick.net/ddm/clk/302982198;130105516;z [1] > > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider [2] Links: ------ [1] https://ad.doubleclick.net/ddm/clk/302982198;130105516;z [2] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider [3] http://stackoverflow.com/q/36752916/466862 |
|
From: M. R. <ma...@la...> - 2016-05-03 18:01:39
|
See http://stackoverflow.com/q/36752916/466862 In short edit Firebird.conf Add Legacy_Auth to AuthServer. Set WireCrypt to Enabled Add Legacy_UserManager to UserManager Create a user for legacy authentication. Mark Mark ----- Bericht beantwoorden ----- Van: "Kyle Green" <ky...@in...> Aan: <fir...@li...> Onderwerp: [Firebird-net-provider] Fb 3 connection string upgrade Datum: di, mei 3, 2016 19:38 I have rebuilt my Fb 2.5 database as Fb 3.0, and have upgraded to the current provider. Now I am trying to make the web app which previously used Fb2.5 work. I am able to connect via isql, and by FlameRobin. Connection Failed to Open for ConnectionString: Database=d:\db\Fb\Data\MyDb.fdb;user=SYSDBA;password=masterkey;DataSource=localhost;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection Lifetime=0;Connection Timeout=15; Exception: FirebirdSql.Data.FirebirdClient.FbException (0x80004005): connection rejected by remote interface ---> connection rejected by remote interface at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) at FirebirdSql.Data.FirebirdClient.FbConnection.Open() The original string failed also: Database=d:\db\Fb\Data\MyDb.fdb;user=SYSDBA;password=masterkey;server=MyServer;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection Lifetime=0;Connection Timeout=15; firebird.conf is default with ServerMode - Classic databases.conf is default How can I get this to work? Thanks! -- Kyle Green ------------------------------------------------------------------------------ Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Kyle G. <ky...@in...> - 2016-05-03 17:40:17
|
I have rebuilt my Fb 2.5 database as Fb 3.0, and have upgraded to the
current provider.
Now I am trying to make the web app which previously used Fb2.5 work. I
am able to connect via isql, and by FlameRobin.
Connection Failed to Open for ConnectionString:
Database=d:\db\Fb\Data\MyDb.fdb;user=SYSDBA;password=masterkey;DataSource=localhost;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection Lifetime=0;Connection Timeout=15;
Exception:
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): connection
rejected by remote interface ---> connection rejected by remote
interface
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at
FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString)
at
FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner)
at
FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner)
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
The original string failed also:
Database=d:\db\Fb\Data\MyDb.fdb;user=SYSDBA;password=masterkey;server=MyServer;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection Lifetime=0;Connection Timeout=15;
firebird.conf is default with ServerMode - Classic
databases.conf is default
How can I get this to work?
Thanks!
--
Kyle Green
|
|
From: Mark R. <ma...@la...> - 2016-05-01 10:07:03
|
On 29-4-2016 08:26, LtColRDSChauhan wrote: > Mark, > Could trace your: > https://github.com/FirebirdSQL/jaybird/wiki/Jaybird-and-Firebird-3 > It covers everything except for SEC$USER_NAME, SEC$NAME_PART. As far as I know doing things for SEC$USER_NAME, SEC$NAME_PART should not be necessary for 'normal' Firebird 2.5 database upgraded to Firebird 3. It seems very specific for your database or maybe if you downgraded a Firebird 3 database to 2.5 and then back to 3 (?). Mark -- Mark Rotteveel |
211 messages has been excluded from this view by a project administrator.
