Questions[debconf](ubuntu)

It seems to be a lot of trouble to get MySQL running with lower_case_table_names=1 as can be seen in:

• lower_case_table_names=1 on Ubuntu 18.04 doesn't let mysql to start
• lower_case_table_names Settings in MySQL 8.0.12
• Set up mysql 8 with lower_case_table_names on CentOS 7
• Mysql : can't set lower_case_table_names variable
• lower_case_table_names option not working

I'm trying to install MySQL 8.0.19 on Ubuntu Server 20.04 LTS. lower_case_table_names=1 cannot be set after mysql has already been initialized, which happens automatically when installing from the package repositories.

According to the documentation Server System Variables | sysvar_lower_case_table_names:

For APT installations on Debian and Ubuntu, however, the server is initialized for you, and there is no opportunity to configure the setting in an option file beforehand. You must therefore use the debconf-set-selection utility prior to installing MySQL using APT to enable lower_case_table_names. To do so, run this command before installing MySQL using APT:

sudo debconf-set-selections <<< "mysql-server mysql-server/lowercase-table-names select Enabled"

I did that on a freshly installed Ubuntu Server 20.04 and ran sudo apt-get install mysql-server afterwards, but it did not change lower_case_table_names to 1.

If at all, what am I doing wrong? How can I successfully install MySQL 8.0 with lower_case_table_names set to 1?

I am installing steamcmd via a headless system and don't want to manually accept the license. Is that possible through debconf?

I tried this, but it detected that I did NOT accept the license:

DEBIAN_FRONTEND=noninteractive apt-get -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" install -qq -y steamcmd

I'm raising this here as I'm not sure if this is a bug or if I'm just going crazy. But when I'm installing a new Ubuntu Desktop I like to use chunks of copy&paste-able lines to get useful stuff installed really quick... e.g...

echo ttf-mscorefonts-installer msttcorefonts/accepted-mscorefonts-eula boolean true | sudo debconf-set-selections
sudo apt-get -y install ttf-mscorefonts-installer

Which works fine.

But when it comes to libdvd-pkg, I just can't get it to shut up (I don't want to use 'DEBIAN_FRONTEND=noninteractive'). Here is what I've tried...

echo libdvd-pkg libdvd-pkg/first-install note | sudo debconf-set-selections
echo libdvd-pkg libdvd-pkg/post-invoke_hook-install boolean true | sudo debconf-set-selections
sudo apt-get -y install libdvd-pkg

You always get this screen...

I've seen this happen on 12+ machines now, so it's not just a one off.

This is on Ubuntu 16.04 by the way.

Any ideas what I might be doing wrong to try and silence this?

I've inspected the DEBIAN/templates file within the .deb package and can't find anything unusual.

I'm trying to install the flashybrid but when I enter the apt-get install flashybrid command, I get this error:

root@user-desktop:/home/user# apt-get install flashybrid
Reading package lists... Done
Building dependency tree
Reading state information... Done
flashybrid is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
Setting up flashybrid (0.15+nmu2) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing flashybrid (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
flashybrid
E: Sub-process /usr/bin/dpkg returned an error code (1)

I also tried this one to find what is already using that file:

root@user-desktop:/home/user# lsof | grep /var/cache/debconf/config.dat
lsof: WARNING: can't stat() fuse.gvfs-fuse-daemon file system /home/user/.gvfs
Output information may be incomplete.
dpkg-prec 4672 root 4rW REG 8,6 39658 1697827 /var/cache/debconf/config.dat

But I don't know how to fix this.

I'd like to install libpam-ldap to use ldap on a client machine and I was hoping to use

sudo apt-get install -qq libpam-ldap

to quietly install the package as part of a bash script used to configure a client once Ubuntu installs. However it still comes up with a blue screen GUI asking for configuration information. Since I intend to just copy an existing /etc/ldap.conf file to overwrite the auto generated one I'd like to skip that step but don't know how.

How do you install a package and make it skip its interactive configuration stage?