Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Murray Roke 503 posts 966 karma points c-trib
    Mar 28, 2010 @ 04:04
    Murray Roke
    0

    How to install without runway?

    Hi

    I don't have runway on the site I wish to add OpenId, do you have a way for me to install your package?

    Cheers.

    Murray.

  • Harald Ulriksen 207 posts 249 karma points
    Jun 14, 2010 @ 23:16
    Harald Ulriksen
    1

    Hi Murray,

    it installas just fine, but you will have to create signin page manually.

    Sorry for the late response,
    Harald

  • Murray Roke 503 posts 966 karma points c-trib
    Jun 27, 2010 @ 07:07
    Murray Roke
    0

    Hi Harald,

    I looked in the package.xml file and it looks like everything is set-up. (except perhaps the package Action "OpenIdPackageAction"

    Also, should there be some modification to the member types?

    the exception I get occurs after returning from my openID provider page.

    [SqlException (0x80131904): Invalid object name 'nuMemberOpenid'.]
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
    System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
    System.Data.SqlClient.SqlDataReader.get_MetaData() +83
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
    System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
    Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +95
    Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +118
    umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters) in C:\Users\Niels Hartvig\Desktop\umbraco\branches\rb403\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:51
    umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in C:\Users\Niels Hartvig\Desktop\umbraco\branches\rb403\umbraco\datalayer\SqlHelper.cs:194

    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
    umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in C:\Users\Niels Hartvig\Desktop\umbraco\branches\rb403\umbraco\datalayer\SqlHelper.cs:198
    Ulriksen.Umbraco.OpenId.OpenIdMember.GetMember(String claimedIdentifier) +197
    Ulriksen.Umbraco.OpenId.Web.OpenId.Page_Load(Object sender, EventArgs e) +491
    System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
    System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
    System.Web.UI.Control.OnLoad(EventArgs e) +99
    System.Web.UI.Control.LoadRecursive() +50
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.AddedControl(Control control, Int32 index) +265
    System.Web.UI.ControlCollection.Add(Control child) +80
    System.Web.UI.WebControls.LoginView.CreateChildControls() +215
    System.Web.UI.Control.EnsureChildControls() +87
    System.Web.UI.Control.PreRenderRecursiveInternal() +44
    System.Web.UI.Control.PreRenderRecursiveInternal() +171
    System.Web.UI.Control.PreRenderRecursiveInternal() +171
    System.Web.UI.Control.PreRenderRecursiveInternal() +171
    System.Web.UI.Control.PreRenderRecursiveInternal() +171
    System.Web.UI.Control.PreRenderRecursiveInternal() +171
    System.Web.UI.Control.PreRenderRecursiveInternal() +171
    System.Web.UI.Control.PreRenderRecursiveInternal() +171
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

  • Harald Ulriksen 207 posts 249 karma points
    Jun 27, 2010 @ 20:37
    Harald Ulriksen
    0

    It's the extra database table which is missing. Is done as a part of the package action.


    If you didn't run the installer you will need to create the table manually.

     CREATE TABLE [dbo].[nuMemberOpenid](
    [OpenId] [varchar](255) NOT NULL,
    [nodeId] [int] NOT NULL,
    CONSTRAINT [PK_nuMemberOpenid] PRIMARY KEY CLUSTERED
    (
    [OpenId] ASC
    )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
    )


    I also have a trigger on the cmsMember table to make sure openid's are deleted when the member is removed.

       CREATE TRIGGER [CascadeDeleteOpenId]
    ON [dbo].[cmsMember]
    AFTER DELETE
    AS
    BEGIN
    SET NOCOUNT ON;
    delete from nuMemberOpenId where nodeId in (select nodeId from deleted)
    END

    Hope this helps,
    Harald

  • Harald Ulriksen 207 posts 249 karma points
    Nov 19, 2010 @ 14:43
    Harald Ulriksen
    0

    The package action has now been updated and the package should install fine without Runway, tested with 4.5.0.2. However, it will only install pages for open id if it can find the Runway homepage. 

    To use OpenId you will have to manually add the macros to your templates/pages. 


Please Sign in or register to post replies

Write your reply to:

Draft