Linux stuff
If you use Chrome version 62 under Fedora 26 and realize the blue color becomes purple on your external monitor (laptop screen is fine) then welcome to the club! My first guessing was cable – changed it with the same result, then tried different monitors with different connection methods – VGA, HDMI, USB. No luck.… Continue reading →
By default Subversion shows diff without highlighting which makes a bit difficult review of big changes. But that situation can be changed extremely simple and fast. I assume you use Fedora 17. For the other distributions you need just use different package manager, choose correct package name and find configs in the proper places. First… Continue reading →
In the previous post I wrote about a way to get a Mysql database size from Mysql shell. Now I’d like to share a way to get size of each Mysql table: SELECT table_name,engine ,ROUND(data_length/1024/1024/1024,2) total_size_gb, ROUND(index_length/1024/1024/1024,2) total_index_size_gb, table_rows FROM information_schema.TABLES WHERE table_schema = ‘rt3′; It’s useful if you need to know what you should… Continue reading →
Recently I needed to know the size of our RT3 database. So, I found this SQL to do that from Mysql shell: SELECT table_schema “rt3”, sum( data_length + index_length ) / 1024 / 1024 / 1024 “Data Base Size in GB” FROM information_schema.TABLES GROUP BY table_schema; The result is 360GB! We have to cleanup before… Continue reading →
Recently I spent a few hours to configure VPN connection using Juniper on my Fedora 15 laptop. Actually there is nothing difficult. But I’d like to mention to one nuance. Looks like Juniper doesn’t work with openJDK Firefox plugin. It needs Sun/Oracle only! Otherwise VPN connection will be terminated immediately after start without any errors… Continue reading →
Recently I moved from Fedora 13 to Ubuntu 10.04 on my work laptop. So, I faced again with problem to setup Oracle PHP interface. Oracle provides RPMs only and not DEBs. So, to install the client RPMs should be converted to the DEBs. It can be done easily using utility alien: sudo alien oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm sudo… Continue reading →
There are two ways (at least) to rebuild Ubuntu package from the source. Using Ubuntu diff file and dpkg-buildpackage Download source from Ubuntu repository. Download Ubuntu diff file and apply it: patch -p1 < ubuntu.diff Build package: dpkg-buildpackage -rfakeroot Using .dsc file and debuild Download .dsc file Run following command: dpkg-source -x file.dsc Note, sometimes… Continue reading →
I have two versions of LinuxMCE on my HTPC – stable 0710 and developer 0810. The 0810 was installed after 0710. So, the GRUB bootloader was placed on 0810 partition. A few days ago I decided re-install 0810 from the scratch and I deleted its partition including GRUB booloader. As result I couldn’t boot 0710… Continue reading →