Edventures in Normalcy

Mindblown: a blog about philosophy.

  • Apache SetEnvIf Logical AND with Two Variables

    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…

  • Command Line Add woff Mime Type

    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’]” 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.

  • Testing http header IP forwarding

    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 =…

  • Find the Default File Paths for a Given SQL Instance

    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…

  • Create the alias with cliconfg.exe

    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…

  • Exporting/Importing (Migrating) All Non System MSSQL Databases

    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”…

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

    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…

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

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

  • iMIS Requirements for 15.1 15.2 and 20

    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)…

  • If you are not bettering yourself

    If you’re not bettering yourself, you’re worse off than you could have been! I once reasoned that person A, having a question, cannot be upset nor hold any negativity to person B for person B not answering said question if person A fails to ask the question. This was a stark realization that in order…

Got any book recommendations?

Get In Touch