Main Page

Figure x - shell script to dump MYSQL databases, first draft script:

   $ sudo aptitude -o APT::Force-LoopBreak=1

 *  https://wiki.ubuntu.com/DpkgTriggers

Preparing to unpack libc-bin_2.27-2_i386.deb ...
dpkg: error processing archive libc-bin_2.27-2_i386.deb (--install):
 triggers ci file contains unknown directive `interest-await'
Errors were encountered while processing:
 libc-bin_2.27-2_i386.deb

user@localhost:~$ gtf 1920 1080 60

  # 1920x1080 @ 60.00 Hz (GTF) hsync: 67.08 kHz; pclk: 172.80 MHz
  Modeline "1920x1080_60.00"  172.80  1920 2040 2248 2576  1080 1081 1084 1118  -HSync +Vsync

user@localhost:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 8.9 (jessie)
Release:        8.9
Codename:       jessie

user@localhost:~$

user@localhost:/var/log$ grep -n EE Xorg.0.log
15:     (WW) warning, (EE) error, (NI) not implemented, (??) unknown.
342:[    27.938] (EE) open /dev/dri/card0: No such file or directory
344:[    27.938] (EE) open /dev/dri/card0: No such file or directory
351:[    27.945] (EE) open /dev/fb0: No such file or directory
359:[    27.946] (EE) open /dev/fb0: No such file or directory
360:[    27.946] (EE) Screen 0 deleted because of no matching config section.
362:[    27.946] (EE) Screen 0 deleted because of no matching config section.
364:[    27.946] (EE) Screen 0 deleted because of no matching config section.
2689:[    28.915] (EE) AIGLX: reverting to software rendering

user@localhost:/var/log$ grep -n 'LoadModule: ' Xorg.0.log
47:[    27.193] (II) LoadModule: "glx"
58:[    27.669] (II) LoadModule: "ati"
64:[    27.719] (II) LoadModule: "radeon"
70:[    27.795] (II) LoadModule: "modesetting"
76:[    27.832] (II) LoadModule: "fbdev"
82:[    27.842] (II) LoadModule: "vesa"
346:[    27.938] (II) LoadModule: "fbdevhw"
354:[    27.946] (II) LoadModule: "fbdevhw"
368:[    27.946] (II) LoadModule: "vbe"
374:[    27.994] (II) LoadModule: "int10"
396:[    28.200] (II) LoadModule: "ddc"
2651:[    28.611] (II) LoadModule: "shadow"
2657:[    28.621] (II) LoadModule: "fb"
2664:[    28.630] (II) LoadModule: "int10"
2694:[    31.327] (II) LoadModule: "evdev"

user@localhost:/var/log$ grep -n UnloadModule Xorg.0.log
361:[    27.946] (II) UnloadModule: "radeon"
363:[    27.946] (II) UnloadModule: "modesetting"
365:[    27.946] (II) UnloadModule: "fbdev"

user@localhost:/var/log$ grep -n radeon Xorg.0.log
64:[    27.719] (II) LoadModule: "radeon"
65:[    27.720] (II) Loading /usr/lib/xorg/modules/drivers/radeon_drv.so
66:[    27.795] (II) Module radeon: vendor="X.Org Foundation"
361:[    27.946] (II) UnloadModule: "radeon"

user@localhost:/var/log$

   $ ssh-keygen -t rsa

   $ cat ~/.ssh/id_rsa.pub | ssh user@123.45.56.78 "mkdir -p ~/.ssh && cat >>  ~/.ssh/authorized_keys"

Host *
    ServerAliveInterval 300
    ServerAliveCountMax 2

Creating config file /etc/php/7.0/cgi/php.ini with new version
Setting up php7.0 (7.0.25-0ubuntu0.16.04.1) ...
Setting up php (1:7.0+35ubuntu6) ...
Setting up shtool (2.0.8-8) ...
Setting up php7.0-dev (7.0.25-0ubuntu0.16.04.1) ...
update-alternatives: using /usr/bin/php-config7.0 to provide /usr/bin/php-config (php-config) in auto mode
update-alternatives: using /usr/bin/phpize7.0 to provide /usr/bin/phpize (phpize) in auto mode
Setting up php-all-dev (1:35ubuntu6) ...
Setting up php-cgi (1:7.0+35ubuntu6) ...
Setting up php-cli (1:7.0+35ubuntu6) ...
Setting up php-dev (1:7.0+35ubuntu6) ...
Setting up php-doc (20140201-1ubuntu1) ...
Setting up php7.0-mysql (7.0.25-0ubuntu0.16.04.1) ...

Creating config file /etc/php/7.0/mods-available/mysqlnd.ini with new version

Creating config file /etc/php/7.0/mods-available/mysqli.ini with new version

 We have a new and strict firewall policy in place, which is blocking GNU gpg requests from our work site to the greater internet.  Here are some initial references to the issue, both of which mention a protocol called hkps, and also a default gpg port 11371 . . .

user@localhost:~$ gpg --keyserver pgpkeys.mit.edu --recv-key 7638D0442B90D010
gpg: directory `/home/ted/.gnupg' created
gpg: new configuration file `/home/ted/.gnupg/gpg.conf' created
gpg: WARNING: options in `/home/ted/.gnupg/gpg.conf' are not yet active during this run
gpg: keyring `/home/ted/.gnupg/secring.gpg' created
gpg: keyring `/home/ted/.gnupg/pubring.gpg' created
gpg: requesting key 2B90D010 from hkp server pgpkeys.mit.edu
^C
gpg: Interrupt caught ... exiting

ted@VERIS-ALTAENGR:~$ gpg --keyserver pgpkeys.mit.edu --recv-key 7638D0442B90D010
gpg: requesting key 2B90D010 from hkp server pgpkeys.mit.edu
^C
gpg: Interrupt caught ... exiting

user@localhost:~$

## Started 2018-30-29 - TMH
## Reference - https://wiki.archlinux.org/index.php/GnuPG
keyserver hkp://pool.sks-keyservers.net:443

gpg --keyserver pgpkeys.mit.edu --recv-key 010908312D230C5F
gpg -a --export 010908312D230C5F | sudo apt-key add -

Vagrant Cascadian < * e-mail address here * >

AttachmentsDec 7 (1 day ago)

to Juergen, Santiago, Reprobuilds, bug-apl
On 2017-12-05, Juergen Sauermann wrote:
> I have adopted the environment variable approach, which is now
> contained in *SVN 1026*. (and therefore also in the next GNU APL release).

That's great news!

> I took the freedom to change your patch from:
>
> +    BUILD_DATE=`date -u "%F %R:%S %Z" --date=@$SOURDCE_DATE_EPOCH`
>
> to:
>
> + BUILD_DATE=`date -u "+%F %R:%S %Z" --date=$SOURCE_DATE_EPOCH`

Unfortunately, the "@" in the --date argument is necessary for it to
work correctly when SOURCE_DATE_EPOCH is specified:

  $ date -u "+%F %R:%S %Z" --date=1412583777
  date: invalid date ‘1412583777’
  $ date -u "+%F %R:%S %Z" --date=@1412583777
  2014-10-06 08:22:57 UTC
  $ date -u "+%F %R:%S %Z" --date=
  2017-12-06 00:00:00 UTC

At least, that's how it works on my Debian system...

live well,
  vagrant

#!/bin/bash

DATABASE_LIST="information_schema mysql phpmyadmin wikidb database_1 database_2 database_3 ..."

SERVER_NAME="example_database_server"

user="root"
pass_phrase_for_mysql="database-passphrase"
options_extra="--skip-lock-tables"

response="n"

mode_interactive="n"

echo "shell script starting,"

for database in ${DATABASE_LIST}; 
do echo "backing up $SERVER_NAME database $database . . .";

#    command="mysqldump --databases $database -u$user -p$pass_phrase_for_mysql $options_extra >> au-database-back-up--${database}.sql"
    command="mysqldump --databases $database -u$user -p$pass_phrase_for_mysql $options_extra"
    redirect="au-database-back-up--${database}.sql"

    if [ $mode_interactive = 'y' ]; then

        echo "build command '$command' and database back-up filename'$redirect',"
        echo "full command will be '$command' > '$redirect',"
        echo "trying running this command and redirect? [y/N/q]  yes, no, 'q' to quit"

        read response
        if [ $response = 'Y' -o $response = 'y' ]; then
            ${command} > $redirect
        elif [ $response = 'N' -o $response = 'n' ]; then
            echo "skipping present command . . ."
        elif [ $response = 'Q' -o $response = 'q' ]; then
            echo "stopping script '$0' and exiting."
            break
        fi
        echo

    else

        echo "$0:  backing up database '$database' to file '$redirect' . . ."
        ${command} > $redirect
        ls -l $redirect

    fi

done

echo "done."

exit 0

#!/bin/bash

## - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
## Started 2017-12-15 FRI - script to parse and show Linux kernel
##  version from top-level makefile in set of kernel sources.  Patterns
##  to `grep` chosen based on kernel version identifiers in first
##  three lines of typical kernel top-level makefile.  Example:
##
##  $ head -n 6 Makefile
##  VERSION = 4
##  PATCHLEVEL = 9
##  SUBLEVEL = 66
##  EXTRAVERSION =
##  NAME = Roaring Lionus
##
##
## - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

if [ ]; then
    head -n 5 Makefile | grep ^VERSION | cut -d " " -f 3
    head -n 5 Makefile | grep ^PATCH | cut -d " " -f 3
    head -n 5 Makefile | grep ^SUBLEVEL | cut -d " " -f 3
fi

MAJOR=$(head -n 5 Makefile | grep ^VERSION | cut -d " " -f 3)
MINOR1=$(head -n 5 Makefile | grep ^PATCH | cut -d " " -f 3)
MINOR2=$(head -n 5 Makefile | grep ^SUBLEVEL | cut -d " " -f 3)

KERNEL_REVISION="${MAJOR}.${MINOR1}.${MINOR2}"

echo
echo "Kernel version in present kernel sources tree, per makefile, is ${KERNEL_REVISION}"
echo

exit 0

for file in `ls`; do if [ -h $file ]; then ls -l $file; fi; done

Main Page

Getting started - this is MediaWiki's default main page section

Contents

^ Linux Distributions

^ lists of Linux distribution releases

^ Linux and Linux Kernel Projects

^ Linux Administration

^ Linux User Space Configuration

^ Edit point . . .

^ SSH key pair configuration and use

^ SSH keep alive facility

^ installing PHP 7.0

^ GNU gpg utility and to configure gpg with proxy

Secure shell via alternate ports

^ Unix and Linux utilities

^ Shell scripting

bash example: back up multiple MYSQL databases

bash example: show Linux kernel version in kernel makefile

bash example: list symbolic links in long format

^ How To Use Git

^ Drupal Content Management

^ Java Programming and Android App Development

^ Composer, a dependency manager of PHP

^ Geography and Science

^ Mathematica

^ Technology

^ Music and Culture

^ Outdoors

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

Tools notes

Linux topics

Embedded work