A handful of HTML and ASCII Symbol Codes

Posted by Rose Bush on June 11th, 2015

OTHER HTML & ASCII SYMBOL CODES:

↓ Down arrow ↓
‾ Overline &oline;
← Left arrow ←
→ Right arrow →
↑ Up arrow ↑
℠ Service Mark ℠
℃ Celsius ℃
℅ care of ℅
℉ Farenheit ℉
№ numero symbol – number sign №
℗ Sound Recording Copyright &#8471
℞ Prescription Take pharmaceutical symbol &#8478
Ω Ohm &#8486
℧ Inverted Ohm &#8487
☀ sunshine – sun &#9728
☁ cloudy – cloud &#9729
☂ raining – rain &#9730
☃ snow – snowman &#9731
☄ comet &#9732
★ star solid &#9733
☆ star outline &#9734
☇ lightning &#9735
☈ thunderstorm &#9736
☉ sun &#9737
☊ ascending node &#9738
☋ descending node &#9739
☌ conjunction &#9740
☍ opposition &#9741
☎ phone number – phone service &#9742
☏ phone symbol outline &#9743
☐ check box – ballot box &#9744
☑ ballot box check mark &#9745
☒ ballot box with X &#9746
☓ Saltire – St. Andrew’s Cross &#9747
☚ left-pointing index finger &#9754
☛ right-pointing index finger &#9755
☜ left-pointing index finger &#9756
☝ upwards pointing index finger &#9757
☞ right pointing index finger &#9758
☟ downwards pointing index finger &#9759
☠ skull & crossbones &#9760
☡ caution sign &#9761
☢ radioactive sign &#9762
☣ biohazard sign &#9763
☤ Caduceus or “Kerykeion” &#9764
☥ Ankh &#9765
☦ Eastern Christian Cross &#9766
☧ Chi Rho Cross &#9767
☨ Patriarchal Cross &#9768
☩ Greek Cross &#9769
☪ Crescent Moon & Star &#9770
☫ Farsi symbol &#9771
☬ Adi Shakti &#9772
☭ hammer & sickle &#9773
☮ peace sign &#9774
☯ yin & yang &#9775
☰ trigram Heaven &#9776
☱ trigram Lake &#9777
☲ trigram Fire &#9778
☳ trigram Thunder &#9779
☴ trigram Wind &#9780
☵ trigram Water &#9781
☶ trigram Mountain &#9782
☷ trigram Heaven &#9783
☸ Dharma Wheel &#9784
☹ frowning face &#9785
☺ smiley face &#9786
☻ black smiley face &#9787
☽ waxing crescent moon &#9789
☾ waning crescent moon &#9790
☿ Mercury &#9791
♀ Venus – Female symbol &#9792
♁ Earth symbol &#9793
♂ Mars – Male symbol &#9794
♃ Jupiter &#9795
♄ Saturn &#9796
♅ Uranus &#9797
♆ Neptune &#9798
♇ Pluto &#9799
♈ Aries &#9800
♉ Taurus &#9801
♊ Gemini &#9802
♋ Cancer &#9803
♌ Leo &#9804
♍ Virgo &#9805
♎ Libra &#9806
♏ Scorpio &#9807
♐ Sagitarius &#9808
♑ Capricorn &#9809
♒ Aquarius &#9810
♓ Pisces &#9811
♔ White King &#9812
♕ White Queen &#9813
♖ White Rook &#9814
♗ White Bishop &#9815
♘ White Knight &#9816
♙ White Pawn &#9817
♚ Black King &#9818
♛ Black Queen &#9819
♜ Black Rook &#9820
♝ Black Bishop &#9821
♞ Black Knight &#9822
♟ Black Pawn &#9823
♠ black spade suit name: &spades &#9824
♡ red heart suit &#9825
♢ red diamond suit &#9826
♣ black club suit = shamrock name: &clubs &#9827
♤ red spade suit &#9828
♥ black heart suit = valentine name: &hearts &#9829
♦ black diamond suit name: &diams &#9830
♧ red club suit &#9831
♨ hot springs &#9832
♩ musical quarter note &#9833
♪ musical eighth note &#9834
♫ musical single bar note &#9835
♬ musical double bar note &#9836
♭ flat note &#9837
♮ natural note &#9838
♯ sharp note &#9839
✁ cut above &#9985
✂ cut here &#9986
✃ cut below &#9987
✄ scissors &#9988
✆ public pay phone &#9990
✇ film reel – tape spool &#9991
✈ airport jet airplane &#9992
✉ envelope mail email &#9993
✌ victory sign &#9996
✍ signature – sign here &#9997
✎ pencil diagonal down &#9998
✏ pencil &#9999
✐ pencil diagonal up &#1000
✓ check mark &#10003
✔ heavy check mark &#10004
✕ multiplication sign X &#100005
✖ heavy multiplication sign X &#10006
✗ ballot X &#10007
✘ heavy ballot X &#10008
✝ Latin Roman Cross &#10013
✞ Latin Cross 3D shadow &#10014
✟ Latin Cross outline &#10015
✠ Maltese Cross &#10016
✡ Star of David &#10017
❛ quotation mark single turned comma &#10075
❜ quotation mark single comma &#10076
❝ quotation mark double turned comma &#10077
❞ quotation mark double comma &#10078

HTML = ♥
ASCII = ♥
♥

or ♡
♡

Filed under: Code or Hosting | Comment (0)

ApplicationPoolIdentity user in Users & IIS_IUSRS

Posted by Rose Bush on May 19th, 2015

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

Filed under: Code or Hosting | Comment (0)

Apache SetEnvIf Logical AND with Two Variables

Posted by Rose Bush on May 15th, 2015

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:

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

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:

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

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.

Filed under: Code or Hosting | Comment (0)

Command Line Add woff Mime Type

Posted by Rose Bush on May 14th, 2015

Easily add in the woff mime-type with the below command:

%systemroot%\system32\inetsrv\appcmd set config /section:staticContent /+"[fileExtension='.woff',mimeType='application/font-woff']"

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.

Filed under: Code or Hosting | Comment (0)

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

?>

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.

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;

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;

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

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:

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

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

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)

Edventures in Normalcy

A handful of HTML and ASCII Symbol Codes

OTHER HTML & ASCII SYMBOL CODES:

ApplicationPoolIdentity user in Users & IIS_IUSRS

Apache SetEnvIf Logical AND with Two Variables

Command Line Add woff Mime Type

Testing http header IP forwarding

Find the Default File Paths for a Given SQL Instance

Create the alias with cliconfg.exe

Exporting/Importing (Migrating) All Non System MSSQL Databases

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

UPDATE!!!

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

Archives

Links

OTHER HTML & ASCII SYMBOL CODES:

UPDATE!!!

Search:

Archives

Links