You are here

Ivan Radovanovic's blog

Ivan Radovanovic's picture

Where GNOME 2 stores mouse configuration

In directory ~/.gconf/desktop/gnome/peripherals/mouse

Ivan Radovanovic's picture

How to make Compiz play nice with Nvidia

After you update your OS and you forgot about this little quirk

edit /usr/local/bin/compiz-manager and change line saying
INDIRECT="no"

to
INDIRECT="yes"

UPDATE (2014-11-15):
Apparently this also depends on nvidia driver, so I am trying to keep the list of those I know work correctly, and those I know don't work correctly.

Working: 331.67, 331.113
Not working: 340.46, 343.22 (works most of the time, but sometimes get crazy), 346.22 similar to 343.22

Ivan Radovanovic's picture

How to create proxy using ssh

You can create SOCKS proxy using ssh by running

ssh -D port [email protected]

replace port with port number you want proxy to appear on your local machine, in web browser choose SOCKS for proxy type, localhost for proxy server and same port as port in command above.

Ivan Radovanovic's picture

How to create user and grant privileges on MySQL

Like this
grant all privileges on db.* to 'user'@'host' identified by 'password';

Ivan Radovanovic's picture

How to flush DNS cache on windows

Execute ipconfig /flushdns on command prompt

Ivan Radovanovic's picture

Zimbra stupidities

Probably impossible to list all, but here are really harmful if you are moving it to other server:

Ivan Radovanovic's picture

Keeping FreeBSD ports secure and up to date

  1. Install /usr/ports/ports-mgmt/portaudit in order to receive vulnerability reports with daily security reports
  2. Install /usr/ports/ports-mgmt/portupgrade in order to be able to update ports in easier way
  3. When you need to upgrade ports
    • portsnap fetch
    • portsnap update (or portsnap extract if using portsnap for the first time)
Ivan Radovanovic's picture

Enable ssl on apache2

a2enmod ssl

Ivan Radovanovic's picture

Extracting private key and certificate from pfx file

To extract private key:

  • openssl pkcs12 -in file.pfx -nocerts -out pk.pem
  • openssl rsa -in pk.pem -out key.pem

To extract certificate:

  • openssl pkcs12 -in file.pfx -clcerts -nokeys -out cert.pem
Ivan Radovanovic's picture

Making SQL Server express listen for tcp connections

Start Configuration Manager (separate program with that name), go to "SQL server network configuration", choose "Protocols" bellow that - right click TCP/IP and click enable if not enabled already. Right click it again - choose properties this time, choose no for "listen all" unless you are exposing service to other machines, then on next tab choose "Enabled" for addresses you want to listen on (::1 and 127.0.0.1 make sense). Make sure you delete "TCP dynamic ports" and set 1433 for "TCP port" value. Also make sure that your web.config files contain 127.0.0.1 for server address.

Pages

Subscribe to RSS - Ivan Radovanovic's blog