Linux on the desktop as a web developer
A breif look at the tools you need as a web developer in 2020, running Linux on the desktop as a web developer. OSX is my os of choice, but…
Defending Against Injection Attacks Through Context-Sensitive String Evaluation
300 word summary: What is the paper about? Defending Against Injection Attacks Through Context-Sensitive String Evaluation introduces CSSE - Context-Sensitive String Evaluation - a way to detect sqlI in php at…
AMNESIA: Analysis and Monitoring for NEutralizing SQL-Injection Attacks
300 word summary: AMNESIA: analysis and monitoring for NEutralizing SQL-injection attacks. Provides a valuable background section on the countermeasures for SQL injection attacks: Defensive ProgrammingGeneral Techniques against SQLiStatic Analysis techniques…
Evaluation of SQL injection testing tools and techniques
My MSc Thesis in 2016 was titled Evaluation of SQL injection testing tools and techniques. I had a quick look through all my old uni work looking for content to…
sql injection attack types – a list of sqli types and papers
My research notes about the different types of sqli - sql injection attack types; inband (eg reading errors from the screen) out-of-band (getting information from a different channel eg from…
Coding in php on android
It turns out that coding in php on android is possible (even if its not as good as on a mac, linux or even windows). In this blog post I'll…
Installing mariadb 10.2 mysql 5.7 in centos
Installing mariadb 10.2 mysql 5.7 in centos If you use the following method to install the latest mariadb, updates will be installed with the regular yum update commands! The first…
MSc Thesis
Ive completed my MSc Thesis! I was awarded a grade A (81%) and an MSc with distinction :D The abstract from my thesis is below: SQL injection vulnerabilities remain one…
Installing mongodb on centos7
Installing mongodb on centos7: To install the mongodb server in centos7 first you have to add the mongodb repo: vim /etc/yum.repos.d/mongodb.repo Paste this into the file: [mongodb] name=MongoDB Repository baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/…
What is an sql injection attack
What is an sql injection attack? All websites process data entered by users. An input-validation attack is when unexpected user input is processed by a web server or database and…
Oracle process overview
Oracle process overview. There are 3 types of oracle processes: USER processes SERVER processes BACKGROUND processes User connected to a user application (eg sql*plus) controls the application associated with an…
Oracle forms overview
Oracle forms overview. Oracle internet platform consists of 3 components: oracle application server (forms service + OC4J) oracle developer suite (forms developer + object navigator + form module) oracle database…
Oracle procedure with cursor
This is a basic oracle procedure with cursor: DECLARE CURSOR my_cursor IS SELECT * FROM table_a LEFT JOIN table_b ON a.x = b.x BEGIN FOR things IN my_cursor LOOP --…
Oracle instead of triggers
Oracle instead of triggers, and why you need them: You cant update a view if it contains:group byorder byanalytical /aggregate functionssubqueriesjoins You then need an 'instead of' trigger CREATE TRIGGER…
Oracle logical structures
Oracle logical structures Oracle logical structures can be summarised by the following: Schema. Tablespace. Datablock. Redo log. Schema collection of objects (table, view, etc) owned by db user name is…
Oracle control file
Oracle control file: binary file start of instance, file is checked database has 1 control file each modifiable only by oracle editing prohibited, even by DBA Keeps track of: datafile…
Updating to php 5.4 and mysql 5.5 in centos 6
To update to php 5.4 and mysql 5.5 in centos 6: 1) install the epel, remi and rpm-forge repos rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm rpm -Uvh http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm 2) edit…
Mysql query to set a featured image on all wordpress posts without a featured image set
If you want to set a featured image on all wordpress posts that dont already have a featured image set, then this mysql query can help: INSERT INTO wp_postmeta (post_id,meta_key,meta_value)…
Database migration finnished (for now)
well, it took a while, but I have finnished the script that will migrate our clients database over to our new system. it didnt actually take that long to make…
Wow. crowded train. and database migration with scripts.
The train home is uber crowded. I still managed to get a seat. today I have been writing a script that will migrate a database from one system to another…