Getting Started

Re: DNN 2.1.2 and 3.0.10 on same machine?

ariggs — Thu, 24 Feb 2005 16:14:05 GMT

Ok, out of frustration I decided to start over. I deleted everything and started over. My problem was a permission error with the Database and not with the connection string.

Since I am new to MS servers, and have only had to admin a Unix box in the past, I found an excellent set of directions online.

http://dotnetvet.net

The set up for the db and for the permissions worked beautifully for 3.0.10, just keep in mind your connection string is not the same. Not sure if you are around, but whoever wrote these..... THANK YOU!!!

Re: DNN 2.1.2 and 3.0.10 on same machine?

ariggs — Wed, 23 Feb 2005 18:52:21 GMT

I am actually having the same issue and after 3 days of beating my head over it have decided I need help.

I have a DNN site running 2.0.4 on my development box. It is a MS 2000 Server with SQL 2000. I created a new database instance, and installed the files. But when I tried to run 3.0.10 I get the following error...
_____________________

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

________________________
I put it on an inteli stick took it to another location with an exact copy of the original site, the difference being it is MS-XP SPII, and SQL 2003. I am getting the same error message.

The only change I made to the config file is the data provider section.

<add key="SiteSqlServer" value="Server=10.0.162.28,1433; Database=test; uid=test; pwd=test;" />

Test is a valid user who has full permissions on the server as well as on my database.

I tried your suggestion of naming the application DotNetNuke in the IIS server, but there is no change. Any help on this would be wonderful.

Thanks in advance!

Re: DNN 2.1.2 and 3.0.10 on same machine?

JWhite — Wed, 23 Feb 2005 15:16:18 GMT

Windows XP does not support that. Windows XP as a desktop OS only supports ONE website so multple copies of DNN must live in virtual directories.

On a server, you can accomplish what you want by installing the two different versions of DNN into their own websites in IIS and setting the host headers or IP addresses as required.

Re: DNN 2.1.2 and 3.0.10 on same machine?

jettman26 — Wed, 23 Feb 2005 13:33:43 GMT

Now back to an earlier question that I had.

I have two installations on DotNetNuke and two domain names.
Each DNN installation is in an IIS virtual Directory.
I want the 2.1.2 installation to be beethe.com
I want the 3.x version to be beethefamily.com.
Is there a way to do this?

Currently I have to type in beethe.com/dotnetnuke2 and
beethefamily.com/dotnetnuke.

Any advice would be appreciated.

Re: DNN 2.1.2 and 3.0.10 on same machine?

jettman26 — Tue, 22 Feb 2005 22:28:28 GMT

Not sure, I think I had to have the application name set to dotnetnuke, but coincidentally my directory had the same name.

Re: DNN 2.1.2 and 3.0.10 on same machine?

pbergma — Tue, 22 Feb 2005 22:04:13 GMT

jettman26

1. I am using XP Pro SP2
2. I am not using simple file sharing is not turned on. ASPNet has full control of my C:\SOS3010
3. Yes, I created a blank database and called it SOS3010
4.Yes, I did create a loging user named pbergman and gave it owner and public rights
5. Should the application name be SOS3010 instead of DotNetNuke? Since this is the directory you are point to and what the virtual directory is called???
5.Yes, Defualt.aspx is 1st in the list.

Still get issue running DNN3.0.10

Pat

Re: DNN 2.1.2 and 3.0.10 on same machine?

jettman26 — Tue, 22 Feb 2005 20:56:44 GMT

1. You are using XP Pro right?
2. Make sure you are not using simple file sharing. If you are turn it off and then create the user ASPNET and give ASPNET full 'Sharing' and 'Security' rights for your SOS3010 folder on your C drive.
3. Did you create a blank database and call it SOS3010?
4. For this newly created blank database called SOS3010, did you add the user 'pbergman' and give it owner and public rights?
5. When you created the virtual directory in IIS, on the 'Virtual Directory' tab, make sure the
'Application name:' says 'dotnetnuke'. Also make sure 'Defualt.aspx' is the first listed in the 'Documents' tab.

Re: DNN 2.1.2 and 3.0.10 on same machine?

pbergma — Tue, 22 Feb 2005 16:59:10 GMT

hi jwhite

I trying to install DNN 3.0.10 on an XP machine with SQL 2000. I have done 6 clean installs and I am always getting errors when the install is trying to run store procedures. It comes back and says it can't find stored procedure dbo.XXXXXXXX.

I have extracted the DNN 3.0.10 code to a folder, DNN3010, under c:\inetpub\wwww.root and created a virtual directory pointing to this folder. This resulted in the error above.

I then tried extracting the code to a folder, SOS3010, under c: and creating a new virtual directory, SOS3010, point to the folder under c:\. I got the same error again.

In both case I have given ASP.Net user, Administrator, Sytem, Everyone ( full access) and the IUSR user Read and Excute) to the folder DNN3.0.10 got installed.

In the database I created a user login pbergman that has db_owner rigths and gave them access to the databases for the DNN 3.0.10.

But still am getting the can't find stored procs.

I then modify the Web.config files in one place with the following modification:
/configSections>


<appSettings>
<add key="SiteSqlServer" value="Server=(local);Database=SOS3010;uid=pbergman;pwd=pjbjmvj4;" />
<add key="MachineValidationKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902" />
<add key="MachineDecryptionKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC" />
<add key="MachineValidationMode" value="SHA1" />
<add key="InstallTemplate" value="DotNetNuke.install.resources" />
</appSettings>

Is there somthing I am missing to casue this problem??? Is there a work around?? Again I have tried a clean install 6 times and still getting the same message.

Thanks for any help you can give.

Re: DNN 2.1.2 and 3.0.10 on same machine?

jettman26 — Tue, 22 Feb 2005 13:51:33 GMT

Thanks, that was the problem. Now that brings up another question.
My domain name is beethe.com. When I type in beethe.com, I want it to go to my 3.x version. I have another domain that I want to go to the 2.1.2 installation. I can't see how this would be possible.
I set the portal alias in 3.x to beethe.com and got a server error. I can only get to 3.x by using beethe.com/dotnetnuke or localhost/dotnetnuke. I want to be able to get to it by just typing beethe.com. Is this possible?

Re: DNN 2.1.2 and 3.0.10 on same machine?

JWhite — Tue, 22 Feb 2005 09:36:40 GMT

On XP, you have no choice other than installing each instance of DNN in it's OWN VDir. The root web.config is still in effect for the vdir. That's where those errors come from.

On a server you can install each instace of DNN into the root of their own site using host headers or seperate IP's.

Re: DNN 2.1.2 and 3.0.10 on same machine?

jettman26 — Tue, 22 Feb 2005 04:39:36 GMT

3.x is installed on the root of IIS. I am using XP Pro.

Re: DNN 2.1.2 and 3.0.10 on same machine?

JWhite — Tue, 22 Feb 2005 04:37:53 GMT

where is DNN 3.x installed? If it's installed in the root, then you could get this error perhaps.

Re: DNN 2.1.2 and 3.0.10 on same machine?

jettman26 — Tue, 22 Feb 2005 03:58:09 GMT

I unzipped 2.1.2 into C:\dotnetnuke2.
I gave ASP.NET full rights in Sharing and Security for this folder.
I created a virtual directory in IIS called dotnetnuke2 and pointed it to the C:\dotnetnuke2 folder.
I created a new blank database in MSSQL 2000 called dotnetnuke2. I added the same user that I am using for my dotnetnuke 3.0.10 installation.
As far as the Web.config file goes, I am not sure if I have it right. Here is my Web.config file (I changed the uid and password to all x's for security of this post.)

<configuration>





	<!-- register local configuration handlers -->


    <configSections>


        <sectionGroup name="dotnetnuke">


            <section name="data" type="DotNetNuke.ProviderConfigurationHandler, DotNetNuke" />


            <section name="logging" type="DotNetNuke.ProviderConfigurationHandler, DotNetNuke" />


            <section name="scheduling" type="DotNetNuke.ProviderConfigurationHandler, DotNetNuke" />


            <section name="htmlEditor" type="DotNetNuke.ProviderConfigurationHandler, DotNetNuke" />


        </sectionGroup>


    </configSections>





	<!-- Sql Server connection string for support of pre DNN 2.0 Private Assemblies


		 The new connection string (for DNN 2.0) is in the section dotnetnuke (providers) -->


	<appSettings>


		<add key="connectionString" value="Server=DELL;Database=dotnetnuke2;uid=DNN;pwd=*****;" />


	</appSettings>





	<system.web>





		<!-- set debugmode to false for running application -->


		<compilation debug="false" />





		<!-- permits errors to be displayed for remote clients -->


		<customErrors mode="RemoteOnly" />





		<!-- Forms or Windows authentication -->


		<authentication mode="Forms">


		<forms name=".DOTNETNUKE" protection="All" timeout="60" />


		</authentication>


		<!--


			<identity impersonate="true"/>


			<authentication mode="Windows">


			</authentication>


		-->





		<!-- allow large file uploads -->


		<httpRuntime useFullyQualifiedRedirectUrl="true" maxRequestLength="8192" />


		


		<!--  GLOBALIZATION


		This section sets the globalization settings of the application. 


		Utf-8 is not supported on Netscape 4.x 


		If you need netscape compatiblity leave iso-8859-1.


		UTF-8 is recommended for complex languages


		-->


		<globalization culture="en-US" uiCulture="en" requestEncoding="UTF-8" responseEncoding="UTF-8" fileEncoding="UTF-8" />


		<!--<globalization culture="en-US" uiCulture="en"  fileEncoding="iso-8859-1" requestEncoding="iso-8859-1" responseEncoding="iso-8859-1"/>-->





		<!-- page level options -->


		<pages validateRequest="false" enableViewStateMac="true" />





	</system.web>





    <dotnetnuke>


		<htmlEditor defaultProvider="FtbHtmlEditorProvider" >


            <providers>


				<clear/>


                <add name = "FtbHtmlEditorProvider" 


                        type = "DotNetNuke.HtmlEditor.FtbHtmlEditorProvider, DotNetNuke.FtbHtmlEditorProvider"                    


	                    providerPath = "~\Providers\HtmlEditorProviders\FtbHtmlEditorProvider\" 


                />


            </providers>


        </htmlEditor> 


        <data defaultProvider="SqlDataProvider" >


            <providers>


				<clear/>


                <add name = "SqlDataProvider" 


                        type = "DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" 


                        connectionString = "Server=DELL;Database=dotnetnuke2;uid=DNN;pwd=*****;" 


	                    providerPath = "~\Providers\DataProviders\SqlDataProvider\" 


                        objectQualifier = "" 


                        databaseOwner = "dbo"


                        upgradeConnectionString = ""


                />


                <add name = "AccessDataProvider" 


                        type = "DotNetNuke.Data.AccessDataProvider, DotNetNuke.AccessDataProvider" 


                        connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"


	                    providerPath = "~\Providers\DataProviders\AccessDataProvider\" 


                        objectQualifier = "DotNetNuke" 


                        databaseFilename = "DotNetNuke.mdb.resources"


		/>


            </providers>


        </data>


        <logging defaultProvider="XMLLoggingProvider" >


            <providers>


				<clear/>


                <add name = "XMLLoggingProvider" 


                        type = "DotNetNuke.Logging.XMLLoggingProvider, DotNetNuke.XMLLoggingProvider" 


                        configfilename="LogConfig.xml.resources"


                        providerPath = "~\Providers\LoggingProviders\XMLLoggingProvider\" 


                />


            </providers>


        </logging>


        <scheduling defaultProvider="DNNScheduler" >


            <providers>


				<clear/>


                <add name = "DNNScheduler" 


                        type = "DotNetNuke.Scheduling.DNNScheduler, DotNetNuke.DNNScheduler"


                        providerPath = "~\Providers\SchedulingProviders\DNNScheduler\" 


                        debug="false"


                        maxThreads="-1"


                        enabled="true"


                />


            </providers>


        </scheduling>





    </dotnetnuke>


</configuration>

1. Is this Web.config file correct?
2. In IIS for my virtual directory on the 'Virtual Directory' tab, I have the 'Application name:' set to 'dotnetnuke2'. Should it be dotnetnuke or dotnetnuke2?

I keep getting this error when dotnetnuke2 goes thru its setup when I type in 'localhost/dotnetnuke2'

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

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Section or group name 'data' has already been defined.

Source Error:

Line 4: <configSections>
Line 5: <sectionGroup name="dotnetnuke">
Line 6: <section name="data" type="DotNetNuke.ProviderConfigurationHandler, DotNetNuke" />
Line 7: <section name="logging" type="DotNetNuke.ProviderConfigurationHandler, DotNetNuke" />
Line 8: <section name="scheduling" type="DotNetNuke.ProviderConfigurationHandler, DotNetNuke" />

Source File: C:\dotnetnuke2\web.config Line: 6

Re: DNN 2.1.2 and 3.0.10 on same machine?

xddg — Tue, 22 Feb 2005 03:39:07 GMT

That's all and you're there!

Just make sure your users are setup correctly in SQL

I run many installations.. for testing, skinning, modules etc.
My local naming convention follows either the version, or if testing versions, the version and date. EG 212Jan3005 - I then name the database the same when testing, so I can copy and paste it from web.config, to db.

You should be OK to go now.

Nina Meiers

Re: DNN 2.1.2 and 3.0.10 on same machine?

jettman26 — Tue, 22 Feb 2005 03:25:24 GMT

Do I need to modify the web.config file any where besides the server name, database name, uid, password in the two spots?