[Mono-devel-list] mono-0.93 + debian = problems

[Gonzalo Paniagua Javier]

El mar, 01-06-2004 a las 12:11, Artur Brodowski escribió:
> W liście z wto, 01-06-2004, godz. 10:45 +0200, Gonzalo Paniagua Javier
> napisał:
> > Are you using debian icu 2.6.1 package? I ended up compiling from the
> > original source with an option to configure ('--with-data=files' ?) that
> > made it actually work.
> 
> Thanks Gonzalo, compiling ICU did help, but I still cannot run apps that
> use ByteFX.Data Mysql provider. It's present, and it is seen by mcs:
> 
> $ ls /usr/lib/mono/gac/ByteFX.Data/0.7.6.1__0738eb9f132ed756/
> ByteFX.Data.dll  __AssemblyInfo__
> 
> $ ls -l /usr/lib/mono/1.0/ByteFX.Data.dll
> lrwxrwxrwx    1 root     root           71 May 31
> 16:32 /usr/lib/mono/1.0/ByteFX.Data.dll
> -> /usr/lib/mono/gac/ByteFX.Data/0.7.6.1__0738eb9f132ed756/ByteFX.Data.dll
> 
> $ mcs -r:System.Data -r:ByteFX.Data sample.cs
> Compilation succeeded
> 
> $ mono ./sample.exe
> 
> Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Unable to
> connect to any of the specified MySQL hosts
> in <0x00158> ByteFX.Data.MySqlClient.Driver:Open
> (ByteFX.Data.MySqlClient.MySqlConnectionString)
> in <0x0003c> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open ()
> in <0x000ef> ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection
> ()
> in <0x00215> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection ()
> in <0x00053> ByteFX.Data.MySqlClient.MySqlPool:GetConnection ()
> in <0x0010c> ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection
> (ByteFX.Data.MySqlClient.MySqlConnectionString)
> in <0x0007c> ByteFX.Data.MySqlClient.MySqlConnection:Open ()
> 
> Code is fine, I can log in to the database from shell:
> 
> string connString =
> 	"Server=localhost;" +
>         "Database=dbname;" +
>         "User ID=user;" +
>         "Password=pass";
> dbh = new MySqlConnection(connString);
> dbh.Open();

I think this requires mysql to be listening on a TCP port. Check the
mysql logs.

> 
> Even sqlsharp acts strange:
> 
> $ sqlsharp
> 
> SQL# \provider mysqlnet
> The default Provider is LOADEXTPROVIDER
>           Assembly: ByteFX.Data
>   Connection Class: ByteFX.Data.MySQLClient.MySQLConnection
>  
> SQL# \connectionstring server=localhost;database=dbname;user
> id=user;password=pass
>  
> 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.

sqlsharp has not been updated after the gac addition and needs to be
fixed, but this is unrelated to the previous problem.