i installed mojoportal on a mac os x tiger 10.4.2

* Mono.Framework 1.1.8
* Apache 2.0.54
* xsp 1.0.9
* mod_mono 1.0.9
* MySQL 4.0.21



all its ok
but my connection to mysql server fail

Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts
in <0x007e4> MySql.Data.MySqlClient.NativeDriver:Open ()
in <0x0004c> MySql.Data.MySqlClient.Driver:Create (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x000f4> MySql.Data.MySqlClient.MySqlPool:CreateNewPooledConnection ()
in <0x002fc> MySql.Data.MySqlClient.MySqlPool:GetPooledConnection ()
in <0x00060> MySql.Data.MySqlClient.MySqlPool:GetConnection ()
in <0x00190> MySql.Data.MySqlClient.MySqlPoolManager:GetConnection (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x00068> MySql.Data.MySqlClient.MySqlConnection:Open ()

the version of mysql is 4.0.21, help me!, from navicat i can connect to the database mojoportal.

thanks Joe but...

my connection string it's correct
Data Source=localhost;Database=mojoportal;User ID=root;Password=123;

i can connect to database from navicat and mysql command line

ibook-g4-de-juan-manuel:/usr/local/apache2/htdocs/mojoportal/bin root# /usr/local/mysql/bin/mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor.? Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 4.0.21 Complete MySQL by Server Logistics

Type help or \h for help. Type \c to clear the buffer.

mysql


i try

telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
Escape character is ^.

4.0.21 Complete MySQL by Server Logistics

and it's ok

i do a test program

using System;
using MySql.Data;
using MySql.Data.MySqlClient;

class Test
{

public static void Main( string[] args )
{
Console.WriteLine(abriendo base de datos...)
MySqlConnection connection = new MySqlConnection(Data Source=localhost
Database=test;User ID=root;password=123;};
connection.Open();
connection.Close();
Console.WriteLine(cerrando base de datos...);
}

}

to test the connection but the error is the same

ibook-g4-de-juan-manuel:/usr/local/apache2/htdocs/mojoportal/bin root# mono mysqltest.exe
abriendo base de datos...

Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts
in <0x007e4> MySql.Data.MySqlClient.NativeDriver:Open ()
in <0x0004c> MySql.Data.MySqlClient.Driver:Create (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x000f4> MySql.Data.MySqlClient.MySqlPool:CreateNewPooledConnection ()
in <0x002fc> MySql.Data.MySqlClient.MySqlPool:GetPooledConnection ()
in <0x00060> MySql.Data.MySqlClient.MySqlPool:GetConnection ()
in <0x00190> MySql.Data.MySqlClient.MySqlPoolManager:GetConnection (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x00068> MySql.Data.MySqlClient.MySqlConnection:Open ()


also try with 127.0.0.1

my hosts file

ibook-g4-de-juan-manuel:/etc root# more hosts
##
# Host Database
#
# localhost is used to configure the loopback interface
# when the system is booting.? Do not change this entry.
##
127.0.0.1 ocalhost
255.255.255.255 broadcasthost

192.168.0.1 z7.mshome.net

any other solution.

What I think is happening here is, it's trying to connect via socket. Traditionally I believe if you specify localhost in comparison to 127.0.0.1 the mysql driver will look for a socket, but if you specify an ip or include in the connection string a port number you'll be able to connect via tcp/ip.

An example connection string would be:
Data Source=localhost;Port=3306;Database=mojoportal;User ID=root;Password=123;
or possibly (port added in this example just to be on the safe side)
Data Source=127.0.0.1;Port=3306;Database=mojoportal;User ID=root;Password=123;

also here is some information about connection strings from mysql about their connector.