Creating new directories for a new year
I have a number of log directories where I store log files where the directory
name is the current year. On the last day of the old year, I want to create
new directories named for the upcoming year. I use the following
Bash
script to create those directories. Since I have several email log directories,
I use a for
loop to create a directory named after the upcoming year in each one.
#!/bin/bash
#
# Create a new directory corresponding to the upcoming year on December 31 of
# every year
newyear=$(date --date=tomorrow +%Y)
echo $newyear
# Apache logs
# Check on whether the directory for the current year exists and, if it doesn't,
# create it.
if [ ! -d /home/jdoe/www/logs/apache/"$newyear" ]; then
mkdir /home/jdoe/www/logs/apache/"$newyear"
chown apache /home/jdoe/www/logs/apache/"$newyear"
chgrp apache /home/jdoe/www/logs/apache/"$newyear"
fi
# Email logs
# Create an array holding the names of the 4 directories within which
# subdirectories will be created using the name of the new year. E.g.,
# /home/jdoe/www/logs/mail/sendmail_stats/2019
logdirs=( "dnsbl_count" "sendmail_stats" "smlogstats" "smreject" )
for i in "${logdirs[@]}"
do :
# Check on whether the directory for the current year exists and, if it
# doesn't, create it.
if [ ! -d /home/jdoe/www/logs/mail/$i/"$newyear" ]; then
mkdir /home/jdoe/www/logs/mail/$i/"$newyear"
chown jdoe /home/jdoe/www/logs/mail/$i/"$newyear"
chgrp jdoe /home/jdoe/www/logs/mail/$i/"$newyear"
fi
doneI then have a
crontab entry containing the following line that will result in the
Bash script above, named end-of-year-dirs, being run at 7;00 AM on December 31
of each year.
0 7 31 DEC * /root/bin/end-of-year-dirs
Related articles:
-
Loop through an array in Bash
-
CRONTAB
-
crontab -e
-
smlogstats
[/os/unix/bash]
permanent link
Gateway 920 Fan Information
Information on the fans contained within a Gateway
920 PC. There are three fans in the system: a CPU fan, a case fan, and a fan
attached to the power supply unit (PSU).
| CPU Temp.: | 34°C/93°F |
| System Temp.: | 28°C/82°F
|
| CPU Fan Speed: | 3515 RPM |
| System Fan Speed: | 2678 RPM |
CPU Fan
Manufacturer: AVC
Model: C6025B12L
Power Connection: 3-Pin
Fan Size: 60mm
DC 12V 
0.12A
Ball Bearing
Case Fan
Manufacturer: Antec
Fan Size: 80mm
Power Supply with Fan
Power Supply Manufacturer: Newton Power Limited
Power Supply Model: NPS-250HB A
Output: 250W Max.
Fan Size: 90mm
[ More Info ]
[/hardware/fans]
permanent link
Adding Google Drive to Nautilus File Manager
Google, unfortunately, does not provide a software package for Linux for Google
Drive support. However, one can still get support for Google Drive through
third-party software or one can use support provided with
GNOME
Files, aka Nautilus, which is the default
file
manager for the
GNOME desktop software under
CentOS 7
Linux. To be able to access files and transfer files to and from Google Drive
storage under CentOS 7 Linux, take the following steps:
-
Click on Applications at the top, left-hand corner of the screen and
select System Tools.
-
Then select Settings.
-
Select Online Accounts from Settings.
-
In the online accounts list, click on Google.
-
You will then be presented with a Google Account sign in window where you
can provide your Google credentials, e.g., an email address or phone number.
-
After you hit enter and log in, you will then be asked to accede to allowing
GNOME to access your Google account, which will allow GNOME the following
access:
If you then click on Applications and Files, you
should see your Google account listed at the left side of the window.
You can then copy files to and from your Google Drive folders to the local
host or access files already stored in Google Drive.
[ More Info ]
[/network/web/services/google/drive]
permanent link
Deleting Windows backups after specified media type is invalid message
When I checked on the status of the weekly backup process on a Microsoft
Windows 10
system by issuing a wbadmin get versions command at
a command prompt, I saw that no
backups had been created since July of 2018.
Microsoft Windows [Version 10.0.17134.285]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\WINDOWS\system32>wbadmin get versions
wbadmin 1.0 - Backup command-line tool
(C) Copyright 2013 Microsoft Corporation. All rights reserved.
Backup time: 7/17/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 07/17/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {76dc6b17-ef40-418f-b13a-a332f3f18c66}
Backup time: 7/24/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 07/24/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {f394de8f-b3e2-4cc0-a2ee-ffb12448f1c6}
Backup time: 7/31/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 07/31/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {275475f1-22d9-455d-893b-f327b8069f99}
Backup time: 8/7/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 08/07/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {58902ac7-c0aa-4384-9abf-b96e89fe1954}
Backup time: 8/14/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 08/14/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {7600fdeb-9722-4f0d-9647-6a5a22613a40}
Backup time: 8/21/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 08/21/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {05e8eefe-486f-4286-bf7a-57ca7ba192e6}
Backup time: 8/28/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 08/28/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {cc0c16df-4eb2-43ca-bb40-4d02928e7617}
Backup time: 9/4/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 09/04/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {98c0f7a3-ca59-4c78-b4c3-5ff716a60bf2}
Backup time: 9/11/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 09/11/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {b066d090-fd1f-44e2-9899-b5defe860e65}
Backup time: 9/18/2016 7:00 PM
Backup target: 1394/USB Disk labeled My Passport(K:)
Version identifier: 09/18/2016-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {88b6a6aa-dce0-439b-96b8-98e1038411cd}
Backup time: 5/27/2018 7:00 PM
Backup target: 1394/USB Disk labeled Seagate Backup Plus Drive(K:)
Version identifier: 05/27/2018-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {e7999e64-18ef-4ffe-826f-63460ae10a95}
Backup time: 6/3/2018 7:00 PM
Backup target: 1394/USB Disk labeled Seagate Backup Plus Drive(K:)
Version identifier: 06/03/2018-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {ed35b3bb-5409-4351-82b3-42829908d5b2}
Backup time: 6/10/2018 7:00 PM
Backup target: 1394/USB Disk labeled Seagate Backup Plus Drive(K:)
Version identifier: 06/10/2018-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {8dd10f96-c62e-42e9-9d68-0947f529db52}
Backup time: 6/17/2018 7:00 PM
Backup target: 1394/USB Disk labeled Seagate Backup Plus Drive(K:)
Version identifier: 06/17/2018-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {0ebd7188-35b3-4317-bb20-b718dfd35789}
Backup time: 6/24/2018 7:00 PM
Backup target: 1394/USB Disk labeled Seagate Backup Plus Drive(K:)
Version identifier: 06/24/2018-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {93803f25-207b-410d-891f-d1e8244236aa}
Backup time: 7/1/2018 7:00 PM
Backup target: 1394/USB Disk labeled Seagate Backup Plus Drive(K:)
Version identifier: 07/01/2018-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {76022746-9b00-4380-a08b-d9a9b5bdd2d8}
Backup time: 7/8/2018 7:00 PM
Backup target: 1394/USB Disk labeled Seagate Backup Plus Drive(K:)
Version identifier: 07/08/2018-23:00
Can recover: Volume(s), File(s), Application(s), Bare Metal Recovery, System State
Snapshot ID: {030fb852-6e15-4ad3-8acb-e0b0d0057e87}
C:\WINDOWS\system32>When I checked the free space left on the drive on which the backups
were stored from the Windows
File
Explorer, I saw there was only a few megabytes of free disk space left,
so I attempted to delete some of the prior backups with the wbadmin command,
but I was unable to delete them with the message "failed with error: The
specified media type is invalid" message appearing.
[ More Info ]
[/os/windows/win10]
permanent link
Checking port 465 connectivity
I needed to check on whether a system was functioning as a mail server listening
on the Simple Mail
Transfer Protocol Secure (SMTPS) port, TCP port 465. One way to check is
to attempt to establish a telnet connection to that port. E.g.:
$ telnet 192.168.248.91 465
Trying 192.168.248.91...
Connected to esa.example.com
Escape character is '^]'.
^C
^CConnection closed by foreign host.
$
If you see a "connected to" message that indicates the system is listening
on that port and you can terminate the connection by hitting Ctrl-C
a couple of times. But you can also use an
OpenSSL
command as shown below to test SMTPS connectivity on TCP port 465:
$ openssl s_client -connect 192.168.248.91:465 -quiet
depth=0 /OU=Zimbra Collaboration Server/CN=esa.example.com
verify error:num=20:unable to get local issuer certificate
verify return:1
depth=0 /OU=Zimbra Collaboration Server/CN=esa.example.com
verify error:num=27:certificate not trusted
verify return:1
depth=0 /OU=Zimbra Collaboration Server/CN=esa.example.com
verify error:num=21:unable to verify the first certificate
verify return:1
220 esa.example.com ESMTP Postfix
quit
221 2.0.0 Bye
$
If you leave the -quiet off the end of the command, you can
see additional information about the certificate on the email server.
Related articles:
-
Using the openssl command to troubleshoot POP3S
[/network/email]
permanent link
Extracting images from an Excel spreadsheet
I needed to extract two diagrams from a worksheet in a
Microsoft Excel workbook. The diagrams appeared to have been put in the
worksheet as an image through a copy and paste operation. I could right-click
on an image in the sheet and choose "Copy" or "Save as Picture" and for the
latter option I could choose PNG, JPEG, PDF, GIF, or BMP for the "Save as Type"
value, but I wondered what type of file Excel was using for the embedded image.
The file was a .xlsm file, which like a .xlsx file is an
Office
Open XML (OpenXML) file format that can be "unzipped" to reveal the
constituent files within it by renaming the file to have a .zip
filename extension or copying the file to a new file with a .zip extension
- see Zipping and unzipping
Excel xlsx files. So I copied the file giving the new file a .zip extension
and then extracted the contents of that file by unzipping it. I then had a
file named "[Content_Types].xml" and the following directories in the directory
where I had extracted files from the zip file:
_rels
customXml
docProps
xl
[ More Info ]
[/os/windows/office/excel]
permanent link
Obtaining information for online citations of an article with Altmetric
Altmetric, a company
founded by Euan Adie in 2011, provides a website where one can look up
information on references to journal articles published online from other
online sources, such as references to an article from
Wikipedia articles,
tweets,
blogs,
Facebook,
etc., which will provide you with information
on how widely cited the online research may be. To easily access
the information, you need to install the Altmetric
bookmarklet.
[ More Info ]
[/network/web/browser/firefox]
permanent link
Determine Python installed modules/packages
If you need to determine the
packages/modules/
libraries installed for
Python on a system, you can do so by obtaining a Python
command prompt and issuing the help("modules") command.
$ python
Python 2.7.10 (default, Oct 23 2015, 19:19:21)
[GCC 4.2.1 Compatible Apple LLVM 7.0.0 (clang-700.0.59.5)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> help("modules")
Please wait a moment while I gather a list of all available modules...
2018-08-18 15:31:45.666 Python[74959:5231860] Cannot find executable for CFBundle 0x
7fe335602be0 </System/Library/Frameworks/Message.framework> (not loaded)
AVFoundation _TE dircache profile
Accounts _Win dis pstats
AddressBook __builtin__ distutils pty
AppKit __future__ dl pwd
AppleScriptKit _abcoll doctest py2app
AppleScriptObjC _ast dumbdbm py_compile
Audio_mac _bisect dummy_thread pyclbr
Automator _builtinSuites dummy_threading pydoc
BaseHTTPServer _codecs easy_install pydoc_data
Bastion _codecs_cn email pyexpat
CFNetwork _codecs_hk encodings pylab
CFOpenDirectory _codecs_iso2022 ensurepip pyparsing
CGIHTTPServer _codecs_jp errno pytz
Canvas _codecs_kr exceptions quopri
Carbon _codecs_tw fcntl random
Cocoa _collections filecmp re
CodeWarrior _csv fileinput readline
Collaboration _ctypes findertools repr
ColorPicker _ctypes_test fnmatch resource
ConfigParser _curses formatter rexec
Cookie _curses_panel fpformat rfc822
CoreData _elementtree fractions rlcompleter
CoreFoundation _functools ftplib robotparser
CoreGraphics _hashlib functools runpy
CoreLocation _heapq future_builtins sched
CoreText _hotshot gc scipy
Dialog _io genericpath select
DictionaryServices _json gensuitemodule sets
DocXMLRPCServer _locale gestalt setuptools
EasyDialogs _lsprof getopt sgmllib
EventKit _markerlib getpass sha
ExceptionHandling _multibytecodec gettext shelve
Explorer _multiprocessing glob shlex
FSEvents _osx_support grp shutil
FileDialog _pyio gzip signal
Finder _random hashlib site
FixTk _scproxy heapq six
Foundation _socket hmac smtpd
FrameWork _sqlite3 hotshot smtplib
HTMLParser _sre htmlentitydefs sndhdr
IN _ssl htmllib socket
InputMethodKit _strptime httplib sqlite3
InstallerPlugins _struct ic sre
InstantMessage _symtable icglue sre_compile
JavaScriptCore _sysconfigdata icopen sre_constants
LatentSemanticMapping _testcapi idlelib sre_parse
LaunchServices _threading_local ihooks ssl
MacOS _tkinter imageop stat
Message _warnings imaplib statvfs
MimeWriter _weakref imghdr string
MiniAEFrame _weakrefset imp stringold
Nav abc importlib stringprep
Netscape aepack imputil strop
OSATerminology aetools inspect struct
OpenDirectory aetypes io subprocess
OpenSSL aifc itertools sunau
PixMapWrapper altgraph json sunaudio
PreferencePanes antigravity keyword symbol
PubSub anydbm lib2to3 symtable
PyObjCTools applesingle linecache sys
PyPDF2 appletrawmain locale sysconfig
QTKit appletrunner logging syslog
Quartz argparse macerrors tabnanny
Queue argvemulator macholib tarfile
ScreenSaver array macostools telnetlib
ScriptingBridge ast macpath tempfile
ScrolledText asynchat macresource terminalcommand
SearchKit asyncore macurl2path termios
ServiceManagement atexit mailbox test
SimpleDialog audiodev mailcap textwrap
SimpleHTTPServer audioop markupbase this
SimpleXMLRPCServer autoGIL marshal thread
Social base64 math threading
SocketServer bdb matplotlib time
StdSuites bdist_mpkg md5 timeit
StringIO bgenlocations mhlib tkColorChooser
SyncServices binascii mimetools tkCommonDialog
SystemConfiguration binhex mimetypes tkFileDialog
SystemEvents bisect mimify tkFont
Tix bonjour mmap tkMessageBox
Tkconstants bsddb modulefinder tkSimpleDialog
Tkdnd bsddb185 modulegraph toaiff
Tkinter buildtools multifile token
UserDict bundlebuilder multiprocessing tokenize
UserList bz2 mutex trace
UserString cPickle netrc traceback
WebKit cProfile new ttk
_AE cStringIO nis tty
_AH calendar nntplib turtle
_App cfmfile ntpath types
_CF cgi nturl2path unicodedata
_CG cgitb numbers unittest
_CarbonEvt chunk numpy urllib
_Cm cmath objc urllib2
_Ctl cmd olefile urlparse
_Dlg code opcode user
_Drag codecs operator uu
_Evt codeop optparse uuid
_File collections os videoreader
_Fm colorsys os2emxpath warnings
_Folder commands parser wave
_Help compileall pdb weakref
_IBCarbon compiler pickle webbrowser
_Icn contextlib pickletools whichdb
_LWPCookieJar cookielib pimp wsgiref
_Launch copy pip xattr
_List copy_reg pipes xdrlib
_Menu crypt pkg_resources xlrd
_Mlte csv pkgutil xml
_MozillaCookieJar ctypes platform xmllib
_OSA curses plistlib xmlrpclib
_Qd datetime popen2 xxsubtype
_Qdoffs dateutil poplib zipfile
_Qt dbhash posix zipimport
_Res dbm posixfile zlib
_Scrap decimal posixpath zope
_Snd difflib pprint
Enter any module name to get more help. Or, type "modules spam" to search
for modules whose descriptions contain the word "spam".
>>> exit()
$[ More Info ]
[/languages/python]
permanent link
Recovering a file on a Windows system from a shadow copy
After editing a
spreadsheet in
Microsoft Excel on a
Microsoft Windows Server 2012 system, I intended to save the modified
version under a new file name, but inadvertently chose "Save" rather than
"Save As." Fortunately, Windows systems running the Volume Snapshot Service,
aka
Shadow
Copy, provide an easy mechanism to recover lost data by reverting to a prior
"shadow copy" version of a file. To revert to the prior version, you can
take the following steps:
-
In the
Windows File Explorer, click on the file to select it, then choose
"Properties" from the ribbon of options at the top of the File Explorer
window or right-click on the file and choose "Properties." Or, you can click
on the file to select it and then hit the Alt and Enter
keys simultaneously to bring up the Properties window for that file.
-
Then click on the Previous Versions tab.
-
Click on the prior version of the file to select it and then click on the
Restore button at the bottom of the window.
-
You will see a window asking "Are you sure you want to restore the previous
version of" followed by the file name and the
timestamp
on the prior version of the file. The window also warns you that "This will
replace the current version of this file on your computer and cannot be
undone." Click on the Restore button on that window.
-
You should then see a window stating "The file has been successfully restored
to the previous version." Click on the OK button to close that window.
If you click on the General tab at this point, the Modified date
will still reflect the timestamp before you restored the file, but if you
close the Properties window and reopen it, you should then see
the Modified date and time reflect the timestamp of the prior version that
was restored to the system.
[ More Info ]
[/os/windows/filesystem]
permanent link
Viewing and Editing Defined Names in Excel 2013
To view or edit the
defined names in the
Microsoft Excel 2013 spreadsheet program, you can take the following steps:
-
Click on the Forumulas tab at the top of the
Excel
window.
-
From the Formulas menu, select Name Manager.
In the Name Manager window, you can see the defined names.
[ More Info ]
[/os/windows/office/excel]
permanent link
