Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.4.0

Bug #11432 Adding User on Multiple containers
Submitted: 2007-06-25 13:28 UTC
From: cedric Assigned:
Status: Open Package: LiveUser_Admin (version 0.3.9)
PHP Version: 5.2.0 OS: XP
Roadmaps: (Not assigned)    
Subscription  


 [2007-06-25 13:28 UTC] cedric (Cedric Lombardot)
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] ) )

Comments

 [2007-06-25 21:32 UTC] dufuz (Helgi Þormar)
What does your config look like ?
 [2007-06-26 07:22 UTC] cedric (Cedric Lombardot)
$conf = array( 'debug' => $logFile, 'session' => array( 'name' => 'PHPSESSION', 'varname' => 'ludata' ), 'login' => array( 'force' => true, ), 'logout' => array( 'destroy' => false, ), 'cookie' => array( 'name' => 'loginInfo', // name of the Remember me cookie 'lifetime' => 30, // cookie lifetime in days 'path' => null, // cookie path ? 'domain' => _DOMAIN_, // cookie domain ? 'secret' => 'a8l62+@°', 'savedir' => '.', // absolute path to writeable // directory (no trailing slash) ? 'secure' => false, // whether cookie only send over // secure connection ), 'authContainers' => array( 'DB' => array( 'type' => 'MDB2', 'expireTime' => 1600, 'idleTime' => 1600, 'allowEmptyPasswords' => 0, 'passwordEncryptionMode'=> 'MD5', 'storage' => array( 'dsn' => DSN_spyrit, 'alias' => array( 'lastlogin' => 'lastlogin', 'is_active' => 'is_active', 'mail'=>'mail', 'name'=>'name', 'phone'=>'phone', ), 'fields' => array( 'lastlogin' => 'timestamp', 'is_active' => 'boolean', 'mail' => 'text', 'name' => 'text', 'phone' => 'text', ), 'tables' => array( 'users' => array( 'fields' => array( 'lastlogin' => false, 'is_active' => false, 'mail' => NULL, 'name' => NULL, 'phone'=> NULL, ), ), ), ) ) ), 'permContainer' => array( 'type' => 'Complex', 'storage' => array( 'MDB2' => array( 'dsn' => DSN_client, 'prefix' => 'liveuser_' ) ), ), );