Event Log Entries

Oct 6, 2011 at 12:06 PM

Hello..

Since doing the manual upgrade of the Helferlein DLL's, I'm starting to get the following entries in the event log for on all the pages which have the Helferlein form on them.  This espeically occurs when a search engine spider crawls the page; google, yahoo, etc.

Any ideas?  Thanks.. -Jeff

P.S.  To protect the innocent, I've changed the Data Source, Initial Catalog, and User ID in this listing.  I've also changed the file:/// location as well.  Otherwise, it's all the same as what is listed in the event log entry.

__________________________________________________________________________________________________________________________________________________
Message: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.PermissionSet.Demand() at System.Data.Common.DbConnectionOptions.DemandPermission() at System.Data.SqlClient.SqlConnection.PermissionDemand() at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at helferlein.DNN.Modules.BabelFish.Data.SqlDataProvider.GetString(Int32 portalID, String locale, String qualifier, String stringKey, String fallBackLocale) at helferlein.DNN.Modules.BabelFish.Business.BabelFishController.GetString(Int32 portalID, String locale, String qualifier, String stringKey, Boolean fromCache) at helferlein.DNN.Modules.Form.UI.Form.Page_Init(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Modules.ModuleHost.InjectModuleContent(Control content) at DotNetNuke.UI.Modules.ModuleHost.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at DotNetNuke.UI.Modules.ModuleHost.get_ModuleControl() at DotNetNuke.UI.Containers.Container.get_ModuleControl() at DotNetNuke.UI.Containers.Container.ProcessModule() at DotNetNuke.UI.Skins.Pane.InjectModule(ModuleInfo objModule) The action that failed was: Demand The type of the first permission that failed was: System.Data.SqlClient.SqlClientPermission The first permission that failed was: <IPermission class="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" AllowBlankPassword="False"> <add ConnectionString="Data Source=DNN_DB;Initial Catalog=DNN_DB_Live;User ID=DNNUser;password=*;" KeyRestrictions="" KeyRestrictionBehavior="AllowOnly"/> </IPermission> The demand was for: <PermissionSet class="System.Security.PermissionSet" version="1"> <IPermission class="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" AllowBlankPassword="False"> <add ConnectionString="Data Source=DNN_DB;Initial Catalog=DNN_DB_Live;User ID=DNNUser;password=*;" KeyRestrictions="" KeyRestrictionBehavior="AllowOnly"/> </IPermission> </PermissionSet> The granted set of the failing assembly was: <PermissionSet class="System.Security.PermissionSet" version="1"> <IPermission class="System.Security.Permissions.FileDialogPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" Access="Open"/> <IPermission class="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" Allowed="ApplicationIsolationByUser" UserQuota="512000"/> <IPermission class="System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" Flags="Execution"/> <IPermission class="System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" Window="SafeTopLevelWindows" Clipboard="OwnClipboard"/> <IPermission class="System.Security.Permissions.UrlIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" Url="file:///C:/Websites/DNN/bin/helferlein_BabelFish.DLL"/> <IPermission class="System.Security.Permissions.ZoneIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" Zone="Internet"/> <IPermission class="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" version="1" Level="SafePrinting"/> </PermissionSet> The assembly or AppDomain that failed was: helferlein_BabelFish, Version=1.1.2.0, Culture=neutral, PublicKeyToken=null The method that caused the failure was: System.Data.IDataReader GetString(Int32, System.String, System.String, System.String, System.String) The Zone of the assembly that failed was: MyComputer The Url of the assembly that failed was: file:///C:/Websites/DNN/bin/helferlein_BabelFish.DLL

Coordinator
Oct 7, 2011 at 12:38 PM

Jeff,

please check the helferlein_BabelFish table. Which fields can you see there?

Best wishes
Michael

Oct 7, 2011 at 2:38 PM

Hello Michael,

I checked this table and there's 174 rows total.  It shows the PortalID, ID, Locale, Qualifier, StringKey, StringText.  StringComment is showing all NULL values.

Thanks.. -Jeff

Coordinator
Oct 8, 2011 at 2:51 PM

Jeff,

that should be ok. Please try to re-install helferlein_BabelFish (do not uninstall, but check the "Repair installation" checkbox during the installation process.

Best wishes
Michael

Oct 12, 2011 at 4:51 PM

Hi Michael,

I installed 2.2.5 as well as repair/installing the BabelFish module yeaterday, and since doing this, aren't seeing the error occur any longer.

I'll keep an eye on it and let you know if it occurs again.

Thanks again for an excellent module and excellent support.. -Jeff