《毕业论文（设计）基于MS ISA 网络流量计费系统.doc》由会员分享，可在线阅读，更多相关《毕业论文（设计）基于MS ISA 网络流量计费系统.doc（6页珍藏版）》请在三一办公上搜索。
1、基于MS ISA2006网络流量计费系统宋继志(中国石油大学（华东）计算机与通信工程学院 山东 东营 257061) 摘要：Internet Security and Acceleration（ISA） Server 2006功能强大，但ISA2006的计费功能不是很全，不符合中国人的使用计费习惯。本系统是在ISA2006上开发的网络计费系统软件，利用ISA2006的丰富的日志得到每个客户的上网的详细情况包括使用时间和流量，然后再根据价格统计最终的费用。关键词： ISA2006；计费系统；网络流量中图分类号：TP393 文献标识码：A1.ISA Server的完善ISA2006（以下简称ISA
2、）为目前大中型企业、公司常用的防火墙软件，是建立在Windows server操作系统以上的一种可扩展的企业级防火墙和Web缓存服务器。ISA能提供多项高效方便的管理功能：多层防火墙安全、状态检测、集成的入侵检测、高性能Web 缓存、缓存阵列路由协议、活动缓存、统一管理、企业策略和访问控制。但美中不足是它本身不具有网络计费和查询的功能，这给ISA的使用和管理带来一定的不便。许多单位都想对通过防火墙服务器上网的电脑进行收费，但多数防火墙(代理)服务器软件设置管理一般都比较繁琐，计费统计麻烦。ISA Server却能与操作系统以及其他软件紧密结合，能够将客户端产生日志通过ODBC记录在数据库里，保
3、存非常详细的客户端上网时间、流量等信息的数据，为上网费的计算、统计、分析带来便利。本文我们根据ISA Server的日志进行了二次开发，增补完善ISA的功能，使其具有多种网络计费查询功能，从而方便ISA用户的使用。使得可通过对ISA上网的计算机用户的上网情况进行实时查询，使ISA具有对用户上网时间、收到字节数、登陆网站次数、网络处理时间等多项统计和查询功能。2.日志文件及数据库生成详细的安全和访问日志是ISA的主要特征。它们能以标准数据格式，比如W3C、ODBC等生成。ISA内置有3种日志：防火墙服务活动监视、Web代理服务以及数据包筛选器。新日志可以按年、月、周、日创建。ISA记录数据包筛选
4、器、防火墙服务和Web代理服务的活动。默认每天为每项服务生成新日志文件。启用服务日志时，阵列中的每一个服务器都生成日志。ISA集中这些日志，收集所有服务器的数据并将其组合成一个单独的日志报告。默认情况下，ISA以W3C格式记录日志文件，比如2007年7月20号生成的W3C格式的Web代理服务的日记录日志文件，可命名为WebEXTD20070720.log；也可以选择以ISA格式记录日志文件，第三种是以ODBC格式记录到数据库。日志文件名是根据所记录的服务名、日志文件格式和记录日期所产生的。把W3C型日志改成Access日志的具体步骤如下：2.1配置记入日志文件 日志文件属性修改是在ISA Ma
5、nagement中Monitoring Configuration节点的Logs文件夹中进行的。在ISA Management控制台树中，展开Monitoring Configuration节点,选择Logs文件夹，确定日志文件格式，这里我们选取Access数据库文件，指定创建新日志文件的频率，并选取以月为单位，将文件保存到另外的文件夹中。2.2建立Access数据库ISA一般把数据写入Access和SQL二种数据库。为方便使用，该系统选择了Access数据库，在建立之前，必须把保存这一数据库的路径选好，一般要选择磁盘空间比较大的地方，因为以后产生的数据量非常大。根据帮助文件w3proxy.s
6、ql中SQL视图生成语句，完成Access表的建立，并取名为web。2.3建立ODBC数据源完成Access数据库与表的建立后，可以开始建立ODBC数据源，通过ODBC数据源管理器。选择Microsoft Access Driver作为需要安装的数据源驱动程序，并为数据源命名web。进入ISA Manager窗口, 双击Web Proxy，选择Logging选项卡，点“Log to SQL/ODBC Database”，在“ODBC Data Source Name”中输入刚才所建立的系统DSN，即数据源名web；在Table中输入刚才所建立的Access表名；完成后点确定。 通过上面的设置，
7、ODBC服务器就可以开始记录 ISA 授权用户的上网日志。信息是非常详细的，其中包括：上网的用户名、上网电脑的IP地址、实际上网时间、所去网站、详细网址、接收与发送字节数等，字段具体内容和含义可参考ISA帮助文档。3.软件界面设计3.1启动界面的设计在设计界面的过程中美感也是必不可少的。其功能按钮可根据查询实际情况来选定。3.2访问数据库的方法在这方面，VB提供了多种数据库访问方式。我们使用的是ADO数据控件和数据绑定控件这种方式。这种访问方式，通过使用控件的属性、方法和事件，编写少量的程序代码，实现数据的访问和处理。数据绑定控件，通过ADO数据控件仅仅建立了与数据库的连接，创建了查询记录集，
8、但其本身不能显示数据。为了实现对数据的操作，必须将数据源与应用程序界面的操作控件连接在一起，这种连接方式称为数据绑定。实现与数据源连接的控件称为数据绑定控件。3.3单个浏览子界面的设计单个浏览子界面（如图1）实现了用户按登陆IP以及登陆日期进行上网情况的详细查询，并进行了用户上网收到总字节数和上网总时间的统计。 该界面的设计，在窗体上放置3个ADO数据控件、8个Label、3个TextBox、2个Command、3个DataGrid。ADO数据控件用于建立数据源（记录集），TextBox及DataGrid绑定控件用于与数据源绑定，显示记录集中的数据，Label控件用于说明TextBox控件的用
9、途。图1 单个浏览子界面运行状态3.4总体浏览子界面的设计 当用户在启动界面上点击总体浏览按钮后，即可进入总体浏览子界面（如图2）。用户在总体浏览子界面中可以看到所有用户IP的收到字节总数和上网总处理时间的统计情况：图2 总体浏览子界面运行状态该界面的设计，在窗体上放置3个DataList控件，一个DataGrid控件，一个ADO数据控件。其中DataList绑定控件用于与数据源绑定，显示记录集中的数据以及显示对记录集的操作结果。该子界面中有一部分非常关键的代码段。它完成了对所有不同用户IP的统计，从而使得在总体浏览界面上能显示出不同IP。这段代码的思想是：首先建立三个数组ip(i)、temp
10、(i)、ipp(i)，并将初值都赋为0；然后将记录集中所有的用户IP赋给数组ip(i)，然后将ip(i)数组的每一个IP值依次与其后的IP值相比较，如果其后的IP值有和这个IP值相等的，则将该IP对应位置的temp(i)的值赋1；最后将temp（i）中为0的对应的ip(i)数组中的IP值依次赋给ipp(i)数组。这样就将IP不重复地赋给了新的数组，以便完成统计。3.5费用查询子界面的设计当用户在启动界面上点击费用查询按钮后，即可进入费用查询子界面（如图3）。用户在费用查询子界面中可以看到所有用户IP的收到字节总数和上网总处理时间的统计，并实现了根据给定上网费率统计出上网费用。图3四.小结 本文
11、阐述的系统实现了在ISA上计费查询二次开发，增补完善ISA的功能，使其具有多种网络计费查询功能，更加符合我们中国用户的使用习惯，使ISA Server更加实用,其功能更加强大。参考文献1Internet Security and Acceleration Server 2006Microsoft Corporation2 3 4美J CMackin. Microsoft ISA Server 2000M .李良波, 刘军山,等译. 北京:清华大学出版社,2002.5宋伟 .中文Visual Basic 6.0高级编程. 1999. 4第1版. 北京:清华大学出版社. 1999年：P335-P3
12、50A Billing System of Netflow Based on MS ISA2006Song Ji-zhi(College Of Computer and Communication Engineering, China University ofPetroleum(East China),Shandong,Dongying,257061) Abstract: The function of Internet Security and Acceleration（ISA） Server 2006 is strong, but its function of billing is n
13、ot complete and accord with the usages of the China. Our system is a software based on ISA2006 of network billing. According to the plenty of logs of ISA2006,we can receive the details of surfing the Internet of every user including of time and netflow. And then we can count the ultimate billing acc
14、ording to the price.Keywords: ISA2006 ;a billing system; netflow（作者简介：宋继志（1976-），男，山东嘉祥人，讲师，系副主任，研究方向计算机应用及系统结构。）Editors note: Judson Jones is a meteorologist, journalist and photographer. He has freelanced with CNN for four years, covering severe weather from tornadoes to typhoons. Follow him on Tw
15、itter: jnjonesjr (CNN) - I will always wonder what it was like to huddle around a shortwave radio and through the crackling static from space hear the faint beeps of the worlds first satellite - Sputnik. I also missed watching Neil Armstrong step foot on the moon and the first space shuttle take off
16、 for the stars. Those events were way before my time.As a kid, I was fascinated with what goes on in the sky, and when NASA pulled the plug on the shuttle program I was heartbroken. Yet the privatized space race has renewed my childhood dreams to reach for the stars.As a meteorologist, Ive still see
17、n many important weather and space events, but right now, if you were sitting next to me, youd hear my foot tapping rapidly under my desk. Im anxious for the next one: a space capsule hanging from a crane in the New Mexico desert.Its like the set for a George Lucas movie floating to the edge of spac
18、e.You and I will have the chance to watch a man take a leap into an unimaginable free fall from the edge of space - live.The (lack of) air up there Watch man jump from 96,000 feet Tuesday, I sat at work glued to the live stream of the Red Bull Stratos Mission. I watched the balloons positioned at di
19、fferent altitudes in the sky to test the winds, knowing that if they would just line up in a vertical straight line we would be go for launch.I feel this mission was created for me because I am also a journalist and a photographer, but above all I live for taking a leap of faith - the feeling of pus
20、hing the envelope into uncharted territory.The guy who is going to do this, Felix Baumgartner, must have that same feeling, at a level I will never reach. However, it did not stop me from feeling his pain when a gust of swirling wind kicked up and twisted the partially filled balloon that would take
21、 him to the upper end of our atmosphere. As soon as the 40-acre balloon, with skin no thicker than a dry cleaning bag, scraped the ground I knew it was over.How claustrophobia almost grounded supersonic skydiverWith each twist, you could see the wrinkles of disappointment on the face of the current
22、record holder and capcom (capsule communications), Col. Joe Kittinger. He hung his head low in mission control as he told Baumgartner the disappointing news: Mission aborted.The supersonic descent could happen as early as Sunday.The weather plays an important role in this mission. Starting at the gr
23、ound, conditions have to be very calm - winds less than 2 mph, with no precipitation or humidity and limited cloud cover. The balloon, with capsule attached, will move through the lower level of the atmosphere (the troposphere) where our day-to-day weather lives. It will climb higher than the tip of
24、 Mount Everest (5.5 miles/8.85 kilometers), drifting even higher than the cruising altitude of commercial airliners (5.6 miles/9.17 kilometers) and into the stratosphere. As he crosses the boundary layer (called the tropopause), he can expect a lot of turbulence.The balloon will slowly drift to the
25、edge of space at 120,000 feet (22.7 miles/36.53 kilometers). Here, Fearless Felix will unclip. He will roll back the door.Then, I would assume, he will slowly step out onto something resembling an Olympic diving platform.Below, the Earth becomes the concrete bottom of a swimming pool that he wants t
26、o land on, but not too hard. Still, hell be traveling fast, so despite the distance, it will not be like diving into the deep end of a pool. It will be like he is diving into the shallow end.Skydiver preps for the big jumpWhen he jumps, he is expected to reach the speed of sound - 690 mph (1,110 kph
27、) - in less than 40 seconds. Like hitting the top of the water, he will begin to slow as he approaches the more dense air closer to Earth. But this will not be enough to stop him completely.If he goes too fast or spins out of control, he has a stabilization parachute that can be deployed to slow him
28、 down. His team hopes its not needed. Instead, he plans to deploy his 270-square-foot (25-square-meter) main chute at an altitude of around 5,000 feet (1,524 meters).In order to deploy this chute successfully, he will have to slow to 172 mph (277 kph). He will have a reserve parachute that will open
29、 automatically if he loses consciousness at mach speeds.Even if everything goes as planned, it wont. Baumgartner still will free fall at a speed that would cause you and me to pass out, and no parachute is guaranteed to work higher than 25,000 feet (7,620 meters).It might not be the moon, but Kittinger free fell from 102,800 feet in 1960 - at the dawn of an infamous space race that captured the hearts of many. Baumgartner will attempt to break that record, a feat that boggles the mind. This is one of those monumental moments I will always remember, because there is no way Id miss this.
