[Mono-list] Problem with MySQL Data Provider (ByteFx)
Hi, I've mono 1 Beta with Fedora Core 2. I try to test a connection string with MySQL Data Provider (ByteFx), compilation is all right but running failed: ## [EMAIL PROTECTED] mono]# mcs EsempioByteFX.cs -r System.Data.dll -r ByteFX.Data.dll Compilation succeeded [EMAIL PROTECTED] mono]# mono EsempioByteFX.exe Unhandled Exception: System.NullReferenceException: A null value was found where an object instance was required. in <0x0025a> ByteFX.Data.MySqlClient.MySqlStream:get_DataAvailable () in <0x00051> ByteFX.Data.Common.MultiHostStream:Read (byte[],int,int) in <0x0003d> ByteFX.Data.MySqlClient.MySqlStream:ReadInt24 () in <0x00050> (wrapper remoting-invoke-with-check) ByteFX.Data.MySqlClient.MySqlS tream:ReadInt24 () in <0x0005b> ByteFX.Data.MySqlClient.Driver:ReadRawPacket () in <0x0004e> ByteFX.Data.MySqlClient.Driver:ReadPacket () in <0x00094> ByteFX.Data.MySqlClient.Driver:Open (ByteFX.Data.MySqlClient.MySqlC onnectionString) in <0x0003c> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open () in <0x000ef> ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection () in <0x00212> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection () in <0x00052> ByteFX.Data.MySqlClient.MySqlPool:GetConnection () in <0x00117> ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection (ByteFX.Data .MySqlClient.MySqlConnectionString) in <0x00077> ByteFX.Data.MySqlClient.MySqlConnection:Open () in <0x0004f> (wrapper remoting-invoke-with-check) ByteFX.Data.MySqlClient.MySqlC onnection:Open () in <0x00070> ConnessioneByteFX.Class1:Main (string[]) ## If I use Sqlsharp I obtein: ## SQL# \Provider MySqlNet The default Provider is LOADEXTPROVIDER Assembly: ByteFX.Data Connection Class: ByteFX.Data.MySQLClient.MySQLConnection SQL# \ConnectionString Server=localhost; Database=db1; UserID=root; Password=roo tpwd; SQL# \Open Attempt to open connection... Loading external provider... Error: unable to load the assembly of the provider: ByteFX.Data : File 'ByteFX.D ata' not found. I've checked ... /usr/lib/mono/1.0/ByteFX.Data.dll exist and also /usr/lib/mono/2.0/ByteFX.Data.dll. What can I do? Thanks, Valentina. ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem with MySQL Data Provider (ByteFx)
W liście z pon, 28-06-2004, godz. 15:31, [EMAIL PROTECTED] pisze: > I've mono 1 Beta with Fedora Core 2. > I try to test a connection string with MySQL Data Provider (ByteFx), compilation > is all right but running failed: Install latest Mono release (RC has some issues, try Beta 3) - ByteFX.Data.dll version shoul be 0.7.6.1. Earlier versions of the libary were broken due to namespace changes. artb. -- only so many songs can be sung with two lips two lungs and one tongue ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem with MySQL Data Provider (ByteFx)
Hi, I've just installed Mono Beta 3...but I've still problems: ## [EMAIL PROTECTED] mono]# mcs provaByteFX.cs -r System.Data.dll -r ByteFX.Data.dll Compilation succeeded [EMAIL PROTECTED] mono]# mono provaByteFX.exe Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Host 'localhost.localdomain' is not allowed to connect to this MySQL server in <0x000d5> ByteFX.Data.MySqlClient.Driver:ReadPacket () in <0x00198> ByteFX.Data.MySqlClient.Driver:Open (ByteFX.Data.MySqlClient.MySqlConnectionString) in <0x0003c> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open () in <0x000ef> ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection () in <0x0021d> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection () in <0x00053> ByteFX.Data.MySqlClient.MySqlPool:GetConnection () in <0x00112> ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection (ByteFX.Data.MySqlClient.MySqlConnectionString) in <0x0007c> ByteFX.Data.MySqlClient.MySqlConnection:Open () ## And with sqlsharp: SQL# \Provider MySql The default Provider is LOADEXTPROVIDER Assembly: Mono.Data.MySql Connection Class: Mono.Data.MySql.MySqlConnection SQL# \Provider MySqlNet The default Provider is LOADEXTPROVIDER Assembly: ByteFX.Data Connection Class: ByteFX.Data.MySQLClient.MySQLConnection SQL# \ConnectionString Server=localhost; Database=db1; UserID=root; Password=rootpwd; SQL# \Open Attempt to open connection... Loading external provider... Error: unable to load the assembly of the provider: ByteFX.Data : File 'ByteFX.Data' not found. Any ideas? thanks, Valentina. >Scrive Artur Brodowski <[EMAIL PROTECTED]>: > W li¶cie z pon, 28-06-2004, godz. 15:31, [EMAIL PROTECTED] pisze: > > I've mono 1 Beta with Fedora Core 2. > > I try to test a connection string with MySQL Data Provider (ByteFx), > compilation > > is all right but running failed: > > Install latest Mono release (RC has some issues, try Beta 3) - > ByteFX.Data.dll version shoul be 0.7.6.1. Earlier versions of > the libary were broken due to namespace changes. > > artb. > -- > only so many songs can be sung with two lips two lungs and one tongue > > ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem with MySQL Data Provider (ByteFx)
This is a permission problem in your Mysql configuration. On Tuesday 29 June 2004 14:32, [EMAIL PROTECTED] wrote: > Hi, > > I've just installed Mono Beta 3...but I've still problems: > > ## > [EMAIL PROTECTED] mono]# mcs provaByteFX.cs -r System.Data.dll -r ByteFX.Data.dll > Compilation succeeded > [EMAIL PROTECTED] mono]# mono provaByteFX.exe > > > Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Host > 'localhost.localdomain' is not allowed to connect to this MySQL server > in <0x000d5> ByteFX.Data.MySqlClient.Driver:ReadPacket () > in <0x00198> ByteFX.Data.MySqlClient.Driver:Open > (ByteFX.Data.MySqlClient.MySqlConnectionString) > in <0x0003c> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open () > in <0x000ef> ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection () > in <0x0021d> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection () > in <0x00053> ByteFX.Data.MySqlClient.MySqlPool:GetConnection () > in <0x00112> ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection > (ByteFX.Data.MySqlClient.MySqlConnectionString) > in <0x0007c> ByteFX.Data.MySqlClient.MySqlConnection:Open () > > > ## > And with sqlsharp: > > SQL# \Provider MySql > The default Provider is LOADEXTPROVIDER > Assembly: Mono.Data.MySql > Connection Class: Mono.Data.MySql.MySqlConnection > > SQL# \Provider MySqlNet > The default Provider is LOADEXTPROVIDER > Assembly: ByteFX.Data > Connection Class: ByteFX.Data.MySQLClient.MySQLConnection > > SQL# \ConnectionString Server=localhost; Database=db1; UserID=root; > Password=rootpwd; > > SQL# \Open > Attempt to open connection... > Loading external provider... > Error: unable to load the assembly of the provider: ByteFX.Data : File > 'ByteFX.Data' not found. > > > Any ideas? > thanks, > Valentina. > > >Scrive Artur Brodowski <[EMAIL PROTECTED]>: > > > > W li¶cie z pon, 28-06-2004, godz. 15:31, [EMAIL PROTECTED] pisze: > > > I've mono 1 Beta with Fedora Core 2. > > > I try to test a connection string with MySQL Data Provider (ByteFx), > > > > compilation > > > > > is all right but running failed: > > > > Install latest Mono release (RC has some issues, try Beta 3) - > > ByteFX.Data.dll version shoul be 0.7.6.1. Earlier versions of > > the libary were broken due to namespace changes. > > > > artb. > > -- > > only so many songs can be sung with two lips two lungs and one tongue > > ___ > Mono-list maillist - [EMAIL PROTECTED] > http://lists.ximian.com/mailman/listinfo/mono-list ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem with MySQL Data Provider (ByteFx)
W liście z wto, 29-06-2004, godz. 16:32, [EMAIL PROTECTED] pisze: > I've just installed Mono Beta 3...but I've still problems: Make sure that ByteFX.Data version is at least 0.7.6: $ gacutil -l | grep ByteFX.Data ByteFX.Data, Version=0.7.6.1, Culture=neutral, PublicKeyToken=0738eb9f132ed756 If not, try to add ICSharpCode.SharpZipLib.dll and ByteFX.Data.dll to gac manually: $ gacutil -i /path/ICSharpCode.SharpZipLib.dll $ gacutil -i /path/ByteFX.Data.dll artb. ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] Problem with MySQL Data Provider (ByteFx)
SQL# does not support external providers put in the Mono GAC. I need to fix this before Mono 1.0. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pablo Baena Sent: Tuesday, June 29, 2004 12:32 PM To: [EMAIL PROTECTED] Subject: Re: [Mono-list] Problem with MySQL Data Provider (ByteFx) This is a permission problem in your Mysql configuration. On Tuesday 29 June 2004 14:32, [EMAIL PROTECTED] wrote: > Hi, > > I've just installed Mono Beta 3...but I've still problems: > > ## > [EMAIL PROTECTED] mono]# mcs provaByteFX.cs -r System.Data.dll -r > ByteFX.Data.dll Compilation succeeded [EMAIL PROTECTED] mono]# mono > provaByteFX.exe > > > Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Host > 'localhost.localdomain' is not allowed to connect to this MySQL server > in <0x000d5> ByteFX.Data.MySqlClient.Driver:ReadPacket () in <0x00198> > ByteFX.Data.MySqlClient.Driver:Open > (ByteFX.Data.MySqlClient.MySqlConnectionString) > in <0x0003c> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open () > in <0x000ef> > ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection () in > <0x0021d> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection () in > <0x00053> ByteFX.Data.MySqlClient.MySqlPool:GetConnection () in > <0x00112> ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection > (ByteFX.Data.MySqlClient.MySqlConnectionString) > in <0x0007c> ByteFX.Data.MySqlClient.MySqlConnection:Open () > > > ## > And with sqlsharp: > > SQL# \Provider MySql > The default Provider is LOADEXTPROVIDER > Assembly: Mono.Data.MySql > Connection Class: Mono.Data.MySql.MySqlConnection > > SQL# \Provider MySqlNet > The default Provider is LOADEXTPROVIDER > Assembly: ByteFX.Data > Connection Class: ByteFX.Data.MySQLClient.MySQLConnection > > SQL# \ConnectionString Server=localhost; Database=db1; UserID=root; > Password=rootpwd; > > SQL# \Open > Attempt to open connection... > Loading external provider... > Error: unable to load the assembly of the provider: ByteFX.Data : File > 'ByteFX.Data' not found. > > Any ideas? > thanks, > Valentina. > > >Scrive Artur Brodowski <[EMAIL PROTECTED]>: > > > > W li¶cie z pon, 28-06-2004, godz. 15:31, [EMAIL PROTECTED] > > pisze: > > > I've mono 1 Beta with Fedora Core 2. > > > I try to test a connection string with MySQL Data Provider > > > (ByteFx), > > > > compilation > > > > > is all right but running failed: > > > > Install latest Mono release (RC has some issues, try Beta 3) - > > ByteFX.Data.dll version shoul be 0.7.6.1. Earlier versions of the > > libary were broken due to namespace changes. > > > > artb. > > -- > > only so many songs can be sung with two lips two lungs and one > > tongue > > ___ > Mono-list maillist - [EMAIL PROTECTED] > http://lists.ximian.com/mailman/listinfo/mono-list ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem with MySQL Data Provider (ByteFx)
Yes...and no... MySQL defaults to "localhost" for hostname if none is provided (assuming you are connecting from the local server of course). However, somewhere along the way "[EMAIL PROTECTED]" is being replaced by "[EMAIL PROTECTED] localdomain" (which is the form most often put in /etc/hosts by default in RedHat, at least). To put it another way, someone is doing a resolver lookup on "localhost" instead of just passing it along when "[EMAIL PROTECTED]" form is used. Reggie has been made aware of this but he points the finger at the authors of the Mono libraries (in other words, it's not his problem and he has no plans to fix it). One workaround is to edit the MySQL user entry to reflect "localhost. localdomain" as well, but this is a poor solution (and impossible if one does not have MySQL admin permissions). For those who are trying to use ByteFX/Mono in a hosted environment (meaning, they are not the MySQL admin), right now they are screwed. THIS NEEDS TO BE ADDRESSED. (I do not have time at present; perhaps in a month or three...otherwise I would dig in myself). Greg On Tue, 2004-06-29 at 16:32 +, Pablo Baena wrote: > This is a permission problem in your Mysql configuration. > > On Tuesday 29 June 2004 14:32, [EMAIL PROTECTED] wrote: > > Hi, > > > > I've just installed Mono Beta 3...but I've still problems: > > > > ## > > [EMAIL PROTECTED] mono]# mcs provaByteFX.cs -r System.Data.dll -r ByteFX.Data.dll > > Compilation succeeded > > [EMAIL PROTECTED] mono]# mono provaByteFX.exe > > > > > > Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Host > > 'localhost.localdomain' is not allowed to connect to this MySQL server > > in <0x000d5> ByteFX.Data.MySqlClient.Driver:ReadPacket () > > in <0x00198> ByteFX.Data.MySqlClient.Driver:Open > > (ByteFX.Data.MySqlClient.MySqlConnectionString) > > in <0x0003c> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open () > > in <0x000ef> ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection () > > in <0x0021d> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection () > > in <0x00053> ByteFX.Data.MySqlClient.MySqlPool:GetConnection () > > in <0x00112> ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection > > (ByteFX.Data.MySqlClient.MySqlConnectionString) > > in <0x0007c> ByteFX.Data.MySqlClient.MySqlConnection:Open () > > > > > > ## > > And with sqlsharp: > > > > SQL# \Provider MySql > > The default Provider is LOADEXTPROVIDER > > Assembly: Mono.Data.MySql > > Connection Class: Mono.Data.MySql.MySqlConnection > > > > SQL# \Provider MySqlNet > > The default Provider is LOADEXTPROVIDER > > Assembly: ByteFX.Data > > Connection Class: ByteFX.Data.MySQLClient.MySQLConnection > > > > SQL# \ConnectionString Server=localhost; Database=db1; UserID=root; > > Password=rootpwd; > > > > SQL# \Open > > Attempt to open connection... > > Loading external provider... > > Error: unable to load the assembly of the provider: ByteFX.Data : File > > 'ByteFX.Data' not found. > > > > > > Any ideas? > > thanks, > > Valentina. > > > > >Scrive Artur Brodowski <[EMAIL PROTECTED]>: > > > > > > W liÂcie z pon, 28-06-2004, godz. 15:31, [EMAIL PROTECTED] pisze: > > > > I've mono 1 Beta with Fedora Core 2. > > > > I try to test a connection string with MySQL Data Provider (ByteFx), > > > > > > compilation > > > > > > > is all right but running failed: > > > > > > Install latest Mono release (RC has some issues, try Beta 3) - > > > ByteFX.Data.dll version shoul be 0.7.6.1. Earlier versions of > > > the libary were broken due to namespace changes. > > > > > > artb. > > > -- > > > only so many songs can be sung with two lips two lungs and one tongue > > > > ___ > > Mono-list maillist - [EMAIL PROTECTED] > > http://lists.ximian.com/mailman/listinfo/mono-list > ___ > Mono-list maillist - [EMAIL PROTECTED] > http://lists.ximian.com/mailman/listinfo/mono-list ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] Problem with MySQL Data Provider (ByteFx)
> > Yes...and no... > > MySQL defaults to "localhost" for hostname if none is > provided (assuming you are connecting from the local server > of course). However, somewhere along the way "[EMAIL PROTECTED]" > is being replaced by "[EMAIL PROTECTED] > localdomain" (which is the form most often put in /etc/hosts > by default in RedHat, at least). To put it another way, > someone is doing a resolver lookup on "localhost" instead of > just passing it along when "[EMAIL PROTECTED]" form is used. > Reggie has been made aware of this but he points the finger > at the authors of the Mono libraries (in other words, it's > not his problem and he has no plans to fix it). This is absolutely not true! I have been made aware of the problem and have not provided a fix for it yet. This does not mean that I am refusing to fix it. When it was mentioned to me before, I suggested (before I even looked at it) that it might have something to do with Mono. Reggie ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list