Tag: update

MySQL

Create trigger to update new field value before insertion

Let’s create a new MySQL trigger to update a new field value before insertion. The new value will be selected from another table. DELIMITER $$   CREATE TRIGGER trig_new_customer BEFORE INSERT ON customers FOR EACH ROW BEGIN DECLARE var1 VARCHAR(7); SELECT customer_next_code INTO var1 FROM next_codes; SET NEW.code = var1; END $$   DELIMITER ;DELIMITER …

Backtrack

Upgrade from BackTrack 5 R2 to BackTrack 5 R3

1. Execute apt-get update && apt-get dist-upgradeapt-get update && apt-get dist-upgrade to make sure that your system is fully updated. 2. Install new tools 32 bit tools apt-get install libcrafter blueranger dbd inundator intersect mercury cutycapt trixd00r artemisa rifiuti2 netgear-telnetenable jboss-autopwn deblaze sakis3g voiphoney apache-users phrasendrescher kautilya manglefizz rainbowcrack rainbowcrack-mt lynis-audit spooftooph wifihoney twofi truecrack …

Backtrack, Metasploit

Metasploit update problem in Backtrack 5 R2

Error: svn: /opt/metasploit/common/lib/libssl.so.0.9.8: no version information available (required by /opt/metasploit/common/lib/libserf-0.so.0) svn: /opt/metasploit/common/lib/libcrypto.so.0.9.8: no version information available (required by /opt/metasploit/common/lib/libserf-0.so.0) Fix: Issue the following commands cd /opt/metasploit/common/libcd /opt/metasploit/common/lib mv libcrypto.so.0.9.8 libcrypto.so.0.9.8-backupmv libcrypto.so.0.9.8 libcrypto.so.0.9.8-backup mv libssl.so.0.9.8 libssl.so.0.9.8-backupmv libssl.so.0.9.8 libssl.so.0.9.8-backup ln -s /usr/lib/libcrypto.so.0.9.8ln -s /usr/lib/libcrypto.so.0.9.8 ln -s /usr/lib/libssl.so.0.9.8ln -s /usr/lib/libssl.so.0.9.8 msfupdatemsfupdate