17 Responses to “Configuring Spacewalk to import CentOS Errata”

1. Melvin says:

   December 5, 2010 at 8:49 pm

   Finally, I found the information I was looking for. I have looked for information of this caliber for the last several hours. Your site is greatly appreciated.

   Reply
2. Ruud says:

   January 7, 2011 at 10:27 pm

   Good information, works now fine form me.

   Thanks

   Reply
3. Kobus says:

   February 3, 2011 at 4:17 pm

   Thanks, infor greatly appreciated.

   Reply
4. Phil says:

   February 7, 2011 at 9:29 pm

   This is great information, I’m almost there. The snag I’m hung on at the moment is that my .rpms are not in /var/satellite .. they’re in /var/satellite/redhat/1/ and in their own directories from there. How can I get the script to search through those directories and find the appropriate rpm?

   Reply
5. William Edwards says:

   February 10, 2011 at 6:58 pm

   Hello Phil,

   The script should still associate the errata with packages stored in the database. The script should recursively look into the /var/satellite directory for the packages associated with the errata. As long as the script is configured to point to /var/satellite, it should work correctly.

   Regards,
   William

   Reply
6. PomTom says:

   February 18, 2011 at 1:03 pm

   Same problem here – all RPMs are stored somewhere beneath /var/satellite.

   The script seems to expect the RPMs directly in the directory specified in the config file and then quits with an error since the RPMs are not there.

   Reply
7. Smooth_p says:

   March 9, 2011 at 3:13 pm

   Am facing the same issue as mentioned above, the directory is structured like – /var/satellite/redhat/1/, has anyone figured a workaround?

   Reply
8. Laurent says:

   April 11, 2011 at 12:31 pm

   Unit what version of spacewalk did this work for you?

   Reply
9. Laurent says:

   April 11, 2011 at 12:32 pm

   Sorry I mean until which version of spacewalk did this work for you?

   Reply
10. David says:

    June 2, 2011 at 2:42 pm

    Same problem over here. Spacewalk version 1.4.
    I used:

    package_dir=/data/satellite/
    (That’s were packages are stored on my system)

    But an update to the gimp rpm for example lives in:

    /data/satellite/redhat/2/792/gimp/2.2.13-2.0.7.el5_6.2/i386/792c1e1451c5ffd44a1433468f5de4d1/gimp-2.2.13-2.0.7.el5_6.2.i386.rpm

    The centos-errata.py script is unable to find it (version 0.2 as well as 0.3) because it’s looking for:

    /data/satellite/gimp-2.2.13-2.0.7.el5_6.2.i386.rpm

    Perhaps the script maintainer(s) can provide us with an update?

    Reply
11. David says:

    June 3, 2011 at 9:00 pm

    Extra information,

    From the rhn_web_api.log on my spacewalk server I can see the requests coming in. For each package I see one ‘packages.search.name’ and 5 ‘packages.getDetails’ requests. But at the end of the process I see these kind of lines in the api.log:

    [2011-06-03 23:06:25,519] ERROR – REQUESTED FROM: *callerIp* CALL: errata.getDetails(3518x8f9278f129f4f799760f4458c2685d22, CESA-2011:0486) CALLER: (david) TIME: 0.007 seconds
    redstone.xmlrpc.XmlRpcFault: unhandled internal exception: could not execute query

    On the centos-errata.py console (which I execute on the Spacewalk server itself by the way) I see this output for each unfound package:

    Spacewalk search failed: falling back to searching /data/satellite/ for cpuspeed-1.2.1-10.el5.i386.rpm
    process_pkg_file failed with exception [Errno 2] No such file or directory: ‘/data/satellite/cpuspeed-1.2.1-10.el5.i386.rpm’.
    Traceback (most recent call last):
    File “./centos-errata.py”, line 671, in process_pkg_file
    fd = os.open(pkgfile, os.O_RDONLY)
    OSError: [Errno 2] No such file or directory: ‘/data/satellite/cpuspeed-1.2.1-10.el5.i386.rpm’

    and:

    At the end I get some errors like these:

    An exception occured when communicating with the server. Skipping erratum CEBA-2011:0825. Reason:

    Traceback (most recent call last):
    File “./centos-errata.py”, line 1031, in main
    if not session.getErrataDetails(erratum.advisoryName) is None:
    File “./centos-errata.py”, line 455, in getErrataDetails
    result = self.server.errata.getDetails(self.rhnSessionKey,advisoryName)
    File “/usr/lib64/python2.4/xmlrpclib.py”, line 1096, in __call__
    return self.__send(self.__name, args)
    File “/usr/lib64/python2.4/xmlrpclib.py”, line 1383, in __request
    verbose=self.__verbose
    File “/usr/lib64/python2.4/xmlrpclib.py”, line 1147, in request
    return self._parse_response(h.getfile(), sock)
    File “/usr/lib64/python2.4/xmlrpclib.py”, line 1286, in _parse_response
    return u.close()
    File “/usr/lib64/python2.4/xmlrpclib.py”, line 744, in close
    raise Fault(**self._stack[0])

    Hope someone can help me out.

    Reply
12. Robert says:

    June 4, 2011 at 8:26 am

    Same problem here with SpaceWalk 1.4.

    Workaround: Create Symlinks via CRON …

    I created a Cron which does:

    cd /var/satellite/redhat && ./do_link.sh

    –content of do_link.sh–

    #!/bin/bash

    for i in $(find . -type f -name *.rpm); do
    BASENAME=$(basename $i)
    if [ ! -L $BASENAME ]; then
    echo “Linking $i to $BASENAME …”
    ln -s $i $BASENAME
    fi
    done

    Reply
13. Tarak Ranjan says:

    July 22, 2011 at 10:09 am

    Hi Robert,

    Really gr8 script. One issue I am facing with this script is, after repo-sync if I run the script on the same location for 2nd time then it throws the below error .

    [root@spacewalk satellite]# ./do_link.sh
    find: paths must precede expression
    Usage: find [-H] [-L] [-P] [path...] [expression]

    /\
    dE

    Reply
14. Puneet says:

    August 2, 2011 at 7:08 pm

    Robert,

    how often do you run the do_link.sh script in cron?

    Thanks,

    Reply
15. MikeE says:

    September 2, 2011 at 4:30 pm

    for those: “paths must precede expression” errors (which will show the 2nd time you run the doLinks script), change the script:

    from:
    for i in $(find . -type f -name *.rpm); do

    to:
    for i in $(find . -type f -name ‘*.rpm’); do

    Reply
16. Fran says:

    January 20, 2012 at 1:09 pm

    Hello! Thanks for the script!

    I have done an improvement in doLinks to search the files throug the database, it may speed up the process:

    #!/bin/bash

    read_sql_stmt() {
    echo ”
    set feedback off verify off heading off pagesize 0 line 1000
    $1;
    exit
    ” | sqlplus -s $user/$passwd@SPACEWALKDB
    }

    file=$1
    if [ "$file" ]; then
    grep rpm $file | cut -d ‘ ‘ -f3 | grep -v ‘^[ ]*$’ | while read pkt; do
    echo -n “Processing $pkt: ”
    SQL=”SELECT P.PATH FROM RHNPACKAGE P WHERE P.PATH LIKE ‘%$pkt%’”
    found=$(read_sql_stmt “$SQL”)
    if [ $found ]; then
    BASENAME=$(basename $found)
    TARGET=/var/satellite/$found
    if [ -f $TARGET ]; then
    #echo “Linking /var/satellite/$i to /var/test/$BASENAME”
    ln -s $TARGET /var/test/$BASENAME
    echo “OK”
    else
    echo “FILE NOT FOUND”
    fi
    else
    echo “NOT IN DB”
    fi

    done
    fi

    Yo have to pass the file in text format to the script doLinks.

    Salu2

    Reply
17. Steve Meier says:

    September 18, 2012 at 12:40 pm

    Hello,

    I hope it is not inappropriate to comment that I have also written a tool that imports CentOS Errata into Spacewalk which has some additonal Features like CVEs, Errata Selection and more.

    If you are interested you can find it at -> http://cefs.steve-meier.de

    Kind regards,
    Steve

    Reply