Group :: System/Servers
RPM: x2goserver
Main Changelog Spec Patches Sources Download Gear Bugs and FR Repocop
Patch: x2gopgwrapper_net.diff
Download
Download
--- x2goserver-2.0.1.orig/x2gopgwrapper_net
+++ x2goserver-2.0.1/x2gopgwrapper_net
@@ -9,19 +9,19 @@
case "$2" in
getdisplays)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select '|'||display||'|' from sessions where server = '$3';\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select '|'||display||'|' from sessions;\"|psql -t x2go_sessions"
;;
getports)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select '|'||port||'|' from used_ports where server = '$3';\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select '|'||port||'|' from used_ports;\"|psql -t x2go_sessions"
;;
getservers)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select server,count(*) from sessions where status != 'F' group by server;\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select server,count(*) from sessions where status != 'F' group by server;\"|psql -t x2go_sessions"
;;
listsessions)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select agent_pid, session_id, display, server, status,\
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select agent_pid, session_id, display, server, status,\
to_char(init_time,'DD.MM.YY*HH24:MI:SS'),cookie,client,gr_port,\
sound_port,to_char(last_time,'DD.MM.YY*HH24:MI:SS'),uname,\
to_char(now()-init_time,'SSSS') from sessions \
@@ -34,66 +34,124 @@
echo "$UNAME, You have not permission to do this job!"
exit
fi
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select agent_pid, session_id, display, server, status,\
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select agent_pid, session_id, display, server, status,\
to_char(init_time,'DD.MM.YY*HH24:MI:SS'),cookie,client,gr_port,\
sound_port,to_char(last_time,'DD.MM.YY*HH24:MI:SS'),uname,\
to_char(now()-init_time,'SSSS') from sessions \
where server='$3' order by status desc;\"|psql -t x2go_sessions"
;;
+listsusp)
+ if [ "$UNAME" != "root" ]
+ then
+ echo "$UNAME, You have not permission to do this job!"
+ exit
+ fi
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select session_id, display, uname, server,extract( day from now()-last_time)*24*60+extract(hour from now()-last_time)*60+extract(minute from now()-last_time)\
+ from sessions where server='$3' and status='S';\"|psql -t x2go_sessions"
+ ;;
+
+
+listallrunning)
+ if [ "$UNAME" != "root" ]
+ then
+ echo "$UNAME, You have not permission to do this job!"
+ exit
+ fi
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select agent_pid, session_id, display, server, status,\
+ to_char(init_time,'DD.MM.YY*HH24:MI:SS'),cookie,client,gr_port,\
+ sound_port,to_char(last_time,'DD.MM.YY*HH24:MI:SS'),uname,\
+ to_char(now()-init_time,'SSSS') from sessions \
+ where status='R';\"|psql -t x2go_sessions"
+ ;;
+
+listmails)
+ if [ "$UNAME" != "root" ]
+ then
+ echo "$UNAME, You have not permission to do this job!"
+ exit
+ fi
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select user_messages.mess_id,sessions.session_id,\
+ sessions.uname,sessions.display from sessions,user_messages,\
+ messages where sessions.uname=user_messages.uname and sessions.status!='F'\
+ and messages.mess_id=user_messages.mess_id and sessions.server='$3';\"|psql -t x2go_sessions"
+ ;;
+
+getmail)
+ if [ "$UNAME" != "root" ]
+ then
+ echo "$UNAME, You have not permission to do this job!"
+ exit
+ fi
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select message\
+ from messages where mess_id='$3';\"|psql -t x2go_sessions"
+ ;;
+
+
+rmmail)
+ if [ "$UNAME" != "root" ]
+ then
+ echo "$UNAME, You have not permission to do this job!"
+ exit
+ fi
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"delete from \
+ user_messages where mess_id='$3' and uname='$4';\"|psql -t x2go_sessions"
+ ;;
+
+
rmsessionsroot)
if [ "$UNAME" != "root" ]
then
echo "$UNAME, You have not permission to do this job!"
exit
fi
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"delete from sessions \
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"delete from sessions \
where session_id='$3' ;\"|psql -t x2go_sessions"
;;
getagent)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select agent_pid from sessions where session_id = '$3';\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select agent_pid from sessions where session_id = '$3';\"|psql -t x2go_sessions"
;;
getdisplay)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select display from sessions where session_id = '$3';\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select display from sessions where session_id = '$3';\"|psql -t x2go_sessions"
;;
changestatus)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"update sessions set last_time=now(),status='$3' where session_id = '$4' and uname='$UNAME';\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"update sessions set last_time=now(),status='$3' where session_id = '$4' and uname='$UNAME';\"|psql -t x2go_sessions"
;;
resume)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"update sessions set last_time=now(),status='R',client='$3' where session_id = '$4' and uname='$UNAME';\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"update sessions set last_time=now(),status='R',client='$3' where session_id = '$4' and uname='$UNAME';\"|psql -t x2go_sessions"
;;
insertsession)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"insert into sessions (display,server,uname,session_id) values \
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"insert into sessions (display,server,uname,session_id) values \
('$3','$4','$UNAME','$5');\"|psql x2go_sessions"
;;
createsession)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"update sessions set status='R',last_time=now(),cookie='$3',agent_pid='$4',\
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"update sessions set status='R',last_time=now(),cookie='$3',agent_pid='$4',\
client='$5',gr_port='$6',sound_port='$7' where session_id='$8' and uname='$UNAME';\"|psql x2go_sessions"
;;
insertport)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"insert into used_ports (server,session_id,port) values \
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"insert into used_ports (server,session_id,port) values \
('$3','$4','$5');\"|psql x2go_sessions"
;;
insertmount)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"insert into mounts (session_id,path,client) values \
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"insert into mounts (session_id,path,client) values \
('$3','$4','$5');\"|psql x2go_sessions"
;;
deletemount)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"delete from mounts where session_id='$3' and path='$4';\"|psql x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"delete from mounts where session_id='$3' and path='$4';\"|psql x2go_sessions"
;;
getmounts)
- ssh -i ~postgres/.ssh/id_dsa postgres@$SERVER "echo \"select client,path from mounts where session_id = '$3';\"|psql -t x2go_sessions"
+ ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@$SERVER "echo \"select client,path from mounts where session_id = '$3';\"|psql -t x2go_sessions"
;;
*)