Re: [Spacewalk-list] SQL error in SSM after update to 2.9

2019-02-07 Thread Hailer, Christian
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Doesn't anybody else experience this problem? Is there anybody out there using 
Spacewalk 2.9 with Oracle?

Regards, Christian

- -Ursprüngliche Nachricht-
Von: spacewalk-list-boun...@redhat.com  Im 
Auftrag von Hailer, Christian
Gesendet: Freitag, 1. Februar 2019 07:28
An: spacewalk-list@redhat.com
Betreff: [Spacewalk-list] SQL error in SSM after update to 2.9

* PGP Signed: 02/01/2019 at 07:28:15 AM

Hello all,

I recently updated Spacewalk from version 2.8 to 2.9. Since then I'm unable to 
manage multiple servers at once.
As soon as I select some servers on the "Systems" tab and click the "Manage" 
button, I get an internal server error. Looking at the Tomcat catalina.out log, 
I can see the following SQL error:


2019-02-01 07:14:02,504 [TP-Processor11] ERROR 
com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing 
cached statement sql: SELECT COUNT(*) as count
  FROM rhnSet
  WHERE
rhnSet.user_id = ? AND
rhnSet.label = ? AND (
  SELECT COUNT(*)
FROM rhnServerFeaturesView
WHERE rhnSet.element = rhnServerFeaturesView.server_id
  AND rhnServerFeaturesView.label = ?
) = 0;
com.redhat.rhn.common.db.WrappedSQLException: ORA-00933: SQL command not 
properly ended

at 
com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82)
at 
com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
at 
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:143)
at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:414)
at 
com.redhat.rhn.common.db.datasource.CachedStatement.internalExecute(CachedStatement.java:293)
at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:232)
at 
com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:90)
at 
com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57)
at 
com.redhat.rhn.manager.system.SystemManager.countSystemsInSetWithoutFeature(SystemManager.java:1333)
at 
com.redhat.rhn.common.security.acl.Access.aclAllSystemsInSetHaveFeature(Access.java:208)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.redhat.rhn.common.security.acl.Acl.evalAcl(Acl.java:470)
at com.redhat.rhn.frontend.nav.AclGuard.canRender(AclGuard.java:69)
at 
com.redhat.rhn.frontend.nav.RenderGuardComposite.canRender(RenderGuardComposite.java:49)
at com.redhat.rhn.frontend.nav.Renderable.canRender(Renderable.java:126)
at 
com.redhat.rhn.frontend.nav.DialognavRenderer.navNodeInactive(DialognavRenderer.java:102)
at 
com.redhat.rhn.frontend.nav.RenderEngine.renderLevel(RenderEngine.java:96)
at com.redhat.rhn.frontend.nav.RenderEngine.render(RenderEngine.java:58)
at 
com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.render(RenderUtils.java:148)
at 
com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:132)
at 
com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:73)
at 
com.redhat.rhn.frontend.taglibs.NavMenuTag.doStartTag(NavMenuTag.java:53)
at 
org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspx_meth_rhn_005fdialogmenu_005f0(Unknown
 Source)
at 
org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspService(Unknown Source)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083)
at 
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396)
at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232)
at 

Re: [Spacewalk-list] Cannot sync confluent (debian) repository to Spacewalk repo

2019-02-07 Thread Robert Paschedag
Am 7. Februar 2019 18:18:51 MEZ schrieb Ihor Lawrin :
>I forgot to mention that the Ubuntu client is able to install the
>Confluent software (using the Confluent install procedure) when it has
>access to the internet. 
>We want to have the software available via Spacewalk so that we don't
>have to connect all our clients to the internet.
>
>Hope this helps.
>
>
>Ihor Lawrin
>Technical Services
>Senior System Administrator (UNIX)
>Delta Dental of Michigan, Ohio, and Indiana
>(517) 381-4207 Direct Line
>(517) 648-7312 Cell
>
>
>ISO 9001 Quality Certified  •  Certified Call Center of Excellence  • 
>Rated A (Excellent) by A.M. Best Company
>
>
>
>-Original Message-
>From: Ihor Lawrin 
>Sent: Thursday, February 7, 2019 12:00 PM
>To: spacewalk-list@redhat.com; Robert Paschedag
>
>Subject: RE: [Spacewalk-list] Cannot sync confluent (debian) repository
>to Spacewalk repo
>
>I'm guessing that it might be the way the debian repository is
>configured on the Confluent site.
>1. We're able to sync update/base/security repos.
>2. We're also able to sync the "rpm" repo from the Confluent site. Just
>not able to sync the "deb" version
>
>Ihor Lawrin
>Technical Services
>Senior System Administrator (UNIX)
>Delta Dental of Michigan, Ohio, and Indiana
>(517) 381-4207 Direct Line
>(517) 648-7312 Cell
>
>
>ISO 9001 Quality Certified  •  Certified Call Center of Excellence  • 
>Rated A (Excellent) by A.M. Best Company
>
>
>
>-Original Message-
>From: spacewalk-list-boun...@redhat.com
> On Behalf Of Ihor Lawrin
>Sent: Thursday, February 7, 2019 11:54 AM
>To: Robert Paschedag ;
>spacewalk-list@redhat.com; spacewalk-list@redhat.com
>Subject: Re: [Spacewalk-list] Cannot sync confluent (debian) repository
>to Spacewalk repo
>
>Looks like the same messages
>
>[root@c7spcwlk29tst01 rhn]# cat reposync/confluent-ubuntu-amd64.log |
>grep "2019/02/07 08:20"
>2019/02/07 08:20:45 -04:00 Command: ['/usr/bin/spacewalk-repo-sync',
>'-vv', '--channel', 'confluent-ubuntu-amd64']
>2019/02/07 08:20:45 -04:00 Sync of channel started.
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>server/rhnChannel.channel_info('confluent-ubuntu-amd64',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params("Converting query
>for PostgreSQL: \nselect\nca.label arch,\nc.id,\n  
>c.parent_channel,\nc.org_id,\nc.label,\n   
>c.name,\nc.summary,\nc.description,\n   
>to_char(c.last_modified, 'MMDDHH24MISS') last_modified\nfrom\n 
>rhnChannel c,\nrhnChannelArch ca\nwhere\n 
>c.channel_arch_id = ca.id\n  and c.label = :channel\n",)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params("New query: \n   
>select\nca.label arch,\nc.id,\n   
>c.parent_channel,\nc.org_id,\nc.label,\n   
>c.name,\nc.summary,\nc.description,\n   
>to_char(c.last_modified, 'MMDDHH24MISS') last_modified\nfrom\n 
>rhnChannel c,\nrhnChannelArch ca\nwhere\n 
>c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n",)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n   
>select\nca.label arch,\nc.id,\n   
>c.parent_channel,\nc.org_id,\nc.label,\n   
>c.name,\nc.summary,\nc.description,\n   
>to_char(c.last_modified, \'MMDDHH24MISS\') last_modified\n   
>from\nrhnChannel c,\nrhnChannelArch ca\nwhere\n
>c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n" with
>bind params: {channel: confluent-ubuntu-amd64}',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('Converting query
>for PostgreSQL: select s.id, s.source_url, s.label as repo_label,
>cst.label as repo_type_label\n  from
>rhnContentSource s,\n  
>rhnChannelContentSource cs,\n  
>rhnContentSourceType cst\n where s.id =
>cs.source_id\n   and cst.id =
>s.type_id\n   and cs.channel_id =
>:channel_id',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('New query: select
>s.id, s.source_url, s.label as repo_label, cst.label as
>repo_type_label\n  from
>rhnContentSource s,\n  
>rhnChannelContentSource cs,\n  
>rhnContentSourceType cst\n where s.id =
>cs.source_id\n   and cst.id =
>s.type_id\n   and cs.channel_id =
>%(channel_id)s',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:

Re: [Spacewalk-list] Cannot sync confluent (debian) repository to Spacewalk repo

2019-02-07 Thread Ihor Lawrin
I forgot to mention that the Ubuntu client is able to install the Confluent 
software (using the Confluent install procedure) when it has access to the 
internet. 
We want to have the software available via Spacewalk so that we don't have to 
connect all our clients to the internet.

Hope this helps.


Ihor Lawrin
Technical Services
Senior System Administrator (UNIX)
Delta Dental of Michigan, Ohio, and Indiana
(517) 381-4207 Direct Line
(517) 648-7312 Cell


ISO 9001 Quality Certified  •  Certified Call Center of Excellence  •  Rated A 
(Excellent) by A.M. Best Company



-Original Message-
From: Ihor Lawrin 
Sent: Thursday, February 7, 2019 12:00 PM
To: spacewalk-list@redhat.com; Robert Paschedag 
Subject: RE: [Spacewalk-list] Cannot sync confluent (debian) repository to 
Spacewalk repo

I'm guessing that it might be the way the debian repository is configured on 
the Confluent site.
1. We're able to sync update/base/security repos.
2. We're also able to sync the "rpm" repo from the Confluent site. Just not 
able to sync the "deb" version

Ihor Lawrin
Technical Services
Senior System Administrator (UNIX)
Delta Dental of Michigan, Ohio, and Indiana
(517) 381-4207 Direct Line
(517) 648-7312 Cell


ISO 9001 Quality Certified  •  Certified Call Center of Excellence  •  Rated A 
(Excellent) by A.M. Best Company



-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Ihor Lawrin
Sent: Thursday, February 7, 2019 11:54 AM
To: Robert Paschedag ; spacewalk-list@redhat.com; 
spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Cannot sync confluent (debian) repository to 
Spacewalk repo

Looks like the same messages

[root@c7spcwlk29tst01 rhn]# cat reposync/confluent-ubuntu-amd64.log | grep 
"2019/02/07 08:20"
2019/02/07 08:20:45 -04:00 Command: ['/usr/bin/spacewalk-repo-sync', '-vv', 
'--channel', 'confluent-ubuntu-amd64']
2019/02/07 08:20:45 -04:00 Sync of channel started.
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
server/rhnChannel.channel_info('confluent-ubuntu-amd64',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params("Converting query for 
PostgreSQL: \nselect\nca.label arch,\nc.id,\n
c.parent_channel,\nc.org_id,\nc.label,\nc.name,\n   
 c.summary,\nc.description,\nto_char(c.last_modified, 
'MMDDHH24MISS') last_modified\nfrom\nrhnChannel c,\n
rhnChannelArch ca\nwhere\n  c.channel_arch_id = ca.id\n  and 
c.label = :channel\n",)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params("New query: \nselect\n  
  ca.label arch,\nc.id,\nc.parent_channel,\n
c.org_id,\nc.label,\nc.name,\nc.summary,\n
c.description,\nto_char(c.last_modified, 'MMDDHH24MISS') 
last_modified\nfrom\nrhnChannel c,\nrhnChannelArch ca\n
where\n  c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n   
 ",)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\nselect\n   
 ca.label arch,\nc.id,\nc.parent_channel,\nc.org_id,\n  
  c.label,\nc.name,\nc.summary,\nc.description,\n   
 to_char(c.last_modified, \'MMDDHH24MISS\') last_modified\nfrom\n   
 rhnChannel c,\nrhnChannelArch ca\nwhere\n  
c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n" with bind 
params: {channel: confluent-ubuntu-amd64}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: select s.id, s.source_url, s.label as repo_label, cst.label as 
repo_type_label\n  from rhnContentSource s,\n   
rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n  
   where s.id = cs.source_id\n   and cst.id = 
s.type_id\n   and cs.channel_id = :channel_id',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: select s.id, 
s.source_url, s.label as repo_label, cst.label as repo_type_label\n 
 from rhnContentSource s,\n 
  rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n where s.id = 
cs.source_id\n   and cst.id = s.type_id\n   
and cs.channel_id = %(channel_id)s',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select s.id, 
s.source_url, s.label as repo_label, cst.label as repo_type_label\n

Re: [Spacewalk-list] Cannot sync confluent (debian) repository to Spacewalk repo

2019-02-07 Thread Ihor Lawrin
I'm guessing that it might be the way the debian repository is configured on 
the Confluent site.
1. We're able to sync update/base/security repos.
2. We're also able to sync the "rpm" repo from the Confluent site. Just not 
able to sync the "deb" version

Ihor Lawrin
Technical Services
Senior System Administrator (UNIX)
Delta Dental of Michigan, Ohio, and Indiana
(517) 381-4207 Direct Line
(517) 648-7312 Cell


ISO 9001 Quality Certified  •  Certified Call Center of Excellence  •  Rated A 
(Excellent) by A.M. Best Company



-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Ihor Lawrin
Sent: Thursday, February 7, 2019 11:54 AM
To: Robert Paschedag ; spacewalk-list@redhat.com; 
spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Cannot sync confluent (debian) repository to 
Spacewalk repo

Looks like the same messages

[root@c7spcwlk29tst01 rhn]# cat reposync/confluent-ubuntu-amd64.log | grep 
"2019/02/07 08:20"
2019/02/07 08:20:45 -04:00 Command: ['/usr/bin/spacewalk-repo-sync', '-vv', 
'--channel', 'confluent-ubuntu-amd64']
2019/02/07 08:20:45 -04:00 Sync of channel started.
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
server/rhnChannel.channel_info('confluent-ubuntu-amd64',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params("Converting query for 
PostgreSQL: \nselect\nca.label arch,\nc.id,\n
c.parent_channel,\nc.org_id,\nc.label,\nc.name,\n   
 c.summary,\nc.description,\nto_char(c.last_modified, 
'MMDDHH24MISS') last_modified\nfrom\nrhnChannel c,\n
rhnChannelArch ca\nwhere\n  c.channel_arch_id = ca.id\n  and 
c.label = :channel\n",)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params("New query: \nselect\n  
  ca.label arch,\nc.id,\nc.parent_channel,\n
c.org_id,\nc.label,\nc.name,\nc.summary,\n
c.description,\nto_char(c.last_modified, 'MMDDHH24MISS') 
last_modified\nfrom\nrhnChannel c,\nrhnChannelArch ca\n
where\n  c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n   
 ",)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\nselect\n   
 ca.label arch,\nc.id,\nc.parent_channel,\nc.org_id,\n  
  c.label,\nc.name,\nc.summary,\nc.description,\n   
 to_char(c.last_modified, \'MMDDHH24MISS\') last_modified\nfrom\n   
 rhnChannel c,\nrhnChannelArch ca\nwhere\n  
c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n" with bind 
params: {channel: confluent-ubuntu-amd64}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: select s.id, s.source_url, s.label as repo_label, cst.label as 
repo_type_label\n  from rhnContentSource s,\n   
rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n  
   where s.id = cs.source_id\n   and cst.id = 
s.type_id\n   and cs.channel_id = :channel_id',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: select s.id, 
s.source_url, s.label as repo_label, cst.label as repo_type_label\n 
 from rhnContentSource s,\n 
  rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n where s.id = 
cs.source_id\n   and cst.id = s.type_id\n   
and cs.channel_id = %(channel_id)s',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select s.id, 
s.source_url, s.label as repo_label, cst.label as repo_type_label\n 
 from rhnContentSource s,\n 
  rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n where s.id = 
cs.source_id\n   and cst.id = s.type_id\n   
and cs.channel_id = %(channel_id)s" with bind 
params: {channel_id: 104}',)
2019/02/07 08:20:45 -04:00
2019/02/07 08:20:45 -04:00   Processing repository with URL: 
https://urldefense.proofpoint.com/v2/url?u=https-3A__packages.confluent.io_deb_5.1=DwIGaQ=Jnf2Cp4PGnCPtuPxt-OIQR21MChqGaHuqvEjP9X2AA0=zQA-8DU7hTmTrVLxkxRj-fpO6YYASUH25bye7e5klwI=y6qRzr0XPvmExsrsikV6UCpphZSwebn2s_M4FL_mkjo=GUtZdb298kIUXgXFayPiJPN_V85j35v2n7AuizGMQdA=
2019/02/07 08:20:45 -04:00 1817 

Re: [Spacewalk-list] Continuing issues with ubuntu client and Spacewalk 2.9

2019-02-07 Thread James Krych
Sorry, I failed to show you what I did on the server side:
/usr/bin/spacewalk-repo-sync --channel ubuntu_16_security --type deb
/usr/bin/spacewalk-repo-sync --channel ubuntu_16_updates --type deb



--
--
James W. Krych
CCNP, CCNA, Net+, Security+, A+, Linux+
Mobile: 843-847-1446
james.w.kr...@gmail.com


On Thu, Feb 7, 2019 at 11:48 AM Robert Paschedag 
wrote:

> Am 7. Februar 2019 17:19:59 MEZ schrieb James Krych <
> james.w.kr...@gmail.com>:
> >*Syncing the repo again.*
> >
> This does *not* sync the repo! It only gets the metadata *for* the repo
> onto the client.
>
> The repo on the server (the channel) has to be updated.
>
> Robert
>
> >*That being done, this is the command I use to stop requesting diffs*
> >
> >#grouper-dev-loader-v:/root: !9949
> >apt-get update -o Acquire::Pdiffs=false
> >Apt-Spacewalk: Updating sources.list
> >Ign:1 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel InRelease
> >Ign:2 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security InRelease
> >Hit:3 http://us.archive.ubuntu.com/ubuntu xenial InRelease
> >Ign:4 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates InRelease
> >Ign:5 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel Release
> >Get:6 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease [109
> >kB]
> >Get:7 http://security.ubuntu.com/ubuntu xenial-security InRelease [109
> >kB]
> >Ign:8 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security Release
> >Ign:9
> >
> http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
> >InRelease
> >Ign:10 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates Release
> >Hit:11
> >
> http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
> >Release
> >Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
> >Packages
> >Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
> >Packages
> >Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
> >Packages
> >Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> >Translation-en_US
> >Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> >Translation-en
> >Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >amd64
> >Packages
> >Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >i386
> >Packages
> >Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >all
> >Packages
> >Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >Translation-en_US
> >Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >Translation-en
> >Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >amd64
> >Packages
> >Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >i386
> >Packages
> >Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >all
> >Packages
> >Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >Translation-en_US
> >Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >Translation-en
> >Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
> >Packages
> >Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
> >Packages
> >Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
> >Packages
> >Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> >Translation-en_US
> >Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> >Translation-en
> >Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >amd64
> >Packages
> >Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >i386
> >Packages
> >Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >all
> >Packages
> >Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >Translation-en_US
> >Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >Translation-en
> >Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >amd64
> >Packages
> >Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >i386
> >Packages
> >Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >all
> >Packages
> >Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >Translation-en_US
> >Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> >Translation-en
> >Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
> >Packages
> >Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
> >Packages
> >Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
> >Packages
> >Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> >Translation-en_US
> >Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> >Translation-en
> >Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> >amd64
> >Packages

Re: [Spacewalk-list] Cannot sync confluent (debian) repository to Spacewalk repo

2019-02-07 Thread Ihor Lawrin
Looks like the same messages

[root@c7spcwlk29tst01 rhn]# cat reposync/confluent-ubuntu-amd64.log | grep 
"2019/02/07 08:20"
2019/02/07 08:20:45 -04:00 Command: ['/usr/bin/spacewalk-repo-sync', '-vv', 
'--channel', 'confluent-ubuntu-amd64']
2019/02/07 08:20:45 -04:00 Sync of channel started.
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
server/rhnChannel.channel_info('confluent-ubuntu-amd64',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params("Converting query for 
PostgreSQL: \nselect\nca.label arch,\nc.id,\n
c.parent_channel,\nc.org_id,\nc.label,\nc.name,\n   
 c.summary,\nc.description,\nto_char(c.last_modified, 
'MMDDHH24MISS') last_modified\nfrom\nrhnChannel c,\n
rhnChannelArch ca\nwhere\n  c.channel_arch_id = ca.id\n  and 
c.label = :channel\n",)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params("New query: \nselect\n  
  ca.label arch,\nc.id,\nc.parent_channel,\n
c.org_id,\nc.label,\nc.name,\nc.summary,\n
c.description,\nto_char(c.last_modified, 'MMDDHH24MISS') 
last_modified\nfrom\nrhnChannel c,\nrhnChannelArch ca\n
where\n  c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n   
 ",)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\nselect\n   
 ca.label arch,\nc.id,\nc.parent_channel,\nc.org_id,\n  
  c.label,\nc.name,\nc.summary,\nc.description,\n   
 to_char(c.last_modified, \'MMDDHH24MISS\') last_modified\nfrom\n   
 rhnChannel c,\nrhnChannelArch ca\nwhere\n  
c.channel_arch_id = ca.id\n  and c.label = %(channel)s\n" with bind 
params: {channel: confluent-ubuntu-amd64}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: select s.id, s.source_url, s.label as repo_label, cst.label as 
repo_type_label\n  from rhnContentSource s,\n   
rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n  
   where s.id = cs.source_id\n   and cst.id = 
s.type_id\n   and cs.channel_id = :channel_id',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: select s.id, 
s.source_url, s.label as repo_label, cst.label as repo_type_label\n 
 from rhnContentSource s,\n 
  rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n where s.id = 
cs.source_id\n   and cst.id = s.type_id\n   
and cs.channel_id = %(channel_id)s',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select s.id, 
s.source_url, s.label as repo_label, cst.label as repo_type_label\n 
 from rhnContentSource s,\n 
  rhnChannelContentSource cs,\n   
rhnContentSourceType cst\n where s.id = 
cs.source_id\n   and cst.id = s.type_id\n   
and cs.channel_id = %(channel_id)s" with bind 
params: {channel_id: 104}',)
2019/02/07 08:20:45 -04:00
2019/02/07 08:20:45 -04:00   Processing repository with URL: 
https://packages.confluent.io/deb/5.1
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: \nselect k1.description as ca_cert_name, 
k1.key as ca_cert, k1.org_id as ca_cert_org,\n   
k2.description as client_cert_name, k2.key as client_cert, k2.org_id as 
client_cert_org,\n   k3.description as 
client_key_name, k3.key as client_key, k3.org_id as client_key_org\n
from rhncontentsource cs inner join\n 
rhncontentsourcessl csssl on cs.id = csssl.content_source_id inner join\n   
  rhncryptokey k1 on csssl.ssl_ca_cert_id = k1.id left 
outer join\n rhncryptokey k2 on 
csssl.ssl_client_cert_id = k2.id left outer join\n 
rhncryptokey k3 on csssl.ssl_client_key_id = k3.id\n
where cs.id = :repo_id\n',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 

Re: [Spacewalk-list] Continuing issues with ubuntu client and Spacewalk 2.9

2019-02-07 Thread Robert Paschedag
Am 7. Februar 2019 17:19:59 MEZ schrieb James Krych :
>*Syncing the repo again.*
>
This does *not* sync the repo! It only gets the metadata *for* the repo onto 
the client.

The repo on the server (the channel) has to be updated.

Robert

>*That being done, this is the command I use to stop requesting diffs*
>
>#grouper-dev-loader-v:/root: !9949
>apt-get update -o Acquire::Pdiffs=false
>Apt-Spacewalk: Updating sources.list
>Ign:1 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel InRelease
>Ign:2 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security InRelease
>Hit:3 http://us.archive.ubuntu.com/ubuntu xenial InRelease
>Ign:4 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates InRelease
>Ign:5 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel Release
>Get:6 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease [109
>kB]
>Get:7 http://security.ubuntu.com/ubuntu xenial-security InRelease [109
>kB]
>Ign:8 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security Release
>Ign:9
>http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
>InRelease
>Ign:10 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates Release
>Hit:11
>http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
>Release
>Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
>Packages
>Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
>Packages
>Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
>Packages
>Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
>Translation-en_US
>Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
>Translation-en
>Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>amd64
>Packages
>Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>i386
>Packages
>Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>all
>Packages
>Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>Translation-en_US
>Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>Translation-en
>Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>amd64
>Packages
>Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>i386
>Packages
>Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>all
>Packages
>Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>Translation-en_US
>Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>Translation-en
>Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
>Packages
>Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
>Packages
>Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
>Packages
>Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
>Translation-en_US
>Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
>Translation-en
>Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>amd64
>Packages
>Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>i386
>Packages
>Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>all
>Packages
>Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>Translation-en_US
>Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>Translation-en
>Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>amd64
>Packages
>Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>i386
>Packages
>Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>all
>Packages
>Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>Translation-en_US
>Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>Translation-en
>Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
>Packages
>Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
>Packages
>Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
>Packages
>Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
>Translation-en_US
>Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
>Translation-en
>Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>amd64
>Packages
>Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>i386
>Packages
>Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>all
>Packages
>Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>Translation-en_US
>Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
>Translation-en
>Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>amd64
>Packages
>Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>i386
>Packages
>Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
>all
>Packages
>Ign:26 

Re: [Spacewalk-list] Continuing issues with ubuntu client and Spacewalk 2.9

2019-02-07 Thread James Krych
That looks like it worked. I take it that once the spacewalk packages have
been installed, and the system registered, that updates will be pulled from
the channels/repos on Spacewalk?

James
--
--
James W. Krych
CCNP, CCNA, Net+, Security+, A+, Linux+
Mobile: 843-847-1446
james.w.kr...@gmail.com


On Thu, Feb 7, 2019 at 11:19 AM James Krych  wrote:

> *Syncing the repo again.*
>
> *That being done, this is the command I use to stop requesting diffs*
>
> #grouper-dev-loader-v:/root: !9949
> apt-get update -o Acquire::Pdiffs=false
> Apt-Spacewalk: Updating sources.list
> Ign:1 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel InRelease
> Ign:2 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security InRelease
> Hit:3 http://us.archive.ubuntu.com/ubuntu xenial InRelease
> Ign:4 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates InRelease
> Ign:5 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel Release
> Get:6 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease [109
> kB]
> Get:7 http://security.ubuntu.com/ubuntu xenial-security InRelease [109 kB]
> Ign:8 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security Release
> Ign:9
> http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
> InRelease
> Ign:10 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates Release
> Hit:11
> http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
> Release
> Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
> Packages
> Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
> Packages
> Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
> Packages
> Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> Translation-en_US
> Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> Translation-en
> Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> amd64 Packages
> Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> i386 Packages
> Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata all
> Packages
> Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> Translation-en_US
> Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> Translation-en
> Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> amd64 Packages
> Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata i386
> Packages
> Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata all
> Packages
> Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> Translation-en_US
> Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> Translation-en
> Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
> Packages
> Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
> Packages
> Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
> Packages
> Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> Translation-en_US
> Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> Translation-en
> Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> amd64 Packages
> Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> i386 Packages
> Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata all
> Packages
> Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> Translation-en_US
> Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> Translation-en
> Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> amd64 Packages
> Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata i386
> Packages
> Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata all
> Packages
> Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> Translation-en_US
> Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
> Translation-en
> Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
> Packages
> Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
> Packages
> Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
> Packages
> Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> Translation-en_US
> Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
> Translation-en
> Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> amd64 Packages
> Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> i386 Packages
> Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata all
> Packages
> Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> Translation-en_US
> Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
> Translation-en
> Ign:23 spacewalk://spacewalk.mdc.musc.edu 

Re: [Spacewalk-list] Continuing issues with ubuntu client and Spacewalk 2.9

2019-02-07 Thread James Krych
*Syncing the repo again.*

*That being done, this is the command I use to stop requesting diffs*

#grouper-dev-loader-v:/root: !9949
apt-get update -o Acquire::Pdiffs=false
Apt-Spacewalk: Updating sources.list
Ign:1 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel InRelease
Ign:2 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security InRelease
Hit:3 http://us.archive.ubuntu.com/ubuntu xenial InRelease
Ign:4 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates InRelease
Ign:5 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel Release
Get:6 http://us.archive.ubuntu.com/ubuntu xenial-updates InRelease [109 kB]
Get:7 http://security.ubuntu.com/ubuntu xenial-security InRelease [109 kB]
Ign:8 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security Release
Ign:9
http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
InRelease
Ign:10 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates Release
Hit:11
http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/2.9:/debclients/xUbuntu_16.04
Release
Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
Packages
Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
Packages
Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
Packages
Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
Translation-en_US
Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
Translation-en
Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata amd64
Packages
Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata i386
Packages
Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata all
Packages
Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
Translation-en_US
Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
Translation-en
Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata amd64
Packages
Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata i386
Packages
Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata all
Packages
Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
Translation-en_US
Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
Translation-en
Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
Packages
Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
Packages
Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
Packages
Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
Translation-en_US
Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
Translation-en
Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata amd64
Packages
Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata i386
Packages
Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata all
Packages
Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
Translation-en_US
Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
Translation-en
Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata amd64
Packages
Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata i386
Packages
Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata all
Packages
Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
Translation-en_US
Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
Translation-en
Ign:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
Packages
Ign:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
Packages
Ign:15 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata all
Packages
Ign:16 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
Translation-en_US
Ign:17 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata
Translation-en
Ign:18 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata amd64
Packages
Ign:19 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata i386
Packages
Ign:20 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata all
Packages
Ign:21 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
Translation-en_US
Ign:22 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_security/repodata
Translation-en
Ign:23 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata amd64
Packages
Ign:24 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata i386
Packages
Ign:25 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata all
Packages
Ign:26 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
Translation-en_US
Ign:27 spacewalk://spacewalk.mdc.musc.edu ubuntu_16_updates/repodata
Translation-en
Get:12 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata amd64
Packages [20 B]
Get:14 spacewalk://spacewalk.mdc.musc.edu ubuntu_channel/repodata i386
Packages [20 B]
Get:15 

Re: [Spacewalk-list] Cannot sync confluent (debian) repository to Spacewalk repo

2019-02-07 Thread Robert Paschedag
Am 7. Februar 2019 14:26:03 MEZ schrieb Ihor Lawrin :
>I ran my sync with high verbosity hoping that someone can help with my
>sync failure...
>
>2019/02/07 08:20:45 -04:00 Command: ['/usr/bin/spacewalk-repo-sync',
>'-vv', '--channel', 'confluent-ubuntu-amd64']
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('Converting query
>for PostgreSQL: \n   select s.source_url, c.label\n
>from rhnContentSource s,\n  
>rhnChannelContentSource cs,\n   rhnChannel c\n 
>   where s.id = cs.source_id and cs.channel_id=c.id\n   ',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('New query: \n 
>select s.source_url, c.label\n   from
>rhnContentSource s,\n   rhnChannelContentSource
>cs,\n   rhnChannel c\n   where
>s.id = cs.source_id and cs.channel_id=c.id\n   ',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n  
>select s.source_url, c.label\n   from
>rhnContentSource s,\n   rhnChannelContentSource
>cs,\n   rhnChannel c\n   where
>s.id = cs.source_id and cs.channel_id=c.id\n   " with bind
>params: {}',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('Converting query
>for PostgreSQL: select 1',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('New query: select
>1',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select 1"
>with bind params: {}',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('Converting query
>for PostgreSQL: \nselect c1.label, c2.label parent_channel,
>c1.id\nfrom rhnChannel c1 left outer join rhnChannel c2 on
>c1.parent_channel = c2.id\norder by c2.label desc, c1.label
>asc\n',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('New query: \n 
>select c1.label, c2.label parent_channel, c1.id\nfrom
>rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel =
>c2.id\norder by c2.label desc, c1.label asc\n',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n   
>select c1.label, c2.label parent_channel, c1.id\nfrom
>rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel =
>c2.id\norder by c2.label desc, c1.label asc\n" with bind
>params: {}',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>server/rhnChannel.isCustomChannel(104,)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('Converting query
>for PostgreSQL: \nselect\nrcf.label\nfrom\n   
>rhnChannelFamily rcf,\nrhnChannelFamilyMembers rcfm\n   
>where\nrcfm.channel_id = :channel_id\nand
>rcfm.channel_family_id = rcf.id\nand rcf.org_id is not null\n  
> ',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('New query: \n   
>select\nrcf.label\nfrom\nrhnChannelFamily rcf,\n   
>rhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id =
>%(channel_id)s\nand rcfm.channel_family_id = rcf.id\n   
>and rcf.org_id is not null\n',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n   
>select\nrcf.label\nfrom\nrhnChannelFamily rcf,\n   
>rhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id =
>%(channel_id)s\nand rcfm.channel_family_id = rcf.id\n   
>and rcf.org_id is not null\n" with bind params: {channel_id:
>104}',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>server/rhnChannel.isCustomChannel(104, 'is a custom channel')
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>server/rhnChannel.isCustomChannel(101,)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('Converting query
>for PostgreSQL: \nselect\nrcf.label\nfrom\n   
>rhnChannelFamily rcf,\nrhnChannelFamilyMembers rcfm\n   
>where\nrcfm.channel_id = :channel_id\nand
>rcfm.channel_family_id = rcf.id\nand rcf.org_id is not null\n  
> ',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:
>rhnSQL/driver_postgresql.convert_named_query_params('New query: \n   
>select\nrcf.label\nfrom\nrhnChannelFamily rcf,\n   
>rhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id =
>%(channel_id)s\nand rcfm.channel_family_id = rcf.id\n   
>and rcf.org_id is not null\n',)
>2019/02/07 08:20:45 -04:00 1817 0.0.0.0:

Re: [Spacewalk-list] Continuing issues with ubuntu client and Spacewalk 2.9

2019-02-07 Thread Robert Paschedag
Am 7. Februar 2019 14:09:23 MEZ schrieb James Krych :
>*Sadly,*
>
>*I am still getting the TRACEBACK error regarding diffs. Message from
>today:*
>Exception reported from spacewalk
>Time: Thu Feb  7 04:55:20 2019
>Exception type 
>Exception while handling function repodata
>Request object information:
>URI: ///XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
>Remote Host: grouper-dev-loader-v.mdc.musc.edu
>Server Name: spacewalk.mdc.musc.edu:443
>Headers passed in:
>Accept-Encoding: identity
>CONTEXT_DOCUMENT_ROOT: /var/www/html
>CONTEXT_PREFIX:
>DOCUMENT_ROOT: /var/www/html
>GATEWAY_INTERFACE: CGI/1.1
>HTTP_ACCEPT_ENCODING: identity
>HTTP_HOST: spacewalk.mdc.musc.edu
>HTTP_X_RHN_AUTH: nL53lMc41V96u3uWpqa4tAArkXsFdl15WUjBfmzzDKQ=
>HTTP_X_RHN_AUTH_EXPIRE_OFFSET: 3600.0
>HTTP_X_RHN_AUTH_SERVER_TIME: 1549533319.96
>HTTP_X_RHN_AUTH_USER_ID:
>HTTP_X_RHN_SERVER_ID: 110001
>HTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
>Host: spacewalk.mdc.musc.edu
> PATH_INFO: /GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
>PATH_TRANSLATED:
>/var/www/html/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
>QUERY_STRING:
>REMOTE_ADDR: 128.23.182.201
>REMOTE_PORT: 59130
>REQUEST_METHOD: GET
>REQUEST_SCHEME: https
>REQUEST_URI:
>///XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
>SCRIPT_FILENAME: /usr/share/rhn/wsgi/xmlrpc.py
>SCRIPT_NAME: /XMLRPC
>SCRIPT_URI:
>https://spacewalk.mdc.musc.edu/XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
>SCRIPT_URL:
>/XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
>SERVER_ADDR: 128.23.191.174
>SERVER_ADMIN: root@localhost
>SERVER_NAME: spacewalk.mdc.musc.edu
>SERVER_PORT: 443
>SERVER_PROTOCOL: HTTP/1.1
>SERVER_SIGNATURE:
>SERVER_SOFTWARE: Apache
>UNIQUE_ID: XFwAiOeFCYNstcIeYzFMcgQ
>X-RHN-Auth: nL53lMc41V96u3uWpqa4tAArkXsFdl15WUjBfmzzDKQ=
>X-RHN-Auth-Expire-Offset: 3600.0
>X-RHN-Auth-Server-Time: 1549533319.96
>X-RHN-Auth-User-Id:
>X-RHN-Server-Id: 110001
>X-RHN-Transport-Capability: follow-redirects=3
>mod_wsgi.application_group: spacewalk.mdc.musc.edu|/xmlrpc
>mod_wsgi.callable_object: application
>mod_wsgi.enable_sendfile: 0
>mod_wsgi.handler_script:
>mod_wsgi.input_chunked: 0
>mod_wsgi.listener_host:
>mod_wsgi.listener_port: 443
>mod_wsgi.process_group:
>mod_wsgi.queue_start: 1549533320284352
>mod_wsgi.request_handler: wsgi-script
>mod_wsgi.script_reloading: 1
>mod_wsgi.version: (3, 4)
>wsgi.errors: 
>wsgi.file_wrapper: mod_wsgi.Adapter object at 0x7f14150260a8>
>wsgi.input: 
>wsgi.multiprocess: True
>wsgi.multithread: False
>wsgi.run_once: False
>wsgi.url_scheme: https
>wsgi.version: (1, 0)
>Extra information about this error:
>Response sent back to the caller:
>While running 'repodata': caught
> : repodata() takes exactly 2 arguments (3
>given)
>
>
>
>Exception Handler Information
>Traceback (most recent call last):
>  File
>"/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py",
>line
>135, in call_function
>response = func(*params)
>TypeError: repodata() takes exactly 2 arguments (3 given)
>
>Local variables by frame
>Frame call_function in
>/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py at
>line
>154
>   fault =  1
>self = 
>0x7f140ec680e0>
>  force_rollback =  1
>  method =  repodata
>  exctype =  
> params =  ('Packages.diff', 'Index')
>   e_type =  
>func =  Repository.repodata of instance
>at 0x7f140ec7acf8>>
> e_value =  repodata()
>takes exactly 2 arguments (3 given)
>  response =  running 'repodata': caught\n : repodata()
>takes exactly 2 arguments (3 given)\n">
>
>Frame process in
>/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py at
>line
>593
>self = 
>0x7f140ec680e0>
> params =  ('Packages.diff', 'Index')
>  method =  repodata
>
>Frame handler in
>/usr/lib/python2.7/site-packages/spacewalk/server/apacheHandler.py at
>line
>203
>   h = 
>0x7f140ecadd88>
>self = 
>0x7f14132c4ab8>
> req = 
>
> ret =  1
> templateStrings =  {'email_account_info':
>'\nAccount Information:\n  Your Spacewalk login: \n 
>Your
>Spacewalk email address: ', 'email_footer': '--the
>Spacewalk Team', 'hostname': 'spacewalk.mdc.musc.edu'}
>  

[Spacewalk-list] Yum.pid...

2019-02-07 Thread Dave Thoms
All,


I am running Spacewalk 2.8 on Centos 7.x.  I have noticed /var/run/yum.pid 
files being created early morning (around 5.30am) on Centos *6* servers ONLY.  
I thought it might be the yum-cron service running yum - but it is disabled.  I 
also see in Spacewalk that the time of last checkin coincides with the creation 
date of the /var/run/yum.pid file.  I wouldn't normally care about yum.pid 
being created...but that is causing alerts.



Does anyone know how to get Spacewalk to cleanup the yum.pid file?



Thanks in advance,

Dave T.

The information in this e-mail (including attachments, if any) is considered 
confidential and is intended only for the recipient(s) listed above. Any 
review, use, disclosure, distribution or copying of this e-mail is prohibited 
except by or on behalf of the intended recipient. If you have received this 
email in error, please notify me immediately by reply e-mail, delete this 
e-mail, and do not disclose its contents to anyone. Any opinions expressed in 
this e-mail are those of the individual and not necessarily the TruHearing 
group. Thank you.
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Cannot sync confluent (debian) repository to Spacewalk repo

2019-02-07 Thread Ihor Lawrin
I ran my sync with high verbosity hoping that someone can help with my sync 
failure...

2019/02/07 08:20:45 -04:00 Command: ['/usr/bin/spacewalk-repo-sync', '-vv', 
'--channel', 'confluent-ubuntu-amd64']
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: \n   select s.source_url, c.label\n   
from rhnContentSource s,\n   rhnChannelContentSource cs,\n  
 rhnChannel c\n   where s.id = 
cs.source_id and cs.channel_id=c.id\n   ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: \n   
select s.source_url, c.label\n   from rhnContentSource s,\n 
  rhnChannelContentSource cs,\n   
rhnChannel c\n   where s.id = cs.source_id and 
cs.channel_id=c.id\n   ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n   select 
s.source_url, c.label\n   from rhnContentSource s,\n
   rhnChannelContentSource cs,\n   rhnChannel 
c\n   where s.id = cs.source_id and cs.channel_id=c.id\n
   " with bind params: {}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select 1" with bind 
params: {}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: \nselect c1.label, c2.label parent_channel, c1.id\n
from rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel = c2.id\n 
   order by c2.label desc, c1.label asc\n',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: \n
select c1.label, c2.label parent_channel, c1.id\nfrom rhnChannel c1 
left outer join rhnChannel c2 on c1.parent_channel = c2.id\norder by 
c2.label desc, c1.label asc\n',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\nselect 
c1.label, c2.label parent_channel, c1.id\nfrom rhnChannel c1 left outer 
join rhnChannel c2 on c1.parent_channel = c2.id\norder by c2.label 
desc, c1.label asc\n" with bind params: {}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(104,)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: \nselect\nrcf.label\nfrom\nrhnChannelFamily 
rcf,\nrhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id 
= :channel_id\nand rcfm.channel_family_id = rcf.id\nand 
rcf.org_id is not null\n',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: \nselect\n  
  rcf.label\nfrom\nrhnChannelFamily rcf,\n
rhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id = 
%(channel_id)s\nand rcfm.channel_family_id = rcf.id\nand 
rcf.org_id is not null\n',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\nselect\n   
 rcf.label\nfrom\nrhnChannelFamily rcf,\n
rhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id = 
%(channel_id)s\nand rcfm.channel_family_id = rcf.id\nand 
rcf.org_id is not null\n" with bind params: {channel_id: 104}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(104, 
'is a custom channel')
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(101,)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('Converting query for 
PostgreSQL: \nselect\nrcf.label\nfrom\nrhnChannelFamily 
rcf,\nrhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id 
= :channel_id\nand rcfm.channel_family_id = rcf.id\nand 
rcf.org_id is not null\n',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql.convert_named_query_params('New query: \nselect\n  
  rcf.label\nfrom\nrhnChannelFamily rcf,\n
rhnChannelFamilyMembers rcfm\nwhere\nrcfm.channel_id = 
%(channel_id)s\nand rcfm.channel_family_id = rcf.id\nand 
rcf.org_id is not null\n',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: 
rhnSQL/driver_postgresql._execute_wrapper('Executing 

[Spacewalk-list] Continuing issues with ubuntu client and Spacewalk 2.9

2019-02-07 Thread James Krych
*Sadly,*

*I am still getting the TRACEBACK error regarding diffs. Message from
today:*
Exception reported from spacewalk
Time: Thu Feb  7 04:55:20 2019
Exception type 
Exception while handling function repodata
Request object information:
URI: ///XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
Remote Host: grouper-dev-loader-v.mdc.musc.edu
Server Name: spacewalk.mdc.musc.edu:443
Headers passed in:
Accept-Encoding: identity
CONTEXT_DOCUMENT_ROOT: /var/www/html
CONTEXT_PREFIX:
DOCUMENT_ROOT: /var/www/html
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT_ENCODING: identity
HTTP_HOST: spacewalk.mdc.musc.edu
HTTP_X_RHN_AUTH: nL53lMc41V96u3uWpqa4tAArkXsFdl15WUjBfmzzDKQ=
HTTP_X_RHN_AUTH_EXPIRE_OFFSET: 3600.0
HTTP_X_RHN_AUTH_SERVER_TIME: 1549533319.96
HTTP_X_RHN_AUTH_USER_ID:
HTTP_X_RHN_SERVER_ID: 110001
HTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
Host: spacewalk.mdc.musc.edu
PATH_INFO: /GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
PATH_TRANSLATED:
/var/www/html/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
QUERY_STRING:
REMOTE_ADDR: 128.23.182.201
REMOTE_PORT: 59130
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_URI:
///XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
SCRIPT_FILENAME: /usr/share/rhn/wsgi/xmlrpc.py
SCRIPT_NAME: /XMLRPC
SCRIPT_URI:
https://spacewalk.mdc.musc.edu/XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
SCRIPT_URL:
/XMLRPC/GET-REQ/ubuntu_16_updates/repodata/Packages.diff/Index
SERVER_ADDR: 128.23.191.174
SERVER_ADMIN: root@localhost
SERVER_NAME: spacewalk.mdc.musc.edu
SERVER_PORT: 443
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE:
SERVER_SOFTWARE: Apache
UNIQUE_ID: XFwAiOeFCYNstcIeYzFMcgQ
X-RHN-Auth: nL53lMc41V96u3uWpqa4tAArkXsFdl15WUjBfmzzDKQ=
X-RHN-Auth-Expire-Offset: 3600.0
X-RHN-Auth-Server-Time: 1549533319.96
X-RHN-Auth-User-Id:
X-RHN-Server-Id: 110001
X-RHN-Transport-Capability: follow-redirects=3
mod_wsgi.application_group: spacewalk.mdc.musc.edu|/xmlrpc
mod_wsgi.callable_object: application
mod_wsgi.enable_sendfile: 0
mod_wsgi.handler_script:
mod_wsgi.input_chunked: 0
mod_wsgi.listener_host:
mod_wsgi.listener_port: 443
mod_wsgi.process_group:
mod_wsgi.queue_start: 1549533320284352
mod_wsgi.request_handler: wsgi-script
mod_wsgi.script_reloading: 1
mod_wsgi.version: (3, 4)
wsgi.errors: 
wsgi.file_wrapper: 
wsgi.input: 
wsgi.multiprocess: True
wsgi.multithread: False
wsgi.run_once: False
wsgi.url_scheme: https
wsgi.version: (1, 0)
Extra information about this error:
Response sent back to the caller:
While running 'repodata': caught
 : repodata() takes exactly 2 arguments (3
given)



Exception Handler Information
Traceback (most recent call last):
  File
"/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py", line
135, in call_function
response = func(*params)
TypeError: repodata() takes exactly 2 arguments (3 given)

Local variables by frame
Frame call_function in
/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py at line
154
   fault =  1
self = 

  force_rollback =  1
  method =  repodata
 exctype =  
  params =  ('Packages.diff', 'Index')
  e_type =  
func =  >
 e_value =  repodata()
takes exactly 2 arguments (3 given)
response =   : repodata()
takes exactly 2 arguments (3 given)\n">

Frame process in
/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py at line
593
self = 

  params =  ('Packages.diff', 'Index')
  method =  repodata

Frame handler in
/usr/lib/python2.7/site-packages/spacewalk/server/apacheHandler.py at line
203
   h = 

self = 

 req = 

 ret =  1
 templateStrings =  {'email_account_info':
'\nAccount Information:\n  Your Spacewalk login: \n  Your
Spacewalk email address: ', 'email_footer': '--the
Spacewalk Team', 'hostname': 'spacewalk.mdc.musc.edu'}
 row =  None

Frame handle in /usr/share/rhn/wsgi/wsgiHandler.py at line 44
replacements =  {'Xml': 'XML', 'Actualuri':
'ActualURI', 'Md5Sum': 'MD5sum', '_': '-', 'Rhn': 'RHN'}
  component_type =  server.xmlrpc
  start_response = 

   k =  Rhn
 req = 

Re: [Spacewalk-list] specific repo to a server with kickstart

2019-02-07 Thread p.cook...@bham.ac.uk
Hi Jérôme

If I understand your question right, you could make the additional repo a Child 
repo of the Parent repo the Activation Key is associated with. Alternatively, 
you could create a separate repo with its own Activation Key. The system you're 
provisioning could then be registered with 2 Activation Keys (channels/repo's) 
perhaps?

If this isn't something you're going to do very often, obviously, you could 
just use Kickstart to provision the system then there isn't anything stopping 
you subscribing the system to the separate repo afterwards.

Regards
Phil


From: spacewalk-list-boun...@redhat.com  On 
Behalf Of jerome.me...@lcsystems.ch
Sent: 06 February 2019 16:23
To: 'spacewalk-list@redhat.com' 
Subject: Re: [Spacewalk-list] specific repo to a server with kickstart

Hi Phil,

Thanks for your quick reply.
Yes, I'm using the Base Channel when a new server is creating with a Kickstart 
Script define on Spacewalk. In that way all is fine and desired packages are 
installed.

I didn't think that the problem is regarding the tree?

Now, for some specifics servers we need specifics repos for particular 
application. My question is : is it possible to insert this particular repo 
during a new kickstart installation? Hope that my question is more 
understandable?

Thanks and best regards,
Jérôme




From: 
spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of 
p.cook...@bham.ac.uk
Sent: Mittwoch, 6. Februar 2019 11:01
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] specific repo to a server with kickstart

Hi Jerome

I've been using Spacewalk to patch systems for a little while but only started 
to look in to provisioning with Spacewalk more recently.

However, if I understand your question properly, the Base Channel is set when 
creating a Kickstart Distribution. Subsequently, this is where the packages 
will come from for installation.

Note, unlike Satellite, Spacewalk does NOT make the OS disk structure 
(Kickstart Tree) required for installation - this needs to be performed as a 
separate task. The Tree Path, within Kickstart Distribution, should be set to 
whatever location you download these to.

As Spacewalk is utilising Kickstart/Koan and Cobbler, under the covers, I 
believe there'll be other ways of achieving the same thing, in an even more 
automated way, though.

Regards
Phil

From: 
spacewalk-list-boun...@redhat.com 
mailto:spacewalk-list-boun...@redhat.com>> 
On Behalf Of jerome.me...@lcsystems.ch
Sent: 06 February 2019 09:30
To: 'spacewalk-list@redhat.com' 
mailto:spacewalk-list@redhat.com>>
Subject: [Spacewalk-list] specific repo to a server with kickstart

Hi everyone,

Does anyone have an idea if it is possible with kickstart (Spacewalk) to define 
once a specific repo on a server during his creation?

Thanks and best regards,
Jerome

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list