2013 – PODTECH

MYSQL

MYSQL Event Scheduler – Auto Enable

MYSQL Event Scheduler – Auto Enable If you are finding the MYSQL event scheduler is disabled everytime you start MYSQL, use the following my.cnf or mysql.ini settings; event_scheduler=on That Simple!!

Miscellaneous

VMware Network Settings – Difference of Bridged, NAT and Host-Only

Comparison of the network types Type Bridged NAT (Network Address Translation) Host-only Description The VM appears as if it was a physical host on the network. The VMware hides behind the IP address of the VMware host. Other VMs in the same NAT network can access it directly. The VM can only access the VMware […]

UNIX

Ubuntu – IPtables – redirect port to different IP

Ubuntu – IPtables – redirect port to different IP Read IP tables; iptables -t nat -L -n -v For redirecting port to different IP and port echo “1” > /proc/sys/net/ipv4/ip_forward Then, we will add a rule telling to forward the traffic on port 1111 to ip 2.2.2.2 on port 1111: # iptables -t […]

UNIX

Outlook Crash – IMAP 0xc0000005 – ISPCONFIG

Outlook Crash – IMAP 0xc0000005 – ISPCONFIG Outlook was crashing on startup every time it synced IMAP folders, not a problem in Thunderbird. This is my fix; Removing the empty first empty line from the files subscriptions and courierimapsubscribed fixes it in /var/vmail/MAILBOX/Maildir/

Miscellaneous

JQUERY setLocale Errors

A number of JQUERY plugins can throw up syntax errors after setting setlocale(“LC_ALL”,XXX.utf8) Make sure you change back the LC_NUMERIC variable; setlocale (LC_ALL, $language); setlocale(LC_NUMERIC, ‘C’);

Miscellaneous

Opt out of BT FON – BT Openzone

Opt out of BT FON – BT Openzone BT may activate your BT home hub to automatically become a BT openzone public hub!! Little do most people know that when you sign up to BT you are automatically opted IN to this service!!! Yes annoying. You can opt out … this link worked for me: […]

Miscellaneous

ALT- Code for international characters

Hold down the ALT key and type the numbers next to the character you need. German / deutsch Portuguese / português ä 132 Ä 142 à 133 À 0192 ö 148 Ö 153 á 0225 Á 0193 ü 129 Ü 154 â 131 Â 0194 ß 0223 ã 0227 Ã 0195 € […]

UNIX

Automatically find and re-attach to a detached screen session

Automatically find and re-attach to a detached screen session SCREEN -RR OR SCREEN -X SCREEN -R ……

UNIX

Extract CREATES from SQL dump

Extract CREATES from SQL dump If you are trying to extract the create routines from a SQL dump, this might help you! Basically it picks out the contents between “CREATE” and “\;” You can modify these two variables as need be.. [bash] cat dump.sql |awk ‘/CREATE/,/\;/ { print $0 ; }’ > create.sql […]

Perl

Perl – Fork and Kill a System Process on Timeout

Perl – Fork and Kill a System Process on Timeout [perl] $pid = open(PIPE, “$command |”) or die $!; eval { local $SIG{ALRM} = sub { die “TIMEOUT” }; alarm($timeout); while (<PIPE>) { $data = $_; }; close(PIPE); alarm(0); }; if ($@) { die $@ unless $@ =~ /TIMEOUT/; kill 15, $pid; close(PIPE); $? ||= […]

Digital Agency

Business Advisor

Marketing Agency

Business Consultant

Investment Solutions

Digital Banking

Comming Soon

Year: 2013

MYSQL Event Scheduler – Auto Enable

VMware Network Settings – Difference of Bridged, NAT and Host-Only

Ubuntu – IPtables – redirect port to different IP

Outlook Crash – IMAP 0xc0000005 – ISPCONFIG

JQUERY setLocale Errors

Opt out of BT FON – BT Openzone

ALT- Code for international characters

Automatically find and re-attach to a detached screen session

Extract CREATES from SQL dump

Perl – Fork and Kill a System Process on Timeout

Feel Free to Contact Us! We’re Ready to Help Business

Email Addrss

About Company

Main Office

Branch Office

Archives

Categories

Contact Info

Follow Us