| Author |
 Topic Search  Topic Options
|
Scotty32 
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 12 July 2009 at 5:20pm |
|
I suspect it would be required for MSSQL and MySQL to write the settings to the config files.
|
|
|
 |
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 July 2009 at 6:36pm |
 iSec wrote:
Ok it works now... thanks again guys.
However, I noticed that the upgrade wizard will NOT run unless the IUSER account has write/modify permission to the 'database' folder. I understand why this would be required for a forum that uses MS Access, but I'm using MS-SQL... why is this required? Can someone explain this please? |
Hi iSec I had no issues like you described when I ran the update on one of our test forums I downloaded the files, unzipped and then uploaded all of them into the forum directory, ran the wizard page and filled in the info - I use SQL Server (not access) so I did not change any permissions anywhere It worked with no problems and no issues. The permissions only need to be set as you correctly say if you are using Access and provided you popped a dot in either of the other two options, SQL or mySQL, then there should not have been any problems Hope that helps
|
|
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 July 2009 at 6:42pm |
I believe that write and modify permissions need to be set to the \forum\database folder so that IUSER can write the database setup details entered in the wizard to the asp connection file. The database used is irrelevant.
If write and modify permissions already existed for IUSER to that folder then check your other folders as your setup may be insecure.
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 July 2009 at 6:56pm |
Thanks Nick - but the permissions on that folder are normal. You would only need IUSER permissions if you were using the access database within that folder itself, otherwise the folder remains locked as such I'm pretty certain (well almost  ) that the setup files run from the main forum folder and providing write and read modifications are set correctly depending on the database being used) then there should be no issues. I suppose if I get time I will try a access install and not set the permissions correctly on the database - in theory this would then produce an error As I said, I was actually connecting to a SQL database and so when I entered the connection details, I was already connecting to an existing database
|
|
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 July 2009 at 8:14pm |
I use MS SQL - no access database. I am quite certain that IUSER had read-only permissions to the \database folder and therefore the upgrade wizard failed as it could not write the database info to the asp files therein. I provided write/modify permissions and it worked. Read permissions for IUSER is the default (not write/modify) and recommended setting for all other folders to prevent hacking. The WWF instructions tell you to change permissions: "5. The forums database folder located at forum/database needs to have read, write, and modify permissions set on it. Check with your web host that you have these permissions set, or if running the server yourself have a look at Setting Read, Write, and Modify Permissions."
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 July 2009 at 8:27pm |
For simplicity, let's just say that following the documented upgrade instructions works fine. Again, they are at http://www.webwiz.net/webwizforums/kb/default.asp. Bruce, as a result of this discussion I have just set IUSER permissions for \database back to read-only as I believe they only need to be write/modify for the upgrade wizard to function at upgrade time. Can you please confirm this (all works fine here) and indeed consider if this action should actually be recommended for security reasons (MS SQL and MySQL not Access). I suspect any Access database should actually be elsewhere to be safe.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 July 2009 at 8:59pm |
Yes... the wizard fails if write/modify permissions aren't set for the database folder (the wizard actually says that when it errors out).
The suggestions you guys posted all make sense, but how come this was not mentioned anywhere in the release announcement or in a separate topic?!
I hope that Bruce will clarify these questions, including the one mentioned by Nick-V, that the write/modify permissions be removed after completing the update wizard.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 July 2009 at 9:50am |
|
Yes read and write permissions are needed on the forums database folder when you run the wizard after it is complete you can put it back to read only.
If I tell you how the update wizard works then it may make more sense. Rather than having to manually edit the database connection file in notepad and save and upload it the setup wizard now writes the settings for you to the database/database_settings.asp file.
|
|
|
|
