Unable to connect bundled embedded database on macOS
----------------------------------------------------
Key: DNET-744
URL: http://tracker.firebirdsql.org/browse/DNET-744
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.8.1.0
Environment: macOS Sierra, Firebird 2.5.6 embedded, Mono 4.8
Reporter: Daniel Martin
Assignee: Jiri Cincura
When bundling the Firebird database with a mono application, one must not
provide a user and a password in the connection string as otherwise the
libfbembed.dylib (Firebird binary) attempts to attach to the systems
security2.fdb.
The FbConnectionString class forces the client to provide a user and password
if LINUX is defined, as trusted auth does no exist on non-windows platforms.
This was locally fixed by checking the FbConnectionString.ServerType property
in FbConnectionString.Validate and FbConnectionString.FallIntoTrustedAuth.
See the provided methods below for details.
I'm not sure whether this is the correct solution or if it creates any side
effects.
----
internal bool FallIntoTrustedAuth
{
// on non-Win the UserID/Password is checked in
Validate method
get { return ServerType != FbServerType.Embedded &&
string.IsNullOrEmpty(UserID) && string.IsNullOrEmpty(Password); } // Embedded
does not require a password
}
---
public void Validate()
{
if (!ContextConnection)
{
if (
#if (LINUX) // on Linux Trusted Auth isn't available
(ServerType != FbServerType.Embedded &&
(string.IsNullOrEmpty(this.UserID) || // Embedded does not require a password
string.IsNullOrEmpty(this.Password))) ||
#endif
(string.IsNullOrEmpty(Database) && !_isServiceConnectionString) ||
(string.IsNullOrEmpty(DataSource) &&
ServerType != FbServerType.Embedded) ||
(string.IsNullOrEmpty(Charset)) ||
(Port == 0) ||
(!Enum.IsDefined(typeof(FbServerType),
ServerType)) ||
(MinPoolSize > MaxPoolSize)
)
{
throw new ArgumentException("An invalid
connection string argument has been supplied or a required connection string
argument has not been supplied.");
}
if (Dialect < 1 || Dialect > 3)
{
throw new ArgumentException("Incorrect
database dialect it should be 1, 2, or 3.");
}
if (PacketSize < 512 || PacketSize > 32767)
{
throw new
ArgumentException(string.Format(CultureInfo.CurrentCulture, "'Packet Size'
value of {0} is not valid.{1}The value should be an integer >= 512 and <=
32767.", PacketSize, Environment.NewLine));
}
if (DbCachePages < 0)
{
throw new
ArgumentException(string.Format(CultureInfo.CurrentCulture, "'Db Cache Pages'
value of {0} is not valid.{1}The value should be an integer >= 0.",
DbCachePages, Environment.NewLine));
}
if (Pooling && NoDatabaseTriggers)
{
throw new ArgumentException("Cannot use
Pooling and NoDBTriggers together.");
}
CheckIsolationLevel();
}
}
---
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
