Articles related to technology, how to use software, ways to work around technology problems, install hardware, install software, upgraded software, etc.
If your PlayStation 3 is operating slow, losing connection, or just not working right most of the time the chances are that you need to change some settings on your Internet router or firewall. Routers use NAT(Network Address Translation) to allow multiple devices to function behind the router as if they all have the public…
The below steps will allow you to set up a TFTP server on Linux but specifically on a CentOS server. All you need to do is install a couple files with yum, enable the server, and restart xinetd. Install TFTP Server: Use the below syntax to install the TFTP server on CentOS. bash [root@centos-server ~]#yum…
Upgrading a Linksys WRT54G v5 wireless router is a bit more complicated than most of the other Linksys WRT54G wireless routers. It is not as easy as downloading a dd-wrt .bin file and uploading it via the router administration GUI. Instead you must first install some other bin files to wipe the wireless router clean…
Its really easy to configure ZenCart to show the credit cards that you are going to accept to customers during their checkout. Not only could you display the text of these images similar to the below example but its also very easy to display images of the credit card types you will be accepting. Example:…
Zencart has four default order status types which are Pending(1), Processing(2), Delivered(3), and Update(4). The number in parenthesis represents the order in which the order type will be located in the drop down so by default the first type in the drop down is Pending. To add a new order status type login to the…
Backing up and restoring PostgreSQL is fairly easy using pg_dump and psql. One more complicated scenario I have run into is doing a complete database backup with pg_dump and at some point down the road needing to just split out one table and restore it. This can be a pain because of how the pg_dump…
The pg_stat_activity table will show you what activity is currently happening on your PostgreSQL database server. The information will detail the database the activity is occuring on, the username initiating the activity, the length of time the acitivy has been occuring for, and much more. Below is example output from running a SELECT query against…
The Linux kill command is used to kill PID’s or process ID’s. This command is beneficial for numerous reasons typically for run away processes, processes caught in some sort of loop, to kick users from a system, or any other number of reasons. Typically kill is used in the below format with 12345 being the…
This post will explain how to post notes from Microsoft OneNote into the WordPress admin. When you copy and paste from most Microsoft products into a visual editor such as TinyMCE that WordPress uses you will typically include a bunch of unwanted tags from the Microsoft application. These tags will make it complicated to format…
To create a PL/pgSQL stored procedure, copy and paste a dummy procedure like this into the “Execute arbitrary SQL queries” window in PgAdmin 1.8.4: