[PHP-DB] test for first mail please ignore
test for first mail please ignore
Re: [PHP-DB] Test connection to database
Jack van Zanen wrote: Databases are located in several datacentres throughout the area/country and we connect through dedicated lines not internet. I realize that there may be many factors to consider, I just would like to have the PHP experts have a look at my method/PHP code to check that this is fairly optimized Looks ok. You can also use something like nagios or monit (or others) to do all of this for you.. and they also monitor other services (eg http, ftp, also disk-space, load etc etc). Another avenue to check out anyway :) -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Test connection to database
Hi
I have written a little program that cycles through a list of databases and
checks conectivity. it writes the status of this to a table
now to check all 143 databases it takes about 50 seconds and I was wondering
if this sounds about right to you guys.
?php
//Include the required libraries and variables
include_once (adodb5/adodb.inc.php);
include_once (ola_ini.php);
//Setup the connection to the database to be updated
$db = NewADOConnection('oci8');
$db-Connect(false, $ola_usr, $ola_pwd, $ola_dbs);
//Get the current status of the database (UP, DOWN or CHECKING)
$stmt = $db-Prepare(select nvl(status,'NEW') from sla_monitoring where
upper(database)=upper(:dbs));
$rs=$db-Execute($stmt, array('dbs' = $argv[1]));
//Logon check for ORACLE (OCI)
if($argv[2]=='Oracle')
{
if($rs-fields[0] == 'CHECKING') //If current status is CHECKING than the
previous check has not completed. Find out why!!!
{
echo exiting;
exit;
}
else
{
$stmt = $db-Prepare(update sla_monitoring set status=:status,
last_check=to_date(:checkdate,'ddmmhh24miss') where
upper(database)=upper(:dbs));
$rs=$db-Execute($stmt, array('dbs' =
$argv[1],'status'='CHECKING','checkdate'=$argv[3])); //set status to
CHECKING for current database before proceding
if($db-Connect(false, $ora_usr, $ora_pwd,$argv[1] ))
{
$db-Execute($stmt, array('dbs' = $argv[1],'status'='UP'));
}
else
{
$rs=$db-Execute($stmt, array('dbs' = $argv[1],'status'='DOWN'));
}
}
}
?
this script gets called from a windows batch file to try and mimic a bit of
multithreading
snip
startphp-win check_connect.php B2B Oracle 27082008145929 eamdasoplp01
startphp-win check_connect.php B2B Oracle 27082008145929 opal
startphp-win check_connect.php BOCMSDEV Oracle 27082008145929
eawalsbop02
startphp-win check_connect.php BOCMSDR Oracle 27082008145929 eawalsbop02
startphp-win check_connect.php BOCMSP Oracle 27082008145929 eahobsorap01
.
/snip
Is this the best way to do this or are there any other ways that may lead to
better performance.
I realize I will have some contention on my table that can maybe be
addressed, but for now let's focus on the PHP/BAT process
Thanks
Jack
Re: [PHP-DB] Test connection to database
Jack van Zanen wrote: Hi I have written a little program that cycles through a list of databases and checks conectivity. it writes the status of this to a table now to check all 143 databases it takes about 50 seconds and I was wondering if this sounds about right to you guys. Across your network I assume. All internal or some db's are external? Don't forget about network overhead, and even more so if you're going out to the internet at some point. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Test connection to database
Databases are located in several datacentres throughout the area/country and we connect through dedicated lines not internet. I realize that there may be many factors to consider, I just would like to have the PHP experts have a look at my method/PHP code to check that this is fairly optimized Jack On 27/08/2008, Chris [EMAIL PROTECTED] wrote: Jack van Zanen wrote: Hi I have written a little program that cycles through a list of databases and checks conectivity. it writes the status of this to a table now to check all 143 databases it takes about 50 seconds and I was wondering if this sounds about right to you guys. Across your network I assume. All internal or some db's are external? Don't forget about network overhead, and even more so if you're going out to the internet at some point. -- Postgresql php tutorials http://www.designmagick.com/ -- J.A. van Zanen
[PHP-DB] Test
Hi Sorry for sending this test message but I haven't received a response from the list daemon. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
new user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
new user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
new user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Test
New user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] test
Paul Anderson wrote: new user test please don't do tests to a public list, its spam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
new comer from China test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
The original message was included as attachment -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Test
Sorry to use this, but I don't know if my messages are arriving... Can someone (only 1 please) reply that my message was received? Jos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Test
recieved On Mon, 21 Mar 2005 12:50:46 +0100, Juffermans, Jos [EMAIL PROTECTED] wrote: Sorry to use this, but I don't know if my messages are arriving... Can someone (only 1 please) reply that my message was received? Jos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test ... ignore me
test :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Test
test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
I m new here (k)
[PHP-DB] test post
please delete this -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] test
Florian -- ...and then Florian Habegger said... % % test Please don't post tests here. We got this and your THREE copies of your oci8 question (for which I can only wish you good luck). HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgp0.pgp Description: PGP signature
Re: [PHP-DB] test
Please do NOT open attachments files without having an Antivirus installed. Like this guys did. Sending emails with attachments to a list is not a common behaviour. Thanks - Original Message - From: David T-G [EMAIL PROTECTED] To: PHP DB list [EMAIL PROTECTED] Cc: Florian Habegger [EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 16:25 Subject: Re: [PHP-DB] test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Test
Please disregard. :) :) Gale L. Allen Jr Macintosh Support Specialist Phone: 919/412-5039 Homepage: http://homepage.mac.com/ateam3/Menu5.html iChat = [EMAIL PROTECTED] Remember, It's only Rock 'n Roll, but I like it! (:
[PHP-DB] test - Please ignore
Please ignore, this is a test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test, please delete
test, please delete -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
login test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Test
Sorry about the test, but . . .
Re: [PHP-DB] test
Test successful. Congratulations. Ignatius You can't trust the Russians. They have no word for 'détente'. - Original Message - From: Art Chevalier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 8:38 PM Subject: [PHP-DB] test test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test
test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test, pls del
test -- PHP Database 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]
[PHP-DB] test
hello? -- PHP Database 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]
[PHP-DB] test
At 10:30 PM 8/30/2001 +, you wrote: Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] Acknowledgment: I have added the address [EMAIL PROTECTED] to the php-db mailing list. Welcome to [EMAIL PROTECTED]! Please save this message so that you know the address you are subscribed under, in case you later want to unsubscribe or change your subscription address. --- Administrative commands for the php-db list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: For help and a description of available commands, send a message to: [EMAIL PROTECTED] To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, just send a message to the address in the ``List-Unsubscribe'' header of any list message. If you haven't changed addresses since subscribing, you can also send a message to: [EMAIL PROTECTED] or for the digest to: [EMAIL PROTECTED] For addition or removal of addresses, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete the transaction. If you need to get in touch with the human owner of this list, please send a message to: [EMAIL PROTECTED] Please include a FORWARDED list message with ALL HEADERS intact to make it easier to help you. --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 31660 invoked from network); 30 Aug 2001 22:30:40 - Received: from unknown (HELO mephisto.ktf.rtu.lv) (213.175.91.1) by pb1.pair.com with SMTP; 30 Aug 2001 22:30:40 - Received: from zikurats.ktf.rtu.lv (dial57.as52.bkc.lv [195.244.129.121]) by mephisto.ktf.rtu.lv (8.11.2/8.11.2) with ESMTP id f7ULSLE02688 for [EMAIL PROTECTED]; Fri, 31 Aug 2001 00:28:23 +0300 Message-Id: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Fri, 31 Aug 2001 00:28:27 +0300 To: [EMAIL PROTECTED] From: Jancs [EMAIL PROTECTED] Subject: Re: confirm subscribe to [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed -- PHP Database 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]
