May 21, 2003 at 9:54 am
Further to previous e-mails is anyone aware whether the following would work.
Am looking to receive SNMP messages from a firewall which will be used as parameters to launch a SQL stored Procedure to update an Authentication Table. My plan is to use something like command line PHP to run as a service to execute the query.
My questions are (a) Could this Work and if so (b) is there anyway that I could keep a connection to SQL open using PHP as a service. or (c) Am I talking nonsense
All help again gratefully rec'd
May 21, 2003 at 10:11 am
First, did you mean SMTP (Simple Mail Transport Protocol) or SNMP (Simple Network Management Protocol).
If SMTP:
Yes, there's a way, but it involves having a SQL Server Agent job reading email via SQLMail. Therefore, you'd have to have SQLMail configured and you'd have to well-define what you want to process and how you determine what's being sent is legitimate to be processed.
If SNMP:
SQL Server doesn't communicate via SNMP. You would have to have some application set up as an SNMP trap receive the SNMP message. That application would then have to fire off a script or some other method to connect to SQL Server and execute the stored procedure.
With respect to PHP:
PHP is like most script engines (such as ASP), in that it parses the page and is done... I'm not aware of PHP staying up longer than it takes to complete its "assigned duties" but then again, I'm not a PHP expert. One could do this with Win32 Perl running as a service, though.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply