[Systems] mirrorbrain - sugarlabs - sql lookup error

[David Farning]

Arggg fixed it.

Apache2/sites-available/download-testing.sugarlabs.org was pointing to
/var/www-sugarlabs/download which was a symlink to /srv/uploads.

Once the the apache config was working pointing at a normal directory
it worked correctly.

thanks
david

On Sun, Oct 11, 2009 at 12:10 PM, David Farning <dfarning at sugarlabs.org> wrote:
> Peter, I installed mirror brain on our production server yesterday.  I
> did not realize that it is blend of 8.10 and 9.04 package.
>
> Judging form the log files it looks like either mod_mirrorbrain of the
> is chopping the several character form the beginning of the string it
> is searching in the database.  (below are sample snippets from a
> broken installation and from a good test installation.
>
>
> Doing mb fileprobe from the command line works correctly
>
> mirrorbrain at sunjammer:/var/log/apache2$ mb probefile
> /beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk
> .
> 1 download2
> http://download2.sugarlabs.org/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk
> http=200
> Found: 1
>
>
> thanks
> david
>
> ---- snippet from error_log on broken installation----
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] MirrorBrainEngine On, mirror_base
> '/var/www-sugarlabs/download/'
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] URI:
> '/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk?mirrorlist'
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] filename:
> '/var/www-sugarlabs/download/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7>
> [Sun Oct 11 12:46:08 2009] [error] [client 207.118.255.6]
> [mod_mirrorbrain] could not resolve continent
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] Country 'US', Continent '--'
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] AS '--', Prefix '--'
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] Successfully acquired database connection.
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] SQL lookup for (canonicalized)
> 'ippocanvas-1-0_0.3.0-r0_armv7a.ipk'
> [Sun Oct 11 12:46:08 2009] [info] [client 207.118.255.6]
> [mod_mirrorbrain] no mirrors found for
> ippocanvas-1-0_0.3.0-r0_armv7a.ipk
> [Sun Oct 11 12:46:08 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] empty mirrorlist
>
>
> ---- snippet from error_log on good installation----
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] MirrorBrainEngine On, mirror_base
> '/var/www/downloads/'
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] URI:
> '/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk?mirrorlist'
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] filename:
> '/var/www/downloads/beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk'
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] Country 'US', Continent 'NA'
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] AS '--', Prefix '--'
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] Successfully acquired database connection.
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] SQL lookup for (canonicalized)
> 'beagleboard/libhippocanvas-1-0_0.3.0-r0_armv7a.ipk'
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] Found 2 mirrors
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] same country: download2.sugarlabs.org        (score
> 100) (rank    7372869)
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] same country: download.sugarlabs.org         (score
> 100) (rank    7813338)
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] Found 2 mirrors: 0 prefix, 0 AS, 2 country, 0
> region, 0 elsewhere
> [Sun Oct 11 12:07:09 2009] [warn] [client 207.118.255.6]
> [mod_mirrorbrain] Sending mirrorlist
>