Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Modular Concept		  New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 22 July 2014 :  06:27:28  Show Profile  Reply with Quote
Well, on these three 8.1 machines; all now have Office installed, all have 32 bit applications enabled, NONE can connect to the database, regardless of whether using accdb, mdb, or DSN connections. They will all response write a simple line to the browser, so ASP is working. The issue is 100% related to database connectivity. Furthermore, even though they all have detailed errors turned on, none of them report detailed errors. There's something rotten with IIS 8.5 in Windows 8.1..

OK - Finally got it working. Had to change the write permissions to the temporary directory to add IUSR/IIS_IUSRS/NETWORK SERVICE (for whatever reason, they aren't automatic. After I did that, I finally started getting detailed errors. The detailed error I received said that I needed access to the database, even though the folder had write permissions, it turned out the database did NOT. I had neglected to propagate the permissions onward to the files within the folder.
Edited by - Carefree on 22 July 2014 07:06:34
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 22 July 2014 :  18:36:22  Show Profile  Reply with Quote
I would of thought that you would do the permissions on the folder and it's contents of the DB on instinct.
quote:
Originally posted by Carefree

OK - Finally got it working. Had to change the write permissions to the temporary directory to add IUSR/IIS_IUSRS/NETWORK SERVICE (for whatever reason, they aren't automatic. After I did that, I finally started getting detailed errors. The detailed error I received said that I needed access to the database, even though the folder had write permissions, it turned out the database did NOT. I had neglected to propagate the permissions onward to the files within the folder.

As long as you got it going, all's good..
Cheers,

David Greening
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 22 July 2014 :  20:18:20  Show Profile  Reply with Quote
Yeah, but when you have to do 10 folders, it's easy to skip checking the little box on occasion. Especially when your brain cannot remember whether you did it right after hitting OK. Here's a batch file to do it automatically, people can use it for simplicity.

The best practice is that when you create the forum directory in which to extract the zip file, make sure that the "users" account has full permission to the folder first. Then extract the zip file and it SHOULD give the users account full permission to all the files and folders automatically.

Then save the code at the bottom of this post to the modular forum root directory, as "permissions.bat". If you use notepad to copy and paste into, change the drop-down menu from "Text Documents (*.txt)" to "All Files (*.*)" before saving. That will prevent it from saving the file as "permissions.bat.txt".

Finally, simply double-click the file to execute it and edit all the necessary permissions at once.

Explanation of what it does:

The first section (all the "vers" and "If" conditions) checks which version of Windows is in use. That's necessary since the CACLS command was deprecated with Windows Server 2003. XP and older operating systems do not have the ICACLS command.

The second section actually does the work of assigning the necessary permissions to all of the required folders (and files within those folders). They don't all require "network service", but a future change may necessitate it and it doesn't hurt to grant it at the same time.

When using CACLS:
  • "/t": Applies the command to all files and sub-directories within a folder.
  • "/e": Edits permissions rather than replacing them.
  • "/c": Continues processing if it encounters an error in a command.
  • "/g": Grants (as opposed to denying, etc.) permissions.
  • "iusr:w": Grants write access. All three necessary accounts are included.

When using ICACLS:
  • "/grant:r": Replaces permissions previously granted to the specified accounts.
  • "(OI)(CI)": This is necessary to apply those permissions to the directories themselves, to allow creation of files/folders within them. Any directory in which users can upload or append to files must have this setting.
  • "iusr:m": The :m stand for "modify" access, replaces "write" access from CACLS. All three necessary accounts are included.
  • "inheritance:e": Enables the folders and files to retain the security settings from the forum folder and simply adds to them, rather than removing the "system", "users", "administrators", etc. which are already there.
  • "/c": Continues processing if it encounters an error in a command.
  • "/t": Applies the command to all files and sub-directories within a folder.



@echo off
cls
Rem	Detect OS
	ver | findstr /i "5\.2\." > nul
	IF %ERRORLEVEL% EQU 0 goto :win8
	ver | findstr /i "6\.0\." > nul
	IF %ERRORLEVEL% EQU 0 goto :win8
	ver | findstr /i "6\.1\." > nul
	IF %ERRORLEVEL% EQU 0 goto :win8
	ver | findstr /i "6\.2\." > nul
	IF %ERRORLEVEL% EQU 0 goto :win8
	ver | findstr /i "6\.3\." > nul
	IF %ERRORLEVEL% EQU 0 goto :win8
Rem	Process permissions, older Windows
	cacls adverts /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls album /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls avatars /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls chatroom /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls dbase /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls filelister /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls flashchat /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls photos /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls topics /t /e /c /g iusr:w iis_iusrs:w "network service":w
	cacls uploads /t /e /c /g iusr:w iis_iusrs:w "network service":w
	goto :end
Rem	Process permissions, newer Windows
:win8
	icacls adverts /grant:r iusr:(OI)(CI)(m,gw,wd,ad) iis_iusrs:(OI)(CI)(m,gw,wd,ad) "network service":(OI)(CI)(m,gw,wd,ad) /inheritance:e /t /c
	icacls album /grant:r iusr:(OI)(CI)(m,gw,wd,ad) iis_iusrs:(OI)(CI)(m,gw,wd,ad) "network service":(OI)(CI)(m,gw,wd,ad) /inheritance:e /t /c
	icacls avatars /grant:r iusr:m iis_iusrs:m "network service":m /inheritance:e /t /c
	icacls chatroom /grant:r iusr:(OI)(CI)(m,gw,wd,ad) iis_iusrs:(OI)(CI)(m,gw,wd,ad) "network service":(OI)(CI)(m,gw,wd,ad) /inheritance:e /t /c
	icacls dbase /grant:r iusr:m iis_iusrs:m "network service":m /inheritance:e /t /c
	icacls filelister /grant:r iusr:m iis_iusrs:m "network service":m /inheritance:e /t /c
	icacls flashchat /grant:r iusr:(OI)(CI)(m,gw,wd,ad) iis_iusrs:(OI)(CI)(m,gw,wd,ad) "network service":(OI)(CI)(m,gw,wd,ad) /inheritance:e /t /c
	icacls photos /grant:r iusr:(OI)(CI)(m,gw,wd,ad) iis_iusrs:(OI)(CI)(m,gw,wd,ad) "network service":(OI)(CI)(m,gw,wd,ad) /inheritance:e /t /c
	icacls topics /grant:r iusr:(OI)(CI)(m,gw,wd,ad) iis_iusrs:(OI)(CI)(m,gw,wd,ad) "network service":(OI)(CI)(m,gw,wd,ad) /inheritance:e /t /c
	icacls uploads /grant:r iusr:(OI)(CI)(m,gw,wd,ad) iis_iusrs:(OI)(CI)(m,gw,wd,ad) "network service":(OI)(CI)(m,gw,wd,ad) /inheritance:e /t /c
Rem	Pause output for review, then exit
:end
	Pause
	Exit
Edited by - Carefree on 23 July 2014 01:31:17
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 26 July 2014 :  02:36:53  Show Profile  Reply with Quote
quote:
Originally posted by richfed

I am going to attempt to test this on my computer, hopefully later today. Where are the new files located for download? Did I miss that part somewhere? As for using it "live," I would upload all the files - change database string, run dbs files and then turn on/off all the mods? Would it be that simple?


Inside the latest package (as of yesterday), I included tools to convert the provided database (with all the tables preinstalled) to either MySQL or MS SQL. It will let you selectively import tables and/or fields into existing tables.
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 26 July 2014 :  14:04:57  Show Profile  Visit richfed's Homepage  Reply with Quote
I am going to have to wait until I feel like my mind is clear to attempt this again. This is complicated!!!!! No online test site, I suppose?
Go to Top of Page

pierretopping
Junior Member

United Kingdom
224 Posts
Posted - 26 July 2014 :  14:15:17  Show Profile  Visit pierretopping's Homepage  Reply with Quote
Great work all. Will give it a go in the morning (under server 2008) and report back :-)
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 27 July 2014 :  04:55:28  Show Profile  Reply with Quote
quote:
Originally posted by richfed

I am going to have to wait until I feel like my mind is clear to attempt this again. This is complicated!!!!! No online test site, I suppose?


Cannot really enable online testing because you have to be the forum admin to access the panel to make all the changes. All it would take is for some loser to get the login info and delete users, etc. I could go through and disable all of those type pages, but then the testing would be really restricted.
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 27 July 2014 :  14:51:34  Show Profile  Visit richfed's Homepage  Reply with Quote
Activated Poll Mod and tried to create a test poll with 4 answers. Preview worked, but when I tried to Post it, I receieved this error:

Microsoft JET Database Engine error '80004005'

The field 'FORUM_POLLS.P_ENDDATE' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

/mforum/post_info.asp, line 1546
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 27 July 2014 :  22:04:09  Show Profile  Reply with Quote
Changed the required, it will work.
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 05 August 2014 :  03:50:45  Show Profile  Reply with Quote
Was looking at the themes mod and saw that a number of buttons weren't included to match the provided themes, so I decided to create automatic CSS-styled buttons (login/logout & Snitz) to match the format of the category cell colors. Now, in order to match the color scheme within "forum.asp" (which is where 99% of the theme's work is done), the header cell and category cell colors should match in the "my_theme2.asp" file, especially since there are no categories displayed there. When on any page other than "forum.asp", the default color scheme is used and the category cell colors are used instead.
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 05 August 2014 :  14:09:15  Show Profile  Visit richfed's Homepage  Reply with Quote
When clicking on the Alert Bar to sign up to forum, I receive this:

Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/mforum/register.asp, line 256
strSql = strSql & ", 1
----------------------^
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 05 August 2014 :  14:36:36  Show Profile  Reply with Quote
There should be a closing quotation mark at the end of the line.
Go to Top of Page

golfmann
Junior Member

United States
450 Posts
Posted - 01 October 2014 :  23:38:40  Show Profile  Visit golfmann's Homepage  Reply with Quote
I'm holding out for MS10...
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 02 October 2014 :  00:24:41  Show Profile  Reply with Quote
Do you mean Windows 10 and, if so, what does that have to do with this?
Go to Top of Page

golfmann
Junior Member

United States
450 Posts
Posted - 02 October 2014 :  14:11:13  Show Profile  Visit golfmann's Homepage  Reply with Quote
Yes (I heard they were changing name) and it was just a joke because of all the 8.1 stuff...

A little humor doesn't hurt (nor do smiles) but I will refrain on this serious topic...

Sorry.
Edited by - golfmann on 02 October 2014 14:14:53
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07