php-windows Digest 3 Mar 2004 20:58:20 -0000 Issue 2148
Topics (messages 23041 through 23051):
Re: Windows 2003 and SQL Server issues
23041 by: David Elliott
23044 by: Bowden, Zeb
Warning about your e-mail account.
23042 by: support.php.net
mcrypt broken in php 4.3.5RC3 on Win32
23043 by: Miha Nedok
Re: HMTL E-mails with images (again)
23045 by: Michael Horton
Re: Process Control Functions (PCNTL)
23046 by: BrokenClock
session problems
23047 by: carlos castillo
echo blob field that contains a PDF with interbase
23048 by: Sara Rubis
Re: start an external program (isqlw.exe)
23049 by: Frank M. Kromann
Re: Windows 2003 and SQL Server issues (SpamEnder: BLOCKED [EMAIL PROTECTED])
23050 by: Charles P. Killmer
SMTP ERROR
23051 by: carlos castillo
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 ---
Hi Charles
On 03 March 2004 at 19:19:22 -0600 (which was 01:19 where I live) Charles P.
Killmer wrote and made these points
> I am having trouble configuring PHP 4.3.4 on Windows Server 2003 to
> connect to SQL Server 2000 on a Windows 2003 Server across the LAN.
< ... >
> Has anyone run into issues with something like this? Thank you for any
> help on this.
I have no problems so I don't think I can help you with this but read on.
There use to be a problem with mssql.dll, sometimes if you did a query and
then do a headre location it would give you a CGI error.
AFAIK the mssql.dll has not changed since 6.5 server.
Use the OBDC connector if possible because you can use some complex queries
which barf up when using mssql.dll.
--
BBFN, _______________________________________________
David | David Elliott | Software Engineer |
_________________________| [EMAIL PROTECTED] | PGP Key ID 0x650F4534 |
| Keep looking for ancestors 'til you join them! |
--- End Message ---
--- Begin Message ---
Also are you using windows or mixed mode authentication?
On the sql box do you see any audit failures in the event logs
indicating a failed login attempt?
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 03, 2004 3:17 AM
To: '[EMAIL PROTECTED] '
Subject: RE: [PHP-WIN] Windows 2003 and SQL Server issues
Is the web server located at the same machine as MS SQL server?
Does it work with isql.exe (command line version) to connect to MS SQL
server?
-----Original Message-----
From: Charles P. Killmer
To: [EMAIL PROTECTED]
Sent: 2004-03-03 02:19
Subject: [PHP-WIN] Windows 2003 and SQL Server issues
I am having trouble configuring PHP 4.3.4 on Windows Server 2003 to
connect to SQL Server 2000 on a Windows 2003 Server across the LAN.
Now PHP is configured correctly because when I run the script from the
command line, ie c:\php\php.exe c:\site\file.php, I get the results from
the query.
Its a simple select count(*) from table query.
When I request the same file through a browser I get the error "PHP
Warning: mssql_connect(): Unable to connect to server: ServerName"
If I change the script to just echo phpinfo(); I get everything I would
expect. Extensions are in the right spot, mssql.dll is loaded...
This tells me that IIS 6.0 is configured to run the php.exe. The
command line test tells me that php is configured to connect to the
database. It seems to be that only when IIS tries to run the code to
connect to the database that I run into issues. Possibly an issue of
Windows 2003 being too secure in some area to allow the webuser to
connect to the database server. I have tried changing from the
predefined "Network
Has anyone run into issues with something like this? Thank you for any
help on this.
Charles Killmer
Netgain Technology
[EMAIL PROTECTED]
Office: (320) 251-4700 ext 107
--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Dear user of "Php.net" mailing system,
Your e-mail account has been temporary disabled because of unauthorized access.
Pay attention on attached file.
For security reasons attached file is password protected. The password is "05088".
Cheers,
The Php.net team http://www.php.net
--- End Message ---
--- Begin Message ---
Hi All !
I just installed 4.3.5RC3 and noticed that mcrypt is broken. It's a vital
component of our php apps.
Can anyone confirm this before submitting a bugreport ?
-Mike
--- End Message ---
--- Begin Message ---
> In your HTML file if there is the img tag which refers to the image file
test.jpg then u have to mention that like this
> <img src=http://www.sitename.com/image/test.jpg> where image(if there is
any such directory) is the directory where the test.jpg is stored.
> Do tell me if this works
>
> Bye
>
> ....SuDeEp.....
>
Thanks, that worked like a charm- the problem I had was I was using relative
links rather than absolute ones.
Michael
---------------------------------------------------------
I'm sorry, did my Karma run over your Dogma?
--- End Message ---
--- Begin Message ---
Thanks again, but this solution seems to be a dead end for me. It seems
impossible to use PHP-GTK in this environnement, except if you make it your
self, with a XWindows server running in cygwin... a bit heavy, and not very
confortable... I would like to use PHP with GTK for Windows and with PCNTL.
Any suggestions are welcome.
Stephane
> -----Message d'origine-----
> De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Envoyé : lundi 1 mars 2004 13:39
> À : [EMAIL PROTECTED]
> Objet : [PHP-WIN] Re: Process Control Functions (PCNTL)
>
>
> Brokenclock wrote on 1/03/04 12:55:
> > Hello list,
> >
> > Could anyone tell me if the Process Control Functions (PCNTL :
> > http://www.php.net/manual/en/ref.pcntl.php) will be available
> or something
> > like those, one day or another, for PHP for Windows?
> >
> > Thanks and regards,
> >
> > BrokenClock
>
>
> Hi,
> Haven't used this myself, but according to that page in the manual's
> user notes (luca dot mariano at email dot it 12-Nov-2003 06:49) there
> does exist a PHP-CLI (version 4.3.3) for Win32 with experimental support
> built-in for:
> - pcntl
> - posix
> - sysvmsg
> - sysvsem
> - sysvshm
>
> http://phplet.sf.net/modules.php?name=Web_Links&l_op=visit&lid=4
>
> Bibiep - sf
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Hi, i have the followin problem, i have a site that use sessions,
sometimes when i want to write on the session i get the followin error:
Warning: Unknown(): The session id contains invalid characters, valid
characters are only a-z, A-Z and 0-9 in Unknown on line 0
Warning: Unknown(): Failed to write session data (files). Please verify
that the current setting of session.save_path is correct (D:\PHP\tmp) in
Unknown on line 0
I see the folder D:\PHP\tmp and there is the session file, so i dont
know whats the problem, also the script works ok, the problem is that at
the end of the html show the warnings.
Any clue?, thanks.
Carlos A. Castillo.
Ingeniero de desarrollo
[EMAIL PROTECTED]
____________________________________
Su Aliado Efectivo en Internet
www.imagine.com.co
(57 1)2182064 - (57 1)6163218
Bogotá - Colombia
____________________________________
- Soluciones web para Internet e Intranet
- Soluciones para redes
- Licenciamiento de Software
- Asesoría y Soporte Técnico
____________________________________
--- End Message ---
--- Begin Message ---
Hi,
I'm trying to show with browser a blob field.
If the blob field contains a txt or bmp or jpeg, I can easily show it with
the command ibase_blob_echo, else if it contains a PDF, in the browser I see
the binary text of pdf, instead of the pdf format.
I'm working with IIS, Win2000 Professional.
Thanks
--- End Message ---
--- Begin Message ---
The answer is no (unless the client and server is running on the same
bos).
PHP is a server side scripting language and the only information send to
the client is through the HTTP protocol. Cold you imaginne what would
happen if a web server could start programs on the client maschine?
- Frank
> Got this to work, but my problem now is that this will only open windows
on the machine hosting the WebServer, is there a way to open an
application on the client side?
>
> also had to make some changes to IIS. Logon Tab, check the box where it
says "allow service to interact with desktop"
>
> my code goes here
> -----------------------------------------------
> $ip = $_SERVER['QUERY_STRING'];
>
> $program = "start \"Query Analyzer\" /D\"c:\\Program Files\\Microsoft
SQL Server\\80\\Tools\\binn\" /NORMAL isqlw.exe -S$ip -Umyuserid
-Pmypassword";
> $aOutput = array();
> $retval = 0;
> echo "<br>program = $program";
>
> exec($program, $aOutput, $retval);
> foreach($aOutput as $val )
> {
> echo "<br>value = $val";
> }
> echo "<br>Dumping retval = $retval";
>
> -------------------------------------------------
>
>
> --
> Gerardo S. Rojas
> mailto: [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Gerardo Rojas [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 02, 2004 11:36 AM
> To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] start an external program (isqlw.exe)
>
>
> No, the "isqlw.exe" is the full SQL Query Analyzer tool. I have the
full path and executable name. I just don't know how to call it (exactly)
from within PHP.
>
>
> --
> Gerardo S. Rojas
> mailto: [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 02, 2004 11:31 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] start an external program (isqlw.exe)
>
>
> For system(), etc , you need executable right for the default command
> shell, and you might like to do "start isql.exe ..." besides, you might
> also need to include the full path(??).
>
> There are some other function calls that also might be better suited to
> fork with... but let me have a check tomorrow (time to leave work)
>
> Anyhow, isqlw.exe, isn't that the plain windows version of isql.exe,
> i.e. /not/ the analyzer but the simplified version of it?
>
> On Tue, 2004-03-02 at 18:25, Gerardo Rojas wrote:
> > the executable is "isqlw.exe" the arguments are -S server -U userid -P
password.
> >
> >
> > --
> > Gerardo S. Rojas
> > mailto: [EMAIL PROTECTED]
> >
> >
> > -----Original Message-----
> > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, March 02, 2004 11:23 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: [PHP-WIN] start an external program (isqlw.exe)
> >
> >
> > Aha, that makes sense! :)
> >
> > Very well, anyway.. .from time to time I tried to locate the
executable
> > for this, but failed (could not identify it in "$MSSQL_HOME\binn". I
> > also been way to lazy with this (no urgent need as to say). Maybe to
> > check the properties of start menu item will help(?), but am not so
sure
> > about that...
> >
> > In any case, if you find out, would you please save me some time as
well
> > and let me know?
> >
> > On Tue, 2004-03-02 at 18:17, Gerardo Rojas wrote:
> > > I have many different SQL Servers that i connect to. This way with
PHP (webserver) i can generate a list and quickly pick the one I want and
connect to it (also passing the userid and password, this seems like a
faster way to do it)
> > >
> > >
> > > --
> > > Gerardo S. Rojas
> > > mailto: [EMAIL PROTECTED]
> > >
> > >
> > > -----Original Message-----
> > > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, March 02, 2004 11:14 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: [PHP-WIN] start an external program (isqlw.exe)
> > >
> > >
> > > Why the do you want to do this with php????
> > >
> > >
> > > On Tue, 2004-03-02 at 17:29, Gerardo Rojas wrote:
> > > > Is there a quick way to start the "Query Analyzer" from within
PHP?
> > > > I've tried exec() and system() with no success.
> > > >
> > > >
> > > > --
> > > > Gerardo S. Rojas
> > > > mailto: [EMAIL PROTECTED]
> > > >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
What if I had installed SpamEnder which would have asked you for the
same confirmation? We would never have received each others emails.
Additionally people do not sign up for these forums to fill out these
rediculous attempts to block spam. This should not be something I have
to do to allow you to view my commments and advice on PHP.
Charles
-----Original Message-----
From: Alan Hale [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 03, 2004 1:31 PM
To: Charles P. Killmer
Subject: Re: [PHP-WIN] Windows 2003 and SQL Server issues (SpamEnder:
BLOCKED [EMAIL PROTECTED])
In an effort to eliminate unsolicited e-mail, I have installed
SpamEnder.
Please REPLY to this e-mail, without modifying the subject line, so that
I can receive your original message. Upon my approval, future e-mails
you send to me will be released automatically. If you do not REPLY to
this e-mail, SpamEnder will block all future e-mails from this address
and will not give you another opportunity to reply.
Copyright 2003, Evolvian, Inc. (http://www.evolvian.com/)
----------------------------------------------------------
Excerpt from original message:
I am having trouble configuring PHP 4.3.4 on Windows Server 2003 to
connect to SQL Server 2000 on a Windows 2003 Server across the LAN.
Now PHP is configured correctly because when I run the script from the
command line, ie c:\php\php.exe c:\site\file.php, I get the results from
the query.
Its a simple select count(*) from table query.
When I request the same file through a browser I get the error "PHP
Warning: mssql_connect(): Unable to connect to server: ServerName"
If I change the script to just echo phpinfo(); I get everything I would
expect. Extensions are in the right spot, mssql.dll is loaded...
This tells me that IIS 6.0 is configured to run the php.exe. The
command line test tells me that php is configured to connect to the
database. It seems to be that only when IIS tries to run the code to
connect to the database that I run into issues. Possibly an issue of
Windows 2003 being too secure in some area to allow the webuser to
connect to the database server. I have tried changing from the
predefined "Network
Has anyone run into issues with something like this? Thank you for any
help on this.
Charles Killmer
Netgain Technology
[EMAIL PROTECTED]
Office: (320) 251-4700 ext 107
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.601 / Virus Database: 382 - Release Date: 29/02/2004
--- End Message ---
--- Begin Message ---
When i try to send a mail i receive the followin error
Warning: mail() [function.mail]: SMTP server response: 503 Comando o
secuencia de comandos inesperados in
E:\wwwroot\helpdesk_imagine\classes\helpdesk.class.php on line 1054
But the mail is sent, it occurs sometimes not always.
Thanks,
Carlos A. Castillo.
Ingeniero de desarrollo
[EMAIL PROTECTED]
____________________________________
Su Aliado Efectivo en Internet
www.imagine.com.co
(57 1)2182064 - (57 1)6163218
Bogotá - Colombia
____________________________________
- Soluciones web para Internet e Intranet
- Soluciones para redes
- Licenciamiento de Software
- Asesoría y Soporte Técnico
____________________________________
--- End Message ---