Kathiravan's

Thursday, November 3, 2011 Written By: Kathiravan Manoharan

XAMPP: Another web server daemon with SSL is already running

This is a peculiar error you will get if you run XAMPP in LINUX.

Assumption: XAMPP is unzipped @ /opt/ folder.

If you get the error "XAMPP: Another web server daemon with SSL is already running" when you run "./lampp start". Simply follow the steps below to get rid of this error:

1. Open the file /opt/lampp/etc/httpd.conf
2. Search the "Listen 80" and change it to some other port (e.g. Listen 2145)  (Line No. 40)
3. Open the file /opt/lampp/etc/extra/httpd-ssl.conf
4. Search the "Listen 443" and change it to some other port (e.g. Listen 16443) (Line No. 39)
5. Open the file "/opt/lampp/lampp"
6. Search for the port "testport 80" and replace it to "testport 2145". Also change the "testport 443" to "testport 16443". (Happens to be the Line No. 197, 214)
7. Now go and run "/opt/lampp/lampp start". (It should work now).

Hope this Helps :-)

Wednesday, September 7, 2011 Written By: Kathiravan Manoharan

Informix Database Connectivity from PHP Application Server

Source: http://www.iiug.org/library/ids/technical/sg247218.pdf

$link = ifx_connect("sysmaster@on1000UC3soc","informix","123456");
if ( !$link ) {
        printf("");
        printf("Connect: Returncode %s -- %s \n",ifx_error(), ifx_errormsg());
        printf("");
        exit();
}
$tab_list = ifx_prepare ("SELECT tabname FROM systables",$link);
$return=ifx_do($tab_list); Chapter 5. PHP applications with Informix database servers  221
if ( $return == 0 ) {
        printf("");
        printf("Select: Returncode %s -- %s \n",ifx_error(), ifx_errormsg());
        printf("");
        exit();
}
ifx_htmltbl_result($tab_list,"border=\"2\"");
ifx_free_result($tab_list);
@ifx_close($link);
?>

-----------------------------------

Example 5-24   Missing INFORMIXSERVER in the Apache environment
/usr/local/bin/php ifxconnect.php

Warning: ifx_connect(): E [SQLSTATE=IX 000  SQLCODE=-25560] in 
/usr/local/apache2/htdocs/ifx/connect/ifxconnect.php on line 3
Connect: Returncode E [SQLSTATE=IX 000  SQLCODE=-25560] -- Environment 
variable INFORMIXSERVER must be set.


-----------------------------------

Example 5-23   Missing INFORMIXDIR in the Apache environment
/usr/local/bin/php ifxconnect.php

Warning: ifx_connect(): E [SQLSTATE=IX 001  SQLCODE=-1829] in 
/usr/local/apache2/htdocs/ifxconnect.php on line 3

-----------------------------------

Example 5-21   Database server name in connection string is wrong
/usr/local/bin/php pdoconnect.php

Error!: SQLSTATE=HY000, SQLDriverConnect: -25555 [Informix]
[Informix ODBC Driver][Informix]Server on1000UC3soc1 is not listed as a 
dbserver name in sqlhosts.

For more information:


Featured Blog Topics:

Saturday, June 11, 2011 Written By: Kathiravan Manoharan

Test PHP Informix Connectivity

<?php

error_reporting(E_ALL);
putenv("INFORMIXSERVER=ol_ids_1150_1");
$conn_id = ifx_connect("sysadmin@ol_ids_1150_1", "informix", "password");
$x = ifx_query("select * from mon_table_names",$conn_id);
ifx_htmltbl_result($x, "border=\"1\"");
?>

Wednesday, June 8, 2011 Written By: Kathiravan Manoharan

Excellent opening as a PHP Architect with Tekmindz Noida location

From: Litisa DCG Professionals <recruiterpoornimat@gmail.com>

Experience required for Job: 8 - 10 years
Job Annual Salary: Not Mentioned
Job location: Delhi/NCR

I got your reference regarding the openings with Tekmindz Noida Location . If your profile matches to the require ment you are interested kindly send me your updated resume ASAP. Else I request you to refer some relevant candidate for the same.

If interested please provide us with your update resume with all the mentioned details:
Name:
Qualification:
Current Organization:
Current Designation:
Current CTC
Expected CTC
Total Exp:
Relevant Exp:
Joining Time / Notice Period:
Current Location
Date of Birth:

Work Location:Noida
Exp: 8+yrs
Skill Set:
Very good exp in PHP
Exp on Symfony framework

Thanks
Poornima

Friday, March 4, 2011 Written By: Kathiravan Manoharan

Informix - How to Install - Step by Step Guide


Installing Informix Server

Download the Installer File

1. Download the informix server developer edition from http://www.ibm.com/developerworks/downloads/im/ids/dev.html

            a) You may have to create a new IBM id (if you don't have already) to download this installer.

2) Extract the downloaded zip file

Windows User Account

3) Create a windows user

            a) Right click "My Computer" -> Manager -> Local Users & Groups
            b) Create a new user called "informix" with password
            c) Ensure that the "password never expires" option is checked

3) Execute the "ids_install.exe" file to start informix server installation

Typical Installation

4) Click "Next" until you get the "Setup Type" screen, wherein please choose "Typical" installation

Informix User Password

5) The setup will ask for informix user password. Enter the same "password" as you'd provided in the step 3 (creating windows user)

6) The setup should now install the server, client sdk and other required softwares in your system. Complete the installation.

Thus Installation Completed

----------------------------------------------------------------------------

Post Installation Configuration

1) After the installation you should have two new menus in Start -> Programs

            a) IBM Informix 11.70
            b) IBM Informix Client SDK

2) Go to Start -> Programs -> IBM Informix 11.70 -> "Server Instance Manager"

            a) You should now see any existing server instances
            b) If not, create a new one with default values
            c) Note all the default values and click “continue”.

            Informix Server         
                        - Database server located on the host machine
            HostName [default: your-machine-name]  
                        - Name of the host machine with the Informix database server
            Protocolname [default: turbo]          
                        - Protocol determined by the configuration on the host machine
            Service Name          
                        - Service determined by the host configuration to communicate to the designated database instance


Select “Create New”


Note: Server number should be unique for every instance


Note: Server name should be unique for every instance


Note: Service name, port number should be unique for every instance


Provide the password of the Informix user created in windows


-         Continue with the default values


Select “Yes”

A new menu item called "server-name" in Start -> Programs -> IBM Informix 11.70 should have been created by now.

----------------------------------------------------------------------------

Access Informix Database

Now you are all set to access informix database.

1) Go to Start -> Programs -> IBM Informix 11.70

2) Select any of the server instances [Example: ol_chn2422]


3) Type “dbaccess” and press enter


4) You should now be able execute sql queries using “Query-language”

Note: dbaccess is a command line tool, can be used to execute queries, create databases, create tables, insert rows, alter tables etc.,

For more information:


Featured Blog Topics:




Monday, February 21, 2011 Written By: Kathiravan Manoharan

12 New File Formats in Google Docs Viewer

Exciting news from google...

Now, it supports 12 New File Formats in Google docs.
  • Microsoft Excel (.XLS and .XLSX)
  • Microsoft PowerPoint 2007 / 2010 (.PPTX)
  • Apple Pages (.PAGES)
  • Adobe Illustrator (.AI)
  • Adobe Photoshop (.PSD)
  • Autodesk AutoCad (.DXF)
  • Scalable Vector Graphics (.SVG)
  • PostScript (.EPS, .PS)
  • TrueType (.TTF)
  • XML Paper Specification (.XPS)
So, if someone sents a PSD or .AI file to your email, you will be able to view it from anywhere in the world without having installed those applications. Enjoy...

Friday, January 28, 2011 Written By: Kathiravan Manoharan

JQuery Events - Example

JQuery Events:


$(“#id”).change(….
$(“a”).click(….
$(“a”).hover(….

Other Events
focusin, focusout, keydown, keyup, scroll, select, submit

Example for JQuery Events



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
  <title>Example - Events</title>
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js" type="text/javascript"></script>
  <script language="javascript">
$(document).ready(function(){
 $('#hide').click(function(element){
$('#hide').attr("disabled","disabled");
//<input id="hide" type="button" value="Hide" disabled="disabled"/>
$('#paragraph').slideUp('slow');
 });
});
  </script>
 </head>

 <body>
 <input id="hide" type="button" value="Hide" />
 <div id="paragraph">
 This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph.
 </div>
 </body>
</html>

Tuesday, November 30, 2010 Written By: Kathiravan Manoharan

Introducing Google TV!

Do you wonder what is next from Google? 
Here is the answer "Google TV"

Features:
  • Your TV will have a homepage :-)
  • Search your favorite TV Programs
  • Your mobile may act as a Remote Control
  • Browse and watch TV Simultaneously
  • Easy to setup and works with your existing TV and Internet
To know more about Google TV:


Happy Watching....

Thursday, September 16, 2010 Written By: Kathiravan Manoharan

Google Me

Eric Schmidt has confirmed that we could be getting "Google Me" sometime this Fall. This Google Me service will introduce what Google calls "a social layer" into online search, video and Google Maps.


Wednesday, September 15, 2010 Written By: Kathiravan Manoharan

Vertical Align Center/Middle in CSS

How to Align an element/content?

Though we have "vertical-align" style available in css, it doesnt work as expected.

To make it work, pls refer the following example


  <!doctype html public quot;-//w3c//dtd html 4.0 transitional//enquot;>
<html>
 <head>
  <title> new document </title>
 </head>

 <body>
<div style=quot;border: 1px solid red; height: 100px; width: 100px; display: table-cell; vertical-align: middle; text-align: center;quot;>
<img src=quot;http://img1.moneycontrol.com/images/top2010/cnbc_logo.jpgquot; style=quot;border: 1px solid red;quot;/>
</div>
 </body>
</html>

Happy CSS!!!

 

Featured Blog Topics:-