php-windows Digest 20 Jul 2001 17:38:21 -0000 Issue 661
Topics (messages 8408 through 8420):
Persistent connections: To choose or Not?
8408 by: Ventsyslav Vassilev
8409 by: Rasmus Lerdorf
8410 by: Ventsyslav Vassilev
Re: Help with index.php directory requests
8411 by: Ventsyslav Vassilev
Re: IIS situation - php as an ISAPI
8412 by: Phil Driscoll
Re: ...misbehaved by not returning a complete set of HTTP headers
8413 by: Phil Driscoll
timer function ?
8414 by: Pim van Yperen
Problems with German Umlaut
8415 by: Thomas Feucht
8418 by: Michael Rudel
Verisign pfpro functions in Windows environment ... newbie ...
8416 by: Robert Dyke
Re: Windows 2000 Advanced server trying to do a - header("WWW-Authenticate: Basic
realm=\"Admin\"")
8417 by: Phil Driscoll
MDAC 2.6?
8419 by: Erik H. Mathy
Re: TNS:unable to connect to destination' error
8420 by: Barry Prentiss
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Recently i have faced the following issue:
I have a site running Apache 1.3.19 under Windows 2000 pro/PHP 4.0.6./Oracle
8i
After a little load Apache crashes with ORA-00020 error - maximum number of
Ora connections exceeded. This problem seems to be faced very often by other
people. Limit in ora.reg is 50, but the other told me that even value of 300
does not resolve the issue.
After i started to use OCILogon() function instead of OCIPLogon() the
problem was solved and the site speed is not affected in any way.
But is this the correct way or...?
--
________________________________
Ventsyslav Vassilev
Comel Soft Multimedia
Sofia, Bulgaria
ICQ UIN: 11199819
e-mail: [EMAIL PROTECTED]
Visit http://www.comelsoft.com
CGI, Apache or ISAPI version of PHP?
On Fri, 20 Jul 2001, Ventsyslav Vassilev wrote:
> Recently i have faced the following issue:
> I have a site running Apache 1.3.19 under Windows 2000 pro/PHP 4.0.6./Oracle
> 8i
> After a little load Apache crashes with ORA-00020 error - maximum number of
> Ora connections exceeded. This problem seems to be faced very often by other
> people. Limit in ora.reg is 50, but the other told me that even value of 300
> does not resolve the issue.
> After i started to use OCILogon() function instead of OCIPLogon() the
> problem was solved and the site speed is not affected in any way.
> But is this the correct way or...?
>
> --
> ________________________________
> Ventsyslav Vassilev
> Comel Soft Multimedia
> Sofia, Bulgaria
> ICQ UIN: 11199819
> e-mail: [EMAIL PROTECTED]
> Visit http://www.comelsoft.com
>
>
>
>
PHP as an Apache module
"Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> CGI, Apache or ISAPI version of PHP?
>
> On Fri, 20 Jul 2001, Ventsyslav Vassilev wrote:
>
> > Recently i have faced the following issue:
> > I have a site running Apache 1.3.19 under Windows 2000 pro/PHP
4.0.6./Oracle
> > 8i
> > After a little load Apache crashes with ORA-00020 error - maximum number
of
> > Ora connections exceeded. This problem seems to be faced very often by
other
> > people. Limit in ora.reg is 50, but the other told me that even value of
300
> > does not resolve the issue.
> > After i started to use OCILogon() function instead of OCIPLogon() the
> > problem was solved and the site speed is not affected in any way.
> > But is this the correct way or...?
> >
> > --
> > ________________________________
> > Ventsyslav Vassilev
> > Comel Soft Multimedia
> > Sofia, Bulgaria
> > ICQ UIN: 11199819
> > e-mail: [EMAIL PROTECTED]
> > Visit http://www.comelsoft.com
> >
> >
> >
> >
>
Xmm, my IE6, for example, automaticly adds the last slash in address bar.
Try to set up 2 different virtual directories - one with the slash and one
without it - both pointing to the same physical folder.
"Michael Kelley" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I know it's off topic but there are many Apache users out there.
>
> I have a small problem with my apache set up and I don't know how to fix
it.
>
> When a user requests a directory (that has a index.php or index.html file)
>
> if the request is http://host
>
> Page not found
>
> if request is http://host/
>
> then index page is loaded
>
> How do I set apache so that both will work?
>
> Thanks in Advance and once again sorry for the Off Topic (Any one know
> of a good apache mailing list??)
>
> Mike
>
>
>
>
>
>
>
> --
>
> Michael Kelley
> [EMAIL PROTECTED]
>
> Programmer/Systems Analyst I
> New Mexico State University
> Information and Communication Technologies
> Work # (505)-646-1374
> P.O. Box 30001
> MSC: 3AT
> Las Cruces, NM 88003
>
>
>
>
>
The ISAPI version of PHP is not stable. Switch to the cgi version.
--
Phil Driscoll
have you ticked the 'check file exists' box in your script mappings?
--
Phil Driscoll
hello all,
I'm looking for a timer-function that can make my PHP function wait for some
time. Does such a function excist?
thanks in advance, Pim
Hi all,
I tried to access an SQL Server 2000 with PHP+Apache under Windows 2K (all
on the same machine). Connection was successful and SELECT statements gave
the proper data back. But: The German Umlauts appeared like binary data.
Can anyone help me please?
Thanks a lot,
Thomas
Hi Thomas,
I think there are two possible ways:
1.) Get the SQL-2k-Server to work with the right char-encoding
(iso-8859-1), but I don't know if this is possible on the
SQL-2K-Server ?!
2.) Mask the German Umlaut. You can use urlencode() from PHP
when inserting new entries and urldecode when reading from
the DB.
I hope this helps.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
Besuchen Sie uns am 20. und 21. August 2001 auf der
online-marketing-düsseldorf in Halle 1 Stand E 16
_______________________________________________________________
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
_______________________________________________________________
> -----Original Message-----
> From: Thomas Feucht [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 20, 2001 12:46 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Problems with German Umlaut
>
>
> Hi all,
>
> I tried to access an SQL Server 2000 with PHP+Apache under
> Windows 2K (all
> on the same machine). Connection was successful and SELECT
> statements gave
> the proper data back. But: The German Umlauts appeared like
> binary data.
>
> Can anyone help me please?
> Thanks a lot,
> Thomas
>
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
Hi ... I'm trying to connect to Verisign Payflo Pro on my home development
machine. I've loaded the PHP4 binaries (4.0.6), but when I try to use the
pfpro function (which was cut and pasted from the php.net documentation), I
get the following error:
Fatal error: Call to undefined function: pfpro_init()
I've checked the PHP.net documentation and it says "These pfpro functions
are only available if PHP has been compiled with the --with-pfpro[=DIR]
option."
Does anybody know where I can get the win32 binary compiled with that
option?
TIA
--
Robert Dyke
[EMAIL PROTECTED]
On Thursday 19 July 2001 07:39, pmt_2k wrote:
> im trying to get ie to throw up a www-authenticate box for username /
> password input. im running windows 2000 advanced server and php 4.0
> the code im using (trying to anyway)
>
> <?php
> if (!isset($PHP_AUTH_USER))
>
> Header("WWW-Authenticate: Basic realm=\"Admin\"");
> Header("HTTP/1.0 401 Unauthorized");
If you are using the CGI version of PHP (which is the only production
strenght version for IIS) then sadly IIS 'beats you to it' on the
authentication front and does the authentication for you based on NTLanMan
file permissions.
The ISAPI version of PHP can be installed as an ISAPI filter to get in on the
act early enough to get at the authentication headers, but is unlikely to be
stable enough for production use.
Depending on your requirements, your options are:
Allow IIS to do authenticaton based on file permissions. The up side is that
it's dead easy. The downside is that all your users have to be real users on
the system with 'log on locally' rights.
Use Apache instead.
Cheers
--
Phil Driscoll
Hi Folks!
It's been awhile since I've been on this list. So, of course, now that I'm
back I've got a real good one for you. (Note: I did search the list
archives. No real explanation or answers were found.)
MDAC 2.6...has anyone else experienced serious problems with it? In order
to make my NT4 server development box match a client's environment, I
installed MDAC sp1. As soon as I did so, all ODBC calls from both PHP3 and
PHP4 went haywire. Essentially, I cannot even call a odbc_connect(). I get
the following errors from the following ODBC drivers:
----------
Example 1:
Driver...Microsoft Access Driver.
Specifics: Generic .mdb file, NTFS security set to "Everyone - Full
Control" (just to rule out NTFS bullsh!t), no password set. ODBC connection
tested via Oracle's ODBC utility with no problems.
Error message: S1000 [Microsoft][ODBC Microsoft Access Driver] The
Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.
----------
Example 2:
Driver...Microsoft Oracle Driver.
Specifics: Oracle8i server on running on the same machine as IIS. ODBC
connection tested via Oracle's ODBC utility with no problems.
Error message: IM004 [Microsoft][ODBC Driver Manager] Driver's
SQLAllocHandle on SQL_HANDLE_ENV failed
----------
Example 3:
Driver...Oracle ODBC Driver.
Specifics: Oracle8i server on running on the same machine as IIS. ODBC
connection tested via Oracle's ODBC utility with no problems.
Error message: IM003 Specified driver could not be loaded due to system
error 5 (Oracle ODBC Driver).
----------
I get these messages no matter which version of PHP (4.0.6 and 3.0.11) I
run. I had no issues hitting these datasources with MDAC 2.5. I can also
connect to them via other means than PHP.
Thoughts?
- Erik
Hi All,
I finally got past the php_oci8.dll problem by moving it to the same
directory as php.exe and changing the php.ini extensions_dir back to './'.
Now I am getting the following error:
Warning: _oci_open_server: ORA-12203: TNS:unable to connect to
destination in c:\program files\apache
group\apache\htdocs\dna\dna_oci_sys_list.php on line 20
which occurs at the $conn line below:
error_reporting (E_ALL);
putenv('ORACLE_HOME=C:\orant');
putenv('TNS_ADMIN=C:\orant\NET80\ADMIN');
putenv('ORACLE_SID=SLAC');
putenv('TWO_TASK=SLAC_TCP');
$conn = ociLogon("user","password");
This implies that I am reaching the Net8 oci client libraries (right?).
My environment: PHP 4.0.5, Apache 1.3.19, W2K, Net8 8.0.6.0.0, remote Oracle
8.1.6 on Solaris.
I can connect through SQL*Plus, tests OK through Net8 assistant,
tnsnames.ora is in proper place (as defined in TNS_ADMIN above).
What am I doing wrong?
Thx in advance,
Barry Prentiss
