MS Word has an ‘ignore this error’ thing in the grammar checker that I use fairly regularly — technical writing has syntax that reads as wrong, grammatical errors for impact, or informal writing where I don’t much care for some rules of grammar … I don’t want to turn off the grammar checker, but I do want to stop seeing a squiggly line under a specific sentence that I don’t want to change. Turns out Pylint has something similar:
Upgraded pip today, and I pretty quickly regretted it. SSL Error attempting to install anything from the Internet (and, amazingly, some things where I downloaded the wheel file). The answer is to downgrade PIP until you hit a version that doesn’t have the error. Annoying. Not sure what the latest rev I could have used was — going back one level and getting the error in loop was more time than I could devote to the project, so I just jumped back six months. Had success with 20.0.2 and left working alone.
Everything from 20.3.1 through 21.0.1 has this failure:
D:\tmp\5\pip>pip install basic_sftp
WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘SSLError(SSLError(1, ‘[SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:1076)’))’: /simple/basic-sftp/
WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘SSLError(SSLError(1, ‘[SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:1076)’))’: /simple/basic-sftp/
WARNING: You are using pip version 20.3.1; however, version 21.0.1 is available.
You should consider upgrading via the ‘c:\programs\anaconda3\python.exe -m pip install –upgrade pip’ command.
Evidently you cannot just scp files from an old Solaris box when you’re on a RHEL/CentOS system … there’s an incompatibility between them that requires you to (1) install scp1 on the Solaris server {not likely in a prod environment} or (2) use sftp to transfer the files.
Server1: Red Hat Enterprise Linux Server release 7.6 (Maipo)
Server2: Solaris 5.9
lisa@server1:~/$ scp lisa@server2:/data/stuff/file1.txt ./input/
lisa@server2’s password:
scp: warning: Executing scp1.
scp: FATAL: Executing ssh1 in compatibility mode failed (Check that scp1 is in your PATH).
Since it’s the third time I’ve had to do this so far this year, I’m going to write down how I disable IPv6 in Fedora. Add these lines to /etc/sysctl.conf
[lisa@server~]# grep ipv6 /etc/sysctl.conf net.ipv6.conf.all.disable_ipv6=1 net.ipv6.conf.default.disable_ipv6=1 net.ipv6.conf.lo.disable_ipv6=1
Then load the sysctl settings (sysctl -p) or reboot.
Without IPv6, if you do X-redirection, you may get an error indicating the redirection was refused. In journalctl, there’s an error “error: Failed to allocate internet-domain X11 display socket”. Evidently you’ve got to configure sshd to use IPv4 by setting “AddressFamily inet” in /etc/ssh/sshd_config
[lisa@server~/]# grep AddressFamily /etc/ssh/sshd_config AddressFamily inet
In the process of troubleshooting UPNP/DLNA on our MythTV server, I learned that you can send logging verbosity settings while the server is running. Using the mythbackend binary with the –setverbose flag, you can specify logging level. For example:
mythbackend --setverbose http:debug,upnp:debug
What items can you set levels on? It’ll conveniently tell you — “all” or “none” override existing settings, everything else will update the current logging levels (i.e. if I’ve already got http and upnp in debug, I can use “–setverbose audio:debug” to add audio to the list of things in debug mode).
[mythuser@server /var/log/mythtv/]# mythbackend -v help Verbose debug levels. Accepts any combination (separated by comma) of: all - ALL available debug output audio - Audio related messages channel - Channel related messages chanscan - Channel Scanning messages commflag - Commercial detection related messages database - Display all SQL commands executed decode - MPEG2Fix Decode messages dsmcc - DSMCC carousel related messages dvbcam - DVB CAM debugging messages eit - EIT related messages file - File and AutoExpire related messages frame - MPEG2Fix frame messages general - General info gpu - GPU OpenGL driver messages gpuaudio - GPU Audio Processing messages gpuvideo - GPU video rendering messages gui - GUI related messages http - HTTP Server messages idle - System idle messages jobqueue - JobQueue related messages libav - Enables libav debugging media - Media Manager debugging messages mheg - MHEG debugging messages most - Most debug (nodatabase,notimestamp,noextra) network - Network protocol related messages none - NO debug output osd - On-Screen Display related messages playback - Playback related messages process - MPEG2Fix processing messages record - Recording related messages refcount - Reference Count messages rplxqueue - MPEG2Fix Replex Queue messages schedule - Scheduling related messages siparser - Siparser related messages socket - socket debugging messages system - External executable related messages timestamp - Conditional data driven messages upnp - UPnP debugging messages vbi - VBI related messages xmltv - xmltv output and related messages
To disable debugging, use “mythbackend –setverbose none”
I have been using LISTAGG to group a bunch of records together to be presented in a single HTML table cell. Problem is LISTAGG doesn’t do anything with null field values. As such, the data doesn’t line up across columns. The three ID values have two string values, which basically get centered in the cell. You cannot tell which ID value goes to which name value.
By adding a concatenation to the LISTAGG value, something will be included in the result set even when the record value is null.
Voila — records line up and I can tell the first ID doesn’t have an associated string value.
I needed to add a few HTML-rendered spaces to a LISTAGG … which meant I needed to figure out a way of getting an ampersand into the glue string. Using the concat (||) feature, I was able to glom ‘&’ and ‘nbsp;’ together as the glue:
We’ve been seeing dropped packets on one of our servers — that usually means more data is coming in than can be processed, but it’s nice to confirm rather than guess. The command “netstat -s” displays summary statistics that are nicely grouped into causes:
TcpExt: 16 invalid SYN cookies received 88 resets received for embryonic SYN_RECV sockets 18 packets pruned from receive queue because of socket buffer overrun 2321 ICMP packets dropped because they were out-of-window 838512 TCP sockets finished time wait in fast timer
The developer console will show client-side errors. You can also use it to interact with data on a web page (like the approaches I’ve published to exporting data from Teams). To display the developer console, use Ctrl+Shift+i
When you first display the console, you may want to clear the existing output – it’s difficult to correlate the errors to discrete actions you’ve taken on the website. Once the console is clear, perform the action again and watch for errors as you perform each individual operation.
Clearing console output on Firefox:
Clearing console output on Chrome:
For both Firefox and Chrome, you can hold CTRL while pressing F5 and bypass cache when reloading a web page. This is particularly useful when the JavaScript for a page has been updated — rather than clearing your entire cache, you can hard refresh the page to get the updated JS file.