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 +0000, 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
