MySQL Bugs: #45980: Profile Provider Fails on Shared Web Hosting

Bug #45980	Profile Provider Fails on Shared Web Hosting
Submitted:	6 Jul 2009 19:14	Modified:	7 Jul 2009 10:09
Reporter:	Darlington Adibe	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	6.0.4	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Profile Provider fail with the following error when saving profil data.

runs fine on my local testing system, but when i upload to my Share hosting Account with GoDaddy i get the following error

Server Error in '/livesms/pages' Application.
--------------------------------------------------------------------------------

Security Exception 
Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. 

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 

[SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]
   MySql.Web.Profile.MySQLProfileProvider.EncodeProfileData(SettingsPropertyValueCollection collection, Boolean isAuthenticated, String& index, String& stringData, Byte[]& binaryData) +0
   MySql.Web.Profile.MySQLProfileProvider.SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection collection) +214
   System.Configuration.SettingsBase.SaveCore() +375
   System.Configuration.SettingsBase.Save() +93
   System.Web.Profile.ProfileBase.SaveWithAssert() +31
   System.Web.Profile.ProfileBase.Save() +63
   System.Web.Profile.ProfileModule.OnLeave(Object source, EventArgs eventArgs) +8773900
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

 

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3072 

How to repeat:
Just try to save and retrive profile data

My Profile defination in my web.config is follow

    <profile defaultProvider="MySQLProfileProvider" enabled="true" automaticSaveEnabled="true">
      <providers>
        <clear/>
        <add connectionStringName="LiveSMSDB" name="MySQLProfileProvider" applicationName="/" autogenerateschema="true"
             type="MySql.Web.Profile.MySQLProfileProvider, MySql.Web" />
      </providers>
      <properties>
        <clear/>
        <!--<add name="Detail" type="Triative.LiveSMS.DashBoard.AccountDetail" serializeAs="Xml" allowAnonymous="false" provider="MySQLProfileProvider"/>-->
        <group name="Account">
          <add name="SenderID"  serializeAs="Xml" allowAnonymous="false" type="String" defaultValue="LiveSMS"/>
          <add name="Balance" serializeAs="Xml" allowAnonymous="false" type="int" defaultValue="10" />
        </group>
        <group name="Contact">
          <add name="FirstName" serializeAs="Xml" allowAnonymous="false" type="String" defaultValue="" />
          <add name="LastName" serializeAs="Xml" allowAnonymous="false" type="String" defaultValue="" />
          <add name="MobilePhone" serializeAs="Xml" allowAnonymous="false" type="String" defaultValue="" />
          <add  name="Organisation" serializeAs="Xml" allowAnonymous="false" type="String" defaultValue=""/>
        </group>
        <group name="Options">
          <add name ="ReceiveMails" serializeAs="Xml" allowAnonymous="false"  type="Boolean" defaultValue="true"/>
          <add name ="ReceivePartnerMails" serializeAs="Xml" allowAnonymous="false" type="Boolean" defaultValue="true"/>
          <add name ="HTMLMailFormat" serializeAs="Xml" allowAnonymous="false" type="Boolean" defaultValue="true"/>
        </group>
      </properties>
    </profile>

Suggested fix:
None

Hi Adibe and thanks for your report.

I believe it is a duplicate of verified one (Bug#45153). Can you please confirm my suspicion by giving the connector full trust or put it in the GAC? If your code works after this change then we have a duplicate.

It works well on my Testing/Developing computer with the dll in the Bin folder.
it only fails when I upload to my shared hosting account on GoDaddy.

I can't chnage the trust level on the hosting server nor can I Add it the GAC

I strongly feel this is the same problem as reported in Bug#45153 so I'm marking your report as duplicate.

So is there any solution or work around to this yet?

Besides two I already gave, no... I'm trying to escalate the original report now.

seem to be exactly my problem

http://forums.mysql.com/read.php?38,272948,272948#msg-272948

it's my problem too... and i'm using the connector 6.1.2.
Any workaround?

I have the same problem with darlington.  works great on dev machine but when uploaded to godaddy profile provider fails because of the trust level issue.

so is there a workaroun already?

I have the same problem with darlington.  
works in the dev machine but when uploaded to uolhost fails because of the trust level issue (Medium Trust).

so is there a workaroun already?

Are this bug forgotten???
There is any plan to solve it?

I have same problem on GoDaddy and can also recreate if I set security policy to medium on my local machine.

Looking through the source code, the problem is EncodeProfileData / DecodeProfile Data - there is a call to SettingsPropertyValue.SerializedValue. This causes the security exception.

For myself, I've rebuilt it and removed the serialized Option.

Sending note to Reggie.

Has this buy been fixed?  I am  using Connector 6.2.4 and having the same issues.