RE: [phplib] Authentication from multiple databases From: Jason Wong (support <email protected>)
Date: 07/17/00

Howard,

you're right in that PHPLib re-uses links. The way I got around it was just
to simply use a different set of connection parameters for the different
databases. So for each of my databases I have a different user and password.
That way PHPLib would setup a different connection ID for each database.

regards
-
Jason Wong
Digital View Ltd
2201 Nanyang Plaza
57 Hung To Road
Kwun Tong
HONG KONG
Tel: +852-2861-3615
Fax: +852-2520-2987
www.digitalview.com

[snip]

> Database error: Invalid SQL: update active_sessions set val='$this->in =
> \"\"; $this->pt = array();
> $this->pt[\"auth\"] = \"1\"; $GLOBALS[\"auth\"] = new Stud_Auth;
> $GLOBALS[\"auth\"]->auth = array(); $GLOBALS[\"auth\"]->auth[\"uid\"] =
> \"12345678\";
> $GLOBALS[\"auth\"]->auth[\"regnum\"] = \"12345678\";
> $GLOBALS[\"auth\"]->auth[\"password\"] = \"010400\";
> $GLOBALS[\"auth\"]->auth[\"lname\"] = \"Klein\";
> $GLOBALS[\"auth\"]->auth[\"fname\"] =
> \"Hänschen\"; $GLOBALS[\"auth\"]->auth[\"perm\"] = \"student\";
> $GLOBALS[\"auth\"]->auth[\"exp\"] = \"962273687\";
> ',changed='20000629115947' where
> sid='3a9ce6a3edad2e31d4763ae890d7a015' and name='Stud_Session'
> MySQL Error: 1017 (Can't find file: 'active_sessions.frm' (errno: 2))
>
> Session halted.
>
> I believe this has to do with the reuse of a link_ID when a database
> with the same host/user/password is opened. At least I can get
> the error to disappear by a dirty hack using the PHP call
> 'mysql_select_db' on the link_ID. I would like to know how to
> do this properly within PHPLIB.
>
> Thanks,
>
> -- Howard Schultens, Systems admin.
>
> --------------------------------------------------------------------
> Dipl.-Phys. H.Schultens Tel: +49 551 39-5914
> Zentrum Physiologie FAX: +49 551 39-5923
> Humboldtallee 23
> 37073 Goettingen mailto:hs <email protected>
> Germany http://www.neuro-physiol.med.uni-goettingen.de
> --------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>