php-windows Digest 16 Apr 2002 03:15:47 -0000 Issue 1095
Topics (messages 13094 through 13115):
Re: Apache 2.0.35
13094 by: Chris Dion
13115 by: Haagen Waade
Re: String reduce
13095 by: Kriegers Horst
Re: Tutorials on stored procedures using SQL Server
13096 by: Svensson, B.A.T. (HKG)
Re: MySQL-max and transaction isolation level ?
13097 by: Svensson, B.A.T. (HKG)
13098 by: Svensson, B.A.T. (HKG)
HELP! Connect or no connect, that's the question...
13099 by: Syd.gmx.net
13114 by: Brad Thomas
Processing forms and emailing results
13100 by: R.S. Herhuth
Re: Security using Apache & Windows
13101 by: Mike Flynn
13102 by: Svensson, B.A.T. (HKG)
How do Pear::DB and ADODB stack up against each other?
13103 by: Asendorf, John
Re: Something involving php, but not windows.
13104 by: Ray Hunter
Re: Frontpage- help!
13105 by: Woolsey, Fred
13109 by: Roger
extention php for win
13106 by: Kimkof.aol.com
PHP stable and for production
13107 by: Roger
13108 by: Roger
13110 by: Christoph Grottolo
Re: Problems with mail()
13111 by: Patrick Reagan
COM and ADODB access
13112 by: Scott Carr
Re: PHP and ZIP
13113 by: Jeff Waldock
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]
----------------------------------------------------------------------
--- Begin Message ---
Tried that still can't start apache2. What version and stuff are you using
and are you sure that's all you added to your http.conf?
--Chris
"Steffen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> This works for me:
>
> LoadModule php4_module d:/bin/php/experimental/apache2filter.dll
> AddType application/x-httpd-php .php
> AddType application/x-httpd-php-source .phps
>
> Steffen
>
>
> "Haagen Waade" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 4.2.0 RC3 is out, and with Apache2 support.
> >
> > But how to configure it with apache2 ? I see there is a
> > /experimental/apache2filter.dll
> > I guess this is the new module for apache2, but how do I configure it in
> > httpd.conf
> > I've tried to load it as an module, but did not get it to work.
> >
> >
> > "Chris Dion" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > Now that there is a binary out for apache 2 for windows...are we going
> to
> > > get a binary for php for apache 2? Anyone know? Or how I can manage
to
> > > compile php for apache2?
> > >
> > >
> >
> >
>
>
--- End Message ---
--- Begin Message ---
Thx, Steffen!
I got it to work now.
I still had the old php.ini file, and php4ts.dll file (from 4.1.2); and even
that is working with the apache2filer!
Guess it's not depenent on the php version then?
Chirs: yes, this is all you need to enable php.
h.
"Chris Dion" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Tried that still can't start apache2. What version and stuff are you
using
> and are you sure that's all you added to your http.conf?
>
> --Chris
>
> "Steffen" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > This works for me:
> >
> > LoadModule php4_module d:/bin/php/experimental/apache2filter.dll
> > AddType application/x-httpd-php .php
> > AddType application/x-httpd-php-source .phps
> >
> > Steffen
> >
> >
> > "Haagen Waade" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > 4.2.0 RC3 is out, and with Apache2 support.
> > >
> > > But how to configure it with apache2 ? I see there is a
> > > /experimental/apache2filter.dll
> > > I guess this is the new module for apache2, but how do I configure it
in
> > > httpd.conf
> > > I've tried to load it as an module, but did not get it to work.
> > >
> > >
> > > "Chris Dion" <[EMAIL PROTECTED]> wrote in message
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > Now that there is a binary out for apache 2 for windows...are we
going
> > to
> > > > get a binary for php for apache 2? Anyone know? Or how I can
manage
> to
> > > > compile php for apache2?
> > > >
> > > >
> > >
> > >
> >
> >
>
>
--- End Message ---
--- Begin Message ---
Thanks to all who helped me
Horst
> -----Message d'origine-----
> De: Hugh Bothwell [SMTP:[EMAIL PROTECTED]]
> Date: vendredi, 12. avril 2002 16:02
> À: [EMAIL PROTECTED]
> Objet: [PHP-WIN] Re: String reduce
>
>
> "Kriegers Horst" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi all,
> >
> > how can I replace the n ; with only one
> >
> > Mot1;;Mot2;;;;;;;;;;;;;Mot3;;;;;;Mot4;;;;;;;Mot5;;;;Mot6
> > ==>
> > Mot1;Mot2;Mot3;Mot4;Mot5;Mot6
>
> alternatively,
>
> $newstr = preg_replace("/;+/",";",$str);
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
> FD> What exactly do u mean? storing functions in an database?
>
> SQL servers can store pre-programmed sequences of SQL instructions in
> a "subroutine" type format for simplified execution of standardised
> functions. These are known as Stored Procedures.
Other RDBMS are able to do the same, stored procedures is even
part of the ISO SQL 9075:1992 if I remember it correctly.
--- End Message ---
--- Begin Message ---
Does this mail lists topic say:
"MySQL - Answes and question?"
No it does not....
> -----Original Message-----
> From: Sviss Cobazor [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 14, 2002 7:38 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] MySQL-max and transaction isolation level ?
>
>
> Hi NG.
>
> Can anybody tell me what the possible isolation levels for MySQL-max means
> while using BDB tables?
> The meaning of each possible isolation level isn't described, only what
> levels are possible to set.
>
> You can start your server with one of the following values:
>
> transaction-isolation= READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ,
> SERIALIZABLE
> But what does each of these mean?
AN isolation level is about how "isolated" and action is in the database.
Read uncommitted, or dirty read, is the lowest isolation level in the data
base and means that data you just read can be deleted or modified since
no locks are hold on data. Hence, your data might or might not be updated,
or deleted by some other process.
Read committed means that shared locks are held while the data is being
read in order to prevent dirty reads, but your data can be changes by
other procress before the end of the transaction since this is not an
atomic operation.
Repeatable read means that locks are placed on all data that is used in
the query. But this does not prevent the inserts of phantom rows by other
processes.
Serializable means just exactly what it says: it prevents concurrency, in
the database and perform an holdlock on everything you uses - even with the
select statements during the transaction. This is the most isolated form
of transaction you can do - and your entire transaction is more or
less an atomic operation in the database.
> thanks in advance...
>
> ~ Sviss
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
> transaction-isolation= READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ,
> SERIALIZABLE
>
> But what does each of these mean?
A short table for things that are allowed
under different transacation levels:
Level a b c
-----+-+-+-+
UNCOM|Y|Y|Y|
-----+-+-+-+
COMIT|N|Y|Y|
-----+-+-+-+
REPAT|N|N|Y|
-----+-+-+-+
SERIL|N|N|N|
-----+-+-+-+
a = dirty read
b = non-repeatable reads
c = phantoms
--- End Message ---
--- Begin Message ---
Dear all,
I installed mysql for windows and had to copy some databases (including
mysql standard databases), that I have to use for my php-project. I also
installed the Apache server 1.3 ...
My problem is, that I get a connect with mysql_connect("localhost",
$username, $password); only for the first time after installing an copying the
databases. After reboot and starting mysql as a service with mysqladmin and
entering password and user in my "login.php", this error occurs:
2003: Can't connect to MySQL server on 'localhost' (10061)
I tried "telnet localhost 3306" under DOS but connection failed. ( After
install, it worked ) I tried other users and passwords, which are in mysql.user
- but no connect.
I don't have a glimpse of an idea left to do. What do I have to do to get
the connect with mysql_connect oder do I have to something with the tables in
mysql ?
After reboot Mysqladmin shows the tables at least...
so I desperately need help :-(
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
--- End Message ---
--- Begin Message ---
<[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Dear all,
>
> I installed mysql for windows and had to copy some databases (including
> mysql standard databases), that I have to use for my php-project. I also
> installed the Apache server 1.3 ...
>
> My problem is, that I get a connect with mysql_connect("localhost",
> $username, $password); only for the first time after installing an copying
the
> databases. After reboot and starting mysql as a service with mysqladmin
and
> entering password and user in my "login.php", this error occurs:
>
> 2003: Can't connect to MySQL server on 'localhost' (10061)
>
> I tried "telnet localhost 3306" under DOS but connection failed. ( After
> install, it worked ) I tried other users and passwords, which are in
mysql.user
> - but no connect.
>
> I don't have a glimpse of an idea left to do. What do I have to do to get
> the connect with mysql_connect oder do I have to something with the tables
in
> mysql ?
>
> After reboot Mysqladmin shows the tables at least...
>
> so I desperately need help :-(
>
> --
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
>
Have you started the MySQL server before trying to connect to it?
--- End Message ---
--- Begin Message ---
I setup the latest versions of Apache, and php. I would like to be able
to process a couple forms and email responses but I can't figure out how
to configure my system to do this. Do I need yet another application
to add this functionality? If so what am I looking for? Any advice?
Thanks,
Ron
--- End Message ---
--- Begin Message ---
At 09:23 PM 4/14/2002 -0400, Tim Mackenzie wrote:
>There is a way of configuring PHP to limit access to the file system. You
>don't want any schmuck who uploads a PHP script access to your entire
>system, right? PHP allows you to limit what parts of the system can be
>seen. My question is how is this done?
What do you mean, "limit access to the file system"? You mean to the
web-accessible directories, or to the whole server? And limit how? All
PHP does is run scripts. Do you mean PHP limiting its scripts' access to
different areas of the server when using file-related functions? PHP
doesn't give users any kind of access to the file system besides as an
interface through functions that a script might call.
-Mike
--- End Message ---
--- Begin Message ---
Dear Timothy,
I totally agree with you about smucks - I prefere to call
them people with low moral insight. :) About PHP, it might
very well be as you said, and if so, and if one execute
this method one are still vulnerably to attacks - if one
can set this privileges with in PHP then one, or rather
the smucks, can remove them with in PHP to.
But if these access right are controlled by a meta-system
instead (e.g. the file access control list maintained by the
operating system it self, and/or the file security settings
within the web server it self), this would be a much secure
way to ensure the file security policy within your system.
//Anders
> -----Original Message-----
> From: Timothy Mackenzie [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 15, 2002 2:54 AM
> To: Svensson, B.A.T. (HKG)
> Subject: Re: [PHP-WIN] Re: Security using Apache & Windows
>
>
> There is a way of configuring PHP to limit access to the file system. You
> don't want any schmuck who uploads a PHP script access to your entire
> system, right? PHP allows you to limit what parts of the system can be
> seen. My question is how is this done?
>
> ----- Original Message -----
> From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
> To: "Tim Mackenzie" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, April 12, 2002 6:40 AM
> Subject: RE: [PHP-WIN] Re: Security using Apache & Windows
>
>
> > This is after all and PHP list, so if you explain the relation to
> > PHP then people might help you
> >
> > Otherwise you might try ask in an apache or MS Windows support group....
> >
> > > -----Original Message-----
> > > From: Tim Mackenzie
> > > Sent: Tuesday, April 02, 2002 5:47 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP-WIN] Re: Security using Apache & Windows
> > >
> > >
> > > No one can help?! Please, please, please...
> > >
> > > "Tim Mackenzie" <[EMAIL PROTECTED]> wrote in message
> > > > I'm running W2K with Apache and PHP4. I'm going to be hosting a
> number of
> > > > websites that I would like to provide PHP support for. What I don't
> want is
> > > > them to be able to access my entire file system. They should, at
> most, be
> > > > only allowed read/write access to their site folder. How do I go
> about
> > > > doing this? I've looked around, but I haven't found something that
> > > > addresses this. I know there's the basedir value (I think that's it),
> but I
> > > > don't understand how to use it. Could somebody (several people)
> please post
> > > > any tips they have for securing the file system of a web server.
> Thanks!
> >
>
--- End Message ---
--- Begin Message ---
I've been using ADODB for quite a while (since version 1.4) and I just love
it. But, I've been considering looking at Pear's DB layer. Has anyone used
both of them enough to compare? I'm connecting to Oracle, Access, MSSQL and
MySQL databases... so that is one of the considerations I have to make.
Thanks in advance for the info,
John
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
--- End Message ---
--- Begin Message ---
You can run the script as a shell script and have it run as the root user.
You might want to change the permissions and allow it to change id as it
runs; however, this is a great security risk...
Ray Hunter
"Michael Reynolds" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I know this is the windows list, but for 1 question, I don't
> feel the need to subscribe to the other lists. Would anyone
> be able to tell me how to run a single php script as root,
> but apache still run as a non-wheel user? Trying to do this
> on FreeBSD 4.5-STABLE, but it isn't working for me. Need
> the page to run as root, in order to directly modify the
> master.passwd file.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
--- End Message ---
--- Begin Message ---
Ditto... I'm running Apache on Windows 2000 and Windows XP, both with PHP,
and it runs byootifully. One note on Front Page, though- it really doesn't
like <? or <?php tags in the HEAD section of an HTML document, and will
insist on "fixing" your document for you by moving any such scripts to the
BODY. Use <script language="php"> ... </script> if you're writing your own
scripts or editing existing scripts in anything but HTML view in Front Page.
An alternative is to use the .asp-style tags <% and %>, which FP, being a
Microsoft product, likes just fine.
Cheers,
Fred Woolsey
-----Original Message-----
From: Scott Carr
To: JJ in MD_USA
Cc: PHP Windows
Sent: 4/13/2002 9:35 PM
Subject: Re: [PHP-WIN] Frontpage- help!
Download a copy of Apache. It runs on Win32 OS, and just about anywhere
else
you happen to be.
If you have problems setting it up, I'll help you.
http://httpd.apache.org
--
Scott Carr
OpenOffice.org
Whiteboard-Doc Maintainer
http://whiteboard.openoffice.org/doc/
Quoting JJ in MD_USA <[EMAIL PROTECTED]>:
> All I want to do is have MS Frontpage 2000 be able to interpret the
php3
> files. Does this mean that I have to install a server on my Win98 OS?
I
> have downloaded and installed PHP.exe and all that, and also the
rocket
> addin from MS knowledgebase, but it still doesn't seem to interpret.
>
> Thanks for any help,
> JJ
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Try use one editor with php syntax hightlight like jext, one of the bests
www.jext.org (free)
"Fred Woolsey" <[EMAIL PROTECTED]> escreveu na mensagem
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Ditto... I'm running Apache on Windows 2000 and Windows XP, both with PHP,
> and it runs byootifully. One note on Front Page, though- it really
doesn't
> like <? or <?php tags in the HEAD section of an HTML document, and will
> insist on "fixing" your document for you by moving any such scripts to the
> BODY. Use <script language="php"> ... </script> if you're writing your
own
> scripts or editing existing scripts in anything but HTML view in Front
Page.
> An alternative is to use the .asp-style tags <% and %>, which FP, being a
> Microsoft product, likes just fine.
>
> Cheers,
> Fred Woolsey
>
> -----Original Message-----
> From: Scott Carr
> To: JJ in MD_USA
> Cc: PHP Windows
> Sent: 4/13/2002 9:35 PM
> Subject: Re: [PHP-WIN] Frontpage- help!
>
> Download a copy of Apache. It runs on Win32 OS, and just about anywhere
> else
> you happen to be.
>
> If you have problems setting it up, I'll help you.
>
> http://httpd.apache.org
>
> --
> Scott Carr
> OpenOffice.org
> Whiteboard-Doc Maintainer
> http://whiteboard.openoffice.org/doc/
>
>
> Quoting JJ in MD_USA <[EMAIL PROTECTED]>:
>
> > All I want to do is have MS Frontpage 2000 be able to interpret the
> php3
> > files. Does this mean that I have to install a server on my Win98 OS?
> I
> > have downloaded and installed PHP.exe and all that, and also the
> rocket
> > addin from MS knowledgebase, but it still doesn't seem to interpret.
> >
> > Thanks for any help,
> > JJ
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> -------------------------------------------------
> This mail sent through IMP: http://horde.org/imp/
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
hi
i developp an extention for linux
but for win how compile it???? with what compiler????
thanks
kimkof
--- End Message ---
--- Begin Message ---
Hi,
I listened that php on windows is not considered for produtions ans stable.
I listed that it is like a test version for windows and is not safe use in
night traffic sites with database access.
Could some one confirmar that infor to me?
Thanks in Advance
Rogerio
--- End Message ---
--- Begin Message ---
Hi,
I listened that php on windows is not considered for produtions ans stable.
I listed that it is like a test version for windows and is not safe use in
higth traffic sites with database access.
Could some one confirmar that infor to me?
Thanks in Advance
Rogerio
--- End Message ---
--- Begin Message ---
No, i can't confîrm that.
We use PHP on win32 with Apache and with IIS on WinNT an Win2000 servers.
There have been stability prolems but only with ISAPI and they seem to have
gone with 4.10.
Like in other environments security issues are discovered now and then.
Usually fixed versions are available quite fast. But I have to say that PHP
and the web server have to be configured properly to work in a secured -
like any other software exposed to the public.
Christoph
"Roger" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
| Hi,
|
| I listened that php on windows is not considered for produtions ans
stable.
| I listed that it is like a test version for windows and is not safe use in
| night traffic sites with database access.
|
| Could some one confirmar that infor to me?
|
| Thanks in Advance
| Rogerio
|
|
--- End Message ---
--- Begin Message ---
I have run into this problem before. When using Windows, make sure you
are using the CRLF sequence for hard returns rather than just LF.
i.e.
\r\n
instead of
\n
a simple str_replace will allow you to format it correctly before sending.
good luck
p.
Adolfo Meneses wrote:
> Welcome to the club!
> I have the same problem, try to put your ISP smtp server.
> or install the smtp server that come with iis5.
> i still dont have a solution to me.
> Adolfo
> ----- Original Message -----
> From: "Alberto. Sartori" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 13, 2002 6:40 AM
> Subject: [PHP-WIN] Problems with mail()
>
>
>
>>Hi guys. I've a big problem using mail() function. My system run under
>
> Win2k SP2 italian, with IIS 5 and PHP 4.1.2 (although I got this prob since
> 4.1.0). This is my php.ini
>
>>[mail function]
>>; For Win32 only.
>>SMTP = localhost
>>
>>; For Win32 only.
>>sendmail_from = [EMAIL PROTECTED]
>>
>>I've tried to replace SMTP value with 127.0.0.1 or with my subnet
>
> IP....nothing to do!
>
>>It appears "Warning: Server Error in c:\inetpub\wwwroot\esempi\email.php
>
> on line 19"
>
>>This is my line 19:
>>
>>mail("[EMAIL PROTECTED]","hi lamer","all ok?");
>>
>>It could be a bug? if I run this code under a english version of Win2k all
>
> works fine. My SMTP server in IIS is correctly configured, I'm sure about
> this!
>
>>Best regards, alb
>>
>>
>>--
>>PHP Windows Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
>
--- End Message ---
--- Begin Message ---
I am having a problem with SQL statements passed to a COM object.
"SELECT * FROM Reports" works fine.
"SELECT IDCode, Report_Name, Report_Description, Report_Status FROM Reports"
blows up. I have been having this issue with 4.0.6 through 4.2.0 RC3.
Has anybody else tried to pass semi-long strings to a COM object?
Here is the error I get on the second select statement:
Warning: Error in php_OLECHAR_to_char() in d:\php\pear\DB\adodb.php on line 191
It's like that for every large string I pass.
--
Scott Carr
OpenOffice.org
Whiteboard-Doc Maintainer
http://whiteboard.openoffice.org/doc/
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--- End Message ---
--- Begin Message ---
What's wrong with using the Winzip command line utility then?
(http://www.winzip.com/wzcline.htm)
Jeff
|-----Original Message-----
|From: Nicole Amashta [mailto:[EMAIL PROTECTED]]
|Sent: 12 April 2002 17:33
|To: [EMAIL PROTECTED]
|Subject: [PHP-WIN] PHP and ZIP
|
|I thought I had seen some functions for creating zip files with PHP. I
|can't
|find what I'm looking for to specifically create .zip files that are
|decompressable by, say, winZip.
|
|Anyone have experience creating .zip files with PHP? If so, could you
point
|me to the name of the function for doing this?
|
|I found ZLib, but this doesn't seem to do what I want.
|
|Much appreciated and TIA!
|
|--
|Nicole Amashta
|Web Application Development
|ABOL Software, Inc.
|[EMAIL PROTECTED]
|
|
|
|
|
|--
|PHP Windows Mailing List (http://www.php.net/)
|To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
