Edventures in Normalcy

Testing http header IP forwarding

Posted by Rose Bush on May 5th, 2015

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:

<?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>');

?>

<?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.

Filed under: Code or Hosting | Comment (0)

Find the Default File Paths for a Given SQL Instance

Posted by Rose Bush on May 4th, 2015

Method 1 of 1?

-- 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;

-- 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;

Filed under: Code or Hosting | Comment (0)

Create the alias with cliconfg.exe

Posted by Rose Bush on May 4th, 2015

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/

Filed under: Code or Hosting | Comment (0)

Exporting/Importing (Migrating) All Non System MSSQL Databases

Posted by Rose Bush on May 4th, 2015

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:

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 master

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:

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

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

from #filesinfo

drop table #filesinfo

Filed under: Code or Hosting | Comment (0)

Solved dotDefender An error occured. Action: get_update_best_practice_rules_configuration Exception: Invalid Response

Posted by Rose Bush on July 17th, 2014

Solved the following dotDefender error:

Error text:
An error occured.

Action: get_update_best_practice_rules_configuration

Exception: Invalid Response

Internet Information Services 7.5

Error Summary
HTTP Error 403.18 – Forbidden

The specified request cannot be processed in the application pool that is configured for this resource on the Web server.

Detailed Error Information

Module
IIS Web Core

Notification
BeginRequest

Handler
StaticFile

Error Code
0x00000000

Requested URL
http://127.0.0.1:80/Rejected-By-UrlScan?~/dotDefender/dotDefenderWS.exe

Physical Path
C:\inetpub\wwwroot\Rejected-By-UrlScan

Most likely causes: •An ISAPI filter or custom module changed the URL to run in a different application pool than the original URL.
•An ISAPI extension (or custom module) used ExecuteURL (or ExecuteRequest) to run in a different application pool than the original URL.
•You have a custom error page that is located in one application pool but is referenced by a Web site in another application pool. When the URL is processed, it is determined by IIS that that it should have been processed in the first application pool, not the other pool.
•The Web site has multiple applications configured. The application this request is configured to run in is set to run in an application pool that does not exist.

Things you can try: •If you have an application that is trying to process a URL in another application pool (such as trying to process a custom error), ensure that they both run in the same application pool if appropriate.
•If you are trying to process a custom error URL that is located in another application pool, enable the custom errors Redirect feature.
•Verify that the application pool for the application exists.
•Create a tracing rule to track failed requests for this HTTP status code and see if ExecuteURL is being called. For more information about creating a tracing rule for failed requests, click here.

Links and More InformationThis error occurs if the application pool for the request does not exist, or if an ISAPI filter, ISAPI extension or HTTP module calls the ExecuteURL server support function (or ExecuteRequest) with a URL that is configured in a different application pool. Due to security reasons, a Web site in one application pool cannot make ExecuteURL requests against a URL in another application pool. If you have an application that is trying to process a URL in another application pool, ensure that they both run in the same application pool if appropriate.
View more information »
Show details Reload current node

Screen shot:

Resolve:
I went to the ISAPI Filters for the site, saw the following:
UrlScan 3.1
C:\Windows\system32\inetsrv\urlscan\urlscan.dll
Local

Removed it, site specific, and was then able to browse to the admin section as expected.

UPDATE!!!

I found a better way to fix the issue. Create an exclusion for dotDefender within URLScan, just like the installation instructions for dotDefender lists (http://www.applicure.com/downloads/5.11/dD-installation-guide-v5%2011_IIS.pdf), odd I know.

The file is found here:
%WINDIR%\System32\Inetsrv\URLscan
And is named
UrlScan.ini

Find the section for [AlwaysAllowedUrls] and add this line below it and above the following section:
/dotDefender/dotDefenderWS.exe ; Don’t filter requests to dotDefender

My config now has the follwoing section:
~~~~~~~~~
[AlwaysAllowedUrls]
;
; URLs listed here will always be explicitly allowed by UrlScan
; and will bypass all UrlScan checks. URLs must be listed
; with a leading ‘/’ character. For example:
;
; /SampleURL.htm
;
/dotDefender/dotDefenderWS.exe ; Don’t filter requests to dotDefender
~~~~~~~~~

Filed under: Code or Hosting | Comment (0)

Solved: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

Posted by Rose Bush on January 2nd, 2014

I ran into this error on a RHEL machine that recently patched. To correct the issue, I recreated the symlink in /tmp :

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
service mysqld restart

1 2	ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock service mysqld restart

I found the solve and associated troubleshooting steps here: http://forums.cpanel.net/f354/cant-connect-local-mysql-server-through-socket-var-lib-mysql-mysql-sock-111-a-78444.html

Filed under: Code or Hosting | Comment (0)

iMIS Requirements for 15.1 15.2 and 20

Posted by Rose Bush on August 2nd, 2013

iMIS:

Version 15.1.3 requires SQL Server 2008 (R1, as R2 will not work even in compatibility mode). By version 15.2 is when SQL Server 2008 R2 can be used.

Requirements for iMis 15.2.15
*Microsoft SQL Server and Express Edition 2012
*Microsoft SQL Server and Express Edition 2008 SP3 and 2008 R2 SP1 (32-bit and 64-bit) (Note: 2008 R2 is not backwards compatible)
*Microsoft SQL Server and Express Edition 2005 SP4 (Note: the shipped Demo DB is not supported on SQL Server 2005)

System requirements
iMIS architecture is made up of a single database server, one or more application servers (appservers), and two types of clients (a Windows application and a web application), which run on typical workstations. These requirements apply across database servers, appservers, and workstations; web clients only need to meet requirements for displays and browsers.

Upgrades: This version supports upgrades from any version of iMIS, starting with 15.1.3. For best results with earlier versions of iMIS, complete the upgrade to 15.1.3 before proceeding.

Caution! The installer removes any existing files for unsupported products, which includes e-CM, e-CM 5.1 publishing service, e-Series, and iBO for COM.

Minimum hardware (all)

See Configuration Examples for typical upgrades.
* 10/100 Mbps network connection between database server host and all appservers and iMIS Desktop clients
* 2 GHz Intel Pentium 4 or compatible processor (64-bit processors must support Intel 64 or AMD64 architectures; some Intel Xeon server processors prior to 2007 may have issues running iMIS Desktop on 64-bit Windows Vista or 7)
* 2 GB of RAM
* 3.2 GB for a full/custom install; 1.8 MB for Desktop install/upgrade (InstallShield may under-report disk space needed)
* An additional 2 GB of disk space on the C: drive (for temp files); and when upgrading, an additional amount of C: drive disk space on the database server that totals twice the size of your database.
* Application Server: additional disk space for publishing and indexing your contact files for search (e.g., 275K contacts=1GB, 2M contacts=7.56GB)
* Display with 1024 x 768 (XVGA) minimum resolution
Operating systems
* Servers: Windows Server 2003 R2 SP2, 2008 SP2, and 2008 R2 SP1 (32-bit and 64-bit, Standard/Enterprise/Datacenter editions only)
* iMIS Desktop: Windows Vista SP2 and 7 SP1 (32-bit and 64-bit), installed as and set to run as Administrator, with non-Aero theme (see note above for 64-bit Intel Xeon server processors)
Databases
* Microsoft SQL Server and Express Edition 2012
* Microsoft SQL Server and Express Edition 2008 SP3 and 2008 R2 SP2 (32-bit and 64-bit) (Note: 2008 R2 is not backwards compatible)
* Microsoft SQL Server and Express Edition 2005 SP4 (Note: the shipped Demo DB is not supported on SQL Server 2005)
Appservers
* Microsoft .NET Framework 4.0 (ASP.NET)
* Microsoft SQL Server 2005/2008/2012 Tools
* Microsoft Internet Information Services (IIS) 6, 7, or 7.5
* Microsoft Windows Indexing Service (see Preparing all servers and workstations)
Systems running iMIS Desktop
* Microsoft .NET Framework 4.0 (ASP.NET)
* Microsoft Word 2007 SP3 and Word 2010 SP1, for Word integration
* Microsoft Excel 2007 SP3 and Excel 2010 SP1 for iMIS Analytics
* Adobe Reader 10.1, installed on all servers and clients to print iMIS reports
* (optional) ExpoCAD 7.4
* Omnis 7 version 3.6.4 (included with install)
Browsers
* Internet Explorer 8-9 (native) for iParts; Internet Explorer 8 (compatibility mode) for all non-iPart .NET web applications; Internet Explorer 9 for iMIS Desktop
* Firefox (most recent stable version), for iParts, web views, and WCM-generated websites (version 19 as of 19 Feb 2013)
* Chrome (most recent stable version), for iParts (version 25 as of 21 Feb 2013)
* Apple IOS 6.1: native default browser, for iParts
Report writing
* Reporting Services: SQL Server 2005 Express Edition Toolkit,
SQL Server 2008 Report Builder 2.0, SQL Server 2008 R2 Report Builder 3.0, or SQL Server 2012 Report Builder
* Crystal Reports: Crystal 9.0

http://docs.imis.com/15.2/index.htm#!systemrequirements.htm
http://docs.imis.com/20.0/#!systemrequirements.htm

System requirements
iMIS architecture is made up of a single database server, one or more application servers (appservers), and two types of clients (a Windows application and a web application), which run on typical workstations. These requirements apply across database servers, appservers, and workstations. Web clients only need to meet requirements for displays and browsers.

Upgrades: This version supports upgrades from any version of iMIS, starting with 15.1.3. For best results with earlier versions of iMIS, complete the upgrade to 15.1.3 before proceeding.

Caution! The installer removes any existing files for unsupported products, which includes e-CM, e-CM 5.1 publishing service, e-Series, and iBO for COM.

Minimum hardware (all)

See Configuration Examples for typical upgrades.
* 100/1000 Mbps network connection between database server host and all appservers and iMIS desktop clients
* 2 GHz Intel Pentium 4 or compatible processor (64-bit processors must support Intel 64 or AMD64 architectures. Some Intel Xeon server processors prior to 2007 might have issues with running iMIS desktop on 64-bit Windows Vista or Windows 7)
* 2 GB of RAM
* 3.2 GB of disk space for a full/custom install. 1.8 MB for desktop install/upgrade (InstallShield might under-report disk space needed)
* An additional 2 GB of disk space on the C: drive (for temporary files). When upgrading, an additional amount of C: drive disk space on the database server that totals twice the size of your database
* Application Server: additional disk space for publishing and indexing your contact files for search (for example, 275K contacts=1GB, 2M contacts=7.56GB)
* Display with 1024 x 768 (XVGA) minimum resolution
Operating systems
* Servers: Windows Server 2008 R2 SP1 and 2012 (32-bit and 64-bit, Standard/Enterprise/Datacenter editions only)
* iMIS desktop: Windows Vista SP2, Windows 7 SP1, and Windows 8 (32-bit and 64-bit), installed as and set to run as Administrator, with non-Aero theme (see note above for 64-bit Intel Xeon server processors)
Databases
* Microsoft SQL Server and Express Edition 2012
* Microsoft SQL Server and Express Edition 2008 SP3 and 2008 R2 SP2 (32-bit and 64-bit) (Note: 2008 R2 is not backwards compatible)
Appservers
* Microsoft .NET Framework 4.0 (ASP.NET)
* SQL Server 2008/2012 Tools
* Microsoft Internet Information Services (IIS) 7.5 or 8
* Apache Lucene 4.1 Indexing and Search
Systems running iMIS desktop
* Microsoft .NET Framework 4.0 (ASP.NET)
* Microsoft Word 2007 SP3 and Word 2010 SP1, for Word integration
* Microsoft Excel 2007 SP3 and Excel 2010 SP1 for iMIS Analytics
* Adobe Reader 11.0, installed on all servers and clients to print iMIS reports.
* (optional) ExpoCAD 7.4
* (included with install) Omnis 7 version 3.6.4
Browsers
* Internet Explorer 8-10 (native) for iParts
* Internet Explorer 8 (compatibility mode) for all non-iPart .NET web applications
* Internet Explorer 9-10 for iMIS desktop
* Firefox (most recent stable version), for iParts, web views, and WCM-generated websites (version 19 as of 26 Mar 2013)
* Chrome (most recent stable version), for iParts (version 26 as of 26 Mar 2013)
* Apple IOS 6.1: native default browser, for iParts
* Google Android 4.1: native default browser, for iParts
Report writing
* Reporting Services: SQL Server 2008 Report Builder 2.0, SQL Server 2008 R2 Report Builder 3.0, or SQL Server 2012 Report Builder
* Crystal Reports 9.0

iMIS 10.6 system requirements:

I cannot find documentation for this version as of yet. If you find it, please comment it and I will gladly credit you.

Filed under: Code or Hosting | Comment (0)

Updating Local Host Entries and Web Server Caching

Posted by Rose Bush on April 30th, 2013

If you edit a hosts entry on your server, you win, and if windows, you need not restart IIS as ASP.NET does not cache this resolution, PHP run as an apache module DOES require a restart of apache. Idk about other languages just yet, nor services tied to them.

Filed under: Code or Hosting | Comment (0)

SQL Server FAQ

Posted by Rose Bush on April 18th, 2013

I wanted a place to throw a lot of the high level SQL FAQ and answers for issues I come to.

v=sql.70 7
v=sql.80 2000
v=sql.90 2005
v=sql.100 2008
v=sql.105 2008R2
v=sql.110 2012
v=sql.120 2014
v=sql.130 2016

This site lists build versions, this is really useful for matching version to version by running the updates needed manually:

Microsoft SQL Server 2012, 2008R2, 2008, 2005, 2000 and 7.0 Builds

SQL Server 2012 msdn: Editions and Components of SQL Server 2012

SQL Server 2008 R2 msdn: Editions and Components of SQL Server 2008 R2

Server Editions:
*Datacenter
*Enterprise
*Standard

Specialized Editions:
*SQL Server Developer
*SQL Server Workgroup
*SQL Server Web
*SQL Server Express (SQL Server Express with Tools, SQL Server Express with Advanced Services)
*Compact 3.5 SP1 (x86) Compact 3.1 (x86)

SQL Server 2008 msdn: Editions and Components of SQL Server 2008

SQL Server 2005 msdn: Editions and Components of SQL Server 2005

Anything else was too old for my purposes.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MSSQL Data links:

http://en.wikipedia.org/wiki/Microsoft_SQL_Server

Deprecated Database Engine Features in SQL Server 2012
http://msdn.microsoft.com/en-us/library/ms143729.aspx

Build version list, you have a version number and want to know what updates are in there:
http://sqlserverbuilds.blogspot.com/

Features Supported by the Editionhere here here here hereNOPENOPENOPE

	SQL Server 2016	SQL Server 2014	SQL Server 2012	SQL Server 2008 R2	SQL Server 2008		SQL Server 2000	SQL Server 7
Hardware and Software Requirements	here	here	here	here	here		NOPE	NOPE
Editions and Components	here	here	here	here	here		NOPE	NOPE

Hardware and Software Requirements for Installing SQL Server 2012
http://msdn.microsoft.com/en-us/library/ms143506.aspx

Features Supported by the Editions of SQL Server 2008 R2
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

Features Supported by the Editions of SQL Server 2012 (FYI SQL web does support SQL profiler some how?)
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx

Features Supported by the Editions of SQL Server 2014
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

Features Supported by the Editions of SQL Server 2016
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.130).aspx

Features Supported by the Editions of SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms143761(v=sql.90).aspx

Prevent Truncation for Dynamically Generated T-SQL Results in SSMS
https://www.edwinbush.com/prevent-truncation-for-dynamically-generated-t-sql-results-in-ssms/

Migrating SQL Server Users
https://www.edwinbush.com/migrating-sql-server-users/

Filed under: Code or Hosting | Comment (0)

Solved: Java method security exception.A security exception occurred while invoking Java method on a “”java.lang.Class”” object. MethodName is getName. Possible cause: Either the createobject function and cfobject tag are disabled in the security sandbox or you are trying to create a class in the ColdFusion package and that is disabled.

Posted by Rose Bush on April 15th, 2013

I was getting this error in the exception log:

“Error”,”ajp-bio-8012-exec-37″,”04/12/13″,”11:51:15″,”mgtemplate”,”Java method security exception.A security exception occurred while invoking Java method on a “”java.lang.Class”” object. MethodName is getName. Possible cause: Either the createobject function and cfobject tag are disabled in the security sandbox or you are trying to create a class in the ColdFusion package and that is disabled. The specific sequence of files included or processed is: C:\inetpub\mgtemplate\RemotingService.cfc, line: 1 ”
coldfusion.runtime.StructBean$SecurityException: Java method security exception.
at coldfusion.runtime.StructBean.checkPermission(StructBean.java:96)
at coldfusion.runtime.StructBean.invoke(StructBean.java:482)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2465)
at Statement870.evaluate(:1)
at coldfusion.runtime.CFPage.evaluateCondition(CFPage.java:9340)
at cfAbstractRemotingService2ecfc1188850940$funcRESETCFHTMLHEAD.runFunction(C:\inetpub\ModelGlue\gesture\remoting\AbstractRemotingService.cfc:59)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2659)
at cfAbstractRemotingService2ecfc1188850940$funcEXECUTEEVENT.runFunction(C:\inetpub\ModelGlue\gesture\remoting\AbstractRemotingService.cfc:40)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2659)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2455)
at cfRemotingService2ecfc1182307450$funcEXECUTEEVENT.runFunction(C:\inetpub\mgtemplate\RemotingService.cfc:17)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:193)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:436)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:155)
at coldfusion.xml.rpc.CFCServlet.doPost(CFCServlet.java:331)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

I was also watching the server and saw that coldfusion.exe was attempting these file touches per procmon.exe:

11:08:40.3218412 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3223507 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\axis2\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3224855 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\gateway\lib\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3226892 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\wwwroot\WEB-INF\cfform\jars\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3228584 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\wwwroot\WEB-INF\flex\jars\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3229917 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\lib\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3231216 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\bin\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3232705 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\lib\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3234821 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\classes\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3236827 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\wwwroot\WEB-INF\classes\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3239420 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\lib\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3241352 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\classes\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3243784 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\lib\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3246013 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\classes\coldfusion\runtime\StructBean.SecurityException_en_US.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3248251 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3252732 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\axis2\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3254280 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\gateway\lib\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3256051 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\wwwroot\WEB-INF\cfform\jars\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3257616 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\wwwroot\WEB-INF\flex\jars\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3259245 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\lib\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3260489 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\bin\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3261651 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\lib\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3262954 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\classes\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3265052 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\wwwroot\WEB-INF\classes\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3266873 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\lib\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3268189 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\classes\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3270259 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\lib\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
11:08:40.3271909 AM coldfusion.exe 2864 CreateFile C:\ColdFusion10\cfusion\lib\oosdk\classes\coldfusion\runtime\StructBean.SecurityException_en.properties PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a

I compared ColdFusion versions, settings, JVM configs and settings and versions. I was at a loss. It turns out, within the ColdFusion Administrator the check box for the below was checked:
Disable access to internal ColdFusion Java components
Disables the ability for CFML code to access and create Java objects that are part of the internal ColdFusion implementation. This prevents an unauthenticated CFML template from reading or modifying administration and configuration information for this server.

Once I unchecked this and saved my settings, the section on the site worked.

Filed under: Code or Hosting | Comment (0)

UPDATE!!!

Search:

Archives