green field

Installing under MySQL

The terms of the GPL license preclude me from distributing a version of mojoPortal configured to depend on the MySQL Connector for .NET as this would require mojoPortal also to be licensed under the GPL.  Note that the GPL places no restriction on how end users can use the software but only the terms under which it can be distributed. Fortunately the architecture of mojoPortal is such that the only code with a dependency on the MySQL Connector is contained in a separate library and I can release this library (the MySQL Data Layer for mojoPortal) under the GPL with the only inconvenience being that you the end user must install it in place of the data layer that ships with mojoPortal since I can't distribute mojoPortal as an application with the .NET Connector for MySQL.

What this means is that if you want to use MySQL with mojoPortal, you should download the MS SQL release files and the MySQL Data Layer for mojoPortal. Then you should copy the dlls from the MySql data layer download into the /bin folder overwriting any files by the same name.

Setting up your MySQL database


I assume you have MySQL 4.0.20 or newer installed. It may work with older versions but I have not tested it.

Create a database and a user with full permission to the database. Enter the connection string in the web.config then navigate to yoursiteroot/Setup/Default.aspx Your connection string will be something like this:

Server=localhost;Database=mojoportal;Uid=mojouser;Pwd=mojo

If you get an error: Unable to connect to any of the specified MySQL hosts
See here http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html

make sure your /etc/mysql/my.conf file does not have the "skip-networking" feature enabled. This is the default in some installations and disables tcp/ip connections.

If you have any difficulties please post messages in the forums and I will try to respond as soon as possible.

Additional Resources:

You can download MySQL for Linux or Windows here:
http://www.mysql.com/products/database/mysql/community_edition.html

Additional GUI tools for MySQL are SQLYog and Aqua Data Studio

Books



mojoPortal Wins the 2007 Open Source CMS Awards Best Non-PHP Open Source CMS Donate Money to support the mojoPortal Project. Join the mojoPortal Group on Facebook Join the mojoPortal Group on LinkedIn View Joe Audette's profile on LinkedIn View Joe Audette's profile on The Guild of Accessible Web Designers site mojoPortal can run on GNU/Linux using Mono