[CentOS] Python/sqlite date time problems.

Tue Oct 10 15:43:50 UTC 2006
Bryan Cardillo <dillo at pcbi.upenn.edu>

On Tue, Oct 10, 2006 at 03:59:42PM +0100, Will McDonald wrote:
> Bear with me, this is CentOS related. :)

        [...]

> As far as I can tell, python, sqlite and python-sqlite are all identical.
> 
> [root at willspc python]# rpm -qa | grep -Ei '(sqlite)|(python)' | sort
> libxml2-python-2.6.16-6
> mod_python-3.1.3-5.1
> python-2.3.4-14.2
> python-elementtree-1.2.6-4.2.1
> python-sqlite-1.1.7-1.2
> python-urlgrabber-2.9.8-2
> rpm-python-4.3.3-18_nonptl
> sqlite-3.3.3-1.2
> 
> On the upgraded system...
> 
> [root at devmon1 python]# rpm -qa | grep -Ei '(sqlite)|(python)' | sort
> libxml2-python-2.6.16-6
> mod_python-3.1.3-5.1
> MySQL-python-1.0.0-1.RHEL4.1
> python-2.3.4-14.2
> python-clearsilver-0.10.1-1.2.el4.rf
> python-elementtree-1.2.6-7.el4.rf
> python-sqlite-1.1.7-1.2
> python-urlgrabber-2.9.8-2
> rpm-python-4.3.3-18_nonptl
> sqlite-3.3.3-1.2
> sqlite-devel-3.3.3-1.2
> 
> Obviously there some date/time issues but I can't pinpoint exactly
> what. Can anyone shed any light or prod me in the right direction? The
> Whitebox systems *do* still have a smattering of Whitebox related
> RPMs...

        what about mx?  this rpm provides python modules which do
        date/time type conversion (and more), yet you haven't listed
        it above.  perhaps its installed on one machine, but not the
        other?

        on my centos 4 machine:
        $ rpm -q mx
        mx-2.0.5-3

        Cheers,
        Bryan Cardillo
        Penn Bioinformatics Core
        University of Pennsylvania