CKAN: Ticket Query

#992: Use X-forwarded-for whenever it is available to set remote IP address

rgrp — Fri, 18 Feb 2011 19:48:52 GMT

At the moment we only use X-forwarded to determine remote user address when remote-addr header is 127.0.0.1. However if a site is behind a cache remote_addr will always be the IP of the cache.

We should fix this by using x-forwarded-for header whenever available and only use remote-addr when it is not available.

Cost: 10m

#991: Checkbox defaults to True

dread — Fri, 18 Feb 2011 13:19:35 GMT

Form for new package has CheckboxExtraField? checked, when the value is False. (as used in ckanext-dgu package v3 form)

#983: 'db upgrade' creates system priviledges

dread — Sat, 12 Feb 2011 13:44:25 GMT

(should leave priviledges alone)

#977: db_upgrade errors

dread — Fri, 11 Feb 2011 10:35:58 GMT

db_upgrade (in ckan/model/init) makes call to validate_authorization_setup but forgets about rest of initialisation.

it uses self.metadata.bind.url when it should be self.metadata.bind it seems (confused by sqlmigrate update?)

#976: Documentation references knowledgeforge.net

dread — Thu, 10 Feb 2011 14:04:09 GMT

#974: Document site_description

dread — Thu, 10 Feb 2011 12:50:54 GMT

Configuration option 'ckan.site_description' isn't documented

#955: Tidy up tests

dread — Fri, 04 Feb 2011 11:35:00 GMT

Removal of init_db from every setup etc.
Get them working

#950: Move importer controller to ckanext-importer

dread — Wed, 02 Feb 2011 17:00:38 GMT

ckan/controllers/importer.py provides a Pylons UI for importing spreadsheet data into CKAN. This would better live in an extension than core CKAN.

In the same move, ckan/tests/misc/test_spreadsheet_importer.py, which is used by importer.py as well as various dgu data importers, should move into ckanext.

#946: No default system rights

dread — Mon, 31 Jan 2011 18:52:02 GMT

CKAN currently comes out of the box being uneditable. We'd like to encourage people to have open CKANs and therefore by default init the db with this right:

visitor -> is editor on -> System system

#932: Move to SQLAlchemy-Migrate 0.6

dread — Thu, 27 Jan 2011 19:31:00 GMT

Basic steps from kindly:

changing the setup.py dependencies for sqlalchemy-migrate and sqlalchemy to their latest versions.
running the migrate script on the repository (or changing the repository scripts manually).
checking in both these changes at once.

#903: Proper handling of deleted packages in Solr serps

pudo — Wed, 12 Jan 2011 11:17:34 GMT

Currently, deleted packages are filtered from search results after solr returns. That means result count can drop below the requested number, down to 0. Thus we need to filter before or in Solr.

#885: reimplement csw module to use owslib

wwaites — Sat, 25 Dec 2010 11:54:59 GMT

#884: harvest job delete operation

wwaites — Sat, 25 Dec 2010 11:50:00 GMT

implement paster subcommand to delete harvest jobs

#879: Storage auth API

rgrp — Mon, 20 Dec 2010 18:08:29 GMT

API to provide credentials to allow authorized 3rd parties (ie. one's with CKAN api keys) to make uploads to storage.

Implement as a CKAN extension.

#862: deploy rdf on catalogue.data.gov.uk

wwaites — Tue, 07 Dec 2010 12:50:37 GMT

handle various dgu extras, configure apache for autonegotiation, etc.

#860: full text indexing for semantic.ckan.net

wwaites — Tue, 07 Dec 2010 12:47:09 GMT

...

#835: Authorization CLI and Documentation

pudo — Mon, 29 Nov 2010 11:11:48 GMT

As a sysadmin I want to take CKAN out of wiki-mode into normal mode. In normal mode visitor and logged in users cannot create or add packages.

Suggest put this as an internal command in authz system and add to cli as paster command.

#832: Convert stats to a plugin

rgrp — Fri, 26 Nov 2010 10:05:15 GMT

Convert stats section to a ckan plugin.

Stats need not be in core and making it a plugin would make it easier to extend and expand.

#831: Migrate ckan trac to ckan.org

rgrp — Fri, 26 Nov 2010 08:40:20 GMT

Move ckan trac to new ckan.org location. Will also need to re-enable user accounts etc.

#828: Update cache support in home controller to use cache config in ini file

rgrp — Thu, 25 Nov 2010 13:52:34 GMT

Currently cache usage in home controller is inconsistent with elsewhere and, in particular, does not respect cache_disabled and is not configurable using path notation (e.g. ckan.controllers.home. ...).

This is especially frustrating in a development environment where is currently running into fact front page is being cached.

Fix this.

#814: Have an “About CKAN” link on every page

cygri — Wed, 17 Nov 2010 12:10:21 GMT

A link “About CKAN” pointing to http://ckan.net/about should be visible on every page. This is important because people often land on subpages and may have trouble figuring out what CKAN is.

I would put this link into the main navigation bar, on the very right next to “Revision History”. Then I would also remove the “Home” item from the main navigation bar because it is redundant. The CKAN logo is already a link to the homepage. The only other subpage in the “Home” section is “Statistics” and that's already linked from the homepage sidebar.

But anywhere else would be fine as well.

#813: Add link to “Register new package” to the homepage

cygri — Wed, 17 Nov 2010 12:00:53 GMT

A link to the “register new package” page would be handy somewhere on the front page. As a frequent editor, I often go to http://ckan.net in order to create a new package. I don't want to hunt around for the link to the “new package” form.

The link could go into the bar next to “About / Statistics”. Or into the “More information” sidebar. Neither of these truly make sense, but it's a frequently accessed link and that's reason enough to put it somewhere onto the frontpage.

#806: Metadata created and last modified timestamps for packages

rgrp — Mon, 15 Nov 2010 21:01:34 GMT

Packages should provide create and last modified attributes which are included in package dict exposed via api.

These attributes will not be in db but are computed (depend not just on package but related objects -- package tags, package resources, package extras etc)

#804: Rework analysis for publisher/provider in UKLP

johnbywater — Mon, 15 Nov 2010 10:14:14 GMT

We need an incremental plan that connects with current state of DGU and reflects what is actually required by UKLP.

#798: cospread importer using API

dread — Thu, 11 Nov 2010 11:36:02 GMT

Move existing getdata/cospread.py into dgu repo and use the importer/loader mechanism.

#797: Rework core html layout to mirror wordpress twentyten

rgrp — Wed, 10 Nov 2010 15:27:53 GMT

WP twentyten has an excellent core html structure. Furthermore, using that structure makes us compatible with all the WP twentyten compatible themes.

Convert to wp twentyten html
Switch css to be based off twentyten css (and perhaps rework somewhat)

#792: Meeting to review pre-alpha testing report from TM

johnbywater — Mon, 08 Nov 2010 10:40:51 GMT

#785: Review document from PP regarding CSW and WAF guidance

johnbywater — Mon, 08 Nov 2010 09:58:58 GMT

Scope of CSW guidance document has been broadened to include WAF.

#782: Add and remove users from sysadmin role from the command line

rgrp — Mon, 08 Nov 2010 08:34:47 GMT

Need to be able to create (and remove) sysadmins easily (used to be able to do this via ini file but this functionality was removed a while back in authz system reorganization it seems).

Suggest creating a new paster command as first step.

# user identifier = openid (?)
paster sysadmin add {user identifier}
paster sysadmin remove {user identifier}

Suggest this also be added to main CKAN docs.

This should go into metastable as well as default so that it goes into the v1.2 release (can do this via a transplant from one branch to the other)

#780: Package edit form - 'preview' button shows preview, with form lower in page

dread — Mon, 01 Nov 2010 17:00:29 GMT

This ticket refers to the form shown in Drupal. This doesn't have a preview function, but we don't have a requirement for it right now, so leaving ticket closed.

#779: Package edit form - stylesheet in DGU updated

dread — Mon, 01 Nov 2010 17:00:00 GMT

#778: Package edit form - name auto-generated from title

dread — Mon, 01 Nov 2010 16:59:37 GMT

#777: Put 503-returning middleware into a module

dread — Mon, 01 Nov 2010 10:45:24 GMT

Also configure hmgckan, hmgapi, test-hmg and dev-hmg machines.

#742: Release ckan 1.2 to metastable

dread — Mon, 25 Oct 2010 10:26:37 GMT

Need to make sure #700 is fixed.

#739: The system shall support retrieving a copy of the harvested metadata for a given package

johnbywater — Fri, 22 Oct 2010 20:35:10 GMT

...obviously, not all packages will have a harvested metadata document.

#734: Investigate department issue (ONS import)

dread — Fri, 22 Oct 2010 11:34:33 GMT

Creation of duplicate packages named with trailing underscore

ww 22/9/10:

Need to ... merge some packages (the "find packages by attributes" is not 100% reliable because of inconsistent data already in there).

The "find by tags" algorithm uses (title, department). Unfortunately some of the data already there has no department. This causes it to make a new package (with trailing underscore).

dread 24/9/10:

I've done a test for the missing department issue and I can't reproduce the problem. This may be due to my general tidy up and getting tests passing using the latest ckanclient. Anyway, can you check over my test to see if this is what you mean?: dgu/ckanext/dgu/tests/ons/test_ons_loader.py:TestOnsLoadMissingDept

ww 20/10/10:

you should uncover it if you run against (a copy of) the dgu database.

#732: Reproduce and investigate (geo coverage issue)

dread — Fri, 22 Oct 2010 09:12:41 GMT

#713: Review four definitions of DGU package attributes

johnbywater — Wed, 20 Oct 2010 13:25:58 GMT

#711: Packages shall support both UK government and location information with a common set of attributes

johnbywater — Wed, 20 Oct 2010 13:21:06 GMT

Previously, a package type attribute was intended to distinguish between package data that came from government depts. and publishers location information (GEMINI). Now there is an intention use a common set of attributes to support data from either source.

Hence, there currently a v.3 of the government attributes, a document about extracting the attributes from Gemini document using XPath, and a comparison documents mapping between governemtn attributes and Gemini attributes.

That means there are potentially four different list of attributes. I'm not sure how to go about reviewing the lists and converging any differences.

But we do want to end up with a list of names, a description of their purpose, and then perhaps the XPath which would reveal the value from a Gemini doc?

#689: Updated package for updated metadata document

johnbywater — Mon, 11 Oct 2010 09:25:34 GMT

#681: Department field bug

dread — Wed, 06 Oct 2010 17:38:05 GMT

https://trac.dataco.coi.gov.uk/projects/datagov/ticket/613

#679: Improve standard package edit form

dread — Wed, 06 Oct 2010 17:27:30 GMT

Add help text, drawing from:
- ca.ckan.net
- http://wiki.okfn.org/ckan/doc/package
- http://wiki.okfn.org/ckan/doc/faq
Make longer text revealed on click

#677: License change script

dread — Wed, 06 Oct 2010 17:05:56 GMT

Uses API to change licenses of all packages in a CKAN instance to a particular one.

Run it on DGU.

#675: Draft specification of CSW harvesting behaviour with guide for publishing agents

johnbywater — Mon, 04 Oct 2010 17:54:37 GMT

#661: Create CKAN site tester

dread — Fri, 24 Sep 2010 17:15:58 GMT

From Rufus:

'blackbox' testing command (read-only only would be fine) -- very
useful for upgrade on sunday
On blackbox thinking of something like:
paster test-site http://hmg.ckan.net {package-name}
Or (maybe better):
paster test-site --site-spec {myconfig.json}
my-config is a json file with info for testing (could overload
--config rather than site-spec):
site-url: http://hmg.ckan.net/
package-name:
package-title:
...etc ...
Then:
Test front-page
Test /revision/
Test /package/{page}  -- check title
Test /package/history
Test /api/rest/package/ ...
Test /api/search/package ...
etc

#648: Enable lock-down of package creation

pudo — Sun, 19 Sep 2010 09:45:19 GMT

copy exisiting tests, modify authz in setUp, adapt and extend tests
- Problem: default_role_actions is read by init_db
- Solution: nuke db after monkey-patching
- role = model.Role('Reader'), del role.actions[...]

self.PRE_MAUTHZ_RULES = copy(mauthz.default_role_actions) mauthz.default_role_actions.remove((Role.READER, Action.CREATE)) #raise Exception(mauthz.default_role_actions) model.Session.remove() model.repo.rebuild_db()

Start from the functional
- Both the api controllers and wui controllers to do
- tests/function/test_authz.py extended to check CREATE in lockedDown mode. fails nicely. http://bitbucket.org/pudo/ckan-authz2

is_authorized(user, Action.Create, model.Package)

-> Doing this will put 'Package' in the context field of the user_object_role table. This will trigger SQLAlchemy to attempt a join towards PackageRole? in all queries. Since for class-level role assignments there never is a PackageRole? join table entry, this will never return any results.

cf branch "classes": http://bitbucket.org/pudo/ckan-authz2/src/6fd0475e0c66
No possibility of including "instance" column in inheritance decision.
Even if this can be cirumvented, it must happen on a per-query level and would require a major re-modelling.

have a ckan install that would not allow visitors to either list packages or list groups
- two paths: create the listing, but for each group/pkg decide that you cannot show this
- lock down the whole page (/package/list)
  - this is class-based, not object-based

is_authorized(user, Action.Package_Create, model.System()) is_authorized(user, Action.Group_Create, model.System())

[Separating Package and Group roles may be useful going forward: PackageEditor?, GroupEditor? etc]

Find a standard way to lock down classes
- possibly add default rows in user_object_role
- introduce lock-down into controllers: group new, package new, REST equivalents,
- confirm tests

#647: Authorization Groups for group-based access control

pudo — Sun, 19 Sep 2010 09:43:38 GMT

allow group-level authorization on all system entities

#621: Metadata document links extracted from WAF response

johnbywater — Sat, 11 Sep 2010 15:58:27 GMT

#576: CKAN Requires Old Version of SQLAlchemy

wwaites — Fri, 10 Sep 2010 17:59:33 GMT

Requires 0.4. 0.5 is a maintenance branch, 0.6 is current.

VDM appears to work correctly (all the tests pass) with 0.5. CKAN does not -- requires more investigation to determine exactly why.

It would actually be nice to be able to run with 0.6 or 0.5, though 0.6 will require some changes to VDM as well

#571: Save metadata document and associate with harvest source entity

johnbywater — Thu, 09 Sep 2010 13:54:55 GMT

#481: Unrestricted total read-only access to catalogue API

johnbywater — Sat, 21 Aug 2010 20:31:37 GMT

#470: Adjust API key's HTTP header name on DGU "live" and "test"

johnbywater — Fri, 20 Aug 2010 13:27:34 GMT

#422: Administrator imports meta-data into CKAN

dread — Tue, 10 Aug 2010 09:44:50 GMT

Requirements:

cater naturally for multiple packages with multiple resources
international encoding
large number of packages

#398: Create Public API documentation for DGU (draft)

johnbywater — Thu, 05 Aug 2010 09:33:48 GMT

#364: Search for 'statistic' returns nothing

dread — Mon, 12 Jul 2010 15:47:00 GMT

On ckan.net there are plenty of packages (and indeed their tags) with the word 'statistic' in them, but no packages turn up when you search for it:

http://ckan.net/package/search?q=statistic&search=Search+Packages+%C2%BB

(Using Postgres full text search)

#231: Make group versioned

rgrp — Thu, 07 Jan 2010 08:45:23 GMT

Make group object revisioned/versioned.

Involves upgrade script both for group object and group_revision object
No changes required to WUI for present

#796: AlphaPage for non-latin languages

pudo — Tue, 09 Nov 2010 09:57:42 GMT

The AlphaPage? implementation assumes that all packages start with a latin character. This is not true for Russian, Chinese, Arabian and Persian languages etc. We should either use a unicode solution (i.e. display a full class of characters based on the current locale) or use generic paging instead.

#793: Fix up changes in changeset aa9aa32e00a9

johnbywater — Mon, 08 Nov 2010 10:41:47 GMT

#733: Fix problem (geo coverage issue)

dread — Fri, 22 Oct 2010 09:12:44 GMT

#712: Model government data package with "v0.4" of the attributes

johnbywater — Wed, 20 Oct 2010 13:23:59 GMT

Where said "v0.4" would be the result of converging four lists mentioned in requirement #711.

#692: The system shall support presenting map thumbnail for bounding box.

johnbywater — Mon, 11 Oct 2010 18:50:49 GMT

To do this for the UKLP, the Ordnance Survey would need to add to their map service an operation to return image for a given bounding box, and COI would need to present the image on the search result page.

Otherwise, it would be possible to use Google.

#611: Load local copy of XML schema for metadata document

johnbywater — Sat, 11 Sep 2010 15:23:59 GMT

#566: The system shall support harvesting remote metadata

johnbywater — Thu, 09 Sep 2010 13:40:19 GMT

#565: The system shall support UKLP code lists

johnbywater — Thu, 09 Sep 2010 12:04:24 GMT

#557: Remove siblings from link_to/from relationship display

pudo — Fri, 03 Sep 2010 19:36:35 GMT

Displaying siblings is not needed for link_to/from.

#533: The performance of CKAN shall scale

johnbywater — Fri, 27 Aug 2010 12:01:39 GMT

CKAN uses a database. We can put the database on another machine and then clone the CKAN machine. Then there are two machines calling the database and converting SQL results into HTTP responses.

How many machines can you have before the database becomes the bottleneck? At that point, what QoS can be obtained with normal hardware?

Afterwards, can CKAN be made to scale further than this with a little development? Can its Postgres database be mirrored in realtime? Or can we change SQL writes (create/updates) to write to many databases?

Are there any other options for scaling the persistence mechanism?

#504: The DGU fieldset shall conform to v3 of DGU metadata specification

rgrp — Tue, 24 Aug 2010 14:30:46 GMT

No need for requirement - closing in favour of #505

#451: Show/Allow only departments associated with user

dread — Fri, 20 Aug 2010 10:20:41 GMT

Use drupal api

#438: Data importers use minimal processing

dread — Thu, 19 Aug 2010 13:26:23 GMT

e.g. ONS importer

#413: Write functional tests for DGU caching

johnbywater — Tue, 10 Aug 2010 09:13:53 GMT

#940: OpenID login via google for same user generates 2 different openid urls

rgrp — Sun, 30 Jan 2011 15:32:01 GMT

This has been noted twice in the last couple of weeks.

Checking around my guess is this is due to someone logging in to www.ckan.net and ckan.net. Google generates openid based on the RP (requesting party) which is the requesting domain url unless the openid.realm is set. See:

To fix this we should set the openid.realm (not sure how atm).

If this is not possible an alternative is to make sure we redirect all users to a single site url (perhaps using ckan config option site_url, or doing this in apache).

Cost: 1h

#809: Link to the Wiki pages in package form

pudo — Wed, 17 Nov 2010 11:10:31 GMT

This would allow for a community-driven definition of field values, conventions, etc.

Plus: create wiki.ckan.net

#807: Handle robot traffic better

rgrp — Tue, 16 Nov 2010 09:30:26 GMT

We get a lot of robot traffic. Notice that robots are visiting package edit pages. Suggest:

Add rel=nofollow to various links
Throttle some robots (not all seem to respect robots.txt)

#770: Improve the paster harvester help command

johnbywater — Wed, 27 Oct 2010 14:37:00 GMT

Issue 1. Help command without arguments fails:

$paster help --plugin ckan --config development.ini

gives:

EITHER

Command help not recognized

paster help: error: no such option: --plugin

Issue 2: Harvester command with arguments fails.

$ paster harvester Traceback (most recent call last): ...

cmd = self.args[0]

IndexError?: list index out of range

#753: The system shall support filtered harvest of CSW sources

johnbywater — Mon, 25 Oct 2010 20:58:10 GMT

#745: Web UI shall accept requests for harvesting jobs

johnbywater — Mon, 25 Oct 2010 13:25:48 GMT

#676: The system shall support browsing to correct version of the CKAN documentation for a given service

johnbywater — Tue, 05 Oct 2010 10:55:36 GMT

#667: API is slow

dread — Thu, 30 Sep 2010 22:20:28 GMT

See message and script: http://lists.okfn.org/pipermail/ckan-discuss/2010-September/000569.html

1500 requests shouldn't take hours.

#564: The system shall support location based search

johnbywater — Thu, 09 Sep 2010 12:03:49 GMT

#502: Data4nr uploading script shall remove deleted packages

rgrp — Tue, 24 Aug 2010 14:15:04 GMT

Occasionally data4nr removes a data package from its registry. When the latest full data4nr data is imported, these removed packages should be found and removed.

#476: Daily database dumps shall be discoverable and downloadable

johnbywater — Fri, 20 Aug 2010 14:10:33 GMT

#466: Name of HTTP header for API key shall be configurable

johnbywater — Fri, 20 Aug 2010 12:56:35 GMT

#465: Require API key for all API requests.

johnbywater — Fri, 20 Aug 2010 12:55:04 GMT

#346: Revision search API (response data format and documentation issue)

johnbywater — Mon, 14 Jun 2010 13:51:57 GMT

Whilst going through the API docs for the revision search API, it was noticed that the "Gdu" SoS doc doesn't match up. It returns revision IDs (perhaps this is useful to note in the spec?) so the format is probably not 'limitedstring'. Also, they appear to be ordered youngest first, not oldest as stated.

And in the revision model, it refers to 'simplestring' which it doesn't define - I guess the names should be 'limitedstring'?

Could this be checked out?

#886: move uklii forms api to dgu module

wwaites — Sat, 25 Dec 2010 11:55:45 GMT

doesn't belong in ckan core

#815: Autocomplete for the search field

cygri — Wed, 17 Nov 2010 12:12:31 GMT

The search field (on the homepage and in the top right corner of each page) should have autocomplete for package name. If a package name is selected, it should not do a search but go straight to the package page.

#800: Get WAF records modified since given time

johnbywater — Thu, 11 Nov 2010 13:49:03 GMT

#795: "Match up" GEMINI2 "metadata point of contact" with registered entities

johnbywater — Mon, 08 Nov 2010 14:53:45 GMT

TM wants to know how this will be "matched up". I don't know whether this always the data provider, or sometimes the publisher.

#791: Submit harvest source form with invalid CSW location

johnbywater — Mon, 08 Nov 2010 10:39:11 GMT

#790: Submit harvest source form with valid CSW location

johnbywater — Mon, 08 Nov 2010 10:34:39 GMT

#789: The harvest source form shall validate location field by positive identification of source type

johnbywater — Mon, 08 Nov 2010 10:28:26 GMT

#788: API user deletes harvest source

johnbywater — Mon, 08 Nov 2010 10:13:16 GMT

Needs to delete all harving jobs and harvested documents, and probably to purge all packages (perhaps just delete?).

#786: The system shall support deleting a registered harvest source

johnbywater — Mon, 08 Nov 2010 10:09:42 GMT

#783: Delete harvested documents when remote metadata disappears from harvest source

johnbywater — Mon, 08 Nov 2010 09:53:49 GMT

We need a condition for 'disappears'. Asked AW about this (prob. in July) but should chase for an answer.

#781: Package edit form - 'extra' fields have 'add' and 'delete' buttons

dread — Mon, 01 Nov 2010 17:02:15 GMT

(Just like resource table, but extra fields don't need up/down buttons)

Nice to have: a blank field is added when you tab from the last filled-in field in the table.

#774: Fix CLI harvester command to return harvester help message

johnbywater — Wed, 27 Oct 2010 14:42:02 GMT

#773: Fix CLI help command to return CLI help message

johnbywater — Wed, 27 Oct 2010 14:41:15 GMT

#772: Run CLI harvester command without arguments

johnbywater — Wed, 27 Oct 2010 14:39:33 GMT

Should return help for the harvester (currently crashes).

#769: Tests for harvesting metadata from ArcGIS CSW API

johnbywater — Wed, 27 Oct 2010 11:16:19 GMT

#768: Obtain example ArcGIS CSW server

johnbywater — Wed, 27 Oct 2010 11:15:34 GMT

#766: The system shall support harvesting metadata from ArcGIS

johnbywater — Wed, 27 Oct 2010 11:12:13 GMT

Perhaps 80% of the users of the UKLII may be using ArcGIS.