OpenVPN Fails to Start on Boot – CentOS 7

This all started one chilly January morning when I upgraded my CentOS 7 virtual machine. My OpenVPN connection would fail to start because the /run/openvpn/ovpn-client.status file was not there nor the /run/openvpn directory. It took a lot of investigative work but what we found was the /usr/lib/tmpfiles.d/openvpn.conf file had this in it: d /run/openvpn-client 0710 root root – d /run/openvpn-server 0710 root root – This temp file was making the directories in the /run folder that were needed on start for OpenVPN to work. As you can see the first line is creating the /run/openvpn-client folder. This would be all well and good but the openvpn.service on startup is looking for /run/openvpn without the “-client” and that is no good. […]

ColdFusion SQL Security

It’s common when working on a web application to interact with a database to read, insert, update, or delete data. In doing so you must take care when using variables in your SQL. The input may be coming from a search form or passed in the URL, but wherever it comes from there is a risk of SQL Injection, Cross Site Scripting or other attacks on your system. ColdFusion provides a few helpful tools for preventing people from executing malicious SQL queries or executing JavaScript injected into your database. One is the cfqueryparam tag. Assuming we set first_name = “Kevin” This would look something like this SELECT u.first_name, u.last_name FROM users u WHERE u.first_name = <cfqueryparam cfsqltype=”CF_SQL_VARCHAR” value=”#first_name#”> This will […]