In the series, ‘spare me the lecture, just tell me how it works’, here is a bunch of quick reminders about your ip configuration on your Ubuntu linux box. ifoncig.me is a handy website that will show you all kinds of information in your web browser, such as your public facing ip, hostname and other […]
Month: January 2020
HYPER-V Compacting of ext4 disks
There are some claims around that quick wins may be made on ext4 disks by using fstrim to release unused blocks, by running #sudo fstrim , however, in practice this will give you fairly limited gains, or none at all. I believe the actual effect of trim is largely misunderstood, as it’s function is _not_ […]
Ubuntu: stop automatically adding printers on the network
Having your printers on the netwrok automatically added can be handed on a small network, but it can become a major drag on networks with a large number of printers. The service repsonsible is named cups-browsed. Here is how you can disable this service, thereby no longer adding your printers. Printing services for manually installed […]
Creating your first let’s encrypt certifcate on Linux
I still see system administrators hold off on SSL because they are scared for the process of creating certificate requests, getting the certificates and then integrating them into apache. This writeup will show how to install an SSL certificate using CERTBOT, a handy tool provided by let’s encrypt that takes all the manual work out […]
Using KVM and virt-manager to setup a hypervisor
first off, for Ubuntu server you will need to enable additional repositories, by running sudo apt-add-repository universe Next, install the hypoervisor, and the management tool sudo apt install qemu qemu-kvm libvirt-bin You can verify the readyness of the hypervisor with the command kvm-ok, which will output something like this INFO: /dev/kvm exists KVM acceleration can […]
Adding apache and php to your bare server configuration
The basic Ubunu server install does not have apache and php installed by default, so you will need to add them to the system. sudo apt install apache2 php php-mysql Verify that your webserver and php are working, by visiting you public ip address. This should display the default apache welcome page. Next, navigate to […]
Adding a named site (virtual hosting) to apache
Each website you configure on your apache server gets it’s own small configuration file, which is a major improvement over the old days where one massive file configured all websites on the server. Navigate to the directory /etc/apache2/sites-available and create a new configuration file for your website. You are free to pick a name for […]
Supressing a field based on value on a report
Rightclick the field and choose ‘Format’ Go to the tab ‘Common’ Tick ‘Supress’ and click on the formula editor Enter the formula as shown below if {yourtablename.yourfieldname} =0 then true else false
Setting the zoom level of a crystal report from code
You can set various default zoom levels for your reportviewer, to control how the report is displayed. Create a form with a crystalreportviewer on it, and set the zoom level to the required value. A zoom level of 1 fits the report to ‘page width’ A zoom level of 2 fits the report to show […]
Supressing a group footer based on the number of records in the section
At times you may want to supress a totaling section on your report based on the number of records in the section. In this example, a total for a group is displayed only if there is more then one record in the section. To accomplish this, we need to supress the group footer if there […]