Reconnecting to DB

Nathan_Gray-2 2008-09-09 20:48:54 UTC #1

Both pERP and workflow like to be connected to a database with
transactions. The code to do so for MySQL looks like:

$db = clone($GLOBALS[‘egw’]->db);
$db->disconnect();
$db->connect(
$GLOBALS[‘egw_info’][‘server’][‘db_name’],
$GLOBALS[‘egw_info’][‘server’][‘db_host’],
$GLOBALS[‘egw_info’][‘server’][‘db_port’],
$GLOBALS[‘egw_info’][‘server’][‘db_user’],
$GLOBALS[‘egw_info’][‘server’][‘db_pass’],
‘mysqlt’
);
return $db;

SVN rev. 25875
Recently (sorry, can’t be more specific), this gives the following
(from pERP, from workflow is pretty much the same):
Warning: include_once(/…/ADOdb/inc/class…inc.php): failed to open
stream: No such file or directory in
/…/phpgwapi/inc/common_functions.inc.php on line 680

Warning: include_once() [function.include: Failed opening
’/…/ADOdb/inc/class…inc.php’ for inclusion
(include_path=’/…/egw-pear:.:/usr/share/php:/usr/share/
pear’) in /…/phpgwapi/inc/common_functions.inc.php on
line 680

CreateObject(‘ADOdb’): Cant instanciate class!!!
bo_perp_api::perp_autoload / call_user_func(Array) / __autoload(ADOdb) /
class_exists(ADOdb) / egw_minimal::__get / egw_db::connect /
bo_perp_api::reconnect_transactional / call_user_func(Array) /
ExecMethod(perp_api.bo_perp_api.reconnect_transactional) /
ReceivableInvoice::post / ui_perp_receivable_invoice::edit /
call_user_func(Array) /
ExecMethod(perp_ar.ui_perp_receivable_invoice.edit)
/ etemplate::process_exec / call_user_func(Array) /
ExecMethod(etemplate.etemplate.process_exec)

For some reason (session not being properly restored?) it looks like
the egw_minimal::ADOdb object is null (see class.egw.inc.php, 572).
This causes the various autoload functions to be called (eGW’s
autoload first, then pERP’s) looking for ‘ADOdb’, which fails.

Sometimes if you log in, and go to the page that fails immediately, it
works with no problems. The error seems to happen after working for a
while, or if you have been working, log out, then log back in.

Ralf, any tips would be appreciated. I’m not even sure where to start
looking for a fix. Is there something not being done by pERP and
workflow to correctly restore the session, or is there something awry
in the autoloading? It looks like it’s looking for /ADODB/inc/…
instead of /phpgwapi/adodb/… Or something else entirely?

Nathan Gray
nathan at goarctic dot com

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Ralf_Becker_6 2008-09-10 06:00:24 UTC #2

The ADOdb classes are never autoloaded. They are explicitly included and
the egw_db::connect() add the files loaded by ADOdb itself to the list
of files to explicitly include:

foreach(get_included_files() as $file)
{
if (strpos($file,‘adodb’) !== false &&
!in_array($file,(array)$_SESSION[‘egw_required_files’]))
{
$_SESSION[‘egw_required_files’][] = $file;
}
}

I dont have time to investigate that further at the moment, but I wonder
why you not simply use ‘mysqlt’ as db-type for the whole eGW. A quick
test shows it works with the rest of eGW and I have no idea why it
should not.

Ralf

Nathan Gray schrieb:

Both pERP and workflow like to be connected to a database with
transactions. The code to do so for MySQL looks like:

$db = clone($GLOBALS[‘egw’]->db);
$db->disconnect();
$db->connect(
$GLOBALS[‘egw_info’][‘server’][‘db_name’],
$GLOBALS[‘egw_info’][‘server’][‘db_host’],
$GLOBALS[‘egw_info’][‘server’][‘db_port’],
$GLOBALS[‘egw_info’][‘server’][‘db_user’],
$GLOBALS[‘egw_info’][‘server’][‘db_pass’],
‘mysqlt’
);
return $db;

SVN rev. 25875
Recently (sorry, can’t be more specific), this gives the following
(from pERP, from workflow is pretty much the same):
Warning: include_once(/…/ADOdb/inc/class…inc.php): failed to open
stream: No such file or directory in
/…/phpgwapi/inc/common_functions.inc.php on line 680

Warning: include_once() [function.include: Failed opening
’/…/ADOdb/inc/class…inc.php’ for inclusion
(include_path=’/…/egw-pear:.:/usr/share/php:/usr/share/
pear’) in /…/phpgwapi/inc/common_functions.inc.php on
line 680

CreateObject(‘ADOdb’): Cant instanciate class!!!
bo_perp_api::perp_autoload / call_user_func(Array) / __autoload(ADOdb) /
class_exists(ADOdb) / egw_minimal::__get / egw_db::connect /
bo_perp_api::reconnect_transactional / call_user_func(Array) /
ExecMethod(perp_api.bo_perp_api.reconnect_transactional) /
ReceivableInvoice::post / ui_perp_receivable_invoice::edit /
call_user_func(Array) /
ExecMethod(perp_ar.ui_perp_receivable_invoice.edit)
/ etemplate::process_exec / call_user_func(Array) /
ExecMethod(etemplate.etemplate.process_exec)

For some reason (session not being properly restored?) it looks like
the egw_minimal::ADOdb object is null (see class.egw.inc.php, 572).
This causes the various autoload functions to be called (eGW’s
autoload first, then pERP’s) looking for ‘ADOdb’, which fails.

Sometimes if you log in, and go to the page that fails immediately, it
works with no problems. The error seems to happen after working for a
while, or if you have been working, log out, then log back in.

Ralf, any tips would be appreciated. I’m not even sure where to start
looking for a fix. Is there something not being done by pERP and
workflow to correctly restore the session, or is there something awry
in the autoloading? It looks like it’s looking for /ADODB/inc/…
instead of /phpgwapi/adodb/… Or something else entirely?

Nathan Gray
nathan at goarctic dot com

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Nathan_Gray-2 2008-09-10 14:08:59 UTC #3

… I wonder
why you not simply use ‘mysqlt’ as db-type for the whole eGW.

Because it wasn’t an option in the header admin, and I never thought
to try changing it myself.
Thank you, Ralf. That one little ‘t’ just saved me a lot of trouble.

Nathan Gray
nathan at goarctic dot com

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers