Re: [Spacewalk-list] rhnreg_ks on F15
On Wed, Apr 13, 2011 at 22:07, Miroslav Suchy wrote: > That is strange. Sandro, can you run this for me: subsystem usb devtype usb_device name usb1 number 1 sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1 driver: usb action: None seqnum: 0 device type: device number: 48384 device file: /dev/bus/usb/001/001 device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1a.0/usb1 SUBSYSTEM = usb MAJOR = 189 MINOR = 0 DEVNAME = /dev/bus/usb/001/001 DEVTYPE = usb_device DRIVER = usb DEVICE = /proc/bus/usb/001/001 PRODUCT = 1d6b/2/206 TYPE = 9/0/0 BUSNUM = 001 DEVNUM = 001 subsystem usb devtype usb_interface name 1-0:1.0 number 0 sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1/1-0:1.0 driver: hub action: None seqnum: 0 device type: device number: 0 device file: None device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1a.0/usb1/1-0:1.0 SUBSYSTEM = usb DEVTYPE = usb_interface DRIVER = hub DEVICE = /proc/bus/usb/001/001 PRODUCT = 1d6b/2/206 TYPE = 9/0/0 INTERFACE = 9/0/0 MODALIAS = usb:v1D6Bp0002d0206dc09dsc00dp00ic09isc00ip00 subsystem usb devtype usb_device name 1-1 number 1 sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1/1-1 driver: usb action: None seqnum: 0 device type: device number: 48385 device file: /dev/bus/usb/001/002 device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1a.0/usb1/1-1 SUBSYSTEM = usb MAJOR = 189 MINOR = 1 DEVNAME = /dev/bus/usb/001/002 DEVTYPE = usb_device DRIVER = usb DEVICE = /proc/bus/usb/001/002 PRODUCT = 8087/20/0 TYPE = 9/0/1 BUSNUM = 001 DEVNUM = 002 subsystem usb devtype usb_interface name 1-1:1.0 number 0 sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1/1-1/1-1:1.0 driver: hub action: None seqnum: 0 device type: device number: 0 device file: None device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1a.0/usb1/1-1/1-1:1.0 SUBSYSTEM = usb DEVTYPE = usb_interface DRIVER = hub DEVICE = /proc/bus/usb/001/002 PRODUCT = 8087/20/0 TYPE = 9/0/1 INTERFACE = 9/0/0 MODALIAS = usb:v8087p0020ddc09dsc00dp01ic09isc00ip00 subsystem usb devtype usb_device name usb2 number 2 sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2 driver: usb action: None seqnum: 0 device type: device number: 48512 device file: /dev/bus/usb/002/001 device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1d.0/usb2 SUBSYSTEM = usb MAJOR = 189 MINOR = 128 DEVNAME = /dev/bus/usb/002/001 DEVTYPE = usb_device DRIVER = usb DEVICE = /proc/bus/usb/002/001 PRODUCT = 1d6b/2/206 TYPE = 9/0/0 BUSNUM = 002 DEVNUM = 001 subsystem usb devtype usb_interface name 2-0:1.0 number 0 sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-0:1.0 driver: hub action: None seqnum: 0 device type: device number: 0 device file: None device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1d.0/usb2/2-0:1.0 SUBSYSTEM = usb DEVTYPE = usb_interface DRIVER = hub DEVICE = /proc/bus/usb/002/001 PRODUCT = 1d6b/2/206 TYPE = 9/0/0 INTERFACE = 9/0/0 MODALIAS = usb:v1D6Bp0002d0206dc09dsc00dp00ic09isc00ip00 subsystem usb devtype usb_device name 2-1 number 1 sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1 driver: usb action: None seqnum: 0 device type: device number: 48513 device file: /dev/bus/usb/002/002 device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1d.0/usb2/2-1 SUBSYSTEM = usb MAJOR = 189 MINOR = 129 DEVNAME = /dev/bus/usb/002/002 DEVTYPE = usb_device DRIVER = usb DEVICE = /proc/bus/usb/002/002 PRODUCT = 8087/20/0 TYPE = 9/0/1 BUSNUM = 002 DEVNUM = 002 subsystem usb devtype usb_device name 2-1.1 number 1 sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1 driver: usb action: None seqnum: 0 device type: device number: 48514 device file: /dev/bus/usb/002/003 device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1d.0/usb2/2-1/2-1.1 SUBSYSTEM = usb MAJOR = 189 MINOR = 130 DEVNAME = /dev/bus/usb/002/003 DEVTYPE = usb_device DRIVER = usb DEVICE = /proc/bus/usb/002/003 PRODUCT = 557/7000/100 TYPE = 9/0/0 BUSNUM = 002 DEVNUM = 003 subsystem usb devtype usb_device name 2-1.1.1 number 1 sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.1 driver: usb action: None seqnum: 0 device type: device number: 48515 device file: /dev/bus/usb/002/004 device file symlinks: UDEV_LOG = 3 DEVPATH = /devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.1 SUBSYSTEM = usb MAJOR = 189 MINOR = 131 DEVNAME = /dev/bus/usb/002/004 DEVTYPE = usb_device DRIVER = usb DEVICE = /proc/bus/usb/002/004 PRODUCT = 4d9/1603/310 TYPE = 0/0/0 BUSNUM = 002 DEVNUM = 004 subsystem usb devtype usb_interface name 2-1.1.1:1.0 number 0 sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.1/2-1.1.1:1.0 driver: usbhid action: None seqnum: 0 device type:
Re: [Spacewalk-list] Database user data
Does it stop once it hits the 4GB limit or is it a performance hit? Did I miss the new more accurate numbers? -Original Message- From: spacewalk-list-boun...@redhat.com [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Michael Mraka Sent: Wednesday, April 13, 2011 12:44 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Database user data d...@fedoraproject.org wrote: % On Tue, 12 Apr 2011, Michael Mraka wrote: % >William S. wrote: % >% % >% On average, do folks exceed the 4GB limitation with Oracle Xe? I'm trying to gauge on what sort of real data is stored in the DB, and how quickly I would run out of space. % > % >Some time ago I did estimates for Spacewalk 1.1 and came to formula % >* 250 KiB per client system, % >* 500 KiB per channel + 230 KiB per package in channel (i.e. 1.1GiB for channel % >with 5000 packages). % > % >It might be slightly lower number nowadays because we optimized % >changelog data storage which was quite hoggish :). % % I found the following in the Satellite 5.4 install docs: % % A single 6 GB tablespace is recommended as more than sufficient for % most installations. % * 192 KB per client system % * 64 MB per channel % % For instance, an RHN Satellite containing 10 channels serving 10,000 % systems would require 1.92 GB for its clients and 640 MB for its % channels. % % Database storage needs may grow rapidly, depending upon the variance % of the following factors: % * The number of public Red Hat packages imported (typical: 5000) % * The number of private packages to be managed (typical: 500) % * The number of systems to be managed (typical: 1000) % * The number of packages installed on the average system (typical: 500) Yes, these were old estimates which are no more accurate so I went ahead and created new, more appropriate, one. Regards, -- Michael Mráka Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Database Schema Update Issue - 1.2 to 1.3 Upgrade
> > I'm having an issue with the upgrade from v1.2 to v1.3 ... when I run > > the spacewalk-schema-upgrade script... it just simply returns: > > > > No existing schema version info found in rhnVersionInfo. > > > > I can make a simple connection via sqlplus.. so I know the database is > > running and available. Looking at the schema upgrade script... I find > > the query that it runs to check the schema version: > > > > select rhnPackageName.name || '-' || (PE.evr).version || '-' || > > (PE.evr).release from rhnVersionInfo, rhnPackageName, rhnPackageEVR PE > > where rhnVersionInfo.label = 'schema' > > and rhnVersionInfo.name_id = rhnPackageName.id > > and rhnVersionInfo.evr_id = PE.id; > > > > And when I run that manually via sqlplus .. I get no rows returned. > > > > Has anyone seen this issue? > > Yes. It means your previous schema upgrade (to Spacewalk 1.2) failed. > Check log files in /var/log/spacewalk/schema-upgrade for reasons why. Right... so, this is something that came up in an earlier thread I think. During my 1.2 upgrade I had this issue with the schema: SQL> set echo on SQL> spool /var/log/spacewalk/schema-upgrade/20101129-165813-to-spacewalk-schema-1.2.log append SQL> whenever sqlerror exit sql.sqlcode SQL> select 'spacewalk-schema-1.1-to-spacewalk-schema-1.2/210-rhnPackage-indexes.sql' from dual; 'SPACEWALK-SCHEMA-1.1-TO-SPACEWALK-SCHEMA-1.2/210-RHNPACKAGE-INDEXES.SQ --- spacewalk-schema-1.1-to-spacewalk-schema-1.2/210-rhnPackage-indexes.sql SQL> SQL> drop index rhn_package_id_nid_paid_idx; drop index rhn_package_id_nid_paid_idx * ERROR at line 1: ORA-02429: cannot drop index used for enforcement of unique/primary key However, there was a post that talked about this.. and how to fix it. Did the fix fail to add something in the database to mark it as "successfully upgraded?" Andy ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Database Schema Update Issue - 1.2 to 1.3 Upgrade
On Wednesday 13 April 2011 21:42:31 Speagle, Andy wrote: > Hi all... > > I'm having an issue with the upgrade from v1.2 to v1.3 ... when I run the > spacewalk-schema-upgrade script... it just simply returns: > > No existing schema version info found in rhnVersionInfo. > > I can make a simple connection via sqlplus.. so I know the database is > running and available. Looking at the schema upgrade script... I find the > query that it runs to check the schema version: > > select rhnPackageName.name || '-' || (PE.evr).version || '-' || > (PE.evr).release from rhnVersionInfo, rhnPackageName, rhnPackageEVR PE > where rhnVersionInfo.label = 'schema' > and rhnVersionInfo.name_id = rhnPackageName.id > and rhnVersionInfo.evr_id = PE.id; > > And when I run that manually via sqlplus .. I get no rows returned. > > Has anyone seen this issue? Yes. It means your previous schema upgrade (to Spacewalk 1.2) failed. Check log files in /var/log/spacewalk/schema-upgrade for reasons why. -MZ ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
Dne 13.4.2011 16:26, Sandro "red" Mathys napsal(a):
2011/4/13 Miroslav Suchý:
On 04/13/2011 02:52 PM, Sandro "red" Mathys wrote:
2011/4/13 Miroslav Suchý:
It is some USB device. Can you run this python script in both %post
section of kickstart and after normal reboot? Check the diferences.
You should look for records with
XXX: None
Lots of XXX: None found, actually it's always None!
That is strange... aha, there is typo. It should be PRODUCT and not product.
Commited as ebd9948a92945026db88932eefd23c4c0c7738ea
Next issue: ~4 lines later, "usb" is not defined:
: local variable 'usb' referenced
before assignment
If I add "usb = USB()" (as found in the first part of that
if-elif-else construct) before that line, I get the next traceback:
[Wed Apr 13 15:18:51 2011] up2date
Traceback (most recent call last):
File "/usr/sbin/rhnreg_ks", line 213, in
cli.run()
File "/usr/share/rhn/up2date_client/rhncli.py", line 74, in run
sys.exit(self.main() or 0)
File "/usr/sbin/rhnreg_ks", line 101, in main
hardwareList = hardware.Hardware()
File "/usr/share/rhn/up2date_client/hardware.py", line 674, in Hardware
allhw = get_devices()
File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 45, in
get_devices
'desc': _get_device_desc(device),
File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 311, in
_get_device_desc
result = "%s|%s" % (usb.get_vendor(vendor_id),
usb.get_device(vendor_id, device.get_property('ID_MODEL_ID')))
File "/usr/lib/python2.7/site-packages/hwdata.py", line 82, in get_device
device = device.lower()
: 'NoneType' object has no attribute 'lower'
That is strange. Sandro, can you run this for me:
>>> import gudev
>>> import glib
>>> def print_device(device):
... print "subsystem", device.get_subsystem()
... print "devtype", device.get_devtype()
... print "name", device.get_name()
... print "number", device.get_number()
... print "sysfs_path:", device.get_sysfs_path()
... print "driver:", device.get_driver()
... print "action:", device.get_action()
... print "seqnum:", device.get_seqnum()
... print "device type:", device.get_device_type()
... print "device number:", device.get_device_number()
... print "device file:", device.get_device_file()
... print "device file symlinks:", ",
".join(device.get_device_file_symlinks())
... for k in device.get_property_keys():
...print " %s = %s" % (k , device.get_property(k))
...
>>> client = gudev.Client(["usb"])
>>> devices = client.query_by_subsystem("usb")
>>> for device in devices:
... print_device(device)
Your traceback means that you have some device which has no ID_MODEL_ID.
I can get this data from PRODUCT, but I'm really curious which device do
not have ID_MODEL_ID. Only usb_interfaces do not have it AFAIK, but they
are filtered few lines above...
Mirek
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
On Wed, Apr 13, 2011 at 21:39, Miroslav Suchy wrote: > Dne 13.4.2011 14:52, Sandro "red" Mathys napsal(a): >>> >>> It happens during gathering HW info. So if you run it with --nohardware, >>> > you can workaround it. >> >> --nohardware doesn't resolve the issue, i.e. no change at all. >> > > > Aha, I got it. You do not have HAL installed or running. > The code try to first retrive data from HAL, if it is not present it will > try gudev, where is the bug. > > To workaround the bug, make sure HAL is running. Unfortunately this is Fedora 15 (nightly) and HAL is being removed from Fedora per this feature: http://fedoraproject.org/wiki/Features/HalRemoval So we do want the gudev stuff - but we need it in working order ;) Thanks :D ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
Dne 13.4.2011 14:52, Sandro "red" Mathys napsal(a): It happens during gathering HW info. So if you run it with --nohardware, > you can workaround it. --nohardware doesn't resolve the issue, i.e. no change at all. Aha, I got it. You do not have HAL installed or running. The code try to first retrive data from HAL, if it is not present it will try gudev, where is the bug. To workaround the bug, make sure HAL is running. Mirek ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] Database Schema Update Issue - 1.2 to 1.3 Upgrade
Hi all... I'm having an issue with the upgrade from v1.2 to v1.3 ... when I run the spacewalk-schema-upgrade script... it just simply returns: No existing schema version info found in rhnVersionInfo. I can make a simple connection via sqlplus.. so I know the database is running and available. Looking at the schema upgrade script... I find the query that it runs to check the schema version: select rhnPackageName.name || '-' || (PE.evr).version || '-' || (PE.evr).release from rhnVersionInfo, rhnPackageName, rhnPackageEVR PE where rhnVersionInfo.label = 'schema' and rhnVersionInfo.name_id = rhnPackageName.id and rhnVersionInfo.evr_id = PE.id; And when I run that manually via sqlplus .. I get no rows returned. Has anyone seen this issue? Andy Speagle System & Storage Administrator UCATS - Wichita State University P: 316.978.3869 C: 316.617.2431 ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] ISE While Attempting to Upload GPG Key or Kickstart File
List: Spacewalk Version: 1.4-RC OS Version: CentOS 5.6 The attached output is written to catalina.out while attempting to upload a GPG Key or Kickstart File to Spacewalk. The files can be uploaded using the spacecmd CLI; however, the web interface fails to achieve the desired results. Please let me know if any additional information is needed and thank you for the assistance. ___ Trevor T. Kates 2011-04-13 12:44:54,773 [TP-Processor1] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back javax.servlet.ServletException: Servlet execution threw an exception at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:636) 2011-04-13 12:44:54,774 [TP-Processor1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception java.lang.ClassNotFoundException: org.apache.commons.fileupload.FileUploadException at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1374) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1220) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332) at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2406) at java.lang.Class.getConstructor0(Class.java:2716) at java.lang.Class.newInstance0(Class.java:343) at java.lang.Class.newInstance(Class.java:325) at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:143) at org.apache.struts.util.RequestUtils.getMultipartHandler(RequestUtils
Re: [Spacewalk-list] error generated when running rhn_check on client
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Sorry , Client is on RHEL 6.0 Server is on Centos 5.6 On 13 Apr 2011, at 16:09, Jan Pazdziora wrote: > On Wed, Apr 13, 2011 at 03:55:15PM +0100, Assaf Flatto wrote: >> Starting tomcat5: [ OK ] >> Waiting for tomcat to be ready ... >> >> >> # lsof -i |grep tomcat >> java 1973 tomcat 70u IPv6 1074846 TCP *:webcache (LISTEN) >> java 1973 tomcat 72r IPv6 1075282 TCP *:8009 (LISTEN) > > And in this situation, the above line is not found by > > /usr/sbin/lsof -t -i TCP:8009 -p 1973 > > (the line in spacewalk-service)? What OS is this? > > -- > Jan Pazdziora > Principal Software Engineer, Satellite Engineering, Red Hat > > ___ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list -BEGIN PGP SIGNATURE- Version: PGP Desktop 10.1.0 (Build 860) Charset: us-ascii wsBVAwUBTaXAMWK6JZrjLX7GAQh8qwf9EkYoPGpUEux3nzOcvgsnljslXG9UsEtU 9sIYBPaTSQkXc/dHM3PD9i/2kVmHjR2tNGO+v+RfjydLx1TM23RkqR7iBihK5ssy 9rXKxPwe5qBVXfT9SbOEhY11YZD9a3/AqslwGYsKUhD7wYDE5zx8ADbfmzosTbjt TsaFAuGEB+OMF6Jz+JgWCTouantlVT10nVLQcPdUxgAPHsHfi+CaLXi1A0HX2Pff w+nBvVSu4fR2Uf5su+Mv6ZazSiYv8+aFif0SDVUq2Z/QvpOdGDqdKELWsFSF2+cS CoUTY4pouWlu6DqFRLDwlmTZ+xxy7JccyJ6ln3aFHa5nTi1M4NHsLg== =PSdZ -END PGP SIGNATURE- ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 RHEL 6.0 On 13 Apr 2011, at 16:09, Jan Pazdziora wrote: > On Wed, Apr 13, 2011 at 03:55:15PM +0100, Assaf Flatto wrote: >> Starting tomcat5: [ OK ] >> Waiting for tomcat to be ready ... >> >> >> # lsof -i |grep tomcat >> java 1973 tomcat 70u IPv6 1074846 TCP *:webcache (LISTEN) >> java 1973 tomcat 72r IPv6 1075282 TCP *:8009 (LISTEN) > > And in this situation, the above line is not found by > > /usr/sbin/lsof -t -i TCP:8009 -p 1973 > > (the line in spacewalk-service)? What OS is this? > > -- > Jan Pazdziora > Principal Software Engineer, Satellite Engineering, Red Hat > > ___ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list -BEGIN PGP SIGNATURE- Version: PGP Desktop 10.1.0 (Build 860) Charset: us-ascii wsBVAwUBTaW+Y2K6JZrjLX7GAQiqzAf+MDNhoH20n0NTbGNjNSyF9IwXJQ+O/S8O nyBBiJxd7pAiUoZp1VLFfmrVSaKVv0SGq81MfoYTnnNEsSxqY+FHbGBIhDQ10V2K B/bGXVtIqt3ghX0JhFe4A21YjqLrsgX2cVDHDeUHXyhX/cNRO3VedW7kZLXYrWYp fNhpfITkTwKDStrzBVjvXv0/gDeGaCgpRkDCGnlgmK7oawQqFh+lV47A8lYUs6jV 4NiGSnrWeV1hBbLp8AgHlaxnwz+KQX1Pr76McehQzmlngTQJo+f5fnFpIwtcp54j VTAQhU5LnJa8c1QuYifYfQCG8L7r918hKgNc1hCiBqtGxkTxHMBoSg== =GL8F -END PGP SIGNATURE- ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
On Wed, Apr 13, 2011 at 03:55:15PM +0100, Assaf Flatto wrote: > Starting tomcat5: [ OK ] > Waiting for tomcat to be ready ... > > > # lsof -i |grep tomcat > java 1973 tomcat 70u IPv6 1074846 TCP *:webcache (LISTEN) > java 1973 tomcat 72r IPv6 1075282 TCP *:8009 (LISTEN) And in this situation, the above line is not found by /usr/sbin/lsof -t -i TCP:8009 -p 1973 (the line in spacewalk-service)? What OS is this? -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] [Spacewalk-devel] Spacewalk 1.4-RC post-upgrade report
On Tue, Apr 12, 2011 at 04:10:09PM +0200, Michael Calmer wrote: > > > > On which OS was this? > > This was SLES11 with python 2.6. I don't know exactly how python import works. > So I do not exactly now what should work and what not :-) On Wed, Apr 13, 2011 at 03:12:15PM +0200, Martin Zehetmayer wrote: > Hi, > > for I am new on this list let me introduce myself: > My name is Martin Zehetmayer, I work for as consultant for a small linux > solution provider in germany, mostly dealing with RHEL systems. > > I am currently testing spacewalk 1.4-RC6 on a RHEL6.0 x86_64 system. > Installing works very fine but when > adding packages to a custom channel I get the following error: [...] > After searching I found a post in this list from Michael Calmer which reports > the same error under SLES. As mentioned above I tested it under RHEL6 and the > same problem appear. It can be solved using three tests as suggested from > Michael. I've only tested this on RHEL 6.1 (to be) and sadly, yum has changed since vanilla RHEL 6.0. I've now added the import from xml.etree and the 1.4-RC repo has the new spacewalk-backend* packages (1.4.38-1). Thanks for bringing this to our attention. -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] kickstart.py: spacecmd -- kickstart_clone -n profile_name -c profile_clone
kickstart.py
below adds the "clone" option.
def help_kickstart_clone(self):
print 'kickstart_clone: Clone a Kickstart profile'
print '''usage: kickstart_clone [options]
options:
-n NAME
-c CLONE_NAME'''
def do_kickstart_clone(self, args):
options = [ Option('-n', '--name', action='store'),
Option('-c', '--clonename', action='store') ]
(args, options) = parse_arguments(args, options)
if is_interactive(options):
options.name = prompt_user('Name:', noblank = True)
options.clonename = prompt_user('Clone Name:', noblank = True)
else:
if not options.name:
logging.error('The Kickstart name is required')
return
if not options.clonename:
logging.error('The Kickstart clone name is required')
return
# leave this blank to use the default server
host = ''
self.client.kickstart.cloneProfile(self.session,
options.name,
options.clonename)
Aaron Prayther
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
i just did a restart to paste the results :
/usr/sbin/spacewalk-service restart
Shutting down spacewalk services...
Stopping RHN Taskomatic...
Stopped RHN Taskomatic.
Stopping cobbler daemon: [ OK ]
Stopping rhn-search...
Stopped rhn-search.
Stopping MonitoringScout ...
[ OK ]
Stopping Monitoring ...
[ OK ]
Stopping httpd:[ OK ]
Stopping tomcat5: [ OK ]
Shutting down osa-dispatcher: [ OK ]
Terminating jabberd processes ...
Stopping router: [ OK ]
Stopping sm: [ OK ]
Stopping c2s: [ OK ]
Stopping s2s: [ OK ]
Done.
Starting spacewalk services...
Initializing jabberd processes ...
Starting router: [ OK ]
Starting sm: [ OK ]
Starting c2s: [ OK ]
Starting s2s: [ OK ]
Starting osa-dispatcher: RHN 1438 2011/04/13 14:50:52 -00:00: ('Server did not
return a stanza',)
RHN 1438 2011/04/13 14:50:52 -00:00: ('Traceback (most recent call last):\n
File "/usr/share/rhn/osad/jabber_lib.py", line 253, in setup_connection\nc
= self._get_jabber_client(js)\n File "/usr/share/rhn/osad/jabber_lib.py", line
310, in _get_jabber_client\nc.connect()\n File
"/usr/share/rhn/osad/jabber_lib.py", line 583, in connect\nraise
SSLDisabledError\nSSLDisabledError\n',)
[ OK ]
Starting tomcat5: [ OK ]
Waiting for tomcat to be ready ...
# lsof -i |grep tomcat
java 1973 tomcat 70u IPv6 1074846 TCP *:webcache (LISTEN)
java 1973 tomcat 72r IPv6 1075282 TCP *:8009 (LISTEN)
java 1973 tomcat 73r IPv6 1075283 TCP
localhost.localdomain:8005 (LISTEN)
java 1973 tomcat 123r IPv6 1075040 TCP
localhost.localdomain:44595->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 124r IPv6 1075043 TCP
localhost.localdomain:44596->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 125r IPv6 1075045 TCP
localhost.localdomain:44597->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 126r IPv6 1075051 TCP
localhost.localdomain:44600->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 127r IPv6 1075049 TCP
localhost.localdomain:44599->localhost.localdomain:postgres (ESTABLISHED)
now when i manually start httpd :
/etc/init.d/httpd start
Starting httpd:[ OK ]
[root@~]# lsof -i |grep tomcat
java 1973 tomcat 70u IPv6 1074846 TCP *:webcache (LISTEN)
java 1973 tomcat 72r IPv6 1075282 TCP *:8009 (LISTEN)
java 1973 tomcat 73r IPv6 1075283 TCP
localhost.localdomain:8005 (LISTEN)
java 1973 tomcat 123r IPv6 1075040 TCP
localhost.localdomain:44595->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 124r IPv6 1075043 TCP
localhost.localdomain:44596->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 125r IPv6 1075045 TCP
localhost.localdomain:44597->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 126r IPv6 1075051 TCP
localhost.localdomain:44600->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 127r IPv6 1075049 TCP
localhost.localdomain:44599->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 138r IPv6 1079852 TCP
localhost.localdomain:44622->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 139r IPv6 1079854 TCP
localhost.localdomain:44623->localhost.localdomain:postgres (ESTABLISHED)
java 1973 tomcat 140r IPv6 1079856 TCP
localhost.localdomain:44624->localhost.localdomain:postgres (ESTABLISHED)
and then the spacewalk start script moves and gives this output :
Starting httpd:
Starting Monitoring ...
[ OK ]
Starting MonitoringScout ...
[ OK ]
Starting rhn-search...
Starting cobbler daemon: [ OK ]
Starting RHN Taskomatic...
Done.
and then i have access to the spacewalkj web interface .
On 13 Apr 2011, at 15:44, Jan Pazdziora wrote:
> On Wed, Apr 13, 2011 at 03:30:46PM +0100, Assaf Flatto wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA256
>>
>>
>> Yes , i just upgraded to the 1.4 RC and did a restart of spacewalk and had
>> the same issues i had on 1.3 , both the postgresql and the tomcat hangup .
>
> But in the nextdoor thread you say that
Re: [Spacewalk-list] error generated when running rhn_check on client
On Wed, Apr 13, 2011 at 03:30:46PM +0100, Assaf Flatto wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > > Yes , i just upgraded to the 1.4 RC and did a restart of spacewalk and had > the same issues i had on 1.3 , both the postgresql and the tomcat hangup . But in the nextdoor thread you say that in fact, tomcat does not start properly at all. When the spacewalk-service is waiting for tomcat to start listening on port 8009, do you see the INFO: Server startup in ... ms line in your catalina.out? What does lsof (which is what we use to check for tomcat being ready) return in that situation? -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Yes , i just upgraded to the 1.4 RC and did a restart of spacewalk and had the same issues i had on 1.3 , both the postgresql and the tomcat hangup . On 13 Apr 2011, at 15:24, Jan Pazdziora wrote: > On Wed, Apr 13, 2011 at 03:15:42PM +0100, Assaf Flatto wrote: >> >>> What makes you think that tomcat is waiting for httpd? >> >> Well , on my machine it is "waiting " for a long time ( some time even 20 >> minutes ) until i manually start httpd , and then the tomcat "kick" up and >> works , >> I've seen it in ALL of my spoacewalk "start" and "restart" i have done. > > This issue was in Spacewalk nightly and it's been fixed on March 25, > so it should not appear in 1.4 RC. Does it happen in 1.4 RC for you? > > -- > Jan Pazdziora > Principal Software Engineer, Satellite Engineering, Red Hat > > ___ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list -BEGIN PGP SIGNATURE- Version: PGP Desktop 10.1.0 (Build 860) Charset: us-ascii wsBVAwUBTaWzmWK6JZrjLX7GAQgZrAf/ZAs47WJOE6w2rSVsEvJtKvHTwSao2PjF b/XLOJ26nLCes8vhc5E6zj8+zruO2AYI6VIIVIbhgGv0RfEmlfO26kJuWqLBOuyv 5zyA5LbFVf26gPULrr+O1pCzcfLxRmwBolrtdAZdZ8Ezg+BfVmooKQ114m+CdD2L c5TKZiShe75ZP742Kwz5T0oXrKj75uINVOIqKiAp2ib+VAK2y0TOXfJRzFjNJuyX oZoaEcUib/ORLfzCA+bexD5Q8zdw3io0/Bv2wkWVVkXofGbaZ5HCEbpRWBZxa2YK 7pPSWfDNWto1dVZQk4ynxvrR5DLvhWI4Dq6DaZ2SqZxwtkawbn94Zw== =3mfx -END PGP SIGNATURE- ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
2011/4/13 Miroslav Suchý :
> On 04/13/2011 02:52 PM, Sandro "red" Mathys wrote:
>> 2011/4/13 Miroslav Suchý :
>>> It is some USB device. Can you run this python script in both %post
>>> section of kickstart and after normal reboot? Check the diferences.
>>> You should look for records with
>>> XXX: None
>>
>> Lots of XXX: None found, actually it's always None!
>
> That is strange... aha, there is typo. It should be PRODUCT and not product.
> Commited as ebd9948a92945026db88932eefd23c4c0c7738ea
Next issue: ~4 lines later, "usb" is not defined:
: local variable 'usb' referenced
before assignment
If I add "usb = USB()" (as found in the first part of that
if-elif-else construct) before that line, I get the next traceback:
[Wed Apr 13 15:18:51 2011] up2date
Traceback (most recent call last):
File "/usr/sbin/rhnreg_ks", line 213, in
cli.run()
File "/usr/share/rhn/up2date_client/rhncli.py", line 74, in run
sys.exit(self.main() or 0)
File "/usr/sbin/rhnreg_ks", line 101, in main
hardwareList = hardware.Hardware()
File "/usr/share/rhn/up2date_client/hardware.py", line 674, in Hardware
allhw = get_devices()
File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 45, in
get_devices
'desc': _get_device_desc(device),
File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 311, in
_get_device_desc
result = "%s|%s" % (usb.get_vendor(vendor_id),
usb.get_device(vendor_id, device.get_property('ID_MODEL_ID')))
File "/usr/lib/python2.7/site-packages/hwdata.py", line 82, in get_device
device = device.lower()
: 'NoneType' object has no attribute 'lower'
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
On Wed, Apr 13, 2011 at 03:15:42PM +0100, Assaf Flatto wrote: > > > What makes you think that tomcat is waiting for httpd? > > Well , on my machine it is "waiting " for a long time ( some time even 20 > minutes ) until i manually start httpd , and then the tomcat "kick" up and > works , > I've seen it in ALL of my spoacewalk "start" and "restart" i have done. This issue was in Spacewalk nightly and it's been fixed on March 25, so it should not appear in 1.4 RC. Does it happen in 1.4 RC for you? -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 13 Apr 2011, at 15:09, Jan Pazdziora wrote: > On Wed, Apr 13, 2011 at 03:02:58PM +0100, Assaf Flatto wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA256 >> >> I've upgraded to the 1.4RC and still getting the same issue after restarting >> the server > The repo hasn't been regenerated yet, it will be in about an hour. Ok , i will wait and try another update then. > >> btw - i found that the tomcat is pending till the httpd service is starting >> , but the httpd is starting AFTER the tomcat in the spacewalk-service >> initiation file , is this a bug or by design ? >> > > What makes you think that tomcat is waiting for httpd? > Well , on my machine it is "waiting " for a long time ( some time even 20 minutes ) until i manually start httpd , and then the tomcat "kick" up and works , I've seen it in ALL of my spoacewalk "start" and "restart" i have done. > -- > Jan Pazdziora > Principal Software Engineer, Satellite Engineering, Red Hat > > ___ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list -BEGIN PGP SIGNATURE- Version: PGP Desktop 10.1.0 (Build 860) Charset: us-ascii wsBVAwUBTaWwEWK6JZrjLX7GAQgeOgf+IZNWbfEkMcgY10NA01+vMCmmKeD7D8eT rKqd+2IZ8cnUL2zF1KZvrjcdrkMjrx7bXcPf0na9kaZcV07bfazMKGyCIqoiyw12 L18dmckRaJxrkuIw3+7lzS6ZkZYxvckVNQNuLshKQ/RAT72lNHmp30grYeoVEs4A JRCt0mw0s5yX1Ljc8iARNA+PuZOfNHVCVkLGQ8vaKtlprkrZgulham83Gjhwf+XJ DTWZSbr09yID+6x8/bI944DZmvOHVkOd+iLxRLbKwret0oMTdxmGp3Aw5BjZfXbb KhaEbC+Xb3q0vVsWpNukZMytYrjaqAOxFBIoF6V7RmCU/edMDl99zQ== =HCI9 -END PGP SIGNATURE- ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
On Wed, Apr 13, 2011 at 03:02:58PM +0100, Assaf Flatto wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > I've upgraded to the 1.4RC and still getting the same issue after restarting > the server The repo hasn't been regenerated yet, it will be in about an hour. > btw - i found that the tomcat is pending till the httpd service is starting , > but the httpd is starting AFTER the tomcat in the spacewalk-service > initiation file , is this a bug or by design ? > What makes you think that tomcat is waiting for httpd? -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] error generated when running rhn_check on client
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
I've upgraded to the 1.4RC and still getting the same issue after restarting
the server
btw - i found that the tomcat is pending till the httpd service is starting ,
but the httpd is starting AFTER the tomcat in the spacewalk-service initiation
file , is this a bug or by design ?
Assaf
On 13 Apr 2011, at 12:13, Michael Mraka wrote:
> Assaf Flatto wrote:
> % Hello
> %
> % When trying to do an rhn_check on a client machine i am getting this error :
> % rhn_check -v
> % XMLRPC ProtocolError: Error>
> %
> % and i am getting the email (below) from the server .
> %
> % Can you tell me what is the issue ?
>
> I guess you are trying to deploy a configuration file from Spacewalk 1.3
> server @ PostgreSQL.
>
> It's been fixed in 1.4 RC.
>
> % Thank you
> ...
> % > SQL Error generated: ('syntax error at or near ")" at character 1296\n',
> 0, "\nselect cfn.path,\n cc.label config_channel,\n
> ccont.contents file_contents,\n ccont.is_binary is_binary,\n
>c.checksum_type,\n c.checksum,\n ccont.delim_start,\n
> ccont.delim_end,\n cr.revision,\n ci.username,\n
> ci.groupname,\n ci.filemode,\n\t cft.label,\n\t
> ci.selinux_ctx,\n case \nwhen cft.label='symlink'
> then (select path from rhnConfigFileName where id =
> ci.SYMLINK_TARGET_FILENAME_ID)\nelse ''\nend as
> symlink\t \n from \n rhnConfigFileState cfs,\n
> rhnConfigContent ccont,\n rhnChecksumView c,\n
> rhnConfigChannel cc,\n rhnConfigFileName cfn,\n
> rhnConfigInfo ci,\n rhnConfigFile cf,\n rhnConfigRevision
> cr,\n\t rhnConfigFileType c!
> % ft,
> % > \n rhnActionConfigRevision acr\n where acr.server_id =
> %(server_id)s\n and acr.action_id = %(action_id)s\n and
> acr.config_revision_id = cr.id\n and cr.config_file_id = cf.id\n
> and cr.config_info_id = ci.id\n and cf.config_file_name_id = cfn.id\n
> and cf.config_channel_id = cc.id\n and cf.state_id = cfs.id\n
> and cfs.label = 'alive'\n and cr.config_content_id = ccont.id (+)\n
> and cr.config_file_type_id = cft.id\n and ccont.checksum_id =
> c.id(+)\n")
>
> Regards,
>
> --
> Michael Mráka
> Satellite Engineering, Red Hat
>
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
-BEGIN PGP SIGNATURE-
Version: PGP Desktop 10.1.0 (Build 860)
Charset: iso-8859-1
wsBVAwUBTaWtFWK6JZrjLX7GAQhArgf+PUTedEqRGmQYfcPIW2JdFzI1psPgy8sf
M18xS039TADIjzm4r6Zv/PqL3vomyGzLh4d8/StnFHu/5zX0GUZCHcaR7k+00BjJ
lAKHixCVWE5e7SbXtzhltKIs6sPBMymX7a5w8a3a/zBqe0USLFfDQM7aPVmP3RQT
O55cJCQCGAT0JG6niJDXWVN3rR3vlzqhogk5k3Uo0k9CMEwjAVeniH47Fah16sz7
Zh4KML0nlHm+BOpV4jq2xARswypNWtEhBXiOPGXN+Kht3VNjZHsSgJQLZoAjS8Qi
vwB19TidH4v8a8l5P4MyiLz/NBoIl1C4XbJBUjdZbGO93YQ2LAeUmw==
=uHvF
-END PGP SIGNATURE-
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
On 04/13/2011 02:52 PM, Sandro "red" Mathys wrote: > 2011/4/13 Miroslav Suchý : >> It happens during gathering HW info. So if you run it with --nohardware, >> you can workaround it. > > --nohardware doesn't resolve the issue, i.e. no change at all. > >> It is some USB device. Can you run this python script in both %post >> section of kickstart and after normal reboot? Check the diferences. >> You should look for records with >> XXX: None > > Lots of XXX: None found, actually it's always None! That is strange... aha, there is typo. It should be PRODUCT and not product. Commited as ebd9948a92945026db88932eefd23c4c0c7738ea > I would disagree here, IMHO. I will back port this commit, but not the previous one. -- Miroslav Suchy Red Hat Satellite Engineering ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] spacewalk 1.4-RC cElementTree problem with spacewalk-repo-sync
Dear Martin.
for I am new on this list let me introduce myself:
My name is Martin Zehetmayer, I work for as consultant for a small linux
solution provider in germany, mostly dealing with RHEL systems.
I am currently testing spacewalk 1.4-RC6 on a RHEL6.0 x86_64 system. Installing
works very fine but when
adding packages to a custom channel I get the following error:
---
[root@spacewalk ]# spacewalk-repo-sync -u
http://10.160.14.83/cobbler/ks_mirror/testrepo -c testchannel1-x86_64 -t yum
Traceback (most recent call last):
File "/usr/bin/spacewalk-repo-sync", line 69, in
sys.exit(abs(main() or 0))
File "/usr/bin/spacewalk-repo-sync", line 63, in main
sync.main()
File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", line
108, in main
plugin = self.load_plugin()(url, self.channel_label)
File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", line
137, in load_plugin
mod = __import__('spacewalk.satellite_tools.repo_plugins', globals(),
locals(), [name])
File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/repo_plugins/yum_src.py",
line 25, in
import cElementTree
ImportError: No module named cElementTree
---
After searching I found a post in this list from Michael Calmer which reports
the same error under SLES. As mentioned above I tested it under RHEL6 and the
same problem appear. It can be solved using three tests as suggested from
Michael.
Fixed in latest sync. Just update using the 1.4-RC repository.
Greets
Marcus
PS: your search does not seem to have included recent topics.
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] spacewalk 1.4-RC cElementTree problem with spacewalk-repo-sync
Hi,
for I am new on this list let me introduce myself:
My name is Martin Zehetmayer, I work for as consultant for a small linux
solution provider in germany, mostly dealing with RHEL systems.
I am currently testing spacewalk 1.4-RC6 on a RHEL6.0 x86_64 system. Installing
works very fine but when
adding packages to a custom channel I get the following error:
---
[root@spacewalk ]# spacewalk-repo-sync -u
http://10.160.14.83/cobbler/ks_mirror/testrepo -c testchannel1-x86_64 -t yum
Traceback (most recent call last):
File "/usr/bin/spacewalk-repo-sync", line 69, in
sys.exit(abs(main() or 0))
File "/usr/bin/spacewalk-repo-sync", line 63, in main
sync.main()
File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", line
108, in main
plugin = self.load_plugin()(url, self.channel_label)
File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", line
137, in load_plugin
mod = __import__('spacewalk.satellite_tools.repo_plugins', globals(),
locals(), [name])
File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/repo_plugins/yum_src.py",
line 25, in
import cElementTree
ImportError: No module named cElementTree
---
After searching I found a post in this list from Michael Calmer which reports
the same error under SLES. As mentioned above I tested it under RHEL6 and the
same problem appear. It can be solved using three tests as suggested from
Michael.
Here is a diff of my changed yum_src.py:
--- snip ---
---
/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/repo_plugins/yum_src.py.old
2011-04-13 17:03:44.611896473 +0200
+++
/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/repo_plugins/yum_src.py
2011-04-13 17:03:35.378881722 +0200
@@ -19,11 +19,17 @@
import gzip
from yum.update_md import UpdateMetadata, UpdateNoticeException, UpdateNotice
from yum.yumRepo import YumRepository
+
try:
from yum.misc import cElementTree_iterparse as iterparse
except ImportError:
-import cElementTree
-iterparse = cElementTree.iterparse
+try:
+from xml.etree import cElementTree
+except ImportError:
+import cElementTree
+iterparse = cElementTree.iterparse
+
+
-- snap ---
For I do not know how to reference the thread this problem was originally
posted in I open an new one.
best regards,
Martin
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
2011/4/13 Miroslav Suchý :
> On 04/13/2011 08:24 AM, Sandro "red" Mathys wrote:
>> Hi,
>>
>> We tried to deploy a F15 system (with the latest from updates-testing)
>> from spacewalk 1.3 which works just fine (yay!) except for rhnreg_ks
>> (rhn-setup 1.4.15-1.fc14) which fails with the following traceback:
>>
>> [Tue Apr 12 16:15:15 2011] up2date
>> Traceback (most recent call last):
>> File "/usr/sbin/rhnreg_ks", line 213, in
>> cli.run()
>> File "/usr/share/rhn/up2date_client/rhncli.py", line 74, in run
>> sys.exit(self.main() or 0)
>> File "/usr/sbin/rhnreg_ks", line 101, in main
>> hardwareList = hardware.Hardware()
>> File "/usr/share/rhn/up2date_client/hardware.py", line 674, in Hardware
>> allhw = get_devices()
>> File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 45, in
>> get_devices
>> 'desc': _get_device_desc(device),
>> File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 306, in
>> _get_device_desc
>> (vendor_id, model_id) = device.get_property('product').split('/')[:2]
>> : 'NoneType' object has no attribute
>> 'split'
>>
>> It seems that device.get_propery('product') returns None but does
>> somebody have an idea why it does so? On what information does this
>> rely? i.e. is there a service not running that should be or a package
>> missing?
>>
>> Is the extracted information actually important? If not, the thrown
>> exception should rather be caught.
>
>
> It happens during gathering HW info. So if you run it with --nohardware,
> you can workaround it.
--nohardware doesn't resolve the issue, i.e. no change at all.
> It is some USB device. Can you run this python script in both %post
> section of kickstart and after normal reboot? Check the diferences.
> You should look for records with
> XXX: None
Lots of XXX: None found, actually it's always None!
>
> import gudev
> import glib
>
> print "GUDEV VERSION: %s" % gudev.__version__
>
> def print_device(device):
> print "subsystem", device.get_subsystem()
> print "devtype", device.get_devtype()
> print "name", device.get_name()
> print "number", device.get_number()
> print "sysfs_path:", device.get_sysfs_path()
> print "XXX: ", device.get_property('product')
>
> devices = client.query_by_subsystem("usb")
The variable client is not defined at this point, so I added:
client = gudev.Client([""])
> for device in devices:
> print_device(device)
>
>
> But yeah, having test before that split is probably good idea. I will
> put it in master, but this is not worth of backporting to 1.4.
I would disagree here, IMHO.
Here's the full output of your debug script:
GUDEV VERSION: 147.1
subsystem usb
devtype usb_device
name usb1
number 1
sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1
XXX: None
subsystem usb
devtype usb_interface
name 1-0:1.0
number 0
sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1/1-0:1.0
XXX: None
subsystem usb
devtype usb_device
name 1-1
number 1
sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1/1-1
XXX: None
subsystem usb
devtype usb_interface
name 1-1:1.0
number 0
sysfs_path: /sys/devices/pci:00/:00:1a.0/usb1/1-1/1-1:1.0
XXX: None
subsystem usb
devtype usb_device
name usb2
number 2
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2
XXX: None
subsystem usb
devtype usb_interface
name 2-0:1.0
number 0
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-0:1.0
XXX: None
subsystem usb
devtype usb_device
name 2-1
number 1
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1
XXX: None
subsystem usb
devtype usb_device
name 2-1.1
number 1
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1
XXX: None
subsystem usb
devtype usb_device
name 2-1.1.1
number 1
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.1
XXX: None
subsystem usb
devtype usb_interface
name 2-1.1.1:1.0
number 0
sysfs_path:
/sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.1/2-1.1.1:1.0
XXX: None
subsystem usb
devtype usb_interface
name 2-1.1.1:1.1
number 1
sysfs_path:
/sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.1/2-1.1.1:1.1
XXX: None
subsystem usb
devtype usb_device
name 2-1.1.4
number 4
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.4
XXX: None
subsystem usb
devtype usb_interface
name 2-1.1.4:1.0
number 0
sysfs_path:
/sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.4/2-1.1.4:1.0
XXX: None
subsystem usb
devtype usb_interface
name 2-1.1.4:1.1
number 1
sysfs_path:
/sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.4/2-1.1.4:1.1
XXX: None
subsystem usb
devtype None
name hiddev0
number 0
sysfs_path:
/sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1.4/2-1.1.4:1.1/usb/hiddev0
XXX: None
subsystem usb
devtype usb_interface
name 2-1.1:1.0
number 0
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1.1/2-1.1:1.0
XXX: None
subsystem usb
devtype usb_interface
name 2-1:1.0
number 0
sysfs_path: /sys/devices/pci:00/:00:1d.0/usb2/2-1/2-1:1.0
Re: [Spacewalk-list] error generated when running rhn_check on client
Assaf Flatto wrote:
% Hello
%
% When trying to do an rhn_check on a client machine i am getting this error :
% rhn_check -v
% XMLRPC ProtocolError:
%
% and i am getting the email (below) from the server .
%
% Can you tell me what is the issue ?
I guess you are trying to deploy a configuration file from Spacewalk 1.3
server @ PostgreSQL.
It's been fixed in 1.4 RC.
% Thank you
...
% > SQL Error generated: ('syntax error at or near ")" at character 1296\n', 0,
"\nselect cfn.path,\n cc.label config_channel,\n
ccont.contents file_contents,\n ccont.is_binary is_binary,\n
c.checksum_type,\n c.checksum,\n ccont.delim_start,\n
ccont.delim_end,\n cr.revision,\n ci.username,\n
ci.groupname,\n ci.filemode,\n\t cft.label,\n\t
ci.selinux_ctx,\n case \nwhen cft.label='symlink'
then (select path from rhnConfigFileName where id =
ci.SYMLINK_TARGET_FILENAME_ID)\nelse ''\nend as
symlink\t \n from \n rhnConfigFileState cfs,\n
rhnConfigContent ccont,\n rhnChecksumView c,\n
rhnConfigChannel cc,\n rhnConfigFileName cfn,\n
rhnConfigInfo ci,\n rhnConfigFile cf,\n rhnConfigRevision
cr,\n\t rhnConfigFileType c!
% ft,
% > \n rhnActionConfigRevision acr\n where acr.server_id =
%(server_id)s\n and acr.action_id = %(action_id)s\n and
acr.config_revision_id = cr.id\n and cr.config_file_id = cf.id\n
and cr.config_info_id = ci.id\n and cf.config_file_name_id = cfn.id\n
and cf.config_channel_id = cc.id\n and cf.state_id = cfs.id\n and
cfs.label = 'alive'\n and cr.config_content_id = ccont.id (+)\n and
cr.config_file_type_id = cft.id\n and ccont.checksum_id = c.id(+)\n")
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
On 04/13/2011 12:49 PM, Miroslav Suchý wrote: > But yeah, having test before that split is probably good idea. I will > put it in master, but this is not worth of backporting to 1.4. > commited as 2a2952d58bc3417ca78a847e967f74700d3e3522 -- Miroslav Suchy Red Hat Satellite Engineering ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] rhnreg_ks on F15
On 04/13/2011 08:24 AM, Sandro "red" Mathys wrote:
> Hi,
>
> We tried to deploy a F15 system (with the latest from updates-testing)
> from spacewalk 1.3 which works just fine (yay!) except for rhnreg_ks
> (rhn-setup 1.4.15-1.fc14) which fails with the following traceback:
>
> [Tue Apr 12 16:15:15 2011] up2date
> Traceback (most recent call last):
> File "/usr/sbin/rhnreg_ks", line 213, in
> cli.run()
> File "/usr/share/rhn/up2date_client/rhncli.py", line 74, in run
> sys.exit(self.main() or 0)
> File "/usr/sbin/rhnreg_ks", line 101, in main
> hardwareList = hardware.Hardware()
> File "/usr/share/rhn/up2date_client/hardware.py", line 674, in Hardware
> allhw = get_devices()
> File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 45, in
> get_devices
> 'desc': _get_device_desc(device),
> File "/usr/share/rhn/up2date_client/hardware_gudev.py", line 306, in
> _get_device_desc
> (vendor_id, model_id) = device.get_property('product').split('/')[:2]
> : 'NoneType' object has no attribute 'split'
>
> It seems that device.get_propery('product') returns None but does
> somebody have an idea why it does so? On what information does this
> rely? i.e. is there a service not running that should be or a package
> missing?
>
> Is the extracted information actually important? If not, the thrown
> exception should rather be caught.
It happens during gathering HW info. So if you run it with --nohardware,
you can workaround it.
It is some USB device. Can you run this python script in both %post
section of kickstart and after normal reboot? Check the diferences.
You should look for records with
XXX: None
import gudev
import glib
print "GUDEV VERSION: %s" % gudev.__version__
def print_device(device):
print "subsystem", device.get_subsystem()
print "devtype", device.get_devtype()
print "name", device.get_name()
print "number", device.get_number()
print "sysfs_path:", device.get_sysfs_path()
print "XXX: ", device.get_property('product')
devices = client.query_by_subsystem("usb")
for device in devices:
print_device(device)
But yeah, having test before that split is probably good idea. I will
put it in master, but this is not worth of backporting to 1.4.
--
Miroslav Suchy
Red Hat Satellite Engineering
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Dell OpenManage
I've tried to use dell-satellite-sync with test installations of Spacewalk 1.2 and 1.3, but with a couple of pitfalls. You have to edit a couple of lines of the Python code to tell it which channels to use as it is tailored for RHEL. The other problem I ran in to but didn't have time to investigate thoroughly was that Dell changed the structure of the OpenManage repository with 6.3 (I think) which resulted in dell-satellite-sync trying to put RPMs with the same name but different hashes into multiple channels, which Spacewalk then objects to. From memory, I think it was something to do with the noarch packages, but I can't remember exactly. Edward Dore Freethought Internet - Original Message - From: "Baptiste AGASSE" To: "spacewalk-list" Sent: Wednesday, 13 April, 2011 11:18:01 AM Subject: [Spacewalk-list] Dell OpenManage Hi all, I've a lot of Dell servers and i want to provide centralized Dell repo management. I' already use spacewalk for CentOS repos in test env and cobbler in production, and i want to replace cobbler with spacewalk in the next months. Anyone use spacewalk to provide Dell OpenManage for these servers ? I've found "dell-satellite-sync" (https://fedorahosted.org/dell-satellite-sync/), anyone use it ? is it maintained ? Regards Baptiste AGASSE Lyra Network, Service Systèmes et Réseaux Rue Carmin, BP 87350, 31673 Labège Cedex - France Tél: (+33)5.67.22.31.87 Fax: (+33)5.67.22.31.61 Mail: baptiste.aga...@lyra-network.com Site: http://www.lyra-network.com ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] error generated when running rhn_check on client
Hello
When trying to do an rhn_check on a client machine i am getting this error :
rhn_check -v
XMLRPC ProtocolError:
and i am getting the email (below) from the server .
Can you tell me what is the issue ?
Thank you
>
>
> Exception reported from FOO
> Time: Wed Apr 13 10:04:56 2011
> Exception type spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError
> Exception while handling function queue.get
> Request object information:
> URI: /XMLRPC
> Remote Host: X.X.X.X
> Server Name: FOO0
> Headers passed in:
> Accept-Encoding: identity
> Content-Length: 2715
> Host: FOO
> content-type: text/xml
> user-agent: rhn.rpclib.py/$Revision$
> x-client-version: 1
> x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
> x-rhn-client-capability:
> osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1
> x-rhn-transport-capability: follow-redirects=3
> x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc
> (version $Revision$)
> x-up2date-version: 1.3.12-1.el6
> Extra information about this error:
> SQL Error generated: ('syntax error at or near ")" at character 1296\n', 0,
> "\nselect cfn.path,\n cc.label config_channel,\n
> ccont.contents file_contents,\n ccont.is_binary is_binary,\n
>c.checksum_type,\n c.checksum,\n ccont.delim_start,\n
> ccont.delim_end,\n cr.revision,\n ci.username,\n
> ci.groupname,\n ci.filemode,\n\t cft.label,\n\t
> ci.selinux_ctx,\n case \nwhen cft.label='symlink'
> then (select path from rhnConfigFileName where id =
> ci.SYMLINK_TARGET_FILENAME_ID)\nelse ''\nend as
> symlink\t \n from \n rhnConfigFileState cfs,\n
> rhnConfigContent ccont,\n rhnChecksumView c,\n
> rhnConfigChannel cc,\n rhnConfigFileName cfn,\n
> rhnConfigInfo ci,\n rhnConfigFile cf,\n rhnConfigRevision
> cr,\n\t rhnConfigFileType c!
ft,
> \n rhnActionConfigRevision acr\n where acr.server_id =
> %(server_id)s\n and acr.action_id = %(action_id)s\n and
> acr.config_revision_id = cr.id\n and cr.config_file_id = cf.id\n
> and cr.config_info_id = ci.id\n and cf.config_file_name_id = cfn.id\n
> and cf.config_channel_id = cc.id\n and cf.state_id = cfs.id\n
> and cfs.label = 'alive'\n and cr.config_content_id = ccont.id (+)\n
> and cr.config_file_type_id = cft.id\n and ccont.checksum_id =
> c.id(+)\n")
>
> Exception Handler Information
> Traceback (most recent call last):
> File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py",
> line 118, in call_function
>response = apply(func, params)
> File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 326, in get
>ret = self.__getV2(action)
> File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 84, in __getV2
>result = method(self.server_id, action['id'], dry_run)
> File
> "/usr/lib/python2.4/site-packages/spacewalk/server/action/configfiles.py",
> line 103, in deploy
>return _get_files(server_id, action_id)
> File
> "/usr/lib/python2.4/site-packages/spacewalk/server/action/configfiles.py",
> line 159, in _get_files
>h.execute(action_id=action_id, server_id=server_id)
> File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py",
> line 163, in execute
>return apply(self._execute_wrapper, (self._execute, ) + p, kw)
> File
> "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
> line 268, in _execute_wrapper
>raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
> SQLStatementPrepareError: ('syntax error at or near ")" at character 1296\n',
> 0, "\nselect cfn.path,\n cc.label config_channel,\n
> ccont.contents file_contents,\n ccont.is_binary is_binary,\n
>c.checksum_type,\n c.checksum,\n ccont.delim_start,\n
> ccont.delim_end,\n cr.revision,\n ci.username,\n
> ci.groupname,\n ci.filemode,\n\t cft.label,\n\t
>
[Spacewalk-list] Dell OpenManage
Hi all, I've a lot of Dell servers and i want to provide centralized Dell repo management. I' already use spacewalk for CentOS repos in test env and cobbler in production, and i want to replace cobbler with spacewalk in the next months. Anyone use spacewalk to provide Dell OpenManage for these servers ? I've found "dell-satellite-sync" (https://fedorahosted.org/dell-satellite-sync/), anyone use it ? is it maintained ? Regards Baptiste AGASSE Lyra Network, Service Systèmes et Réseaux Rue Carmin, BP 87350, 31673 Labège Cedex - France Tél: (+33)5.67.22.31.87 Fax: (+33)5.67.22.31.61 Mail: baptiste.aga...@lyra-network.com Site: http://www.lyra-network.com ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] OSA-00933 on Remote Command
Trevor T Kates wrote:
% List:
%
% Spacewalk Version: 1.4 RC
% OS Version: CentOS 5.6
%
% Problem: Receiving attached error after scheduling remote command via web
interface
%
% Thank you for any assistance with this problem.
%
%
___
% Trevor T. Kates
%
% Exception reported from idmssat00.vancpower.com
...
% SQL Error generated: ('ORA-00933: SQL command not properly ended\n', 933,
"insert into rhnServerActionScriptResult ( server_id, action_script_id, output,
start_date, stop_date, return_code ) select :server_id, ascript.id,
empty_blob(), TO_DATE(:process_start, '-MM-DD HH24:MI:SS'),
TO_DATE(:process_end, '-MM-DD HH24:MI:SS'), :return_code from
rhnActionScript ascript where ascript.action_id = :action_id returning output
into :output_blob")
Hi Trevor,
this is an error in blob insert routine; I've fixed it both in master
and spacewalk-1.4 branch (spacewalk-backend-1.4.37-1).
Thanks for the report.
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] how to clear a channel
Here https://www.redhat.com/archives/spacewalk-list/2011-April/msg00050.html is a suggestion to "clear out" base and update channel. How do I do that? ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Database user data
d...@fedoraproject.org wrote: % On Tue, 12 Apr 2011, Michael Mraka wrote: % >William S. wrote: % >% % >% On average, do folks exceed the 4GB limitation with Oracle Xe? I'm trying to gauge on what sort of real data is stored in the DB, and how quickly I would run out of space. % > % >Some time ago I did estimates for Spacewalk 1.1 and came to formula % >* 250 KiB per client system, % >* 500 KiB per channel + 230 KiB per package in channel (i.e. 1.1GiB for channel % >with 5000 packages). % > % >It might be slightly lower number nowadays because we optimized % >changelog data storage which was quite hoggish :). % % I found the following in the Satellite 5.4 install docs: % % A single 6 GB tablespace is recommended as more than sufficient for % most installations. % * 192 KB per client system % * 64 MB per channel % % For instance, an RHN Satellite containing 10 channels serving 10,000 % systems would require 1.92 GB for its clients and 640 MB for its % channels. % % Database storage needs may grow rapidly, depending upon the variance % of the following factors: % * The number of public Red Hat packages imported (typical: 5000) % * The number of private packages to be managed (typical: 500) % * The number of systems to be managed (typical: 1000) % * The number of packages installed on the average system (typical: 500) Yes, these were old estimates which are no more accurate so I went ahead and created new, more appropriate, one. Regards, -- Michael Mráka Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
