Scanners/Printers on un-supported OS


Got a scanner, printer, all-in-one device that is not supported on your OS, maybe a new printer and you do not want to upgrade your OS. All is not lost!

For scanners try VueScan found at: http://www.hamrick.com/ It replaces the software bundled with your device and is supported on most OS.

For printers try Gutenprint found at: http://gimp-print.sourceforge.net/index.php Its an open-source project so might take some time for new printers to be supported, yet you might be lucky for your situation.

Common Oracle XE and Oracle SQL Developer problems


SQL Developer – Connections tab not visible
1) Do make sure that you have downloaded the version that includes the jre
2) Do make sure that you have the right version, there is a 64-bit version if you have a 64-bit system.
3) Do make sure that SetJavaHome has been properly set to the Java location on your system, the option is found in the SQL Developer configuration file \sqldeveloper\bin\sqldeveloper.conf (http://forums.oracle.com/forums/thread.jspa?threadID=1049872)

Oracle XE Home Page returns Error 404
If you are using NetBeans or Visual Studio and your web pages or Oracle XE Home page are returning a Error 404: Page Not Found you might want to try the following link: http://hubpages.com/hub/ASPNET-DEVELOPMENT-SERVER–WEB-PAGE-CANNOT-BE-DISPLAYED

Unknown Locale
If when attempting to connect you are getting a Locale not recognized error, make sure that your regional settings are set to English, Control Panel->Regional and Language Options, you also need to add the following to the sqldeveloper.conf file: AddVMOption -Duser.Xlanguage=en
AddVMOption -Duser.region=US
(http://forums.oracle.com/forums/thread.jspa?threadID=369603)

Access Denied error when starting Oracle Database
If you are getting an Access Denied error when starting the Oracle XE server you need to right-click on the “Start Dabatase” option and select “Run as administrator”.

Other Errors
It is know that some errors are particular to Windows Vista, if you still cannot get either Oracle XE or Oracle SQL Developer to work you might want to try to install a Virtual Machine, install an OS of your choice (recommended Windows XP) and install Oracle XE then Oracle SQL Developer.

Complete Un-installation of PostgreSQL from Mac OS X Lion


In response to a question on stackoverflow, here is a short guide on how to completely uninstall PostgreSQL 9.1 from Mac OS X Lion.

  1. Open a terminal window

    Utilities->Terminal

  2. Run the uninstaller

    sudo /Library/PostgreSQL/9.1/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh

    PostgreSQL Uninstall Wizard

    PostgreSQL Uninstall Wizard in Progress

    Data not removed after PostgreSQL Uninstallation

  3. Remove the PostgreSQL and data folders (Wizard will notify you that these were not removed)

    sudo rm -rf /Library/PostgreSQL

  4. Remove the ini file

    sudo rm /etc/postgres-reg.ini

  5. Remove the PostgreSQL user

    System Preferences -> Users & Groups

    Unlock the settings panel by clicking on the padlock and enter your password

    Select the PostgreSQL user and click on the minus button.

Remove PostgreSQL User

 

Virtual Hosts on Apache


Working on multiple Web Projects on the same system might become a headache to manage. You must use Virtual Hosts if you are using Apache as pointed out by David Kiss. Following are the steps required to create a Virtual Host called magento in your system such that when you type http://magento the site is displayed, as per Mac OS X Lion using MAMP:

    1. Backup your files.
      1. Open a terminal window.
      2. Backup your hosts file:
        sudo cp /private/etc/hosts /private/etc/hosts.bak
      3. Backup your Apache configuration file:
        cp /Applications/MAMP/conf/apache/httpd.conf /Applications/MAMP/conf/apache/httpd.conf.bak
      4. Backup your Virtual Hosts configuration file:
        cp /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf.bak
    2. Update the hosts file.
      1. Edit the hosts file:
        sudo nano /private/etc/hosts
      2. Add the name of the Virtual Host you want on your system:
        127.0.0.1 magento
      3. Save and exit:
        Press Ctrl+X then Y.
    3. Update the Apache configuration file.
      1. Edit the Apache configuration file:
        nano /Applications/MAMP/conf/apache/httpd.conf
      2. Un-comment the line where httpd-vhosts.conf is found such that it looks like this:
        Include /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf
      3. Save and exit:
        Press Ctrl-W then Y
    4. Update the Virtual Hosts configuration file.
      1. Edit the configuration file:
        nano /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf
      2. At the end add the following:
        <VirtualHost *:80>
        ServerName magento
        DocumentRoot /Users/fraki/Sites/magento
        </VirtualHost>
      3. Save and exit:
        Press Ctrl-X then Y
    5. Place the site contents in the folder specified.
    6. Navigate to the virtual host.

Using Virtual hosts

You might want to check the official documentation of Apache about Virtual Hosts, in this post I am using name-based virtual hosts.