Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




migrating from 2.2.6 to v3_1_1 i get error Firefox has detected that the server is redirecting the r

web-app

after upgrading from 2.2.6 to v311 i get error Firefox/IE etc has detected that the server is redirecting the request for this address in a way that will never complete.

I followed all steps ad documented in the manual:
CreateTables.sql
Create
Views.sql
CreateProcs.sql

Upgrade
v3-0-Step1.sql
Upgradev3-0-Step2.sql

I have set all permissions on the database as I have on my current production.
webconfig file has been modified to point to my test db but I still get this error.
at first I was getting permission errors on gemini
users but I took care of that.

This is the complete error I get:
"Redirect Loop
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.  

The browser has stopped trying to retrieve the requested item. The site is redirecting the request in a way that will never complete.

    * Have you disabled or blocked cookies required by this site?
    * NOTE: If accepting the site's cookies does not resolve the problem, it is likely a server configuration issue and not your computer."

The error displays right after I click on Login, what can the problem be?  I cleared all cookies/temps files, etc...tried different machines with the same results.

when I run fiddler to see if I can capture any type of error it just loops between the following urls
http://gemini.themls.com/GeminiB/default.aspx
http://gemini.themls.com/GeminiB/Main.aspx
http://gemini.themls.com/GeminiB/Default.aspx?x=1
http://gemini.themls.com/GeminiB/Main.aspx?x=1
http://gemini.themls.com/GeminiB/Default.aspx?x=1
http://gemini.themls.com/GeminiB/Main.aspx?x=1
http://gemini.themls.com/GeminiB/Default.aspx?x=1
http://gemini.themls.com/GeminiB/Main.aspx?x=1
etc....

I query the geminierrorlog and this is what has been recorded:
Error message
Invalid object name 'gemini
applicationsettings'.

stacktrace
 SOURCE: .Net SqlClient Data Provider TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean) STACKTRACE:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()     at System.Data.SqlClient.SqlDataReader.get_MetaData()     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Bool


Now I have verified my application settings and the only thing I have modified is the FullGeminiURL to point to my test environment which is correct since I'm actually able to get to the login page.  But I think the error log is not related to what the problem i'm seeing now.
Thank you in advance.

garifo
· 1
garifo
Replies (6)
helpful
0
not helpful

Please make sure that the SQL user that Gemini is using can see the table (gemini_applicationsettings) and all gemini objects. It might be that you run the upgrade under another user.

Also, make sure that the application pool is .NET calssic (IIS7).


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

how to I do this "make sure that the application pool is .NET calssic (IIS7)"

I'm currently running on IIS 5.

thank you,

garifo


garifo
· 1
garifo
helpful
0
not helpful

This only applies to IIS7. It seems like the issue is with your database permissions as it complains that it can not find the settings table.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

No that error is gone like I mentioned on my issue description on the ticket.
The issue is that now I just keep getting this error message
"Firefox has detected that the server is redirecting the request for this address in a way that will never complete."  The browsers gets stuck on a redirect loop after I click on login.  I have restore my db back to the original state a few times now but I still have the same issue.

I cleared all cookies/temps files, etc...tried different machines with the same results.

when I run fiddler to see if I can capture any type of error it just loops between the following urls
http://gemini.themls.com/GeminiB/default.aspx
http://gemini.themls.com/GeminiB/Main.aspx
http://gemini.themls.com/GeminiB/Default.aspx?x=1
http://gemini.themls.com/GeminiB/Main.aspx?x=1
http://gemini.themls.com/GeminiB/Default.aspx?x=1
http://gemini.themls.com/GeminiB/Main.aspx?x=1
http://gemini.themls.com/GeminiB/Default.aspx?x=1
http://gemini.themls.com/GeminiB/Main.aspx?x=1
etc....

Thank you,
garifo


garifo
· 1
garifo
helpful
0
not helpful

This will occur if Gemini can not execute stored procedures. Can you check the access?

Also, try use SQL profiler to see if Gemini is running anything on SQL.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

omg..this is so annonying....you know it never occur to me to run profiler.
one of the store procedures did not have the correct permissions.  I went back to my script to add the permissions and I had missed that one.  I never thought of looking into the permissions due to the error displayed on the browser.

thank you very much for all your help.

garifo


garifo
· 1
garifo