Aug 29 2007

Nagios 3.0 beta2

Catégorie : Nagios, Supervision, NewsCharles Collier @ 11:41 pm

The new realse of Nagios 3 was released today. It fixes some bugs and add improvments to the new host logic check.

As soon as the new version will be available, a tutorial will be published about Nagios 3.

Visit:
Nagios.org


Aug 20 2007

XenSource - made in Citrix

Catégorie : Virtualization, NewsCharles Collier @ 1:52 pm

En vacances, quelques jours et je decouvre que Xen a été rachté par Citrix. Le point positif montre l’importance aujourd’hui des solutions de virtualisation et le serieux de la solution XenSource. Le point négatif réside dans le flou concernat le cote open-source de Xen, en effet dans les différentes annonces faites sur le sujet, des zones d’ombres persistent sur le type de licence.

visit:
http://www.xensource.com
http://www.citrix.com


Jul 11 2007

Oracle Database 11g Launch

Catégorie : Database, News, Oracle Database, OracleCharles Collier @ 12:47 am

Oracle is going to launch today Oracle Database 11g

On Oracle website you can join a live webcast about this new version. it will be at 10 a.m. ET

We had to wait 4 long years to have these 482 new features with data compression for example or hot patching (that sounds great) or new RAC possibilities:

Oracle11g High Availability & RAC new features

Oracle continues to enhanced Real Application Clusters in Oracle11g and we see some exciting new features in RAC manageability and enhanced performance:

  • Oracle 11g RAC parallel upgrades - Oracle 11g promises to have a rolling upgrade features whereby RAC database can be upgraded without any downtime. Ellison first promised this feature in 2002, and it is a very challenging and complex 11g new feature.

  • Oracle RAC load balancing advisor - Starting in 10gr2 we see a RAC load balancing advisor utility. Oracle says that the 11g RAC load balancing advisor is only available with clients which use .NET, ODBC, or the Oracle Call Interface (OCI).

  • ADDM for RAC - Oracle will incorporate RAC into the automatic database diagnostic monitor, for cross-node advisories.

  • Optimized RAC cache fusion protocols - moves on from the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized. Source: Mark Rittman

  • Oracle 11g RAC Grid provisioning - The Oracle grid control provisioning pack allows you to “blow-out” a RAC node without the time-consuming install, using a pre-installed “footprint”. Oracle 11g OEM has have easy server blade installs where a binary footprint is tar’ed to the server blade and configured, without a cumbersome install process.

  • Hot patching - Zero downtime patch application.

  • Data Guard - Standby snapshot - The new standby snapshot feature allows you to encapsulate a snapshot for regression testing. You can collect a standby snapshot and move it into your QA database, ensuring that your regression test uses real production data.

  • Quick Fault Resolution - Automatic capture of diagnostics (dumps) for a fault.

Don’t miss the live webcast -> Click here to view the live Webcast on July 11, 2007.


Jul 10 2007

Awstats on Tomcat

Catégorie : Tomcat, Web server, LinuxCharles Collier @ 11:35 pm

I’ve found this little tutorial two years ago and it helps me a lot with awstats on tomcat, i hope it can be useful for you….

AwStats
Author: John Smith (first website found) it seems to have a mirror here

Tomcat statistics

Requirements

  • Perl 5.2 or above
  • Tomcat 5 (I can’t see any reason for Tomcat 4 not to work, I haven’t tried it, though)
  • awstats.war file (see downloads)

Changing Tomcat access logs format

Tomcat access logs format isn’t exactly what we need. We could also have modified AWStats configuration files, but with the loss of important information. Thus, let’s make Tomcat logs compatible with AWStats. Logs are configured in [Tomcat_install]/conf/server.xml. They might look something like:

<Valve className=“org.apache.catalina.valves.AccessLogValve” directory=“logs” prefix=“localhost_access_log.” suffix=“.txt” pattern=“common” resolveHosts=“false”/>

Normally this lines are commented. Just take in mind they should appear, uncommented, within your Host definition.

We will replace the valve definition with this one:

<Valve className=“org.apache.catalina.valves.AccessLogValve” directory=“logs” prefix=“www_mydomain_com_access_log.” suffix=“.log” pattern=“combined” fileDateFormat=“dd-MM-yy” resolveHosts=“false”/>

Enable Perl scripts

Tomcat has disabled by default CGI executions. This is because CGIs do not conform Tomcat security box. But we know exactly what we are going to do, aren’t we ….. ?

The only thing you need to do is renaming [Tomcat_install]/server/lib/servlets-cgi.renametojar to [Tomcat_install]/server/lib/servlets-cgi.jar. This will enable AWStats Perl scripts to execute on Tomcat server. When it’s done, restart Tomcat.

There is something more done through awstats.war file’s web.xml. You might want to look at this file once downloaded.

Install AWStats

AWStats is included in awstats.war file, therefore you will not need to install AWStats by hand.

Deploy awstats.war file. Will suffice copying this file into [Tomca_install]/webapps folder, but in case your Tomcat is configured not to auto-deploy war files, unzip it yourself. By default would create an [Tomca_install]/webapps/awstats folder.

Although you could change default context, isn’t a good idea. At least not to start with. Better make it work and then think about changing things.

Configure AWStats

This is the hardest part, did you already take a coffe?

First we will make some assumptions, are these ones:

  • awstats.war was deployed into /awstats default context. See Install AWStats.
  • Our domain is www.mydomain.com.

Now, go to [Tomca_install]/webapps/awstats/WEB-INF/cgi-bin folder. Next instructions make the assumption this is your current working folder.

  1. Copy awstats.model.conf into awstats.www.mydomain.com.conf.
  2. Edit awstats.www.mydomain.com.conf.

You can use any text editor of your preference. Now, we will change some file default values. You must look for the attributes and change their values as shown below:

LogFile=”[TI]/webapps/awstats/WEB-INF/tools/logresolvemerge.pl [TI]/logs/*.log |”

LogType=W

LogFormat=1

LogSeparator=” ”

SiteDomain=”www.mydomain.com”

DNSLookup=1

DirData=”.”

DirCgi=”/cgi-bin”

DirIcons=”/awstats/icon”

Remember replacing [TI] with full path to Tomcat. And www.mydomain.com with your domain name.

Update site statistics.

Here you have two choices:

  1. Set AllowToUpdateStatsFromBrowser=1 in awstats.www.mydomain.com.conf file, see above. This will allow updating from the web browser with: http://www.mydomain.com/awstats/cgi-bin/awstats.pl?config=www.mydomain.com&update=1.
  2. Using Telnet or SSH, go to [Tom ca_install]/webapps/awstats/WEB-INF/cgi-bin folder and run perl awstats.pl -config=www.mydomain.com -update.

View site statistics.

Type http://www.mydomain.com/awstats/cgi-bin/awstats.pl?config=www.mydomain.com. That was all.

Creating separated domain statistics.

From the instructions above, everything is valid for creating separated domain statistics, except for one thing:

Inside your awstats.www.mydomain.com.conf we said:

LogFile=“[TI]/webapps/awstats/WEB-INF/tools/logresolvemerge.pl [TI]/logs/*.log |”

This line was gathering the whole set of log files, and this is against having statistics appart for each domain. We should replace this line to match the log files for the corresponding domain, as we said when changing Tomcat access logs format:

LogFile=“[TI]/webapps/awstats/WEB-INF/tools/logresolvemerge.pl [TI]/logs/www_mydomain_com*.log |”

Important! Don’t omit the asterisk in pointing the log files. Take in mind that Tomcat will create an access log file for each day, and that final file’s name will include the date.


Jun 20 2007

Oracle 11g will be launched the 11 July

Catégorie : Database, News, Oracle Database, OracleCharles Collier @ 1:22 am

It’s now official, Oracle has announced the release of Oracle 11g on 11th July 2007.

Since last October and the OpenWorld conference, Oracle was anouncing this new version. A lots of new features will be avalaible in this 11g version. That will be detailed on a future post.

Of course i’m sure you notice that 11g will be launched 11 july (and “g” is the 7th letter of the alphabet and july the 7th month of the year) Oracle 11g should be a lucky version even if it will not be launched th 7th July (07/07/07)

>> www.oracle.com


Jun 15 2007

Information Request

Catégorie : Supervision, Nagios, Tips and tricks, News, Oracle, LinuxCharles Collier @ 12:06 am

You’d like to have a post or a tutorial about linux (redhat, fedora) Oracle (database, 10g, RAC or OAS - oracle application suite), Nagios, Cacti,…

Feel free to ask and i’ll try to answer to your question.
Leave a comment with your question.


Jun 08 2007

Oracle’s Certification Matrices

Catégorie : Database, Tips and tricks, Oracle Database, OracleCharles Collier @ 1:07 pm

Because i didn’t find it quickly, i’d just want to publish this very useful link to publish this access to the Certify - Oracle’s Certification Matrices:
http://www.oracle.com/technology/support/metalink/index.html

    —°°°— 

Une petite info pratique que je souhaite publié parce que je ne l’ai pas trouvé rapidemment. Voici le lien pour acceder aux matrices de compatibilté Oracle:
http://www.oracle.com/technology/support/metalink/index.html


Jun 08 2007

List installed oracle components

Catégorie : Database, Tips and tricks, Oracle Database, OracleCharles Collier @ 12:37 pm

If you want to know which components were installed on your server:

$ORACLE_HOME/OPatch/opatch lsinventory -detail


« Page précédentePage suivante »