所有由雷老虎发布的文章

iF.SVNAdmin 在 Php7.0下的运行

iF.SVNAdmin判断PHP版本的函数有缺陷,需要修改

<?php
function checkPHPVersion($minimumVersion)
{
  $phpVersion = phpversion();
  $phpVersionParts = explode(".", $phpVersion);
  $minVersionParts = explode(".", $minimumVersion);
  $minVersionPartsCount = count($minVersionParts);

  $check = true;
  if ($minVersionPartsCount >= 1)
    if ($phpVersionParts[0] < $minVersionParts[0])
      $check = false;

  if ($minVersionPartsCount >= 2)
    //if ($phpVersionParts[1] < $minVersionParts[1])
    if ($phpVersionParts[0] < $minVersionParts[0] || $phpVersionParts[0] == $minVersionParts[0] && $phpVersionParts[1] < $minVersionParts[1])
      $check = false;

  if ($minVersionPartsCount >= 3)
    if ($phpVersionParts[2] < $minVersionParts[2])
      $check = false;

  return $check;
}

 

因为我增加了维护用户的同时保存用户信息到数据库的功能,所以需要访问数据库,这个是新增文件。PHP7.0 不再支持mysql驱动,改为mysqli,所以需要修改以下操作数据库的方法:

<?php
function getConnection(){
  $hostname = "localhost:3306";
  $username = "username";
  $password = "password";  
  $conn = mysqli_connect($hostname,$username,$password) or die("Connection error:" . mysqli_connect_error());
  $dbName = "dbname";	
  $ret=mysqli_select_db($conn, $dbName);
  return $conn; 
}
function query($sql){
  $conn = getConnection();
  $res = mysqli_query($conn, $sql)  or die("Connection error:" . mysqli_error($conn));
  return $res;  
}
?>

如果是用mysql驱动,这段代码可以改为:

<?php
function getConnection(){
  $hostname = "localhost:3306";
  $username = "username";
  $password = "password";  
  $conn = mysql_pconnect($hostname,$username,$password) or die("Connection error:" . mysql_error());
  $dbName = "dbname";	
  $ret=mysql_select_db($dbName,$conn);
  return $conn; 
}
function query($sql){
  $conn = getConnection();
  $res = mysql_query($sql,$conn)  or die("Connection error:" . mysql_error());
  return $res;  
}
?>

而要保存用户信息到数据库需要修改./actions/create_user.php

// Create user object.
$u = new \svnadmin\core\entities\User;
$u->id = $username;
$u->name = $username;
$u->password = $password;

try {
  // Create the user now.
  $b = $appEngine->getUserEditProvider()->addUser($u);
  if($b)
  {
    $appEngine->getUserEditProvider()->save();
    $appEngine->addMessage(tr("The user %0 has been created successfully.", array($username)));
          $q = "insert IGNORE into user(name, password) values('" . $username . "', '{SHA}" . base64_encode(sha1($password, TRUE)) . "')";
    query($q);

  }

删除用户信息:

// Delete the user.
$done = $appEngine->getUserEditProvider()->deleteUser($u);
if ($done)
{
          $q = "delete from user where name = '" . $u->name . "'";
          query($q);

	$appEngine->addMessage(tr("Removed user %0 successfully.", array($u->name)));
}
else
{
	$appEngine->addException(tr("Can not remove user %0."));
}

 

更改密码

// Ok, change password now.
$b = $appEngine->getUserEditProvider()->changePassword($username, $password);
if ($b) {
  $appEngine->getUserEditProvider()->save();
  $q = "update user set password = '{SHA}" . base64_encode(sha1($password, TRUE)) . "' where name = '" . $username . "'";
  query($q);
  $appEngine->addMessage(tr("The password has been changed."));
}

在./include/config.inc.php这个文件的头部增加对db.inc.php的引用

error_reporting(E_ALL);
include_once("./classes/util/global.func.php");
include_once("./db.inc.php");
set_exception_handler('exception_handler');

 

 

SSH 使用小结

-f    要求 ssh在执行命令前退至后台.它用于当ssh准备询问口令或密语,但是用户希望它在后台进行.该选项隐含了-n选项.在远端机器上启动

-N    不执行远程命令.用于转发端口.

-C    要求进行数据压缩 (包括stdin, stdout, stderr以及转发X11和TCP/IP连接 的数据).压缩算法和gzip(1)的一样,协议第一版中,压缩级别 “level” 用CompressionLevel选项控制.压缩技术在modem线路或其他慢速连接上很有用,但是在高速网络上反而 可能降低速度.可以在配置文件中对每个主机单独设定这个参数.

-g    允许远端主机连接本地转发的端口

-q    安静模式.消除所有的警告和诊断信息

-T    禁止分配伪终端

-n    把 stdin重定向到/dev/null (实际上防止从stdin读取数据).  ssh在后台运行时一定会用到这个选项.它的常用技巧是远程运行X11程序.

ssh -CfNg -L port1:127.0.0.1:port2 user@host    #本地转发
ssh -CfNg -R port2:127.0.0.1:port1 user@host    #远程转发
要监听到0.0.0.0,需要参数 -o GatewayPorts=yes 或者修改 /etc/ssh/sshd_config
SSH -qTfnN -D port remotehost   #socks代理,如果非默认端口,加 -p 参数