Backup and restore cookie and site exception list in Firefox

README.md

Installation

mkdir -p ~/bin
curl --proto "=https" --tlsv1.2 https://gist.githubusercontent.com/msanders/57837aaf6f7da30dcc1eb0bdf6b0b733/raw/firefox_export_cookie_exceptions > ~/bin/firefox_export_cookie_exceptions
curl --proto "=https" --tlsv1.2 https://gist.githubusercontent.com/msanders/57837aaf6f7da30dcc1eb0bdf6b0b733/raw/firefox_restore_cookie_exceptions > ~/bin/firefox_restore_cookie_exceptions
chmod u+x ~/bin/firefox_export_cookie_exceptions  ~/bin/firefox_restore_cookie_exceptions 
mkdir -p ~/.local/share/fxcookies

# NOTE: Firefox must be closed in order for restore to unlock the database.
# https://kb.mozillazine.org/Profile_folder_-_Firefox#Finding_the_profile_folder
~/bin/firefox_export_cookie_exceptions /path/to/fxprofile > ~/.local/share/fxcookies/exceptions.txt
~/bin/firefox_restore_cookie_exceptions /path/to/fxprofile ~/.local/share/fxcookies/exceptions.txt

License

Copyright Michael Sanders.

This work is licensed under the terms of the MIT license. For a copy, see https://opensource.org/licenses/MIT.

firefox_export_cookie_exceptions

#!/bin/sh
# https://gist.github.com/msanders/57837aaf6f7da30dcc1eb0bdf6b0b733
# License: MIT
set -o errexit -o nounset

SCRIPT_NAME="$(basename "$0")"

show_usage() {
    cat <<USAGE
Usage: $SCRIPT_NAME <profile>

Export cookie exceptions from a Firefox profile as a newline-separated list of
domain names.
USAGE
}

main() (
    if [ "$#" -ne 1 ]; then
        show_usage
        exit 1
    fi
    case "$1" in
        -h | --help)
            show_usage
            exit
    esac

    profiledir="$(readlink -f "$1")"
    dbpath="$profiledir/permissions.sqlite"
    sqlite3 -init /dev/null -readonly "file://$dbpath?immutable=1" <<EOF | sed "s_^https\{0,1\}://__" | sort -u
SELECT
  origin
FROM
  moz_perms
WHERE
  type = 'cookie'
  AND permission = 1
  AND expireTime = 0;
EOF
)

main "$@"

firefox_restore_cookie_exceptions

#!/bin/sh
# https://gist.github.com/msanders/57837aaf6f7da30dcc1eb0bdf6b0b733
# License: MIT
set -o errexit -o nounset

SCRIPT_NAME="$(basename "$0")"

show_usage() {
    cat <<USAGE
Usage: $SCRIPT_NAME <profile> <backup>

Restore cookie exceptions for Firefox profile from a newline-separated list of
domain names. Any exceptions stored in the profile that are not included in the
backup will be removed.
USAGE
}

sql_insertion_statement() (
    dbpath="$1"
    origin="$2"
    mtime="$3"
    cat <<EOF
INSERT INTO
  moz_perms (
    origin,
    type,
    permission,
    expireType,
    expireTime,
    modificationTime
  )
VALUES
  ('$origin', 'cookie', 1, 0, 0, $mtime);
EOF
)

generate_sql() {
    dbpath="$1"
    backup="$2"
    modtime="$(date +%s000)"
    while read -r line; do
        sql_insertion_statement "$dbpath" "https://$line" "$modtime"
        sql_insertion_statement "$dbpath" "http://$line" "$modtime"
    done <"$backup"
}

main() (
    if [ "$#" -ne 2 ]; then
        show_usage
        exit 1
    fi
    for i; do
        case $i in
            -h | --help)
                show_usage
                exit
        esac
    done

    profiledir="$1"
    backup="$2"
    dbpath="$profiledir/permissions.sqlite"
    sql="$(generate_sql "$dbpath" "$backup")"
    sqlite3 -init /dev/null "$dbpath" <<EOF
BEGIN TRANSACTION;
DELETE FROM moz_perms
WHERE
  type = 'cookie'
  AND permission = 1
  AND expireTime = 0;
$sql
COMMIT;
EOF
    printf "Successfully imported cookie exceptions to '%s'.\n" "$dbpath"
)

main "$@"