Archive for September, 2009
Maybe u met this problem when install PGSQL on CentOS 5.3
rpmlib(FileDigests) <= 4.6.0-1 is needed by pgdg-centos-8.5-1.noarch
we check the pgsql rpm release version
pgdg-centos-8.5-1.noarch [4 KiB] Changelog by Devrim GUNDUZ (2009-08-26):
pgdg-centos-8.4-1.noarch [4 KiB] Changelog by Devrim GUNDUZ (2008-09-03):
as far as we got, 8.5 is packaged recently, so the rpm-libs maybe very new.
to resolve this problem:
1. upgrade your system (rpm package)
as I searched, rpm 4.7.1 include rpmlib(FileDigests) <= 4.6.0-1
2. install 8.4
rpm -Uvh http://yum.pgsqlrpms.org/reporpms/8.4/pgdg-centos-8.4-1.noarch.rpm
btw: why the package in CentOS keep so old. coooool.
OpenSUSE/Debian/Ubuntu is better in new packages
If up2date throws some horrible Python errors and rpm says “rpmdb: Lock table is out of available locker entries”, you can restore your system to normality with the following:
rpmdb: Lock table is out of available locker entries
error: db4 error(22) from db->close: Invalid argument
error: cannot open Packages index using db3 – Cannot allocate memory (12)
error: cannot open Packages database in /var/lib/rpm
Make a backup of /var/lib/rpm in case you break something:
tar cvzf rpmdb-backup.tar.gz /var/lib/rpm
Remove the Berkeley databases that rpm uses:
Make rpm rebuild the databases from scratch (may take a short while):
Now, check rpm to make sure everything is okay:
rpm -qa | sort
Why does this happen?
When rpm accesses the Berkeley database files, it makes temporary locker entries within the tables while it searches for data. If you control-c your rpm processes often, this issue will occur much sooner because the locks are never cleared.
btw: opensuse/debian series didn’t happy that kind of problem.
I was looking for some issue tracker written in Php, there is jira (java) works well , but we want to install on Cpanel, so we need some project written in php. here is what i found, maybe can help you, if u have any other good projects, plz comment my post. tks.
no project, and in php
use Zope, and in Python, no Project
Work Tracker is a work tracking system written in PHP. This project is a fork of the Sourceforge Issue-Tracker project. While Issue-Tracker focuses mostly on tracking issues, Work Tracker tracks general work tasks.
it modify the name Issue-Tracker to Work Tracker
is written in Python
firstname.lastname@example.org / guest
email@example.com / administrator
Enterprise CRM and Groupware System
not good at project control, and user permission
IT Project Guide
use Postgresql , Php and Apache