Solved. Installation on Ubuntu Hardy 8.04 and 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.
12/9/2008 12:46:35 AM
Gravatar
Total Posts 1

Solved. Installation on Ubuntu Hardy 8.04 and mySql

After several attempts to make mojoPortal run on an Ubuntu Hardy machine (Apache/2.2.8, Mono 2.0.1 and MySql 5.0.51a), I've found a final workaraound and made it work.

The server was already running a couple of PHP5 applications, so I followed this howto (note: setting prefix /usr/local leads to a lot of problems, so use prefix=/usr in all compilations) to allow Apache2 run both XSP2 and PHP5. Using default packages would uninstall one or the other due to incompatibilities. I downloaded and compiled latest stable Mono and Mod_Mono source tarballs: 2.01

XSP2 now were running ok the test pages, under Apache2, but I smashed against an old mojoPortal intallation problem I already had that made me abandon mojoPortal setup a month ago. But this time I insisted and made it run.

The setup runs but it immediately gives an error: it gives errno: 105 as soon as it tries to create the second table. I googled around very deeply but didn't find anything specific (error 105 is a generic Foreign Key creation error, generally due to inconsistency between data types).

I finally found that ALL FOREIGN KEY statements in Setup/applications/mojoportal-core/SchemaInstallScripts/mssql/2.2.7.8.config have a mismatch in the named foreign table: it appears as lowercase:
CONSTRAINT `FK_mp_PagesSite` FOREIGN KEY (`SiteID`) REFERENCES `mp_sites` (`SiteID`)
gives errno:105

Changing every table name in every statement to the correct case:
CONSTRAINT `FK_mp_PagesSite` FOREIGN KEY (`SiteID`) REFERENCES `mp_Sites` (`SiteID`)
solved the problem and finally, after over a month of headaches made me proudly see my mojoPortal site.

Uh, I also had the no-skin problem as reported in this post and solved manually adding the
<add verb="*" path="*csshandler.ashx" type="mojoPortal.Web.UI.CssHandler, mojoPortal.Web" />
in Web.config.
Joe, it seems that the Web.config.mono is not updated with your last modifications to skinning.

Now I can start creating pages. Thank you all (particulary Joe)!
Hope this helps. Ciao.

12/9/2008 5:41:31 AM
Gravatar
Total Posts 18439

Re: Solved. Installation on Ubuntu Hardy 8.04 and mySql

Hi,

Thanks for letting me know about the script issue. I've fixed it in svn trunk.

My bad on the mono web.config for the current release not having the csshandler.

Running the latest mojoPortal from svn with the latest Mono from svn, Mono can use the main Web.config and there is no longer a need to have a different version.

Best,

Joe

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