about archives contact posts tags

my hackergotchi

Since you're already here and don't want to pass by, welcome to my webpage!

One may wonder what Pimentola is. Well, according to Kalevala, it is a very cold location somewhere in the far North. The word means something like a "region of darkness". That's why it is dark over there. You can check an article on Pohjola to learn a bit more.

Hope you're not afraid of cold and darkness.

RSS Atom
0041: Debian log, 2020-09

Here is my monthly log covering what I have been doing for Debian in September 2020.

Debian website

Added new files

Translated new pages into Russian

Debian packages

Uploaded packages

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 204 spam reports.

Posted Fri Oct 2 22:51:49 2020 Tags:
0040: Debian log, 2020-08

Here is my monthly log covering what I have been doing for Debian in August 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Debian packages

Uploaded packages

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 78 spam reports.

Posted Tue Sep 1 19:09:54 2020 Tags:
0039: Tor hidden service

Setting up a Tor hidden service is pretty straightforward. In a simple case one needs to follow Tor Project's instructions. Also, it is a good idea to take a look into Riseup's Best Practices.

So, now my website is also available as a Tor hidden service at the following address:

xbetver6rggmt2vdxlcwzjqjrhurklsevvnzzctvrwbzd6knukmw2iid.onion

I've added the following settings to my /etc/tor/torrc:

HiddenServiceDir /var/lib/tor/hidden_service/
HiddenServicePort 80 127.0.0.1:80
HiddenServicePort 443 127.0.0.1:443

Also, I had to switch off Apache's mod_status, to prevent statistics leakage through Tor hidden service. To switch it off one need to run a2dismod status (it is enabled by default in Debian). Anyway I don't need it.

Posted Tue Aug 18 12:01:19 2020 Tags:
0038: Debian log, 2020-07

Here is my monthly log covering what I have been doing for Debian in July 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Synchronized po files

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 100 spam reports.

Posted Sat Aug 1 09:41:52 2020 Tags:
0037: Debian log, 2020-06

Here is my monthly log covering what I have been doing for Debian in June 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 0 spam reports.

Posted Wed Jul 1 09:50:18 2020 Tags:
0036: Debian log, 2020-05

Here is my monthly log covering what I have been doing for Debian in May 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Synchronized po files

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 69 spam reports.

Posted Mon Jun 1 12:41:37 2020 Tags:
0034: Debian log, 2020-04

Here is my monthly log covering what I have been doing for Debian in April 2020.

Debian website

Added new files

Translated new pages into Russian

Debian packages

Uploaded packages

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 0 spam reports.

Posted Sat May 2 00:00:18 2020 Tags:
0034: Debian log, 2020-03

Here is my monthly log covering what I have been doing for Debian in March 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 138 spam reports.

Posted Wed Apr 1 10:17:13 2020 Tags:
0033: Debian log, 2020-02

Here is my monthly log covering what I have been doing for Debian in February 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Localization

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 166 spam reports.

Posted Sun Mar 1 12:26:32 2020 Tags:
0032: UDD to the rescue

In #debian:matrix.org one person just performed stretch->buster upgrade and asked about a way to get a list of newly added packages, that is a list of packages in buster but not in stretch. Another person proposed to run a VM with stretch to get a list of packages in stretch, then run a VM with buster to get a list of packages in buster, then do diff between them. This advise is pretty ingenious, but I doubt that it's good way to do such a simple task. Well, there is UDD, so UDD to the rescue!

There's a public UDD mirror which allows anyone to query UDD using PostgreSQL command-line or GUI clients. So, the mentioned task can be easily solved as follows.

  1. Install your PostgreSQL client of choice, say:

    sudo apt install postgresql-client

  2. Connect to the public mirror with the following command:

    psql -U udd-mirror -h udd-mirror.debian.net -p 5432 udd

  3. Run the following PostgreSQL query:

SELECT package FROM packages WHERE release='buster' AND architecture='amd64'
EXCEPT
SELECT package FROM packages WHERE release='stretch' AND architecture='amd64' ORDER BY package;

This SQL query gives a list of packages in buster but not in stretch for amd64 architecture sorted by package name.

That's it! Pretty easy, huh? UDD is a wonderful source of data about Debian and I really like it.

More information about UDD:

Debian wikipage on UDD

Index of UDD database

Posted Sun Feb 9 14:39:34 2020 Tags:

This page is powerly powered by powerful ikiwiki.