Hi Joe,

I have created a databse with the name mojoportal ( the SQL scripts did not work properly, I had to do a lot of editing). I executed the SQL scripts 1,2,3 and 4, edited the webconfig and placed the MySQL dlls as in the documentation in the Bin folder.
On XSP( windows) I get this error:

MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts ---> System.Net.Sockets.SocketException: No such host is known
in <0x0009f> System.Net.Dns:GetHostByName (System.String hostName)
in <0x0014d> MySql.Data.Common.StreamCreator:GetStream (Int32 timeOut)
in <0x00176> MySql.Data.MySqlClient.NativeDriver:Open ()--- End of inner exception stack trace ---

in <0x001ad> MySql.Data.MySqlClient.NativeDriver:Open ()
in <0x00029> MySql.Data.MySqlClient.Driver:Create (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x0008d> MySql.Data.MySqlClient.MySqlPool:CreateNewPooledConnection ()
in <0x001ae> MySql.Data.MySqlClient.MySqlPool:GetPooledConnection ()
in <0x0003f> MySql.Data.MySqlClient.MySqlPool:GetConnection ()
in <0x000e3> MySql.Data.MySqlClient.MySqlPoolManager:GetConnection (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x00041> MySql.Data.MySqlClient.MySqlConnection:Open ()

===================================================================================


Using the Sassini web server, I get something similar:


SocketException (0x2af9): No such host is known]
System.Net.Dns.GetHostByName(String hostName) +270
MySql.Data.Common.StreamCreator.GetStream(Int32 timeOut) +231
MySql.Data.MySqlClient.NativeDriver.Open() +278

[MySqlException: Unable to connect to any of the specified MySQL hosts]
mojoPortal.Web.Global.Application_BeginRequest(Object sender, EventArgs e) +568
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +50
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87


Do you have an idea what exactly I?m doing wrong?

Thanks for your help in advance.

Hi Joe, sorry to have bothered you, I took a look once again at my connection string, the data source was set to "Suse", upon editiong the data source(localhost), mojo portal started up, it works very well now, keep up the good work :-)

Oh, for the record, I dont know if my method has been tried before, I´m running MojoPortal on the free Cassini web server with .net 1.1.


Thanks

Hi there Joe,


First and foremost, congrats on a great-looking portal. I'm really looking forward to being able to
use it!!!

I've got a similar problem going on my server, looked into the above but to no avail...?

I've successfully created the database, granted the mojo user the permission to access the
localhost (a mysql -u mojo -p mojoportal brings me in just fine without being root),

I've made the mods to my Web.config file (I even changed the values for all three connection strings?
just in case... :P).?

An nslookup resolves just fine to the usual 127.0.0.1, and a rename to web.config seems to confuse
the app (I get a null ref exception...? If I have both Web.config and web.config in the folder,
the connection error occurs rather than the null ref)
I've kind of run out of ideas, any suggestions?
FYI: Mandriva Linux 2005, mono 1.1.9 installed via the installer, MySQL, attempting to run
mojoportal via XSP, no extra changes made to the Web.config file.?
When attempting to run mojoportal, running XSP as root.
My database changes (used loopback address but also localhost):

Thanks in advance and best regards,

Rick

Thanks for the quick reply!? I've actually got a slightly older version,? 4.1.11... Tried to check what the latest version supported by the connector is, without success...? Do you know if this version works?

Here's the stack trace:

Server error in '/' application
Description: Error processing request.

Error Message: HTTP 500.

Stack Trace:

MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts
in <0x006c5> MySql.Data.MySqlClient.NativeDriver:Open ()
in <0x00027> MySql.Data.MySqlClient.Driver:Create (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x0008d> MySql.Data.MySqlClient.MySqlPool:CreateNewPooledConnection ()
in <0x001b0> MySql.Data.MySqlClient.MySqlPool:GetPooledConnection ()
in <0x0003f> MySql.Data.MySqlClient.MySqlPool:GetConnection ()
in <0x000e5> MySql.Data.MySqlClient.MySqlPoolManager:GetConnection (MySql.Data.MySqlClient.MySqlConnectionString settings)
in <0x00050> MySql.Data.MySqlClient.MySqlConnection:Open ()

Thanks again in advance,
Rick.

Yup, that did the trick!

Thank you very much Joe, and sorry for the trouble...

All the best,
Rick.