Archive for March, 2006

A Concise apt-get / dpkg primer for new Debian users

Posted by Oleksiy Kovyrin under Admin-tips · русский

I really like Debian and Debian-based Linux distributions. That is because I am admin and I am lazy as all good system administrators ;-) With apt-get based distributions I can install/update/deinstall system packages very fast and my work becomes very efficient (there is no rpm-hell or constant building of new software or software updates).

Today I dugg very useful primer for apt-get/dpkg users. It contains many real-life examples of work with apt-get and dpkg utilities and may be interesting for new debian administrators.

Google Educational Seminars (techtalks) and Saving Google Video to Local Disk

Posted by Oleksiy Kovyrin under Links · русский

Some days ago I came across interesting resource from Google. They are providing free access to video recordings from the some of their Educational seminars.

As far as I understand, these seminars has been provided by Google for their staff and now all of us can get them via Google Video service.

By the way, when I have decided to view some of that interesting seminars, it was not wery confortable for me to view them in browser window… and I have googled ;-) for some method to save video from google to local disk. As the result of my seraching, I got great service, that allows saving any clip from Google Video, Youtube or iFilm services to local disk!

And now, you have link to very interesting collection of video clips and you know the metod how to save it to local disc… the last I need to do is to say: “Happy viewing!” :-)

Russian Translation for Contact Form WordPress Plugin

Posted by Oleksiy Kovyrin under Blog · русский

As a part of my wife’s work on wp-based site, I have translated Contact Form WordPress plugin to russian.

WP-ContactForm is a simple drop in way for users to get in touch with you. Its easy for any WordPress user to add this functionality to their site. Just upload two files and change a few options in your admin panel and you’re set.

Russian .po and compiled .mo files can be found here. Installation procedure is really simple: upload .mo file to /wp-content/plugins/wp-contactform/ directory on your server.

BrowserBook – Must Have for Web Developers

Posted by Oleksiy Kovyrin under Development · русский

Today I have found very useful thing on digg.com. This thing is BrowserBook – colorful 16-pages booklet with compilation of all client-side web-technologies, such as Colour Palette, Font Characters, XHTML Tags, CSS Styles, JavaScript syntax and functions, DOM API and Regular expressions manual.

I think, this book is really Must Have for all of Web-developers, HTML-editors and other people, that needs to remember all of that complex web-technologies!

Oracle SQL Developer (formerly Project Raptor) Release 6 is Out

Posted by Oleksiy Kovyrin under Development · русский

Some days ago, 2 March 2006, really great software Oracle SQL Developer has been released.

Oracle SQL Developer (known as “Project Raptor” through EA Release 3) is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own.

As for me, this software is a good free and cross-platform alternative for proprietary TOAD from Quest Software. This software has almost all TOADs features, it is efficient and has beautiful interface. The best features in this release are: PL/SQL syntax highlight and PL/SQL debugger.

Web-based OS has beed created!

Posted by Oleksiy Kovyrin under Networks · русский

Maybe, some day admins will need to manage only a huge web servers with some Apache or IIS software? Why I am asking this question? Look at that!

Welcome to eyeOS, a web based operating system. With eyeOS you can access your data and your applications anywhere, anytime. A virtual office in your hands, no need to install anything in the computer. Everything lives in the browser, for you and your work colleagues. eyeOS is open source and free software.

As I understand, there is only one drawback in idea of an internet-based desktop environment – there is no caching JavaScript compiler created for fast and efficient JavaScript execution. When we will get it, there is no doubt, some of our desktop tools will move to online.

How to Install Oracle Database XE on Debian Sarge

Posted by Oleksiy Kovyrin under Admin-tips, Databases · русский

Few days ago Oracle Database Express Edition has been released.

Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for:

  • Developers working on PHP, Java, .NET, and Open Source applications
  • DBAs who need a free, starter database for training and deployment
  • Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
  • Educational institutions and students who need a free database for their curriculum

I have spent some time for installing it on Debian Sarge because it has only Debian Unstable support and many people does not know, that required lib (libaio) can be installed to Sarge. Now, I will describe step-by-step howto about installing Oracle XE on Debian Sarge.

First of all, you do not need to download Oracle XE installation package for Debian from Oracle Express Download Page. You do not need to do it because Oracle has its own debian repository for automated installations.

Read the rest of this entry »

Hosting Tricks: How to delegate DNS-management for some subdomain to off-site DNS-server

Posted by Oleksiy Kovyrin under Admin-tips · русский

In one of my last posts about cheap hosting unlimited number of domains, I have described how to point your domain to some sub-directory of an existing hosting account. But sometimes hosting provider requires parking of your DNS name for creating aliases in hosting account. For example, hosting platform, created by me and used on Free Adult hosting Servik.com service, requires your domain’s NS-records to be directed to provider’s own DNS-servers. What can you do if you don’t want to park entire domain to provider’s DNS-servers and want to host only one sub-domain on its servers?

As a simple, but very powerful solution, I can suggest following trick.

Let’s see to generic DNS-domain configuration. Generic domain has following records:

  • SOA – record with domain contact information, expiring values, etc.
  • NS – record(s) with IP addresses of domain’s DNS-servers.
  • MX – record(s) with IP or symbolic names of domain’s mail servers.
  • A – record(s) with IP addresses of domain and subdomains.
  • CNAME – synonyms for A-records.

When you asking your DNS system for resolving some symbolic name to an IP address and this name is some sub-domain name (such as kovyrin.net or mail.google.com), your DNS server trying to find NS-records for this sub-domain (e.g kovyrin.net) and then, if records were not found, it looks for NS servers for parent domain (kovyrin.net). With generic DNS configuration you can’t allow DNS-management of some sub-domain to off-site DNS-server. You can only move entire domain between DNS-servers.

But let’s try to add following records to your DNS-zone:

    ....
    subdomain.domain.com IN NS off-site.dns-server.com.
    ....

Now, all requests for subdomain.domain.com will be referred to off-site.dns-server.com and this server can freely manage delegated subdomain record by creating another sub-domains or changing this subdomain IP-address.

Hosting Tricks: Hosting Unlimited Number of Domains in One-Domain Hosting Account

Posted by Oleksiy Kovyrin under Admin-tips · русский

Some times we need to use our existing hosting account to (maybe temporarily) place another web-site in it. But what we can do, if our hosting provider allows only one hosting directory and only aliases for main site (as GoDaddy.com does)? We can use the following Apache+mod_rewrite trick to host unlimited number of domains on one hosting directory.

First of all, we need to point our new domain to hosting server IP. If server’s IP is static, we can do it by simple A-record in our DNS-zone control panel:

    new-domain.com  IN A IP.ADD.RE.SS

If you don’t know IP address of hosting server or this address is not permanent (for example, because of some load balancing used by hosting provider), you can use simple trick with CNAME-record in your new DNS-zone:

     new-domain.com  IN CNAME already-hosted-domain.com.

After the first step was finished we have new-domain.com pointed to our hosting provider’s server. Now, we need to add this domain support to hosting server. We can do it by your hosting provider’s “Domain aliases” option or another option with such meaning.

After we have associated our new domain name with existing directory on hosting server (/hosting/dir), everything we need is to do something to force hosting server to use some sub-directory for all requests to new-domain.com (/hosting/dir/new-domain). To do it, we need to put following code into the .htaccess file in /hosting/dir directory:

    RewriteEngine On
    RewriteBase /
    RewriteCond %{REQUEST_URI} !^/new-domain/
    RewriteCond %{HTTP_HOST} new-domain\.com$
    RewriteRule (.*) http://already-hosted-domain.com/new-domain/$1 [L]

That’s all! After we have created this file, all requests to new-domain.com will be pointed to /hosting/dir/new-domain directory.