for   
Save 
Save 
   Join IIUG  

Informix News
16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read
14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read
29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read
29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read
28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read
28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read
09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read
08 April 08 - IT-Director.com - Informix seeks developers... Read
18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read
17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read
17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read
16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read
16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read
28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read
27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read
14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read
14 June 07 - eChannelLine - IBM expands scope for IDS... Read
14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read
13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read
12 June 07 - IBM - IDS 11 release announcement (pdf)... Read
12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read
12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read
12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read
12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read
12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read
12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read
12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read
12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read
12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read
12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read
12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - golem.de - Informix 11 vorgestellt... Read
12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read
12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - Heise - IBM gibt Informix 11 frei... Read
25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read
18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read
18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read
7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read

Previous news items
 

Home Member Area About IIUG


Resources
IIUG Insider
IIUG Hotspots
IBM-Informix Links
IIUG RSS Feeds
Software Repository
Informix Products
Online Resources
Informix Library
Informix Books
IIUG Banners
Discussion
Technical Special
  Interest Groups

Other Discussion
Community
Events
Webcasts/Chat w Lab
IIUG TV
IIUG Sponsors
Informix Business Directory
IIUG Press Partners
Local User Groups
Rate the Vendor
Job Board
Fun Stuff

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

IDS - PAM AUTHENTICATION ANYONE WHO HAVE ACTUALLY MANAGED TO USE IT PLEASE???

Posted By: Stefan Sammut
Date: Thursday, 28 July 2005, at 7:14 a.m.

Hello People.

We've been trying to use the IDS PAM authentication module for the past 2
weeks, but we seem done only a little progresses.
We followed the release notes under $INFORMIXDIR/release/en_us/0333/pam.txt;
The sqlhosts file is set up as follows.

tadinda_tcp onsoctcp acilia 1525
s=4,pam_serv=(informix),pamauth=(challenge)

The informix file (pam_serv) under /etc/init.d reads as follows:
#%PAM-1.0
#auth optional pam_toledo.so /usr/informix tadinda_tcp
auth required pam_rps.so debug
account required pam_rps.so debug
password required pam_rps.so debug
session required pam_rps.so debug

We have tried many of the available services ( pam_unix_passwd,even our
own!) , but with this configuration (using the pam_rps service) we the
nearest since when running the esqlc pam_demo example prompts back with a
challenge. However it consistently returns the -1809 error!

We're running IDS 10.0.3 and seems pam documentation is rather misleading
and incomplete. We looked throughout the whole net but found nothing
helpful. We need to use PAM with PowerBuilder and so far we've managed to
get PowerBuilder 10 to talk to an esqlc generated DLL (already a big step).
The first person who manages to get the callback function example working,
we can update IIUG with new relevant PAM documentation including
PowerBuilder connectivity.

Many thanks for your help.

The esqlc pam_demo ($INFORMIXDIR/demo/esqlc/pam_demo.ec reads as follows:

#include <stdio.h>
#include <string.h>

#define PAM_PROMPT_ECHO_OFF 1
#define PAM_PROMPT_ECHO_ON 2
#define PAM_ERROR_MSG 3
#define PAM_TEXT_INFO 4
#define PAM_MAX_MSG_SIZE 512

EXEC SQL define FNAME_LEN 40;
EXEC SQL define LNAME_LEN 40;

int callback(char *challenge, char *response, int msg_style);

int main()
{
EXEC SQL BEGIN DECLARE SECTION;
char fname[ FNAME_LEN + 1 ];
char lname[ LNAME_LEN + 1 ];
char dbpass[20];
char dbuser[20];
char dbname[20];
EXEC SQL END DECLARE SECTION;

int retval = 0;

/* First register the callback. This needs to be done before establishing
the
* connection as done here.
*/

printf("Starting PAM demo \n");
EXEC SQL WHENEVER ERROR STOP;

retval = ifx_pam_callback(callback);

if (retval == -1)
{
printf("Error in registering callback\n");
return (-1);
}
else
{
printf("Callback Registered. Status=%d\n",retval);
strcpy(dbpass,"mibobva");
strcpy(dbuser,"acilia");
strcpy(dbname,"cell");
printf( "Callback function registered.\n");
/* EXEC SQL connect to :dbname user :dbuser using :dbpass; */
EXEC SQL database :dbname ;
printf ("SQLCODE ON CONNECT = %d\n", SQLCODE);

EXEC SQL declare pamcursor cursor for
select customer,name
into :fname, :lname
from slcustm;

EXEC SQL open pamcursor;
for (;;)
{
EXEC SQL fetch pamcursor;
if (strncmp(SQLSTATE, "00", 2) != 0) {
break; }

printf("%s %s\n",fname, lname);

}

if (strncmp(SQLSTATE, "02", 2) != 0)
printf("SQLSTATE after fetch is %s\n", SQLSTATE);

EXEC SQL close pamcursor;
EXEC SQL free pamcursor;

EXEC SQL disconnect current;
printf("\nPAM DEMO run completed successfully\n");
}
}

/* The callback function which will provide responses to the challenges. */

int callback(char *challenge, char *response, int msg_style)
{

printf("%s\n",challenge);
switch (msg_style){
case PAM_PROMPT_ECHO_OFF:
case PAM_PROMPT_ECHO_ON :
printf("%s: %d:\n",challenge, msg_style);
scanf("%s:",response);
break;

case PAM_ERROR_MSG:
case PAM_TEXT_INFO:
default:
printf("%s: %d\n",challenge, msg_style);
}
return 0;
}

Stefan Sammut
Software Engineer
Philip Toledo Limited
Computer & Communications Solutions
Notabile Road, Mriehel BKR01, Malta
Tel: (+356) 2144 5566
Fax: (+356) 2148 4316
Website : www.ptl.com.mt

The information contained in this email is confidential and may be
privileged. It is intended for the addressee only, if you are not the
intended recipient please notify the sender and delete the email
immediately. The contents of this e-mail must not be disclosed or copied
without the senders consent. We cannot accept any responsibility for
viruses. Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be the view of
Philip Toledo Limited


----- Original Message -----
From: "Colin Bull" <Colin.Bull@videonetworks.com>
To: <ids@iiug.org>
Sent: Wednesday, July 27, 2005 3:34 PM
Subject: RE: oninit error .. [5501]


> SANTOSH NIKUMBH wrote
>
> >One more update for this . I get the following in the log :-
> >16:12:29 listener-thread: err = -25572: oserr = 227: errstr = :
> Network driver cannot
> >bind a name to the port.
> > System error = 227.
>
> ------------------------------------------------------------------
> >Does it mean that my entry in the "services" file is NOT proper ?
>
> >I have made an entry in /etc/services file as :-
>
>
> >padbv2 3400/tcp #informix padbv2 instance
>
> What does 'grep padbv2 $INFORMIXDIR/etc/sqlhosts'
>
> output (assuming Unix platform)
>
> Colin Bull
>
> =======================================================================
> This email may contain confidential and privileged information and is
intended for the named or
> authorised recipients only. If you are not the named or authorised
recipient of this email,
> please note that any copying, distribution, disclosure or use of its
contents is strictly
> prohibited. If you have received this email in error please notify the
sender immediately and
> then destroy it. The views expressed in this email are not necessarily
those held by VNL, and VNL
> does not accept any liability for any action taken in reliance on the
contents of this message.
> VNL does not guarantee that the integrity of this email has been
maintained, nor that it is free
> of viruses, interceptions or interference.
>
> _______________________________________________________________________
> This email has been scanned for all known viruses by the MessageLabs Email
Security System.
> _______________________________________________________________________
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.9.5/58 - Release Date: 25/07/05
>
>

Messages In This Thread

  • IDS - PAM AUTHENTICATION ANYONE WHO HAVE ACTUALLY MANAGED TO USE IT PLEASE???
    Stefan Sammut -- Thursday, 28 July 2005, at 7:14 a.m.
    • Re: IDS - PAM AUTHENTICATION ANYONE WHO HAVE ACTUALLY MANAGED TO USE IT PLEASE???
      Stefan Sammut -- Friday, 29 July 2005, at 2:39 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.

©2001 - 2007 International Informix Users Group.   All rights reserved.     Terms of use    
*** Powered By IBM Informix Dynamic Server V10.00 ***