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" <kyle...@interfacesandengines.com>
> Aan: <firebird-net-provider@lists.sourceforge.net>
> 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
> Firebird-net-provider@lists.sourceforge.net
> 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
> Firebird-net-provider@lists.sourceforge.net
> 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
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
