[buildd-tools-devel] upgrade issues with wanna-build web interface.

[Aurelien Jarno]

Hi,

On 2016-06-02 16:01, peter green wrote:
> I recently tried to upgrade the wanna-build web interface for
> buildd.raspbian.org to the latest version but i'm getting.
> 
> *Warning*: include(/srv/buildd.debian.org/etc/binsrc_assoc.php): failed to
> open stream: No such file or directory in
> */srv/buildd.debian.org/www/status/library.php* on line *29*
> 
> *Warning*: include(): Failed opening
> '/srv/buildd.debian.org/etc/binsrc_assoc.php' for inclusion
> (include_path='.:/usr/share/php:/usr/share/pear') in
> */srv/buildd.debian.org/www/status/library.php* on line *29*
>
> *Warning*: pg_query(): Query failed: ERROR: column "vancouvered" does not
> exist LINE 1: SELECT distribution, architecture, vancouvered ^ in
> */srv/buildd.debian.org/www/status/library.php* on line *115*
> 
> *Warning*: pg_fetch_assoc() expects parameter 1 to be resource, boolean
> given in */srv/buildd.debian.org/www/status/library.php* on line *116*
> 
> *Warning*: pg_free_result() expects parameter 1 to be resource, boolean
> given in */srv/buildd.debian.org/www/status/library.php* on line *121*
> 
> *Notice*: Use of undefined constant BUILDD_SCHEME - assumed 'BUILDD_SCHEME'
> in */srv/buildd.debian.org/www/status/library.php* on line *1588
> 
> From looking at *buildd.debian.org it seems
> /srv/buildd.debian.org/etc/binsrc_assoc.php is a generated file but i'm not
> sure what is supposed to generate it.

Please find attached the script generating this file from the projectb
database.

> I have failed to find any details or explanation of the "vancouvered" column
> with my google searches and it does not seem to be in the schema files I got
> from https://buildd.debian.org/git/wanna-build.git/

Indeed, the schema hasn't been updated in the git repository in years. I
have just committed the changes, but there are huge, due to the newly
added architectures, but also by the postgresql upgrade between wheezy
and jessie.

The vancouvered columns decides if an architecture is a primary one or a
secondary one. Secondary architectures appear with a slightly darker
color on the web interface, and also after the primary ones.

Aurelien

-- 
Aurelien Jarno                          GPG: 4096R/1DDD8C9B
aurelien at aurel32.net                 http://www.aurel32.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gen_srcbin_assoc.py
Type: text/x-python
Size: 929 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/buildd-tools-devel/attachments/20160604/6c84cd19/attachment.py>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/buildd-tools-devel/attachments/20160604/6c84cd19/attachment.sig>