surveillance station cannot add license connection failed

[mrhappydude]

I tried to register my purchased camera keys in the new version running TinyCore RedPill Loader and I got this error, cannot add license connection failed.  I tried a bunch of times with all the suggestions I could, even installed this hack Kaitiz / Surveillance-Station-9 and it worked but could not run the latest version it would fail every hour or so.

 

I did come up with my own hack per se that allowed me to transfer my real licenses to my new server.  I hope this helps someone else.

 

Old Server
----------
putty ssh to synology server ip
user: admin
password: admin
oldSynology> cd /volume1/@appstore/SurveillanceStation/
oldSynology> sqlite3
sqlite> .open system.db
sqlite> .tables
account                  guard                    nvrlayout
actionrule               guardSchedule            nvrlayoutchannel
actionrulemultirule      iomodule                 patrol
alertsettings            iomoduleiosetting        patrolPresetData
audiopattern             iomodulestatus           preset
autoupdateid             joystick                 privilege
camdetsetting            layout                   privilegepercamera
camdeviceoutput          layoutcamera             privilegeprofile
camera                   licensekey               privilegeprofilecam
cameragroup              localdisplayinfo         recordingshare
cameragroupcam           localdisplayuser         slaveds
camerastatus             migration                smsprovider
edgestoragesettings      motion                   ssgeneric
emap                     notification             sswebinfo
emapItem                 notificationfilter       visualstation
eventexport              notificationpushservice  vslayout
eventmount               notificationsms          vslayoutchannel
fisheyeregion            nvrconfig
sqlite> .headers on
sqlite> .mode column
sqlite> select * from licensekey;
id          camera_count  key                                  serial                    owner_ds_id  install_date  is_restored  expired_date  activated   id_on_rec
----------  ------------  -----------------------------------  ------------------------  -----------  ------------  -----------  ------------  ----------  ------------------------
1                         KEYKEYKEYKEYKEYKEYKEYKEYKEYKEYKEYKE  SERIALSERIALSERIALSERIAL  0            0                                                    9l/999999+s+udDO9y9w==

New Server
----------
open a new putty session
putty ssh to new synology server ip
user: your account you setup
password: your password
newSynology> sudo -i (Enter same Password)
newSynology> cd /volume1/@appstore/SurveillanceStation/
newSynology> sqlite3
sqlite> .open system.db
sqlite> .tables
account                      iva_setting
accountActivity              iva_task_group
actionrule                   joystick
actionruleevent              layout
actionrulemultirule          layoutcamera
alertsettings                layoutgroup
audiopattern                 licensekey
autoupdateid                 localdisplayinfo
c2camera                     localdisplayuser
c2plan                       log_rotate_settings
c2planinfo                   logadvanced
c2subscription               logininfo
cam_customdet_extdevice      migration
cam_disconnect_info          mobiles
camdetsetting                motion
camdeviceoutput              notification
camera                       notificationadvance
camera_integration           notificationevent
camera_udc                   notificationfilter
cameragroup                  notificationpushservice
cameragroupcam               notificationsms
camerastatus                 nvrconfig
cms_server_udc               nvrlayout
disk_udc                     nvrlayoutchannel
edgestoragesettings          patrol
emap                         patrolPresetData
emapItem                     preset
emapgroup                    privilege
emapgroupitem                privilegepercamera
emapregionvertex             privilegeperdoor
eventexport                  privilegeprofile
eventlabelsetting            privilegeprofilecam
eventmount                   pushservicetargetid
face_setting                 recordingshare
failoversetting              sharedfolderstorage
fisheyeregion                slaveds
geomapfavorview              smsprovider
geomapitem                   snapshotadvance
groupaccount                 ssgeneric
guard                        sswebinfo
guardSchedule                synocam_info_udc
homemode_rec_custom_app_det  syslog_settings
homemodenotifyfilter         systemwisesetting
homemodesetting              useradvance
iomodule                     vslogininfo
iomodulecampairing           watermark
iomoduleiosetting            youtubelive
iomodulestatus
sqlite> .headers on
sqlite> .mode column
sqlite> insert into licensekey (id, camera_count, key, serial, owner_ds_id, install_date, is_restored, expired_date, id_on_rec, activated)
..>     values (1,null,'KEYKEYKEYKEYKEYKEYKEYKEYKEYKEYKEYKE','SERIALSERIALSERIALSERIAL',0,0,'','','9l/999999+s+udDO9y9w==','');
sqlite> select * from licensekey;
id          camera_count  key                                  serial                    owner_ds_id  install_date  is_restored  expired_date  activated   id_on_rec
----------  ------------  -----------------------------------  ------------------------  -----------  ------------  -----------  ------------  ----------  ------------------------
1                         KEYKEYKEYKEYKEYKEYKEYKEYKEYKEYKEYKE  SERIALSERIALSERIALSERIAL  0            0                                                    9l/999999+s+udDO9y9w==
CTRL+D to exit

 

Edited December 9, 2023 by mrhappydude