Bug#547883: marked as done (qa.debian.org: UDD : error on recreation from dump)
Your message dated Tue, 22 Sep 2009 20:16:52 +0200
with message-id <20090922181652.GA4751@xanadu.blop.info>
and subject line Re: Bug#547883: qa.debian.org: UDD : error on recreation from dump
has caused the Debian Bug report #547883,
regarding qa.debian.org: UDD : error on recreation from dump
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)
--
547883: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=547883
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message ---
Package: qa.debian.org
Severity: normal
Upon importing the UDD dump, I get :
ERREUR: la relation « ldap » n'existe pas
(Hope you guys understand french ;-)
This seems to be in :
CREATE VIEW really_active_dds AS
SELECT DISTINCT carnivore_login.id, carnivore_login.login FROM carnivore_login, carnivore_keys, ldap WHERE ((((carnivore_keys.id = carnivore_login.id) AND (carnivore_keys.key_type = 'keyring'::text)) AND (carnivore_login.login = ldap.login)) AND (ldap.activity_pgp > '2009-01-01 00:00:00+00'::timestamp with time zone));
Hope this helps,
Best regards,
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (990, 'testing'), (500, 'testing-proposed-updates')
Architecture: i386 (i686)
Kernel: Linux 2.6.30-1-686 (SMP w/2 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
--- End Message ---
--- Begin Message ---
On 22/09/09 at 13:19 +0200, Olivier Berger wrote:
> Package: qa.debian.org
> Severity: normal
>
> Upon importing the UDD dump, I get :
>
> ERREUR: la relation « ldap » n'existe pas
>
> (Hope you guys understand french ;-)
>
> This seems to be in :
> CREATE VIEW really_active_dds AS
> SELECT DISTINCT carnivore_login.id, carnivore_login.login FROM carnivore_login, carnivore_keys, ldap WHERE ((((carnivore_keys.id = carnivore_login.id) AND (carnivore_keys.key_type = 'keyring'::text)) AND (carnivore_login.login = ldap.login)) AND (ldap.activity_pgp > '2009-01-01 00:00:00+00'::timestamp with time zone));
>
> Hope this helps,
Fixed, by excluding the view as well from the dump. The ldap table
contains sensitive information, so it is not available in the dump.
--
| Lucas Nussbaum
| lucas@lucas-nussbaum.net http://www.lucas-nussbaum.net/ |
| jabber: lucas@nussbaum.fr GPG: 1024D/023B3F4F |
--- End Message ---
Reply to: