| Author |
|
Kateriana
New User
Joined: July/08/2008
Location: United States
Online Status: Offline
Info: 8
|
| Added: July/08/2008 at 3:50pm | IP Logged
|
|
|
Got the software, uploaded it, got my SQL tables created, fixed my data connection... so I'm on this page:
http://www.beautybythebatch.com/account/data/config/aspbanne r_unlimited.asp
And it says that the security permissions for:
F:\inetpub\wwwroot\beautybythebatch\account\data\
need to be R/W/X/D - first, I have never seen these used in a Windows setting *chuckle* unix yes, windows? maybe I'm just blind? Anyway, to my problem. My connection string works on that page and I click the "Admin Area" and get this:
Connection string not saved in (data/config/aspbanner_unlimited_config.asp) file.
Most likey the data folder does not have proper permissions set on it.
That folder and all of the folders within it need (R,W,X,D) Permissions set for the anonymous webserver account.
These permissions can generally only be set by your hosting company.
I administer my own servers so I handle permissions myself... the anonymous account for this website is IUSR_TINA (don't ask - its a long story, heh). I opened the security settings for the "data" folder and just gave IUSR_TINA full control (I tried just doing modify, read & execute, read and write and that didn't work). I'm still getting the above error. To see if it would fix it, I added "Everyone" as a user and again, gave them full control and I'm still getting the above error. I've double-checked that IUSR_TINA is the account used for anonymous access through IIS so I guess I'm not sure what other permissions I could possibly set since I've given that account full control.
I even tried going into this file:
data/config/aspbanner_unlimited_config.asp
And just setting the BannerConnectionString by hand to the correct DSN info - no luck.
Permissions are always my weak-point so I apologize for this. Also, in your documentation at the bottom of the "installation" page you have a link to permissions.htm which is supposed to be in the /docs folder and that file doesn't exist - I really tried to figure this out on my own!
- Tina
__________________
Tina Harshbarger
Webmaster and Database Administer
www.NaturalSourcing.com - www.FromNatureWithLove.com - www.BeautyByTheBatch.com - www.KitsForCrafts.com - www.NaturalBeautyWorkshop.com
|
| Back to Top |
|
| |
Kateriana
New User
Joined: July/08/2008
Location: United States
Online Status: Offline
Info: 8
|
| Added: July/08/2008 at 4:08pm | IP Logged
|
|
|
Well, since I couldn't see anything to change with permissions, I started digging into the ASP. In the config page, this line wasn't updating to the MSSQL that needed to be there - when I changed it by hand, suddenly everything worked:
BannerDatabaseType=MSSQL
Not sure why that would have caused a permissions error but... its working so I'm happy!
__________________
Tina Harshbarger
Webmaster and Database Administer
www.NaturalSourcing.com - www.FromNatureWithLove.com - www.BeautyByTheBatch.com - www.KitsForCrafts.com - www.NaturalBeautyWorkshop.com
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1769
|
| Added: July/08/2008 at 6:55pm | IP Logged
|
|
|
Hi,
I have explained windows server permissions in great detail here...
http://support.cjwsoft.com/code/moreinfo136-1.htm
In the world of windows (R,W,X,D) are also known as change or modify permissions..
As for that line the value should not be =MSSQL.. it should be =SQL
Everything that happened to you, everything you described is because of incorrect permissions on the data folder and it's child folders..essentially the config file in there could not be written to.. thus all the trouble and also why you had to edit it manually..
I did see what you wrote about the various account names your using and what not and well.. that is something only you know about.. whatever you have going on there is out of the norm and probably part of why that is all giving you trouble... I mean it has to be be
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
Kateriana
New User
Joined: July/08/2008
Location: United States
Online Status: Offline
Info: 8
|
| Added: July/08/2008 at 7:09pm | IP Logged
|
|
|
But thats what I'm saying... my permissions ARE setup exactly like you show in that post. Thats why I am not sure why it was giving me the error. I even double-checked the ASPNET account (we don't use ASP.NET but our provider thought we did and so all our sites have it - since I don't have a clue how to un-install it, we just basically ignore it).
*shrug* Everything has worked since without any problems so not sure what to say. Maybe its just me, but maybe someone else will run into this problem and find this post?
Very awesome product btw! I've been really impressed with the things I can change and move around!
__________________
Tina Harshbarger
Webmaster and Database Administer
www.NaturalSourcing.com - www.FromNatureWithLove.com - www.BeautyByTheBatch.com - www.KitsForCrafts.com - www.NaturalBeautyWorkshop.com
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1769
|
| Added: July/08/2008 at 7:14pm | IP Logged
|
|
|
did the subfolder in the data folder get permissions... did you actually check the config file itself to see if it got the permissions ??
I mean if it cant write to that file it didn't .. there is no other explanation.
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1769
|
| Added: July/08/2008 at 7:16pm | IP Logged
|
|
|
unless something on your server is disabling the filesystem object... but that is whole other issue on it's own. Norton antivirus is known to do that and that is why people dont run that on commercial windows servers.
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1769
|
| Added: July/08/2008 at 7:17pm | IP Logged
|
|
|
and the aspnet account is not involved..
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
Kateriana
New User
Joined: July/08/2008
Location: United States
Online Status: Offline
Info: 8
|
| Added: July/08/2008 at 7:17pm | IP Logged
|
|
|
I swear to you, I checked (I spot checked files all over under data and its subfolders). You know... I think I might have opened that config file before I tried running the setup thing - just seeing what was around, etc. I may have edited the connection line at least by hand - could that have messed it up? if I put an extra line break or something in there? I dunno... you got me! It works now and that makes me happy!
__________________
Tina Harshbarger
Webmaster and Database Administer
www.NaturalSourcing.com - www.FromNatureWithLove.com - www.BeautyByTheBatch.com - www.KitsForCrafts.com - www.NaturalBeautyWorkshop.com
|
| Back to Top |
|
| |
Active Info
Memberlist
Search
Help
Register
Login
Info: Data Folder Permissions Error
