Re: [Firebird-net-provider] Fb 3 connection string upgrade

[Kyle G. <ky...@in...>]

 

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