MySQL and OpenId problems in Medium Trust Environment

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.
10/21/2007 1:41:26 PM
johnc
Gravatar
Total Posts 5
View Posts

MySQL and OpenId problems in Medium Trust Environment

I am working with the latest and greatest code from your SVN repository.  I compiled everything (I'm not making any code changes) and wanted to run on my shared host with MySQL 5.  I've read all the medium trust info and seemed to gain some ground, but hit a dead end with the OpenID piece.  I thought I'd give some info here in hopes that some of it will help others and maybe you can offer me some help with the part I still can't get working.

I quickly ran into the MySQL permission issues in medium trust.  I downloaded the latest beta version of the connector (5.1.3), installed, changed all the references in the mojo-complete solution to point to the new version I installed and recompiled everything.  I uploaded to my host and the MySQL piece worked.  I was able to get the database setup and running using the normal setup process.  Looks like the new MySQL connector is going to help a lot in the shared hosting world.

I set the EnableOpenIDAuthentication to false in the web.config, as well as made all the other medium trust changes.  I deleted the Janrain.OpenId dll files from the bin folder.  The portal comes up to the main web page.  I can do a site map and some other things just fine, no errors.  But when I click on the login link I get an error that it cannot find the mojoOpenIdLogin control.  Seems this piece of code is not working.

<portal:mojoOpenIdLogin ID="OpenIdLogin1" runat="server" CssClass="openid_login"
RequestCountry="Request" RequestEmail="Require" RequestGender="Request"
RequestPostalCode="Request" RequestTimeZone="Request"
/>

I can't seem to figure this one out.  I'm not seeing any compiler errors or warnings in this area.

I gotta say, this medium trust stuff stinks.  MS and the vendors have to do something about this.  There are just so many people using shared hosting environments, they're hurting their market penetration if they can't support medium trust more easily.  I see MySQL figured it out and is working on this in their next version.  More need to do the same.

10/21/2007 5:00:06 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: MySQL and OpenId problems in Medium Trust Environment

Hi,

I'm not sure I'm following you on the MySql connector. As far as I understand no data access is allowed in medium trust unless the data access provider is in the Global Assembly Cache (GAC) so for MySql connector to work the connector must be in the GAC so in a hosted environment the host must install it in the GAC. It sounds like you are saying that the 5.1.3 version works without being installed in the GAC? I would love for that to be true but its hard to imagine it is. Since the the MS libraries are inthe GAC by default or defacto MS SQL has a little advantage here. But I would think that hosts offering MySql databases for ASP.NET hosting would surely have this in the GAC.

I'm not sure whether the open id stuff could be made to work in medium trust if the janrain library was in the GAC but maybe. You can disable it and bypass it by Setting EnableOpenIDAuthentication = false in Web.config and delete Janrain.OpenId.dll from the bin folder so the site can run in medium trust without open id support.

Hope it helps,

Joe

10/21/2007 6:20:29 PM
johnc
Gravatar
Total Posts 5
View Posts

Re: MySQL and OpenId problems in Medium Trust Environment

Yes, I am saying that the latest MySql connector supports medium trust.  See this blurb here: http://forums.mysql.com/read.php?38,174299,174680

As for the EnableOpenIDAuthentication, I have done what you say (setting value in web.config to false and deleting the DLLs from the BIN folder) but I am getting the error described in my original post.  This solution doesn't seem to work.

 

10/23/2007 3:19:13 PM
johnc
Gravatar
Total Posts 5
View Posts

Re: MySQL and OpenId problems in Medium Trust Environment

Can anyone help me with the OpenId error on the login page?  I've done what Joe said to do to make it work in Medium Trust and I simply cannot get to the login page.  What am I doing wrong?

10/23/2007 3:56:44 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: MySQL and OpenId problems in Medium Trust Environment

Hi,

Try opening Secure/Login.aspx with a text editor and cut out this part:

<portal:OpenIDLoginControl id="oidLogin" runat="server"></portal:OpenIDLoginControl>

also make sue this is set to false in Web.config and user.config if using a user.config file:

<add key="EnableOpenIDAuthentication" value="false" />

and delete the janrain stuff from bin folder.

Hope it helps,

Joe

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