Thursday, September 20, 2012

SunRay VPN password not stored

1) Power cycling by using keys [Stop] [A] or [Control] [Qt moon]  clears
user's VPN password in firmware.

Answer:  The firmware has an security enchancement so now the DTU pays attention to the VPN gateway setting to disallow stored password.
So you have to change the gateway setting if you still want the password in the DTU.


http://permalink.gmane.org/gmane.os.solaris.sunray/13528


So, on your Cisco VPN appliance, go to Network (Client) Access -> Group policies, Edit the group, Advanced -> IPSec Client -> Store Password on Client System and select Enable.

Friday, September 7, 2012

Another SQL query for dcm4chee


Like a previous one, useful to discover files with full path owned by a study.
SIUID = study instance uid

SELECT concat(filesystem.dirpath,'/', files.filepath)
FROM series
JOIN study ON series.study_fk = study.pk
JOIN patient ON study.patient_fk = patient.pk
JOIN instance ON instance.series_fk = series.pk
JOIN files ON instance.pk = files.instance_fk
JOIN filesystem ON files.filesystem_fk = filesystem.pk
WHERE study.study_iuid = '$SIUID';