[Mono-list] ByteFX
Chris Aitken
chris at ion-dreams.com
Fri Jul 29 11:21:42 EDT 2005
> 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
Does the user have the correct permissions to connect from the webserver
(i.e. username@'%')?
> # 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.
Do you have a port declaration within my.cnf?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
More information about the Mono-list
mailing list