|
0 ) {
echo $check['msg'];
close_html_and_exit();
}
?>
TestLink setup will now attempt to setup the database: Creating connection to Database Server:"; // -------------------------------------------------------------------------- // Connect to DB Server without choosing an specific database switch($db_type) { case 'mssql': $dbDriverName = 'mssqlnative'; break; default: $dbDriverName = $db_type; break; } $db = new database($dbDriverName); define('NO_DSN',FALSE); @$conn_result = $db->connect(NO_DSN,$db_server, $db_admin_name, $db_admin_pass); if( $conn_result['status'] == 0 ) { echo 'Failed!Please check the database login details and try again.'; echo ' Database Error Message: ' . $db->error_msg() . " "; echo ' $db_server:' . $db_server . ' '; echo ' $db_admin_name:' . $db_admin_name . ' '; echo ' $db_admin_pass:' . $db_admin_pass . ' '; close_html_and_exit(); } else { echo "OK!"; } $db->close(); $db=null; // ------------------------------------------------------------------------- // Connect to the Database (if Succesful -> database exists) $db = new database($dbDriverName); @$conn_result = $db->connect(NO_DSN,$db_server, $db_admin_name, $db_admin_pass,$db_name); if( $conn_result['status'] == 0 ) { $db->close(); echo " Database $db_name does not exist. "; if( $upgrade ) { echo "Can't Upgrade"; close_html_and_exit(); $errors += 1; } else { echo "Will attempt to create:"; $create = true; } } else { echo " Connecting to database `" . $db_name . "`:"; echo "OK!"; } // ------------------- // ------------------- if($create) { // check database name for invalid characters (now only for MySQL) $db->close(); $db = null; $db = New database($dbDriverName); $conn_result=$db->connect(NO_DSN,$db_server, $db_admin_name, $db_admin_pass); echo " Creating database `" . $db_name . "`:"; // from MySQL Manual // 9.2. Database, Table, Index, Column, and Alias Names // // Identifier : Database // Maximum Length (bytes): 64 // Allowed Characters : Any character that is allowed in a directory name, except '/', '\', or '.' // // An identifier may be quoted or unquoted. // If an identifier is a reserved word or contains special characters, you must quote it whenever you refer to it. // For a list of reserved words, see Section 9.6, �Treatment of Reserved Words in MySQL�. // Special characters are those outside the set of alphanumeric characters from the current character set, // '_', and '$'. // The identifier quote character is the backtick ('`'): // // // Postgres uses as identifier quote character " (double quotes): $sql_create_db =$db->build_sql_create_db($db_name); if(!$db->exec_query($sql_create_db)) { echo "Failed! - Could not create database: $db! " . $db->error_msg(); $errors += 1; echo " TestLink setup could not create the database, " .
"and no existing database with the same name was found. You are trying to upgrade from a pre-release of TestLink 1.5" .
" You are trying to upgrade from a pre-release of TestLink 1.7" .
" Your DB Schema {$schema_version} NEED TO BE upgraded, but you have to do ";
echo " this MANUALLY using a SQL client and scripts you will find on ";
echo " directory install/sql/alter_tables/1.9.1 ";
echo " Your DB Schema {$schema_version} NEED TO BE upgraded, but you have to do ";
echo " this MANUALLY using a SQL client and scripts you will find on ";
echo " directory install/sql/alter_tables/1.9.4 ";
echo " Your DB Schema {$schema_version} is the last available, then you don't need to do any upgrade.";
echo " Information of DB schema version is missing. Don't know how to upgrade. "; } else { echo "This script doesn't recognize your schema version: " . $schema_version . " "; } echo "Upgrade is not possible. Check your input data (Go back in page history). "; close_html_and_exit(); break; } } $a_sql_schema = getDirSqlFiles($a_sql_upd_dir,ADD_DIR); $a_sql_data = getDirSqlFiles($a_sql_data_dir,ADD_DIR); } // ------------------------------------------------------------------------ // Now proceed with user checks and user creation (if needed) // // Added support for different types of architecture/installations: // webserver and dbserver on same machines => user will be created as user // webserver and dbserver on DIFFERENT machines => user must be created as user@webserver // // if @ in tl_db_login (username) -> get the hostname using splitting, and use it // during user creation on db. $db->close(); $db=null; $user_host = explode('@',$tl_db_login); $msg = create_user_for_db($dbDriverName,$db_name, $db_server, $db_admin_name, $db_admin_pass, $tl_db_login, $tl_db_passwd); echo "Creating Testlink DB user `" . $user_host[0] . "`:"; if ( strpos($msg,'ok -') === FALSE ) { echo "Failed! - Could not create user: $tl_db_login!"; $errors += 1; } else { echo "OK! ($msg) "; } // ------------------------------------------------------------------------ // Schema Operations (CREATE, ALTER, ecc). // Important: // Postgres: do it as tl_login NOT as db_admin // MySQL : do it as db_admin NOT as tl_login if( !is_null($db) ) { $db->close(); $db=null; } $db = new database($dbDriverName); switch($db_type) { case 'mssql': @$conn_result = $db->connect(NO_DSN, $db_server, $db_admin_name, $db_admin_pass, $db_name); break; case 'mysql': @$conn_result = $db->connect(NO_DSN, $db_server, $db_admin_name, $db_admin_pass, $db_name); break; case 'postgres': @$conn_result = $db->connect(NO_DSN, $db_server, $tl_db_login, $tl_db_passwd, $db_name); break; } // ------------------------------------------------------------------------------------ if( $install && $conn_result['status'] != 0 ) { drop_views($db,$db_table_prefix,$db_type); drop_tables($db,$db_table_prefix,$db_type); } // ------------------------------------------------------------------------------- $sqlParser = new SqlParser($db,$db_type,$db_table_prefix); foreach($a_sql_schema as $sql_schema) { foreach ($sql_schema as $sql_file) { echo " Processing:" . $sql_file; $sqlParser->process($sql_file); } echo " "; } // Now data migration must be done if needed if( $migration_process != '' ) { require_once($migration_functions_file); $migration_process($db,$tables); } // ------------------------------------------------- // Data Operations if ( count($a_sql_data > 0) ) { foreach($a_sql_data as $sql_data ) { if ( count($sql_data > 0) ) { foreach ($sql_data as $sql_file) { $sqlParser->process($sql_file); } } } } // ------------------------------------------------- if ($update_pwd) { echo "Password Conversion ..."; // @author Francisco Mancardi - 20050918 // Found error upgrading from 1.0.4 to 1.6 on RH // due to case sensitive on table name. (USER) $user_pwd = "UPDATE user SET password=MD5(password)"; $result = $db->exec_query($user_pwd); } if($sqlParser->install_failed==true) { echo "Failed! - {$inst_type_verbose} failed!"; $errors += 1; echo "" . "TestLink setup couldn't install the default site into the selected database. " . "The last error to occur was " . $sqlParser->sql_errors[count($sqlParser->sql_errors)-1]["error"] . ' during the execution of SQL statement ' . strip_tags($sqlParser->sql_errors[count($sqlParser->sql_errors)-1]["sql"]). ""; close_html_and_exit(); } else { echo "OK!"; } // ----------------------------------------------------------------------------- echo " Writing configuration file:"; $data['db_host']=$db_server; $data['db_login'] = $user_host[0]; $data['db_passwd'] = $tl_db_passwd; $data['db_name'] = $db_name; $data['db_type'] = $db_type; $data['db_table_prefix'] = $db_table_prefix; $cfg_file = "../config_db.inc.php"; $yy = write_config_db($cfg_file,$data); // ----------------------------------------------------------------------------- if(strcasecmp('ko', $yy['status']) == 0) { echo "Failed!"; $errors += 1; echo "" . "TestLink couldn't write the config file. Please copy the following into the " . ' ' . $cfg_file . ' file: ' . '"; echo "Once that's been done, you can log into TestLink by pointing your browser at your TestLink site."; close_html_and_exit(); } else { echo "OK!"; } manual_operations($db_type); important_reminder(); // When testlink is updated do not show login data admin/admin // as they might not exist $successfull_message = ' ' . "{$inst_type_verbose} was successful!" . ' ';
echo $successfull_message;
$db->close();
close_html_and_exit();
/**
*
*
*/
function manual_operations($dbType) {
echo '' . 'You can now log in to Testlink'; if($create) { $successfull_message .= ' (using login name:admin / password:admin - Please Click Me!)'; } $successfull_message .= '. IMPORTANT NOTICE - IMPORTANT NOTICE - IMPORTANT NOTICE - IMPORTANT NOTICE'; echo ''; //echo 'IMPORTANT NOTICE - IMPORTANT NOTICE - IMPORTANT NOTICE - IMPORTANT NOTICE'; //echo ''; echo ''; echo ' YOU NEED TO RUN MANUALLY Following Script on your DB CLIENT Application'; echo ''; echo ' ' . dirname(__FILE__) . '/sql/'. $dbType . '/testlink_create_udf0.sql'; echo 'THANKS A LOT'; } // ----------------------------------------------------------- function write_config_db($filename, $data) { $ret = array('status' => 'ok', 'cfg_string' => ''); $db_host = $data['db_host']; $db_login = $data['db_login']; // if @ present in db_login, explode an take user name WITHOUT HOST $user_host = explode('@',$db_login); if (count($user_host) > 1 ) { $db_login = $user_host[0]; } $db_passwd = $data['db_passwd']; $db_name = $data['db_name']; $db_type = $data['db_type']; $db_table_prefix = $data['db_table_prefix']; // write config.inc.php $configString = "get_dbmgr_object(); $tablesOnDB =$my_ado->MetaTables('TABLES'); if( count($tablesOnDB) > 0 && isset($tablesOnDB[0])) { echo "Dropping all TL existent tables: "; foreach($schema as $tablePlainName => $tableFullName) { $targetTable = $dbTablePrefix . $tablePlainName; if( in_array($targetTable,$tablesOnDB) ) { // Need to add option (CASCADE ?) to delete dependent object echo "Droping $targetTable" . " "; $sql="DROP TABLE $targetTable"; $sql .= (($dbType != 'mssql') && ($dbType != 'sqlsrv')) ? " CASCADE " : ' '; $dbHandler->exec_query($sql); } } echo "Done!"; } } function drop_views(&$dbHandler,$dbItemPrefix,$dbType) { $schema = tlObjectWithDB::getDBViews(); // views present on target db $my_ado = $dbHandler->get_dbmgr_object(); $itemsOnDB =$my_ado->MetaTables('VIEWS'); if( count($itemsOnDB) > 0 && isset($itemsOnDB[0])) { echo " Dropping all TL existent views: "; foreach($schema as $itemPlainName => $itemFullName) { $target = $dbItemPrefix . $itemPlainName; if( in_array($target,$itemsOnDB) ) { // Need to add option (CASCADE ?) to delete dependent object echo "Droping $target" . " "; $sql="DROP VIEW $target"; $sql .= (($dbType != 'mssql') && ($dbType != 'sqlsrv')) ? " CASCADE " : ' '; $dbHandler->exec_query($sql); } } echo "Done!"; } } |