• Shell script to get all WordPress databases and URL’s

    Below you will find a simple script that you can use to find all the databases and URL’s associated to wordpress sites in a shared database. This script requires a SQL user with the ability to ‘show databases’ and access to the DB’s you want to query.

    The script grabs a list of all the databases on the server then loops through them all retrieving the URL from the wp_options table. The script also takes into consideration the fact the the table might not actually be wp_options (could contain some random characters) so we use a wildcard there.

    Read the rest of this entry »

  • WinSCP program for Mac

    WinSCP is a great program for Windows that will give you a GUI interface to manage files on a remote server when all you can use to connect is SSH. Having grown fond of this program a colleague was sad to find there was no version for MAC. After playing with several different options, they ended up settling on using the FireFTP extension for Firefox and connecting via SFTP to the remote server. To setup FireFTP to use SFTP on the MAC you need to do a few things first.
    Read the rest of this entry »

  • Installing Mongrel with Ruby 1.9

    Installing mongrel on ruby 1.9 has caused problems for many different people as has been reported on isitruby19.com.

    Running gem install mongrel produces the following error.

    http11.c: In function ‘http_field’:
    http11.c:77: error: ‘struct RString’ has no member named ‘ptr’
    http11.c:77: error: ‘struct RString’ has no member named ‘len’
    http11.c:77: warning: left-hand operand of comma expression has no effect
    http11.c: In function ‘header_done’:
    http11.c:172: error: ‘struct RString’ has no member named ‘ptr’
    http11.c:174: error: ‘struct RString’ has no member named ‘ptr’
    http11.c:176: error: ‘struct RString’ has no member named ‘ptr’
    http11.c:177: error: ‘struct RString’ has no member named ‘len’
    http11.c: In function ‘HttpParser_execute’:
    http11.c:298: error: ‘struct RString’ has no member named ‘ptr’
    http11.c:299: error: ‘struct RString’ has no member named ‘len’
    make: *** [http11.o] Error 1

    To install mongrel after receiving this error, just follow these steps: Read the rest of this entry »

  • How to control Windows with Apple Remote Desktop

    If you do not want to use the Microsoft Remote Desktop application as detailed here. You can do the following to allow you to control Windows via Apple’s Remote Desktop application.

    Install RealVNC Server (www.realvnc.com or www.tightvnc.com) on your Windows PC.

    Once installed it will appear in the tray area of the taskbar or in your program files, select options and set a password, and adjust any necessary settings.

    Now on Apple Remote Desktop you can connect to the Windows PC via the IP address. You will have remote control and view capabilities but no other Apple Remote Desktop features such as remote install.

  • VMware Fusion cannot connect to the virtual machine

    After having a MacBook pro crash and subsequently get repaired with a new logic board, we found that the virtual machines on the computer would not start at all. This problem started happening just before the computer fatally crashed before needing repair, but persisted after the logic board was replaced. The exact error VMware Fusion 2 gave us was, “Make sure you have rights to run the program and to access all directories it uses and rights to access all directories for temporary files”. Many solutions to this problem involve removing and reinstalling VMware Fusion.

    After uninstalling, deleting the remaining files and rebooting then reinstalling the latest version a few times (even as different users) we found that we had the exact same problem. We even tried reinstalling again using an older version of Fusion (version 1). We ran the verify and repair on both the disk and permissions with no success either.

    Read the rest of this entry »