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 licie 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
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)
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)
W licie 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
