Re: Problems with Mono MySQL 4 and up connectivity
Are you having this problem with mojoportal or with your own app? I'm guessing your own app since mojoportal no longer uses the ByteFX driver.
It could be your problem would go away with the newer Connector for .NET available on the MySQL site but I know I used ByteFX with MySQL 4.0.23 before myself and it worked for me.
You are using the same user in the connection string as for the phpmysql and all of it is running on the same server localhost?
In answer to the question about compiling. I compiled ByteFX and also the newer connector on windows and used it on linux no problem. When you compile in VS.NET you have to use Rebuild instead of Build so that it doesn't do an incremental build.
I've never tried installing it in the GAC on linux, but for a compiled web app just drop the dll in the bin folder with everything else and it will use it.
It really sounds like it has to be one of a few possible things
- MySQL is not configured to accept tcp/ip connections
- The user does not have permission to connect from the host that the web is running on to the host that the db is running on
- The web server is able to resolve the name of the db server
- a bad connection string, your looks ok but mine is slightly different so it may be worth an experiment
Data Source=localhost;Database=mojo;User ID=mojo;Password=mojo
It could possibly be a bug in mono 1.1.8 but that is not my first suspect
Are you developing on linux or windows?
Are you compiling your web code to a dll or running it inline in scripts tags
The fact that the table editor couldn't connect supports a permission issue as a possibility
You might also post at www.gotmono.com forums