Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

Petite mise à jour hier soir sur le serveur en voyant dans les logs

Dec 14 23:56:22 olivia freshclam[8292]: TTL: 648
Dec 14 23:56:22 olivia freshclam[8292]: Software version from DNS: 0.95.3
Dec 14 23:56:22 olivia freshclam[8292]: Your ClamAV installation is OUTDATED!
Dec 14 23:56:22 olivia freshclam[8292]: Local version: 0.94.1 Recommended version: 0.95.3
Dec 14 23:56:22 olivia freshclam[8292]: DON'T PANIC! Read http://www.clamav.net/support/faq
Dec 14 23:56:24 olivia freshclam[8292]: main.cvd version from DNS: 51
Dec 14 23:56:24 olivia freshclam[8292]: main.cld is up to date (version: 51, sigs: 545035, f-level: 42, builder: sven)
Dec 14 23:56:24 olivia freshclam[8292]: daily.cvd version from DNS: 10170
Dec 14 23:56:24 olivia freshclam[8292]: daily.cld is up to date (version: 10170, sigs: 128747, f-level: 44, builder: guitar)
Dec 14 23:56:24 olivia freshclam[8292]: --------------------------------------

On procède à la mise à jour habituel du système (téléchargement+compilation+installation

wget "http://downloads.sourceforge.net/project/clamav/clamav/0.95.3/clamav-0.95.3.tar.gz?use_mirror=freefr"
tar xvzf clamav-0.95.3.tar.gz 
cd clamav-0.95.3
./configure --with-user=simscan
make
make install
ldconfig

On redémarre les services et on relance freshclam

root@olivia:~/clamav-0.95.3# /etc/init.d/clamav-daemon restart
 * Stopping ClamAV daemon clamd                                                                     [ OK ] 
 * Starting ClamAV daemon clamd                                                                      [OK ] 
root@olivia:~/clamav-0.95.3# freshclam
freshclam      freshclam_old  
root@olivia:~/clamav-0.95.3# freshclam
ClamAV update process started at Tue Dec 15 00:10:35 2009
main.cld is up to date (version: 51, sigs: 545035, f-level: 42, builder: sven)
Trying host database.clamav.net (149.6.161.117)...
Downloading daily-10171.cdiff [100%]
Downloading daily-10172.cdiff [100%]
daily.cld updated (version: 10172, sigs: 129071, f-level: 44, builder: arnaud)
Database updated (674106 signatures) from database.clamav.net (IP: 149.6.161.117)

Un petit cours de cuisine avec Denise cette semaine

Vidéo Garlic

Bon appétit!!!

J'ai ajouté la détection pour les processus en background comme petit test

ORACLE_HOME=/u01/app/oracle/product/8.1.7
ORACLE_OWNER=oracle

if [ ! -f $ORACLE_HOME/bin/dbstart ]
then
    echo "Oracle startup: cannot start"
    exit
fi

case "$1" in
    'start')
        # Start the Oracle databases:
        # will not prompt the user for any values
        ps aux|grep -q ' ora_';
        [ "$?" -eq 0 ] && { echo "Oracle is already running...";} || {
                                su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
                                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart
                        }
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        ps aux|grep -q ' ora_';
         [ "$?" -eq 0 ] && {
                                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut
                                su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"
                        } || { echo "Oracle is not running...";}
        ;;
      *)
        echo "Bad argument!!!";
        echo "Usage: $0 (start|stop)";
        ;;
esac

Suite aux judicieux conseils de Vincent Rogier - l'auteur de OCILIB - et contrairement à mes dires, j'ai finalement réussi à compiler Ocilib 3.4.0 avec Oracle 8.1.7.4.0.et effectuer mes tests

1. Installation

Conformément à ma documentation sur Oracle 8i, on chroot et on installe

wget "http://downloads.sourceforge.net/project/orclib/OCILIB%20Sources/3.4.0/ocilib-3.4.0-gnu.tar.gz?use_mirror=freefr" -q -O - | tar -xzf -
cd ocilib-3.4.0/
LDFLAGS="-L$ORACLE_HOME/lib/ -lclient8"  CPPFLAGS="-I$ORACLE_HOME/rdbms/demo" ./configure && make && make install

2. Petits tests

Le même programme que le précédent billet

monroe:~/ocilib-test# cat connection1.c
#include "ocilib.h"
  
int main(void)
{
  OCI_Connection *cn;
  
  if (!OCI_Initialize(NULL, NULL, OCI_ENV_DEFAULT))
    return EXIT_FAILURE;
  
  cn = OCI_ConnectionCreate("webmedia", "udweb", "udweb", OCI_SESSION_DEFAULT);
  
  if (cn != NULL)
  {
    printf(OCI_GetVersionServer(cn));
    
    printf("Server major    version : %i\n", OCI_GetServerMajorVersion(cn));
    printf("Server minor    version : %i\n", OCI_GetServerMinorVersion(cn));
    printf("Server revision version : %i\n", OCI_GetServerRevisionVersion(cn));
    
    printf("Connection      version : %i\n", OCI_GetVersionConnection(cn));

    OCI_ConnectionFree(cn);
  }
  
  OCI_Cleanup();
  
  return EXIT_SUCCESS;
}      

En ayant le Makefile suivant:

INCS =  -I/usr/local/include
CFLAGS = -DOCI_IMPORT_LINKAGE -DOCI_CHARSET_ANSI
LDFLAGS= -L/u01/app/oracle/product/8.1.7/lib -lclntsh  -L/usr/local/lib -locilib
CC = gcc
SRCS = connection1.c
OBJS = $(SRCS:.c=.o)

all: connection1

demo: $(OBJS)
	$(CC) $(LDFLAGS) -o $@ $(OBJS)

.c.o:
	$(CC) $(INCS) $(CFLAGS) -c -o $@ $<

clean: 
	rm -f *~ $(OBJS)

on compile et on test

monroe:~/ocilib-test# make
gcc -I/usr/local/include -DOCI_IMPORT_LINKAGE -DOCI_CHARSET_ANSI -c -o connection1.o connection1.c
gcc -L/u01/app/oracle/product/8.1.7/lib -lclntsh  -L/usr/local/lib -locilib  connection1.o   -o connection1
monroe:~/ocilib-test# ./connection1 
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - ProductionServer major    version : 8
Server minor    version : 1
Server revision version : 8
Connection      version : 0