MariaDB

Ubuntu 18.04 MariaDB 10.2 Too many open files

On my computer running Ubuntu 18.04, MriaDB stopped working. PHP application i run on my computer failed with error

Application can’t find the table. So i tried to login to MySQL and see if table is there or not. But i get error

Next i checked if this is due to any MySQL upgrade. I found MySQL got updated today

To fix this error, run

This wil open a text editor. Add following

Save and quit the editor. Restart MaraDB with

MySQL will work properly now. systemctl edit mysql will create file /etc/systemd/system/mysql.service.d/override.conf

Disable Native Notification on Google Chrome Ubuntu

On Ubuntu, Google chrome had a disable native notification option. On Chrome 78, this option is removed. But you still can manually enable it.

To enbale chrome notification, edit file

Find

Replace with

Save and exit the file. Now restart google chrome.

Related Posts

Google Chrome

Linux KVM Bridge network on Ubuntu

On Ubuntu 18.04 server, first i get Ubuntu to use /etc/network/interface, by default Ubuntu 18.04 and newer use netplan.

First install ifdown

Now you can configure your network interface by editing file

Here is my network configuration on an OVH server.

To convert this interface to bridge network, do the following

1) Replace all occurance of “eno3” with “br0”

2) Add following lines

In above, replace “eno3” with name of your physical interface.

Here is my final network configuration.

See Linux KVM, Networking @ linux-kvm.org

xfce-vnc

Install Xfce VNC remote desktop on Ubuntu

XFCE is a light weight desktop for Linux. XFCE + vnc allow you to setup remote desktop on a VPS or dedicated server located on a data center or cloud. You can connect to remote desktop using VNC client and work like it is local computer.

To instal XFCE run

Next install vncserver

It is bad idea to use root user for logging into desktop. Create a normal user to run desktop.

It will be good to make this user an admin, so user can install software or update system.

Now login as the user

Create a vnc password for this user.

Create vnc startup file

Add

Make it executable

Now exit the user with “exit” command. You should be user “root” now.

Create service file

To auto start vncserver on boot, you need to create a service file.

Add

Enable the service with

You can start/stop vncserver with

Now reboot the server. You should be able to connect to VNC server using SERVER_IP:1

Install HandBrake on Ubuntu 18.04

HandBreak is an OpenSource Video transcoder available from https://handbrake.fr. It can convert video to various format.

Latest version of Handbreak available in Ubuntu PPA. To install, enable Handbreak PPA

Install handbreak with

kvm-os-image

Install Linux KVM on Ubuntu

Linux KVM is virtualisation software that allow you to create virtual machine under linux. To install on Ubuntu, run

Install libvirtd, this allow you to easily create KVM virtual machines and allow remote connection from virt-manager GUI application.

Enable and start libvirt

At this stage, you should be able to connect to KVM server form your computer using virt-manager.

You need to create a bridge network interface (“br0”), for this, follow instructions at Linux KVM Bridge network on Ubuntu.

Downloading ISO

Before you can setup any VM, you need to download ISO image for the OS. Here i downloaded ISO image for Ubuntu 19.04

Once downloaded, you should be able to select this ISO image in virt-manager when creating a VM.

See Linux KVM

ubuntu-software-updates

Install drivers on Ubuntu

To install drivers on Ubuntu using command line, run

This list all drivers available for your hardware. You can install a driver with apt. In this cuase, i have 2 drivers available

First driver is recommended by Ubuntu. To install, run

Install Driver using Software & Updates

Start software and updates application.

Click on Additional Drivers tab. You will see available drivers for your computer.