setting up MySql

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
1/23/2008 8:00:30 AM
Gravatar
Total Posts 9

setting up MySql

Hello,

I'm new to mojoportal and trying to get it going. I like what i have seen and read so far.

In the documentation section under database configuration is stated that if you want to use MySQL you should download the MS SQL release files and the MySQL Data Layer. Are these files all included in the source files?

It is also stated that you should use the sharpziplib.dll file. But i can't find it in the data layer download?

thanks for your help,

Rogan

 

1/23/2008 8:20:26 AM
Gravatar
Total Posts 18439

Re: setting up MySql

Hi  Rogan,

If you are working with the source code you don't need any additional downloads, though I recommend you get the code from svn trunk instead of using the .zip.

All you need to do is change the reference from the mojoPortal.Business project to the data layer of your choice, in this case from mojoPortal.Data.MSSQL to mojoPortal.Data.MySql. Then rebuild the solution.

Note that the code from svn is more up to date than the release .zip In recent days I've implemented the MySql data layer for the survey feature and will soon do the same for the Poll feature. To use the Survey you would either use mojoportal-complete.sln or mojoportal-survey.sln, and just as with the main business layer, you need to change the SurveyFeature.Business so it references SurveyFeature.Data.MySql instead of SurveyFeature.Data.MSSQL

Survey and Poll are implemented as separate projects to illustrate how developers can create features that plug in to mojoportal without mingling their custom code in the core. They use post build events to copy their output to the proper location beneath the Web project.

If you are working with the release files (which are pre-compiled and don't include any C# source code) you would follow the instructions here. I've updated it to reflect that sharpziplib is no longer needed.

Hope it helps,

Joe

1/23/2008 9:14:15 AM
Gravatar
Total Posts 9

Re: setting up MySql

Hello Joe,

Thanks for your tips.

I just got my first mojoportal website up and running (using MySql @localhost).

Very impressing, it looks very nice.

I especially like the way you set it up (3 layer architecture and c# object oriented code). This gives us users/developers the flexibility we (i) like.

Rogan

 

You must sign in to post in the forums. This thread is closed to new posts.