Skip to main content ↑ ↓

Messages

This section allows you to view all Messages made by this member. Note that you can only see Messages made in areas you currently have access to.

Messages - tino

10
PostgreSQL / Re: MISC Queries
Show running queries (9.2)

Code: [Select]
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

kill running query
Code: [Select]
SELECT pg_cancel_backend(procpid);

Kill idle query
Code: [Select]
SELECT pg_terminate_backend(procpid);
11
PostgreSQL / MISC Queries
Compare two rows

Code: [Select]
SELECT T1.log_dt, T2.log_dt, EXTRACT(EPOCH FROM (T2.log_dt - T1.log_dt))
FROM power_data AS T1
INNER JOIN power_data  AS T2
	USING ( node )
WHERE T1.log_dt > '2017-05-05 22:10:00'
AND T2.log_dt > '2017-05-05 22:10:00'
ORDER BY T1.id, T2.id
LIMIT 2
13
PHP Code / Lazy Load Class
Code: [Select]
class MyClass {
    public function __construct() {
        echo 'I am initialized!';
    }
}

$getMyClass = function() {
    $myClass = new MyClass();
    return $myClass;
};


Code: [Select]
$myClass = $getMyClass();
14
Tutorials / Postfix call script via bcc
Code: [Select]
vim /etc/postfix/master.cf

Add the following
Code: [Select]
  -o receive_override_options=no_address_mappings

Just below the
Code: [Select]
smtp      inet  n       -       -       -       -       smtpd

Setup the recipient bcc

Code: [Select]
vim /etc/postfix/recipient_bcc

Add the following as appropriate

Code: [Select]
upload@tinoest.co.uk upload-script@localhost

Run postmap so postfix can read it.

Code: [Select]
 postmap /etc/postfix/recipient_bcc


Setup the transport

Code: [Select]
vim /etc/postfix/transport

Add the following as appropriate

Code: [Select]
upload-script@localhost :

Run postmap so postfix can read it.

Code: [Select]
 postmap /etc/postfix/transport

edit the main.cf

Code: [Select]
 vim /etc/postfix/main.cf

Add the following:

Code: [Select]
recipient_bcc_maps = hash:/etc/postfix/recipient_bcc
transport_maps = hash:/etc/postfix/transport


Also ensure that localhost is in the mydestination list

Edit the /etc/aliases file

Code: [Select]
vim /etc/aliases

Add the following, to point to the relevant file you wish to parse the data

Code: [Select]
upload-script: "|/usr/bin/postfix-parse"




Then restart postfix

Code: [Select]
systemcntl restart postfix
15
Tutorials / LTSP Debian Jessie Install
Install the required files

Code: [Select]
apt-get install ltsp-server dnsmasq

Build the client

Code: [Select]
ltsp-build-client --arch i386

Edit the exports file

Code: [Select]
vim  /etc/exports

Add the following to the bottom

Code: [Select]
/opt/ltsp       *(ro,no_root_squash,async,no_subtree_check)

Restart the Service

Code: [Select]
invoke-rc.d nfs-kernel-server reload

Just to be sure...

Code: [Select]
service nfs-kernel-server restart

Create the DNS masq files

Code: [Select]
ltsp-config dnsmasq

Amend one of the created files

Code: [Select]
vim /opt/ltsp/i386/etc/ltsp/update-kernels.conf

Change the following line:

Code: [Select]
CMDLINE_NFS="root=/dev/nfs ip=dhcp boot=nfs"

To

Code: [Select]
CMDLINE_NFS="root=/dev/nfs ip=dhcp boot=nfs nfsroot=/opt/ltsp/i386"
IPAPPEND=3

Update everything.

Code: [Select]

ltsp-chroot /usr/share/ltsp/update-kernels

ltsp-update-kernels