mod_python error installing Koji

[Naveen Gavini]

Mike Bonnet wrote:
> On Wed, 2008-07-16 at 16:53 -0400, Naveen Gavini wrote:
>   
>> Hello all,
>>
>> We are trying to setup the Koji build system for our Centos and Fedora 
>> repositories. We are getting the errors below after following the setup 
>> guide.
>> We have tried numerous different things to attempt to correct the errors 
>> and nothing has worked. We initially thought it was an issue of what 
>> user it was
>> being run as and we changed users around this did not work. We changed 
>> various settings in our apache configuration and still no dice.
>> Here is the errors we are seeing on http://192.168.226.61/koji/:
>>
>> MOD_PYTHON ERROR
>>
>> ProcessId:      9453
>> Interpreter:    '127.0.0.1'
>>
>> ServerName:     '127.0.0.1'
>> DocumentRoot:   '/var/www/html'
>>
>> URI:            '/koji/'
>> Location:       None
>> Directory:      '/usr/share/koji-web/scripts/'
>> Filename:       '/usr/share/koji-web/scripts/index.py'
>> PathInfo:       ''
>>
>> Phase:          'PythonHandler'
>> Handler:        'mod_python.publisher'
>>
>> Traceback (most recent call last):
>>
>>   File "/usr/lib64/python2.4/site-packages/mod_python/importer.py", line 1537, in HandlerDispatch
>>     default=default_handler, arg=req, silent=hlist.silent)
>>
>>   File "/usr/lib64/python2.4/site-packages/mod_python/importer.py", line 1229, in _process_target
>>     result = _execute_target(config, req, object, arg)
>>
>>   File "/usr/lib64/python2.4/site-packages/mod_python/importer.py", line 1128, in _execute_target
>>     result = object(arg)
>>
>>   File "/usr/lib64/python2.4/site-packages/mod_python/publisher.py", line 213, in handler
>>     published = publish_object(req, object)
>>
>>   File "/usr/lib64/python2.4/site-packages/mod_python/publisher.py", line 425, in publish_object
>>     return publish_object(req,util.apply_fs_data(object, req.form, req=req))
>>
>>   File "/usr/lib64/python2.4/site-packages/mod_python/util.py", line 554, in apply_fs_data
>>     return object(**args)
>>
>>   File "/usr/share/koji-web/scripts/index.py", line 175, in index
>>     start=buildStart, dataName='builds', prefix='build', order=buildOrder, pageSize=10)
>>
>>   File "/usr/share/koji-web/lib/kojiweb/util.py", line 109, in paginateMethod
>>     totalRows = getattr(server, methodName)(*args, **kw)
>>
>>   File "/usr/lib/python2.4/site-packages/koji/__init__.py", line 1077, in __call__
>>     return self.__func(self.__name,args,opts)
>>
>>   File "/usr/lib/python2.4/site-packages/koji/__init__.py", line 1302, in _callMethod
>>     return proxy.__getattr__(name)(*args)
>>
>>   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 1137, in request
>>     headers
>>
>> ProtocolError: <ProtocolError for 192.168.226.61/kojihub: 500 Internal Server Error>
>>
>>
>> MODULE CACHE DETAILS
>>
>> Accessed:       Wed Jul 16 16:47:56 2008
>> Generation:     1
>>
>> _mp_0dec3ca8c086f5baed01b0d5504fa2b0 {
>>   FileName:     '/usr/share/koji-web/scripts/index.py'
>>   Instance:     1
>>   Generation:   1
>>   Modified:     Fri Dec 14 21:12:36 2007
>>   Imported:     Wed Jul 16 16:36:02 2008
>> }
>>
>>
>> Here is the error we are seeing on http://192.168.226.61/koji/index.chtml:
>> Forbidden
>> You don't have permission to access /koji/index.chtml on this server.
>>
>> Here is the error we are seeing on http://192.168.226.61/kojihub:
>> Internal Server Error
>> blah blah blah
>>
>> http://192.168.226.61/koji-static/
>> Displays a directory listing of a few files and directories so I am 
>> assuming it is working correctly.
>>     
>
> You should see more detailed error messages in /var/log/httpd/error_log
> (or ssl_error_log, depending on your setup).  I'm guessing the "apache"
> OS user does not have permission to connect to the "koji" database as
> the "koji" database user.  You need to grant the appropriate access in
> pg_hba.conf.
>
>   
We were able to fix this:

Our problem was that our pg_hba.conf file was in the wrong order.

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          ident sameuser
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser
#koji line
host    koji        koji        127.0.0.1/32          trust

Moving the koji line to the top instead of the bottom fixed it.

Thanks for all the help.

-- 
Naveen Gavini
Student Systems Programmer
OSS/CSS - OIT Rutgers
ngavini at jla.rutgers.edu