Tech Site & Blog http://techsiteblog.com http://backend.userland.com/rss092 en ext2 and ext3 on Windows If you are using dual boot with Windows and Linux you've probably faced with a problem of accessing ext3 partitions from Windows OS. Most of the Linux distributions come with NTFS-3G driver, which allow reading & writing to NTFS partiton. Sadly, Windows doesn't offer such filesystem driver fo [...] http://techsiteblog.com/ext2-and-ext3-on-windows/ MS SQL Add User 1. Connect to MS SQL server using MS SQL Management Studio. 2. Click on the \"New query\" button in the toolbar on left. 3. Create a database Type following query and execute it: Example: 3. Create login Example: 4. Create user use DATABASE_NAME create user USE [...] http://techsiteblog.com/ms-sql-add-user/ ffmpeg and x264 How to install ffmpeg with x264 codec support on Debian Lenny (5.0)? By using x264 codec rather than a FLV video format you will gain on video and audio quality. 1. We need to remove any previous ffmpeg installations. 2. Add additional repository to /etc/apt/sources.list Open file with [...] http://techsiteblog.com/ffmpeg-and-x264/ Use MySQL database in your C++ projects How to use MySQL DB in your C++ projects. This tutorial is written for Debian Lenny/Ubuntu 9.10. With a few minor changes, it should work on other distributions also. What will you need? - gcc <-- c++ compiler - MySQL server 5.0 installed - MySQL C API To install above programs run [...] http://techsiteblog.com/use-mysql-database-in-your-c-projects/ How to remove Linux from a Mac? I don't really see why would you do that, but here is a how to about removing Linux from a Mac. Linux creates few partitions (usually / and swap, it's also a common practice to have /home partition). Everything would be easy if only Mac OS's built-in Disk Utility would support deleting Linux part [...] http://techsiteblog.com/how-to-remove-linux-from-a-mac/ mod_python and MySQLdb MySQL is one of greatest databases for web sites, and for applications and it\'s probably most used with PHP. Python is a good language for a lot of things. In my case, I needed some daemons, to do certain tasks. Firstly, I tried with PHP, but it is language for web pages, and it don\'t perform [...] http://techsiteblog.com/mod_python-and-mysqldb/ How to speed up loading of your website Is your website slow? Do you even realize that it could load faster? Every webmaster tries to make web sites faster, so people will get better user experience. But there are few tricks that not everyone is aware of. - cache static content (pictures, javascripts, css files) - remove ETag fro [...] http://techsiteblog.com/how-to-speed-up-loading-of-your-website/ Convert video to FLV with PHP This is a simple approach to converting videos to .flv with PHP. For example, users are allowed to upload videos, and then you can play it by Flash Player. Probably you already have PHP installed, so let\'s continue with FFmpeg. Following commands works only in Debian/Ubuntu distribution. [...] http://techsiteblog.com/convert-video-to-flv-with-php/ VPN or how to access US sites abroad If you live outside US you cannot watch Hulu/CBS/etc. videos on demand because you need US IP. The other reason to use VPN is a secure connection to VPN provider. So your ISP doesn't know what are you browsing until you are connected to VPN. There is some free and some payable services. Payable u [...] http://techsiteblog.com/vpn-or-how-to-access-us-sites-abroad/ Essential security tips for servers 1. First thing you need to do is to change your root password. Connect to server with SSH and type: Then type in your new password, press enter, and retype it again. 2. It\'s not safe to allow root user to login throught SSH. So you need to create a new user: Then set the password for t [...] http://techsiteblog.com/essential-security-tips-for-servers/