developer.jelix.org is not used any more and exists only for history. Post new tickets on the Github account.
developer.jelix.org n'est plus utilisée, et existe uniquement pour son historique. Postez les nouveaux tickets sur le compte github.

Opened 12 years ago

Closed 11 years ago

#915 closed bug (fixed)

jacl2db_admin et stockage des groupe anonyme en base de données

Reported by: foxmask Owned by:
Priority: normal Milestone: Jelix 1.1.4
Component: jelix:acl Version: 1.1.2
Severity: major Keywords:
Cc: Blocked By:
Blocking: Documentation needed: no
Hosting Provider: Php version:

Description

Avec le scrit install_jacl2.schema.pgsql.sql on peut créer les tables nécessaire à l'utilisation de jAcl2.

Cependant quand on veut stocker les droits des utilisateurs anonymes on se heurte à un problème de foreign key (dans la table jacl2_rights) absente de la table jacl2_group où on ne stocke pas l'id 0 du groupe anonyme.

J'ai rencontré ce problème avec Postgresql 8.1.3 mais avec MySQL on aura les memes déboires si on utilise les contraintes des forgein key.

Attachments (2)

install_jacl2.data.mysql.sql.patch (602 bytes) - added by foxmask 11 years ago.
add anonymous group to jAcl2db
install_jacl2.data.mysql.sql.2.patch (1.5 KB) - added by foxmask 11 years ago.
add anonymous group to jAcl2db

Download all attachments as: .zip

Change History (11)

comment:1 Changed 12 years ago by foxmask

il s'agit de pgsql 8.3.7 très exactement.

comment:2 Changed 12 years ago by laurentj

  • Component changed from module:jacl2db_admin to jelix:acl
  • Milestone set to Jelix 1.1.3

Changed 11 years ago by foxmask

add anonymous group to jAcl2db

Changed 11 years ago by foxmask

add anonymous group to jAcl2db

comment:3 Changed 11 years ago by foxmask

  • review set to review?

cette enregistrement suffit à ne plus avoir de pb d'integrité referentielle.

comment:4 Changed 11 years ago by laurentj

  • review changed from review? to review+

comment:5 Changed 11 years ago by foxmask

  • Resolution set to fixed
  • Status changed from new to closed

comment:6 Changed 11 years ago by laurentj

  • Resolution fixed deleted
  • Status changed from closed to reopened

you should also include your patch in the trunk...

comment:7 Changed 11 years ago by foxmask

I tried this night but i cant ; like i said to Loic, there are a lot of files missing in install/sql

in fact there are 4 files in trunk and 16 in branche 1.1.x ...

So i thought "it's normal ; this would change in trunk but i dont know what now".

comment:8 Changed 11 years ago by foxmask

noeud à mon mouchoir : les fichiers sont dans les dossiers d'install des modules respectifs

comment:9 Changed 11 years ago by foxmask

  • Resolution set to fixed
  • Status changed from reopened to closed
Note: See TracTickets for help on using tickets.