Why I love PhpStorm: SQL GROUP BY handling

2 Replies

Here’s another post from my series why I love JetBrains PhpStorm. This is a SQL query, where I have I list of column names. The IDE not only marks the columns missing in the GROUP BY clause as errors, it also offers an option to fix it for you by adding them to the GROUP BY clause.

PhpStorm understands SQL mixed with PHP code.

More PhpStorm love:
SQL table aliases
JavaScript code completion with dojo

Share VPN connection of Windows host with VirtualBox guest

1 Reply

Sharing the VPN connection of your host in VirtualBox works fine with NAT, but not with host only mode. The solution I found on morales-rodriguez.net is simple. Open an admin console on your windows7 host and execute the following:

$ VBoxManage list vms

Note that uuid or name in parenthesis of your VM and then:

$ VBoxManage modifyvm <uuid or name here> --natdnshostresolver1 on

How to automount your virtualbox shared folder to /var/www

Reply

After adding the shared folder Websites to fstab by adding the line

Websites /var/www vboxsf rw,uid=33,gid=33 0 0

and giving the right permissions, I always got the following error during my virtual Linux Mint boot:

keys:Press S to skip mounting or M for manual recovery

All I had to do was add vboxsf on a line of its own in /etc/modules.
Solution found on askubuntu.com

Linux Mint 17: Install php_oci

Reply

Quick cooking recipe to install PHP oci8 on Linux Mint 17 / 18.

  1. Download the Instant Client from the Oracle Website and follow the instructions at the bottom of the download page.
  2. Download the Instant Client SDK from the same location, unpack it and move the SDK folder to the same folder where the Instant client is installed. On Linux Mint this would be “/opt/oracle/instantclient_xy”
  3. “sudo pecl install oci8” and give path to your instant client when asked
  4. Add “extension=oci8.so” to your php.ini located at “/etc/php5/apache2/php.ini”
  5. restart apache “sudo apache2 -k restart”

Note: You can use phpinfo() to locate the used php.ini

Linux beginners trick: mount root shell to read-write

Reply

If your Linux (Mint) fails to boot because you broke the /etc/fstab, for example, you’ll end up with a ready only root shell. The trick is to mount the root partition to as read-write without actually unmounting it:

# mount -o remount,rw /

After doing that, you wil be able to edit /etc/fstab, correct the error, and reboot normally.

Found on: How to fix Linux boot problems

Setup Lightning to work with Google Calendar

Reply

Quick installation guide to setup your Google Calendar in Thunderbird 31.2 with the Lightning Calendar Addon 3.3.1. You don’t even need to install the ‘Provider for Google Calendar’:

  1. Create a new calendar by right clicking on the calendar pane, then select ‘On the Network’
  2. Select ‘CalDav’ as you remote calendar format and put the following url as the location: https://www.google.com/calendar/dav/calId/events and replace calId with your calendar id. You can find it in your calender settings after logon to calendar.google.com. It’s usually your email address.

Note: use /events and not /user in the url, otherwise it won’t work