ainsofs

-- create drupal databases
mysql -u root -p

CREATE DATABASE drupal;

CREATE USER drupaluser@localhost IDENTIFIED BY 'password';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES ON drupal.* TO drupaluser@localhost;

FLUSH PRIVILEGES;

ainsofs

    drush dl ckeditor
    drush en -y ckeditor
    drush ckeditor-download


drush make-generate [fileName].make

ainsofs

#ubuntu 12
sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/example.com

#ubuntu 14
sudo cp /etc/apache2/sites-available/000-default.config /etc/apache2/sites-available/example.com.config

sudo nano /etc/apache2/sites-available/example.com
ServerName example.com 

ainsofs

public class DnnLogger {
    private EventLogController Controller;

    public DnnLogger() {
      Controller = new EventLogController();
    }

    public void AddLog(string message)
    {
      var log = CreateLogDefaults();

ainsofs

interface IWebApiResponse {
        bool ApiSuccess { get; set; }
        string ApiError { get; set; }
        string ApiStackTrace { get; set; }
    }

ainsofs

# ensure you have backed up the database and files before running these commands
# mysql/mariadb
drush sql-dump --gipz --result-file

#postgres
pg_dump -U postgres -h localhost "[YOUR_DATABASE]" | gzip > [dbname]-[date]00.sql.gz

# remove old files
rm -rf images/ includes/ misc/ modules/ profiles/ scripts/ themes/
rm -f .* *.php *.txt *.config

ainsofs

## login to a database
psql -U [username] [database_name]

## check database size
SELECT pg_size_pretty( pg_database_size('dbname') );

## check table sizes (top 5)
SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
  FROM pg_class C

ainsofs

For Alfresco 4.x and Solr 1.4:

#! /bin/bash
export ALF_HOME=/opt/alfresco4
export SOLR_HOME=/opt/alfresco4/alf_data/solr

$ALF_HOME/alfresco.sh stop
sleep 10

rm -rf $SOLR_HOME/workspace/SpacesStore/*

ainsofs

-- kill all connections For MS SQL Server 2000, 2005, 2008

USE master;

DECLARE @kill varchar(8000); SET @kill = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'  
FROM master..sysprocesses  
WHERE dbid = db_id('MyDB')

EXEC(@kill); 

ainsofs

<!-- requires url rewrite module --->
<!-- https://docs.microsoft.com/en-us/archive/blogs/dawiese/redirect-from-http-to-https-using-the-iis-url-rewrite-module -->

<system.webServer>
    <rewrite>
        <rules>
            <rule name="Redirect http to https" patternSyntax="Wildcard" stopProcessing="true">
                <match url="*" />
                <conditions>
                    <add input="{HTTPS}" pattern="off" />