Read-only user in postgres

  1. Connect as admin
  2. create user:
    CREATE USER 'uuu' PASSWORD 'ppp'
  3. switch to necessary db (if not already):
    \connect ddd
  4. add rights:
    GRANT CONNECT ON DATABASE ddd TO uuu;
    GRANT USAGE ON SCHEMA public TO uuu;
    GRANT SELECT ON ALL TABLES IN SCHEMA public TO uuu;

This only affects tables that have already been created. More powerfully, you can automatically have default roles assigned to new objects in future:

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO uuu;

Fix Rapid Accelerator and Build

After MacOS upgrade Matlab has outdated links to MacOS SDK and therefore running models in ‘Rapid Accelerator’ mode causes errors. In order to fix ‘Rapid Accelerator’ mode version of MacOS must be updated (for example, from 10.8 to 10.10) in:
/Applications/MATLAB_R2014a.app/rtw/c/tools/unixtools.mk
/Applications/MATLAB_R2014a.app/bin/mexopts.sh
/Applications/MATLAB_R2014a.app/bin/maci64/mexopts/clang_maci64.xml
/Applications/MATLAB_R2014a.app/bin/maci64/mexopts/clang++_maci64.xml

Convert character set of MySQL database

In the command line shell, just fill in “dbname”, “user”, “pass” 😀

DB="dbname"
USER="user"
PASS="pass"
(
echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_general_ci;'
mysql -u "$USER" -p"$PASS" "$DB" -e "SHOW TABLES" --batch --skip-column-names \
| xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;'
) \
| mysql -u "$USER" -p"$PASS" "$DB"

Add BootCamp on external HDD

1. Add a new virtual hard disk from within the Boot Camp VM settings (it should be Add Device… —> New Hard Disk) of IDE type (the size doesn’t matter, and probably it shouldn’t be of the split type), and save it – with a NameOfVMDK.vmdk name of your choice – inside your Boot Camp VM bundle (it should be the default position in the save dialog); close the VM settings and quit Fusion.
2. In the Terminal, type this command:
$ /Applications/VMware\ Fusion.app/Contents/Library/vmware-rawdiskCreator create /dev/diskX fullDevice ./Desktop/NameOfVMDK ide
… which will create the new .vmdk file on your Desktop.
3. Copy the newly created .vmdk into your Boot Camp VM bundle, thus overwriting the existing one (which was created from within the VM settings).
4. Open Fusion and the VM settings again and verify that the new IDE virtual disk now has the size of your real added hard disk.

Move Gnome window buttons

If you are used to left-side Close, Minimize, Maximize buttons, then can be moved by editing dconf.

  • If you are using Metacity (Gnome3 fallback), settings are located in:
    org.gnome.desktop.wm.preferences.button-layout
  • If you are using Gnome3, settings are located in
    org.gnome.shell.overrides

Contents of the given key must be:
close,minimize,maximize:

Fix print 4x scaling

My Linux printer was scaling down 4x times each printout, except ones from “document viewer”. Turned out that default option “Pages per sheet” in CUPS was reset to 4.

In order to set default value of “Pages per sheet” in CUPS to 1:
1)Stop cups: /etc/init.d/cups stop
2)edit file /etc/cups/printers.conf and set
Option number-up 1
3)Start cups: /etc/init.d/cups start