Unlock HLR user

1. login into SQL server

select database "ReportServer"

then create new SQL script

Paste SQL command as below

list username who password password locked
select
    UserName,
    IsAnonymous,
    LastActivityDate,
    IsApproved,
    IsLockedOut,
    FailedPasswordAttemptCount
from dbo.aspnet_Users u
    inner join dbo.aspnet_Membership m on u.UserId = m.UserId
where IsLockedOut = '1'


for unlock server
update dbo.aspnet_Membership set FailedPasswordAttemptCount = 0,IsLockedOut=0
where UserId in (select UserId from dbo.aspnet_Users where UserName = 'USER_NAME')


Delete HLR user

first you need to VNC. You can follow VNC to VAS

then go to Start -> All Promgaram -> Micros -> Microsoft Viasual Studio 2005 - > Microsoft Visual studio 2005

then click on File->Open->Web site...

open web project in folder "D:\Appication\source\hlr-proj

open login.aspx

click "design"

open Administrator Webside

after web administrator open click tab "Security"

for create new HLR user just click "Manage user"

then find user that you need to delete and then click link "Delete user"

Click "Yes" to confirm delete

Create new HLR user

first you need to VNC. You can follow VNC to VAS

then go to Start -> All Promgaram -> Micros -> Microsoft Viasual Studio 2005 - > Microsoft Visual studio 2005

then click on File->Open->Web site...

open web project in folder "D:\Appication\source\hlr-proj

open login.aspx

click "design"

open Administrator Webside

after web administrator open click tab "Security"

for create new HLR user just click "Create user"

then fill all information then click button "Create User"

create new HLR user success

VNC to VAS-APP1

1. open program Run VNC Viewver

2. type Server to 192.168.150.247 then click button OK

3. type password to login aVNC then click button OK

4. remote hot will open then right-click on title bar and select send Ctrl+Alt+Del
5. type username and password  and then click button OK to access.

Smap check user information

 login to SMAP first
then go to Individual then Query->Accumulator

input number Ex: 207xxxxxxx or 307xxxxxx then click query

then have tab

 

1. Customer Information: owner number information.
2. Subscriber Information: phone number information.
3. Account Information:
4. Balance Record List: list all balance this number have + expire date
5. Service List: all available service this number have.
6.Product List: show manual and auto subscribe product
7. CUG
8. Accumulative Amout

Welcome to Web SMAP

link http://192.168.151.13:7772/frameset/login.action?loginLocale=en

 

1. type username.

2. type password.

3. input verification code

4. click login

Create service Radio sms

If no short code yet.
1. Tell Mr. khamhoung to create shortcode tariff MO 500 kip/sms, MT free.
MO 500 kip/sms => customer send to short code deduct 500 kip/ sms.
MT free => short code send to customer free.
2. Tell Mr. phokham route short code to service VASAPP

if already have short code
Step 1: Create short code service
1. Go to data base mysql http://192.168.150.251/phpmyadmin/
2. Login user: root password r*** and then click Go

3. Select data base "getting"

4. Select table "service"

5. Click "Insert" and input data

serv_name:
date:
shortcode:
username:
password:
then click Go




Step 2: Route short code to script
we store script to get sms in
192.168.150.251/vasapp/getting/sms_getting.php


1. Login to 192.168.150.244 (proxy)
2. Open script  on /var/www/gateway/sms_center.php and modify script 2 point

check short code

route short code

Step 3: login web report
1. follow link to login http://fun.beeline.la/beebox/

 

after login