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.




Just installed the free version, and get sql errors

install
database

Hi,

I just install the free version, and when running the home page I get the generic error.

windows logs file show a sql error. I double check the connexionString, It's fine, the problem come from the request itself :

SELECT this.projectgroupmembershipid as projectg1210, this.projectid as projectid210, this.projectgroupid as projectg3210, this.userid as userid210, (select geminiprojectgroups.ProjectGroupName from geminiprojectgroups where geminiprojectgroups.projectgroupid = this.projectgroupid) as formula60, (select geminiprojects.ProjectName from geminiprojects where geminiprojects.projectid = this.projectid) as formula70 FROM geminiprojectgroupmembership this WHERE this_.userid = 0

Both subrequests use columns with cased names : gemini_projectgroups.ProjectGroupName. But in database, columns name are lower case... and sql server is case sensitive.

Is there a sql script to correct this, or a binary update ?

Thanks.

User26762
· 1
User26762
Replies (9)
helpful
0
not helpful

Make sure you model database is not case sensative.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Ok, I changed the interclassement.

Now another issue, the client gemini program can't connect the webserver... wich is local for testing purpose (http://localhost/Gemini)

Message : Invalid gemini URL?

the website work well when accessing it locally with browsers, with or without the proxy. Is there any limitation ? also tried with local dns name without success.


User26762
· 1
User26762
helpful
0
not helpful

You need to use the machine name if browsing from another PC: http://pc name/gemini


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Not so stupid :)

My tests are on the local machine with the webapp on the same machine. Using the machine name did'nt solve the issue. Still the same message.

Again, I browser the site with the same url through IE and firefox without issue, and with or without the proxy configured.


User26762
· 1
User26762
helpful
0
not helpful

Please check the app.log for errors: %appdata%\CounterSoft\Gemini\Desktop\app.log


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Please make sure that anonymous access is allowed in IIS for the Gemini site.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Hi,

the file exist, but is empty

I checked the website access with simple code, and get a Http401 error on Gemini. Look like the website has some build in restriction, as I can access others website on the same machine with this code.

WebRequest wr = HttpWebRequest.Create("http://localhost/Gemini"); WebResponse response = wr.GetResponse(); Stream str = response.GetResponseStream(); StreamReader read = new StreamReader(str); Console.Write(read.ReadToEnd());

Ok, solved the issue for my code in commenting out web.Config : !authorization!!deny users="?" /!!/authorization!

... But still no way for the Gemini app. Yes anonymous access is ON


User26762
· 1
User26762
helpful
0
not helpful

Please send an email to support at countersoft dot com, we will do a remote session to see what the issue is.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful
ANSWER

For readers, the missing thing was pipeline mode on the application pool : set it integrated.

Thanks for your help :)


User26762
· 1
User26762