gacl/setup.php

   1 <?php
   2
   3 $config_file = dirname(__FILE__).'/gacl.ini.php';
   4
   5 require_once(dirname(__FILE__).'/admin/gacl_admin.inc.php');
   6 require_once(ADODB_DIR .'/adodb-xmlschema.inc.php');
   7
   8 $db_table_prefix = $gacl->_db_table_prefix;
   9 $db_type = $gacl->_db_type;
  10 $db_name = $gacl->_db_name;
  11 $db_host = $gacl->_db_host;
  12 $db_user = $gacl->_db_user;
  13 $db_password = $gacl->_db_password;
  14 $db_name = $gacl->_db_name;
  15
  16 $failed = 0;
  17
  18 echo '<b>Configuration:</b><br/>
  19 driver = <b>'.$db_type.'</b>,<br/>
  20 host = <b>'.$db_host.'</b>,<br/>
  21 user = <b>'.$db_user.'</b>,<br/>
  22 database = <b>'.$db_name.'</b>,<br/>
  23 table prefix = <b>'.$db_table_prefix.'</b>';
  24
  25 function echo_success($text) {
  26         echo '<font color="green"><b>Success!</b></font> '.$text."<br/>\n";
  27 }
  28
  29 function echo_failed($text) {
  30         global $failed;
  31         echo '<font color="red"><b>Failed!</b></font> '.$text."<br/>\n";
  32         $failed++;
  33 }
  34
  35 function echo_normal($text) {
  36         echo $text."<br/>\n";
  37 }
  38
  39 /*
  40  * Test database connection
  41  */
  42 echo 'Testing database connection...<br/>'."\n";
  43
  44 if (is_resource($db->_connectionID)) {
  45         echo_success('Connected to &quot;<b>'.$db_type.'</b>&quot; database on &quot;<b>'.$db_host.'</b>&quot;.');
  46 } else {
  47         echo_failed('<b>ERROR</b> connecting to database,<br/>
  48                         are you sure you specified the proper host, user name, password, and database in <b>admin/gacl_admin.inc.php</b>?<br/>
  49                         Did you create the database, and give read/write permissions to &quot;<b>'.$db_user.'</b>&quot; already?');
  50         exit;
  51 }
  52
  53 /*
  54  * Do database specific stuff.
  55  */
  56 echo 'Testing database type...<br/>'."\n";
  57
  58 switch ( $db_type ) {
  59         case ($db_type == "mysql" OR $db_type == "mysqlt" OR $db_type == "maxsql" ):
  60                 echo_success("Compatible database type \"<b>$db_type</b>\" detected!");
  61                 echo_normal("Making sure database \"<b>$db_name</b>\" exists...");
  62
  63                 $databases = $db->GetCol("show databases");
  64
  65                 if (in_array($db_name, $databases) ) {
  66                         echo_success("Good, database \"<b>$db_name</b>\" already exists!");
  67                 } else {
  68                         echo_normal("Database \"<b>$db_name</b>\" does not exist!");
  69                         echo_normal("Lets try to create it...");
  70
  71                         if (!$db->Execute("create database $db_name") ) {
  72                                 echo_failed("Database \"<b>$db_name</b>\" could not be created, please do so manually.");
  73                         } else {
  74                                 echo_success("Good, database \"<b>$db_name</b>\" has been created!!");
  75
  76                                 //Reconnect. Hrmm, this is kinda weird.
  77                                 $db->Connect($db_host, $db_user, $db_password, $db_name);
  78                         }
  79                 }
  80
  81                 break;
  82         case ( $db_type == "postgres8" OR $db_type == "postgres7" ):
  83                 echo_success("Compatible database type \"<b>$db_type</b>\" detected!");
  84
  85                 echo_normal("Making sure database \"<b>$db_name</b>\" exists...");
  86
  87                 $databases = $db->GetCol("select datname from pg_database");
  88
  89                 if (in_array($db_name, $databases) ) {
  90                         echo_success("Good, database \"<b>$db_name</b>\" already exists!");
  91                 } else {
  92                         echo_normal("Database \"<b>$db_name</b>\" does not exist!");
  93                         echo_normal("Lets try to create it...");
  94
  95                         if (!$db->Execute("create database $db_name") ) {
  96                                 echo_failed("Database \"<b>$db_name</b>\" could not be created, please do so manually.");
  97                         } else {
  98                                 echo_success("Good, database \"<b>$db_name</b>\" has been created!!");
  99
 100                                 //Reconnect. Hrmm, this is kinda weird.
 101                                 $db->Connect($db_host, $db_user, $db_password, $db_name);
 102                         }
 103                 }
 104
 105                 break;
 106
 107         case "oci8-po":
 108                 echo_success("Compatible database type \"<b>$db_type</b>\" detected!");
 109
 110                 echo_normal("Making sure database \"<b>$db_name</b>\" exists...");
 111
 112                 $databases = $db->GetCol("select '$db_name' from dual");
 113
 114                 if (in_array($db_name, $databases) ) {
 115                                 echo_success("Good, database \"<b>$db_name</b>\" already exists!");
 116                 } else {
 117                                 echo_normal("Database \"<b>$db_name</b>\" does not exist!");
 118                                 echo_normal("Lets try to create it...");
 119
 120                                 if (!$db->Execute("create database $db_name") ) {
 121                                                 echo_failed("Database \"<b>$db_name</b>\" could not be created, please do so manually.");
 122                                 } else {
 123                                                 echo_success("Good, database \"<b>$db_name</b>\" has been created!!");
 124
 125                                                 //Reconnect. Hrmm, this is kinda weird.
 126                                                 $db->Connect($db_host, $db_user, $db_password, $db_name);
 127                                 }
 128                 }
 129
 130                 break;
 131
 132         case "mssql":
 133                 echo_success("Compatible database type \"<b>$db_type</b>\" detected!");
 134
 135                 echo_normal("Making sure database \"<b>$db_name</b>\" exists...");
 136
 137                 $databases = $db->GetCol("select CATALOG_NAME from INFORMATION_SCHEMA.SCHEMATA");
 138
 139                 if (in_array($db_name, $databases) ) {
 140                                 echo_success("Good, database \"<b>$db_name</b>\" already exists!");
 141                 } else {
 142                                 echo_normal("Database \"<b>$db_name</b>\" does not exist!");
 143                                 echo_normal("Lets try to create it...");
 144
 145                                 if (!$db->Execute("create database $db_name") ) {
 146                                                 echo_failed("Database \"<b>$db_name</b>\" could not be created, please do so manually.");
 147                                 } else {
 148                                                 echo_success("Good, database \"<b>$db_name</b>\" has been created!!");
 149
 150                                                 //Reconnect. Hrmm, this is kinda weird.
 151                                                 $db->Connect($db_host, $db_user, $db_password, $db_name);
 152                                 }
 153                 }
 154
 155                 break;
 156
 157         default:
 158                 echo_normal("Sorry, <b>setup.php</b> currently does not fully support \"<b>$db_type</b>\" databases.
 159                                         <br>I'm assuming you've already created the database \"$db_name\", attempting to create tables.
 160                                         <br> Please email <b>$author_email</b> code to detect if a database is created or not so full support for \"<b>$db_type</b>\" can be added.");
 161 }
 162
 163
 164 /*
 165  * Attempt to create tables
 166  */
 167 // Create the schema object and build the query array.
 168 $schema = new adoSchema($db);
 169 $schema->SetPrefix($db_table_prefix, FALSE); //set $underscore == FALSE
 170
 171 // Build the SQL array
 172 $schema->ParseSchema(dirname(__FILE__).'/schema.xml');
 173
 174 // maybe display this if $gacl->debug is true?
 175 if ($gacl->_debug) {
 176         print "Here's the SQL to do the build:<br />\n<code>";
 177         print $schema->getSQL('html');
 178         print "</code>\n";
 179         // exit;
 180 }
 181
 182 // Execute the SQL on the database
 183 #ADODB's xmlschema is being lame, continue on error.
 184 $schema->ContinueOnError(TRUE);
 185 $result = $schema->ExecuteSchema();
 186
 187 if ($result != 2) {
 188   echo_failed('Failed creating tables. Please enable DEBUG mode (set it to TRUE in $gacl_options near top of admin/gacl_admin.inc.php) to see the error and try again. You will most likely need to delete any tables already created.');
 189 }
 190
 191 if ( $failed <= 0 ) {
 192         echo_success('
 193 First Step of Access Control Installation Successful!!!<br>');
 194 } else {
 195         echo_failed('Please fix the above errors and try again.<br><br>');
 196 }
 197 ?>