wiki:TracQuery

Trac Ticket Queries

In addition to reports, Trac provides support for custom ticket queries, used to display lists of tickets meeting a specified set of criteria.

To configure and execute a custom query, switch to the View Tickets module from the navigation bar, and select the Custom Query link.

Filters

When you first go to the query page the default filter will display tickets relevant to you:

  • If logged in then all open tickets it will display open tickets assigned to you.
  • If not logged in but you have specified a name or email address in the preferences then it will display all open tickets where your email (or name if email not defined) is in the CC list.
  • If not logged and no name/email defined in the preferences then all open issues are displayed.

Current filters can be removed by clicking the button to the left with the minus sign on the label. New filters are added from the pulldown lists at the bottom corners of the filters box ('And' conditions on the left, 'Or' conditions on the right). Filters with either a text box or a pulldown menu of options can be added multiple times to perform an or of the criteria.

You can use the fields just below the filters box to group the results based on a field, or display the full description for each ticket.

Once you've edited your filters click the Update button to refresh your results.

Clicking on one of the query results will take you to that ticket. You can navigate through the results by clicking the Next Ticket or Previous Ticket links just below the main menu bar, or click the Back to Query link to return to the query page.

You can safely edit any of the tickets and continue to navigate through the results using the Next/Previous/Back to Query links after saving your results. When you return to the query any tickets which were edited will be displayed with italicized text. If one of the tickets was edited such that it no longer matches the query criteria the text will also be greyed. Lastly, if a new ticket matching the query criteria has been created, it will be shown in bold.

The query results can be refreshed and cleared of these status indicators by clicking the Update button again.

Saving Queries

Trac allows you to save the query as a named query accessible from the reports module. To save a query ensure that you have Updated the view and then click the Save query button displayed beneath the results. You can also save references to queries in Wiki content, as described below.

Note: one way to easily build queries like the ones below, you can build and test the queries in the Custom report module and when ready - click Save query. This will build the query string for you. All you need to do is remove the extra line breaks.

Note: you must have the REPORT_CREATE permission in order to save queries to the list of default reports. The Save query button will only appear if you are logged in as a user that has been granted this permission. If your account does not have permission to create reports, you can still use the methods below to save a query.

You may want to save some queries so that you can come back to them later. You can do this by making a link to the query from any Wiki page.

[query:status=new|assigned|reopened&version=1.0 Active tickets against 1.0]

Which is displayed as:

Active tickets against 1.0

This uses a very simple query language to specify the criteria (see Query Language).

Alternatively, you can copy the query string of a query and paste that into the Wiki link, including the leading ? character:

[query:?status=new&status=assigned&status=reopened&group=owner Assigned tickets by owner]

Which is displayed as:

Assigned tickets by owner

Using the [[TicketQuery]] Macro

The TicketQuery macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.

Example:

[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]

This is displayed as:

No results

Just like the query: wiki links, the parameter of this macro expects a query string formatted according to the rules of the simple ticket query language. This also allows displaying the link and description of a single ticket:

[[TicketQuery(id=123)]]

This is displayed as:

#123
using custom disk partitions causes newfs to skip/fail during install

A more compact representation without the ticket summaries is also available:

[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]

This is displayed as:

No results

Finally, if you wish to receive only the number of defects that match the query, use the count parameter.

[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]

This is displayed as:

0

Customizing the table format

You can also customize the columns displayed in the table format (format=table) by using col=<field> - you can specify multiple fields and what order they are displayed by placing pipes (|) between the columns like below:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]

This is displayed as:

Results (1 - 3 of 1012)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#1450 deferred CD detection should detect blank CDs ken joshms
#1449 deferred HTTPS does not work with Static IP TWiN
#1448 duplicate Cannot get printer working in 10.0.2 q/pa
1 2 3 4 5 6 7 8 9 10 11

Full rows

In table format you can also have full rows by using rows=<field> like below:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]

This is displayed as:

Results (1 - 3 of 1012)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#1450 deferred CD detection should detect blank CDs ken joshms
Description

CD detection should detect blank CDs and suggest a burning program.

#1449 deferred HTTPS does not work with Static IP TWiN
Description

I have tried any kind of browser and I cannot connect to any HTTP or secure server. If I use HTTP I do not have any problems.

I have tried several computers and several different network cards (Gb and 10/100 ) and I can reproduce the problem every single time.

This only happen when the IP is static, but not in DHCP

I have tried with and without a proxy configuration installed and my system is fully updated.

When I say "it doesn't work" I mean that the browsers waits until the timeout is reached and no connection is made. Even if I try with "fetch" or "wget" I get timeout results.

This is my diag. report:

PC-BSD 10.0-RELEASE-p15 Diagnostic Sheet
Generated: Mon Aug 11 11:28:47 EDT 2014

---------------PC-BSD Packages------------------------

pcbsd-base-1402603526
pcbsd-meta-lxde-1400073211
pcbsd-meta-nvidia-1366133527
pcbsd-utils-1403205162
pcbsd-utils-qt4-1403185164

-----------------Dmesg Output-------------------------

Copyright (c) 1992-2014 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
	The Regents of the University of California. All rights reserved.
FreeBSD is a registered trademark of The FreeBSD Foundation.
FreeBSD 10.0-RELEASE-p15 #0: Wed Jul  9 15:46:53 UTC 2014
    root@amd64-builder.pcbsd.org:/usr/obj/usr/src/sys/GENERIC amd64
FreeBSD clang version 3.3 (tags/RELEASE_33/final 183502) 20130610
CPU: AMD Athlon(tm) Dual Core Processor 4850e (2505.28-MHz K8-class CPU)
  Origin = "AuthenticAMD"  Id = 0x60fb2  Family = 0xf  Model = 0x6b  Stepping = 2
  Features=0x178bfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,MMX,FXSR,SSE,SSE2,HTT>
  Features2=0x2001<SSE3,CX16>
  AMD Features=0xea500800<SYSCALL,NX,MMX+,FFXSR,RDTSCP,LM,3DNow!+,3DNow!>
  AMD Features2=0x11f<LAHF,CMP,SVM,ExtAPIC,CR8,Prefetch>
real memory  = 4831838208 (4608 MB)
avail memory = 4032311296 (3845 MB)
Event timer "LAPIC" quality 400
ACPI APIC Table: <DELL   bMk    >
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
FreeBSD/SMP: 1 package(s) x 2 core(s)
 cpu0 (BSP): APIC ID:  0
 cpu1 (AP): APIC ID:  1
ioapic0: Changing APIC ID to 4
ioapic0 <Version 1.1> irqs 0-23 on motherboard
kbd1 at kbdmux0
random: <Software, Yarrow> initialized
cryptosoft0: <software crypto> on motherboard
aesni0: No AESNI support.
acpi0: <DELL bMk    > on motherboard
acpi0: Power Button (fixed)
acpi0: reservation of 0, a0000 (3) failed
acpi0: reservation of 100000, dbdd0000 (3) failed
cpu0: <ACPI CPU> on acpi0
cpu1: <ACPI CPU> on acpi0
attimer0: <AT timer> port 0x40-0x43 irq 0 on acpi0
Timecounter "i8254" frequency 1193182 Hz quality 0
Event timer "i8254" frequency 1193182 Hz quality 100
atrtc0: <AT realtime clock> port 0x70-0x73 irq 8 on acpi0
Event timer "RTC" frequency 32768 Hz quality 0
Timecounter "ACPI-fast" frequency 3579545 Hz quality 900
acpi_timer0: <24-bit timer at 3.579545MHz> port 0x1008-0x100b on acpi0
hpet0: <High Precision Event Timer> iomem 0xfeff0000-0xfeff03ff on acpi0
Timecounter "HPET" frequency 25000000 Hz quality 950
acpi_button0: <Power Button> on acpi0
pcib0: <ACPI Host-PCI bridge> port 0xcf8-0xcff on acpi0
pcib0: Length mismatch for 4 range: 81 vs 7f
pci0: <ACPI PCI bus> on pcib0
pci0: <memory, RAM> at device 0.0 (no driver attached)
pci0: <memory, RAM> at device 0.1 (no driver attached)
pci0: <memory, RAM> at device 0.2 (no driver attached)
pci0: <memory, RAM> at device 0.3 (no driver attached)
pci0: <memory, RAM> at device 0.4 (no driver attached)
pci0: <memory, RAM> at device 0.5 (no driver attached)
pci0: <memory, RAM> at device 0.6 (no driver attached)
pci0: <memory, RAM> at device 0.7 (no driver attached)
pcib1: <ACPI PCI-PCI bridge> at device 2.0 on pci0
pci1: <ACPI PCI bus> on pcib1
pcib2: <ACPI PCI-PCI bridge> at device 3.0 on pci0
pci2: <ACPI PCI bus> on pcib2
pcib3: <ACPI PCI-PCI bridge> at device 4.0 on pci0
pci3: <ACPI PCI bus> on pcib3
vgapci0: <VGA-compatible display> mem 0xfb000000-0xfbffffff,0xe0000000-0xefffffff,0xfc000000-0xfcffffff irq 16 at device 5.0 on pci0
NVRM: The NVIDIA GeForce 6150 LE GPU installed in this system is
NVRM:  supported through the NVIDIA 304.xx Legacy drivers. Please
NVRM:  visit http://www.nvidia.com/object/unix.html for more
NVRM:  information.  The 331.67 NVIDIA driver will ignore
NVRM:  this GPU.  Continuing probe...
vgapci0: Boot video device
pci0: <memory, RAM> at device 9.0 (no driver attached)
isab0: <PCI-ISA bridge> port 0x1d00-0x1dff at device 10.0 on pci0
isa0: <ISA bus> on isab0
pci0: <serial bus, SMBus> at device 10.1 (no driver attached)
pci0: <memory, RAM> at device 10.2 (no driver attached)
ohci0: <OHCI (generic) USB controller> mem 0xfe02f000-0xfe02ffff irq 21 at device 11.0 on pci0
usbus0 on ohci0
ehci0: <EHCI (generic) USB 2.0 controller> mem 0xfe02e000-0xfe02e0ff irq 22 at device 11.1 on pci0
usbus1: EHCI version 1.0
usbus1 on ehci0
atapci0: <nVidia nForce MCP51 SATA300 controller> port 0x9f0-0x9f7,0xbf0-0xbf3,0x970-0x977,0xb70-0xb73,0xe000-0xe00f mem 0xfe02d000-0xfe02dfff irq 23 at device 14.0 on pci0
ata2: <ATA channel> at channel 0 on atapci0
ata3: <ATA channel> at channel 1 on atapci0
atapci1: <nVidia nForce MCP51 SATA300 controller> port 0x9e0-0x9e7,0xbe0-0xbe3,0x960-0x967,0xb60-0xb63,0xcc00-0xcc0f mem 0xfe02c000-0xfe02cfff irq 20 at device 15.0 on pci0
ata4: <ATA channel> at channel 0 on atapci1
ata5: <ATA channel> at channel 1 on atapci1
pcib4: <ACPI PCI-PCI bridge> at device 16.0 on pci0
pci4: <ACPI PCI bus> on pcib4
vr0: <VIA VT6105 Rhine III 10/100BaseTX> port 0x9c00-0x9cff mem 0xfdaff000-0xfdaff0ff irq 16 at device 8.0 on pci4
vr0: Quirks: 0x0
vr0: Revision: 0x86
miibus0: <MII bus> on vr0
ukphy0: <Generic IEEE 802.3u media interface> PHY 1 on miibus0
ukphy0:  none, 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto, auto-flow
vr0: Ethernet address: 00:24:01:00:0c:2a
uart0: <16550 or compatible> port 0x3f8-0x3ff irq 4 flags 0x10 on acpi0
ppc0: <Parallel port> port 0x378-0x37f irq 7 on acpi0
ppc0: Generic chipset (EPP/NIBBLE) in COMPATIBLE mode
ppbus0: <Parallel port bus> on ppc0
lpt0: <Printer> on ppbus0
lpt0: Interrupt-driven port
ppi0: <Parallel I/O> on ppbus0
sc0: <System console> at flags 0x100 on isa0
sc0: VGA <16 virtual consoles, flags=0x300>
vga0: <Generic ISA VGA> at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0
atkbdc0: <Keyboard controller (i8042)> at port 0x60,0x64 on isa0
atkbd0: <AT Keyboard> irq 1 on atkbdc0
kbd0 at atkbd0
atkbd0: [GIANT-LOCKED]
powernow0: <PowerNow! K8> on cpu0
powernow1: <PowerNow! K8> on cpu1
ZFS NOTICE: Prefetch is disabled by default if less than 4GB of RAM is present;
            to enable, add "vfs.zfs.prefetch_disable=0" to /boot/loader.conf.
ZFS filesystem version: 5
ZFS storage pool version: features support (5000)
Timecounters tick every 1.000 msec
random: unblocking device.
usbus0: 12Mbps Full Speed USB v1.0
usbus1: 480Mbps High Speed USB v2.0
ugen0.1: <nVidia> at usbus0
uhub0: <nVidia OHCI root HUB, class 9/0, rev 1.00/1.00, addr 1> on usbus0
ugen1.1: <nVidia> at usbus1
uhub1: <nVidia EHCI root HUB, class 9/0, rev 2.00/1.00, addr 1> on usbus1
uhub0: 6 ports with 6 removable, self powered
ada0 at ata2 bus 0 scbus0 target 0 lun 0
ada0: <ST3160318AS CC44> ATA-8 SATA 2.x device
ada0: Serial Number 6VY1DNQT
ada0: 300.000MB/s transfers (SATA 2.x, UDMA5, PIO 8192bytes)
ada0: 152587MB (312500000 512 byte sectors: 16H 63S/T 16383C)
ada0: Previously was known as ad4
cd0 at ata3 bus 0 scbus1 target 0 lun 0
cd0: <PBDS CDRWDVD DH-48C2S ND12> Removable CD-ROM SCSI-0 device 
cd0: Serial Number 2009040100782041
cd0: 150.000MB/s transfers (SATA 1.x, UDMA5, ATAPI 12bytes, PIO 8192bytes)
cd0: Attempt to query device size failed: NOT READY, Medium not present
Netvsc initializing... SMP: AP CPU #1 Launched!
Root mount waiting for: usbus1
uhub1: 6 ports with 6 removable, self powered
Trying to mount root from zfs:tank/ROOT/default []...
ugen0.2: <SIGMACHIP> at usbus0
ukbd0: <SIGMACHIP USB Keyboard, class 0/0, rev 1.10/1.10, addr 2> on usbus0
kbd2 at ukbd0
GEOM_ELI: Device label/swap0.eli created.
GEOM_ELI: Encryption: AES-XTS 128
GEOM_ELI:     Crypto: software
ugen0.3: <vendor 0x0000> at usbus0
ums0: <vendor 0x0000 USB OPTICAL MOUSE, class 0/0, rev 1.10/1.00, addr 3> on usbus0
ums0: 3 buttons and [XYZ] coordinates ID=1
Cuse4BSD v0.1.33 @ /dev/cuse
NVRM: The NVIDIA GeForce 6150 LE GPU installed in this system is
NVRM:  supported through the NVIDIA 304.xx Legacy drivers. Please
NVRM:  visit http://www.nvidia.com/object/unix.html for more
NVRM:  information.  The 331.67 NVIDIA driver will ignore
NVRM:  this GPU.  Continuing probe...
fuse-freebsd: version 0.4.4, FUSE ABI 7.8
uhid0: <SIGMACHIP USB Keyboard, class 0/0, rev 1.10/1.10, addr 2> on usbus0
ipfw2 (+ipv6) initialized, divert loadable, nat loadable, default to deny, logging disabled
WARNING: attempt to domain_add(bluetooth) after domainfinalize()
pid 1419 (PCDM-session), uid 0: exited on signal 11
vr0: link state changed to DOWN
vr0: link state changed to UP
vr0: link state changed to DOWN
vr0: link state changed to UP
vr0: vr_stop: Rx shutdown error
vr0: vr_stop: Rx shutdown error
vr0: Using force reset command.
vr0: link state changed to DOWN
vr0: link state changed to UP
vr0: link state changed to DOWN
vr0: link state changed to UP
vr0: link state changed to DOWN
vr0: link state changed to UP
GEOM_ELI: Device label/swap0.eli destroyed.
GEOM_ELI: Detached label/swap0.eli on last close.
Waiting (max 60 seconds) for system process `vnlru' to stop...done
Waiting (max 60 seconds) for system process `bufdaemon' to stop...done
Waiting (max 60 seconds) for system process `syncer' to stop...
Syncing disks, vnodes remaining...0 0 0 0 0 done
All buffers synced.
Uptime: 10m57s
Copyright (c) 1992-2014 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
	The Regents of the University of California. All rights reserved.
FreeBSD is a registered trademark of The FreeBSD Foundation.
FreeBSD 10.0-RELEASE-p15 #0: Wed Jul  9 15:46:53 UTC 2014
    root@amd64-builder.pcbsd.org:/usr/obj/usr/src/sys/GENERIC amd64
FreeBSD clang version 3.3 (tags/RELEASE_33/final 183502) 20130610
CPU: AMD Athlon(tm) Dual Core Processor 4850e (2505.27-MHz K8-class CPU)
  Origin = "AuthenticAMD"  Id = 0x60fb2  Family = 0xf  Model = 0x6b  Stepping = 2
  Features=0x178bfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,MMX,FXSR,SSE,SSE2,HTT>
  Features2=0x2001<SSE3,CX16>
  AMD Features=0xea500800<SYSCALL,NX,MMX+,FFXSR,RDTSCP,LM,3DNow!+,3DNow!>
  AMD Features2=0x11f<LAHF,CMP,SVM,ExtAPIC,CR8,Prefetch>
real memory  = 4831838208 (4608 MB)
avail memory = 4032311296 (3845 MB)
Event timer "LAPIC" quality 400
ACPI APIC Table: <DELL   bMk    >
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
FreeBSD/SMP: 1 package(s) x 2 core(s)
 cpu0 (BSP): APIC ID:  0
 cpu1 (AP): APIC ID:  1
ioapic0: Changing APIC ID to 4
ioapic0 <Version 1.1> irqs 0-23 on motherboard
kbd1 at kbdmux0
random: <Software, Yarrow> initialized
cryptosoft0: <software crypto> on motherboard
aesni0: No AESNI support.
acpi0: <DELL bMk    > on motherboard
acpi0: Power Button (fixed)
acpi0: reservation of 0, a0000 (3) failed
acpi0: reservation of 100000, dbdd0000 (3) failed
cpu0: <ACPI CPU> on acpi0
cpu1: <ACPI CPU> on acpi0
attimer0: <AT timer> port 0x40-0x43 irq 0 on acpi0
Timecounter "i8254" frequency 1193182 Hz quality 0
Event timer "i8254" frequency 1193182 Hz quality 100
atrtc0: <AT realtime clock> port 0x70-0x73 irq 8 on acpi0
Event timer "RTC" frequency 32768 Hz quality 0
Timecounter "ACPI-fast" frequency 3579545 Hz quality 900
acpi_timer0: <24-bit timer at 3.579545MHz> port 0x1008-0x100b on acpi0
hpet0: <High Precision Event Timer> iomem 0xfeff0000-0xfeff03ff on acpi0
Timecounter "HPET" frequency 25000000 Hz quality 950
acpi_button0: <Power Button> on acpi0
pcib0: <ACPI Host-PCI bridge> port 0xcf8-0xcff on acpi0
pcib0: Length mismatch for 4 range: 81 vs 7f
pci0: <ACPI PCI bus> on pcib0
pci0: <memory, RAM> at device 0.0 (no driver attached)
pci0: <memory, RAM> at device 0.1 (no driver attached)
pci0: <memory, RAM> at device 0.2 (no driver attached)
pci0: <memory, RAM> at device 0.3 (no driver attached)
pci0: <memory, RAM> at device 0.4 (no driver attached)
pci0: <memory, RAM> at device 0.5 (no driver attached)
pci0: <memory, RAM> at device 0.6 (no driver attached)
pci0: <memory, RAM> at device 0.7 (no driver attached)
pcib1: <ACPI PCI-PCI bridge> at device 2.0 on pci0
pci1: <ACPI PCI bus> on pcib1
pcib2: <ACPI PCI-PCI bridge> at device 3.0 on pci0
pci2: <ACPI PCI bus> on pcib2
pcib3: <ACPI PCI-PCI bridge> at device 4.0 on pci0
pci3: <ACPI PCI bus> on pcib3
vgapci0: <VGA-compatible display> mem 0xfb000000-0xfbffffff,0xe0000000-0xefffffff,0xfc000000-0xfcffffff irq 16 at device 5.0 on pci0
NVRM: The NVIDIA GeForce 6150 LE GPU installed in this system is
NVRM:  supported through the NVIDIA 304.xx Legacy drivers. Please
NVRM:  visit http://www.nvidia.com/object/unix.html for more
NVRM:  information.  The 331.67 NVIDIA driver will ignore
NVRM:  this GPU.  Continuing probe...
vgapci0: Boot video device
pci0: <memory, RAM> at device 9.0 (no driver attached)
isab0: <PCI-ISA bridge> port 0x1d00-0x1dff at device 10.0 on pci0
isa0: <ISA bus> on isab0
pci0: <serial bus, SMBus> at device 10.1 (no driver attached)
pci0: <memory, RAM> at device 10.2 (no driver attached)
ohci0: <OHCI (generic) USB controller> mem 0xfe02f000-0xfe02ffff irq 21 at device 11.0 on pci0
usbus0 on ohci0
ehci0: <EHCI (generic) USB 2.0 controller> mem 0xfe02e000-0xfe02e0ff irq 22 at device 11.1 on pci0
usbus1: EHCI version 1.0
usbus1 on ehci0
atapci0: <nVidia nForce MCP51 SATA300 controller> port 0x9f0-0x9f7,0xbf0-0xbf3,0x970-0x977,0xb70-0xb73,0xe000-0xe00f mem 0xfe02d000-0xfe02dfff irq 23 at device 14.0 on pci0
ata2: <ATA channel> at channel 0 on atapci0
ata3: <ATA channel> at channel 1 on atapci0
atapci1: <nVidia nForce MCP51 SATA300 controller> port 0x9e0-0x9e7,0xbe0-0xbe3,0x960-0x967,0xb60-0xb63,0xcc00-0xcc0f mem 0xfe02c000-0xfe02cfff irq 20 at device 15.0 on pci0
ata4: <ATA channel> at channel 0 on atapci1
ata5: <ATA channel> at channel 1 on atapci1
pcib4: <ACPI PCI-PCI bridge> at device 16.0 on pci0
pci4: <ACPI PCI bus> on pcib4
vr0: <VIA VT6105 Rhine III 10/100BaseTX> port 0x9c00-0x9cff mem 0xfdaff000-0xfdaff0ff irq 16 at device 8.0 on pci4
vr0: Quirks: 0x0
vr0: Revision: 0x86
miibus0: <MII bus> on vr0
ukphy0: <Generic IEEE 802.3u media interface> PHY 1 on miibus0
ukphy0:  none, 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto, auto-flow
vr0: Ethernet address: 00:24:01:00:0c:2a
uart0: <16550 or compatible> port 0x3f8-0x3ff irq 4 flags 0x10 on acpi0
ppc0: <Parallel port> port 0x378-0x37f irq 7 on acpi0
ppc0: Generic chipset (EPP/NIBBLE) in COMPATIBLE mode
ppbus0: <Parallel port bus> on ppc0
lpt0: <Printer> on ppbus0
lpt0: Interrupt-driven port
ppi0: <Parallel I/O> on ppbus0
sc0: <System console> at flags 0x100 on isa0
sc0: VGA <16 virtual consoles, flags=0x300>
vga0: <Generic ISA VGA> at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0
atkbdc0: <Keyboard controller (i8042)> at port 0x60,0x64 on isa0
atkbd0: <AT Keyboard> irq 1 on atkbdc0
kbd0 at atkbd0
atkbd0: [GIANT-LOCKED]
powernow0: <PowerNow! K8> on cpu0
powernow1: <PowerNow! K8> on cpu1
ZFS NOTICE: Prefetch is disabled by default if less than 4GB of RAM is present;
            to enable, add "vfs.zfs.prefetch_disable=0" to /boot/loader.conf.
ZFS filesystem version: 5
ZFS storage pool version: features support (5000)
Timecounters tick every 1.000 msec
random: unblocking device.
usbus0: 12Mbps Full Speed USB v1.0
usbus1: 480Mbps High Speed USB v2.0
ugen0.1: <nVidia> at usbus0
uhub0: <nVidia OHCI root HUB, class 9/0, rev 1.00/1.00, addr 1> on usbus0
ugen1.1: <nVidia> at usbus1
uhub1: <nVidia EHCI root HUB, class 9/0, rev 2.00/1.00, addr 1> on usbus1
uhub0: 6 ports with 6 removable, self powered
ada0 at ata2 bus 0 scbus0 target 0 lun 0
ada0: <ST3160318AS CC44> ATA-8 SATA 2.x device
ada0: Serial Number 6VY1DNQT
ada0: 300.000MB/s transfers (SATA 2.x, UDMA5, PIO 8192bytes)
ada0: 152587MB (312500000 512 byte sectors: 16H 63S/T 16383C)
ada0: Previously was known as ad4
cd0 at ata3 bus 0 scbus1 target 0 lun 0
cd0: <PBDS CDRWDVD DH-48C2S ND12> Removable CD-ROM SCSI-0 device 
cd0: Serial Number 2009040100782041
cd0: 150.000MB/s transfers (SATA 1.x, UDMA5, ATAPI 12bytes, PIO 8192bytes)
cd0: Attempt to query device size failed: NOT READY, Medium not present
Netvsc initializing... SMP: AP CPU #1 Launched!
Root mount waiting for: usbus1
uhub1: 6 ports with 6 removable, self powered
Trying to mount root from zfs:tank/ROOT/default []...
ugen0.2: <SIGMACHIP> at usbus0
ukbd0: <SIGMACHIP USB Keyboard, class 0/0, rev 1.10/1.10, addr 2> on usbus0
kbd2 at ukbd0
GEOM_ELI: Device label/swap0.eli created.
GEOM_ELI: Encryption: AES-XTS 128
GEOM_ELI:     Crypto: software
ugen0.3: <vendor 0x0000> at usbus0
ums0: <vendor 0x0000 USB OPTICAL MOUSE, class 0/0, rev 1.10/1.00, addr 3> on usbus0
ums0: 3 buttons and [XYZ] coordinates ID=1
Cuse4BSD v0.1.33 @ /dev/cuse
NVRM: The NVIDIA GeForce 6150 LE GPU installed in this system is
NVRM:  supported through the NVIDIA 304.xx Legacy drivers. Please
NVRM:  visit http://www.nvidia.com/object/unix.html for more
NVRM:  information.  The 331.67 NVIDIA driver will ignore
NVRM:  this GPU.  Continuing probe...
fuse-freebsd: version 0.4.4, FUSE ABI 7.8
uhid0: <SIGMACHIP USB Keyboard, class 0/0, rev 1.10/1.10, addr 2> on usbus0
ipfw2 (+ipv6) initialized, divert loadable, nat loadable, default to deny, logging disabled
WARNING: attempt to domain_add(bluetooth) after domainfinalize()
vr0: link state changed to DOWN
vr0: link state changed to UP
vr0: vr_stop: Rx shutdown error
vr0: vr_stop: Rx shutdown error
vr0: Using force reset command.
vr0: link state changed to DOWN
vr0: link state changed to UP

-----------------Messages Output----------------------

Aug 11 11:14:27 prod2120 devd: Executing '/etc/rc.d/dhclient quietstart vr0'
Aug 11 11:20:21 prod2120 pulseaudio[6446]: [(null)] module-detect.c: failed to detect any sound hardware.
Aug 11 11:20:21 prod2120 pulseaudio[6446]: [(null)] module.c: Failed to load module "module-detect" (argument: ""): initialization failed.
Aug 11 11:20:21 prod2120 pulseaudio[6446]: [(null)] main.c: Module load failed.
Aug 11 11:20:21 prod2120 pulseaudio[6446]: [(null)] main.c: Failed to initialize daemon.
Aug 11 11:20:22 prod2120 pulseaudio[6444]: [(null)] main.c: Daemon startup failed.
Aug 11 11:21:01 prod2120 kernel: vr0: vr_stop: Rx shutdown error
Aug 11 11:21:01 prod2120 kernel: vr0: vr_stop: Rx shutdown error
Aug 11 11:21:01 prod2120 kernel: vr0: Using force reset command.
Aug 11 11:21:01 prod2120 kernel: vr0: link state changed to DOWN
Aug 11 11:21:04 prod2120 kernel: vr0: link state changed to UP
Aug 11 11:21:04 prod2120 devd: Executing '/etc/rc.d/dhclient quietstart vr0'
Aug 11 11:21:04 prod2120 dhclient: New IP Address (vr0): 192.168.4.180
Aug 11 11:21:04 prod2120 dhclient: New Subnet Mask (vr0): 255.255.0.0
Aug 11 11:21:04 prod2120 dhclient: New Broadcast Address (vr0): 192.168.255.255
Aug 11 11:21:04 prod2120 dhclient: New Routers (vr0): 192.168.1.1
Aug 11 11:21:13 prod2120 su: BAD SU prod01 to root on /dev/pts/0
Aug 11 11:21:19 prod2120 su: BAD SU prod01 to root on /dev/pts/0
Aug 11 11:21:26 prod2120 su: prod01 to root on /dev/pts/0
Aug 11 11:25:31 prod2120 ntpd[1019]: time reset -0.537247 s

------------------pciconf-----------------------------

none0@pci0:0:0:0:	class=0x050000 card=0x02f010de chip=0x02f010de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Host Bridge'
    class      = memory
    subclass   = RAM
none1@pci0:0:0:1:	class=0x050000 card=0x02fa10de chip=0x02fa10de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Memory Controller 0'
    class      = memory
    subclass   = RAM
none2@pci0:0:0:2:	class=0x050000 card=0x02fe10de chip=0x02fe10de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Memory Controller 1'
    class      = memory
    subclass   = RAM
none3@pci0:0:0:3:	class=0x050000 card=0x02f810de chip=0x02f810de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Memory Controller 5'
    class      = memory
    subclass   = RAM
none4@pci0:0:0:4:	class=0x050000 card=0x02f910de chip=0x02f910de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Memory Controller 4'
    class      = memory
    subclass   = RAM
none5@pci0:0:0:5:	class=0x050000 card=0x02ff10de chip=0x02ff10de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Host Bridge'
    class      = memory
    subclass   = RAM
none6@pci0:0:0:6:	class=0x050000 card=0x027f10de chip=0x027f10de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Memory Controller 3'
    class      = memory
    subclass   = RAM
none7@pci0:0:0:7:	class=0x050000 card=0x027e10de chip=0x027e10de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 Memory Controller 2'
    class      = memory
    subclass   = RAM
pcib1@pci0:0:2:0:	class=0x060400 card=0x000010de chip=0x02fc10de rev=0xa1 hdr=0x01
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 PCI Express Bridge'
    class      = bridge
    subclass   = PCI-PCI
pcib2@pci0:0:3:0:	class=0x060400 card=0x000010de chip=0x02fd10de rev=0xa1 hdr=0x01
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 PCI Express Bridge'
    class      = bridge
    subclass   = PCI-PCI
pcib3@pci0:0:4:0:	class=0x060400 card=0x000010de chip=0x02fb10de rev=0xa1 hdr=0x01
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 PCI Express Bridge'
    class      = bridge
    subclass   = PCI-PCI
vgapci0@pci0:0:5:0:	class=0x030000 card=0x01ec1028 chip=0x024110de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'C51 [GeForce 6150 LE]'
    class      = display
    subclass   = VGA
none8@pci0:0:9:0:	class=0x050000 card=0xcb8410de chip=0x027010de rev=0xa2 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 Host Bridge'
    class      = memory
    subclass   = RAM
isab0@pci0:0:10:0:	class=0x060100 card=0x01ec1028 chip=0x026010de rev=0xa3 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 LPC Bridge'
    class      = bridge
    subclass   = PCI-ISA
none9@pci0:0:10:1:	class=0x0c0500 card=0x01ec1028 chip=0x026410de rev=0xa3 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 SMBus'
    class      = serial bus
    subclass   = SMBus
none10@pci0:0:10:2:	class=0x050000 card=0x01ec1028 chip=0x027210de rev=0xa3 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 Memory Controller 0'
    class      = memory
    subclass   = RAM
ohci0@pci0:0:11:0:	class=0x0c0310 card=0x01ec1028 chip=0x026d10de rev=0xa3 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 USB Controller'
    class      = serial bus
    subclass   = USB
ehci0@pci0:0:11:1:	class=0x0c0320 card=0x01ec1028 chip=0x026e10de rev=0xa3 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 USB Controller'
    class      = serial bus
    subclass   = USB
atapci0@pci0:0:14:0:	class=0x010185 card=0x01ec1028 chip=0x026610de rev=0xa1 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 Serial ATA Controller'
    class      = mass storage
    subclass   = ATA
atapci1@pci0:0:15:0:	class=0x010185 card=0x01ec1028 chip=0x026710de rev=0xa1 hdr=0x00
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 Serial ATA Controller'
    class      = mass storage
    subclass   = ATA
pcib4@pci0:0:16:0:	class=0x060401 card=0xcb8410de chip=0x026f10de rev=0xa2 hdr=0x01
    vendor     = 'NVIDIA Corporation'
    device     = 'MCP51 PCI Bridge'
    class      = bridge
    subclass   = PCI-PCI
hostb0@pci0:0:24:0:	class=0x060000 card=0x00000000 chip=0x11001022 rev=0x00 hdr=0x00
    vendor     = 'Advanced Micro Devices [AMD]'
    device     = 'K8 [Athlon64/Opteron] HyperTransport Technology Configuration'
    class      = bridge
    subclass   = HOST-PCI
hostb1@pci0:0:24:1:	class=0x060000 card=0x00000000 chip=0x11011022 rev=0x00 hdr=0x00
    vendor     = 'Advanced Micro Devices [AMD]'
    device     = 'K8 [Athlon64/Opteron] Address Map'
    class      = bridge
    subclass   = HOST-PCI
hostb2@pci0:0:24:2:	class=0x060000 card=0x00000000 chip=0x11021022 rev=0x00 hdr=0x00
    vendor     = 'Advanced Micro Devices [AMD]'
    device     = 'K8 [Athlon64/Opteron] DRAM Controller'
    class      = bridge
    subclass   = HOST-PCI
hostb3@pci0:0:24:3:	class=0x060000 card=0x00000000 chip=0x11031022 rev=0x00 hdr=0x00
    vendor     = 'Advanced Micro Devices [AMD]'
    device     = 'K8 [Athlon64/Opteron] Miscellaneous Control'
    class      = bridge
    subclass   = HOST-PCI
vr0@pci0:4:8:0:	class=0x020000 card=0x14061186 chip=0x31061106 rev=0x86 hdr=0x00
    vendor     = 'VIA Technologies, Inc.'
    device     = 'VT6105/VT6106S [Rhine-III]'
    class      = network
    subclass   = ethernet

------------------xorg.conf---------------------------



------------------RC File-----------------------------

# Auto-Enabled NICs from pc-sysinstall
ifconfig_vr0="DHCP"
# Auto-Enabled NICs from pc-sysinstall
hostname="prod2120"
zfs_enable="YES"
defaultrouter="192.168.1.1"
ifconfig_vr0_ipv6="inet6 accept_rtadv"

------------------Loader File-------------------------

# * IMPORTANT NOTICE *
# Run 'grub-mkconfig -o /boot/grub/grub.cfg' after making changes to this file
###############################################################################
nvidia_load="YES"
crypto_load="YES"
aesni_load="YES"
geom_eli_load="YES"
zfs_load="YES"

------------------Free Space--------------------------

Filesystem               1M-blocks Used  Avail Capacity  Mounted on
tank/ROOT/default           147066 3401 143665     2%    /
devfs                            0    0      0   100%    /dev
procfs                           0    0      0   100%    /proc
linprocfs                        0    0      0   100%    /compat/linux/proc
tank/tmp                    143665    0 143665     0%    /tmp
tank/usr/home               143665    0 143665     0%    /usr/home
tank/usr/home/admin         143669    4 143665     0%    /usr/home/admin
tank/usr/home/prod01        143678   13 143665     0%    /usr/home/prod01
tank/usr/jails              143665    0 143665     0%    /usr/jails
tank/usr/obj                143665    0 143665     0%    /usr/obj
tank/usr/pbi                143665    0 143665     0%    /usr/pbi
tank/usr/ports              143665    0 143665     0%    /usr/ports
tank/usr/ports/distfiles    143665    0 143665     0%    /usr/ports/distfiles
tank/usr/src                143665    0 143665     0%    /usr/src
tank/var/audit              143665    0 143665     0%    /var/audit
tank/var/log                143665    0 143665     0%    /var/log
tank/var/tmp                143666    1 143665     0%    /var/tmp

------------------System Processes--------------------

last pid: 10294;  load averages:  0.13,  0.42,  0.41  up 0+00:58:26    11:28:47
80 processes:  1 running, 78 sleeping, 1 zombie

Mem: 249M Active, 263M Inact, 851M Wired, 5468K Cache, 2503M Free
ARC: 695M Total, 333M MFU, 339M MRU, 155K Anon, 3778K Header, 20M Other
Swap: 2048M Total, 2048M Free


  PID USERNAME    THR PRI NICE   SIZE    RES STATE   C   TIME    WCPU COMMAND
 1344 root          1 -21  r31   247M   139M select  1   0:38   2.39% Xorg
 6102 prod01        2  20    0   206M 38716K select  1   0:03   1.46% pc-bugreport
  636 root          1  20    0 16796K  2028K select  1   0:02   0.59% moused
 1928 prod01        3  31    0   191M 26448K sbwait  1   0:10   0.29% lxpanel
 6271 prod01        6  20    0   899M   111M uwait   0   0:11   0.10% chrome
 5876 prod01       22  20    0   409M 91576K uwait   1   0:34   0.00% chrome
 1926 prod01        1  20    0   118M 14652K select  0   0:02   0.00% openbox
 6190 prod01        2  20    0   322M 50300K kqread  1   0:01   0.00% kdeinit4
 6238 prod01        8  20    0   373M 52392K uwait   0   0:01   0.00% kactivitymanagerd
 6251 prod01        1  20    0   464M 85156K select  0   0:01   0.00% knotify4
 1930 prod01        4  20    0   222M 24844K uwait   1   0:01   0.00% pcmanfm
 6742 root          2  32    0   202M 33788K select  0   0:01   0.00% pc-netmanager
 6241 prod01        1  20    0   305M 45492K select  0   0:01   0.00% kdeinit4
 1290 haldaemon     2  32    0 60556K  8204K select  1   0:01   0.00% hald
 1353 root          2  20    0   238M 33420K select  0   0:01   0.00% PCDM-session
 1207 root          1  20    0 90392K 17168K select  1   0:00   0.00% python2.7
 1327 root          1  20    0 23428K  2760K select  1   0:00   0.00% hald-addon-storage
 1022 root          1  20    0 14568K  1924K select  1   0:00   0.00% powerd
#1448 duplicate Cannot get printer working in 10.0.2 q/pa
Description

Thinkpad T520, 10.0.2-PRODUCTION, 10.0-RELEASE-p15

I am using an HP DeskJet? 5940. In 10.0.1 (and 10.0 or 9.x for that matter) I installed pcbsd-meta-hplip and used the appropriate PPD file and everything was fine.

In 10.0.2 (fresh install, pcbsd-meta-hplip, foomatics installed) I cannot get the printer working.

When I am using the PPD file the printer is not responding and I get the message "Filter failed".

When I am using any of the HP Deskjet 5900 series drivers or any of the 990C drivers (also recommended on openprinting.org) the printer starts printing countless of garbled signs.

Or should I try a downgrade to CUPS 1.5.4? How would I do that?

1 2 3 4 5 6 7 8 9 10 11

Query Language

query: TracLinks and the [[TicketQuery]] macro both use a mini “query language” for specifying query filters. Basically, the filters are separated by ampersands (&). Each filter then consists of the ticket field name, an operator, and one or more values. More than one value are separated by a pipe (|), meaning that the filter matches any of the values. To include a literal & or | in a value, escape the character with a backslash (\).

The available operators are:

= the field content exactly matches one of the values
~= the field content contains one or more of the values
^= the field content starts with one of the values
$= the field content ends with one of the values

All of these operators can also be negated:

!= the field content matches none of the values
!~= the field content does not contain any of the values
!^= the field content does not start with any of the values
!$= the field content does not end with any of the values

The date fields created and modified can be constrained by using the = operator and specifying a value containing two dates separated by two dots (..). Either end of the date range can be left empty, meaning that the corresponding end of the range is open. The date parser understands a few natural date specifications like "3 weeks ago", "last month" and "now", as well as Bugzilla-style date specifications like "1d", "2w", "3m" or "4y" for 1 day, 2 weeks, 3 months and 4 years, respectively. Spaces in date specifications can be left out to avoid having to quote the query string.

created=2007-01-01..2008-01-01 query tickets created in 2007
created=lastmonth..thismonth query tickets created during the previous month
modified=1weekago.. query tickets that have been modified in the last week
modified=..30daysago query tickets that have been inactive for the last 30 days

See also: TracTickets, TracReports, TracGuide

Last modified 16 months ago Last modified on 05/16/13 07:34:23