Academic, Researcher, Data Specialist
For educational use only, I have prepared an installation guide of MySQL 5.6.20 Community Server tested on Windows XP (32-Bit), Windows 7 (32-Bit), Windows 8 (64-Bit), Ubuntu 14.04 (64-Bit) and Mac OS 10.9.4 (64.bit)
Click on the following link for the MySQL 10.6.20 Installation Guide.
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
600 people reached the top of Mt. Everest in 2012. This blog got about 8,000 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 13 years to get that many views.
Just launched one of my latest projects: matfar.co.uk This is a portfolio site for Matthew Farrugia a senior creative and a great friend of mine. The site is based on WordPress and the Photorific premium theme. Following is the flier:
N.B. All graphic and photographic material is the work of Matthew Farrugia.
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.
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.
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.
Utilities->Terminal
sudo /Library/PostgreSQL/9.1/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh
sudo rm -rf /Library/PostgreSQL
sudo rm /etc/postgres-reg.ini
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.
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:
You might want to check the official documentation of Apache about Virtual Hosts, in this post I am using name-based virtual hosts.
After self-signing an SSL certificate for development purposes the Web server needs to be configured appropriately. I found the posting by Dave Kiss to be the best one. Following are the required steps if you used the default MAMP settings:
N.B. If the apache server fails to start then you have an error in your configuration, make sure you replace the DocumentRoot in your SSL configuration file to match your actual root folder.
N.B. Dave’s post also contains steps to configure Virtual Hosts which I left out for a different posting to be less confusing.
N.B. Dave’s post using git to backup the files, in this post I simply make a copy of the configuration file, if you want to restore the backup simply type: cp httpd.conf.bak httpd.conf or any other file you want to restore.
Installing MAMP on Mac OS X Lion is surely an easy way of getting Apache, PHP and MySQL working on your system. If you plan on using MySQL Workbench you will need to do some additional steps.
Keep checking through the guide for additional configuration.
At some point any Web Developer would need to secure part of a site and therefore require an SSL certificate. There are different options available depending on the use and here is a short post documenting the various options:
Free for Open Source Projects: Some providers are willing to offer free SSL certificates for open-source projects such as GoDaddy.com, obviously some terms and conditions apply which one must read. More details can be found here.
Free with Hosting Plan: Some Web Hosting providers would include a free SSL certificate if you buy a hosting plan. Generally the offer is for the first year with competitive renewal pricing. Just to name a few: HostColor.com, DomainAvenue.com and HostGator.com
Free SSL Community: A growing community called StartSSL are offering an entry level service for free for basic used and limited warranty which might well satisfy your needs and therefore worth a check.
Comparison Charts: If none of the above suits you then you might have to actually buy an SSL certificate, not before doing the appropriate research. WhichSSL is a dedicated site to aid in the selection of the appropriate certificate authority or SSL vendor to choose with the help of a comparison chart. More comparisons can be found in Wikipedia.org and SSLShopper.com. Your research might also payoff by finding some promotional offers and/or discounts.
Self-Signed Certificates for Development: Well if you need a certificate just for development purposes then you can sign one yourself as shown in my previous post.