Tuesday, March 6, 2012

Efficient file storage for user uploaded files

While disk space is cheap, dealing with large numbers of files can be tedious, and in some cases unnecessary.  Before considering file naming conventions, consider the uniqueness of your files.  At work, we allow our customers to upload logos.  It's possible for multiple customers to upload the same logo.  The last thing we wanted was to maintain multiple copies of the same logo on the server.

We decided our best approach would be to name the files based on the contents of the file.  If the contents changed, so did the filename.

$filename = md5(file_get_contents($pathToFile));

The MD5 hashed filename is what was linked to the user logos.  This turned out to be a fantastic solution for our needs.

What naming conventions do you use for user uploaded files?  This method seems like it would work well for any uploaded files because nothing would ever be the same.  Do you agree or disagree?  Why?

Sunday, March 4, 2012

Smart MySQL Backup

A lot of web sites are hosted on shared servers via web hosting services like Hostgator where a single web server may have a hundred or more customer accounts hosted on it.  While services like this do backup your files and databases they do not guarantee them.  This means if something goes wrong and their backups couldn't be restored for any reason, you'd simply lose your data and they wouldn't be at fault.  For this reason, I do not use cPanel backups on my shared hosting account.

I personally use and recommend Smart MySQL Backup to create backup databases.  There are a lot of great features...
  • Backup individual or all databases in a separate file for each database
  • UTF-8 support
  • Daily, weekly and monthly backup rotation
  • Send backups to email
  • Upload backups to FTP
  • Handles foreign keys and stored procedures
Once I have that setup and running, I have a simple PHP script to upload the backups to Amazon S3.  These backups can be restored through cPanel/PHPMyAdmin, or via command line.

// Take db backups and copy them to s3
// https://github.com/tpyo/amazon-s3-php-class
require_once 's3.php';

$bucket = 'my-bucket-name';

$backupPath = '/path/to/backups/archive/daily';

$s3 = new S3("[awsAccessKey]", "[awsSecretKey]");

$today = date('Y-m-d');
$expired = date('Y-m-d', strtotime('-5 days'));
foreach(glob($backupPath.'/'.$today.'/*.bz2') as $file) {
    $fileInfo = pathinfo($file);
    
    //move backup file to s3
    $s3->putObject(S3::inputFile($file), $bucket, $fileInfo['basename'], S3::ACL_PRIVATE);
    
    //remove expired files
    $s3->deleteObject($bucket, str_replace($today, $expired, $fileInfo['basename']));
}

PHP file upload MIME type is unreliable

I ran into an odd issue this week where a PDF being uploaded by a user through the latest Firefox wasn't properly detected as a PDF.  The "type" showed a value of "application/x-word-xxx" instead of "application/pdf".  On my own computer, Firefox and Chrome worked fine as expected.

The file type header is defined by the browser handling the uploading.  The fix for this appears to be to use mime_content_type on the file after it's been uploaded instead of relying on $_FILES.

echo mime_content_type('php.gif') . "\n"; //image/gif
echo mime_content_type('test.php'); //text/plain

Wednesday, August 3, 2011

PrintNet/GMC: Critical error: Unmatched options (810 or 811)

I ran into this issue when working with GMC... it took me forever to figure out what was up with it.  To keep a long story short, turns out it was the `enableerrorconsole` flag... my initial command read 
/usr/local/PNetT/PNetTCNetClient
-o /usr/local/PNetT/tmpData/SOB/workflows/master_ppo_sob_3col.wfd
-e PDF
-f "/usr/local/PNetT/tmpData/SOB/Master PPO-Gem Mortgage BC Classic PPO_temp.pdf" -useincluded "*"
-difDataInput1 "/usr/local/PNetT/tmpData/SOB/Master PPO-Gem Mortgage BC Classic PPO.txt" 
-difDataInput2 "/usr/local/PNetT/tmpData/SOB/Master PPO-Gem Mortgage BC Classic PPO-table.txt"
-enableerrorconsole true
If you do this, you'll see one of the following errors:
Critical error 0810: Unmatched options
Critical error 0811: Unmatched options
The issue is that the `enableerrorconsole` flag does not need a true parameter, it needs options for the log files to split up.  This option isn't something that is enabled/disabled by it's parameters, it's parameters specify the log files that the error console requires.  According to the user manual it splits up the error for the command so that the log data goes one places, and the error is recorded somewhere else.  I fixed this error by changing my command by specifying the log files as seen below:
/usr/local/PNetT/PNetTCNetClient
-o /usr/local/PNetT/tmpData/SOB/workflows/master_ppo_sob_3col.wfd
-e PDF
-f "/usr/local/PNetT/tmpData/SOB/Master PPO-Gem Mortgage BC Classic PPO_temp.pdf"
-useincluded "*"
-difDataInput1 "/usr/local/PNetT/tmpData/SOB/Master PPO-Gem Mortgage BC Classic PPO.txt"
-difDataInput2 "/usr/local/PNetT/tmpData/SOB/Master PPO-Gem Mortgage BC Classic PPO-table.txt"
-enableerrorconsole >sob.log 2>gmc-error.log

PrintNetT & GMC Support, Forums & Documentation

If you've ever used PrintNetT or GMC and tried to look something up on Google you'll notice that you can basically find nothing.  I began working with these products while at a printing company and quickly realized that with my lack of training with the server client I was going to run into many problems.  After some time of trying to look through the manual to get my answers I finally reached out to price options for training that I could present to my bosses to resolve all of our issues.  I was referred to their community forums and online documentation.  I was dumbfounded that this information was so easily accessible on their web site - but why was it so hard to find?

The truth is that GMC doesn't want you to find it.  Their goal is for you to pay thousands of dollars for support and training.  They've blocked search engines from indexing their message boards.  So the only content you're going to find is that which is not posted on their web site.  I'm not trying to sell them as an evil corporation, it makes perfect sense for them to try to make more money, my only gripe is that it hurts the customer in this specific case.

Be aware of these resources, they can be very helpful.

Monday, January 3, 2011

What to do if your server gets hacked...


I read this elsewhere and thought it was just so good I had to post it.  I'm not able to determine the exact source or I would provide a link to it.
First things first, there are no "quick fixes" other than restoring your system from a backup taken prior to the intrusion, and this has at least two problems.
  1. It's difficult to pinpoint when the intrusion happened.
  2. It doesn't help you close the "hole" that allowed them to break in last time, nor deal with the consequences of any "data theft" that may also have taken place.
This question keeps being asked repeatedly by the victims of hackers breaking into their web server. The answers very rarely change, but people keep asking the question. I'm not sure why. Perhaps people just don't like the answers they've seen when searching for help, or they can't find someone they trust to give them advice. Or perhaps people read an answer to this question and focus too much on the 5% of why their case is special and different from the answers they can find online and miss the 95% of the question and answer where their case is near enough the same as the one they read online.
That brings me to the first important nugget of information. I really do appreciate that you are a special unique snowflake. I appreciate that your website is too, as it's a reflection of you and your business or at the very least, your hard work on behalf of an employer. But to someone on the outside looking in, whether a computer security person looking at the problem to try and help you or even the attacker himself, it is very likely that your problem will be at least 95% identical to every other case they've ever looked at.
Don't take the attack personally, and don't take the recommendations that follow here or that you get from other people personally. If you are reading this after just becoming the victim of a website hack then I really am sorry, and I really hope you can find something helpful here, but this is not the time to let your ego get in the way of what you need to do.
You have just found out that your server(s) got hacked. Now what?
Do not panic. Absolutely do not act in haste, and absolutely do not try and pretend things never happened and not act at all.
First: understand that the disaster has already happened. This is not the time for denial; it is the time to accept what has happened, to be realistic about it, and to take steps to manage the consequences of the impact.
Some of these steps are going to hurt, and (unless your website holds a copy of my details) I really don't care if you ignore all or some of these steps but doing so will make things better in the end. The medicine might taste awful but sometimes you have to overlook that if you really want the cure to work.
Stop the problem from becoming worse than it already is:
  1. The first thing you should do is disconnect the affected systems from the Internet. Whatever other problems you have, leaving the system connected to the web will only allow the attack to continue. I mean this quite literally; get someone to physically visit the server and unplug network cables if that is what it takes, but disconnect the victim from its muggers before you try to do anything else.
  2. Change all your passwords for all accounts on all computers that are on the same network as the compromised systems. No really. All accounts. All computers. Yes, you're right, this might be overkill; on the other hand, it might not. You don't know either way, do you?
  3. Check your other systems. Pay special attention to other Internet facing services, and to those that hold financial or other commercially sensitive data.
  4. If the system holds anyone's personal data, make a full and frank disclosure to anyone potentially affected at once. I know this one is tough. I know this one is going to hurt. I know that many businesses want to sweep this kind of problem under the carpet but I'm afraid you're just going to have to deal with it.
Still hesitating to take this last step? I understand, I do. But look at it like this:
In some places you might well have a legal requirement to inform the authorities and/or the victims of this kind of privacy breach. However annoyed your customers might be to have you tell them about a problem, they'll be far more annoyed if you don't tell them, and they only find out for themselves after someone charges $8,000 worth of goods using the credit card details they stole from your site.
Remember what I said previously? The bad thing has already happened. The only question now is how well you deal with it.
Understand the problem fully:
  1. Do NOT put the affected systems back online until this stage is fully complete, unless you want to be the person whose post was the tipping point for me actually deciding to write this article. I'm not going to link to that post so that people can get a cheap laugh, but the real tragedy is when people fail to learn from their mistakes.
  2. Examine the 'attacked' systems to understand how the attacks succeeded in compromising your security. Make every effort to find out where the attacks "came from", so that you understand what problems you have and need to address to make your system safe in the future.
  3. Examine the 'attacked' systems again, this time to understand where the attacks went, so that you understand what systems were compromised in the attack. Ensure you follow up any pointers that suggest compromised systems could become a springboard to attack your systems further.
  4. Ensure the "gateways" used in any and all attacks are fully understood, so that you may begin to close them properly. (e.g. if your systems were compromised by a SQL injection attack, then not only do you need to close the particular flawed line of code that they broke in by, you would want to audit all of your code to see if the same type of mistake was made elsewhere).
  5. Understand that attacks might succeed because of more than one flaw. Often, attacks succeed not through finding one major bug in a system but by stringing together several issues (sometimes minor and trivial by themselves) to compromise a system. For example, using SQL injection attacks to send commands to a database server, discovering the website/application you're attacking is running in the context of an administrative user and using the rights of that account as a stepping-stone to compromise other parts of a system. Or as hackers like to call it: "another day in the office taking advantage of common mistakes people make".
Make a plan for recovery and to bring your website back online and stick to it:
Nobody wants to be offline for longer than they have to be. That's a given. If this website is a revenue generating mechanism then the pressure to bring it back online quickly will be intense. Even if the only thing at stake is your / your company's reputation, this is still going generate a lot of pressure to put things back up quickly.
However, don't give in to the temptation to go back online too quickly. Instead move with as fast as possible to understand what caused the problem and to solve it before you go back online or else you will almost certainly fall victim to an intrusion once again, and remember, "to get hacked once can be classed as misfortune; to get hacked again straight afterward looks like carelessness" (with apologies to Oscar Wilde).
  1. I'm assuming you've understood all the issues that led to the successful intrusion in the first place before you even start this section. I don't want to overstate the case but if you haven't done that first then you really do need to. Sorry.
  2. Never pay blackmail / protection money. This is the sign of an easy mark and you don't want that phrase ever used to describe you.
  3. Don't be tempted to put the same server(s) back online without a full rebuild. It should be far quicker to build a new box or "nuke the server from orbit and do a clean install" on the old hardware than it would be to audit every single corner of the old system to make sure it is clean before putting it back online again. If you disagree with that then you probably don't know what it really means to ensure a system is fully cleaned, or your website deployment procedures are an unholy mess. You presumably have backups and test deployments of your site that you can just use to build the live site, and if you don't then being hacked is not your biggest problem.
  4. Be very careful about re-using data that was "live" on the system at the time of the hack. I won't say "never ever do it" because you'll just ignore me, but frankly I think you do need to consider the consequences of keeping data around when you know you cannot guarantee its integrity. Ideally, you should restore this from a backup made prior to the intrusion. If you cannot or will not do that, you should be very careful with that data because it's tainted. You should especially be aware of the consequences to others if this data belongs to customers or site visitors rather than directly to you.
  5. Monitor the system(s) carefully. You should resolve to do this as an ongoing process in the future (more below) but you take extra pains to be vigilant during the period immediately following your site coming back online. The intruders will almost certainly be back, and if you can spot them trying to break in again you will certainly be able to see quickly if you really have closed all the holes they used before plus any they made for themselves, and you might gather useful information you can pass on to your local law enforcement.
Reducing the risk in the future.
The first thing you need to understand is that security is a process that you have to apply throughout the entire life-cycle of designing, deploying and maintaining an Internet-facing system, not something you can slap a few layers over your code afterwards like cheap paint. To be properly secure, a service and an application need to be designed from the start with this in mind as one of the major goals of the project. I realise that's boring and you've heard it all before and that I "just don't realise the pressure man" of getting your beta web2.0 (beta) service into beta status on the web, but the fact is that this keeps getting repeated because it was true the first time it was said and it hasn't yet become a lie.
You can't eliminate risk. You shouldn't even try to do that. What you should do however is to understand which security risks are important to you, and understand how to manage and reduce both the impact of the risk and the probability that the risk will occur.
What steps can you take to reduce the probability of an attack being successful?
For example:
  1. Was the flaw that allowed people to break into your site a known bug in vendor code, for which a patch was available? If so, do you need to re-think your approach to how you patch applications on your Internet-facing servers?
  2. Was the flaw that allowed people to break into your site an unknown bug in vendor code, for which a patch was not available? I most certainly do not advocate changing suppliers whenever something like this bites you because they all have their problems and you'll run out of platforms in a year at the most if you take this approach. However, if a system constantly lets you down then you should either migrate to something more robust or at the very least, re-architect your system so that vulnerable components stay wrapped up in cotton wool and as far away as possible from hostile eyes.
  3. Was the flaw a bug in code developed by you (or a contractor working for you)? If so, do you need to re-think your approach to how you approve code for deployment to your live site? Could the bug have been caught with an improved test system, or with changes to your coding "standard" (for example, while technology is not a panacea, you can reduce the probability of a successful SQL injection attack by using well-documented coding techniques).
  4. Was the flaw due to a problem with how the server or application software was deployed? If so, are you using automated procedures to build and deploy servers where possible? These are a great help in maintaining a consistent "baseline" state on all your servers, minimising the amount of custom work that has to be done on each one and hence hopefully minimising the opportunity for a mistake to be made. Same goes with code deployment - if you require something "special" to be done to deploy the latest version of your web app then try hard to automate it and ensure it always is done in a consistent manner.
  5. Could the intrusion have been caught earlier with better monitoring of your systems? Of course, 24-hour monitoring or an "on call" system for your staff might not be cost effective, but there are companies out there who can monitor your web facing services for you and alert you in the event of a problem. You might decide you can't afford this or don't need it and that's just fine... just take it into consideration.
  6. Use tools such as tripwire and nessus where appropriate - but don't just use them blindly because I said so. Take the time to learn how to use a few good security tools that are appropriate to your environment, keep these tools updated and use them on a regular basis.
  7. Consider hiring security experts to 'audit' your website security on a regular basis. Again, you might decide you can't afford this or don't need it and that's just fine... just take it into consideration.
What steps can you take to reduce the consequences of a successful attack?
If you decide that the "risk" of the lower floor of your home flooding is high, but not high enough to warrant moving, you should at least move the irreplaceable family heirlooms upstairs. Right?
  1. Can you reduce the amount of services directly exposed to the Internet? Can you maintain some kind of gap between your internal services and your Internet-facing services? This ensures that even if your external systems are compromised the chances of using this as a springboard to attack your internal systems are limited.
  2. Are you storing information you don't need to store? Are you storing such information "online" when it could be archived somewhere else. There are two points to this part; the obvious one is that people cannot steal information from you that you don't have, and the second point is that the less you store, the less you need to maintain and code for, and so there are fewer chances for bugs to slip into your code or systems design.
  3. Are you using "least access" principles for your web app? If users only need to read from a database, then make sure the account the web app uses to service this only has read access, don't allow it write access and certainly not system-level access.
  4. If you're not very experienced at something and it is not central to your business, consider outsourcing it. In other words, if you run a small website talking about writing desktop application code and decide to start selling small desktop applications from the site then consider "outsourcing" your credit card order system to someone like Paypal.
  5. If at all possible, make practicing recovery from compromised systems part of your Disaster Recovery plan. This is arguably just another "disaster scenario" that you could encounter, simply one with its own set of problems and issues that are distinct from the usual 'server room caught fire'/'was invaded by giant server eating furbies' kind of thing.
... And finally
I've probably left out no end of stuff that others consider important, but the steps above should at least help you start sorting things out if you are unlucky enough to fall victim to hackers.
Above all: Don't panic. Think before you act. Act firmly once you've made a decision, and leave a comment below if you have something to add to my list of steps.

Friday, December 24, 2010

R.drawable cannot be resolved

I'm jumping into Android head first and wanted to make a button that when I press it, it trigger's a notification on the notification bar at the top of the screen.  I was browsing through the documentation and ran into this error.

If you look at the Android Notification Documentation example, you'll notice this line in step 2: int icon = R.drawable.notification_icon;. If you use their example in a tutorial you'll find that this icon doesn't exist and you can't compile your app.  The reason for this is that there is no notification_icon image that exists within /res/drawable-*/.  By default, icon.png exists within these directories.  If you change the notification_icon to icon it will work fine.