“ApplicationPoolIdentity is assigned membership of the Users group as well as the IIS_IUSRS group.” Source: http://stackoverflow.com/questions/5437723/iis-apppoolidentity-and-file-system-write-access-permissions
I often need to add Users in particular to give the permissions needed.
In trying to adjust the method of logging in Apache, it was found logical to have the configuration perform an AND on two variables to validate one format vs another. I had not found much detail on this, until making my way to: http://stephane.lesimple.fr/blog/2010-01-28/apache-logical-or-and-conditions-with-setenvif.html. From the page archived, I had the following:
|
1 2 3 4 5 |
CustomLog /var/log/apache2/loopback_posts.log combined env=posting_myself SetEnvIf Remote_Addr "^" loopback_ip=0 SetEnvIf Remote_Addr "^127\.0\.0\.1$" loopback_ip=1 SetEnvIf Request_Method "POST" posting_myself SetEnvIf loopback_ip 0 !posting_myself |
In my example, it was not able to work as shown above, but not of by much. We quoted the last 0 in the lines we had written, giving us the following example:
|
1 2 3 4 5 6 |
SetEnvIf X-Forwarded-For "^.*\..*\..*\..*" forwarded SetEnvIf Remote_Addr "^" LB_ip=0 SetEnvIf Remote_Addr "10\.11\.0\.254" LB_ip=1 SetEnvIf LB_ip "0" !forwarded CustomLog logs/access_log proxy env=forwarded CustomLog logs/access_log combined env=!forwarded |
When tested, requests coming from the LB IP are listed as trusted, and only trusted requests are adjusted and trusted as having been forwarded. Other requests, we can assume (based on topology) with x-forwarded-for header are identified as falsified.
Easily add in the woff mime-type with the below command:
|
1 |
%systemroot%\system32\inetsrv\appcmd set config /section:staticContent /+"[fileExtension='.woff',mimeType='application/font-woff']" |
To note, the above placed the configuration within the applicationHost.config and not in a web.config. As desired in my scenario as I had wanted the configuration to be server wide.
I need to determine what the application sees versus what is being sent, these scripts helped me see the discrepancy and validate the change once resolved:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
<?php header('Expires: 0'); // Proxies. header('Cache-Control: no-store, no-cache, must-revalidate'); // HTTP 1.1. header('Cache-Control: post-check=0, pre-check=0', FALSE); header('Pragma: no-cache'); // HTTP 1.0. $client = @$_SERVER['HTTP_CLIENT_IP']; $forward = @$_SERVER['HTTP_X_FORWARDED_FOR']; $remote = $_SERVER['REMOTE_ADDR']; print ('This page was generated ' . date(DATE_RFC2822) . '.'); print ("<br /><br /><br />Client IP address reported by the REMOTE_ADDR variable is $remote"); print ("<br /><br />Client IP address reported by the HTTP_X_FORWARDED_FOR variable is $forward"); print ("<br /><br />Client IP address reported by the HTTP_CLIENT_IP variable is $client"); if(filter_var($client, FILTER_VALIDATE_IP)) { $ip = $client; } elseif(filter_var($forward, FILTER_VALIDATE_IP)) { $ip = $forward; } else { $ip = $remote; } print ("<br /><br /><br />Client IP address determined to be $ip"); print ('<br /><br /><form method="POST"> <input type="submit" name="b1" value="Force Reload." /></form>'); ?> |
The above does allow you to force a post, as the original case was behind a caching server.
Method 1 of 1?
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
-- Check if temp database exists -- Tempdatabase is used for determining the default database path --if the zztempDefaultPath db exists drop IF EXISTS(SELECT 1 FROM [master].[sys].[databases] WHERE [name] = 'zzTempDBForDefaultPath') BEGIN DROP DATABASE zzTempDBForDefaultPath END; -- Create temp database. Because no options are given, the default data and --- log path locations are used CREATE DATABASE zzTempDBForDefaultPath; --Declare variables for creating temp database DECLARE @Default_Data_Path VARCHAR(512), @Default_Log_Path VARCHAR(512); --Get the default data path SELECT @Default_Data_Path = ( SELECT LEFT(physical_name,LEN(physical_name)-CHARINDEX('\',REVERSE(physical_name))+1) FROM sys.master_files mf INNER JOIN sys.[databases] d ON mf.[database_id] = d.[database_id] WHERE d.[name] = 'zzTempDBForDefaultPath' AND type = 0); --Get the default Log path SELECT @Default_Log_Path = ( SELECT LEFT(physical_name,LEN(physical_name)-CHARINDEX('\',REVERSE(physical_name))+1) FROM sys.master_files mf INNER JOIN sys.[databases] d ON mf.[database_id] = d.[database_id] WHERE d.[name] = 'zzTempDBForDefaultPath' AND type = 1); --Clean up. Drop de temp database IF EXISTS(SELECT 1 FROM [master].[sys].[databases] WHERE [name] = 'zzTempDBForDefaultPath') BEGIN DROP DATABASE zzTempDBForDefaultPath END; PRINT @Default_Data_Path; PRINT @Default_Log_Path; |
Option 2: Create the alias with cliconfg.exe
Log into the Application and/or front-end Web servers
Got to Start > cliconfg.exe (Note: it’s c-l-i-c-o-n-f-g-dot-e-x-e)
Then click on “Alias”:
If you already have an alias set up, it will show up there. Otherwise…
Click “Add”
Specify the port number and give it a name. That’s it!
Test your SQL Alias:
To test your SQL alias, create a Microsoft Data Link (udl) file on your desktop:
From your desktop, right click on the desktop and choose New > Text file
A new file named New Text Document.txt appears in the directory.
Rename this file to “TestDBConnection.udl”, removing all spaces. Be sure to change its file extension to .udl.
Open the file and, under Connection, type either the SQL server name or, if you are testing an SQL alias, the alias name.
Under 2, chose “Windows Authenticated security”
Click “refresh”
If the connection was successful, list of databases should appear in the dropdown menu under #3.
I have a separate blog post that covers the same steps for creating a udl file here. http://smallcitydesign.com/how-to-test-a-database-connection-from-an-application-server/
I want all DB’s moved, from SQL Server/Instance A to SQL Server/Instance B. The easiest way to do this of course, is scripted :D. Oh how I love the idea of automation.
Generate export script:
|
1 2 3 4 5 6 7 8 |
use master GO select ' BACKUP DATABASE [' + [name] + '] TO DISK = N''C:\RESTORE\PATH\' + [name] + '.bak'' WITH NOFORMAT, NOINIT, NAME = N''' + [name] + '-Full Database Backup'' , SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO' from master..sysdatabases where dbid > 4 |
Use the output to backup the databases.
Then run the following command to get the import commands you would run on the destination instance:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
declare @cmd1 varchar(500) declare @cmd2 varchar(500) declare @cmd3 varchar(500) declare @pre varchar(500) set @cmd1 = 'insert into #filesinfo (db, dn, dfn ) select ''?'', [name], [filename] from [?]..sysfiles where groupid=1' set @cmd2 = 'update #filesinfo set ln = [name], lfn =[filename] from [?]..sysfiles sf where sf.groupid=0 and #filesinfo.db=''?''' set @cmd3 = 'update #filesinfo set nf = (select count(*) from [?]..sysfiles) where #filesinfo.db=''?''' CREATE TABLE #filesinfo (db sysname, dn sysname, ln sysname null, dfn nvarchar(500), lfn nvarchar(500) null, nf int, sa sysname null) EXEC sp_MSforeachdb @command1=@cmd1,@command2=@cmd2, @command3=@cmd3 set @cmd1 = 'update #filesinfo set sa = (select sl.[name] from master..syslogins sl inner join [?]..sysusers su on sl.sid=su.sid where su.name=''dbo'') where #filesinfo.db=''?''' EXEC sp_MSforeachdb @command1=@cmd1 --EXEC sp_MSforeachdb 'insert into #filesinfo (db) select ''?''' DELETE FROM #filesinfo WHERE db in ('model','master','tempdb','pubs','Northwind','msdb') --SELECT 'backup database ' + db + ' to disk=''' + db + '.bak''' FROM #filesinfo declare @restorepath nvarchar(1024) declare @datapath nvarchar(1024) declare @logpath nvarchar(1024) set @datapath = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\' set @logpath = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\' set @restorepath = N'C:\EdgeWeb\migrate\' select ' RESTORE DATABASE [' + db + '] FROM DISK = ''' + @restorepath + db + '.bak'' WITH FILE = 1 , MOVE N''' + dn + ''' TO N''' + @datapath + db + '.mdf'' , MOVE N''' + ln + ''' TO N''' + @logpath + db + '_log.ldf'' , NOUNLOAD, REPLACE, STATS = 10 GO ' from #filesinfo drop table #filesinfo |