Linux, Office

Installing Ingres….

I was little unwell last week and before, and not being able to do the work i was doing, i was moving around the office, When Balaji asked me to help him to install linux.  Being Me, i asked why you want to install Linux?  He said, he had to test if the enterprise version of our product will work on ingres database.  My First thoughts were (seriously) WTF is ingress(later i found that it was ingres and not ingress)?  And that is how i ended up doing it for him, and that is why i am here writing this.  I wanted to write it here, only after completing the entire exercise.  or atleast after everything was completed.  (Connecting from a machine other than the server(localhost) is not yet working).  But anyway connectivity issues and installation are different.  So without bragging and dragging, let us proceed with how to install Ingres in Linux.
For this exercise i used a RHEL5 machine setup on VirtualBox.  You need to have UI.  I am listing those steps which i had recieved as instructions when i had called up technical support of Ingres.
  1. create a user called ingres.
  2. create a group called ingres.
  3. add the user ingres to the group ingres.
  4. login as root.  yes you read that right, no logging in as normal user and changing into root by issuing switch user command.  the guy gave up on me when i told i did a su to become root and did the install, when we faced the connectivity issue.  So better login as root, if you might be calling the tech support any time.
  5. create two directories ingres_src and ingresII under /opt. (it ain’t case sensitive, you can name it anyway, but the guy said it is his way that he always keeps the names in small case, unless and until mentioned not to)
  6. move the installation gzip file and unzip it into ingres_src folder.
  7. change into that directory and execute ./ingres_install
  8. In the First Screen choose your Configuration Type.  I choose Transactional System.
  9. In the next Screen choose the Installation Mode as ‘Advanced‘.
  10. Instance Name should be IngresII (two capital I)
  11. In the Component Select Screen select Custom.  Uncheck Ingres Replicator and Ingres Star.
  12. Set the Installation Location to the folder which we created next /opt/ingresII.  Leave the rest as such
  13. Set the transaction log file size to half the size of the total RAM available to the system.  If you would be running any other applications in the machine, then calculate the memory with what would be left after satisfying the other applications memory requirements.
  14. Set your locale settings.  Do not change the Character Set.
  15. Do not enable Strict SQL Compliance
  16. Choose the Date Type as ANSI Date
  17. Set the Instance Owner user as ingres and group as ingres
  18. UnCheck Start Ingres with computer, and Check create a demo database.
  19. Well that’s it, Ingres should successfully install and start.
To make sure that the Installer started the server, login as ingres user and issue the command ingstatus.  If you get error saying command not found or something like that, you better logout and then login.  If it still does not work, go the home folder of the user ingres and look for file named .ingIIbash and .ingIItcsh, copy the contents of .ingIIbash to .bash_profile of ingres user and then logout and login again. now it will work.  The output will be something as follows
Now if it hasn’t started issue the command ingstart and wait till the control returns to you.  now in terminal type
sql demodb
and press enter, you will be taken into the screen where you can execute the queries. to come out of it type \q and press enter.  to stop the server use the command ingstop.

Windows as a Guest on a Linux (ubuntu) host

After having been through all those days of triple boot and quadruple boot systems, i am coming back to a single boot machine now.  This time with my work laptop with Ubuntu as the main and the only OS.  Since i knew i could never complete that dream of running everything from linux in my work place in the near future, i decided to go with the only other choice to achieve it with immediate effect.

So what are my work place requirements. i need to have a firefox with silverlight.  That is the only thing for which i need Windows, ok, may be occasionaly for something else like, i don’t know…. I can’t think of any thing else.  and though even that can be circumnavigated with Wine, the video chat on gmail is another thing which will become a road block.

So to solve these, i decided to install Windows on Virtual Box with Ubuntu as Host.  This i thought will solve the problem.  But, yeah it did solve the problem of firefox with silverlight.  But Virtual Box is not allowing to enable to use of webcam to the guest OS.  It has to be a small problem somewhere i think.  Will look into it.  And to solve the problem of not having a anti-virus, I am allowing internet only to firefox, and have removed the access to the rest of the system.  I did it with Squid on the host.  It feels good, to be close to achieving the original thought.  But i can live with a little Evil i guess.

For Virtual Box installation i followed the instructions in this page under the title Debian Based Distributions.  Just in case if you are not able to open it.

add the following line in your repositories list in Synaptic Package Manager (settings -> repositories -> other software)

deb lucid non-free

add the key to the Synaptic Package Manager (settings -> repositories -> authentication)

then say

sudo apt-get update
sudo apt-get install virtualbox-3.2

That should do it.  I mean that is all i did. and i had to go thru this to understand how to access shared folders form host to guest and why the display resolution went to 800×600 when i made the shared folder access to work.  It was frustrating, the display always going to 800×600 from 1024×768  finally figured out, that it was the Virtual Box Display Driver which was causing it.  Then i just uninstalled just the display driver, and override it with the default driver whatever windows took itself.  And that is it.  Things are working fine for now.  Just the small thorn of WebCam access from host to guest.  Will soon try to find a way out.


AutoStart TweetDeck during System Startup

i was cleaning up my laptop today.  Totally cleared of everything from it and did a fresh install of Ubuntu.

Played around with Gwibber, but somehow did not like it.  Couldn’t see it working 20 minutes after configuring and logging.  It was showing only one direct message which i had recieved 2 days back.  so removed the account in Gwibber.  Searched around for some other twitter clients. Chanced upon Tweet Deck.  I have seen some of my colleagues us it in office.  so thought of giving it a try.  It seemed a little confusing at the beginning, but after a while got a hang of it.  Then i noticed that it was not starting automatically at system startup.  So did it manually.

First i looked around for the command which was launching TweetDeck.  Had to add the shortcut under Applications -> Accessories -> TweetDeck to the panel, and then opened the properties by right clicking the TweetDeck icon in the panel.  Copied the launch Command from there.

Now i went to System -> Preferences -> Startup Applications.  I Clicked on Add button and then Pasted the command in the Command text box.  While i was there, filled up the rest of the boxes too.  And then clicked Add and closed the window.

Well that’s it.  From the next time, TweetDeck starts during system startup, so i don’t have to remember to start TweetDeck everytime system starts up.

Linux, What the...

Chrome Crash2

My woes with Chrome Unstable build still continues.  I tried opening it after installation it crashes again.  I tried to open it again from terminal and i got this output, anyone there who can understand this.

anbarasan@anbarasan-laptop:~$ google-chrome
[31492:31517:5214051937:FATAL:chrome/browser/sync/syncable/] Check failed: SQLITE_DONE == query_result.
–2010-05-01 18:48:55–
Connecting to||:443… connected.
HTTP request sent, awaiting response… 200 OK
Length: unspecified [text/html]
Saving to: `/dev/fd/3′

[<=>                                                                                                                 ] 0           –.-K/s
Crash dump id: ccecdccf19b0deb5
[ <=>                                                                                                                ] 16          –.-K/s   in 0s

2010-05-01 18:48:59 (543 KB/s) – `/dev/fd/3′ saved [16]


Anyway armed with this knowledge, now i will wade thru the internet in search of a solution.

Linux, Open Source

OMG! My Web Cam works!

Wow!  Lucid did its first wow, and may be the only wow i suppose.  My web cam works.  now i can use every piece of hardware that is present in my laptop.  I can’t say that the problem was linux.  Actually the problem was my webcam, it did not come with drivers for linux.  some wise geeks out there, had tried and had developed drivers for this brand, which had 3 variants, and mine was stamped as the hopeless variant (Genesys Logic – gspca_gl860).  After a valiant effort by me and my friends for 3 days during February, we gave up saying it was impossible.  We made the system to recognize the webcam, but to make it work, to make it show the view, we weren’t able to.   I took a pic of me

First Pic with my Laptop WebCam in Linux.

I used Cheese to take this picture.  I know it is not that great.  but come on, my web cam is working……….

Linux, What the...

Upgrading Karmic to Lucid.

As I said in the previous post.  I tried to do what was said in ubuntu website to upgrade to lucid. i pressed Alt+F2 and then typed update-manager -d and pressed enter, Update Manager opener, there was a message at the top that Ubuntu 10.04 was available, and i clicked the upgrade button, but then after some 15 seconds a message comes saying that Could not download Release Notes. Please check your internet connection.  The internet is working, i was checking the ubuntu website that time.

A little Google Check confirmed that some others to have faced this error.  One person told after doing a complete update of latest packages in Karmic, the problem got solved.  Assuming that could be the problem, i sat thru another half hour of updates.  Then again when i tried to upgrade to lynx, i got the same error.  I searched some more, but could not find anything,

Then i saw there was some upgrade notes, which talked about some software which could be causing problems.  I followed thru everything, which started the installation, in the screen after release notes, it said, again some problem, with updating software, and said it will not continue. (I had to u ninstall, Chrome, VLC, Mplayer)

Defeated I decided to  download the alternate install CD to do the upgrade.

After 2 power cuts during download and  me blacking out for the rest of the night.  I resumed again.  I had backed up a few files of mine to Ubuntu One. Then mounted and started the upgrade.  Everything went fine.  Upgrade completed after a wait of 2 hours.  And restarted into Lucid.  It was disappointing.

The Grub Menu was black again.  this is not nice, atleast something more colorful, like Chamelon would have been nice.  or atleast theming options would have been great,  But still it is black, then the screen remained black for the entire time it moved to the login screen, when i saw the new purple theme.  Ok now the login screen looks nice than the previous one.

After logging in it was even more disappointment.  The system was slow as hell, nothing was responding,  Accessing the menus froze the system.  I feared for a result worse than what i had achieved with mandriva.  So I pulled the plug, and went off to get sleep some more.

Later sat thru and decided that those xubuntu desktop which i had installed was somehow causing these problems.  System Update said it can do a partial upgrade, which confirmed my suspictions.  i did a

sudo apt-get remove xubuntu-desktop

, which did not work.  the other software was not removed.

Then again searching i arrived at a page saying you could easily remove things with aptitude instead of apt-get.  Which gave me the thought that i am right path of removing xubuntu-desktop, to get my system back to performing like before.  then i did a

apt-get install xubuntu-desktop

after completion, i searched the internet to remove xubuntu-desktop completely.  again psychocats came to my rescue.  I executed the command.

sudo apt-get remove a2ps abiword abiword-common abiword-plugin-grammar abiword-plugin-mathview app-install-data-commercial aumix aumix-common catfish exaile exo-utils fortune-mod fortunes-min gigolo gimp gimp-data gnumeric gnumeric-common gnumeric-doc gtk2-engines-xfce libabiword-2.8 libaiksaurus-1.2-0c2a libaiksaurus-1.2-data libaiksaurusgtk-1.2-0c2a libbabl-0.0-0 libexo-0.3-0 libexo-common libgdome2-0 libgdome2-cpp-smart0c2a libgegl-0.0-0 libgimp2.0 libgoffice-0.8-8 libgoffice-0.8-8-common libgtkmathview0c2a libjpeg-progs liblink-grammar4 libmng1 libotr2 libots0 libpsiconv6 librecode0 libscim8c2a libsdl1.2debian-alsa libsexy2 libt1-5 libtagc0 libthunar-vfs-1-2 libwv-1.2-3 libxcb-keysyms1 libxfce4menu-0.1-0 libxfce4util-bin libxfce4util-common libxfce4util4 libxfcegui4-4 libxfconf-0-2 libxmlrpc-core-c3 link-grammar-dictionaries-en mousepad murrine-themes orage oss-compat pidgin pidgin-data pidgin-libnotify pidgin-otr psutils python-cddb python-mmkeys python-mutagen python-sexy ristretto scim scim-bridge-agent scim-bridge-client-gtk scim-gtk2-immodule scim-modules-socket scim-modules-table scim-tables-additional tango-icon-theme tango-icon-theme-common tcl thunar thunar-archive-plugin thunar-data thunar-media-tags-plugin thunar-thumbnailers thunar-volman thunderbird ttf-lyx usb-creator vim-runtime wdiff xchat xchat-common xfce-keyboard-shortcuts xfce4-appfinder xfce4-clipman xfce4-clipman-plugin xfce4-cpugraph-plugin xfce4-dict xfce4-fsguard-plugin xfce4-mailwatch-plugin xfce4-mixer xfce4-mount-plugin xfce4-netload-plugin xfce4-notes xfce4-notes-plugin xfce4-panel xfce4-places-plugin xfce4-power-manager xfce4-power-manager-data xfce4-quicklauncher-plugin xfce4-screenshooter xfce4-session xfce4-settings xfce4-smartbookmark-plugin xfce4-systemload-plugin xfce4-terminal xfce4-utils xfce4-verve-plugin xfce4-volumed xfce4-weather-plugin xfce4-xkb-plugin xfconf xfdesktop4 xfdesktop4-data xfprint4 xfswitch-plugin xfwm4 xfwm4-themes xscreensaver xubuntu-artwork xubuntu-default-settings xubuntu-desktop xubuntu-docs xubuntu-gdm-theme xubuntu-icon-theme xubuntu-plymouth-theme xubuntu-wallpapers && sudo apt-get install ubuntu-desktop
Then, as if it was magic, everything was back to normal, the system was performing cool.  The sluggishness had gone off.
The system is working fine, now i have installed VLC again, have to install libdvdcss, chrome and picasa again.  Then i am off to check how Lucid is….

Upgrading to Ubuntu 10.04 (Lucid Lynx)

Lucid is released today,  and i am gonna upgrade.  i just booted in to Karmic.  writing this as i am preparing for upgrading.  This is gonna be my second time doing an upgrade.  Am yet to do a successful upgrade.  The last time i did an upgrade was from Mandriva 2008 Spring to Mandriva 2009, which ended up being a cross between both the versions.  after that this is the first time i am gonna do an upgrade. Fingers Crossed.  i am doing the upgrade in my laptop.  i don’t think my desktop could handle lucid.  Will try that later.  I am just waiting to see how the lucid is gonna wow me.!!!

Linux, What the...

Chrome Crash!!!

I don’t know what i did, but Chrome keeps crashing in ubuntu in my laptop for the past 2 weeks even after two updates.  I don’t know why.  I even removed it via synaptic (with the option saying Remove Completely).  restarted the machine, and then installed it again, only to find it saying chrome did not close properly message, and crash again.

But no such issue was happening in the Desktop or on windows in my laptop.  I was kinda missing it, so i decided to go uninstall the unstable one and install the beta one.  Any one else having the same issue out there with the unstable builds….


An improved Desktop…..

Like i had said in the previous post, i installed xfce or xubuntu-desktop.  First i installed it in my laptop, and played around.  it was nice, Though i couldn’t find any difference in performance in my laptop (core 2 duo, 2 GB of Ram).  It was slightly different and interesting.  But after around an hour or so, i was stuck with my first 2 issues.

  1. My USB Hard drive / flash drives were not getting automatically mounted as in Gnome.
  2. In VLC i was not able to access the Playlist window or the Equalizer window when playing a movie.

I did check both right then and there by logging out and then logging back into GNOME.  There they worked.  i don’t know why.  But anyway other than these two i did not find anything else out of place or a reason to cause trouble when others in house would use it.  So i decided to get it into my desktop machine.

Well, i was expecting at least some improvement in the experience.  But it was still same as GNOME, slow and sluggish.  I couldn’t understand, how come?!!  there’s got to be at least some improvement.  Since the whole effort was down the drain, i decided to go ahead with the next logical step, to see if any unwanted things were running in the background.  I noticed GUAKE and Evolution alarm something running, which we never use.  so i switched them off from starting up during startup.  I went to

System -> Preferences -> Startup Applications

and unchecked the check box for the two applications.  and restarted the system.  Wow.  now the system was responsive.  so it had been GUAKE auto start which was causing the sluggish desktop.  well, now i can use the Desktop without having to worry about long wait times. atleast not 10 – 12 seconds…..


researching xfce…

Dad has started to complain that the system’s responsiveness is becoming less and less day by day. (you load junk, then it is sure to go down).  Well any way,  Now how can i make it responsive, i mean i have to wait atleast 6 – 7 secs for firefox or chrome to open, and the system appears to have frozen during that time, now image if i have to open openoffice writer, it will take another 10 – 15 secs.  and running multiple tabs and switching between, you can go out have coffee and come back.  You wanna play cafeworld or farmville, i pray for all blessing, coz it’s gonna sleep.  So i have decided to push xfce as the UI to dad.  I know he will be a little hesitant, but he would accept if the system performs well.  I don’t know why he was not liking xfce.  i have researched for the past two days and have hit upon a few links which i am going to use as  the base and give it a try to install.  First on my laptop and then on the Desktop.  Will get back after installing.