Need help with yum,python and php in CentOS. (I made a complete mess!)
- by pek
a while back I wanted to install some plugins for Trac but it required python 2.5 I tried installing it (I don't remember how) and the only thing I managed was to have two versions of python (2.4 and 2.5). Trac still uses the old version but the console uses 2.5 (python -V = Python 2.5.2). Anyway, the problem is not python, the problem is yum (which uses python).
I am trying to upgrade my PHP version from 5.1.x to 5.2.x. I tried following this tutorial but when I reach the step with yum I get this error:
>[root@XXX]# yum update
Loading "installonlyn" plugin
Setting up Update Process
Setting up repositories
Reading repository metadata in from local files
Traceback (most recent call last):
File "/usr/bin/yum", line 29, in ?
yummain.main(sys.argv[1:])
File "/usr/share/yum-cli/yummain.py", line 94, in main
result, resultmsgs = base.doCommands()
File "/usr/share/yum-cli/cli.py", line 381, in doCommands
return self.yum_cli_commands[self.basecmd].doCommand(self, self.basecmd, self.extcmds)
File "/usr/share/yum-cli/yumcommands.py", line 150, in doCommand
return base.updatePkgs(extcmds)
File "/usr/share/yum-cli/cli.py", line 672, in updatePkgs
self.doRepoSetup()
File "/usr/share/yum-cli/cli.py", line 109, in doRepoSetup
self.doSackSetup(thisrepo=thisrepo)
File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 338, in doSackSetup
self.repos.populateSack(which=repos)
File "/usr/lib/python2.4/site-packages/yum/repos.py", line 200, in populateSack
sack.populate(repo, with, callback, cacheonly)
File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 91, in populate
dobj = repo.cacheHandler.getPrimary(xml, csum)
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 100, in getPrimary
return self._getbase(location, checksum, 'primary')
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 86, in _getbase
(db, dbchecksum) = self.getDatabase(location, metadatatype)
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 82, in getDatabase
db = self.makeSqliteCacheFile(filename,cachetype)
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 245, in makeSqliteCacheFile
self.createTablesPrimary(db)
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 165, in createTablesPrimary
cur.execute(q)
File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 244, in execute
self.rs = self.con.db.execute(SQL)
_sqlite.DatabaseError: near "release": syntax error
Any help?
Thank you.
Update
OK, so I've managed to update yum hoping it would solve my problems but now I get a slightly different version of the same error:
[root@XXX]# yum -y update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: mirror.skiplink.com
* base: www.gtlib.gatech.edu
* epel: mirrors.tummy.com
* extras: yum.singlehop.com
* updates: centos-distro.cavecreek.net
(process:30840): GLib-CRITICAL **: g_timer_stop: assertion `timer != NULL' failed
(process:30840): GLib-CRITICAL **: g_timer_destroy: assertion `timer != NULL' failed
Traceback (most recent call last):
File "/usr/bin/yum", line 29, in ?
yummain.user_main(sys.argv[1:], exit_code=True)
File "/usr/share/yum-cli/yummain.py", line 309, in user_main
errcode = main(args)
File "/usr/share/yum-cli/yummain.py", line 178, in main
result, resultmsgs = base.doCommands()
File "/usr/share/yum-cli/cli.py", line 345, in doCommands
self._getTs(needTsRemove)
File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 101, in _getTs
self._getTsInfo(remove_only)
File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 112, in _getTsInfo
pkgSack = self.pkgSack
File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 661, in <lambda>
pkgSack = property(fget=lambda self: self._getSacks(),
File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 501, in _getSacks
self.repos.populateSack(which=repos)
File "/usr/lib/python2.4/site-packages/yum/repos.py", line 260, in populateSack
sack.populate(repo, mdtype, callback, cacheonly)
File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 190, in populate
dobj = repo_cache_function(xml, csum)
File "/usr/lib/python2.4/site-packages/sqlitecachec.py", line 42, in getPrimary
self.repoid))
TypeError: Can not create packages table: near "release": syntax error
I'm guessing that this "release" thing has something to do with a repository, but I didn't find anything...
I went to the sqlitecachec.py at line 42 which writes (line numbers added for convenience):
39: return self.open_database(_sqlitecache.update_primary(location,
40: checksum,
41: self.callback,
42: self.repoid))
Update 2
I think I found the problem. This post suggests that the problem is sqlite and not yum. The version of sqlite I have installed is 3.6.10 but I have no idea which version does python 2.4 uses. ld.so.config contains the following:
include ld.so.conf.d/*.conf
/usr/local/lib
In folder /usr/local/lib I find a symbolic link named libsqlite3.so that points to libsqlite3.so.0.8.6
WHAT IS HAPPENING??????? :S
