[Mono-list] Problem with MySQL Data Provider (ByteFx)

[Gregory Junker]

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 "user@localhost" is being replaced by "user@localhost.
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
"user@servername" 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 +0000, Pablo Baena wrote:
> This is a permission problem in your Mysql configuration.
> 
> On Tuesday 29 June 2004 14:32, beniniva@csr.unibo.it wrote:
> > Hi,
> >
> > I've just installed Mono Beta 3...but I've still problems:
> >
> > ##############
> > [root@or2 mono]# mcs provaByteFX.cs -r System.Data.dll -r ByteFX.Data.dll
> > Compilation succeeded
> > [root@or2 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 <bzdurqa@wp.pl>:
> > >
> > > W li¶cie z pon, 28-06-2004, godz. 15:31, beniniva@csr.unibo.it 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  -  Mono-list@lists.ximian.com
> > http://lists.ximian.com/mailman/listinfo/mono-list
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list