Can I change port used while HTTPS access???

This is a forum to suggest new features for mojoPortal. 

This thread is closed to new posts. You must sign in to post in the forums.
8/21/2005 4:02:01 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Can I change port used while HTTPS access???

In the MSSQLData folder there is a script for the upgrade to the next release, upgradefrom20050710to.sql
run that then re-run the script to create all stored procs 3mojoPortal.MSSQL.CreateStoredProcedures.sql

That should get you past this error.

No reason you can't debug as long as you have IIS and Developer tool. On Windows we are not using mono but .NET 1.1. I compile on windows against .NET 1.1 and then deploy to a mono machine and it works fine but if you are using Windows for deployment target you have no need of mono for anything.
8/21/2005 4:02:56 AM
Petr Antos
Gravatar
Total Posts 25
View Posts

Re: Can I change port used while HTTPS access???

Joe, hope I have found field type in source (nvarchar[20]), so I will try to correct db now.

edit:

Thanks, yes, things are not as easy... I will do through scripts.

NOTE:

With Rainbow, I have never reached this level of understanding, never successfuly compiled the beast, never have so good online support, never have up-and-running localized portal less than 24 hours from "first contact".

mojoPortal is great, everything works like a charm!

8/21/2005 5:50:02 AM
Petr Antos
Gravatar
Total Posts 25
View Posts

Re: Can I change port used while HTTPS access???

oh, little trouble at my internet connection side....
As I started stored procedures (re)creating script, connection was lost during this process,
so my question is:

Are database maintenance scripts fully recoverable itself from this kind of trouble?
Are maintenance transactioned at some small step level?
Can I hope that simply restarting script again does "remaining" undone steps correctly, or that some warning will be shown in case of inconsistency?

Yes, I will rerun script  again right now, simply I want to be SURE and hope all new deployers want it too :-)
 
Petr

8/21/2005 6:22:53 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Can I change port used while HTTPS access???

The MS SQL upgrade script is mostly transacted so you should be able to try and run it again.

You can always run the stored procedure script over and over as many times as you want, it replaces the procedures every time so it should never fail, though you may get one warning about dependency you can ignore it.
8/21/2005 6:48:18 AM
Petr Antos
Gravatar
Total Posts 25
View Posts

Re: Can I change port used while HTTPS access???

OK, seems that runing SP script again already does not warn .... instead, I have result, which says that language was changed to Czech, who knows ....

But BIG progres happened! 10 minutes ago I have successfully started mojoPortal again,
signing up through SSL?:-)

web.config contains this:


At first attempt, I leaved "MapAlternatePort" at "false", which was not good. I am?only little confused WHY is it setup that way ...

BUT, there is (and was before) trouble when I want to show MemberList.aspx. Before I have always custom error page shown, but now I can see?following message. This trouble exist only in MemberList until now. Relates to database COLLATION which is well know problem while localizing?any DB projects. While playing with RainbowPortal, I have changed my database default collation to "SQL_Latin1_General_CP1_CI_AS" as "quite most neutral" and required by them ...

Error report is here:

Server Error in '/2005' Application.
--------------------------------------------------------------------------------

Cannot resolve collation conflict for equal to operation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation.

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:

[SqlException: Cannot resolve collation conflict for equal to operation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
mojoPortal.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +147
mojoPortal.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +88
mojoPortal.Data.dbPortal.SiteUser_GetUserListPage(Int32 SiteID, Int32 PageNumber, Int32 PageSize, String UserNameBeginsWith) +703
mojoPortal.Business.SiteUser.GetUserListPage(Int32 SiteID, Int32 PageNumber, Int32 PageSize, String UserNameBeginsWith) +13
mojoPortal.Web.MemberList.PopulateControsl() +55
mojoPortal.Web.MemberList.Page_Load(Object sender, EventArgs e) +519
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750





--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
8/21/2005 6:56:42 AM
Petr Antos
Gravatar
Total Posts 25
View Posts

Re: Can I change port used while HTTPS access???

BTW, why this method name? :-))

mojoPortal.Web.MemberList.PopulateControsl() +55

8/21/2005 7:13:06 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Can I change port used while HTTPS access???

Uuhg.. Its because the table creation script has the COLLATE SQL_Latin1_General_CP1_CI_AS on every table

I try to remember to remove them but every time I re-create the script MS SQL puts it back in there.

You should be able to use whatever collation you want but because my machine is setup with latin it does that every time I generate the table scripts.

You will need to remove that from every table create statement and re-create the tables.

Or

I will do that to my copy in just a few minutes and commit to svn if you want to wait as few minutes
8/21/2005 7:15:51 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Can I change port used while HTTPS access???

I've commited the corrected script. If you re-create the tables you don't need to run the upgrade script becuase the latest table scripts have all the changes.
8/21/2005 7:20:07 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Can I change port used while HTTPS access???

>BTW, why this method name? :-))
mojoPortal.Web.MemberList.PopulateControsl()

Its UI code thats what it does, it populate UI controls

> MapAlternatePort
is used in proxy situatuations like at my hosting company grokthis.net they give me my own instance of apache2 running on port 8046 and they map port 80 requests to it using a proxy server, anytime using any non standard ports it should be true, in your case you are only using non standard for ssl but you still need true.
8/21/2005 7:36:10 AM
Petr Antos
Gravatar
Total Posts 25
View Posts

Re: Can I change port used while HTTPS access???

Hmm, now I dont know if you understood me, or if we understand ourself at all :-) ...

My default DB collation ***ALREADY IS*** "SQL_Latin1_General_CP1_CI_AS" and as I know, Rainbow developers removed all explicit collation settings in scripts too.

In mojoPotal, are you doing things the same way? I understand that I can have only one default DATABASE collation, fortunatelly changeable for each one hosetd (against MSSQL7?). Sometimes, there may be trouble with default SERVER colaltion, so app must be well written for neutrality, OK (In my case, I could not remember, but my hosting provider has Czech_CI_AS as SERVER default..., We MUST hope OK?). Tables are created without explicit collation, so inheriting DATABASE default, OK?.

I dont want to have "Czech_CI_AS" or anything special colaltion setup at least on CORE mojoPortal tables. I want in future to be able to store and handle (of course, mainly SORT) MULTILANGUAGE CONTENT in some usable way too. As I know SQLServer (very little..) it is possible to specify col¨lation at QUERY RESULT LEVEL, which seems for me as best case. To be exact, I think that this is even required at PRESENTATION layer queries at all, handling all internal DB processes as fast as possible using fastest BINARY collation...

!!! oh "mea culpa" - my favourite colaltion is of course anything BINARY, no case/accent sensitivity at table level... (but I have database setup as is, as it required Rainbow....)

Excuse me that long post about this issuse, but it is IHMO essential for proper culture neutrality on mojo, and I want to discuss it ASAP ...

thanks for your great support,
Petr

8/21/2005 7:43:19 AM
Petr Antos
Gravatar
Total Posts 25
View Posts

Re: Can I change port used while HTTPS access???

>>BTW, why this method name? :-))
>mojoPortal.Web.MemberList.PopulateControsl()

>Its UI code thats what it does, it populate UI controls

 OK, but why are you populating "Controsl" ...

(excuse me, I am trying to regulary eat "own dog food" as you like; and may be today I have overload you ...)

Petr


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