May 16th, 2012 | By: Gareth Parmar | How to's, MySQL howto | No comments »
Why?…. LOAD DATA LOCAL INFILE?
I recently updated my home machine to Ubuntu 12.04 and found MySQL 5.5 installed as default. As happy as I was to have the latest stable MySQL server, I was a bit gutted to find that LOAD DATA LOCAL was disabled as default, due to security issues. These issues may be valid but this is my local environment and I’ve got projects that require it so thought I’d waste utilize some free time fixing it.
The Process
I’ll be truthful, I did quite a bit of research and didn’t find a definitive guide on how to install MySQL from source, but I aim to provide a guide that gets as close as possible as quick as possible!
April 28th, 2012 | By: Gareth Parmar | Customisation, Tips, tricks & fixes (juicy bits!) | No comments »
I don’t know why Ubuntu has decided to keep window controls in the left corner of the window. For some reason, with every release of Ubuntu I expect the window controls to be moved to the right!
Ubuntu 12.04 is no different, time to change some settings again…
Enter gconf-editor…
Gconf-editor allows you to change a lot of settings on your system. I would suggest getting to grips with this tool as you may be able to fix/modify a lot of your Ubuntu gripes here! (But as always be careful!!)
March 2nd, 2012 | By: Gareth Parmar | Tips, tricks & fixes (juicy bits!) | No comments »
LXDE Lightweight Desktop Environment
Setting a permanent resolution seems quite straightforward in Ubuntu, sometimes! You may have had a few problems setting the resolution in Ubuntu 11.10 (among other things – which has led many people to seek out new distributions).
I decided to try out a few distributions (Crunchbang #!, Lubuntu, Mint to name a few) but also tried to tailor Ubuntu needs – which led me to LXDE.
LXDE
LXDE is a great lightweight desktop environment compared to Gnome or Ubuntu’s Unity. There are a few quibbles which I may address in the future, but the first one that struck me was my resolution not saving after changing it through the ‘preferences->Multiple Screens’ menu.
February 18th, 2012 | By: Gareth Parmar | How to's, Tips, tricks & fixes (juicy bits!) | No comments »
Opening a terminal isn’t as important as it used to be in Ubuntu. Ubuntu is quite user friendly now (though some would argue it is moving against that with it’s unity interface!) but using a terminal is still as powerful as ever!
The quickest way (as always) is the keyboard shortcut, press:
Ctrl+Alt+t
Open Terminal in Ubuntu Unity
Ubuntu is installed with the Unity dashoard as standard which can be accessed by clicking your unity icon (usually in a sidebar on the left of your screen – as the picture) and as you type “terminal” it should display the terminal icon for you to click and open.
January 21st, 2012 | By: Gareth Parmar | Tips, tricks & fixes (juicy bits!) | 7 comments »
Filezilla - What just happened?!
I’ve had a recent problem with the popular open source FTP client: Filezilla crashes on drag and drop.
Whenever I try to drag and drop a folder Filezilla disappears (exits or crashes – however you want to explain it!). It wasn’t too painful to fix…. luckily.
The Fix
This is something to do with python-wx*. Updating these packages fixed the problem, the releases in the standard software repositories are a few releases behind so we need to get the latest ones.
First, we need to add a to our trusted keys (or you will get error messages)
January 14th, 2012 | By: Gareth Parmar | How to's, PHP, Tips, tricks & fixes (juicy bits!) | 5 comments »
Install LAMP Server - Ubuntu: The command we're all after....
Installing LAMP Server on Ubuntu is simple and possible with one command and then following the on-screen instructions:
(NOTE: All the commands here need to be typed into a terminal, open one by pressing Ctrl+Alt+T.)
sudo apt-get install lamp-server^
It’s important to remember the caret (^) at the end of the command.
Thought I’d get that out the way for all the hit and runners looking for the command!
What is LAMP Server
LAMP Server is a collection of open source software used to create a web server. The collection consists of:
January 14th, 2012 | By: Riccardo | BASH Script Tutorials | No comments »
This is a problem that could come across quite often. How to replace text in multiple files at once?
If you are running a UNIX system you are lucky: with a simple BASH script you can achieve this.
How to Replace Text in Many Files with BASH scripting
There are several ways to achieve this, one of the easiest is using sed utility.
Assuming we need to change every “blue” occurrence to “red”, our replace_string.sh would look something like:
January 14th, 2012 | By: Riccardo | PHP | 2 comments »
Where is php.ini? There it is!
Depending on what system you are running, php.ini could have different locations. But where is php.ini hidden?
Find php.ini
There are few ways to know where is php.ini file.
Find it with a PHP script
The safest way to know it, is through the following script:
<?php
phpinfo();
?>
Once you run the script in your favourite browser, the function phpinfo() will output the what you see in the image.
You can find much more details with this function, but in order to locate php.ini, we need to focus only on the field “Loaded Configuration File”.
December 7th, 2011 | By: Riccardo | PHP | No comments »
Some scripts require some time to execute, and they might reach your PHP time limit.
Fatal error
If PHP time limit is too short for your script, you will see this error:
Fatal error: Maximum execution time of N seconds exceeded in /path/to/script.php on line N
Configuring php.ini
PHP time limit can be configured in php.ini, open it up and change the following line to something more suitable:
(EDIT: Can’t find it? Look where is php.ini)
max_execution_time = 30
NOTE: PHP time limit is measured in seconds!
