Path for db schema referenced by bootstrapdb.py doesn't exist

[quickezed]

After installing the calendarserver package, the python file "bootstrapdatabase.py"[0] fails to run due to it referencing an invalid file path. This invalid file path is defined on line 28 of "bootstrapdatabase.py":

SCHEMAFILE = "/usr/share/pyshared/txdav/common/datastore/sql_schema/current.sql"

The path "/usr/share/pyshared/txdav" does not exist. The correct path for "current.sql" is actually:
/usr/lib/python2.7/dist-packages/txdav/common/datastore/sql_schema/current.sql

Further information:
1) System version: Ubuntu 14.04 LTS
2) calendarserver version: 5.2+dfsg-1
3) I expected "bootstrapdatabase.py" to execute successfully.
4) "bootstrapdatabase.py" failed to run due to a file it references not existing. See above for the specifics.

[0] /usr/lib/python2.7/dist-packages/calendarserver/tools/bootstrapdatabase.py

[TJ (tj)]

The (faulty) path is introduced in "debian/patches/debianize-bootstrapdatabase.py.patch". The path should not be hard-coded it should be calculated at runtime to accommodate the package-install-time path translation from "/usr/share/pyshared to "/usr/lib/pythonX.Y/"

[TJ (tj)]

Revised patch: Use proper Python path separator

[TJ (tj)]

Revise patch: Iterate all package paths checking for file existence (copes with alternate site-paths such as "/usr/local/pythonX.Y/site-packages/")

[quickezed (quickezed-deactivatedaccount)]

I can confirm this latest patch works. When executed, bootstrapdatabase.py can correctly locate the schema file.

[Ubuntu Foundations Team Bug Bot (crichton)]

The attachment "Possible fix using runtime-calculated path" seems to be a patch. If it isn't, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are a member of the ~ubuntu-reviewers, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issues please contact him.]