Login

Username

Password





Register   Reset password

Get Cuyahoga at SourceForge.net. Fast, secure and Free Open Source software downloads

Forum

Welcome Guest Search | Active Topics | Members

Not able to proceed with installation Options
ben9035
Posted: Sunday, January 2, 2011 5:18:34 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Ok, to recap:

Installed SQL Express 2k8 with 'cuyahoga' instance name on Windows 7 Ultimate x86

I downloaded and unzipped cuyahoga to c:\inetpub\wwwroot

Using Nant, I built the solution

Then, I changed the configuration file per the instructions on the site

I created an application in IIS and listed the build directory as it's base

Now, when I browse to http://localhost/cuyahoga/, I get

Server Error in Application "cuyahoga"

HTTP Error 404.3 - Not Found
The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.

I am using v1.6 of cuyahoga.

Thanks in advance.
Constructor
Posted: Monday, January 3, 2011 5:51:48 AM
Rank: Administration
Groups: Administration , Member

Joined: 10/7/2008
Posts: 505
Points: 1,515
ben9035
Posted: Tuesday, January 4, 2011 4:47:43 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
First one, I tried, but am still getting the error. Second one provided a great deal of info, but what, exactly you were trying to point out is a mystery, can you clarify for me please?

So we're clear:

I changed permissions on the web.config file for full access for everyone (right now)
Changed the interpreted to classic for apps in IIS
Changed identity to localsystem rather than apppool
ben9035
Posted: Tuesday, January 4, 2011 5:01:53 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Also, if I want to add a Script Map Handler in IIS, what Request Path and Executables do I use?
ben9035
Posted: Tuesday, January 4, 2011 5:17:42 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Ok, wow, the rank "Newbie" fits here....I forgot to manually select ASP.net when configuring IIS.

New issue, still unable to see page, I get this error:


Server Error in '/' Application.

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'Cuyahoga.Web.Global'.

Source Error:


Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="Cuyahoga.Web.Global" %>

Source File: /global.asax Line: 1
ben9035
Posted: Tuesday, January 4, 2011 8:01:18 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Alright...resolved this one also. Copied the bin folder from the subdirectory to the web\ folder root

I cannot for the life of me get SQL to connec though, I've tried SQL 2k5, 2k5 Express, 2k8, and 2k8 Enterprise. I enabled Named Pipes and TCP/IP on all and set the connection string as was provided in the installation instructions, but I continually cannot connect. I've read through hundreds of forum posts trying to find the issue, but nothing seems to resolve it, can you offer some insight please?
Constructor
Posted: Wednesday, January 5, 2011 1:32:18 AM
Rank: Administration
Groups: Administration , Member

Joined: 10/7/2008
Posts: 505
Points: 1,515
ben9035 wrote:
Alright...resolved this one also. Copied the bin folder from the subdirectory to the web\ folder root

I cannot for the life of me get SQL to connec though, I've tried SQL 2k5, 2k5 Express, 2k8, and 2k8 Enterprise. I enabled Named Pipes and TCP/IP on all and set the connection string as was provided in the installation instructions, but I continually cannot connect. I've read through hundreds of forum posts trying to find the issue, but nothing seems to resolve it, can you offer some insight please?



Try this:

1) Open IIS Manager (II7)
2) Click 'Application Pools'
3) Right click the application and click 'Advanced Settings...'
4) Find 'Process Model' section and change the 'Identity' to 'Local System'

SQL Server should now connect.
ben9035
Posted: Wednesday, January 5, 2011 2:42:20 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
No Luck, is this what my connection string should look like?

connectionString server=

(local);database=Cuyahoga;Trusted_Connection=True connectionString

Obviously there are brackets around the conenction string, but it wouldn't let me post it with them
ben9035
Posted: Wednesday, January 5, 2011 2:59:24 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
I was not presented with the option to add a user to SQL 2k5, nor did SQL Management Studio get installed for me to create a user, and I tried the old default of "sa"/"sa", but that didn't work either.
Constructor
Posted: Wednesday, January 5, 2011 3:18:55 AM
Rank: Administration
Groups: Administration , Member

Joined: 10/7/2008
Posts: 505
Points: 1,515
ben9035 wrote:
No Luck, is this what my connection string should look like?

connectionString server=

(local);database=Cuyahoga;Trusted_Connection=True connectionString

Obviously there are brackets around the conenction string, but it wouldn't let me post it with them


Try:

((connectionString))Server=.\sqlexpress;Database=Cuyahoga;Integrated Security=SSPI((/connectionString))

Replace (( and )) for correct brackets.
ben9035
Posted: Wednesday, January 5, 2011 3:28:21 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Nope. I am wondering though...why is the database name cuyahoga already? It just created the default SQLExpress instance, so I don't know when it would've configured that.
ben9035
Posted: Wednesday, January 5, 2011 3:30:17 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Just so you know, I have no firewall or anything running that would prevent access on 1433 (or any other port for that matter)
Constructor
Posted: Wednesday, January 5, 2011 4:11:23 AM
Rank: Administration
Groups: Administration , Member

Joined: 10/7/2008
Posts: 505
Points: 1,515
ben9035 wrote:
Nope. I am wondering though...why is the database name cuyahoga already? It just created the default SQLExpress instance, so I don't know when it would've configured that.



Try:

((connectionString))Server=.\sqlexpress;Database={DatabaseName};Integrated Security=SSPI((/connectionString))

Replace (( and )) for correct brackets.
Replace {DatabaseName} for the name of your database.

To create a database:
http://www.quackit.com/sql_server/sql_server_2008/tutorial/create_a_database.cfm
ben9035
Posted: Wednesday, January 5, 2011 7:07:14 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
It's SQL 2005, and, as previously stated, no Management Console came with it :-(
ben9035
Posted: Wednesday, January 5, 2011 8:17:00 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Went ahead and installed 2k8 Express with Management Studio, but can't login to even the Studio part with either windows or SQL credentials....ideas?
ben9035
Posted: Wednesday, January 5, 2011 8:28:35 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
wowsers, I thought this was supposed to be easy. Ok, I manually added a db in sql and changed the connection string to:

(connectionString)server=computername

\cuyahoga;Database=cuyahoga;Integrated Security=SSPI(connectionString)

NOW, I can connect, but I get the following error....

Server Error in '/' Application.

Invalid object name 'cuyahoga_moduletype'.

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: Invalid object name 'cuyahoga_moduletype'.

Source Error:


Line 72: }
Line 73: }
Line 74: return crit.List();
Line 75: }
Line 76:

Source File: C:\CuyaHoga\Core\DataAccess\CommonDao.cs Line: 74
ben9035
Posted: Wednesday, January 5, 2011 8:38:27 AM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Well, it looks like the DB didn't ever install like it should've because I get a different error everytime I try the webpage. Is there a way to reinstall it?
ben9035
Posted: Wednesday, January 5, 2011 1:46:19 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
Update: I ran the top 4 db query files located in the database directory, and I think I'm almost there, but I got this now:

Server Error in '/' Application.

Invalid column name 'metakeywords'.
Invalid column name 'metadescription'.
Invalid column name 'offlinetemplateid'.

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: Invalid column name 'metakeywords'.
Invalid column name 'metadescription'.
Invalid column name 'offlinetemplateid'.
ben9035
Posted: Wednesday, January 5, 2011 1:49:11 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
On a whim, I went and browsed to the admin directory, and am actually prompted for a login! However, I was never presented for an option to create a password other than the ones when installing dbs and/or programs, and those passwords aren't working. Help!
ben9035
Posted: Wednesday, January 5, 2011 2:12:18 PM
Rank: Member
Groups: Member

Joined: 1/2/2011
Posts: 17
Points: 51
I added NT AUTHORITY/NETWORK SERVICE to SQL Security and 'can get logged on', but as soon as I hit the login button, I get:

The SELECT permission was denied on the object 'cuyahoga_user', database 'master', schema 'dbo'.
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Yet Another Forum.net version 1.9.0 running under Cuyahoga.
Copyright © 2003-2006 Yet Another Forum.net. All rights reserved.