openvpn使用mysql来验证

也有现成的一些插件，不过感觉不好用，自己用PHP简单写了一个。

openvpn server需要配置

C++代码

openvpn client需要配置

C++代码

使用这些PHP脚本文件

mysqlconfig.inc.php

PHP代码

verifyvpn.php

PHP代码

#!/usr/bin/env php
<?php
include_once 'mysqlconfig.inc.php';
$mysqli = new mysqli($server,$username,$password,$database);
if (mysqli_connect_errno()) {
exit(1);
}
$user = $mysqli->real_escape_string($_ENV["username"]);
$pass = $mysqli->real_escape_string($_ENV["password"]);
$rs = $mysqli->query("select id from user where name = '$user' and password = '$pass' and canlogin = 1 and expiretime > now()");
$mysqli->close();
if ($rs->num_rows == 1) {
exit(0);
} else {
exit(1);
}

clientconnected.php

PHP代码

#!/usr/bin/env php
<?php
include_once 'mysqlconfig.inc.php';
$mysqli = new mysqli($server,$username,$password,$database);
if (mysqli_connect_errno()) {
exit(1);
}
$user = $mysqli->real_escape_string($_ENV["common_name"]);
$ip = $mysqli->real_escape_string($_ENV["trusted_ip"]);
$rs = $mysqli->query("select id from user where name = '$user'");
$id = -1;
if($rs->num_rows == 1){
$id = $rs->fetch_object()->id;
}else{
$mysqli->close();
exit(1);
}
$logintime = date('Y-m-d H:i:s');
$mysqli->query("update user set logincount = logincount +1, lastlogintime = '$logintime', lastloginip = '$ip', isonline = 1 where id = $id");
if ($mysqli->affected_rows != 1) {
$mysqli->close();
exit(1);
}
$mysqli->query("insert into log (userid, logintime, loginip) values ($id, '$logintime', '$ip')");
if ($mysqli->affected_rows != 1) {
$mysqli->close();
exit(1);
}
$mysqli->close();
exit(0);

clientdisconnected.php

PHP代码

#!/usr/bin/env php
<?php
include_once 'mysqlconfig.inc.php';
$mysqli = new mysqli($server,$username,$password,$database);
if (mysqli_connect_errno()) {
exit(1);
}
$user = $mysqli->real_escape_string($_ENV["common_name"]);
$br = $mysqli->real_escape_string($_ENV["bytes_received"]);
$bt = $mysqli->real_escape_string($_ENV["bytes_sent"]);
$rs = $mysqli->query("select id,lastlogintime,lastloginip from user where name = '$user'");
$id = -1;
$logintime = '';
$ip = '';
if($rs->num_rows == 1){
$userinfo = $rs->fetch_object();
$id = $userinfo->id;
$logintime = $userinfo->lastlogintime;
$ip = $userinfo->lastloginip;
}else{
$mysqli->close();
exit(1);
}
$logouttime = date('Y-m-d H:i:s');
$mysqli->query("update user set isonline = 0, bytes_received = bytes_received + $br, bytes_sent = bytes_sent + $bt where id = $id");
if ($mysqli->affected_rows != 1) {
$mysqli->close();
exit(1);
}
$mysqli->query("update log set logouttime = '$logouttime', bytes_received = $br, bytes_sent = $bt where userid = $id and logintime = '$logintime' and loginip = '$ip'");
if ($mysqli->affected_rows != 1) {
$mysqli->close();
exit(1);
}
$mysqli->close();
exit(0);

数据库结构

SQL代码

管理的话直接使用phpMyAdmin吧，呵呵，前台和后台现在还没有做。

openvpn其它设置与一般的一样。

只显示5条记录相关文章