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)
