Occassionally one or more tables in the database becomes corrupt. Fixing it is usually simple. Always be sure to make periodic backups of your database, just in case these tools do not work.

To test your database for corruption, issue the following command. You can include a table name at the end to just check a specific table, if desired:

mysqlcheck -u {USERNAME} {DATABASE} [TABLE]

Example:

C:\mysql5.0.45\bin>mysqlcheck -u root bytesphere alerts
bytesphere.alerts
warning  : 19 clients are using or haven't closed the table properly
error    : Found key at page 339968 that points to record outside datafile
error    : Corrupt

To fix it, make sure the system is shut down and not connected to it, then issue the following command including the -r switch to repair:

mysqlcheck -r -u {USERNAME} {DATABASE} [TABLE]

Example:

C:\mysql5.0.45\bin>mysqlcheck -r -u root bytesphere alerts

bytesphere.alerts                                  OK

Here we see that the mysql tool has fixed the alerts table. Now you can start up your application and attend to business as usual.

How To, JaguarSX corruption, database, How To

This error is caused by an incomplete PHP configuration. Both SOAP and XML extensions need to be enabled in PHP in order for the UI to work.

On linux, make sure the following packages are installed (PHP SOAP, PHP XML, PHP DOM). You can install them by typing in the following commands:

yum install php-xml

yum install php-soap

yum install php-dom

On Windows, make sure the php.ini file has the following extensions enabled in the php.ini file and then restart Apache:

extension=php_soap.dll

JaguarSX, KnowledgeBase Configuration, error, JaguarSX, PHP, SOAP, XML

This post is password protected. To view it please enter your password below:

Password:

How To, JaguarSX debugging, JaguarSX

The problem:

You get a message stating “Your system is not compatible with your license file or your license file does not exist!”

Very rarely, you may experience this error when trying to start OidView. Usually occurs after a system upgrade (hardware or software). What this means is that the HARDWARE-ID in the computer has changed (you can tell this by running OIDVIEW REGISTER from the command line).

The solution:

The problem is easily solved, all you must do is to transfer your old license with your original HARDWARE-ID to a new license with your new HARDWARE-ID. You can issue transfers at the following URL: http://www.oidview.com/key-request-txfr.html

For more information on how to license OidView (including license Transfers) please see the following URL: http://www.oidview.com/wordpress/2008/10/07/how-to-activate-oidview/

KnowledgeBase, OidView error, KB, licensing

OidView needs to activated to be completely licensed and work properly. To activate OidView, follow these steps:

1. Get the HARDWARE-ID

The HARDWARE-ID (also called the HARDWARE Fingerprint by the licensing system).

e.g.: ABCD-1234

It is NOT a MAC-ADDRESS. It is a unique one-way hash that is generated for your computer. It changes if you upgrade the OS, install a new disk drive, or install some major piece of hardware in your computer. Don’t worry, if it changes, you can “transfer” your OLD license and HARDWARE-ID to a new computer (or the same computer) with a different HARDWARE-ID.

The HARDWARE-ID can be obtained by:

a) In OidView, click Help -> Show HARDWARE-ID.

b) From the Command Line (in the OidView directory), type OIDVIEW REGISTER

2) Get your ORDER#

This is provided to you when you purchase the product. The ORDER# is a long number, sometimes with a dash and more numbers. Rarely is it a set of words or other characters.

e.g.: 103539845-1

3) Submit License Request

Simply go to the following URL with the HARDWARE-ID and the ORDER# and submit your request using your email address.

licenses:    http://www.oidview.com/key-request-main.html

Please note for license transfers and upgrades you will need the original HARDWARE-ID and the new HARDWARE-ID, and you will need to use a different url:

transfers:   http://www.oidview.com/key-request-txfr.html

upgrades:  http://www.oidview.com/key-request-upgrade.html

4) Check your email

There should be 2 emails arriving in your inbox within the next minute or so. One email will have the activation information on it, and the other should have both the activation information and the license keys themselves, as attachments. If you only receive ONE email, then you need to go to step 3 again, and either enter a different email address or uncheck the option “Send Key in Zip File”, as some mail servers block emails with certain attachments.

Inside the email you will have two lines specifying the USER and CODE. The USER should be your email address, the CODE should be a very long code of many characters and numbers (it may be longer than the example show here), e.g.:

USER  : webmaster@mycompany.com

CODE  : 000017-F30Q9V-XPZK44-Y3UC42-VX52UJ-KEP2C2-34WGYN-319V1K

5) Copy the license keys into the OidView directory

Usually they are named license.key and license.tms.key. These are NOT registry keys, do not try to enter them into the registry. They are encrypted binary files.

If there was a ZIP file, extract the 2 or more keys into the top-level OidView directory (usually Program Files\OidView). Otherwise, just save the attachments into this directory.

6) Activate OidView

Start OidView or type OIDVIEW REGISTER from the command line prompt. It will ask you for the USER and CODE. Here you will enter the USER and CODE you were given in the email.

Now, simply click the OK button and you should receive a message stating the key has been stored.

How To, OidView activation, hardware-id, licensing, OidView