def get_terminal_status(self, terminal_id): status = GFCode.SUCCESS terminal_fd = None address_key = get_terminal_address_key(terminal_id) terminal_fd = self.redis.getvalue(address_key) #if (not terminal_fd or terminal_fd == DUMMY_FD): # terminal = self.db.get("SELECT id FROM T_TERMINAL_INFO" # " WHERE tid = %s", # terminal_id) # if terminal: # status = GFCode.TERMINAL_OFFLINE # self.db.execute("UPDATE T_TERMINAL_INFO" # " SET login = %s" # " WHERE id = %s", # TERMINAL_LOGIN.OFFLINE, terminal.id) # terminal_sessionID_key = get_terminal_sessionID_key(terminal_id) # terminal_status_key = get_terminal_address_key(terminal_id) # keys = [terminal_sessionID_key, terminal_status_key] # self.redis.delete(*keys) # terminal_info_key = get_terminal_info_key(terminal_id) # terminal_info = self.redis.getvalue(terminal_info_key) # if terminal_info: # terminal_info['login'] = TERMINAL_LOGIN.OFFLINE # terminal_info = dict(terminal_info) # self.redis.set(terminal_info_key, terminal_info) # else: # status = GFCode.GF_NOT_ORDERED return terminal_fd, status
def update_terminal_status(redis, dev_id, address, is_sleep=False): """Keep the latest address of termianl in redis. """ terminal_status_key = get_terminal_address_key(dev_id) lq_interval_key = get_lq_interval_key(dev_id) is_lq = redis.getvalue(lq_interval_key) if is_sleep: redis.delete(lq_interval_key) is_lq = False if is_lq and not is_sleep: redis.setvalue(terminal_status_key, address, 10 * HEARTBEAT_INTERVAL) else: redis.setvalue(terminal_status_key, address, (1 * SLEEP_HEARTBEAT_INTERVAL + 300))
def post(self, tmobile, service_status): status = ErrorCode.SUCCESS try: terminal = self.db.get("SELECT id, tid FROM T_TERMINAL_INFO" " WHERE mobile = %s", tmobile) self.db.execute("UPDATE T_TERMINAL_INFO" " SET service_status = %s" " WHERE id = %s", service_status, terminal.id) # clear redis sessionID_key = get_terminal_sessionID_key(terminal.tid) address_key = get_terminal_address_key(terminal.tid) info_key = get_terminal_info_key(terminal.tid) lq_sms_key = get_lq_sms_key(terminal.tid) lq_interval_key = get_lq_interval_key(terminal.tid) keys = [sessionID_key, address_key, info_key, lq_sms_key, lq_interval_key] self.redis.delete(*keys) except Exception as e: status = ErrorCode.FAILED logging.exception("[ADMIN] Update service_status to %s failed." " tmobile: %s, Exception: %s", service_status, tmobile, e.args) self.write_ret(status)
def handle_old_login(t_info, address, connection, channel, exchange, gw_binding, db, redis): """ S1 Login response packet: 0 - success, then get a sessionID for terminal and record terminal's address 1 - illegal format of sim 2 - expired, service stop or endtime < now 3 - illegal sim, a mismatch between imsi and sim 4 - psd wrong. HK 5 - dev_id is empty 6 - not whitelist """ sms = None args = DotDict(success=GATEWAY.LOGIN_STATUS.SUCCESS, sessionID='') dev_id = t_info['dev_id'] resend_key, resend_flag = get_resend_flag(redis, dev_id, t_info.timestamp, t_info.command) logging.info("[GW] Checking terminal mobile: %s and owner mobile: %s, Terminal: %s", t_info['t_msisdn'], t_info['u_msisdn'], t_info['dev_id']) if not (check_phone(t_info['u_msisdn']) and check_phone(t_info['t_msisdn'])): args.success = GATEWAY.LOGIN_STATUS.ILLEGAL_SIM lc = LoginRespComposer(args) request = DotDict(packet=lc.buf, address=address, dev_id=t_info["dev_id"]) append_gw_request(request, connection, channel, exchange, gw_binding) logging.error("[GW] Login failed! Invalid terminal mobile: %s or owner_mobile: %s, dev_id: %s", t_info['t_msisdn'], t_info['u_msisdn'], t_info['dev_id']) return t_status = db.get("SELECT service_status" " FROM T_TERMINAL_INFO" " WHERE mobile = %s", t_info['t_msisdn']) if t_status and t_status.service_status == GATEWAY.SERVICE_STATUS.OFF: args.success = GATEWAY.LOGIN_STATUS.EXPIRED lc = LoginRespComposer(args) request = DotDict(packet=lc.buf, address=address, dev_id=t_info["dev_id"]) append_gw_request(request, connection, channel, exchange, gw_binding) logging.error("[GW] Login failed! terminal service expired! mobile: %s, dev_id: %s", t_info['t_msisdn'], t_info['dev_id']) return logging.info("[GW] Checking imsi: %s and mobile: %s, Terminal: %s", t_info['imsi'], t_info['t_msisdn'], t_info['dev_id']) tmobile = db.get("SELECT imsi FROM T_TERMINAL_INFO" " WHERE mobile = %s", t_info['t_msisdn']) if tmobile and tmobile.imsi and tmobile.imsi != t_info['imsi']: # check terminal and give a appropriate HK notification terminal = db.get("SELECT id FROM T_TERMINAL_INFO WHERE tid=%s", t_info['dev_id']) if terminal: alias = QueryHelper.get_alias_by_tid(t_info['dev_id'], redis, db) else: alias = t_info['t_msisdn'] args.success = GATEWAY.LOGIN_STATUS.ILLEGAL_SIM sms = SMSCode.SMS_TERMINAL_HK % alias SMSHelper.send(t_info['u_msisdn'], sms) lc = LoginRespComposer(args) request = DotDict(packet=lc.buf, address=address, dev_id=t_info["dev_id"]) append_gw_request(request, connection, channel, exchange, gw_binding) logging.error("[GW] Login failed! Illegal SIM: %s for Terminal: %s", t_info['t_msisdn'], t_info['dev_id']) return terminal = db.get("SELECT id, mobile, owner_mobile, service_status" " FROM T_TERMINAL_INFO" " WHERE tid = %s", t_info['dev_id']) if terminal: if terminal.mobile != t_info['t_msisdn']: logging.info("[GW] Terminal: %s changed mobile, old mobile: %s, new mobile: %s", t_info['dev_id'], terminal.mobile, t_info['t_msisdn']) if (terminal.owner_mobile == t_info['u_msisdn'] or terminal.service_status == UWEB.SERVICE_STATUS.TO_BE_UNBIND): # delete old terminal! logging.info("[GW] Delete old tid bind relation. tid: %s, owner_mobile: %s, service_status: %s", t_info['dev_id'], t_info['u_msisdn'], terminal.service_status) delete_terminal_new(t_info['dev_id'], db, redis, del_user=False) exist = db.get("SELECT tid, owner_mobile, service_status FROM T_TERMINAL_INFO" " WHERE mobile = %s LIMIT 1", t_info['t_msisdn']) if exist: # cannot send unbind packet to dev_id t_status = None logging.info("[GW] Delete old tmobile bind relation. tid: %s, mobile: %s", exist.tid, t_info['t_msisdn']) delete_terminal_new(exist.tid, db, redis, del_user=False) if exist.service_status == UWEB.SERVICE_STATUS.TO_BE_UNBIND: logging.info("[GW] Terminal: %s of %s is to_be_unbind, delete it.", exist.tid, t_info['t_msisdn']) elif exist.owner_mobile != t_info['u_msisdn']: sms = SMSCode.SMS_DELETE_TERMINAL % t_info['t_msisdn'] SMSHelper.send(exist.owner_mobile, sms) terminal = None else: args.success = GATEWAY.LOGIN_STATUS.ILLEGAL_SIM sms = SMSCode.SMS_TID_EXIST % t_info['dev_id'] SMSHelper.send(t_info['u_msisdn'], sms) lc = LoginRespComposer(args) request = DotDict(packet=lc.buf, address=address, dev_id=t_info["dev_id"]) append_gw_request(request, connection, channel, exchange, gw_binding) logging.error("[GW] Login failed! Terminal: %s already bound by %s, new mobile: %s", t_info['dev_id'], terminal.mobile, t_info['t_msisdn']) return #NOTE: Check ydcw or ajt ajt = QueryHelper.get_ajt_whitelist_by_mobile(t_info['t_msisdn'], db) if ajt: url_out = ConfHelper.UWEB_CONF.ajt_url_out else: url_out = ConfHelper.UWEB_CONF.url_out logging.info("[GW] Terminal: %s, login url is: %s", t_info['t_msisdn'], url_out) if t_info['psd']: flag = 0 # check terminal exist or not when HK if not terminal: args.success = GATEWAY.LOGIN_STATUS.UNREGISTER sms = SMSCode.SMS_TID_NOT_EXIST SMSHelper.send(t_info['u_msisdn'], sms) lc = LoginRespComposer(args) request = DotDict(packet=lc.buf, address=address, dev_id=t_info["dev_id"]) append_gw_request(request, connection, channel, exchange, gw_binding) logging.error("[GW] Login failed! Terminal %s execute HK, but tid is not exist", t_info['dev_id']) return # HK, change terminal mobile or owner mobile logging.info("[GW] Checking password. Terminal: %s", t_info['dev_id']) owner = db.get("SELECT id FROM T_USER" " WHERE mobile = %s" " AND password = password(%s)", terminal.owner_mobile, t_info['psd']) if not owner: # psd wrong sms = SMSCode.SMS_PSD_WRONG args.success = GATEWAY.LOGIN_STATUS.PSD_WRONG logging.error("[GW] Login failed! Password invalid. Terminal: %s", t_info['dev_id']) else: if terminal: if terminal.mobile != t_info['t_msisdn']: # terminal HK logging.info("[GW] Terminal: %s HK started.", t_info['dev_id']) # unbind old tmobile old_bind = db.get("SELECT id, tid FROM T_TERMINAL_INFO" " WHERE mobile = %s" " AND id != %s", t_info['t_msisdn'], terminal.id) if old_bind: # clear db db.execute("DELETE FROM T_TERMINAL_INFO" " WHERE id = %s", old_bind.id) # clear redis sessionID_key = get_terminal_sessionID_key(old_bind.tid) address_key = get_terminal_address_key(old_bind.tid) info_key = get_terminal_info_key(old_bind.tid) lq_sms_key = get_lq_sms_key(old_bind.tid) lq_interval_key = get_lq_interval_key(old_bind.tid) keys = [sessionID_key, address_key, info_key, lq_sms_key, lq_interval_key] redis.delete(*keys) logging.info("[GW] Delete old bind Terminal: %s, SIM: %s", t_info['dev_id'], t_info['t_msisdn']) # update new tmobile db.execute("UPDATE T_TERMINAL_INFO" " SET mobile = %s," " imsi = %s" " WHERE id = %s", t_info['t_msisdn'], t_info['imsi'], terminal.id) # clear redis sessionID_key = get_terminal_sessionID_key(t_info['dev_id']) address_key = get_terminal_address_key(t_info['dev_id']) info_key = get_terminal_info_key(t_info['dev_id']) lq_sms_key = get_lq_sms_key(t_info['dev_id']) lq_interval_key = get_lq_interval_key(t_info['dev_id']) keys = [sessionID_key, address_key, info_key, lq_sms_key, lq_interval_key] redis.delete(*keys) # HK sms sms = SMSCode.SMS_TERMINAL_HK_SUCCESS % (terminal.mobile, t_info['t_msisdn']) # subscription LE for new sim thread.start_new_thread(subscription_lbmp, (t_info,)) logging.info("[GW] Terminal: %s HK success!", t_info['dev_id']) if terminal.owner_mobile != t_info['u_msisdn']: logging.info("[GW] Owner HK started. Terminal: %s", t_info['dev_id']) # owner HK user = db.get("SELECT id FROM T_USER" " WHERE mobile = %s", t_info['u_msisdn']) if user: logging.info("[GW] Owner already existed. Terminal: %s", t_info['dev_id']) sms = SMSCode.SMS_USER_ADD_TERMINAL % (t_info['t_msisdn'], url_out) else: logging.info("[GW] Create new owner started. Terminal: %s", t_info['dev_id']) psd = get_psd() user_info = dict(umobile=t_info['u_msisdn'], password=psd) add_user(user_info, db, redis) sms = SMSCode.SMS_USER_HK_SUCCESS % (t_info['u_msisdn'], url_out, t_info['u_msisdn'], psd) db.execute("UPDATE T_TERMINAL_INFO" " SET owner_mobile = %s" " WHERE id = %s", t_info['u_msisdn'], terminal.id) logging.info("[GW] Owner of %s HK success!", t_info['dev_id']) else: logging.error("[GW] What happened? Cannot find old terminal by dev_id: %s", t_info['dev_id']) else: flag = 1 # login or JH if terminal: # login logging.info("[GW] Terminal: %s Normal login started!", t_info['dev_id']) else: # SMS JH or admin JH or change new dev JH logging.info("[GW] Terminal: %s, mobile: %s JH started.", t_info['dev_id'], t_info['t_msisdn']) exist = db.get("SELECT id FROM T_USER" " WHERE mobile = %s", t_info['u_msisdn']) if exist: logging.info("[GW] Owner already existed. Terminal: %s", t_info['dev_id']) sms = SMSCode.SMS_USER_ADD_TERMINAL % (t_info['t_msisdn'], url_out) else: # get a new psd for new user logging.info("[GW] Create new owner started. Terminal: %s", t_info['dev_id']) psd = get_psd() user_info = dict(umobile=t_info['u_msisdn'], password=psd, uname=t_info['u_msisdn']) add_user(user_info, db, redis) sms = SMSCode.SMS_JH_SUCCESS % (t_info['t_msisdn'], url_out, t_info['u_msisdn'], psd) admin_terminal = db.get("SELECT id, tid FROM T_TERMINAL_INFO" " WHERE tid = %s", t_info['t_msisdn']) if admin_terminal: # admin JH db.execute("UPDATE T_TERMINAL_INFO" " SET tid = %s," " dev_type = %s," " owner_mobile = %s," " imsi = %s," " imei = %s," " factory_name = %s," " keys_num = %s," " softversion = %s" " WHERE id = %s", t_info['dev_id'], t_info['dev_type'], t_info['u_msisdn'], t_info['imsi'], t_info['imei'], t_info['factory_name'], t_info['keys_num'], t_info['softversion'], admin_terminal.id) db.execute("UPDATE T_CAR SET tid = %s" " WHERE tid = %s", t_info['dev_id'], t_info['t_msisdn']) logging.info("[GW] Terminal %s by ADMIN JH success!", t_info['dev_id']) else: exist_terminal = db.get("SELECT id, tid FROM T_TERMINAL_INFO" " WHERE mobile = %s", t_info['t_msisdn']) if exist_terminal: # unbind old tmobile db.execute("DELETE FROM T_TERMINAL_INFO" " WHERE id = %s", exist_terminal.id) # clear redis sessionID_key = get_terminal_sessionID_key(exist_terminal.tid) address_key = get_terminal_address_key(exist_terminal.tid) info_key = get_terminal_info_key(exist_terminal.tid) lq_sms_key = get_lq_sms_key(exist_terminal.tid) lq_interval_key = get_lq_interval_key(exist_terminal.tid) keys = [sessionID_key, address_key, info_key, lq_sms_key, lq_interval_key] redis.delete(*keys) logging.info("[GW] Terminal %s change dev, old dev: %s!", t_info['dev_id'], exist_terminal.tid) # send JH sms to terminal. default active time # is one year. begintime = datetime.datetime.now() endtime = begintime + relativedelta(years=1) terminal_info = dict(tid=t_info['dev_id'], dev_type=t_info['dev_type'], tmobile=t_info['t_msisdn'], owner_mobile=t_info['u_msisdn'], imsi=t_info['imsi'], imei=t_info['imei'], factory_name=t_info['factory_name'], softversion=t_info['softversion'], keys_num=t_info['keys_num'], login=GATEWAY.TERMINAL_LOGIN.ONLINE, service_status=UWEB.SERVICE_STATUS.ON, group_id=-1, mannual_status=UWEB.DEFEND_STATUS.YES, begintime=int(time.mktime(begintime.timetuple())), endtime=4733481600, offline_time=int(time.mktime(begintime.timetuple())), biz_type=UWEB.BIZ_TYPE.YDWS) add_terminal(terminal_info, db, redis) # record the add action, enterprise or individual bind_info = dict(tid=t_info['dev_id'], tmobile=t_info['t_msisdn'], umobile=t_info['u_msisdn'], group_id=-1, cid='', add_time=int(time.time())) record_add_action(bind_info, db) logging.info("[GW] Terminal %s by SMS JH success!", t_info['dev_id']) # subscription LE for new sim thread.start_new_thread(subscription_lbmp, (t_info,)) if args.success == GATEWAY.LOGIN_STATUS.SUCCESS: # get SessionID if resend_flag: args.sessionID = QueryHelper.get_terminal_sessionID(t_info['dev_id'], redis) logging.warn("[GW] Recv resend login packet: %s and use old sessionID: %s!", t_info, args.sessionID) if not args.sessionID: args.sessionID = get_sessionID() else: args.sessionID = get_sessionID() terminal_sessionID_key = get_terminal_sessionID_key(t_info['dev_id']) redis.setvalue(terminal_sessionID_key, args.sessionID) redis.setvalue(resend_key, True, GATEWAY.RESEND_EXPIRY) # record terminal address update_terminal_status(redis, t_info["dev_id"], address) # set login info = DotDict(login=GATEWAY.TERMINAL_LOGIN.ONLINE, mobile=t_info['t_msisdn'], keys_num=t_info['keys_num'], login_time=int(time.time()), dev_id=t_info["dev_id"]) update_terminal_info(db, redis, info) logging.info("[GW] Terminal %s login success! SIM: %s", t_info['dev_id'], t_info['t_msisdn']) #NOTE: wspush to cient if flag != "1": # normal login WSPushHelper.pushS4(t_info["dev_id"], db, redis) else: # JH pass lc = LoginRespComposer(args) request = DotDict(packet=lc.buf, address=address, dev_id=t_info["dev_id"]) append_gw_request(request, connection, channel, exchange, gw_binding) if sms and t_info['u_msisdn']: SMSHelper.send(t_info['u_msisdn'], sms) # unbind terminal of to_be_unbind if t_status and t_status.service_status == UWEB.SERVICE_STATUS.TO_BE_UNBIND: logging.info("[GW] Terminal: %s is unbinded, send unbind packet.", t_info["dev_id"]) seq = str(int(time.time()*1000))[-4:] args = DotDict(seq=seq, tid=t_info["dev_id"]) ubc = UNBindComposer(args) request = DotDict(packet=ubc.buf, address=address, dev_id=t_info["dev_id"]) append_gw_request(request, connection, channel, exchange, gw_binding)