Tracking SQL Queries for a Request using Django
Packt is due to launch a new Open Source brand, into which future VirtualBox titles will be published. For more information on that launch, look here
In this article by Karen M. Tracey, author of the book Django 1.1 Testing and Debugging, we will develop a template code that can be used to include information about all of the SQL queries needed to render a page in the page itself.
Read Tracking SQL Queries for a Request using Django in fullTransferring Data from MS Access 2003 to SQL Server 2008
The Export and Import Wizard is an extremely useful tool for transferring data. In fact it is the simplest tool to copy over data from one database to another and to create data transfer packages that can be persisted. Data can be transferred between SQL Servers (between versions of SQL Servers for example) as well as between even two non-Microsoft databases. Both Microsoft and proprietary data source providers are available to connect to many different database products.
In this article by Dr. Jayaram Krishnaswamy, we will be transferring data from an MS Access database to a database on SQLServer 2008. Both the source of data and the destination database are on the same machine, in this case a computer box running Windows XP Pro. There are two versions of the Import and Export Wizard and in this example the 32 bit version is used.
Read Transferring Data from MS Access 2003 to SQL Server 2008 in fullTranslations in Drupal 6
Drupal offers some enticing JavaScript tools, one of which is jQuery. The theming and behavior capabilities provided by drupal.js are other examples. Along with those cool tools comes a feature that has had a remarkable influence on the success of Drupal, but which provides far less glitz and glamour.
This tragic hero is the translation engine, which will be the subject of this article written by Matt Butcher.
Translations are important—one might even say vital—to the success of Drupal. Consequently, it is imperative that all Drupal developers become familiar with these tools. JavaScript written in Drupal 6 (and in later versions) should be translation-aware.
Here are the things we will cover in this article:
- Get our bearings in the drupal.js library
- Enable multi-language capabilities in Drupal
- Learn the translation functions
Trapping Errors by Using Built-In Objects in JavaScript Testing
In this article, by Liang Yuxian Eugene, author of JavaScript Testing Beginner's Guide, we'll briefly describe what each type of built-in object is, along with its syntax, before we show some examples of how each of the built-in objects work. Do take note that the alert messages, which we will be using sparingly in the examples, are based on the Firefox browser. If you try the code on Internet Explorer, you might see different error messages.
In this article we will be specifically covering:
- The Error object
- The RangeError object
- The ReferenceError object
- The TypeError object
- The SyntaxError object
- The URIError object
- The EvalError object
Triggers in Zabbix 1.8
In this article by Rihards Olups, author of Zabbix 1.8 Network Monitoring, we will discuss triggers in detail which will include Trigger dependencies, Constructing trigger expressions, Event details, and Event generation and hysteresis.
Read Triggers in Zabbix 1.8 in fulltrixbox CE Functions and Features
Every commercial PBX system has its own set of advanced features that are activated by key commands, also known as vertical service activation codes. In this article by Kerry Garrison, we will look at the standard and advanced features of trixbox CE. We will even look at how to add our own custom features to the system.
Read trixbox CE Functions and Features in fullTroubleshooting and Gotchas in Oracle VM Manager 2.1.2
The journey with Oracle VM Manager is not free of troubles and errors. In this article, Tarry Singh will attempt to address the ones that are bound to bother you the most as far as Oracle VM Manager is concerned.
What will we cover in troubleshooting?
While we tackle the following issues in troubleshooting VM Manager. We are assuming that you are using the latest version of Oracle VM Manager and the Oracle VM Server version is 2.1.x:
- Oracle VM Manager login takes too much time
- VM guest creation fails
- Not enough disk space available for ISOs and Templates
- Cannot login to the VM remotely
Read Troubleshooting and Gotchas in Oracle VM Manager 2.1.2 in full
Troubleshooting FreeNAS server
It is a common experience amongst all of us that from time to time our computers don't always work as we expect and we need to hunt down and resolve problems with them. Troubleshooting can be time consuming especially if you have limited experience with the software or system you are using. This article by Gary Sims, is a guide on how to solve problems with your FreeNAS server. It covers where to look for information about the problem as well as how to hunt down problems by being methodical. It also looks at the common problems people have with their FreeNAS servers including networking problems and problems with RAID.
Read Troubleshooting FreeNAS server in fullTroubleshooting in OpenStack Cloud Computing
OpenStack is an open source software for building public and private clouds, born from Rackspace and NASA. It is now a global success and is developed and supported by scores of people around the globe and backed by some of the leading players in the cloud space today
In this article by Kevin Jackson, author of OpenStack Cloud Computing Cookbook, we will cover:
- Checking OpenStack Compute Services
- Understanding logging
- Troubleshooting OpenStack Compute Services
- Troubleshooting OpenStack Storage Service
- Troubleshooting OpenStack Authentication
Troubleshooting Lotus Notes/Domino 7 applications
Troubleshooting the problems are always a part of any system. In this article by Dick McCarrick, Stephen Cooke, Timothy Speed, and Raphael Savir, we will see how to identify and correct problems in our Lotus Notes/Domino 7 applications. This article includes troubleshooting issues that affect performance and also talks about Domino Domain Monitoring (DDM) and what it can do in terms of troubleshooting applications. A brief overview of Agent Profiler is given at the end of this article.
Read Troubleshooting Lotus Notes/Domino 7 applications in fullTroubleshooting Nagios 3.0
In this article by Wojciech Kocjan, we will learn about troubleshooting Nagios 3.0 which includes troubleshooting the web interface, passive checks, SSH-Based checks, and NRPE.The article includes various possible errors along with their solutions and detailed explanations for each error listed out.
Read Troubleshooting Nagios 3.0 in fullTroubleshooting OpenVPN 2: Configurations
Routing gives an insight into troubleshooting routing problems when setting up a VPN using OpenVPN. You will learn how to detect, diagnose, and repair common routing issues.
In this article by Jan Just Keijser, author of OpenVPN 2 Cookbook, we will cover:
- Cipher mismatches
- TUN versus TAP mismatches
- Compression mismatches
- Key mismatches
- Troubleshooting MTU and tun-mtu issues
- Troubleshooting network connectivity
- Troubleshooting client-config-dir issues
- How to read the OpenVPN log files
Troubleshooting WebSphere Security-related Issues
It is not uncommon to run into issues when global security is first enabled in a WebSphere environment. Some of those situations may occur due to performing tasks out of order. Other problematic conditions related to security configuration may take place due to inadvertently omitting one or more steps in a set up process. Moreover, a third category of errors that may happen due to security configuration is caused by using the wrong values to one or more parameters.
In the previous article by Omar Siliceo, author of IBM WebSphere Application Server v7.0 Security, we took a look at tuning websphere security. In this article we will be presented by a set of some conditions that may appear in a WebSphere Application Server ND version 7 (WAS ND7) when global security is first enabled. The first subsection covers circumstances that may come about during the configuration phase. Next, a subsection is included that presents circumstances that may happen at runtime.
Read Troubleshooting WebSphere Security-related Issues in fullTroubleshooting your BAM Applications
In a typical business flow in BAM, business data moves from various upstream data sources to Oracle BAM, which internally processes and pushes the data to IE browsers for report rendering. As different technologies and BAM Server components are involved, it could be time-consuming and challenging to identify and solve the problem if anything goes wrong in this flow.
In this article by Pete Wang , author of Oracle BAM 11gR1 Handbook, we will cover:
- Methodologies for troubleshooting Oracle BAM
- Troubleshooting Active Data processing
- Troubleshooting BAM HA issues
Troux Enterprise Architecture: Managing the EA function
This article by Richard J. Reese, author of the book Troux Enterprise Architecture Solutions, explores an aspect of Enterprise Architecture that is not written about a great deal. There are as many models for running the EA function as there are opinions about the topic. This article provides a brief introduction to the following topics:
- Setting the EA charter
- Staffing the function
- Sample job descriptions
- Management metrics
These topics are provided as representative samples of how the EA function can be managed within a business or agency. There is no "best way" to organize the EA function. There are, however, some management principles that have worked well for many organizations, and these are presented next.
Read Troux Enterprise Architecture: Managing the EA function in fullTrunks in FreePBX 2.5
In this article by Alex Robar, we will learn about trunks in FreePBX. We will discuss the following:
- Various types of trunks allowed by FreePBX
- Methods for setting up each type of trunk
Trunks using 3CX: Part 1
If you have a working phone system with extensions, voicemail, digital receptionists, call queues, and several other features and you want to call home or have a customer call you, what will you do? For that, you need to connect 3CX outside your internal network. This connection is called as trunk. In this article by Matthew M. Landis and Robert Lloyd, authors of The 3CX IP PBX Tutorial, we will cover:
- PSTN trunks
- SIP trunks
- Introduction to dial plans
- Hardware needed for analog lines
Trunks using 3CX: Part 2
Read Part One of Trunks using 3CX here.
Read Trunks using 3CX: Part 2 in fullUnpublished
Tuning jBoss AS 7 Performance
Tuning WebSphere Security
The generic term "tuning security … " some say, it's an oxymoron. Why so? Well, in many cases, tightening up security is normally reflected in poor performance. So, if a portion of your environment is performing poorly, it may need a review of the security configuration in order to see if loosening it a bit does not compromise the environment itself. This article by Omar Siliceo, author of IBM WebSphere Application Server v7.0 Security, briefly describes tuning in three major areas:
- General security configuration
- CSIv2 connectivity
- LDAP and Web authentication


