Friday, March 25, 2011

#2002 Cannot log in to the MySQL server

If you're getting "#2002 Cannot log in to the MySQL server" when logging in to phpmyadmin on mac os, try editing phpmyadmin/config.inc.php and change:
$cfg['Servers'][$i]['host'] = 'localhost';
to:
$cfg['Servers'][$i]['host'] = '127.0.0.1';

Did the trick for me (after spending 2 hours on it).

Monday, March 14, 2011

Oracle with Ruby 1.9.2 / rvm

Thanks mikecomstock for pointing me to this ruby oracle tut

I’m running rvm so a couple things to note

remove sudo before building the ruby-oci8 gem
$ sudo env LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2 /usr/bin/gem install ruby-oci8

just run
$ env LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2 /usr/bin/gem install ruby-oci8

with rvm, you’ll need to specify your env before executing the sql.rb script from the tutorial
$ env LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2 ruby sql.rb

Useful link: http://www.pixellatedvisions.com/2009/03/25/rails-on-oracle-part-1-installing-the-oracle-instant-client-on-mac-os-x

Saturday, March 12, 2011

Mac OSX Start/Stop SSH

Start:
$sudo launchctl load -w /System/Library/LaunchDaemons/ssh.plist
Stop:
$sudo launchctl unload  /System/Library/LaunchDaemons/ssh.plist

Thursday, March 10, 2011

How to View Hidden Files and Folders in Ubuntu File Browser

ctrl+h
http://www.debianadmin.com/how-to-view-hidden-files-and-folders-in-ubuntu-file-browser.html