Last post Jan 09, 2006 10:29 AM by airam
Oct 28, 2005 07:23 PM|aznguy0831|LINK
Oct 31, 2005 08:40 AM|dsmith678|LINK
did you follow the documentation exactly?...If not start over and do by the book..
Oct 31, 2005 05:58 PM|aznguy0831|LINK
Nov 01, 2005 10:55 AM|Girly_Coder|LINK
Nov 01, 2005 10:12 PM|Web Data Technologies|LINK
<add key="SiteSqlServer" value="Server=(local);Trusted_connection=true;Database=DNN;uid=janice;pwd=password;" />
Where the Bold Italicized Capitalized print are your information or credentials. This would also be double authentication for both the dbo and aspnet_worker process.
Nov 02, 2005 04:40 PM|aznguy0831|LINK
I setup the database connection correctly. It still doesn't work. [:(] I'm running the SQL desktop engine. Created a user and gave it full administrative access to the dotnetnuke database. My server name is europa. I added europa\aspnet and europa\iusr_europa
as administrators as well. Even gave europa\aspnet and europa\iusr_europa full control of the drive I store my web files on as well as full control of the temp folders. This doesn't work either.
I did have to set the objectQualifier or the install process wouldn't have begun:
<add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="dnn_" databaseOwner="dbo"
Nov 02, 2005 06:44 PM|Web Data Technologies|LINK
I added europa\aspnet and europa\iusr_europa as administrators as well. Even gave europa\aspnet and europa\iusr_europa full control of the drive I store my web files on as well as full control of the temp folders. This doesn't work either.
I did have to set the objectQualifier or the install process wouldn't have begun:
Nov 03, 2005 01:18 AM|aznguy0831|LINK
Nov 03, 2005 11:11 AM|Web Data Technologies|LINK
The role of dbo is db_owner and will have public priveledges. I say dbo instead because its short hand for database owner.
Editing the users and passwords in the DotNetNuke.install.resources file just changes them at default when the install actually occurs instead of admin admin or host host you would have ray ray (which sounds funny) if you chose ray ray or ray balloo if you
chose balloo as your password, just make sure you remember these and or change the email to which you reminder is send or you could have fun times ahead...
Below is a really rought three step sorta make shift try mean type how-to that may or may not work and you will see me say that throughout it. I do not see why it wouldnt work and I might get flamed from some of the more experienced DNN specialists, but if
it brings them here to flame me it might bring them here to help us an correct my methods all in one shot.
Try this in your web.config. I am about to get my remote DNN to work and I am banking that this is the problem right here and then I will shout it out to the whole world what the secret answer to that question is on shared hosting and dnn for the ones having
problems. Anyways try this:
This is in the web Config as you can tell by the colors this came from my web.config this is where the dboQualifier is, take note to where I changed dbo to ray, you can change this to whatever you need it to be as long as its the user that you have defined
as the one logged in in your sql string see below this example.
What happened is that I started to think, and here were my thoughts, if data is being created and dnn.config is being written, then everyone that brags and moans about permissions is wrong, especially when they start reciting stuff about win 2k when I am not
even using a win 2k machine for my hosting and I am being told that permissions were set. Then I started thinking, data and permissions, and I was like wait a minute DNN creates some roles in SQL server and needs give some permissions too so I started to
read through the install guide again for shared hosting complaints, and it was there. See what you need to do to finish this puppy up and HOPEFULLY get you going, worst case scenario back up your db or try it again from scratch, be fortunate that you can
do this locally and do not have to wait 24-48 hours for some network admin to get a work order to propagate. (Kinda why I hate outsource work but what can ya do)
Setting the permissions in SQL Server or in your case MSDE
Give ray these permissions in your desktop manager
This should allow all
of the correct information to be written to the correct tables within SQL Server or MSDE. I am thinking that because of the db_ddladmin it would not allowing the MemberRoles to be written which means a null exception must be thrown and with out the db_securityadmin
it would not grant the necessary permissions on tables to be written to in the way that they need to be written to like portal_alias so that would also cause a null value exception to be thrown. This is what I have come up with and if anyone sees my logic
as being correct, by all means correct me but its my $.02 and I will stick with it until I have a chance to prove it wrong or aznguy0831 tells me he has tried and it didnt work for him. If you really think about it though it does make sense. The table are
being made, but no data inserted, the files/directories in the actual www directories are being made but cannot reference what should be displayed from the db because that data does not exist. If that data does not exist it was not written and if it was not
written, why was it not written? My guess its because SQL Server did not have the permission to write that data and if it did not have the permission to write that data, its locked down tightly and needs to be told it needs to be allowed to write it. Just
like the part of path x:\ error where its trying to find the path through SQL server. Hopefully the core team can find a way to code in a try catch statement that will verify that the tables are being writen to and if not have an error log or message saying
error incorrect permission in sql server, try putting in these permission and restart the install process. Like I said thats IF and ONLY IF this is correct.
Sorry about the formatting here it did its own thing and the credit for the bullet list above goes to the writers of the 3.1.1 documentation of DNN.
Nov 03, 2005 04:10 PM|aznguy0831|LINK
Reasoning sounds very good but unfortunately still no go. I notice new roles such as aspnet_Membership_FullAccess and aspnet_Roles_FullAccess after I ran the install.
Tried everything stated and some other combinations of things deleting the db, directory, and virtual directory then trying again each time. *sigh*
About ready to give up on this thing and have all future clients use unix hosting using a tailored oscommerce. For those who use Windows hosting I'll just build my own cms. Probably less headache. Really like to see this thing work though as it does look
pretty impretty impressive. Be faster than building everything from scratch too. *sigh*
Nov 03, 2005 05:48 PM|Web Data Technologies|LINK
Nov 03, 2005 07:14 PM|gstar_elwoods|LINK
00:00:18.234 - Executing Additional Scripts:
00:00:18.234 - Creating Portal: My Website
00:00:18.281 - Error: Request for the permission of type System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
00:00:18.281 - Portal failed to install:
00:00:18.281 - Installing Optional Resources:
Nov 03, 2005 07:53 PM|Web Data Technologies|LINK
Nov 10, 2005 06:53 PM|aznguy0831|LINK
You ever manage to get the thing working? I haven't. Tried everything. The new version they release doesn't even run saying <connectionStrings> isn't recognized. Trying to configure my 2K3 machine now. Hopefully it'll work there.
I'm starting to lose faith in the quality of this thing.
Nov 11, 2005 11:39 AM|Web Data Technologies|LINK
Nov 13, 2005 12:22 AM|chertzy|LINK
If connectionString isn't recognized that would most likely mean that you are trying to run the site under.NET 1.1 instead of 2.0.
Nov 13, 2005 12:35 AM|chertzy|LINK
Jan 09, 2006 10:29 AM|airam|LINK
I’m having the same problem you mention in your post. Although my specifications are different, I think the cause of our problems maybe the same. I’ll really appreciate if someone could give me a clue to solve the problem.
My specs are:
DB : Oracle 9i
OS: Windows 2003
DNN version: 3.1.1
And the error I get is: “Portal failed to install”
I’ve set all the permissions that are mentioned in the thread. The database is created, but PortalAlias doesn’t have any content.