[Mediawiki-l] PageSecurity and Postgresql

[Fernando Carpani - INCO]

Hello.
Does anyone working this things?
I have the following definitions:

<security-definition name="Default"  notice="Define la seguridad por 
Defecto">
  <allow action="read">all</allow>
  <allow action="write">csi</allow>
</security-definition>

When I save the page, only displays the action for read and the first 
log message is (taken from the debug file with SQL debug activated):

=================
nstubbing $wgParser on call of $wgParser->setHook from 
fnPageSecurityExtension
Fully initialised
Unstubbing $wgContLang on call of $wgContLang->checkTitleEncoding from 
WebRequest::getGPCVal
Language::loadLocalisation(): got localisation for es from source
Language::loadLocalisation(): got localisation for en from source
Unstubbing $wgUser on call of $wgUser->isAllowed from Title::userCanRead
Cache miss for user 2
Unstubbing $wgLoadBalancer on call of $wgLoadBalancer->getConnection 
from wfGetDB
SQL: SELECT /* User::loadFromDatabase */  *  FROM mwuser  WHERE user_id 
= '2'  LIMIT 1
SQL: SELECT /* User::loadFromDatabase */  ug_group  FROM user_groups  
WHERE ug_user = '2'
Logged in from session
SQL: SELECT /* Article::pageData */  
page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len  
FROM page  WHERE page_namespace = '0' AND page_title = 
'Definiciones_de_Seguridad'  LIMIT 1
Unstubbing $wgLang on call of $wgLang->getCode from 
User::getPageRenderingHash
OutputPage::checkLastModified: CACHE DISABLED
Article::tryFileCache(): not cacheable
Article::view using parser cache: no
Unstubbing $wgMessageCache on call of $wgMessageCache->getTransform from 
wfMsgGetKey
SQL: SELECT /* MediaWikiBagOStuff::_doquery */ value,exptime FROM 
objectcache WHERE keyname='wikiDes:messages-hash'
SQL: SELECT /* MediaWikiBagOStuff::_doquery */ value,exptime FROM 
objectcache WHERE keyname='wikiDes:messages'
MessageCache::load(): got from global cache
SQL: SELECT /* Revision::fetchRow */  
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted  
FROM page,revision  WHERE (page_id=rev_page) AND rev_id = '1547'  LIMIT 1
SQL: SELECT /* Revision::loadText */  old_text,old_flags  FROM 
pagecontent  WHERE old_id = '1547'  LIMIT 1
SQL: SELECT /* SecurityDefinition::loadFromDatabase */  
security_definition_id,security_definition_name,base_security_definition_id,security_definition_notice,security_definition_logo  
FROM security_definitions  WHERE security_definition_name = 'Default'
SQL: SELECT /* SecurityDefinition::loadFromDatabase */  
security_definition_item_id,security_definition_id,security_definition_item_action,security_definition_item_permission,security_definition_item_group  
FROM security_definition_items  WHERE security_definition_id = '2'  
ORDER BY security_definition_item_id
SQL: UPDATE page SET page_counter = page_counter + 1 WHERE page_id = 1513
SQL: SELECT /* WatchedItem::isWatched */  1  FROM watchlist  WHERE 
wl_user = '2' AND wl_namespace = '0' AND wl_title = 
'Definiciones_de_Seguridad'
SQL: SELECT /* SiteStatsUpdate::doUpdate */  *  FROM site_stats   LIMIT 1
SQL: BEGIN
SQL: UPDATE /* SiteStatsUpdate::doUpdate */ site_stats SET 
ss_total_views=ss_total_views+1
SQL: COMMIT
SQL: SELECT /* Job::pop */  *  FROM job   ORDER BY job_id LIMIT 1
SQL: SELECT /* LinkBatch::doQuery */ page_id, page_namespace, page_title 
FROM page WHERE (page_namespace=2 AND page_title IN ('Fcarpani')) OR 
(page_namespace=3 AND page_title IN ('Fcarpani')) OR (page_namespace=1 
AND page_title IN ('Definiciones_de_Seguridad'))
SQL: SELECT /* User::checkNewtalk */  user_id  FROM user_newtalk  WHERE 
user_id = '2'  LIMIT 1
OutputPage::sendCacheControl: private caching;  **
20070212100358  0.219   /wiki/Des/index.php/Definiciones_de_Seguridad
Request ended normally
==================


The content of the security tables is:

wikiDes=> select * from security_definitions;
 security_definition_id | security_definition_name | 
base_security_definition_id |   security_definition_notice    | 
security_definition_logo
------------------------+--------------------------+-----------------------------+---------------------------------+--------------------------
                      2 | Default                  
|                           0 | Define la seguridad por Defecto |
(1 row)

wikiDes=> select * from security_definition_items;
 security_definition_item_id | security_definition_id | 
security_definition_item_action | security_definition_item_permission | 
security_definition_item_group
-----------------------------+------------------------+---------------------------------+-------------------------------------+--------------------------------
                          13 |                      2 | 
read                            | allow                               | *
(1 row)



Does anyone help me ?

Thanks.

Ferrnando Carpani