Frequently Asked Questions

The following list of responses and suggestions has been prepared to address frequently asked questions. If you require support for a specific issue that is not addressed by the information below, please send us a Feedback.

We also offer Consulting Services to help get you started using QLR Manager. This can range from installation and configuration, and include services such as authoring Queries, Macros, and Forms to your specifications. We can also create User Menus to organize your reports and place them at your finger tips with one click.

Installation Tips:
How do I install QLR Manager?
How do I install the QLR Manager license?
How do I migrate from my current product version to the latest version?
How do I upgrade my current product version to the latest release within the version?
Can I change the name of the startup HTML file to something other than qlrmanager.html?
What is the most secure way to run the application?
How do I normalize MySQL 4.1+ passwords for use with QLR Manager?
What are some tips for installing PHP to work with Oracle?
How do I install a production version of FusionCharts?
How do I create images of FusionCharts for e-mail or download formats?
Which databases does QLR Manager work with?
How can I install the IBM DB2 PHP extension to access DB2?
How do I change the database access ID and/or Password used by QLR Manager?
Optimal PHP settings (IMPORTANT):
How can I determine the current php.ini settings?
What are the optimal php.ini settings to work with QLR Manager?
Using QLR Manager:
Can I use my browser's Back and Forward buttons?
If I create Queries and Layouts using the Trial version, will they be lost if I buy the product?
What is the maximum number of rows I can display from the results of a query?
When I attempt to logon to QLR Manager, I see a message that says "Your session with the server has expired."
When I start QLR Manager, I see a message that says "Cannot continue. Could not connect to the QLR Manager database."
Can I issue "alter session" commands in Oracle to change my session configuration?
Why does my browser stall on large reports or output with charts?
How can I print a large report to a printer or PDF writer?
How can I print mailing labels from my database?
Can I connect remotely to a MS SQL 2005 database?
Why do I sometimes receive Forbidden messages from the server?
Version & Support info:
What's new in this product release?
What support can I expect with a product purchase?

How do I install QLR Manager?

If upgrading from an earlier version, see migration information.

If upgrading from an earlier release within the same version, see product upgrade.

Follow these steps to install QLR Manager:

The Install & Migration Manager is intended to guide you through the installation process. There are only a few steps in the process, each requiring minimal information. Once the necessary information is gathered, the actual execution time of the installer only takes a few seconds, depending on your server. These are the steps:

1. Download the desired archive type of the Full Version package from our Downloads page.
2. Create a directory, e.g. /qlr, /qlrmgr, etc. in your server's execution path for QLR Manager.
3. Unzip or untar the contents of the full install package into the new directory and be careful to preserve the original directories/folders as they exist in the install package. If you download and extract the contents on a client, you can FTP the files to your new server directory.
4. Obtain a FREE 30 day trial license for the Enterprise Edition from our Purchase page. Place the QLRlicense.inc file into the new server directory. If you first request a trial license and later wish to buy QLR Manager, you simply upgrade the trial license.
5. It is optional to temporarily grant Read, Write and Execute (Unix 777) permissions to the main directory you created in step #2. This will allow the install program to write the qlr.ini file into this directory. If you don't grant this authority, the install program displays its output to the browser, which allows you to copy and paste the contents necessary to manually create the qlr.ini file. The qlr.ini file must be present in the new server directory to run QLR Manager. If write authority is granted, don't forget to remove it after the installation is completed.
6. From your browser, start the install program by referencing install.html in the newly created directory, e.g. http://127.0.0.1/qlrmgr/install.html. Select the New Installation option and click the Begin button.
7. Carefully follow the instructions on the install panels, paying attention to any messages generated during the install. The bold labels are linked to help in the Installation topic of the QLR User's Guide. Use the buttons on the bottom of the panel to proceed through the upgrade process.
8. After completing all the install panels, the qlr.ini file will be created with all the configuration parameters for your QLR Manager installation. If you granted the authority suggested in step #5, the qlr.ini file will be written into the new server directory.
9. Grant Read, Write and Execute (Unix 777) permissions to the following directories in the QLR Manager directory structure:
/reports to allow for temporary output file storage and support the creation of PDFs.
/graphs in the Enterprise Edition to support the creation of charts and graphs.
10. From your browser, start QLR Manager by referencing qlrmanager.html in the newly created directory, e.g. http://127.0.0.1/qlrmgr/qlrmanager.html.

The Install & Migration Manager is not only intended to initially install QLR Manager, it can also be used to update the QLR Manager parameters. On installation step Step 2 of 3, there is a button at the bottom of the page to Update Settings Only. This will bypass dropping and re-creating of the tables used by QLR Manager, and only update the parameters in the qlr.ini file.

The install process can be started by entering install.html, with the proper path information, into your browser. Install.html resides in the top level directory you created to store the QLR Manager files on your server.

Top

How do I install the QLR Manager license?

In order to run QLR Manager, you must have a product license file. Prior to buying QLR Manager, we urge everyone to take advantage of our FREE 30 day trial of the Enterprise Edition. This will ensure it runs correctly in your environment and the product meets your expectations. If you first request a trial license and later wish to buy QLR Manager, you simply upgrade the trial license. To receive a license, you must first create a user account so we can e-mail your license file. A trial or purchased license can be obtained from our Purchase page.

To install the QLRlicense.inc file, simply copy the file into the same directory where QLR Manager is installed, which is the same directory where the file qlrmanager.html is located.

A license will entitle you to free upgrades and fixes within the same version. We don't release a new version until we incorporate significant new function and features. Upgrades to new versions are steeply discounted for existing license holders.

Top

How do I migrate from my current product version to the latest version?

A migration is necessary when the underlying QLR Manager database tables, or data in those tables, must be updated. A migration is always necessary when upgrading from one major version to another, e.g. version 4.1.5 to version 5.0. In addition to updating the QLR database tables, the migration will copy your existing queries, layouts, etc. to the new version.

The same QLRlicense.inc file will work with all levels of the same major version number. In other words, a version 9 license will work with versions 9.0, 9.1.5, etc. but not version 10.0. Existing customers upgrading to the latest version will receive a 60% discount for a one version upgrade and a 20% discount for a two version upgrade. Before purchasing an upgrade license, we urge you to take advantage of a FREE 30 day trial license for the Enterprise Edition of the new version. Trial licenses can be obtained from our Purchase page. If you first request a trial license and later wish to buy QLR Manager, you simply upgrade the trial license.

1. Download the desired archive type of the Full Version package from our Downloads page.
2. Create a new directory, e.g. /qlr_v10, for the new version of QLR Manager.
3. Unzip or untar the contents of the full install package into the new directory and be careful to preserve the original directories/folders as they exist in the install package. If you download and extract the contents on a client, you can FTP the files to your new server directory.
4. Copy the qlr.ini file from your existing QLR directory into the new directory.
5. If you are utilizing the conmsg.html file (Connect panel message), copy your existing conmsg.html file into the new directory.
6. Place the trial or purchased license file (QLRlicense.inc) for the new version into your new directory.
7. Launch your web browser and access the file qlrmanager.html in the newly created directory, e.g. /qlr_v53. QLR Manager will automatically detect that it needs to update its data tables. An Update button will be presented. Click this button to update your version of QLR Manager.

If you wish to erase your existing queries and layouts, or this is a new installation, simply access install.html with your browser and choose the New Installation option to install the product.

Top

How do I upgrade my current product version to the latest release within the version?

A product upgrade occurs when a more recent release is available for the same product version number, e.g. upgrading from version 9.0 to version 9.1.5. The same QLRlicense.inc file will work with all releases of the same major version number. A FREE Upgrade pack is normally provided on our Downloads page when an upgrade is available for the current version. The Upgrade pack will contain the files to be replaced in your QLR Manager installation to upgrade to the latest release.

Note: It is not usually necessary to run install.html for an upgrade within the same version. You are simply replacing the existing QLR Manager files on your server.

An upgrade differs from a migration to a new version of the product, i.e. version 9.1.5 to version 10.0.

If an upgrade pack is offered, follow these steps to upgrade to the latest QLR Manager release:

1. Copy your existing QLR Manager directory into a new directory, e.g. /qlr_v10.
2. Download the desired archive type for the Upgrade pack from Downloads.
3. Extract the files from the directories in the Upgrade pack into the same directories in your new copy of QLR Manager, e.g. /qlr_v10.
4. Follow any special instructions included near the top of the README.html included in the root directory of the Upgrade pack.
5. Test the new release of QLR Manager. Once you are satisfied that it is working correctly, you can rename or delete the old release directory and rename the new directory to the original directory name.

Note: In some instances, too many files are updated within a release which makes an upgrade pack impractical. If this is the case, you can download the full install package and sort the files in descending date sequence and overwriting the like named files in the earlier release, being careful to overwrite the files in the correct directories. The dates of newer files can be determined by comparing those in the latest package against the latest date in your existing install. It is recommended the upgrade be performed against a copy of your existing installation.

Top

Can I change the name of the startup HTML file to something other than qlrmanager.html?

Yes, you can change the name by renaming the qlrmanager.html file in the main install directory. In addition, there is a line in your qlr.ini file, also located in the main directory, that must be updated to reflect the new startup file name:

startFile     = qlrmanager.html

If your server is configured to use index.php, you can access QLR Manager by simply entering the path name. If you do choose to change the name of qlrmanager.html, index.php should also be edited to reflect the new file name.

Top

What is the most secure way to run the application?

There are several things that can be done to enhance security:

Install QLR Manager to store its pages in a database or simply edit the qlr.ini file pageSource = database.
Password protect (.htaccess) your main directory so users must enter a password to begin using QLR manager.
Rename the install program after you have completed your install so someone else can't try and access it.
Protect your user IDs and passwords!

Top

How do I normalize MySQL 4.1+ passwords for use with QLR Manager?

With the release of MySQL 4.1, a new method of password hashing was introduced and continues to be used. When using PHP version 4.x, QLR Manager is unable to recognize these passwords unless they are normalized to the pre-4.1 password style. This is critical because QLR Manager requires that an existing user ID and password be provided to perform the product installation. The user ID performing the installation must be using the old style password. This does not appear to be an issue when using PHP 5.0 or newer.

In order to change the password for the ID that will perform the install, you should issue the following MySQL command:

SET PASSWORD FOR 'some user'@'some host' = OLD_PASSWORD('existing password');
Example: SET PASSWORD FOR 'conor'@'localhost' = OLD_PASSWORD('guinness');

Note: In addition to normalizing the password for the user ID that will perform the installation, the password for any user ID that will be accessing QLR Manager must be changed as well.

The following is an example of a mixture of new style (longer) and old style (shorter) encrypted passwords.

  select host,user,password from mysql.user

host user password
localhost root *C17559EB42E5CCB3F961A2FC2DC4BE40DB725E7A
localhost jimmy 57c9a17a46d6fd35
localhost conor *C17849ACCBD5CCB3F961A2FC2DC4BE89EFFCA21D
localhost qlrmgr 0bc8e68c1fc65570

After issuing the MySQL command to change to old style password:

  SET PASSWORD FOR 'conor'@'localhost' = OLD_PASSWORD('guinness');

The contents of the user table would appear as follows:

host user password
localhost root *C17559EB42E5CCB3F961A2FC2DC4BE40DB725E7A
localhost jimmy 57c9a17a46d6fd35
localhost conor 1e2989030051c8f0
localhost qlrmgr 0bc8e68c1fc65570

More information can be found at: http://dev.mysql.com/doc/mysql/en/password-hashing.html.

Top

What are some tips for installing PHP to work with Oracle?

If this is the first time you have tried to set up PHP to use with an Oracle database, here are a few tips. If you are installing on a Windows platform, you must have the complete Windows binary version loaded, since it contains the dll files necessary for PHP to interact with Oracle. If you have already set up PHP, but did so using the Windows Installer version, you will need to get the full binary version. Here's what you can do:

1. Download both the full and installer versions of PHP for Windows.
2. Install PHP using the installer version. This will walk you through a basic PHP install.
3. Unzip and overlay the contents of your php directory that you specified in the basic install with the contents of the full binary package. The full package contains the dll files for PHP to work with various products, including Oracle.

For both Windows or Unix, do the following:

Edit your php.ini file and uncomment (remove the semicolon) for the line that reads php_oci8.dll. Warning - this dll is incompatible with php_oracle.dll running at the same time. php_oracle.dll must be commented out.
Make sure your extension directory variable in php.ini references the path where the dll files are located, e.g. extension_dir = "c:/php/extensions/".

Top

How do I install a production version of FusionCharts?

If you purchase a license for FusionCharts, you will be sent by the company FusionCharts (not QLR Manager) a set of files. These files will generate charts without the "Evaluation" text being displayed. QLR Manager expects to find these files in its FusionCharts directory.

The best way to install the production version is to rename the existing FusionCharts directory to something else, such as FusionCharts_eval. Then recreate a directory called FusionCharts and place the production version of the FusionChart files into the directory. It may help you to examine the contents of the original FusionCharts directory to understand which files need to be present. You may need to copy the Javascript files from the evaluation directory into your new production directory.

Top

How do I create images of FusionCharts for e-mail or download formats?

If you wish to embed fusion charts into the various download formats or email options available in Report Tools or send them using Macros, the FusionChart must be converted to an image on the server. To accomplish this, a free third party tool is available from http://www.phantomjs.org. Although PhantomJS is free to distribute, it is not included with the QLR Manager install package because there are three different versions depending on the server OS - Windows, Linux 32-bit and Linux 64-bit.

There is a PHP script in the main QLR Manager directory called phantomjs_check.php that can be executed to determine the proper phantomjs package to obtain for your environment. This script can be executed from your browser's address area by substituting your domain and path with something like: http://www.mysite.com/qlrv9/phantomjs_check.php. As a convenience, we host the Linux and Windows versions of PhantomJS at http://www.qlrmanager.com/html/phantomjs.html. We have discovered in some instances that the Linux 64-bit version of PhantomJS will not run on a 64-bit server and in most of these cases the 32-bit version will often run successfully.

The PhantomJS directory structure is included within the QLR install directory. After obtaining the correct version of the phantomjs binary, it must be installed in the QLR install directory > phantomjs > bin folder. With the PhantomJS binary present, Fusion Charts and Fusion Widgets can be E-mailed, and the various download formats can be created. If you are planning to use FusionCharts in the manner described, you are encouraged to purchase a licensed version from Fusion Charts which will remove the FusionCharts XT Trial watermark from the PNG images.

More information about using PhantomJS can be found at: http://www.phantomjs.org. A few things to note when installing the appropriate phantomjs package for your server environment:

The appropriate binary must be installed in the correct folder: QLR install directory > phantomjs > bin.
The phantomjs binary must be named phantomjs in Linux environments and phantomjs.exe in Windows.
When using FTP to transfer the phantomjs binaries, they must be transferred using a Binary transfer.
The /phantomjs folder, along with all the nested folders and files should have 755 permissions.
Sometimes the linux-X86-64 (64-bit) version of phantomjs will not run on a 64-bit server and in most of these cases the linux-i686 (32-bit) version will often run successfully.

An easy way to determine if PhantomJS is working properly is to generate a report with a FusionChart, then use Report Tools to create a PDF.

Top

How do I change the database access ID and/or Password used by QLR Manager?

The master ID and Password used by QLR Manager to access your database is stored as an encrypted value in the qlr.ini file. In order to change it, you must launch install.html that is found in the directory where you installed QLR Manager, e.g. http://my_domain/qlr_directory/install.html.

Note: It is IMPORTANT that you click the Update qlr.ini Only button and not theBegin Install button. Performing a new install will drop the tables used by QLR Manager to store all your saved objects such as queries, layouts, etc.

Follow these steps to change your database access password stored in the qlr.ini file:

1. Access your QLR installation panel by entering http://my_domain/qlr_directory/install.html.
2. Enter your Existing QLR Manager ID and Password for existing ID, then click the Continue button.
3. The next panel displays your license information, click the Proceed to Step 1 button.
4. On the Step 1 of 3 panel, enter the Login credentials for a Super User ID that has Read/Write authority to your database. Click the Proceed to Step 2 button.
5. On the Step 2 of 3 panel, you can define the Login ID (new or existing) to be used as the Master QLR ID and the Password for the master ID. This is where you can change the User ID and/or Password stored as an encrypted value in your qlr.ini file.
6. At the bottom of the Step 2 of 3 panel, click theUpdate qlr.ini Only button. DO NOT click theBegin Install button. Performing a new install will drop the tables used by QLR Manager to store all your saved objects such as queries, layouts, etc.

Top

How can I determine the current php.ini settings?

A phpinfo.php file is provided as part of the QLR Manager install package and will be located in the main install directory. Executing this file from the browser, e.g. http://my_domain/qlr_directory/phpinfo.php, will return information about the server configuration. Scroll down to the section entitled Configuration PHP Core to view the php.ini settings.

Top

What are the optimal php.ini settings to work with QLR Manager?

The PHP Core configuration settings can be changed by editing the server's php.ini file. Adjusting the following 3 settings will help ensure QLR Manager functions properly on your server. If you're running on a shared hosting environment, check with your Hosting Service (ISP) about modifying these settings. Some ISPs provide solutions where the php.ini file or entries in an .htaccess file can be read from the hosted domain to override the server's default php.ini settings.

max_execution_time Should be set from a minimum of 60 seconds to as long as 90 seconds to support large, sophisticated queries. Beyond 90 seconds, the browser may timeout waiting for a response from the server.
memory_limit The Enterprise Edition with chart support enabled should be set to a minimum 32M.
The Enterprise Edition without chart support, or other editions, should be set to a minimum 16M.
PHP GD support If you intend to create charts and download PDFs, GD support must be enabled in PHP. Please see the Product Installation topic in the QLR User's Guide about Chart support and Graphics manipulation with PHP.
safe_mode With this mode set to OFF, QLR Manager will adjust memory allocation and execution time as needed to execute large queries or longer running macros.
session.use_trans_sid This setting should be "0" or "Off". With this value set to "1" or "On", you may experience frequent session expirations, particularly with the Report Tools window.

Top

Can I use my browser's Back and Forward buttons?

In general, yes you can. Some browsers behave differently than others. The most stable browser for using these buttons is Internet Explorer. It can be very useful to use Back and Forward when paging back and forth between page sets in a large report. Be aware that you may page back to a screen that is in a different "page state". An example might be that you ran a query to generate a report, paged back to the query page, and then try to return to the report page via the Report tab. The query page may not recognize that a report exists, because you have paged back to its state prior to running the query.

Top

If I create Queries and Layouts using the Trial version, will they be lost if I buy the product?

No. You will be able to install, or upgrade your version of QLR Manager without loosing any of your data. If you decide to Purchase a non-expiring license. you simply upgrade your trial license.

Top

What is the maximum number of rows I can display from the results of a query?

QLR Manager displays reports in blocks of pages, or "page sets". The number of rows in a page set is defined as the reportRows value in the qlr.ini file created when QLR Manager is installed. If the block size is set to 500 (default value), then 500 rows can be displayed at one time. QLR Manager can create up to 1,000 page sets for a report. Therefore, using this reportRows setting, 500,000 rows of data can be displayed. If queries do generate more than the allowable maximum rows, you can either use the "Group" Action in the Layout panel to compress rows, or Group the data in your query with the SQL "Group By" function. Navigation links (First, Back, More, Last) are provided above the report output to move between page sets.

The value established during installation and recorded in the qlr.ini file becomes the default for the installation. There is also a "Max displayed rows" control in the Report Body section of the Layout panel that will override the installation default. If this value is increased, more report rows will be displayed per page set. The compromise is the time your browser will take to render larger page sets. The slower rendering speed can be very noticeable with slower network connections.

The Max displayed rows value can be increased to produce one continuous set of report pages. This may be desirable to print the output or to produce a PDF. If the Layout is saved as the same name as its associated query or wizard, it will be automatically applied when the query, wizard or menu item is executed.

Top

When I attempt to logon to QLR Manager, I see a message that says "Your session with the server has expired."

If you see an immediate message that says "Your session with the server has expired", it may be that PHP is unable to write to the directory where it stores your session variables. The name of this directory can be found in the php.ini file, and is called "session.save_path". Make sure that there is Read, Write and Execute (Unix 777) access to this directory.

Top

When I start QLR Manager, I see a message that says "Cannot continue. Could not connect to the QLR Manager database."

The probable cause is that your database engine is not running on your server. Check to make sure you have started the database engine.

Top

Can I issue "alter session" commands in Oracle to change my session configuration?

Not directly, but there is a special query a user can create called "user session" that accomplishes the same thing. If a query exists with the name of "user session", its contents will be executed when the Run Query button is clicked, prior to executing the query in the Query panel. This allows for the setting of database commands, such as "alter session" commands in Oracle. An example of the contents of a user session query is:

alter session set nls_date_format = 'DD-MON-YY HH24:MI:SS';

Since QLR Manager supports batch query processing, multiple commands can be placed into this query, separated by a semicolon(;). Each User ID may have a "user session" query. This technique also works for MySQL commands, such as "set".

Top

Why does my browser stall on large reports or output with charts?

This may be due to a memory limitation in PHP. QLR Manager attempts to alter memory allocation at runtime for memory intensive operations, such as creating charts. If your browser still hangs or produces incomplete output, this is probably because QLR Manager was unable to increase the memory allocation. See optimal php.ini settings for more information.

Top

How can I print a large report to a printer or PDF writer?

QLR Manager Version 5.1.2 introduced the capability of setting the Max displayed rows in the Report Body section of the Layout panel. This provides a method of overriding the installation default for the total number of report rows that will be displayed for each block of pages, or "page set". By entering a value that is greater than the total numbers of rows expected to be produced by the query, one continuous set of pages will be produced. Using the Print displayed output option in the Report tools pop-up, the entire report can be printed or sent to a PDF writer. Saving a layout with the same name as its associated query or wizard will automatically apply the layout when the query is executed.

When sending the output to a PDF writer such as Adobe Acrobat or CutePDF (available free from www.cutepdf.com), it is usually desirable to produce the PDF in full color. There is a Print black & white control in the Report Body section of the Layout panel that must be deselected. In addition, the default installation for most browsers prevents printing background colors to conserve ink. The printing selections for your browser may have to be changed to print to a PDF writer in full color. More information about these browser settings can be found in our User's Guide.

Top

How can I print mailing labels from my database?

Mailing labels can be printed from Microsoft Word using an imported CSV file downloaded from QLR Manager. Begin by authoring a query to select the desired address records from your database. Include the appropriate columns in the report to generate mailing labels such as, name, street, city, state, and zip code. Generate the report and launch Report Tools. Open the section for Download as Data File and select "Include column headers" and "CSV". Click Create and download the file to your local PC.

Launch Microsoft Word and select from the Tools menu:

Letters and Mailings
Mail Merge Wizard....

The Mail Merge controls will appear in the right pane:

Step 1 of 6 - Select document type: Labels. (click Next: Starting document)
Step 2 of 6 - Select starting document: Select Use the current document. Label options can also be specified. (click Next: Select recipients)
Step 3 of 6 - Select recipients: Use an existing list and Browse to where the CSV file downloaded from QLR Manager is saved. (click Next: Arrange your labels)
Step 4 of 6 - Arrange your labels: Complete the steps below. (click Next: Preview your labels)
Assign the Address block...
Replicate labels by clicking the "Update all labels" button
Step 5 of 6 - Preview your labels: Edit recipient list... if desired. (click Next: Complete the merge)
Step 6 of 6 - Complete the merge: Print... or Edit individual labels.../td>

Top

Can I connect remotely to a MS SQL 2005 database?

If you receive the message "Unable to connect to XX.XX.XXX with User ID administrator and password entered." after entering the correct log on credentials from the Connect panel, the problem may result from the ntwdblib.dll distributed with Apache and PHP. To fix this problem, try the follow steps:

1. Download the good version of ntwdblib.dll (2000.80.194.0) from http://webzila.com/dll/1/ntwdblib.zip
2. Overwrite \apache\apache2.2.6\bin\ntwdblib.dll
3. Overwrite \php\php5.2.5\ntwdblib.dll
4. Start the SQL Server Configuration Manager -> Protocols
5. Enable "named pipes" and "tcp/ip".
6. Right-click "tcp/ip" -> Properties tab "IP addresses"
7. Fill in "TCP Dynamic Ports" with 1433
8. Restart SQL Server AND Apache, PHP and all the other services

Top

Which databases does QLR Manager work with?

There are two aspects to this question.

The first is that QLR Manager needs to create tables during the product installation to manage data, such as your queries, layouts, etc. The databases that QLR Manager can be installed in are listed in the second column in the table. Keep in mind that the proper PHP supported, called PHP extensions, have to be installed in your PHP environment in order for PHP to communicate with a database engine. The PHP extensions that QLR Manager directly work with are listed in the third column of the table.

The second aspect is what are all the different data sources that QLR Manager can work with.When the ODBC extension for PHP is present, additional data sources can be accessed. This is listed in the last column of the table.

To see which PHP extension are installed, you can execute phpinfo.php, which is found in the QLR Manager root directory, as a URL entry in your browser. This will list the characteristics associated with your PHP environment.

Data Source Can be installed in
this database
Directly accessible when
PHP extension installed
Accessible through PHP
ODBC extension
IBM DB2 Yes Yes Yes
MySQL Yes Yes Yes
Oracle Yes Yes Yes
PostgreSQL Yes Yes Yes
SQL Server Yes Yes Yes
SQLite3 Yes Yes Yes
MS Access Yes
Excel Files Yes
Firebird Yes
SQLite Yes

Top

How can I install the IBM DB2 PHP extension to access DB2?

In order to install QLR Manager in a DB2 environment, PHP must be configured with the IBM DB2 extension. The key is to get the correct extension file for your environment. We have found that a Sourceforge project found at http://sourceforge.net/projects/db2mc/files/ is a good source. You should first execute phpinfo.php which is found in the QLR Manger root directory to determine your php version, thread safety and compiler settings. This will allow you to choose the correct package for your environment.

Note: You can access a DB2 database via an ODBC connection without installing the IBM DB2 PHP extension. But you cannot install QLR Manager in DB2 with the ODBC connection. You will also see improved performance when using the IBM DB2 extension as opposed to ODBC.

Top

Why do I sometimes receive Forbidden messages from the server?

If you receive the message:

Forbidden

You don't have permission to access /processreport.php on this server.

It is most likely resulting from a violation of a ModSecurity rule implemented on your server to help prevent SQL Injection attacks. Many hosting services are going to great lengths to "harden" their PHP environments and the number of strings that provoke ModSecurity violations has grown substantially in recent years.

During the installation of QLR Manager, a qlr.ini file is created in the install directory. There is a line in the qlr.ini file that must be set as follows:

Prior to V10: security = ;if,><,<html,<meta,&nbsp,@import,auto,concat(,doctype,href,iframe,insert,input,null,on,or,select,settimeout,script,selected,style,substring,text,union,v/,varchar(,background,inner,toString,having,eval(,substr(,location
These are SQL syntax that have been previously reported as causing Forbidden messages in some environments and are automatically added to qlr.ini during the install process. There may be other strings that could result in Forbidden. Discovering the string or words that may be causing the problem is achieved through trial and error. Once the offending string is isolated, it can be added into the qlr.ini as additional security entries, separated by commas.
V10 or later: security = Yes
These modSecurity rules are much easier to deal with starting with QLR V10. An _ (underscore) is inserted between each character submitted from the client browser as POST variables and decoded on the server. This eliminates the painstaking task of identifying specific strings.

Top

What support can I expect with a product purchase?

Tatler Software stands behind QLR Manager and provides the following free support for product purchases. This support extends to the current and one prior version of QLR Manager:

Always attempt to respond to installation and product questions within 24 hours.
Any inconsistency in product function that appears to be a result of a coding error always takes top priority with fixes provided as quickly as possible. If it is determined that the problem is the result of User error or the User's operating environment, Tatler Software may request that we be reimbursed for our efforts at a rate of $100 per hour.
All upgrades within a version that includes fixes, and often some additional function, are always free.
Provide lifetime support to change a license domain when it can be demonstrated the new domain replaces the current licensed domain or IP address.

We also offer generous discounts for version upgrades and investment protection for the purchase price of lower editions. Product customization, installation support and product training is available through our Consulting Services.

Top