php_library/fboprime/dbconncheck.php

#!/usr/bin/php -q
<?php
//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/standalone/dbconncheck.php,v 1.3 2006/04/02 00:50:34 dashley Exp $
//--------------------------------------------------------------------------------
//dbconncheck.php--Checks Database Connectivity To The FBO-Prime Database
//Copyright (C) 2006  David T. Ashley
//
//This program is free software; you can redistribute it and/or
//modify it under the terms of the GNU General Public License
//as published by the Free Software Foundation; either version 2
//of the License, or (at your option) any later version.
//
//This program is distributed in the hope that it will be useful,
//but WITHOUT ANY WARRANTY; without even the implied warranty of
//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//GNU General Public License for more details.
//
//You should have received a copy of the GNU General Public License
//along with this program; if not, write to the Free Software
//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
//--------------------------------------------------------------------------------
//Set the include file path.  This is necessary to get to the configuration
//information, including how to try to connect to the database.
set_include_path("/var/www/php_library/fboprime");
//
//Include the configuration information.
require_once("config.inc");
//
//--------------------------------------------------------------------------------
//Returns a version control string.  Used for randomness.
//
function vc_info()
   {
   return("\$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/standalone/dbconncheck.php,v 1.3 2006/04/02 00:50:34 dashley Exp $");
   }
//--------------------------------------------------------------------------------
//--------------------------------------------------------------------------------
//--------------------------------------------------------------------------------
//------  M A I N    S C R I P T  ------------------------------------------------
//--------------------------------------------------------------------------------
//--------------------------------------------------------------------------------
//--------------------------------------------------------------------------------
//
if ($argc == 1)
   {
   //The no-parameters case, as expected.

   $handle = mysql_connect(CONFIG_MYSQL_SERVER, CONFIG_MYSQL_USERNAME, CONFIG_MYSQL_PASSWORD);
   $handle_copy = $handle;
   if ($handle === FALSE)
      {
      echo "ERROR:  Unable to connect and/or authenticate to MySQL database.\n";
      exit(1);
      }

   $result = mysql_select_db(CONFIG_MYSQL_DATABASE, $handle);
   if ($result === FALSE)
      {
      echo "ERROR:  Unable to select MySQL database \"" . CONFIG_MYSQL_DATABASE . "\".\n";
      exit(1);
      }

   $result = mysql_close($handle);
   if ($result === FALSE)
      {
      echo "ERROR:  Unable to close MySQL connection.\n";
      exit(1);
      }
   
   //If we've made it this far, things are OK.
   echo "Success (";
   echo vc_info();
   echo ")\n";
   echo "Server          :  " . CONFIG_MYSQL_SERVER    . "\n";
   echo "Username        :  " . CONFIG_MYSQL_USERNAME  . "\n";
   echo "Password        :  " . CONFIG_MYSQL_PASSWORD  . "\n";
   echo "Database        :  " . CONFIG_MYSQL_DATABASE  . "\n";
   echo "Handle returned :  " . $handle_copy           . "\n";

   exit(0);
   }
else
   {
   echo "ERROR:  This command accepts no command-line parameters.\n";
   exit(1);
   }

//If we're here, success.  Per the standard Unix way of thinking
//say nothing.  Silence means OK.
exit(0);
//
//--------------------------------------------------------------------------------
//End of $RCSfile: dbconncheck.php,v $.
//--------------------------------------------------------------------------------
?>
1	#!/usr/bin/php -q
2	<?php
3	//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/standalone/dbconncheck.php,v 1.3 2006/04/02 00:50:34 dashley Exp $
4	//--------------------------------------------------------------------------------
5	//dbconncheck.php--Checks Database Connectivity To The FBO-Prime Database
6	//Copyright (C) 2006 David T. Ashley
7	//
8	//This program is free software; you can redistribute it and/or
9	//modify it under the terms of the GNU General Public License
10	//as published by the Free Software Foundation; either version 2
11	//of the License, or (at your option) any later version.
12	//
13	//This program is distributed in the hope that it will be useful,
14	//but WITHOUT ANY WARRANTY; without even the implied warranty of
15	//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16	//GNU General Public License for more details.
17	//
18	//You should have received a copy of the GNU General Public License
19	//along with this program; if not, write to the Free Software
20	//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
21	//--------------------------------------------------------------------------------
22	//Set the include file path. This is necessary to get to the configuration
23	//information, including how to try to connect to the database.
24	set_include_path("/var/www/php_library/fboprime");
25	//
26	//Include the configuration information.
27	require_once("config.inc");
28	//
29	//--------------------------------------------------------------------------------
30	//Returns a version control string. Used for randomness.
31	//
32	function vc_info()
33	{
34	return("\$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/standalone/dbconncheck.php,v 1.3 2006/04/02 00:50:34 dashley Exp $");
35	}
36	//--------------------------------------------------------------------------------
37	//--------------------------------------------------------------------------------
38	//--------------------------------------------------------------------------------
39	//------ M A I N S C R I P T ------------------------------------------------
40	//--------------------------------------------------------------------------------
41	//--------------------------------------------------------------------------------
42	//--------------------------------------------------------------------------------
43	//
44	if ($argc == 1)
45	{
46	//The no-parameters case, as expected.
47
48	$handle = mysql_connect(CONFIG_MYSQL_SERVER, CONFIG_MYSQL_USERNAME, CONFIG_MYSQL_PASSWORD);
49	$handle_copy = $handle;
50	if ($handle === FALSE)
51	{
52	echo "ERROR: Unable to connect and/or authenticate to MySQL database.\n";
53	exit(1);
54	}
55
56	$result = mysql_select_db(CONFIG_MYSQL_DATABASE, $handle);
57	if ($result === FALSE)
58	{
59	echo "ERROR: Unable to select MySQL database \"" . CONFIG_MYSQL_DATABASE . "\".\n";
60	exit(1);
61	}
62
63	$result = mysql_close($handle);
64	if ($result === FALSE)
65	{
66	echo "ERROR: Unable to close MySQL connection.\n";
67	exit(1);
68	}
69
70	//If we've made it this far, things are OK.
71	echo "Success (";
72	echo vc_info();
73	echo ")\n";
74	echo "Server : " . CONFIG_MYSQL_SERVER . "\n";
75	echo "Username : " . CONFIG_MYSQL_USERNAME . "\n";
76	echo "Password : " . CONFIG_MYSQL_PASSWORD . "\n";
77	echo "Database : " . CONFIG_MYSQL_DATABASE . "\n";
78	echo "Handle returned : " . $handle_copy . "\n";
79
80	exit(0);
81	}
82	else
83	{
84	echo "ERROR: This command accepts no command-line parameters.\n";
85	exit(1);
86	}
87
88	//If we're here, success. Per the standard Unix way of thinking
89	//say nothing. Silence means OK.
90	exit(0);
91	//
92	//--------------------------------------------------------------------------------
93	//End of $RCSfile: dbconncheck.php,v $.
94	//--------------------------------------------------------------------------------
95	?>