PEAR Bug Search Results

LiveUser_Admin: Bug 15434 [Open] With complex perm container, unimplyRight removes more records then it should.

pierre2543 at hotmail dot com — 2008-12-29T05:25:32+00:00

LiveUser_Admin Bug
Reported by pcharb
2008-12-29T05:25:32+00:00
PHP: 5.2.4 OS: Linux Package Version: 0.3.9

Description:
------------
When you do:
$data = array('right_id' => 10,'implied_right_id' => 16);
$LUA->perm->unimplyRight($data);

The following sql is issued:
DELETE FROM liveuser_right_implied
 WHERE implied_right_id IN (16)

The right_id in the $data array is ignored. This is a problem when more then one right, implies a particular right.

Test script:
---------------
$data = array('application_define_name' => 'mytestapp');
$appId = $LUA->perm->addApplication($data);

$data = array('application_id' => $appId,'area_define_name' => 'mytestarea');
$areaId = $LUA->perm->addArea($data);

$data = array('area_id' => $areaId, 'right_define_name' => 'super1');
$super1Id = $LUA->perm->addRight($data);

$data = array('area_id' => $areaId, 'right_define_name' => 'super2');
$super2Id = $LUA->perm->addRight($data);

$data = array('area_id' => $areaId, 'right_define_name' => 'implied');
$impliedId = $LUA->perm->addRight($data);

$data = array('right_id' => $super1Id,'implied_right_id' => $impliedId);
$LUA->perm->implyRight($data);

$data = array('right_id' => $super2Id,'implied_right_id' => $impliedId);
$LUA->perm->implyRight($data);

$data = array('right_id' => $super2Id,'implied_right_id' => $impliedId);
$LUA->perm->unimplyRight($data);

echo "right_id: $super1Id - implied_right_id: $impliedId";


Expected result:
----------------
Only one record is deleted from the database, we have one record remaining record, namely $super1Id implies impliedId.

Actual result:
--------------
All records that have the same implied_right_id are deleted.

LiveUser_Admin: Bug 15433 [Open] With complex Perm container, removeUser doesn't clean up area_admin_areas

pierre2543 at hotmail dot com — 2008-12-29T05:00:24+00:00

LiveUser_Admin Bug
Reported by pcharb
2008-12-29T05:00:24+00:00
PHP: 5.2.4 OS: Linux Package Version: 0.3.9

Description:
------------
The Complex perm container should implement removeUser to clean up the link to the 

Test script:
---------------
$data = array('application_define_name' => 'mytestapp');
$appId = $LUA->perm->addApplication($data);

$data = array('application_id' => $appId,'area_define_name' => 'mytestarea');
$areaId = $LUA->perm->addArea($data);

$data = array('handle'=>'mytestuser','passwd'=>'secret','perm_type'=>3);
$userId = $LUA->addUser($data);

echo "userId: $userId - areaId: $areaId";

$data = array('area_id' => $areaId,'perm_user_id' => $userId);
$LUA->perm->addAreaAdmin($data);

$LUA->removeUser($userId);

Expected result:
----------------
The record created in the area_admin_areas has been deleted.

Actual result:
--------------
The record create in the area_admin_areas is not deleted.

LiveUser_Admin: Bug 11432 [Open] Adding User on Multiple containers

cedric dot lombardot at spyrit dot net — 2007-06-26T07:22:48+00:00

LiveUser_Admin Bug
Reported by cedric
2007-06-25T13:28:51+00:00
PHP: 5.2.0 OS: XP Package Version: 0.3.9

Description:
------------
When I attempt to create a new user with one DB for authContainers and one for permContainer LiveUser_Admin make the auth request on the permContainer.

If I add setAdminAuthContainer it Return always an error

Test script:
---------------
$LUA =& LiveUser_Admin::factory($conf, 'FR');
$LUA->init();
$data = array('handle'    => 'cedric',
                  'passwd'    => 'azc+XOC1987',
				  'name' => 'CÃ©dric Lombardot',
                  'mail'     => 'cedric.lombardot@spyrit.net',
                  'is_active' => '1',
                  'perm_type' => LIVEUSER_MASTERADMIN_TYPE_ID 
                  );

$userId = $LUA->addUser($data);
print_r( $LUA->getErrors());


Actual result:
--------------
========ERROR MESSAGE ====================================
Array ( [0] => Array ( [code] => -4 [params] => Array ( [reason] => MDB2 Error: no such table-_doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO liveuser_users (handle, passwd, name, mail, is_active, auth_user_id) VALUES ('cedric', '5d86f3b0c0050e462872b00961280672', 'CÃ©dric Lombardot', 'cedric.lombardot@spyrit.net', 1, '40')] [Native code: 1146] [Native message: La table 'venio_client_install.liveuser_users' n'existe pas] ) [package] => LiveUser_Admin [level] => exception [time] => 1182777401.1783 [context] => Array ( [file] => D:\WEB\EasyPHP 2.0b1\www\PEAR\LiveUser\Admin\Storage\MDB2.php [line] => 225 [function] => exec [class] => LiveUser_Admin_Storage_MDB2 ) [message] => Couldn't create the query, reason: MDB2 Error: no such table-_doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO liveuser_users (handle, passwd, name, mail, is_active, auth_user_id) VALUES ('cedric', '5d86f3b0c0050e462872b00961280672', 'CÃ©dric Lombardot', 'cedric.lombardot@spyrit.net', 1, '40')] [Native code: 1146] [Native message: La table 'venio_client_install.liveuser_users' n'existe pas] ) )

LiveUser_Admin: Bug 9706 [Open] PDO Storage Module Incomplete

aschiffler at ferzkopp dot net — 2009-03-15T03:23:45+00:00

LiveUser_Admin Bug
Reported by aschiffler@...
2006-12-28T15:15:04+00:00
PHP: 5.0.0 OS: Linux Package Version: 

Description:
------------
Function nextId() in LiveUser_Admin-0.3.9/Storage/PDO.php is not implemented. 

Initial call to $LUA->addUser() works, but any subsequent call fails because no new index ID is created.



Test script:
---------------
Run LiveUser_Admin/docs/examples/example1/User.php with PDO backend.


Expected result:
----------------
20 User are created.

Actual result:
--------------
Database errors after the first user was inserted.

LiveUser_Admin: Feature/Change Request 7041 [Analyzed] getRights() on an unassigned group returns nothing

msadagopan at wltcapital dot com — 2006-08-14T08:45:40+00:00

LiveUser_Admin Feature/Change Request
Reported by msadagopan@...
2006-03-06T23:07:23+00:00
PHP: 5.1.2 OS: Linux Package Version: 0.3.7

Description:
------------
Package              Version  State
LiveUser             0.16.10  beta
LiveUser_Admin       0.3.7    beta

System 	Linux ubuntu 2.6.12-10-386 #1 Mon Feb 13 12:13:15 UTC 2006 i686
Build Date 	Feb 21 2006 10:09:40

'./configure' '--with-apxs2=/usr/bin/apxs2' '--with-mysql=/usr/local/mysql' '--with-mysqli=/usr/local/mysql/bin/mysql_config' '--with-mysql-sock=/tmp/mysql.sock' '--with-sqlite' '--enable-sqlite-utf8' '--with-zlib' '--with-zlib-dir' '--with-bz2' '--with-gd' '--enable-gd' '--enable-gd-native-ttf' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-ttf' '--with-freetype-dir=/usr/local' '--with-iconv=/usr/local' '--with-curl=/usr/local' '--enable-track-vars' '--with-gettext' '--with-config-file-path=/etc/apache2' '--enable-trans-id' '--enable-ftp' '--enable-mbstring' '--with-tidy' '--with-xsl'

Test script:
---------------
//LUA -> LiveUser_Admin

$data = array('application_define_name' => 'APP_WORLD');
$app_id = $LUA->perm->addApplication($data);

$data = array(
'application_id' => $app_id,
'area_define_name' => 'AREA_FOO',);
$area_id  = $LUA->perm->addArea($data);

$data = array(
'area_id' => $area_id,
'right_define_name' => 'INSERT',
'has_implied' => FALSE);
$right_id  = $LUA->perm->addRight($data);

$data = array(
'group_define_name' => 'GRP_TEST');
$group_id = $LUA->perm->addGroup($data);

$data = array(
'group_id' => $group_id,
'right_id' => $right_id,
'right_level' => '1');
$granted = $LUA->perm->grantGroupRight($data);

$params = array(
'fields' => array('right_id','right_define_name','right_level'),
'filters' => array('group_id' => $group_id),
'by_group' => TRUE,);
        
$grp_rights = $LUA->perm->getRights($params, TRUE);

print_r($grp_rights);

Expected result:
----------------
array(1) {
  [0]=>
  array(3) {
    ["right_id"]=>
    string(3) "" //the $right_id 
    ["right_define_name"]=>
    string(6) "INSERT"
    ["right_level"]=>
    string(1) "1"
  }


Actual result:
--------------
array(0)

The final generated query @ LiveUser/Admin/Storage/SQL.php in the function select()

SELECT liveuser_rights.right_id AS right_id, liveuser_rights.right_define_name AS right_define_name, liveuser_grouprights.right_level AS right_level FROM liveuser_rights, liveuser_groupusers, liveuser_grouprights WHERE liveuser_rights.right_id = liveuser_grouprights.right_id AND liveuser_grouprights.group_id = liveuser_groupusers.group_id AND liveuser_groupusers.group_id = 27

Its joining the 'liveuser_groupusers' table also. But in this case, since a user hasn't been assigned to the group 'GRP_TEST', getRights() returns nothing.