Archive for August, 2017
Getting Debian 9 “Stretch” using a password for the mysql root user
0As it turns out Debian 9 is using “unix_socket” and not a password for the mysql/maria root user.
Here’s a explanation and solution:
https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost
It boils down to, in my case, these commands:
stas@HAL9000:~$ mysql -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' stas@HAL9000:~$ sudo mysql -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.1.23-MariaDB-9+deb9u1 Debian 9.0 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [mysql]> SELECT User, Host, plugin FROM mysql.user; +------+-----------+-------------+ | User | Host | plugin | +------+-----------+-------------+ | root | localhost | unix_socket | +------+-----------+-------------+ 1 row in set (0.00 sec) MariaDB [mysql]> UPDATE user SET plugin='mysql_native_password' WHERE User='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [mysql]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> SELECT User, Host, plugin FROM mysql.user;+------+-----------+-----------------------+ | User | Host | plugin | +------+-----------+-----------------------+ | root | localhost | mysql_native_password | +------+-----------+-----------------------+ 1 row in set (0.00 sec) MariaDB [mysql]> exit Bye stas@HAL9000:~$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 4 Server version: 10.1.23-MariaDB-9+deb9u1 Debian 9.0 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
Sound volume issues when using kivy on Debian with gnome and pulse audio fixed
0When using kivy on a Debian system running pulse audio (gnome) you would encounter issues with the sound volume due to the fact that kivy would set the volume to 100% each time it uses the soundcard.
The problem is in pulse audio, what’s new 🙁 as it’s the from the same author who brings us systemd.
You can remove pulse audio as much of gnome depends on it.
You can however disable pulse and use good old alsa.
Disable pulse in /etc/pulse/client.conf uncomment the line “autospawn = yes” and set it to “autospawn = no”
Install gnome alsa mixer, sudo apt-get install gnome-alsamixer
Restart alsa, sudo alsa force-reload
Or use alsamixer (console) to control the volumes.
Tried to use key shortcuts in gnome but that doesn’t work correctly.
Just use trusted xbindkeysrc always works 🙂
install xbindkeys, sudo apt-get install xbindkeys
Use this .xbindkeysrc file and your done (after logout and login)
#Alsa Volume Down "amixer set Master 3- unmute" XF86AudioLowerVolume #Alsa Volume Up "amixer set Master 3%+ unmute" XF86AudioRaiseVolume #Alsa mute/unmute toggel "amixer sset Master toggle" XF86AudioMute
Backup and restore the packages on a debian system
0This is only a way to backup and restore installed packages on your system.
I use this when I change from workstation to have my trusted set of packages installed 😉
You might need to install dselect as it’s no longer part of a standard Debian install:
apt-get install dselect
And then:
dpkg --get-selections > selections
Install the new Debian system, copy the selections file and then:
avail=`mktemp`
apt-cache dumpavail > "$avail"
dpkg --merge-avail "$avail"
rm -f "$avail"
dpkg --set-selections < selections
apt-get dselect-upgrade
Recent Comments