[vhffs] Problème ajout de DNS

[Bruno Marmier <bruno.marmier@xxxxxxxxxxx>]

Bonsoir à tous...

Lorsque j'essaie de créer un nouveau DNS, j'ai l'erreur suivante qui
s'affiche dans les log postgresql:

2009-10-31 18:19:41 CET ERREUR:  une valeur NULL viole la contrainte NOT
NULL de la colonne « ns »

Version de vhffs: Run VHFFS 4.1.0 (hippocampus)

J'ai essayé de mettre une valeur par défaut pour le "ns", mais ça n'a
rien changé.

Merci!

Bruno


Le log complet de postgresql:
=====================

2009-10-31 18:19:41 CET LOG:  instruction : SELECT 'DBD::Pg ping test'
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_1 AS SELECT
u.uid, u.gid, u.object_id, u.username, u.passwd, u.homedir, u.shell,
u.admin, u.firstname, u.lastname, u.address, u.zipcode, u.city,
u.country, u.mail, u.gpg_key, u.note, u.language, u.theme,
u.lastloginpanel, o.date_creation, o.description, o.state FROM
vhffs_users u INNER JOIN vhffs_object o ON o.object_id = u.object_id
WHERE u.uid = $1
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT u.uid, u.gid, u.object_id, u.username, u.passwd, u.homedir,
u.shell, u.admin, u.firstname, u.lastname, u.address, u.zipcode, u.city,
u.country, u.mail, u.gpg_key, u.note, u.language, u.theme,
u.lastloginpanel, o.date_creation, o.description, o.state FROM
vhffs_users u INNER JOIN vhffs_object o ON o.object_id = u.object_id
WHERE u.uid = $1]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_1
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_2 AS SELECT
g.gid, o.object_id, o.owner_uid, g.groupname, g.realname, g.passwd,
g.quota, g.quota_used, o.date_creation, o.description, o.state FROM
vhffs_groups g INNER JOIN vhffs_object o ON o.object_id = g.object_id
WHERE g.gid = $1
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT g.gid, o.object_id, o.owner_uid, g.groupname, g.realname,
g.passwd, g.quota, g.quota_used, o.date_creation, o.description, o.state
FROM vhffs_groups g INNER JOIN vhffs_object o ON o.object_id =
g.object_id WHERE g.gid = $1]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_2
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_3 AS SELECT
g.gid, o.object_id, o.owner_uid, g.groupname, g.realname, g.passwd,
g.quota, g.quota_used, o.date_creation, o.description, o.state FROM
vhffs_groups g INNER JOIN vhffs_object o ON o.object_id = g.object_id
WHERE g.groupname = $1
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT g.gid, o.object_id, o.owner_uid, g.groupname, g.realname,
g.passwd, g.quota, g.quota_used, o.date_creation, o.description, o.state
FROM vhffs_groups g INNER JOIN vhffs_object o ON o.object_id =
g.object_id WHERE g.groupname = $1]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_3
2009-10-31 18:19:41 CET LOG:  instruction : begin
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_4 AS INSERT
INTO vhffs_object(owner_uid, owner_gid, date_creation, state,
description, type) VALUES ( $1, $2, $3, $4, $5, $6)
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  INSERT INTO vhffs_object(owner_uid, owner_gid, date_creation, state,
description, type) VALUES ( $1, $2, $3, $4, $5, $6)]
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_5 AS SELECT
c.oid FROM pg_catalog.pg_class c
     WHERE relname = $1
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT c.oid FROM pg_catalog.pg_class c
     WHERE relname = $1]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_5
2009-10-31 18:19:41 CET LOG:  instruction : SELECT a.attname,
i.indisprimary, substring(d.adsrc for 128) AS def
    FROM pg_catalog.pg_index i, pg_catalog.pg_attribute a,
pg_catalog.pg_attrdef d
     WHERE i.indrelid = 19011 AND d.adrelid=a.attrelid AND d.adnum=a.attnum
      AND a.attrelid=19011 AND i.indisunique IS TRUE
      AND a.atthasdef IS TRUE AND i.indkey[0]=a.attnum
     AND d.adsrc ~ '^nextval'
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_6 AS SELECT
currval($1)
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT currval($1)]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_6
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_7 AS SELECT
owner_uid, owner_gid, date_creation, description, refuse_reason, state,
type FROM vhffs_object WHERE object_id =$1
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT owner_uid, owner_gid, date_creation, description,
refuse_reason, state, type FROM vhffs_object WHERE object_id =$1]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_7
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_8 AS INSERT
INTO vhffs_history(object_id, date, message)  VALUES($1, $2, $3)
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  INSERT INTO vhffs_history(object_id, date, message)  VALUES($1, $2, $3)]
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_9 AS SELECT
c.oid FROM pg_catalog.pg_class c
     WHERE relname = $1
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT c.oid FROM pg_catalog.pg_class c
     WHERE relname = $1]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_9
2009-10-31 18:19:41 CET LOG:  instruction : SELECT a.attname,
i.indisprimary, substring(d.adsrc for 128) AS def
    FROM pg_catalog.pg_index i, pg_catalog.pg_attribute a,
pg_catalog.pg_attrdef d
     WHERE i.indrelid = 19042 AND d.adrelid=a.attrelid AND d.adnum=a.attnum
      AND a.attrelid=19042 AND i.indisunique IS TRUE
      AND a.atthasdef IS TRUE AND i.indkey[0]=a.attnum
     AND d.adsrc ~ '^nextval'
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_10 AS SELECT
currval($1)
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  SELECT currval($1)]
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_10
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_8
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_4
2009-10-31 18:19:41 CET LOG:  instruction : PREPARE dbdpg_11 AS INSERT
INTO vhffs_dns (domain, object_id, ns, mbox, serial, refresh, retry,
expire, minimum, ttl) VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)
2009-10-31 18:19:41 CET LOG:  instruction : <BIND>
2009-10-31 18:19:41 CET LOG:  instruction : EXECUTE <unnamed>  [PREPARE
:  INSERT INTO vhffs_dns (domain, object_id, ns, mbox, serial, refresh,
retry, expire, minimum, ttl) VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9,
$10)]
2009-10-31 18:19:41 CET ERREUR:  une valeur NULL viole la contrainte NOT
NULL de la colonne « ns »
2009-10-31 18:19:41 CET LOG:  instruction : ROLLBACK
2009-10-31 18:19:41 CET LOG:  instruction : DEALLOCATE dbdpg_11