Hi,

I am looking for someone that has access to a testing oracle
database.
I would like to ask to take a look at bug #11848 [1] and try
the test
script provided by the user to see if the problem can be
reproduced. I
have no access to such database. Also, I am not even sure
they have a
server version for Mac OS X (not server), the only operation
system
that is available to me ATM.

[1] http://pear
.php.net/bugs/bug.php?id=11848

Kind regards,
iGor.

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

Hi Igor,

i can reproduce it.

MDB2_Driver_oci8::_doConnect is called twice, the first time
with the
username and password from the $dsn array, the second time
the username
is replaced by the database name as it is defined in the XML
schema.

If the database name is a valid username than it works.

regards,
Friedel


Igor Feghali schrieb:
> Hi,
> 
> I am looking for someone that has access to a testing
oracle database.
> I would like to ask to take a look at bug #11848 [1]
and try the test
> script provided by the user to see if the problem can
be reproduced. I
> have no access to such database. Also, I am not even
sure they have a
> server version for Mac OS X (not server), the only
operation system
> that is available to me ATM.
> 
> [1] http://pear
.php.net/bugs/bug.php?id=11848
> 
> Kind regards,
> iGor.
> 

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

Hi,

> I am looking for someone that has access to a testing
oracle database.
> I would like to ask to take a look at bug #11848 [1]
and try the test
> script provided by the user to see if the problem can
be reproduced. I
> have no access to such database. Also, I am not even
sure they have a
> server version for Mac OS X (not server), the only
operation system
> that is available to me ATM.
>
> [1] http://pear
.php.net/bugs/bug.php?id=11848

Well, I've Oracle installed in my desktop, just need to
arrive home
(at night, Mexico City) to test it. However, in Jaws
Project[0] we are
using MDB2 and someone reported a similar bug[1] about
having wrong
username/password values using Oracle (oci8) so with this
information
I can be pretty sure the bug Mark submitted is true.

[0] http://www.jaws-project.c
om
[1] http://dev.jaws-project.com/cgi-bin/trac.cgi/ticket/416

Cheers,
-- 
Pablo Fischer (pfischer [arroba/at] php.net)

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

Hello Friedel,

Thank you a lot. I will investigate this.

regards,
iGor.

On 8/17/07, Friedmut Hill <friedelgmx.net> wrote:
> Hi Igor,
>
> i can reproduce it.
>
> MDB2_Driver_oci8::_doConnect is called twice, the first
time with the
> username and password from the $dsn array, the second
time the username
> is replaced by the database name as it is defined in
the XML schema.
>
> If the database name is a valid username than it
works.
>
> regards,
> Friedel
>
>
> Igor Feghali schrieb:
> > Hi,
> >
> > I am looking for someone that has access to a
testing oracle database.
> > I would like to ask to take a look at bug #11848
[1] and try the test
> > script provided by the user to see if the problem
can be reproduced. I
> > have no access to such database. Also, I am not
even sure they have a
> > server version for Mac OS X (not server), the only
operation system
> > that is available to me ATM.
> >
> > [1] http://pear
.php.net/bugs/bug.php?id=11848
> >
> > Kind regards,
> > iGor.
> >
>
> --
> PEAR Development Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub
.php
>
>

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

Hi Pablo,

Thanks. When you arrive home please tell me how your tests
gone.
Could you please do some test with only the MDB2 driver as
well ? Like
connecting and performing a simple query. Just to be sure
whether this
is a MDB2_Schema issue.

regards,
iGor.

On 8/17/07, Pablo Fischer <pfischerphp.net> wrote:
> Hi,
>
> > I am looking for someone that has access to a
testing oracle database.
> > I would like to ask to take a look at bug #11848
[1] and try the test
> > script provided by the user to see if the problem
can be reproduced. I
> > have no access to such database. Also, I am not
even sure they have a
> > server version for Mac OS X (not server), the only
operation system
> > that is available to me ATM.
> >
> > [1] http://pear
.php.net/bugs/bug.php?id=11848
>
> Well, I've Oracle installed in my desktop, just need to
arrive home
> (at night, Mexico City) to test it. However, in Jaws
Project[0] we are
> using MDB2 and someone reported a similar bug[1] about
having wrong
> username/password values using Oracle (oci8) so with
this information
> I can be pretty sure the bug Mark submitted is true.
>
> [0] http://www.jaws-project.c
om
> [1] http://dev.jaws-project.com/cgi-bin/trac.cgi/ticket/416
>
> Cheers,
> --
> Pablo Fischer (pfischer [arroba/at] php.net)
>
> --
> PEAR Development Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub
.php
>
>

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

Hi Friedel,

could you please test again with the instruction on my last
comment here :

http://pear
.php.net/bugs/bug.php?id=11848

the reporter didn't give any feedback so far so I would need
the help
of someone else. As you were the only one that confirmed the
bug I
hope you don't mind to help me with that one more time ;)

regards,
iGor.

On 8/17/07, Friedmut Hill <friedelgmx.net> wrote:
> Hi Igor,
>
> i can reproduce it.
>
> MDB2_Driver_oci8::_doConnect is called twice, the first
time with the
> username and password from the $dsn array, the second
time the username
> is replaced by the database name as it is defined in
the XML schema.
>
> If the database name is a valid username than it
works.
>
> regards,
> Friedel
>
>
> Igor Feghali schrieb:
> > Hi,
> >
> > I am looking for someone that has access to a
testing oracle database.
> > I would like to ask to take a look at bug #11848
[1] and try the test
> > script provided by the user to see if the problem
can be reproduced. I
> > have no access to such database. Also, I am not
even sure they have a
> > server version for Mac OS X (not server), the only
operation system
> > that is available to me ATM.
> >
> > [1] http://pear
.php.net/bugs/bug.php?id=11848
> >
> > Kind regards,
> > iGor.
> >
>
> --
> PEAR Development Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub
.php
>
>

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

Hi,

should that work with 0.8.1 or CVS only? Because with 0.8.1
it does not.

If I pass the options to MDB2::connect they are present in
the
MDB2_Driver_oci8::options array, passing them to
MDB2_Schema::factory
has no effect since MDB2_Schema::options does not have these
keys.

Anyway, they are not used. MDB2 still tries to connect with
the database
name from the XML file. Instead of connecting again it
should probably
exec an "alter session set current_schema"
statement if the database
name is different from the username, but i don't know much
about oracle
or MDB2 (not even using it), it's just a thought.

regard

Igor Feghali schrieb:
> Hi Friedel,
> 
> could you please test again with the instruction on my
last comment here :
> 
> http://pear
.php.net/bugs/bug.php?id=11848
> 
> the reporter didn't give any feedback so far so I would
need the help
> of someone else. As you were the only one that
confirmed the bug I
> hope you don't mind to help me with that one more time
;)
> 
> regards,
> iGor.
> 
> On 8/17/07, Friedmut Hill <friedelgmx.net> wrote:
>> Hi Igor,
>>
>> i can reproduce it.
>>
>> MDB2_Driver_oci8::_doConnect is called twice, the
first time with the
>> username and password from the $dsn array, the
second time the username
>> is replaced by the database name as it is defined
in the XML schema.
>>
>> If the database name is a valid username than it
works.
>>
>> regards,
>> Friedel
>>
>>
>> Igor Feghali schrieb:
>>> Hi,
>>>
>>> I am looking for someone that has access to a
testing oracle database.
>>> I would like to ask to take a look at bug
#11848 [1] and try the test
>>> script provided by the user to see if the
problem can be reproduced. I
>>> have no access to such database. Also, I am not
even sure they have a
>>> server version for Mac OS X (not server), the
only operation system
>>> that is available to me ATM.
>>>
>>> [1] http://pear
.php.net/bugs/bug.php?id=11848
>>>
>>> Kind regards,
>>> iGor.
>>>
>> --
>> PEAR Development Mailing List (http://pear.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub
.php
>>
>>

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

On 9/25/07, Friedmut Hill <friedelgmx.net> wrote:
> Hi,
>
> should that work with 0.8.1 or CVS only? Because with
0.8.1 it does not.
>

0.8.1 === CVS

> If I pass the options to MDB2::connect they are present
in the
> MDB2_Driver_oci8::options array, passing them to
MDB2_Schema::factory
> has no effect since MDB2_Schema::options does not have
these keys.
>

yeh they should be in the MDB2 options array.

> Anyway, they are not used. MDB2 still tries to connect
with the database
> name from the XML file. Instead of connecting again it
should probably
> exec an "alter session set current_schema"
statement if the database
> name is different from the username, but i don't know
much about oracle
> or MDB2 (not even using it), it's just a thought.
>

MDB2_Driver_oci8

line 514:
    function &standaloneExec($query)
    {
        $connection = $this->_doConnect(
            $this->options['DBA_username'],
            $this->options['DBA_password'],
            $this->options['persistent']
        );

same for standaloneQuery()...

When I followed it I noticed that it is assumed the database
name as
the username when DBA_username is empty. ATM I just don't
remember
where I read that though. If that option isn't used at all
so I would
better investigate further... it seems that I am in the
wrong way.

thank you for your help,
iGor.

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php