Confluence : FIx space permissions via SQL

--General query select s.spacename,sp.*,s.* from SPACEPERMISSIONS sp, spaces s where 1=1 and s.spaceid = sp.spaceid order by 1,2 --Look up the exact space name select * from spaces --Check what permid range is available select * from SPACEPERMISSIONS where spaceid in (select spaceid from spaces where spacename = 'IT') order by 1 commit -- Add full permissions to the confluence-administrators group for a single space -- * Set the offest to a range which allows 14 rows to be added -- * Use either perm_groupname OR perm_username but not both -- * Replace anotheruser as appropriate insert into SPACEPERMISSIONS with target as ( select 3620 offset, 'confluence-administrators' perm_groupname, NULL perm_username, 'IT' spacename, 'anotheruser' audit_username from dual), ptypes as ( SELECT 'COMMENT' permtype from dual union all SELECT 'CREATEATTACHMENT' from dual union all SELECT 'EDITBLOG' from dual union all SELECT 'EDITSPACE' from dual union all SELECT 'EXPORTPAGE' from dual union all SELECT 'EXPORTSPACE' from dual union all SELECT 'REMOVEATTACHMENT' from dual union all SELECT 'REMOVEBLOG' from dual union all SELECT 'REMOVECOMMENT' from dual union all SELECT 'REMOVEMAIL' from dual union all SELECT 'REMOVEPAGE' from dual union all SELECT 'SETPAGEPERMISSIONS' from dual union all SELECT 'SETSPACEPERMISSIONS' from dual union all SELECT 'VIEWSPACE' from dual) select t.offset+rownum permid, s.spaceid, p.permtype, t.groupname permgroupname, t.perm_username permusername, t.audit_username creator, sysdate creationdate, t.audit_username lastmodifier, sysdate lastmoddate from target t, ptypes p, spaces s where t.spacename = s.spacename (+)

Keeping an SSH tunnel (passworded) running perniciously

* Download and compile sshpass and place in DIR http://sshpass.sourceforge.net/ * Create a script like this DIR=/? LOG=$DIR/ssh.log LOCAL_PORT=15000 REMOTE_SERVER=192.168.69.69 REMOTE_PORT=1521 echo "`date` - Restarting " >> $LOG export SSHPASS='PASSWORD' $DIR/sshpass -e ssh  $USERNAME@ $REMOTE_SERVER -L${LOCAL_PORT}:localhost:${REMOTE_PORT} -N -o ServerAliveInterval=30 -o TCPKeepAlive=yes -o ServerAliveCountMax=172800 echo "`date` - Ending " >> $LOG * Add the following to /etc/inittab - replace xxxx with a unique id, USER with the user to login as and and script.sh accordingly with full path xxxx:35:respawn:/bin/su - USER "/?/script.sh" * Get the init process to reload (as root) kill -HUP 1 * Test

Keeping Your SSH Sessions Alive Through Firewalls

To send a keep alive every 4 minutes either change ~/.ssh/config or /etc/ssh/ssh_config to add Host *         ServerAliveInterval 240

Windows : More RDP-related commands

Connect to a share to get an admin connections * net use /user:targetdomain\administrator \\targetmachine List Current Users on a machine * quser /server:targetmachine (shows session id - better as also shows login and idle time) * qwinsta /server:serverName Log a user off a machine * logoff sessionId /server:targetmachine<br />

Sharepoint - Where is the data hidden

SELECT TOP 1000 [tp_ID]       ,tp_author       ,tp_version       ,[datetime1]+8 x1       ,[datetime2]+7 x2       ,[datetime1]       ,[datetime2]       ,[nvarchar1]       ,[nvarchar2]       ,[nvarchar3]       ,[nvarchar4]       ,[nvarchar5]       ,[nvarchar6]       ,[nvarchar7]       ,[datetime3]       ,[datetime4]       ,[datetime5]       ,[int1]       ,[int2]       ,[int3]       ,[int4]       ,[int5]       ,[int6]   FROM [WSS_Content].[dbo].[AllUserData]   where 1=1   --and tp_ListId = 'DA7307B0-4D77-4DEE-A347-D183BE27CCC3'   and tp_DirName = 'hr/holidays/Lists/Absences'   and nvarchar5 = 'IT Development'   and tp_author = 51   and tp_ID = 709   order by datetime1 desc

Perl : One liner to find files less than an hour old in a dir

perl -e 'for ( glob "./*" ) { system "ls -l $_"  if ( -M $_ <= (1/24) ) };'

iTunes Error 9808

Itunes error -9808 logging into the iTunes Music Store In Internet Explorer, go up to Tools > Internet Options. Then go to the last tab, Advanced, and scroll down to the Security section. It is the fifth box down and make sure "Check for server certificate revocation (requires restart)" is unchecked. Then access the iTunes Store.