h3c imc 7.3 portal

某局点iMC EIA 7.3 (E0623) 修改接入用户的在线数量限制不生效，比如在线数量限制从1修改为2，发现第二个终端仍然无法上线。

1.执行“接入策略管理-业务参数配置-系统配置手工生效”操作问题依旧。 

2.从UAM调试日志看确实强制下线了接入用户mali，说明在线数量限制为2确实没有生效。 

%% 2022-11-17 12:42:35.463 ; [LDBG] ; [954181376] ; OnlineMgr ; chkOnlineQtyLmt: to kick off 256665385903707101.

%% 2022-11-17 12:42:35.463 ; [LDBG] ; [954181376] ; LAN ; chkUsrOnlineQtyLmt: to kick 256665385903707101 out.

%% 2022-11-17 12:42:35.463 ; [LDBG] ; [954181376] ; UAM ; stopOneUsrAtNas: add attr acct_session_id:0000000420130125230551000005fc08100249.

%% 2022-11-17 12:42:35.463 ; [LDBG] ; [954181376] ; UAM ; stopOneUsrAtNas: The type is session-control, uam will send session-control kickout packet.

%% 2022-11-17 12:42:35.464 ; [LDBG] ; [954181376] ; UAM ; stopOneUsrAtNas: add attr acct_session_id:0000000420130125230551000005fc08100249.

%% 2022-11-17 12:42:35.464 ; [LDBG] ; [954181376] ; UAM ; stopOneUsrAtNas: The type is DM, uam will send DM kickout packet.

%% 2022-11-17 12:42:35.464 ; [LDBG] ; [954181376] ; LAN ; chkUsrOnlineQtyLmt: done to force kick user offline.

%% 2022-11-17 12:42:35.464 ; [LDBG] ; [954181376] ; lan ; recSessDetail: Begin.

%% 2022-11-17 12:42:35.464 ; [LDBG] ; [954181376] ; lan ; recSessDetail: End.

%% 2022-11-17 12:42:35.464 ; [WARN] ; [954181376] ; LAN ; stopOneUsrAtLocal: delete the online record(online-id 256665385903707101, user mali, mac 50:7B:9D:xx:xx:F9).

%% 2022-11-17 12:42:35.464 ; [LDBG] ; [954181376] ; UsrOnlineMgr ; delOnlineUsrInMem: 256665385903707101 has been deleted.

%% 2022-11-17 12:42:35.464 ; [LDBG] ; [954181376] ; UsrOnlineMgr ; delOnlineUsr: a db-del pushed.

%% 2022-11-17 12:42:35.475 ; [LDBG] ; [3514808064] ; LAN ; WXATW\mali ; 4 ; 2f0200a2d3ae4ea1baef3d3dc57a576e ;  ; Received message from 10.10.1.7:

CODE = 4 ID = 145.

       User-Name(1) = WXATW\mali

       Framed-Protocol(7) = 1.

       Called-Station-Id(30) = A0-69-D9-xx-xx-F2

       NAS-Port-Type(61) = 15.

       hw_IP_Host_Addr(60) = 0.0.0.0 50:7b:9d:xx:xx:f9

       H3C_NAS_PORT_NAME(230) = GigabitEthernet1/0/11

       NAS-Port(5) = 16822295.

       NAS-Port-Id(87) = slot=1;subslot=0;port=11;vlanid=23

       H3C_AVPair(210) = nas:ifindex=11

       Acct-Session-Id(44) = 0000000420130125230551000005fc08100249

       NAS-IP-Address(4) = 168427783.

       Calling-Station-Id(31) = 50-7B-9D-xx-xx-F9

       NAS-Identifier(32) = BG-1D-3F-01

       Class(25) = FpjcvBBt

       Acct-Terminate-Cause(49) = 6.

       H3C_USER_VLAN_ID(133) = 23.

       Acct-Session-Time(46) = 562.

       Acct-Authentic(45) = 1.

       Acct-Status-Type(40) = 2.

       Acct-Delay-Time(41) = 0.

       Event-Timestamp(55) = 1359155713.

       hw_Product_ID(255) = H3C S5130S-52P-EI

3.确认现场安装环境，现场是centos+mysql的部署环境； 而Mysql数据库的默认隔离级别是repeatable-read，这个隔离级别在一个事务中，直到事务结束前，都可以反复读取到事务刚开始时看到的数据，并一直不会发生变化，所以会导致前台下发修改消息后，后台加载时还是加载到修改之前的数据信息，也就是修改前的状态。 

参考EIA版本说明书的使用限制及操作说明解决： 

MySQL（MariaDB）数据库环境下，须将数据库的事务隔离级别设置为READ-COMMITTED。具体操作： 编辑数据库配置文件，查看[mysqld]配置下看是否有“transaction_isolation”配置项，如果没有则增加“transaction_isolation = READ-COMMITTED”，如果有则将配置项的值修改为“READ-COMMITTED”； 执行service mysqld restart(service mariadb restart)重启MySQL（MariaDB）服务。