FreeRadius记录登陆的错误信息到数据库 在modules里面添加attr_rewrite，内容为attr_rewrite sanereplymessage {attribute = Reply-Messagesearchin = replysearchfor = "\n|\r"replacewith = ""ignore_case = nonew_attribute = nomax_matches = 10append = no}12345678910attr_rewrite sanereplymessage { attribute = Reply-Message searchin = reply searchfor = "\n|\r" replacewith = "" ignore_case = no new_attribute = no max_matches = 10 append = no}然后修改default，在sql前面增加sanereplymessagePost-Auth-Type REJECT {..sanereplymessagesql..}123456Post-Auth-Type REJECT { .. sanereplymessage sql .. }最后按照FreeRADIUS 2.x 记录认证者信息 修改usr/local/etc/raddb/sql/mysql/dialup.confpostauth_query = "INSERT INTO ${postauth_table} \ (username, pass, reply, authdate, calledstationid, nasipaddress, replymessage) \ VALUES ( \ '%{User-Name}', \ '%{%{User-Password}:...

FreeRADIUS 2.x默认在数据库只记录用户名，密码，认证时间等信息，但没有访问IP和连接VPN的IP，为了更好的监控，所以添加记录验证者的ip和连接vpn的IP。首先给FreeRADIUS数据库的radpostauth表添加2个字段 calledstationid和nasipaddress。然后修改 /usr/local/etc/raddb/sql/mysql/dialup.conf ，将最后的认证信息修改为： postauth_query = "INSERT INTO ${postauth_table} \ (username, pass, reply, authdate, calledstationid, nasipaddress) \ VALUES ( \ '%{User-Name}', \ '%{%{User-Password}:-%{Chap-Password}}', \ '%{reply:Packet-Type}', '%S', '%{Calling-Station-Id}', '%{NAS-IP-Address}')"123456 postauth_query = "INSERT INTO ${postauth_table} \                          (username, pass, reply, authdate, calledstationid, nasipaddress) \  &nb...

VM virt-install 安装各个系统配置Debian 8virt-install \--accelerate \--name debian8 \--ram 1024 \--controller type=scsi,model=virtio-scsi \--disk path=/home/date/debian8.qcow2,size=10,sparse=true,cache=none,bus=scsi \--vcpus 1 \--os-type linux \--os-variant generic \--network bridge=br0 \--graphics none \--console pty,target_type=serial \--location 'http://ftp.nl.debian.org/debian/dists/jessie/main/installer-amd64/' \--extra-args 'console=ttyS0,115200n8 serial'1234567891011121314virt-install \--accelerate \--name debian8 \--ram 1024 \--controller type=scsi,model=virtio-scsi \--disk path=/home/date/debian8.qcow2,size=10,sparse=true,cache=none,bus=scsi \--vcpus 1 \--os-type linux \--os-variant generic \--network bridge=br0 \--graphics none \--console pty,target_type=serial \--location 'http://ftp.nl.debian.org/debian/dists/jessie/main/installer-amd64/' \--extra-args 'console=ttyS0,115200n8 serial'Debian 7virt-install \--accelerate \--name debian7 \--ram 1024 \--controller type=scsi,model...

 安装freeradius 2.x和freeradius 3.x，测试连接都无法通过，错误如下 freeradius 2.x 提示的错误radclient:: Failed to find IP address for Excaliburradclient: Nothing to send.12radclient:: Failed to find IP address for Excaliburradclient: Nothing to send. freeradius 3.x 提示的错误(0) Error parsing "-": ip_hton: Name or service not known1(0) Error parsing "-": ip_hton: Name or service not known 解决方法很简单给/etc/hosts添加主机名解析就可以vi /etc/hosts添加：127.0.0.1 servername或者运行以下语句cat >>/etc/hosts<<EOF127.0.0.1 `hostname`EOF123cat >>/etc/hosts<<EOF127.0.0.1 `hostname`EOF

Installation Before installing TCAdmin make sure you have installed the System Requirements Installation (Windows) Make sure you have installed the System Requirements. Download the TCAdmin installer http://www.tcadmin.com/installer/tcadmin2setup.exe Execute and install. Change the installation directory as needed. Follow the Initial Configuration guide to configure TCAdmin. Installation (Linux) Make sure you have installed the System Requirements. Download and install the TCAdmin package for your Linux distro. CentOS / Fedora / Redhatwget http://www.tcadmin.com/installer/tcadmin-2-bi.noarch.rpm;yum -y install tcadmin-2-bi.noarch.rpm --nogpgcheck Debian / Ubuntuwget http://www.tcadmin.com/installer/tcadmin-2-bi.noarch.deb;dpkg -i tcadmin-2-bi.noarch.deb Follow the Initial Configuration guide to configure TCAdmin.Initial Configuration Contents [hide] 1 Access your Control Panel2 License Information3 Database Configurat...

H3C S5048E web不能配置端口链路汇聚在web中配置链路汇聚 手工模式时,添加端口状态都是不能添加的状态。通过控制口，查看当然运行配置信息如：interface GigabitEthernet0/47 speed 1000 controller arp enable undo arp detection trust arp rate-limit 15 port link-aggregation group 1 dhcp-snooping trust#interface GigabitEthernet0/48 speed 1000 controller arp enable  undo arp detection trust arp rate-limit 15 dhcp-snooping trust#然后通过命令配置聚合， #: port link-aggregation group 1 mode manaul提示打开controller arp enable 命令，不能配置聚合。#： undo controller arp 再配置端口聚合，可以正常配置。#: port link-aggregation group 1 mode manaul# interface GigabitEthernet 0/48#: port link-aggregation group 1# interface GigabitEthernet 0/47#: port link-aggregation group 1再到web中查看配置，已经添加好了端口聚合。配置关键点：1．同一个汇聚组中端口的基本配置必须保持一致，基本配置主要包括STP、QoS、VLAN、端口属性等相关配置；2．对于端口环回监测（loopback-detect...

On a computer that has a multicore processor, you may be unable to install SQL Server 2005  Email  Print SymptomsConsider the following scenario. You try to install Microsoft SQL Server 2005 on a computer that has a multicore processor, and one of the following conditions is true:The ratio between logical processors and physical sockets is not a power of 2. For example, the computer has a single socket together with a triple-core processor. The number of physical cores is not a power of 2.The total number of CPUs is an odd number. For example, there are seven or nine CPUs.In these scenarios, you cannot install SQL Server 2005.When the installation fails, the following error message is logged in the Summary.txt file:The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Ser...

Centos6升级Centos7.2最新版网上教程都是旧版的，没法用。自己想到办法解决了。step 1,配置yum源：[root@localhost ~]# cat /etc/yum.repos.d/upgrade.repo                                                 [upgrade]name=upgradebaseurl=http://dev.centos.org/centos/6/upg/x86_64/enable=1gpgcheck=0step 2安装升级软件工具：[root@localhost ~]# yum install preupgrade-assistant-contents redhat-upgrade-tool preupgrade-assistant$ sudo preupg Preupg tool doesn't do the actual upgrade. Please ensure you have backed up your system and/or data in the event of a failed upgrade that would require a full re-install of the system from installation media. Do you want to continue? y/n y Gathering logs used by preupgrade assistant: All installed packages : 01/10 ...finished (time 00:00s) All changed files : 02/10 ...finished (time 00:48s) Changed config files : 03/10 ...finished (tim...

oneproxy---mysql代理集群安装   　OneProxy是一款数据库中间件，与目前市面上的TDDL、MySQL-Proxy属于同类型产品。我们坚持研发OneProxy是基于如下几点考虑：     　1. 我们不想被某一种开发语言绑定：TDDL绑定了客户必须使用JAVA做开发语言，而且整个一套系统的正常运行非常依赖于强大的配置推送中心和雄厚的运维团队；     　2. 使用上必须透明： MySQL-Proxy实现了MySQL协议，使得其看起来就像一个MySQL数据库一样，因此客户可以使用任何他们喜欢的语言来操作数据库。因此OneProxy借鉴了其在协议上的实现。     　3. 我们需要更稳定，更多功能的中间件： 令人痛心的是，官方对这款产品的重视度好像不够。从2007年第一版推出到2015年都快八年了，仍未达到GA状态。 　 我们的OneProxy是楼方鑫倾力打造的一款产品，里面的每一行代码都流淌着丰富的经验。可以说，OneProxy生而为实战。　    那我在这里先向大家丢出一个最常遇见的问题，如果数据库挂掉怎么办？        1. 手动改应用配置，太low；就算这不是太low的事情，但是当你有20个应用要手动改呢？      &n...

How To Fix NIC Link is Down On Centos 6.5  Centos6网卡:  e1000e Timesync Tx Control register not set as expectedSince upgrading a CentOS 6.4 with a SuperMicro X8SIE-F/X9SCL board with Intel 82574L NIC to 2.6.32-431.el6.x86_64 and rebooting, I have been having consistent NIC failures where the NIC shuts down permanently until a soft reboot is performed.Type the following commands to get more info about error# cat /var/log/messages | grep eth1 kernel: NETDEV WATCHDOG: eth1 (e1000e): transmit queue 0 timed out kernel: e1000e 0000:02:00.0: eth1: Reset adapter unexpectedly kernel: e1000e 0000:02:00.0: eth1: Timesync Tx Control register not set as expected kernel: e1000e 0000:02:00.0: eth1: Timesync Tx Control register not set as expected kernel: e1000e 0000:02:00.0: eth1: Timesync Tx Control register not set as expected kernel: ADDRCONF(NETDEV_UP): eth1: link is not ready# uname -a Linux svr.lifelinux.com 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86...