php-windows Digest 17 Sep 2002 07:26:29 -0000 Issue 1343
Topics (messages 15850 through 15854):
Re: Exec () works for me in Apache, but not in IIS, Do I need execute
15850 by: Kurtis Harper
15851 by: Rich Gray
15853 by: Tracker1
Re: MSSQL Date Format Problem
15852 by: Calum Scott
REGISTER_SHUTDOWN_FUNCTION() BUG -- Please Fix.
15854 by: Jason Caldwell
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 ---
Tracker1,
Thanks but how do I add the IUSER_MACHINENAME and change the permissions, In
webserver properties in IIS, the securty has IUSER_MACHINENAME but I do not
see where I give the permissions to the file. Where do I assign these
permissions.
BTW I am running XP pro
Thanks again for any help you can give me.
"Tracker1" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> add IUSER_MACHINENAME and give it execute permissions on the exe..
> beyond this make sure that IUSER_MACHINENAME has modify/write access
> to the directory in question.
>
> Kurtis Harper wrote:
> > Hi,
> >
> > I have the exec command working perfectly under Apache, But when I try
> > running the same code under IIS it will not work. This command is
working
> > under apache:
> >
> > exec('convert -resize 100x100
> > c:\apache2\apache2\htdocs\uploads\\'.$user.'\\'.$uploadreal3.'
> > c:\apache2\apache2\htdocs\uploads\\'.$user.'\\'.$uploadthumb3);
> >
> > Hi,
> >
> > I guess my questions are, In IIS do I have to give execute permissions
to
> > the "convert.exe" in order for it to function. If so how do I go about
> > doing this.
> >
> > Thanks again for everyones help :) I am almost there
> >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.386 / Virus Database: 218 - Release Date: 9/9/2002
>
> --
> -----------------------------------------------------------------------
> Michael J. Ryan | ICQ: 4935386
> tracker1(at)theroughnecks(dot)net | AIM/AOL: azTracker1
> Roughneck BBS: | Yahoo: azTracker1
> http://www.theroughnecks.net | MSN: (email address)
> telnet://theroughnecks.net | Trillian: www.trillian.cc
> --- Synchronet 3.10j-Win32 NewsLink 1.30
> * Roughneck BBS - www.theroughnecks.net - telnet://theroughnecks.net
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.386 / Virus Database: 218 - Release Date: 9/9/2002
--- End Message ---
--- Begin Message ---
Use explorer - right click on the file/folder and select the security tab...
make sure Everyone or at least the IUSR_<MACHINENAME> has execute permission
on the .exe and write permissions for the folder.
-----Original Message-----
From: Kurtis Harper [mailto:[EMAIL PROTECTED]]
Sent: 16 September 2002 12:04
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Re: Exec () works for me in Apache, but not in IIS,
Do I need execute
Tracker1,
Thanks but how do I add the IUSER_MACHINENAME and change the permissions, In
webserver properties in IIS, the securty has IUSER_MACHINENAME but I do not
see where I give the permissions to the file. Where do I assign these
permissions.
BTW I am running XP pro
Thanks again for any help you can give me.
"Tracker1" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> add IUSER_MACHINENAME and give it execute permissions on the exe..
> beyond this make sure that IUSER_MACHINENAME has modify/write access
> to the directory in question.
>
> Kurtis Harper wrote:
> > Hi,
> >
> > I have the exec command working perfectly under Apache, But when I try
> > running the same code under IIS it will not work. This command is
working
> > under apache:
> >
> > exec('convert -resize 100x100
> > c:\apache2\apache2\htdocs\uploads\\'.$user.'\\'.$uploadreal3.'
> > c:\apache2\apache2\htdocs\uploads\\'.$user.'\\'.$uploadthumb3);
> >
> > Hi,
> >
> > I guess my questions are, In IIS do I have to give execute permissions
to
> > the "convert.exe" in order for it to function. If so how do I go about
> > doing this.
> >
> > Thanks again for everyones help :) I am almost there
> >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.386 / Virus Database: 218 - Release Date: 9/9/2002
>
> --
> -----------------------------------------------------------------------
> Michael J. Ryan | ICQ: 4935386
> tracker1(at)theroughnecks(dot)net | AIM/AOL: azTracker1
> Roughneck BBS: | Yahoo: azTracker1
> http://www.theroughnecks.net | MSN: (email address)
> telnet://theroughnecks.net | Trillian: www.trillian.cc
> --- Synchronet 3.10j-Win32 NewsLink 1.30
> * Roughneck BBS - www.theroughnecks.net - telnet://theroughnecks.net
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.386 / Virus Database: 218 - Release Date: 9/9/2002
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Kurtis Harper wrote:
> Thanks but how do I add the IUSER_MACHINENAME and change the permissions, In
> webserver properties in IIS, the securty has IUSER_MACHINENAME but I do not
> see where I give the permissions to the file. Where do I assign these
> permissions.
>
> BTW I am running XP pro
>
> Thanks again for any help you can give me.
right click on the file, properties..security tab.. and add
IUSER_MACHINENAME.. if it isn't there, check the allow box for execute.
fyi, MACHINENAME is the name of the machine that iis is running on..
--
-----------------------------------------------------------------------
Michael J. Ryan | ICQ: 4935386
tracker1(at)theroughnecks(dot)net | AIM/AOL: azTracker1
Roughneck BBS: | Yahoo: azTracker1
http://www.theroughnecks.net | MSN: (email address)
telnet://theroughnecks.net | Trillian: www.trillian.cc
--- Synchronet 3.10j-Win32 NewsLink 1.30
* Roughneck BBS - www.theroughnecks.net - telnet://theroughnecks.net
--- End Message ---
--- Begin Message ---
Thanks to all who replied.
I found the answer to this one on the microsoft support site.
The problem lies in the way that IIS running on Windows 2000 Advanced Server
handles regional settings.
The full text can be found here...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306044
...I know it says its about ASP but the principle is the same. If anyone is
implementing this make sure that you use option 2 for the registry keys and
make sure you read all of the text where it explains about what option 2
means! I didn't and ended up going round in circles for hours!!!
Cheers
Calum
-----Original Message-----
From: David Hollister [mailto:[EMAIL PROTECTED]]
Sent: 16 September 2002 19:15
To: 'Calum Scott'; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] MSSQL Date Format Problem
Questions I have are:
1) Which date datatype is the date field? Custom or datetime?
2) What format is returned when you select the date column in query analyzer
from each machine (assuming query analyzer is diff version on each client)?
3) When you say "regional options" do you mean you have already checked the
TIME display tab in control panel \ regional options ?
4) Are you setting any connection options after you make the db session?
Otherwise, just utilize PHP to format the return to a common format.
Throwing in a couple lines to format shouldn't take very long; it's not the
same as recoding. And double check MS's site for SQL version differences
and session options in relation to datetime. SQL 7 doesn't have too much in
the way of formatting the date per session, but 2000 might.
-----Original Message-----
From: Calum Scott [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 14, 2002 9:17 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] MSSQL Date Format Problem
Hi,
I have a small problem with the formats of dates on two separate machines
running the same code!
Machine One
-----------
Windows 2000 Pro
IIS 5
PHP 4.1.2
MS SQL Server 7
Machine Two
-----------
Windows 2000 Advanced Server
IIS 5
PHP 4.1.2
MS SQL Server 2000
Code
----
<?
$cn = mssql_connect("SRVName","User","Password");
mssql_select_db("DBName");
$sqlq = "select DateField from Table";
$rs = mssql_query($sqlq);
$row = mssql_fetch_row($rs);
echo $row[0];
?>
Results Machine One
-------------------
14 Sep 2002 0:00
Results Machine Two
-------------------
Sep 14 2002 12:00AM
I have tried setting all the "Regional Settings" locales and languages to
British English on both machines but it seems like I've missed one on
Machine Two!
Incidentally, inserting a value into the databases on both machines works
presenting the date as "14/9/2002", it is just when returning a recordset to
PHP via the select statement that the difference occurs.
I'm at a total loss! It must be something to do with PHP, IIS or SQL Server
but I can't find what, if anyone has any ideas I'd be most grateful, however
recoding is not an option as the system is pretty big!
TIA
CAS
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
I'm posting this here to give this BUG attention. It's a pretty serious one
for Win32 users, and it would be great if it could be fixed *very
quickly* -- I posted this in the Bug Reports on PHP.net on May 27th, 2002.
Here's the link: http://bugs.php.net/bug.php?id=17461
I need to use this function to perform certain *required* tasks on a
Timeout -- however (and please read the Bug Report, before replying) the
Timeout functionality of this function DOES NOT work on Win32 builds.
If your a C/C++ / PHP contributor and have a moment to look into this -- it
would be great -- I would love to see this fixed in release 4.2.4 !!!
Thanks
Jason
--- End Message ---
