RE: [PEAR] DB -> passwort problem with oracle

Hi Jeroen, but I can't connect to the Oracle database, the passwort into the DSN string is wrong, says pear, but it isn't wrong. There is a '+' and a '=' in the passwort. And PEAR can't make a connection to oracle; If I make: $conn = OCILogon ("user", "+***=***","sid"); no problem If I make: $conn = DB::connect(oci8://user:+***=***@$sid); I get the Error: DB Error: connect failed [nativecode=ORA-01017: invalid username/password; logon denied ] greetinX Dirk ------------------------------------------------------------------ Dirk Labes Dipl.-Ing. (FH) Webprogrammer/designer - IT EBV Elektronik GmbH & Co. KG Tel. ++49 (0)8121 - 774-562 ------------------------------------------------------------------ -----Original Message----- From: Jeroen Houben [mailto:jeroen@terena.nl] Sent: Freitag, 11. Juli 2003 12:30 To: Labes Dirk Cc: pear-general@lists.php.net Subject: Re: [PEAR] DB -> passwort problem with oracle Hi Dirk, You can do it like this: $params = array( 'table' => 'users', 'usernamecol' => 'username', 'passwordcol' => 'pwd', 'dsn' => DSN, 'cryptType' => 'none' ); $auth = new Auth('DB', $params); if you leave an option out, it will use the default value instead. HTH - Jeroen Labes Dirk wrote: >Where can I set the options array? >If I set the type in the connect string: > >$db1 = DB::connect($dsn1, array('persistent' => true, 'optimize' >=> 'portability', 'cryptType' => 'none')); > >I get the Error: > >DB Error: unknown option cryptType > >thanX >Dirk > > >-----Original Message----- >From: Jeroen Houben [mailto:jeroen@terena.nl] >Sent: Freitag, 11. Juli 2003 11:32 >To: Labes Dirk >Cc: pear-general@lists.php.net >Subject: Re: [PEAR] DB -> passwort problem with oracle > > >Hi, > >have you set the right encryption type? By default it uses md5 IIRC, so >if you store your passwords using some other encryption type or just >plain text, it won't work. You can set the encryption type in the >options array: > >'cryptType' => 'none' > >HTH >Jeroen > > >Labes Dirk wrote: > > > >>Hi, >> >>thereis a "=" and a "+" in my passwort. >> >>I try the following: >> >>$user1 = "*****"; >>$host1 = "*****"; >>$pass1 = '+***=**'; >>$dsn1 = "oci8://$user1:$pass1@$host1"; >>$db1 = DB::connect($dsn1, array('persistent' => true, 'optimize' >>=> 'portability')); >> >>I get: >> >>Database Error: >>DB Error: connect failed >>[nativecode=ORA-01017: invalid username/password; logon denied ] >> >>But the password is correct. >>What's wrong??? >> >>greetings >>Dirk >> >> >>P.S. I can't change the password >> >> >> >> >> > > > > > >