[Mono-list] ByteFX

[Joe Audette]

Try it with just localhost instead of
localhost.localdomain


Hope it helps,

Joe

--- Julien Sobrier <julien at sobrier.net> wrote:

> Hello,
> I have issues to use ByteFx with Mono 1.1.6/Linux:
> using System.Data;                              //
> needed?
> using ByteFX.Data.MySqlClient;
> 
> string connectionString =
> "Server=localhost.localdomain;" + 
>                                                     
>           "User 
> ID=xxx;" + 
>                    "Password=xxx;" + 
>                                  "Database=db;";
> 
> IDbCommand dbcon = new
> MySqlConnection(connectionString);
> Console.WriteLine("connection created");
> 
> dbcon.Open();
> Console.WriteLine("connection opened");
> 
> I got the exception:
> ByteFX.Data.MySqlClient.MySqlException: Unable to
> connect to any of the 
> specified MySQL hosts
> in <0x00345> ByteFX.Data.MySqlClient.Driver:Open 
> (ByteFX.Data.MySqlClient.MySqlConnectionString
> settings)
> in <0x00039>
> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open
> ()
> in <0x000b1>
>
ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection
> ()
> in <0x0018a>
>
ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection
> ()
> in <0x00042>
> ByteFX.Data.MySqlClient.MySqlPool:GetConnection ()
> in <0x000cf>
>
ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection
> 
> (ByteFX.Data.MySqlClient.MySqlConnectionString
> settings)
> in <0x0004b>
> ByteFX.Data.MySqlClient.MySqlConnection:Open ()
> 
> 
> But I have no problem connecting directly to mysql
> with "mysql -u xxx -p";
> 
> Messages on internet point out to a bad MySQL
> configuration. It looks 
> like ByteFX use a TCP/IP connection. I checked
> /etc/my.cnf, I don't have 
> anyuthing like "skip-network" enabled:
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> 
> # Default to using old password format for
> compatibility with old and
> # shorter password hash.
> # Reference:
>
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
> old_passwords=1
> 
> [mysql.server]
> user=mysql
> basedir=/var/lib
> 
> [mysqld_safe]
> err-log=/var/log/mysqld/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> 
> I guess ByteFX should use the loopback interface. I
> did a "tcpdump -s 0 
> -i lo -w /tmp/mysql.pcap" but I ddin't see any
> traffic.
> 
> Any idea on why I cannot connect to MySQL with
> ByteFX?
> 
> Thank you
> Julien Sobrier
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 


joe_audette [at] yahoo dotcom
http://www.joeaudette.com
http://www.mojoportal.com