Re: DB -> passwort problem with oracle

Stupid me! I've totally misunderstood the problem. For some weird reason I thought you were having problems with PEAR::Auth, trying to login - reading back there's not a single notice of PEAR::Auth in your posts, so who knows why I thought this (!??) Anyway, I know nothing about Oracle, sorry I can't help. Jeroen Labes Dirk wrote:

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