Install Sqlite And Query Firefox Log Files Using SQL

September 10, 2014

Firefox saves a lot of log information in RDBMS files that can be queried in sqlite, using standard SQL commands.

SQLite3

SQLite3

 

To query the files, you have to have the right version of sqlite. Turns out that an old version was installed with my Redhat Linux 6.4 installation and I had to upgrade it in order to see the data. Here is how you can install the software and query the logs.

 

When I ran sample sqlite queries I found on the web, I got lots of errors:

sqlite3 ./cookies.sqlite 'select count() from moz_cookies'
Error: file is encrypted or is not a database


Read the rest of this entry »


Four Ways To Install Software On Linux

September 9, 2014

New to Linux?  Here’s some information that might be useful.

Linux is different from Windows in how software is installed. In Windows, starting with a CD, DVD, or an executable file, you run an executable file and install the software, usually via a GUI with prompts.

 

Redhat Desktop

Redhat Desktop

 

However, in Linux, there are at least 3 or 4 different ways to install software:

rpm packages
yum (related to rpm)
Unzip a file into a directory
Run an executable file or script   Read the rest of this entry »


Installing Gephi On 64 bit Machines

July 8, 2013

The instructions for installing Gephi can be found at:

https://gephi.org/users/install/

They seem simple enough. But I found out that on a 64 bit server, it’s really important that you have a full 64/64/64 bit combination. That represents the operating system, Java, and Gephi. Here are some hints to get it right.


Java
:

Be sure to download the right java file.   Read the rest of this entry »


Installing NVidia Drivers on Redhat 6.4 and Removing Nouveau

July 7, 2013

Recently I’ve been working with the graph database, NEO4J. Much of the usefulness of graph software is in visualizing it. So, I decided to install Gephi on Redhat 6.4. Gephi installed on Redhat easily enough. But it did not display the most important thing, the graph window!  :(

Gephi With No Graph Section

Gephi With No Graph Section

Debugging Gephi:

The Gephi website says:  “Gephi uses an OpenGL 3D engine to speed up graph visualization. However a compatible graphic card is required.”

Here’s how you can add some debugging to Gephi. Read the rest of this entry »


OBIEE 11.1.1.6.2 BP1 SampleApp v207 on Virtual Box 4.2.12

July 6, 2013

You might have read of how long and complex it is to install OBIEE directly onto Redhat.

OBIEE SampleApp v207 Desktop

OBIEE SampleApp v207 Desktop

This year I heard that there was a new Virtual Box image of OBIEE. The idea being: you install and start Virtual Box, then use the OBIEE virtual machine. Great idea. You should be able to get on with actually using OBIEE, not struggling with its installation, startup, and administration.

However, that would assume that all the components work. Like any technology stack.

Unfortunately for me, they did not.

Installing Virtual Box 4.2.12 r84980:    Read the rest of this entry »


At Least Nine Ways To Identify Hard Disks

June 25, 2013

After writing the long post, Secrets of BIOS, Grub, and Triple Boot Servers, I still had some notes left over.

Here’s some more detailed info on the many different ways that hard drives are identified in my server using: Phoenix BIOS, ASUS BIOS 1006, Sept 1, 2008. There are at least 9 different properties or ways to identify them.

Disk Drive Model Name WD10 Hitachi WD400
Hard Disk 3 4 5
Fixed Disk 0 1 2
Sata Port 2 3 4
IDE 3 4 5
BIOS Boot Order 2 3 1
Grub HD? (hd1) (hd2) (hd0)
Operating System Windows 7 Redhat 5.5 Redhat 6.4
/dev/sd? /dev/sdb /dev/sda /dev/sdc

Make sense? Quick, how many can you recall?

Note: Redhat 6.4 is the main boot disk. After booting Redhat 6.4, the /dev/sd? is what is indicated by running fdisk -l. Please read the previous post for the details.


Secrets of BIOS, Grub, and Triple Boot Servers

June 9, 2013

Have you read: Rodger’s Very Simple Dual Boot Method?

If you haven’t already, do check it out. One advantage: no Master Boot Record (MBR) modifications! Another advantage: it allows all disks and operating systems the option to be completely independent of each other. You can remove any disk, insert it into another machine, and it will boot perfectly fine. The disks are no longer married to each other. But mainly, this post won’t make any sense to you, otherwise.

A few months ago, I used this method with only two operating systems: Redhat 5.5 and Windows 7. Then recently, in the same server, I installed Redhat 6.4 onto a third disk. But suddenly I had an awful time getting all three to work.

Symptoms:

Redhat 6.4 booted Redhat 5.5 perfectly. But when I booted Windows from the Redhat 6.4 grub.conf file, I got the error:

File:  \BOOT\BCD
Status:  0xc0000001
Info:  An error occurred while attempting to read the boot configuration file

Redhat 5.5 booted Windows 7 perfectly. But when I tried to boot Redhat 6.4 from the Redhat 5.5 grub.conf file, I got the error:

Error 2: Bad file or directory type

So, I could only boot two of the three operating systems at one time.  To make things work, I’d have to be changing sata cables. That really defeated the purpose of a triple boot.

This was really mysterious, and no one on the newsgroups had any idea how to fix it. Mere mortals would have given up and implemented some kind of work around. :) But here is how I ultimately overcome the errors and got all the three disks to boot cleanly.  Read the rest of this entry »


%d bloggers like this: