[Spacewalk-list] Error registering clients on 2.1

[Milan Zázrivec]

On Monday 09 June 2014 16:12:37 Matthew Rinella wrote:
> I setup a new spacewalk 2.1 installation last week, using the latest
> available bits, and have not been able to register any clients.   The
> rhn_server_xmlrpc.log contains the following for all tries:
> 
> 2014/06/09 12:06:05 -04:00 723 172.19.4.7:
> xmlrpc/registration.welcome_message('lang: None',) 2014/06/09 12:06:05
> -04:00 718 172.19.4.7: xmlrpc/registration.welcome_message('lang: None',)
> 2014/06/09 12:06:05 -04:00 719 172.19.4.7:
> xmlrpc/registration.create_system("token = '1-rhel6-infr'", '6Server',
> 'x86_64') 2014/06/09 12:06:06 -04:00 719 172.19.4.7:
> rhnServer/server_token.process_token(1000010004,
> 'enterprise_entitled,monitoring_entitled,provisioning_entitled') 2014/06/09
> 12:06:06 -04:00 715 172.19.4.7: xmlrpc/registration.welcome_message('lang:
> None',) 2014/06/09 12:06:06 -04:00 712 172.19.4.7:
> xmlrpc/registration.__add_hw_profile_no_auth(1000010004, 'items: 7')
> 2014/06/09 12:06:07 -04:00 722 172.19.4.7:
> xmlrpc/registration.welcome_message('lang: None',) 2014/06/09 12:06:07
> -04:00 723 172.19.4.7: xmlrpc/registration.add_packages(1000010004,
> 'packages: 707') 2014/06/09 12:06:07 -04:00 723 172.19.4.7:
> server/apacheRequest.call_function('ERROR', 'Unhandled exception',
> IntegrityError('new row for relation "rhnpackageevr" violates check
> constraint "vn_rhnpackageevr_release"\nCONTEXT:  Error occurred on dblink
> connection named "at_conn": could not execute command.\nSQL statement
> "SELECT  dblink_exec(\'at_conn\',  $1 , true)"\nPL/pgSQL function
> "pg_dblink_exec" line 7 at PERFORM\nSQL statement "SELECT  pg_dblink_exec(
> \'insert into rhnPackageEVR(id, epoch, version, release, evr) values (\' ||
>  $1  || \', \' ||  $2  || \', \' ||  $3  || \', \' ||  $4  || \', evr_t(\'
> ||  $2  || \', \' ||  $3  || \', \' ||  $4  || \'))\' )"\nPL/pgSQL function
> "lookup_evr" line 18 at PERFORM\n',))

This means that one or more of the packages installed on the registering
system have the release field set to '' (empty string), which is rather
weird (Spacewalk doesn't allow that).

You should probably look at what's installed on the problematic system
and / or try to register without the package profile upload (rhnreg_ks
--nopackages or run rhn_register and uncheck the package profile upload
at one of its screens).

-MZ