Jaydin's questions

I receive Google's DMARC reports daily as a zip file containing an XML file. I manually download each zip file ~/Documents/DMARC.

I want to aggregate the information from all the saved DMARC reports and produce a human-readable readable report (e.g. table in LibreOffice Calc spreadsheet). I am on Ubuntu 20.04 standard desktop, so I would rather not have memory-hungry or CPU-hungry services running all the time.

Any suggestions on how to do this?

Background Info

Domain-based Message Authentication, Reporting and Conformance (DMARC) is an evolving technical standard and the DMARC report format is specified by that standard. It also looks like Ubuntu will natively support DMARC from 21.04 onwards, but not in 20.04.

The Google link above shows samples of input DMARC XML file format and an output tabular form. As requested, they are pasted here.

Sample input XML file:

<?xml version="1.0" encoding="UTF-8" ?>
<feedback>
  <report_metadata>
    <org_name>solarmora.com</org_name>
    <email>[email protected]</email>
   <extra_contact_info>http://solarmora.com/dmarc/support</extra_contact_info>
    <report_id>9391651994964116463</report_id>
    <date_range>
      <begin>1335571200</begin>
      <end>1335657599</end>
    </date_range>
  </report_metadata>
  <policy_published>
    <domain>bix-business.com</domain>
    <adkim>r</adkim>
    <aspf>r</aspf>
    <p>none</p>
    <sp>none</sp>
    <pct>100</pct>
  </policy_published>
  <record>
    <row>
      <source_ip>203.0.113.209</source_ip>
      <count>2</count>
      <policy_evaluated>
        <disposition>none</disposition>
        <dkim>fail</dkim>
        <spf>pass</spf>
      </policy_evaluated>
    </row>
    <identifiers>
      <header_from>bix-business.com</header_from>
    </identifiers>
    <auth_results>
      <dkim>
        <domain>bix-business.com</domain>
        <result>fail</result>
        <human_result></human_result>
      </dkim>
      <spf>
        <domain>bix-business.com</domain>
        <result>pass</result>
      </spf>
    </auth_results>
  </record>
</feedback>

Sample output table:

I have Anbox (v4-56c25f1) running on my Ubuntu 18.04 PC and I want to sync a folder between the two systems.

It may be possible to use a cloud drive like Google Drive or Dropbox, but I am hoping for a more direct and faster solution given that Anbox is part of the Ubuntu filesystem. Plus Anbox doesn't seem to like multiple Google Drive accounts.

The simplest solution is changing the Anbox folder permissions (eg chown -R [user] /var/snap/anbox/common/data/media) and then syncing the Anbox drive folder directly using rsync. However, uploading a file to Anbox this way resulted in significant data loss as the app in Anbox I was using was unable to update that file (probably due to file permissions) when I tried to save the changes. For this reason, I am looking for a more fool-proof method.

• System: Ubuntu 18.04
• Webcam: Logitech C920 / C922

I use mostly the Microsoft Teams Ubuntu app (v1.4) to join work video calls. I also make Zoom and Meet work video calls on occasion.

The webcam resolution during Microsoft Teams (and also Zoom and Meet) work video calls seems to be something like 16:9, which shows a lot more of my (messy working from home) background than I want.

I would like to set the aspect ratio as 4:3 and zoom in a bit so that my profile is centred on the screen. How can I do this in Ubuntu?

I installed V4L2 Test Bench from Ubuntu software and this allows me to set the aspect ratio for video within that app, but these settings do not apply to the video conferencing apps.

I have the latest version of the Zoom Client app directly downloaded from their website and installed on Ubuntu 18.04. The Zoom app works fine when I have a meeting number and password.

When I only have a link (eg something.zoom.us/w/12345?tk=zxcv), Firefox does not open the Zoom app. But if I use the same link on Google Chrome, it opens the Zoom app correctly.

How do I enable Firefox to open the Zoom app with the correct details?

Ubuntu Software (aka Gnome Software) on Ubuntu 18.04 has started giving the error message: Unable to get a list of updates: remote lvfs has no cache signature

This issue started recently and, based on a bit of online research, it may be related to Linux Vendor Firmware Service (LVFS) and the fwupd application.

Here are the installed fwupd packages:

~$ apt list --installed | grep fwupd
fwupd/bionic-updates,now 1.2.10-1ubuntu2~ubuntu18.04.3 amd64 [installed]
fwupd-signed/bionic-updates,now 1.10~ubuntu18.04.3+1.2.10-1ubuntu2~ubuntu18.04.3 amd64 [installed,automatic]
fwupdate/bionic-updates,now 12-7~ubuntu18.04.3 amd64 [installed]
fwupdate-signed/bionic-updates,now 12-7~ubuntu18.04.3 amd64 [installed]
libfwupd2/bionic-updates,now 1.2.10-1ubuntu2~ubuntu18.04.3 amd64 [installed,automatic]

and

~$ snap list | grep fwupd
fwupd 1.4.2 2084  latest/stable    richard-hughes  classic

How can I install updates to Microsoft Office 2016 installed on Ubuntu 18.04 using PlayOnLinux?

I was able to install Microsoft Office 2016 using PlayOnLinux (POL). However clinking Word->Account->Office Updates does not work in POL. I expect that updates will need to be downloaded and installed manually. It would be good to at least get Microsoft Word and Microsoft Excel gets updated.

My Ubuntu (18.04) drive is synchronised with a Windows drive. Some of my folder and file names in Ubuntu contains characters not allowed in Windows and this causes issues during sync. I want to find these characters and either remove them from the file/folder names or replace these characters by an "x". This needs to be done recursively across the folder/directory tree.

How can I do this quickly?

Here are the characters forbidden in Windows (modified from Christopher Oezbek's answer):

< (less than)
> (greater than)
: (colon - sometimes works, but is actually NTFS Alternate Data Streams)
" (double quote)
\ (backslash)
| (vertical bar or pipe)
? (question mark)
* (asterisk)

I want to play Android games on Ubuntu 18.04. Some games are linked to my Google account so I probably need to run the Play Games and Play Store.

Note that similar questions have been posted here before but those posts are quite old and the main answers no longer seems to apply to 18.04 and current state of tech.

I am running Microsoft Excel 2010 through PlayOnLinux (POL v4.2.10 with Wine v2.22) on Ubuntu 16.04. The Save As PDF function works for most Excel files but sometimes crashes for certain Excel files with the error message: Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience

This always happens with the same Excel files and it happens each time I try to Save As PDF those specific files. I haven't been able to figure out the difference between the Excel files that crash and those that do not crash.

As a work-around, I print to the cups-pdf package as a printer. But this is not ideal because the text in the PDF cannot be selected when the cups-pdf is used.

I have been running Word 2010 through PlayOnLinux (POL v4.2.10 with Wine v2.22) on Ubuntu 16.04 for a while without any problems. I recently started getting the error "This file could not be found" when I try to save the Word document as a PDF.

Any ideas on how to fix this error?

How do I set up Secure DNS (eg over TLS or HTTPS) on 16.04?

I would prefer to use functionality built into 16.04 or apps available on the 16.04 repository. I plan to use either the Google Public DNS (eg 8.8.8.8, 8.8.4.4) or Cloudflare (1.1.1.1, 1.0.0.1) or some combination of the two.

From a web search, the commonly recommended way is to use stubby on 18.04 for DNS over TLS, but stubby does not seem to be available on the 16.04 repository.

Current options for DNS over HTTP seems to be cloudflared by Cloudfare and doh-proxy by Facebook, neither of which seem to be available on the 16.04 repository.

How do I install MS Visio 2010, updates and the Compatibility Pack on PlayOnLinux? There is a script in POL for Visio 2010 initial install, but not for the updates and the Visio Compatibility Pack so it would be good to have end-to-end directions.

Through trial and error, I can get up to installing the Visio Compatibility Pack, which opens files in Microsoft Visio 2010 that were created in the newer Visio drawing file format. I did this by changing the Wine Windows version to Win 7. I could not get the Visio Compatibility Pack to work.

When opening a vsdx file, it fails with the error message:

An error (1502) has occurred during the action Open File. Fine not found.

I am not sure if the issue is with the Visio Compatibility Pack install or with some setting changes I made somewhere earlier during trial and error.

I am on Ubuntu 16.04 and I have installed MS Office 2010 over 2010 POL (v4.2.10 with Wine 2.22). The icons locked to the Unity Launcher are the correct MS Excel and Word icons, and both Excel and Word works fine when I click those icons.

However, both Excel and Word open in the Unity Launcher as the "Wine Windows Program Loader" (ie Wine Glass) icon and is grouped under it and not under Excel and Word icons.

Here's the Excel .desktop file

[Desktop Entry]
Encoding=UTF-8
Name=Microsoft Excel 2010
Comment=PlayOnLinux
Type=Application
Exec=/usr/share/playonlinux/playonlinux --run "Microsoft Excel 2010" %F
Icon=/home/jd/.PlayOnLinux//icones/full_size/Microsoft Excel 2010
Name[fr_FR]=Microsoft Excel 2010
StartupWMClass=EXCEL.EXE
Categories=Office;Spreadsheet;

How can I change this behaviour to enable the Excel instances to be grouped under the Excel icon and the Word instances under the Word icon?

Is there an easy way to keep MS Office updated on PlayOnLinux?

I am running MS Office (2010) on PlayOnLinux (4.2.10) on Ubuntu 16.04. I was able to install the latest service pack (SP2) by manually downloading it and installing by

• POL->Configure->select the correct virtual drive->Miscellaneous->Run a .exe file in this virtual drive->select the SP file.

Now I want to install the Office updates that have been released since the last service pack. As there are dozens/hundreds of Office updates that need to be installed, doing this individually for each is not practical. I tried WSUS Offline but could not get it working in POL.

I cannot figure out how to see and access Wine apps minimised to the windows system tray. Any ideas?

I have a clean install of Ubuntu 16.04 LTS with a windows application running on Wine and installed through PlayOnLinux. That application minimises to the windows system tray. However, once minimised, that application is not shown on the Launcher or in the Unity Application Indicator (I believe that's the correct name for the system-tray that sits on the top right corner). The application is still shown on System Monitor so I know it's still running.