[Bsd-sharp-list] mono 1.1.13.6 and mysql-connector-net-1.0.8 problem

[Phillip Neumann]

El mié, 13-12-2006 a las 22:50 -0600, Mike Geise escribió:
> I have been having a problem with the mono on freebsd and mysql
> connector.
>  
> basically I cannot connect. I searched this error and found some
> information on it and tried a few things but still no luck.
>  
> I made sure skip-networking was disabled
>  
> tried connection with ip 127.0.0.1, localhost and unix
> socket /tmp/mysql.sock
>  
> anyone have an idea?
>  
> Exception.
>  
> Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Unable to
> connect to
> in <0x006e1> MySql.Data.MySqlClient.NativeDriver:Open ()
> in <0x00027> MySql.Data.MySqlClient.Driver:Create
> (MySql.Data.MySqlClient.MySqlC
> in <0x000b2> MySql.Data.MySqlClient.MySqlConnection:Open ()
>  
>  

Hi mike..

Im not a user of mysql myself..

but ive try to run the example on http://www.mono-project.com/MySQL
using the ByteFX mysql provider and i saw a similar output:


Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Unable to
connect to any of the specified MySQL hosts --->
System.Net.Sockets.SocketException: No such host is known
  at System.Net.Dns.hostent_to_IPHostEntry (System.String h_name,
System.String[] h_aliases, System.String[] h_addrlist) [0x00000] 
  at System.Net.Dns.GetHostByName (System.String hostName) [0x00000] 
  at ByteFX.Data.Common.StreamCreator.GetStream (Int32 timeOut)
[0x00000] 
  at ByteFX.Data.MySqlClient.Driver.Open
(ByteFX.Data.MySqlClient.MySqlConnectionString settings) [0x00000] ---
End of inner exception stack trace ---
 
  at ByteFX.Data.MySqlClient.Driver.Open
(ByteFX.Data.MySqlClient.MySqlConnectionString settings) [0x00000] 
  at ByteFX.Data.MySqlClient.MySqlInternalConnection.Open () [0x00000] 
  at ByteFX.Data.MySqlClient.MySqlConnection.Open () [0x00000] 


thats when connecting to the IP.

after i map the ip on hosts and change the DSN to connect to that
hostname, i get:
 Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Host
'10.0.0.100' is not allowed to connect to this MySQL server

looks like it works.

its wired tho, becouse 
System.Net.Dns.GetHostByName("10.0.0.67").AddressList[0].ToString();
prints out 10.0.0.67....

anyway. Could you try to do the host mapp?...



thanks!


PS: this is with mono 1.2.2


> Thanks, Mike
> _______________________________________________
> Bsd-sharp-list mailing list
> Bsd-sharp-list at forge.novell.com
> 
> Home Page: http://www.mono-project.com/Mono:FreeBSD
> Project Site: http://forge.novell.com/mailman/listinfo/bsd-sharp-list
> IRC: #BSD-Sharp on irc.freenode.org