Re: FW: C API for ARDBC Plug-in
Thanks, Jarl!
Just one question: there's a mapping->mappingList[i].u.vendor.fieldName that
must be filled as it is the field name to use. There is (I believe) where my
problem starts. How do you fill that property?
// Fields' mappings
if(mapping != NULL) {
mapping->numItems = numItems;
if((mapping->mappingList = (ARFieldMappingStruct
*)calloc(mapping->numItems, sizeof(ARFieldMappingStruct))) == NULL)
return AR_RETURN_ERROR;
mapping->mappingList[0].fieldType = AR_FIELD_REGULAR;
mapping->mappingList[1].fieldType = AR_FIELD_REGULAR;
}
Com os melhores cumprimentos,
Kind regards,
Cordialement,
Paulo Moreira
Compta
Business Solutions
Engenharia
Email : [EMAIL PROTECTED]
Tel. : (+351) 21 413 42 00
Fax : (+351) 21 413 12 20
www : http://www.compta.pt
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Jarl Grøneng
Sent: terça-feira, 19 de Fevereiro de 2008 12:24
To: arslist@ARSLIST.ORG
Subject: Re: FW: C API for ARDBC Plug-in
This may work after some changes:
--
ARPLUGIN_EXPORT int ARDBCGetMultipleFields(
void *object, // IN; plug-in instance
ARCompoundSchema *schema, // IN; form containing the data ARFieldMappingList
*mapping,// OUT; list of fields
ARFieldLimitList *limit, // OUT; corresponding field limits
ARUnsignedIntList *dataType,// OUT; corresponding data types
ARStatusList *status // OUT; status of the operation
)
{
int numItems = 2;
ARPluginVaLog(logFunc, AR_PLUGIN_LOG_INFO,
"ARDBCGetMultipleFields, ...");
// Fields' mappings
if(mapping != NULL) {
mapping->numItems = numItems;
if((mapping->mappingList = (ARFieldMappingStruct
*)calloc(mapping->numItems, sizeof(ARFieldMappingStruct))) == NULL)
return AR_RETURN_ERROR;
mapping->mappingList[0].fieldType = AR_FIELD_REGULAR;
mapping->mappingList[1].fieldType = AR_FIELD_REGULAR;
}
// Fields' limits
if(limit != NULL) {
limit->numItems = numItems;
if((limit->fieldLimitList = (ARFieldLimitStruct
*)calloc(limit->numItems, sizeof(ARFieldLimitStruct))) == NULL)
return AR_RETURN_ERROR;
// Field 'Request ID'
limit->fieldLimitList[0].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[0].u.charLimits.maxLength = 15;
limit->fieldLimitList[0].u.charLimits.menuStyle = 2;
limit->fieldLimitList[0].u.charLimits.qbeMatchOperation = 1;
limit->fieldLimitList[0].u.charLimits.charMenu[0] = '\0';
if((limit->fieldLimitList[0].u.charLimits.pattern = (char *) calloc(1,
sizeof(char))) == NULL)
return AR_RETURN_ERROR;
limit->fieldLimitList[0].u.charLimits.pattern[0] = '\0';
limit->fieldLimitList[0].u.charLimits.fullTextOptions = 0;
// Field 'name'
limit->fieldLimitList[1].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[1].u.charLimits.maxLength = 254;
limit->fieldLimitList[1].u.charLimits.menuStyle = 2;
limit->fieldLimitList[1].u.charLimits.qbeMatchOperation = 1;
limit->fieldLimitList[1].u.charLimits.charMenu[0] = '\0';
if((limit->fieldLimitList[1].u.charLimits.pattern = (char *) calloc(1,
sizeof(char))) == NULL)
return AR_RETURN_ERROR;
limit->fieldLimitList[1].u.charLimits.pattern[0] = '\0';
limit->fieldLimitList[1].u.charLimits.fullTextOptions = 0;
}
// Fields' data types
if(dataType != NULL) {
dataType->numItems = numItems;
if((dataType->intList = (unsigned int *)calloc(dataType->numItems,
sizeof(unsigned int))) == NULL)
return AR_RETURN_ERROR;
dataType->intList[0] = AR_DATA_TYPE_CHAR;
dataType->intList[1] = AR_DATA_TYPE_CHAR;
}
if (status != NULL)
memset(status, 0, sizeof(status));
return AR_RETURN_OK;
}
--
On Feb 19, 2008 11:02 AM, Paulo Moreira <[EMAIL PROTECTED]> wrote:
> Hello,
>
> First of all, thank you for your reply.
> I really *don't* want to support everything, believe me! :) If it is
> such a headache to write a test plugin, I really believe it would be a
> nightmare to write the whole thing
> My final goal is to create an ardbc plugin to have certain search fields and
> a method to search a FileNet database.
> But for now, I'm just trying to make a test plugin using the C skeleton file
> and implementing a dummy "ARDBCGetMultipleFields" method on it.
> The sample I'm using as a guide is "getemployeedata.c" that I found on BMC
> site, but it doesn't work very well fo
Re: FW: C API for ARDBC Plug-in
This may work after some changes:
--
ARPLUGIN_EXPORT int ARDBCGetMultipleFields(
void *object, // IN; plug-in instance
ARCompoundSchema *schema, // IN; form containing the data
ARFieldMappingList *mapping,// OUT; list of fields
ARFieldLimitList *limit, // OUT; corresponding field limits
ARUnsignedIntList *dataType,// OUT; corresponding data types
ARStatusList *status // OUT; status of the operation
)
{
int numItems = 2;
ARPluginVaLog(logFunc, AR_PLUGIN_LOG_INFO,
"ARDBCGetMultipleFields, ...");
// Fields' mappings
if(mapping != NULL) {
mapping->numItems = numItems;
if((mapping->mappingList = (ARFieldMappingStruct
*)calloc(mapping->numItems, sizeof(ARFieldMappingStruct))) == NULL)
return AR_RETURN_ERROR;
mapping->mappingList[0].fieldType = AR_FIELD_REGULAR;
mapping->mappingList[1].fieldType = AR_FIELD_REGULAR;
}
// Fields' limits
if(limit != NULL) {
limit->numItems = numItems;
if((limit->fieldLimitList = (ARFieldLimitStruct
*)calloc(limit->numItems, sizeof(ARFieldLimitStruct))) == NULL)
return AR_RETURN_ERROR;
// Field 'Request ID'
limit->fieldLimitList[0].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[0].u.charLimits.maxLength = 15;
limit->fieldLimitList[0].u.charLimits.menuStyle = 2;
limit->fieldLimitList[0].u.charLimits.qbeMatchOperation = 1;
limit->fieldLimitList[0].u.charLimits.charMenu[0] = '\0';
if((limit->fieldLimitList[0].u.charLimits.pattern = (char *)
calloc(1, sizeof(char))) == NULL)
return AR_RETURN_ERROR;
limit->fieldLimitList[0].u.charLimits.pattern[0] = '\0';
limit->fieldLimitList[0].u.charLimits.fullTextOptions = 0;
// Field 'name'
limit->fieldLimitList[1].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[1].u.charLimits.maxLength = 254;
limit->fieldLimitList[1].u.charLimits.menuStyle = 2;
limit->fieldLimitList[1].u.charLimits.qbeMatchOperation = 1;
limit->fieldLimitList[1].u.charLimits.charMenu[0] = '\0';
if((limit->fieldLimitList[1].u.charLimits.pattern = (char *)
calloc(1, sizeof(char))) == NULL)
return AR_RETURN_ERROR;
limit->fieldLimitList[1].u.charLimits.pattern[0] = '\0';
limit->fieldLimitList[1].u.charLimits.fullTextOptions = 0;
}
// Fields' data types
if(dataType != NULL) {
dataType->numItems = numItems;
if((dataType->intList = (unsigned int
*)calloc(dataType->numItems, sizeof(unsigned int))) == NULL)
return AR_RETURN_ERROR;
dataType->intList[0] = AR_DATA_TYPE_CHAR;
dataType->intList[1] = AR_DATA_TYPE_CHAR;
}
if (status != NULL)
memset(status, 0, sizeof(status));
return AR_RETURN_OK;
}
--
On Feb 19, 2008 11:02 AM, Paulo Moreira <[EMAIL PROTECTED]> wrote:
> Hello,
>
> First of all, thank you for your reply.
> I really *don't* want to support everything, believe me! :)
> If it is such a headache to write a test plugin, I really believe it would be
> a nightmare to write the whole thing
> My final goal is to create an ardbc plugin to have certain search fields and
> a method to search a FileNet database.
> But for now, I'm just trying to make a test plugin using the C skeleton file
> and implementing a dummy "ARDBCGetMultipleFields" method on it.
> The sample I'm using as a guide is "getemployeedata.c" that I found on BMC
> site, but it doesn't work very well for me, as you can see by my previous
> mail.
>
>
> Kind regards,
> Paulo Moreira
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:[EMAIL
> PROTECTED] On Behalf Of Misi Mladoniczky
> Sent: terça-feira, 19 de Fevereiro de 2008 7:54
> To: arslist@ARSLIST.ORG
> Subject: Re: FW: C API for ARDBC Plug-in
>
> Hi,
>
> To write a general ARDBC-plugin that supports everything, is quite a task.
>
> You have problems of mapping forms, field and datatypes, as well as the nice
> ARQualifierStruct into something you can use against your external data
> source.
>
> If you limit the functionality to a few specific things (forms/fields) and
> also limit the search capabilities, it is easier.
>
> Best Regards - Misi, RRR AB, http://rrr.se
>
> > Hello all,
> >
> >
> >
> > Can someone please provide me with some real-life samples on how to
> > (properly) write a C ARDBC Plug-in for Remedy (I've also tried
> > g
Re: FW: C API for ARDBC Plug-in
Hello,
First of all, thank you for your reply.
I really *don't* want to support everything, believe me! :)
If it is such a headache to write a test plugin, I really believe it would be a
nightmare to write the whole thing
My final goal is to create an ardbc plugin to have certain search fields and a
method to search a FileNet database.
But for now, I'm just trying to make a test plugin using the C skeleton file
and implementing a dummy "ARDBCGetMultipleFields" method on it.
The sample I'm using as a guide is "getemployeedata.c" that I found on BMC
site, but it doesn't work very well for me, as you can see by my previous mail.
Kind regards,
Paulo Moreira
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Misi Mladoniczky
Sent: terça-feira, 19 de Fevereiro de 2008 7:54
To: arslist@ARSLIST.ORG
Subject: Re: FW: C API for ARDBC Plug-in
Hi,
To write a general ARDBC-plugin that supports everything, is quite a task.
You have problems of mapping forms, field and datatypes, as well as the nice
ARQualifierStruct into something you can use against your external data source.
If you limit the functionality to a few specific things (forms/fields) and also
limit the search capabilities, it is easier.
Best Regards - Misi, RRR AB, http://rrr.se
> Hello all,
>
>
>
> Can someone please provide me with some real-life samples on how to
> (properly) write a C ARDBC Plug-in for Remedy (I've also tried
> getemployeedata.c) ?
>
> So far I've read the C-API-Ref-710, used the ardbcskl.c and headers
> from the samples directory and implemented the ARDBCGetListSchemas
> method successfully.
>
> I'm having trouble implementing the ARDBCGetMultipleFields method,
> which is not showing all the fields I insert to the array
> mapping->mappingList. Only the first one is shown.
>
>
>
> Please find below the source I'm trying to use:
>
>
>
> ARPLUGIN_EXPORT int ARDBCGetMultipleFields(
>
> void *object, /* IN; plug-in instance */
>
> ARCompoundSchema *schema, /* IN; form containing the data */
>
> ARFieldMappingList *mapping,/* OUT; list of fields */
>
> ARFieldLimitList *limit, /* OUT; corresponding field limits */
>
> ARUnsignedIntList *dataType,/* OUT; corresponding data types */
>
> ARStatusList *status /* OUT; status of the operation */
>
> )
>
> {
>
> FILE * pFile;
>
> pFile = fopen ("myfile.txt","a");
>
>
>
>if (schema->schemaType == AR_SCHEMA_VENDOR &&
>
>strcmp(schema->u.vendor.tableName, FORM_NAME) == 0)
>
>{
>
> mapping->numItems = 3;
>
>
>
> mapping->mappingList =
>
> (ARFieldMappingStruct *) malloc(sizeof(ARFieldMappingStruct)
> *
>
> mapping->numItems);
>
> if (mapping->mappingList == NULL) return AR_RETURN_ERROR;
>
>
>
> mapping->mappingList[0].fieldType = AR_FIELD_VENDOR;
>
> strcpy(mapping->mappingList[0].u.vendor.fieldName, "file_id");
> /* this is shown OK */
>
> mapping->mappingList[1].fieldType = AR_FIELD_VENDOR;
>
> strcpy(mapping->mappingList[1].u.vendor.fieldName, "file_name");
> /* this is not */
>
> mapping->mappingList[2].fieldType = AR_FIELD_VENDOR;
>
> strcpy(mapping->mappingList[2].u.vendor.fieldName, "file_date");
>
>
>
> if (pFile!=NULL)
>
> {
>
> fprintf (pFile, "-//-\r\n");
>
> fprintf (pFile, "%s\r\n",
> mapping->mappingList[0].u.vendor.fieldName);
>
> fprintf (pFile, "%s\r\n",
> mapping->mappingList[1].u.vendor.fieldName);
>
> fprintf (pFile, "%s\r\n",
> mapping->mappingList[2].u.vendor.fieldName);
>
>
>
> /* all these fields appear filled in on the log file
> I'm creating at runtime */
>
> }
>
>
>
> limit->numItems = 3;
>
>
>
> limit->fieldLimitList =
>
> (ARFieldLimitStruct *) calloc(limit->numItems,
>
>sizeof(ARFieldLimitStruct));
>
>
>
> if (limit->fieldLimitList == NULL) return AR_RETURN_ERROR;
>
>
>
> limit->fieldLimitList[0].dataType = AR_DATA_TYPE_CHAR;
>
> limit->fieldLimitList[0].u.charLimits.maxLength = 20;
>
> limit->fieldLimitList[0].u.charLimits.menuStyle =
> AR_MENU_APPEND;
>
> l
Re: FW: C API for ARDBC Plug-in
Hi,
To write a general ARDBC-plugin that supports everything, is quite a task.
You have problems of mapping forms, field and datatypes, as well as the
nice ARQualifierStruct into something you can use against your external
data source.
If you limit the functionality to a few specific things (forms/fields) and
also limit the search capabilities, it is easier.
Best Regards - Misi, RRR AB, http://rrr.se
> Hello all,
>
>
>
> Can someone please provide me with some real-life samples on how to
> (properly) write a C ARDBC Plug-in for Remedy (I've also tried
> getemployeedata.c) ?
>
> So far I've read the C-API-Ref-710, used the ardbcskl.c and headers from
> the samples directory and implemented the ARDBCGetListSchemas method
> successfully.
>
> I'm having trouble implementing the ARDBCGetMultipleFields method, which
> is not showing all the fields I insert to the array
> mapping->mappingList. Only the first one is shown.
>
>
>
> Please find below the source I'm trying to use:
>
>
>
> ARPLUGIN_EXPORT int ARDBCGetMultipleFields(
>
> void *object, /* IN; plug-in instance */
>
> ARCompoundSchema *schema, /* IN; form containing the data */
>
> ARFieldMappingList *mapping,/* OUT; list of fields */
>
> ARFieldLimitList *limit, /* OUT; corresponding field limits */
>
> ARUnsignedIntList *dataType,/* OUT; corresponding data types */
>
> ARStatusList *status /* OUT; status of the operation */
>
> )
>
> {
>
> FILE * pFile;
>
> pFile = fopen ("myfile.txt","a");
>
>
>
>if (schema->schemaType == AR_SCHEMA_VENDOR &&
>
>strcmp(schema->u.vendor.tableName, FORM_NAME) == 0)
>
>{
>
> mapping->numItems = 3;
>
>
>
> mapping->mappingList =
>
> (ARFieldMappingStruct *) malloc(sizeof(ARFieldMappingStruct) *
>
> mapping->numItems);
>
> if (mapping->mappingList == NULL) return AR_RETURN_ERROR;
>
>
>
> mapping->mappingList[0].fieldType = AR_FIELD_VENDOR;
>
> strcpy(mapping->mappingList[0].u.vendor.fieldName, "file_id"); /*
> this is shown OK */
>
> mapping->mappingList[1].fieldType = AR_FIELD_VENDOR;
>
> strcpy(mapping->mappingList[1].u.vendor.fieldName, "file_name");
> /* this is not */
>
> mapping->mappingList[2].fieldType = AR_FIELD_VENDOR;
>
> strcpy(mapping->mappingList[2].u.vendor.fieldName, "file_date");
>
>
>
> if (pFile!=NULL)
>
> {
>
> fprintf (pFile, "-//-\r\n");
>
> fprintf (pFile, "%s\r\n",
> mapping->mappingList[0].u.vendor.fieldName);
>
> fprintf (pFile, "%s\r\n",
> mapping->mappingList[1].u.vendor.fieldName);
>
> fprintf (pFile, "%s\r\n",
> mapping->mappingList[2].u.vendor.fieldName);
>
>
>
> /* all these fields appear filled in on the log file
> I'm creating at runtime */
>
> }
>
>
>
> limit->numItems = 3;
>
>
>
> limit->fieldLimitList =
>
> (ARFieldLimitStruct *) calloc(limit->numItems,
>
>sizeof(ARFieldLimitStruct));
>
>
>
> if (limit->fieldLimitList == NULL) return AR_RETURN_ERROR;
>
>
>
> limit->fieldLimitList[0].dataType = AR_DATA_TYPE_CHAR;
>
> limit->fieldLimitList[0].u.charLimits.maxLength = 20;
>
> limit->fieldLimitList[0].u.charLimits.menuStyle = AR_MENU_APPEND;
>
> limit->fieldLimitList[0].u.charLimits.qbeMatchOperation =
> AR_QBE_MATCH_ANYWHERE;
>
> limit->fieldLimitList[0].u.charLimits.fullTextOptions =
> AR_FULLTEXT_OPTIONS_NONE;
>
>
>
> /* from this point on, nothing is recognized on Remedy, but is
> show on the log file (?) */
>
>
>
> limit->fieldLimitList[1].dataType = AR_DATA_TYPE_CHAR;
>
> limit->fieldLimitList[1].u.charLimits.maxLength = 21;
>
> limit->fieldLimitList[1].u.charLimits.menuStyle = AR_MENU_APPEND;
>
> limit->fieldLimitList[1].u.charLimits.qbeMatchOperation =
> AR_QBE_MATCH_ANYWHERE;
>
> limit->fieldLimitList[1].u.charLimits.fullTextOptions =
> AR_FULLTEXT_OPTIONS_NONE;
>
> limit->fieldLimitList[2].dataType = AR_DATA_TYPE_CHAR;
>
> limit->fieldLimitList[2].u.charLimits.maxLength = 22;
>
> limit->fieldLimitList[2].u.charLimits.menuStyle = AR_MENU_APPEND;
FW: C API for ARDBC Plug-in
Hello all,
Can someone please provide me with some real-life samples on how to
(properly) write a C ARDBC Plug-in for Remedy (I've also tried
getemployeedata.c) ?
So far I've read the C-API-Ref-710, used the ardbcskl.c and headers from
the samples directory and implemented the ARDBCGetListSchemas method
successfully.
I'm having trouble implementing the ARDBCGetMultipleFields method, which
is not showing all the fields I insert to the array
mapping->mappingList. Only the first one is shown.
Please find below the source I'm trying to use:
ARPLUGIN_EXPORT int ARDBCGetMultipleFields(
void *object, /* IN; plug-in instance */
ARCompoundSchema *schema, /* IN; form containing the data */
ARFieldMappingList *mapping,/* OUT; list of fields */
ARFieldLimitList *limit, /* OUT; corresponding field limits */
ARUnsignedIntList *dataType,/* OUT; corresponding data types */
ARStatusList *status /* OUT; status of the operation */
)
{
FILE * pFile;
pFile = fopen ("myfile.txt","a");
if (schema->schemaType == AR_SCHEMA_VENDOR &&
strcmp(schema->u.vendor.tableName, FORM_NAME) == 0)
{
mapping->numItems = 3;
mapping->mappingList =
(ARFieldMappingStruct *) malloc(sizeof(ARFieldMappingStruct) *
mapping->numItems);
if (mapping->mappingList == NULL) return AR_RETURN_ERROR;
mapping->mappingList[0].fieldType = AR_FIELD_VENDOR;
strcpy(mapping->mappingList[0].u.vendor.fieldName, "file_id"); /*
this is shown OK */
mapping->mappingList[1].fieldType = AR_FIELD_VENDOR;
strcpy(mapping->mappingList[1].u.vendor.fieldName, "file_name");
/* this is not */
mapping->mappingList[2].fieldType = AR_FIELD_VENDOR;
strcpy(mapping->mappingList[2].u.vendor.fieldName, "file_date");
if (pFile!=NULL)
{
fprintf (pFile, "-//-\r\n");
fprintf (pFile, "%s\r\n",
mapping->mappingList[0].u.vendor.fieldName);
fprintf (pFile, "%s\r\n",
mapping->mappingList[1].u.vendor.fieldName);
fprintf (pFile, "%s\r\n",
mapping->mappingList[2].u.vendor.fieldName);
/* all these fields appear filled in on the log file
I'm creating at runtime */
}
limit->numItems = 3;
limit->fieldLimitList =
(ARFieldLimitStruct *) calloc(limit->numItems,
sizeof(ARFieldLimitStruct));
if (limit->fieldLimitList == NULL) return AR_RETURN_ERROR;
limit->fieldLimitList[0].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[0].u.charLimits.maxLength = 20;
limit->fieldLimitList[0].u.charLimits.menuStyle = AR_MENU_APPEND;
limit->fieldLimitList[0].u.charLimits.qbeMatchOperation =
AR_QBE_MATCH_ANYWHERE;
limit->fieldLimitList[0].u.charLimits.fullTextOptions =
AR_FULLTEXT_OPTIONS_NONE;
/* from this point on, nothing is recognized on Remedy, but is
show on the log file (?) */
limit->fieldLimitList[1].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[1].u.charLimits.maxLength = 21;
limit->fieldLimitList[1].u.charLimits.menuStyle = AR_MENU_APPEND;
limit->fieldLimitList[1].u.charLimits.qbeMatchOperation =
AR_QBE_MATCH_ANYWHERE;
limit->fieldLimitList[1].u.charLimits.fullTextOptions =
AR_FULLTEXT_OPTIONS_NONE;
limit->fieldLimitList[2].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[2].u.charLimits.maxLength = 22;
limit->fieldLimitList[2].u.charLimits.menuStyle = AR_MENU_APPEND;
limit->fieldLimitList[2].u.charLimits.qbeMatchOperation =
AR_QBE_MATCH_ANYWHERE;
limit->fieldLimitList[2].u.charLimits.fullTextOptions =
AR_FULLTEXT_OPTIONS_NONE;
if (pFile!=NULL)
{
fprintf (pFile, "---\r\n");
fprintf (pFile, "%d\r\n",
limit->fieldLimitList[1].dataType);
fprintf (pFile, "%d\r\n",
limit->fieldLimitList[1].u.charLimits.maxLength);
fprintf (pFile, "%d\r\n",
limit->fieldLimitList[1].u.charLimits.menuStyle);
}
/* fill the data type list */
dataType->numItems = 3;
dataType->intList =
(unsigned int *) malloc(sizeof(unsigned) * dataType->numItems);
if (dataType->intList == NULL) return AR_RETURN_ERROR;
dataType->intList[0] = AR_DATA_TYPE_CHAR;
dataType->intList[1] = AR_DATA_TYPE_CHAR;
dataType->intList[2] = AR_DATA_TYPE_CHAR;
if (pFile!=NULL)
Re: ARDBC Plug-in Returns only Subset of Data -- Why? - UPDATE
Jack, I do not have access to a v5.1.2 server anymore... so on a v6.3 server... I see settings on the "ARDBC LDAP Configuration" form for 'Distinguished Name', 'Password', 'Using Secure Socket Layer', and 'Certificate Database*'. I also recall several people having issues getting the 'Certificate Database*' file setup properly ( I am guessing that these fields are all in the v5.1.2 plugin too. ) So.. I guess.. maybe what is happening is that the plugin is trying to authenticate but is failing due to SSL related issues and then falling back to an anonymous bind? If your not already doing this.. Try to find out if the plugin spits out any run time error messages about the bind failing... I still have the v5.1 docs laying around after all. wow.. "Configuring_AR_Sys_English.pdf" ... Plugin-Log-Level in Appendix A Pg. 170 Looks like you want to use Plugin-Log-Level: 100 Maybe that will get it to show the error? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/26/07, Covert, Jack <[EMAIL PROTECTED]> wrote: > Hi guys, I'm working w/ Tim on this. So the problem is that Remedy > isn't binding to a user before making the query. This is causing the > query to be done as anonymous, which is why we aren't getting much data > back. > > Where /how is Remedy instructed to bind the user? > > Thanks for your help... > > Jack Covert > > Corporate IT > Enterprise Systems Management > Remedy Support Team > > > Remedy Support Team Home Page > http://collaborate.mckesson.com/sites/esm/remedy > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield > Sent: Friday, October 26, 2007 9:59 AM > To: arslist@ARSLIST.ORG > Subject: Re: ARDBC Plug-in Returns only Subset of Data -- Why? > > One of the data elements we're not getting is the 'cn', which is just a > seven-character text attribute. The fullName attrib is char(15), and > we're getting that one. > > It's almost as if we're only seeing one part of the aggregation. Like > we're seeing only person data related to the record, but no location > data. > > It's very strange. > > --Tim > On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > > Hey, everybody. I was wondering if anyone out there has seen this > issue before. It's got a lot of people baffled. > > > > > > > > A customer has an AIX server running the latest patch for AR 5.1.2. > The target LDAP server is Novell, and it doesn't allow anonymous > browsing. When the Remedy daemons start up, all the plug-ins load > without a hitch. And in the configuration form, the parameters for > ARDBC look correct -- that is, the values are what we were told to > use, > and they match what I'm using in Softerra's LDAP Browser. > > > > > > > > However, when attempting to query the LDAP host the vendor form > exhibits strange behavior. It shows us only a subset of any given > person's record. For example, we can see the last name, first name, > and email address, but no location data. Even more strange is the > empty cn field. In database terms, we're getting all the rows, but > only some of the columns. > > > > > > > > The base query we're using is pretty simple. It looks something like > this: > > > > > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > > > > > The customer has an AR System version 7 development server with > almost the exact same setup (same query, same credentials), and all > the > data comes back as expected. Out of desperation, I imported the > vendor > form onto their production 5.1.2 server, and the same thing happened as > on the development 5.1.2 machine: Swiss-cheese data. > > I've built new vendor forms from scratch, and I've even performed > surgery on def files, all to no avail. > > > > > > There are no errors in the plug-in logs. > > As far as the AR Server goes, there is no problem. > > > > > > I'm stumped. Any ideas? > > > > > > > > --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ANSWERED: RE: ARDBC Plug-in Returns only Subset of Data -- Why?
When using SSL, Remedy won't bind. We had to use stunnel to get it out. Jack Corporate IT Enterprise Systems Management Remedy Support Team Remedy Support Team Home Page http://collaborate.mckesson.com/sites/esm/remedy -Original Message- From: Tim Widowfield [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 10:52 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-in Returns only Subset of Data -- Why? --0-1178468522-1193421149=:48183 Content-Type: text/plain; charset=us-ascii That's a possibility, but it doesn't explain why other client tools (including a version 7 Remedy server) can use the same authentication credentials and see the entire record. --Tim - Original Message From: "Durrant, Michael M. - ITSD" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 1:05:24 PM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Is there any kind of field/column-level access control in LDAP? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Friday, October 26, 2007 9:59 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-in Returns only Subset of Data -- Why? One of the data elements we're not getting is the 'cn', which is just a seven-character text attribute. The fullName attrib is char(15), and we're getting that one. It's almost as if we're only seeing one part of the aggregation. Like we're seeing only person data related to the record, but no location data. It's very strange. --Tim - Original Message From: Carey Matthew Black <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 11:18:31 AM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Tim, Just a few WAGS Check the data types for the ldap attributes that are not returned. ( Maybe they are not supported in v5.x but are in v7.x ?) Maybe the ARS side is truncating the data due to a size/memory constraint? (and thus you get a partial record) HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The target LDAP server is Novell, and it doesn't allow anonymous browsing. When the Remedy daemons start up, all the plug-ins load without a hitch. And in the configuration form, the parameters for ARDBC look correct -- that is, the values are what we were told to use, and they match what I'm using in Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits strange behavior. It shows us only a subset of any given person's record. For example, we can see the last name, first name, and email address, but no location data. Even more strange is the empty cn field. In database terms, we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the exact same setup (same query, same credentials), and all the data comes back as expected. Out of desperation, I imported the vendor form onto their production 5.1.2 server, and the same thing happened as on the development 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this info
Re: ARDBC Plug-in Returns only Subset of Data -- Why? - UPDATE
Hi guys, I'm working w/ Tim on this. So the problem is that Remedy isn't binding to a user before making the query. This is causing the query to be done as anonymous, which is why we aren't getting much data back. Where /how is Remedy instructed to bind the user? Thanks for your help... Jack Covert Corporate IT Enterprise Systems Management Remedy Support Team Remedy Support Team Home Page http://collaborate.mckesson.com/sites/esm/remedy -Original Message- From: Tim Widowfield [mailto:[EMAIL PROTECTED] Sent: Friday, October 26, 2007 10:52 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-in Returns only Subset of Data -- Why? --0-1178468522-1193421149=:48183 Content-Type: text/plain; charset=us-ascii That's a possibility, but it doesn't explain why other client tools (including a version 7 Remedy server) can use the same authentication credentials and see the entire record. --Tim - Original Message From: "Durrant, Michael M. - ITSD" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 1:05:24 PM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Is there any kind of field/column-level access control in LDAP? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Friday, October 26, 2007 9:59 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-in Returns only Subset of Data -- Why? One of the data elements we're not getting is the 'cn', which is just a seven-character text attribute. The fullName attrib is char(15), and we're getting that one. It's almost as if we're only seeing one part of the aggregation. Like we're seeing only person data related to the record, but no location data. It's very strange. --Tim - Original Message From: Carey Matthew Black <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 11:18:31 AM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Tim, Just a few WAGS Check the data types for the ldap attributes that are not returned. ( Maybe they are not supported in v5.x but are in v7.x ?) Maybe the ARS side is truncating the data due to a size/memory constraint? (and thus you get a partial record) HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The target LDAP server is Novell, and it doesn't allow anonymous browsing. When the Remedy daemons start up, all the plug-ins load without a hitch. And in the configuration form, the parameters for ARDBC look correct -- that is, the values are what we were told to use, and they match what I'm using in Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits strange behavior. It shows us only a subset of any given person's record. For example, we can see the last name, first name, and email address, but no location data. Even more strange is the empty cn field. In database terms, we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the exact same setup (same query, same credentials), and all the data comes back as expected. Out of desperation, I imported the vendor form onto their production 5.1.2 server, and the same thing happened as on the development 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under
Re: ARDBC Plug-in Returns only Subset of Data -- Why?
That's a possibility, but it doesn't explain why other client tools (including a version 7 Remedy server) can use the same authentication credentials and see the entire record. --Tim - Original Message From: "Durrant, Michael M. - ITSD" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 1:05:24 PM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Is there any kind of field/column-level access control in LDAP? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Friday, October 26, 2007 9:59 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-in Returns only Subset of Data -- Why? One of the data elements we're not getting is the 'cn', which is just a seven-character text attribute. The fullName attrib is char(15), and we're getting that one. It's almost as if we're only seeing one part of the aggregation. Like we're seeing only person data related to the record, but no location data. It's very strange. --Tim - Original Message From: Carey Matthew Black <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 11:18:31 AM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Tim, Just a few WAGS Check the data types for the ldap attributes that are not returned. ( Maybe they are not supported in v5.x but are in v7.x ?) Maybe the ARS side is truncating the data due to a size/memory constraint? (and thus you get a partial record) HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The target LDAP server is Novell, and it doesn't allow anonymous browsing. When the Remedy daemons start up, all the plug-ins load without a hitch. And in the configuration form, the parameters for ARDBC look correct -- that is, the values are what we were told to use, and they match what I'm using in Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits strange behavior. It shows us only a subset of any given person's record. For example, we can see the last name, first name, and email address, but no location data. Even more strange is the empty cn field. In database terms, we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the exact same setup (same query, same credentials), and all the data comes back as expected. Out of desperation, I imported the vendor form onto their production 5.1.2 server, and the same thing happened as on the development 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-in Returns only Subset of Data -- Why?
Is there any kind of field/column-level access control in LDAP? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Friday, October 26, 2007 9:59 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-in Returns only Subset of Data -- Why? One of the data elements we're not getting is the 'cn', which is just a seven-character text attribute. The fullName attrib is char(15), and we're getting that one. It's almost as if we're only seeing one part of the aggregation. Like we're seeing only person data related to the record, but no location data. It's very strange. --Tim - Original Message From: Carey Matthew Black <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 11:18:31 AM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Tim, Just a few WAGS Check the data types for the ldap attributes that are not returned. ( Maybe they are not supported in v5.x but are in v7.x ?) Maybe the ARS side is truncating the data due to a size/memory constraint? (and thus you get a partial record) HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The target LDAP server is Novell, and it doesn't allow anonymous browsing. When the Remedy daemons start up, all the plug-ins load without a hitch. And in the configuration form, the parameters for ARDBC look correct -- that is, the values are what we were told to use, and they match what I'm using in Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits strange behavior. It shows us only a subset of any given person's record. For example, we can see the last name, first name, and email address, but no location data. Even more strange is the empty cn field. In database terms, we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the exact same setup (same query, same credentials), and all the data comes back as expected. Out of desperation, I imported the vendor form onto their production 5.1.2 server, and the same thing happened as on the development 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-in Returns only Subset of Data -- Why?
One of the data elements we're not getting is the 'cn', which is just a seven-character text attribute. The fullName attrib is char(15), and we're getting that one. It's almost as if we're only seeing one part of the aggregation. Like we're seeing only person data related to the record, but no location data. It's very strange. --Tim - Original Message From: Carey Matthew Black <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 11:18:31 AM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? Tim, Just a few WAGS Check the data types for the ldap attributes that are not returned. ( Maybe they are not supported in v5.x but are in v7.x ?) Maybe the ARS side is truncating the data due to a size/memory constraint? (and thus you get a partial record) HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The target LDAP server is Novell, and it doesn't allow anonymous browsing. When the Remedy daemons start up, all the plug-ins load without a hitch. And in the configuration form, the parameters for ARDBC look correct -- that is, the values are what we were told to use, and they match what I'm using in Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits strange behavior. It shows us only a subset of any given person's record. For example, we can see the last name, first name, and email address, but no location data. Even more strange is the empty cn field. In database terms, we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the exact same setup (same query, same credentials), and all the data comes back as expected. Out of desperation, I imported the vendor form onto their production 5.1.2 server, and the same thing happened as on the development 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-in Returns only Subset of Data -- Why?
That would be a great test, except that the server won't accept non-SSL reqeusts. --Tim - Original Message From: Axton <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 26, 2007 11:02:58 AM Subject: Re: [ARSLIST] ARDBC Plug-in Returns only Subset of Data -- Why? If you use regular ldap instead of ldaps, what does a packet dump show different between the two environments? Axton Grams On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The target LDAP server is Novell, and it doesn't allow anonymous browsing. When the Remedy daemons start up, all the plug-ins load without a hitch. And in the configuration form, the parameters for ARDBC look correct -- that is, the values are what we were told to use, and they match what I'm using in Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits strange behavior. It shows us only a subset of any given person's record. For example, we can see the last name, first name, and email address, but no location data. Even more strange is the empty cn field. In database terms, we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the exact same setup (same query, same credentials), and all the data comes back as expected. Out of desperation, I imported the vendor form onto their production 5.1.2 server, and the same thing happened as on the development 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-in Returns only Subset of Data -- Why?
Tim, Just a few WAGS Check the data types for the ldap attributes that are not returned. ( Maybe they are not supported in v5.x but are in v7.x ?) Maybe the ARS side is truncating the data due to a size/memory constraint? (and thus you get a partial record) HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue > before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The > target LDAP server is Novell, and it doesn't allow anonymous browsing. When > the Remedy daemons start up, all the plug-ins load without a hitch. And in > the configuration form, the parameters for ARDBC look correct -- that is, > the values are what we were told to use, and they match what I'm using in > Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits > strange behavior. It shows us only a subset of any given person's record. > For example, we can see the last name, first name, and email address, but no > location data. Even more strange is the empty cn field. In database terms, > we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the > exact same setup (same query, same credentials), and all the data comes back > as expected. Out of desperation, I imported the vendor form onto their > production 5.1.2 server, and the same thing happened as on the development > 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on > def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-in Returns only Subset of Data -- Why?
If you use regular ldap instead of ldaps, what does a packet dump show different between the two environments? Axton Grams On 10/26/07, Tim Widowfield <[EMAIL PROTECTED]> wrote: > Hey, everybody. I was wondering if anyone out there has seen this issue > before. It's got a lot of people baffled. > > > > A customer has an AIX server running the latest patch for AR 5.1.2. The > target LDAP server is Novell, and it doesn't allow anonymous browsing. When > the Remedy daemons start up, all the plug-ins load without a hitch. And in > the configuration form, the parameters for ARDBC look correct -- that is, > the values are what we were told to use, and they match what I'm using in > Softerra's LDAP Browser. > > > > However, when attempting to query the LDAP host the vendor form exhibits > strange behavior. It shows us only a subset of any given person's record. > For example, we can see the last name, first name, and email address, but no > location data. Even more strange is the empty cn field. In database terms, > we're getting all the rows, but only some of the columns. > > > > The base query we're using is pretty simple. It looks something like this: > > > > ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) > > > > The customer has an AR System version 7 development server with almost the > exact same setup (same query, same credentials), and all the data comes back > as expected. Out of desperation, I imported the vendor form onto their > production 5.1.2 server, and the same thing happened as on the development > 5.1.2 machine: Swiss-cheese data. > I've built new vendor forms from scratch, and I've even performed surgery on > def files, all to no avail. > > > There are no errors in the plug-in logs. > As far as the AR Server goes, there is no problem. > > > I'm stumped. Any ideas? > > > > --Tim > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ARDBC Plug-in Returns only Subset of Data -- Why?
Hey, everybody. I was wondering if anyone out there has seen this issue before. It's got a lot of people baffled. A customer has an AIX server running the latest patch for AR 5.1.2. The target LDAP server is Novell, and it doesn't allow anonymous browsing. When the Remedy daemons start up, all the plug-ins load without a hitch. And in the configuration form, the parameters for ARDBC look correct -- that is, the values are what we were told to use, and they match what I'm using in Softerra's LDAP Browser. However, when attempting to query the LDAP host the vendor form exhibits strange behavior. It shows us only a subset of any given person's record. For example, we can see the last name, first name, and email address, but no location data. Even more strange is the empty cn field. In database terms, we're getting all the rows, but only some of the columns. The base query we're using is pretty simple. It looks something like this: ldaps://[LDAP_Server]/o=[domain]??sub?(objectclass=*) The customer has an AR System version 7 development server with almost the exact same setup (same query, same credentials), and all the data comes back as expected. Out of desperation, I imported the vendor form onto their production 5.1.2 server, and the same thing happened as on the development 5.1.2 machine: Swiss-cheese data. I've built new vendor forms from scratch, and I've even performed surgery on def files, all to no avail. There are no errors in the plug-in logs. As far as the AR Server goes, there is no problem. I'm stumped. Any ideas? --Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
I assume you are using gcc to compile. With gcc, the flag "-m32" will compile it 32-bit on a 64-bit platform. From the gcc man page: -m32 -m64 Generate code for a 32-bit or 64-bit environment. The 32-bit environment sets int, long and pointer to 32 bits. The 64-bit environment sets int to 32 bits and long and pointer to 64 bits. A plugin I am working on shows the following from file: [EMAIL PROTECTED] ardbcsql]# file ardbcsql.so ardbcsql.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped I The file above, showing not stripped, does load and run as expected. Stripped just means that the debugging symbols were removed from the file. If you want to remove the symbols, you can use the strip command to do that, though it shouldn't make a difference. Do an ldd on the 32-bit version and make sure it is referencing the 32-bit libs. Axton Grams On 7/20/07, Mark Milke <[EMAIL PROTECTED]> wrote: now, there is funny thing: all ardbc plug-ins that work are 32-bit! [EMAIL PROTECTED] bin]$ file ardbcconf.so ardbcconf.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), stripped SO now, I have a 32-bit version one guy compiled for me on 32-bit LINUX HERE: [EMAIL PROTECTED] bin]$ file ardbccsv.so ardbccsv.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped The only difference is stripped vs. not stripped. Do you think this is a problem? Guess what! It works Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
now, there is funny thing: all ardbc plug-ins that work are 32-bit! [EMAIL PROTECTED] bin]$ file ardbcconf.so ardbcconf.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), stripped SO now, I have a 32-bit version one guy compiled for me on 32-bit LINUX HERE: [EMAIL PROTECTED] bin]$ file ardbccsv.so ardbccsv.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped The only difference is stripped vs. not stripped. Do you think this is a problem? Guess what! It works Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Hi Mike, Can I just ask, your first email said the following: Fri Jul 20 08:29:58 2007 /appexec/ar/arsentw01_spk/plugins/ ardbccsv/linux/linux/ardbccsv.so: cannot open shared object file: File or Directory not found. Yet your make file says LIBNAME= ardbctest.so Is it a case that your ar.conf is looking for ardbccsv.so but you are compiling ardbctest.so ? Kind regards Danny Kellett Principal Consultant EMEA Professional Services Strategic Workflow Solutions Ltd Quoting Mark Milke <[EMAIL PROTECTED]>: > > [EMAIL PROTECTED] ~]$ users > > remedy > > [EMAIL PROTECTED] ~]$ groups > > remedy > > [EMAIL PROTECTED] ~]$ ls -la /u01/arsystem/arsdev/bin/arcache > > -rwx-- 1 remedy remedy 184 Jan 11 2007 > > /u01/arsystem/arsdev/bin/arcache > > [EMAIL PROTECTED] linux]$ env |grep PATH > > > LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib:/u01/arsystem/arsdev/ap i/lib:/u01/arsystem/arsdev/bin: > > PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/remedy/bin > > SQLPATH=/usr/lib/oracle/10.2.0.3/client/lib: > > > > Substitute your plug-in file for the ls command. > > [EMAIL PROTECTED] bin]$ users > ize0578 > [EMAIL PROTECTED] bin]$ groups > aradmin > [EMAIL PROTECTED] bin]$ ls -la /u01/arsystem/arsdev/bin/arcache > ls: /u01/arsystem/arsdev/bin/arcache: No such file or directory > [EMAIL PROTECTED] bin]$ ls -la /appexec/ar/ > arsentw01_lbs arsentw01_spk lost+found > [EMAIL PROTECTED] bin]$ ls -la /appexec/ar/arsentw01_spk/ > aha bin Logstemplates > api confmibsusr_ar > AREmail db plugins > backup_patch17.tar helprpc > backup_patch18.tar locale sample_db > [EMAIL PROTECTED] bin]$ ls -la /appexec/ar/arsentw01_spk/bin/arcache > -rwx--1 aradmin aradmin 1642072 Feb 7 03:29 /appexec/ar/ > arsentw01_spk/bin/arcache > [EMAIL PROTECTED] bin]$ env |grep PATH > LD_LIBRARY_PATH=:/appexec/ar/arsentw01_spk/bin:/lib64:/stub/lib64:/ > lib64/tls > PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/ > home/aradmin/bin:/appexec/ar/arsentw01_spk/bin:/lib64:/stub/lib64:/ > lib64/tls > > > > Also, it looks like your plugin is attempting to use a 64-bit version > > of libc, among others. You will need to compile the plugin with > > 32-bit, then when run, it needs the 32-bit libs in the path/ld_path > > before the 64-bit libs. > > I can't compile 32-bit. It's a 64-BIT LINUX > > look here: > > [EMAIL PROTECTED] bin]$ file ardbcskl.so > ardbcskl.so: ELF 64-bit LSB shared object, AMD x86-64, version 1 > (SYSV), not stripped > > Linux servername 2.4.21-47.ELsmp #1 SMP Wed Jul 5 20:30:30 EDT 2006 > x86_64 x86_64 x86_64 GNU/Linux > > > > Before sending the output to the list, try this LD_LIBRARY_PATH: > > > > > LD_LIBRARY_PATH=/appexec/ar/arsentw01_spk/:api/lib:/appexec/ar/arsentw01_sp k/bin:/lib:/stub/lib:/lib/tls > > export LD_LIBRARY_PATH > > I did try this, but I'm still getting the same error. > > Thanks! > > Mark > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
> [EMAIL PROTECTED] ~]$ users > remedy > [EMAIL PROTECTED] ~]$ groups > remedy > [EMAIL PROTECTED] ~]$ ls -la /u01/arsystem/arsdev/bin/arcache > -rwx-- 1 remedy remedy 184 Jan 11 2007 > /u01/arsystem/arsdev/bin/arcache > [EMAIL PROTECTED] linux]$ env |grep PATH > LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib:/u01/arsystem/arsdev/api/lib:/u01/arsystem/arsdev/bin: > PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/remedy/bin > SQLPATH=/usr/lib/oracle/10.2.0.3/client/lib: > > Substitute your plug-in file for the ls command. [EMAIL PROTECTED] bin]$ users ize0578 [EMAIL PROTECTED] bin]$ groups aradmin [EMAIL PROTECTED] bin]$ ls -la /u01/arsystem/arsdev/bin/arcache ls: /u01/arsystem/arsdev/bin/arcache: No such file or directory [EMAIL PROTECTED] bin]$ ls -la /appexec/ar/ arsentw01_lbs arsentw01_spk lost+found [EMAIL PROTECTED] bin]$ ls -la /appexec/ar/arsentw01_spk/ aha bin Logstemplates api confmibsusr_ar AREmail db plugins backup_patch17.tar helprpc backup_patch18.tar locale sample_db [EMAIL PROTECTED] bin]$ ls -la /appexec/ar/arsentw01_spk/bin/arcache -rwx--1 aradmin aradmin 1642072 Feb 7 03:29 /appexec/ar/ arsentw01_spk/bin/arcache [EMAIL PROTECTED] bin]$ env |grep PATH LD_LIBRARY_PATH=:/appexec/ar/arsentw01_spk/bin:/lib64:/stub/lib64:/ lib64/tls PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/ home/aradmin/bin:/appexec/ar/arsentw01_spk/bin:/lib64:/stub/lib64:/ lib64/tls > Also, it looks like your plugin is attempting to use a 64-bit version > of libc, among others. You will need to compile the plugin with > 32-bit, then when run, it needs the 32-bit libs in the path/ld_path > before the 64-bit libs. I can't compile 32-bit. It's a 64-BIT LINUX look here: [EMAIL PROTECTED] bin]$ file ardbcskl.so ardbcskl.so: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped Linux servername 2.4.21-47.ELsmp #1 SMP Wed Jul 5 20:30:30 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux > Before sending the output to the list, try this LD_LIBRARY_PATH: > > LD_LIBRARY_PATH=/appexec/ar/arsentw01_spk/:api/lib:/appexec/ar/arsentw01_spk/bin:/lib:/stub/lib:/lib/tls > export LD_LIBRARY_PATH I did try this, but I'm still getting the same error. Thanks! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Can you give the output of the following commands: [EMAIL PROTECTED] ~]$ users remedy [EMAIL PROTECTED] ~]$ groups remedy [EMAIL PROTECTED] ~]$ ls -la /u01/arsystem/arsdev/bin/arcache -rwx-- 1 remedy remedy 184 Jan 11 2007 /u01/arsystem/arsdev/bin/arcache [EMAIL PROTECTED] linux]$ env |grep PATH LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib:/u01/arsystem/arsdev/api/lib:/u01/arsystem/arsdev/bin: PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/remedy/bin SQLPATH=/usr/lib/oracle/10.2.0.3/client/lib: Substitute your plug-in file for the ls command. Also, it looks like your plugin is attempting to use a 64-bit version of libc, among others. You will need to compile the plugin with 32-bit, then when run, it needs the 32-bit libs in the path/ld_path before the 64-bit libs. Before sending the output to the list, try this LD_LIBRARY_PATH: LD_LIBRARY_PATH=/appexec/ar/arsentw01_spk/:api/lib:/appexec/ar/arsentw01_spk/bin:/lib:/stub/lib:/lib/tls export LD_LIBRARY_PATH Axton Grams On 7/20/07, Danny Kellett <[EMAIL PROTECTED]> wrote: Have you made sure this directory is in your $PATH and add it to the LD_LIBRARY_PATH. Also make sure the user you start ars with can read it. /appexec/ar/arsentw01_spk/plugins/ardbccsv/linux/linux/ Danny Kellett Principal Consultant EMEA Professional Services Strategic Workflow Solutions Ltd Quoting Mark Milke <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] bin]$ echo $LD_LIBRARY_PATH > :/appexec/ar/arsentw01_spk/bin:/lib64:/stub/lib64:/lib64/tls > > is this ":" at the beginning of the line ok? > > anyway, I'm still getting the same error > > and BTW: > > [EMAIL PROTECTED] linux]$ ldd -v ardbctest.so > /stub/$LIB/libcwait.so => /stub/lib64/libcwait.so > (0x002a9577a000) > libc.so.6 => /lib64/tls/libc.so.6 (0x002a9587b000) > libnsl.so.1 => /lib64/libnsl.so.1 (0x002a95ac) > libpthread.so.0 => /lib64/tls/libpthread.so.0 > (0x002a95bd7000) > /lib64/ld-linux-x86-64.so.2 => /lib64/ld-linux-x86-64.so.2 > (0x002a95556000) > > Version information: > ./ardbctest.so: > libc.so.6 (GLIBC_2.3) => /lib64/tls/libc.so.6 > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > /stub/lib64/libcwait.so: > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > /lib64/tls/libc.so.6: > ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux- > x86-64.so.2 > ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux- > x86-64.so.2 > ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld- > linux-x86-64.so.2 > /lib64/libnsl.so.1: > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > /lib64/tls/libpthread.so.0: > ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux- > x86-64.so.2 > ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld- > linux-x86-64.so.2 > libc.so.6 (GLIBC_2.3.2) => /lib64/tls/libc.so.6 > libc.so.6 (GLIBC_PRIVATE) => /lib64/tls/libc.so.6 > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > > I'm getting really tired with this... > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Have you made sure this directory is in your $PATH and add it to the LD_LIBRARY_PATH. Also make sure the user you start ars with can read it. /appexec/ar/arsentw01_spk/plugins/ardbccsv/linux/linux/ Danny Kellett Principal Consultant EMEA Professional Services Strategic Workflow Solutions Ltd Quoting Mark Milke <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] bin]$ echo $LD_LIBRARY_PATH > :/appexec/ar/arsentw01_spk/bin:/lib64:/stub/lib64:/lib64/tls > > is this ":" at the beginning of the line ok? > > anyway, I'm still getting the same error > > and BTW: > > [EMAIL PROTECTED] linux]$ ldd -v ardbctest.so > /stub/$LIB/libcwait.so => /stub/lib64/libcwait.so > (0x002a9577a000) > libc.so.6 => /lib64/tls/libc.so.6 (0x002a9587b000) > libnsl.so.1 => /lib64/libnsl.so.1 (0x002a95ac) > libpthread.so.0 => /lib64/tls/libpthread.so.0 > (0x002a95bd7000) > /lib64/ld-linux-x86-64.so.2 => /lib64/ld-linux-x86-64.so.2 > (0x002a95556000) > > Version information: > ./ardbctest.so: > libc.so.6 (GLIBC_2.3) => /lib64/tls/libc.so.6 > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > /stub/lib64/libcwait.so: > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > /lib64/tls/libc.so.6: > ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux- > x86-64.so.2 > ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux- > x86-64.so.2 > ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld- > linux-x86-64.so.2 > /lib64/libnsl.so.1: > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > /lib64/tls/libpthread.so.0: > ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux- > x86-64.so.2 > ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld- > linux-x86-64.so.2 > libc.so.6 (GLIBC_2.3.2) => /lib64/tls/libc.so.6 > libc.so.6 (GLIBC_PRIVATE) => /lib64/tls/libc.so.6 > libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 > > I'm getting really tired with this... > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
> Set LD_LIBRARY_PATH so that it includes the directory that contains > the ars libraries: > unset LD_LIBRARY_PATH > LD_LIBRARY_PATH=/appexec/ar/servername/bin/ > export LD_LIBRARY_PATH I did this still get this error. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Copy it to /appexec/ar/servername/bin -- Jarl On 7/20/07, Mark Milke <[EMAIL PROTECTED]> wrote: > It complain about this file: > /appexec/ar/servername/bin/arplugin: error while loading shared > libraries: libarcrypto.so: cannot open shared object file: Nosuch file > or directory I've found the file libarcrypto.so somewhere else. Should I move copy it to somewhere else? Where does it want me to copy it? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
[EMAIL PROTECTED] bin]$ echo $LD_LIBRARY_PATH :/appexec/ar/arsentw01_spk/bin:/lib64:/stub/lib64:/lib64/tls is this ":" at the beginning of the line ok? anyway, I'm still getting the same error and BTW: [EMAIL PROTECTED] linux]$ ldd -v ardbctest.so /stub/$LIB/libcwait.so => /stub/lib64/libcwait.so (0x002a9577a000) libc.so.6 => /lib64/tls/libc.so.6 (0x002a9587b000) libnsl.so.1 => /lib64/libnsl.so.1 (0x002a95ac) libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x002a95bd7000) /lib64/ld-linux-x86-64.so.2 => /lib64/ld-linux-x86-64.so.2 (0x002a95556000) Version information: ./ardbctest.so: libc.so.6 (GLIBC_2.3) => /lib64/tls/libc.so.6 libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 /stub/lib64/libcwait.so: libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 /lib64/tls/libc.so.6: ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux- x86-64.so.2 ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux- x86-64.so.2 ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld- linux-x86-64.so.2 /lib64/libnsl.so.1: libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 /lib64/tls/libpthread.so.0: ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux- x86-64.so.2 ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld- linux-x86-64.so.2 libc.so.6 (GLIBC_2.3.2) => /lib64/tls/libc.so.6 libc.so.6 (GLIBC_PRIVATE) => /lib64/tls/libc.so.6 libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6 I'm getting really tired with this... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Mark, My preferred way to manage ARS server environment variables is to add them to the armonitor.conf file. (Assuming that your plugin server is started by armonitor) Docs on how to do this can be found in.. Configuring-700.pdf Page 344 but a line something like this is the idea: Environment-variable: LD_LIBRARY_PATH=/some/path/goes/here;/another/path/goes/here; ( I think : is the right separator.. but your server env might be different so look at your existing PATH env setting and use the same separator.) Another option would be to edit/add this env setting to the /bin/arsystem start up script. (and maybe the /etc/ start up script too.) ( And if you wanted to add them to the user's env that will help when you are "manually" starting the plugin server by hand too.) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/20/07, Mark Milke <[EMAIL PROTECTED]> wrote: Wait, I found the libarcrypto.so in /appexec/ar/servername/bin/ arplugin. echo $LD_LIBRARY_PATH gives an empy line ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Set LD_LIBRARY_PATH so that it includes the directory that contains the ars libraries: unset LD_LIBRARY_PATH LD_LIBRARY_PATH=/appexec/ar/servername/bin/ export LD_LIBRARY_PATH It is probably best to do this in the arsystem script. Axton Grams On 7/20/07, Mark Milke <[EMAIL PROTECTED]> wrote: Wait, I found the libarcrypto.so in /appexec/ar/servername/bin/ arplugin. echo $LD_LIBRARY_PATH gives an empy line ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Hi Mike, On your *nix box try ldd YourPluginName.so It should output all the dependancies and thier expected location. E.g. [EMAIL PROTECTED] ~]# ldd /home/dkellett/tss2_rc2/libsqlmy.so linux-gate.so.1 => (0xe000) libdl.so.2 => /lib/libdl.so.2 (0xb7fc8000) libm.so.6 => /lib/tls/libm.so.6 (0xb7fa5000) libc.so.6 => /lib/tls/libc.so.6 (0xb7e7b000) /lib/ld-linux.so.2 (0x8000) Then make sure those directories are in your LD_LIBRARY_PATH and I try to make sure they are in your profile PATH too. Regards Danny Kellett Principal Consultant EMEA Professional Services Strategic Workflow Solutions Ltd Quoting Mark Milke <[EMAIL PROTECTED]>: > Wait, I found the libarcrypto.so in /appexec/ar/servername/bin/ > arplugin. > > echo $LD_LIBRARY_PATH gives an empy line > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Wait, I found the libarcrypto.so in /appexec/ar/servername/bin/ arplugin. echo $LD_LIBRARY_PATH gives an empy line ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
> It complain about this file: > /appexec/ar/servername/bin/arplugin: error while loading shared > libraries: libarcrypto.so: cannot open shared object file: Nosuch file > or directory I've found the file libarcrypto.so somewhere else. Should I move copy it to somewhere else? Where does it want me to copy it? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
> Is /appexec/ar/servername/bin an valid directory? It definitely is. I've just replaced the real server name with the "servername" string. > Is it added to LD_LIBRARY_PATH? I don't know. How do I check and change that respectively? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Is /appexec/ar/servername/bin an valid directory?
Is it added to LD_LIBRARY_PATH?
-
Jarl
On 7/20/07, Jarl Grøneng <[EMAIL PROTECTED]> wrote:
It complain about this file:
/appexec/ar/servername/bin/arplugin: error while loading shared
libraries: libarcrypto.so: cannot open shared object file: Nosuch file
or directory
--
Jarl
On 7/20/07, Mark Milke <[EMAIL PROTECTED]> wrote:
> > Try to start arplugin manually with truss, it may give some answers.
>
> here is the output:
>
> [EMAIL PROTECTED] conf]$ strace /appexec/ar/servername/bin/arplugin
> execve("/appexec/ar/servername/bin/arplugin", ["/appexec/ar/servername/
> bin/ar"...], [/* 18 vars */]) = 0
> [ Process PID=21163 runs in 32 bit mode. ]
> uname({sys="Linux", node="arsentw01.domain.de", ...}) = 0
> brk(0) = 0x80f7000
> open("/etc/ld.so.preload", O_RDONLY)= 3
> fstat64(0x3, 0xcec0)= 0
> old_mmap(NULL, 23, PROT_READ|PROT_WRITE, MAP_PRIVATE, 3, 0) =
> 0x40016000
> close(3)= 0
> readlink("/proc/self/exe", "/appexec/ar/servername/bin/arplugin",
> 4096) = 38
> open("/stub/lib/libcwait.so", O_RDONLY) = 3
> read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\340\4\0"...,
> 512) = 512
> fstat64(0x3, 0xcc44)= 0
> old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
> -1, 0) = 0x40017000
> old_mmap(NULL, 5936, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
> 0x40018000
> old_mmap(0x40019000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|
> MAP_FIXED, 3, 0) = 0x40019000
> close(3)= 0
> munmap(0x40016000, 23) = 0
> open("/etc/ld.so.cache", O_RDONLY) = 3
> fstat64(0x3, 0xc9a8)= 0
> old_mmap(NULL, 79996, PROT_READ, MAP_PRIVATE, 3, 0) = 0x4001a000
> close(3)= 0
> open("/lib/tls/libpthread.so.0", O_RDONLY) = 3
> read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0G\0\000"...,
> 512) = 512
> fstat64(0x3, 0xca20)= 0
> old_mmap(NULL, 65140, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
> 0x4002e000
> old_mmap(0x4003b000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|
> MAP_FIXED, 3, 0xc000) = 0x4003b000
> old_mmap(0x4003c000, 7796, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|
> MAP_ANONYMOUS, -1, 0) = 0x4003c000
> close(3)= 0
> open("/lib/tls/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
> such file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/lib/tls/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/lib/tls/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/lib/tls/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
> directory)
> stat64(0xc990, 0xca04) = 0
> open("/lib/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/lib/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file
> or directory)
> stat64(0xc990, 0xca04) = 0
> open("/lib/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
> directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/lib/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
> directory)
> stat64(0xc990, 0xca04) = 0
> open("/usr/lib/tls/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
> such file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/usr/lib/tls/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
> such file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/usr/lib/tls/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/usr/lib/tls/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/usr/lib/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
> such file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/usr/lib/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/usr/lib/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
> directory)
> open("/usr/lib/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
> directory)
> stat64(0xc990, 0xf
Re: ARDBC Plug-In doesn't work on Linux
It complain about this file:
/appexec/ar/servername/bin/arplugin: error while loading shared
libraries: libarcrypto.so: cannot open shared object file: Nosuch file
or directory
--
Jarl
On 7/20/07, Mark Milke <[EMAIL PROTECTED]> wrote:
> Try to start arplugin manually with truss, it may give some answers.
here is the output:
[EMAIL PROTECTED] conf]$ strace /appexec/ar/servername/bin/arplugin
execve("/appexec/ar/servername/bin/arplugin", ["/appexec/ar/servername/
bin/ar"...], [/* 18 vars */]) = 0
[ Process PID=21163 runs in 32 bit mode. ]
uname({sys="Linux", node="arsentw01.domain.de", ...}) = 0
brk(0) = 0x80f7000
open("/etc/ld.so.preload", O_RDONLY)= 3
fstat64(0x3, 0xcec0)= 0
old_mmap(NULL, 23, PROT_READ|PROT_WRITE, MAP_PRIVATE, 3, 0) =
0x40016000
close(3)= 0
readlink("/proc/self/exe", "/appexec/ar/servername/bin/arplugin",
4096) = 38
open("/stub/lib/libcwait.so", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\340\4\0"...,
512) = 512
fstat64(0x3, 0xcc44)= 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
-1, 0) = 0x40017000
old_mmap(NULL, 5936, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x40018000
old_mmap(0x40019000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|
MAP_FIXED, 3, 0) = 0x40019000
close(3)= 0
munmap(0x40016000, 23) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(0x3, 0xc9a8)= 0
old_mmap(NULL, 79996, PROT_READ, MAP_PRIVATE, 3, 0) = 0x4001a000
close(3)= 0
open("/lib/tls/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0G\0\000"...,
512) = 512
fstat64(0x3, 0xca20)= 0
old_mmap(NULL, 65140, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x4002e000
old_mmap(0x4003b000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|
MAP_FIXED, 3, 0xc000) = 0x4003b000
old_mmap(0x4003c000, 7796, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|
MAP_ANONYMOUS, -1, 0) = 0x4003c000
close(3)= 0
open("/lib/tls/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/tls/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/tls/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/tls/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = 0
open("/lib/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file
or directory)
stat64(0xc990, 0xca04) = 0
open("/lib/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = 0
open("/usr/lib/tls/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/tls/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/tls/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/tls/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = 0
writev(2, [{ptrace: umoven: Input/output error
0x26dc3e, 9663755672}, {ptrace: umoven: Input/output error
0x24400147f8, 9663755676}, {ptrace: umoven: Input/output error
0xe4001750f, 9663755667}, {ptrace: umoven: Input/output error
0x1e400174f0, 9663755667}, {ptrace: umoven: Input/output error
0x19400137e2, 5368788392}, {NUL
Re: ARDBC Plug-In doesn't work on Linux
> Try to start arplugin manually with truss, it may give some answers.
here is the output:
[EMAIL PROTECTED] conf]$ strace /appexec/ar/servername/bin/arplugin
execve("/appexec/ar/servername/bin/arplugin", ["/appexec/ar/servername/
bin/ar"...], [/* 18 vars */]) = 0
[ Process PID=21163 runs in 32 bit mode. ]
uname({sys="Linux", node="arsentw01.domain.de", ...}) = 0
brk(0) = 0x80f7000
open("/etc/ld.so.preload", O_RDONLY)= 3
fstat64(0x3, 0xcec0)= 0
old_mmap(NULL, 23, PROT_READ|PROT_WRITE, MAP_PRIVATE, 3, 0) =
0x40016000
close(3)= 0
readlink("/proc/self/exe", "/appexec/ar/servername/bin/arplugin",
4096) = 38
open("/stub/lib/libcwait.so", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\340\4\0"...,
512) = 512
fstat64(0x3, 0xcc44)= 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
-1, 0) = 0x40017000
old_mmap(NULL, 5936, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x40018000
old_mmap(0x40019000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|
MAP_FIXED, 3, 0) = 0x40019000
close(3)= 0
munmap(0x40016000, 23) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(0x3, 0xc9a8)= 0
old_mmap(NULL, 79996, PROT_READ, MAP_PRIVATE, 3, 0) = 0x4001a000
close(3)= 0
open("/lib/tls/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0G\0\000"...,
512) = 512
fstat64(0x3, 0xca20)= 0
old_mmap(NULL, 65140, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x4002e000
old_mmap(0x4003b000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|
MAP_FIXED, 3, 0xc000) = 0x4003b000
old_mmap(0x4003c000, 7796, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|
MAP_ANONYMOUS, -1, 0) = 0x4003c000
close(3)= 0
open("/lib/tls/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/tls/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/tls/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/tls/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = 0
open("/lib/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file
or directory)
stat64(0xc990, 0xca04) = 0
open("/lib/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/lib/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = 0
open("/usr/lib/tls/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/tls/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/tls/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/tls/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/i686/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No
such file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/i686/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/mmx/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such
file or directory)
stat64(0xc990, 0xca04) = -1 ENOENT (No such file or
directory)
open("/usr/lib/libarcrypto.so", O_RDONLY) = -1 ENOENT (No such file or
directory)
stat64(0xc990, 0xca04) = 0
writev(2, [{ptrace: umoven: Input/output error
0x26dc3e, 9663755672}, {ptrace: umoven: Input/output error
0x24400147f8, 9663755676}, {ptrace: umoven: Input/output error
0xe4001750f, 9663755667}, {ptrace: umoven: Input/output error
0x1e400174f0, 9663755667}, {ptrace: umoven: Input/output error
0x19400137e2, 5368788392}, {NULL, 0}, {NULL, 0}, {NULL, 0}, {NULL, 0},
{NULL, 0}], 10/appexec/ar/servername/bin/arplugin: error while loading
shared libraries: libarcrypto.so: cannot open shared object file: No
such file or directory
) = 152
exit_group(127)
Re: ARDBC Plug-In doesn't work on Linux
> Try to start arplugin manually with truss, it may give some answers. There is no truss on LINUX. There is strace. I'm not sure if I know how to do it... > Only include your plugin to easier debug. What do you mean saying include your plugin to easier debug? The plugin the the skeleton plugin from Remedy. Go to AR_INSTALL_DIR/api/ src/ardbc/skeleton/ and you can see it. It doesn't really matter which plugin I compile on this 64it LINUX box I get the same problem, even though we have precompiled plugins for reporting and ldap that work. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
Try to start arplugin manually with truss, it may give some answers. Only include your plugin to easier debug. -- Jarl On 7/20/07, Mark Milke <[EMAIL PROTECTED]> wrote: I just tried to compile and install the ardbcskeleton that was written by BMC Remedy. I even used their Makefile. When I install it and restart the server I get this again: Action Request System(R) Plug-In-Server Version 6.03.00 patch 021 Remedy, a BMC Software company. Copyright (c) 2001 - 2005 BMC Software, Inc. All rights reserved. 390695 : An error has occurred while loading a plug-in. (ARERR 8756) /appexec/ar/arsentw01_lbs/bin/ardbcskl.so: cannot open shared object file: File or Directory not found Any ideas what's wrong? Thanks! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
BTW, I already tried several different boxes with the same hardware and configuration and get the same error, so I guess it's not the problem of the box... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
> I have a similar error on my Dev (Solaris 9) server ONLY when I cycle > the services. If I do a reboot of the machine, I will never get an > error. I haven't had anytime to research but I think it might have to do > another plugin that hasn't stopped after you stopped the services (ps > -ef). I kicked out all other plug-in from the ar.conf and restarted the ARServer. Same error... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
BTW, this is a 64bit LINUX box. [EMAIL PROTECTED] linux]$ file ardbctest.so ardbctest.so: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped does anyone how to compile for 64bit LINUX boxes? Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
I have a similar error on my Dev (Solaris 9) server ONLY when I cycle the services. If I do a reboot of the machine, I will never get an error. I haven't had anytime to research but I think it might have to do another plugin that hasn't stopped after you stopped the services (ps -ef). -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Friday, July 20, 2007 5:27 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-In doesn't work on Linux I just tried to compile and install the ardbcskeleton that was written by BMC Remedy. I even used their Makefile. When I install it and restart the server I get this again: Action Request System(R) Plug-In-Server Version 6.03.00 patch 021 Remedy, a BMC Software company. Copyright (c) 2001 - 2005 BMC Software, Inc. All rights reserved. 390695 : An error has occurred while loading a plug-in. (ARERR 8756) /appexec/ar/arsentw01_lbs/bin/ardbcskl.so: cannot open shared object file: File or Directory not found Any ideas what's wrong? Thanks! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In doesn't work on Linux
I just tried to compile and install the ardbcskeleton that was written by BMC Remedy. I even used their Makefile. When I install it and restart the server I get this again: Action Request System(R) Plug-In-Server Version 6.03.00 patch 021 Remedy, a BMC Software company. Copyright (c) 2001 - 2005 BMC Software, Inc. All rights reserved. 390695 : An error has occurred while loading a plug-in. (ARERR 8756) /appexec/ar/arsentw01_lbs/bin/ardbcskl.so: cannot open shared object file: File or Directory not found Any ideas what's wrong? Thanks! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ARDBC Plug-In doesn't work on Linux
Hi everyone, I've have a self-written ARDBC plug-in which works just fine on Windows, Solaris and HP-UX. When I install it and try to restart the server on Linux I get this: Fri Jul 20 08:29:58 2007 390695 : An error has occurred while loading a plug-in. (ARERR 8756) Fri Jul 20 08:29:58 2007 /appexec/ar/arsentw01_spk/plugins/ ardbccsv/linux/linux/ardbccsv.so: cannot open shared object file: File or Directory not found. I have ldap and reporting plugins running on this server in the same directory, so I'm not sure what's wrong with it. Permissions of the .so library and directories are fine. Here is my Makefile: rm=/bin/rm -f CC=gcc -fPIC -DPIC -c LINK=gcc -shared -lc -fPIC -lnsl -lpthread -static-libgcc DEFS= -DAR_STRICT_ANSI -DLINUX -DFULL -DREMEDY_63 -D_REENTRANT AR= ar cq RANLIB= /usr/bin/ranlib LIBNAME= ardbctest.so LIBX= INCLUDES= -I. -I.. -I../inc DEFINES= $(INCLUDES) $(DEFS) -DSYS_UNIX=1 CFLAGS= -g -c $(DEFINES) SRCS = ardbctest.c ardbcstubs.c TestLayer.c TestUtils.c QualifierStruct.c crypt.c TimeStampMananger.c OBJS = ardbctest.o ardbcstubs.o TestLayer.o TestUtils.o QualifierStruct.o crypt.o TimeStampManager.o LIBS = $(OBJS) $(LIBX) .c.o: $(rm) -f $@ $(CC) $(CFLAGS) -c $*.c .cpp.o: $(rm) -f $@ $(CC) $(CFLAGS) -c $*.cpp all: $(LIBNAME) $(LIBNAME) : $(OBJS) $(rm) $@ $(LINK) -o $(LIBNAME) $(LIBS) clean: $(rm) $(OBJS) $(LIBNAME) cor *~ Do you guys think the Makefile is alright? Do you have any idea what's wrong with this thing? Thanks! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC plug-in
Make sure the file is loaded with the Plugin: parameter in ar.conf. If you don't have the library for the plugin, extract it from the installation source of whatever product includes it. Axton On 5/14/07, Guillermo Alfredo Torres Barron <[EMAIL PROTECTED]> wrote: I need the REMEDY.ARDBC.APPQUERY, and it doesn't appear in the log, how can I install the REMEDY.ARDBC.APPQUERY in my server? Remedy ITSM 7.0 Windows 2003 Oracle 10g Thanks in advance -Mensaje original- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] En nombre de Axton Enviado el: Sábado, 12 de Mayo de 2007 10:02 p.m. Para: arslist@ARSLIST.ORG Asunto: Re: ARDBC plug-in Importancia: Alta Two ways: 1-Look in the ar.conf file for the Plugin line: Plugin: /u01/arsystem/arsdev/bin/ardbcldap.so 2-Turn on plugin logging and restart the server. Look for: ARDBC Plug-In Loaded: ARSYS.ARDBC.LDAP version 3 Axton Grams On 5/12/07, Guillermo Alfredo Torres Barron <[EMAIL PROTECTED]> wrote: > Hi listers. > Can you tell me how I can know if in my Windows Server has installed the ARDBC plug-in?, and too in case of It have not it, Can you tell me like this plug-in is installed in the Windows Server for the Remedy Server 7.0? > Thanks in advance > > Remedy ITSM 7.0 > Windows 2003 > Oracle 10g > > > ... > Este correo electronico es confidencial y/o puede contener informacion privilegiada. > Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. > Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. > > This e-mail is confidential and/or may contain privileged information. > If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any > other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. > ... > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC plug-in
I need the REMEDY.ARDBC.APPQUERY, and it doesn't appear in the log, how can I install the REMEDY.ARDBC.APPQUERY in my server? Remedy ITSM 7.0 Windows 2003 Oracle 10g Thanks in advance -Mensaje original- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] En nombre de Axton Enviado el: Sábado, 12 de Mayo de 2007 10:02 p.m. Para: arslist@ARSLIST.ORG Asunto: Re: ARDBC plug-in Importancia: Alta Two ways: 1-Look in the ar.conf file for the Plugin line: Plugin: /u01/arsystem/arsdev/bin/ardbcldap.so 2-Turn on plugin logging and restart the server. Look for: ARDBC Plug-In Loaded: ARSYS.ARDBC.LDAP version 3 Axton Grams On 5/12/07, Guillermo Alfredo Torres Barron <[EMAIL PROTECTED]> wrote: > Hi listers. > Can you tell me how I can know if in my Windows Server has installed the > ARDBC plug-in?, and too in case of It have not it, Can you tell me like this > plug-in is installed in the Windows Server for the Remedy Server 7.0? > Thanks in advance > > Remedy ITSM 7.0 > Windows 2003 > Oracle 10g > > > ... > Este correo electronico es confidencial y/o puede contener informacion > privilegiada. > Si usted no es su destinatario o no es alguna persona autorizada por este > para recibir sus correos electronicos, NO debera usted utilizar, copiar, > revelar, o tomar ninguna accion basada en este correo electronico o cualquier > otra informacion incluida en el, favor de notificar al remitente de inmediato > mediante el reenvio de este correo electronico y borrar a continuacion > totalmente este correo electronico y sus anexos. > Nota: Los acentos y caracteres especiales fueron omitidos para su correcta > lectura en cualquier medio electronico. > > This e-mail is confidential and/or may contain privileged information. > If you are not the addressee or authorized to receive this for the addressee, > you must not use, copy, disclose, or take any action based on this message or > any > other information herein, please advise the sender immediately by reply this > e-mail and delete this e-mail and its attachments. > ... > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC plug-in
Two ways: 1-Look in the ar.conf file for the Plugin line: Plugin: /u01/arsystem/arsdev/bin/ardbcldap.so 2-Turn on plugin logging and restart the server. Look for: ARDBC Plug-In Loaded: ARSYS.ARDBC.LDAP version 3 Axton Grams On 5/12/07, Guillermo Alfredo Torres Barron <[EMAIL PROTECTED]> wrote: Hi listers. Can you tell me how I can know if in my Windows Server has installed the ARDBC plug-in?, and too in case of It have not it, Can you tell me like this plug-in is installed in the Windows Server for the Remedy Server 7.0? Thanks in advance Remedy ITSM 7.0 Windows 2003 Oracle 10g ... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ARDBC plug-in
Hi listers. Can you tell me how I can know if in my Windows Server has installed the ARDBC plug-in?, and too in case of It have not it, Can you tell me like this plug-in is installed in the Windows Server for the Remedy Server 7.0? Thanks in advance Remedy ITSM 7.0 Windows 2003 Oracle 10g ... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In for MS Access
Right you are Tim, Vendor Form. I will check out Mr. Croom's products. I do remember that there was a public available one for Excel, thought there might be one for access as well. Thanks, Doug From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Wednesday, December 20, 2006 2:54 PM To: arslist@ARSLIST.ORG Subject: Re: ARDBC Plug-In for MS Access Hi, Doug! You mean a vendor form? Didn't James Croom write a generic ARDBC plug-in for ODBC? If you're on MS SQL Server, you can probably create a database link via the OLE-DB interface. Then you can use a simple view form and query against the Access table. Tim Widowfield http://www.widowfield.com - Original Message From: "Tanner, Doug" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, December 20, 2006 2:48:32 PM Subject: [ARSLIST] ARDBC Plug-In for MS Access ** Anyone have information on an available ARDBC Plug-in for Remedy (View Form) ? Thanks, Doug Doug Tanner Senior Developer Remedy Skilled Professional (RSP) (704) 328-3178 [EMAIL PROTECTED] DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC Plug-In for MS Access
Hi, Doug! You mean a vendor form? Didn't James Croom write a generic ARDBC plug-in for ODBC? If you're on MS SQL Server, you can probably create a database link via the OLE-DB interface. Then you can use a simple view form and query against the Access table. Tim Widowfield http://www.widowfield.com - Original Message From: "Tanner, Doug" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, December 20, 2006 2:48:32 PM Subject: [ARSLIST] ARDBC Plug-In for MS Access ** Anyone have information on an available ARDBC Plug-in for Remedy (View Form) ? Thanks, Doug Doug Tanner Senior Developer Remedy Skilled Professional (RSP) (704) 328-3178 [EMAIL PROTECTED] DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ARDBC Plug-In for MS Access
Anyone have information on an available ARDBC Plug-in for Remedy (View Form) ? Thanks, Doug Doug Tanner Senior Developer Remedy Skilled Professional (RSP) (704) 328-3178 [EMAIL PROTECTED] DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARDBC plug-in to Sybase
Matt, Thanks for the reply. I have put in a request to the Sybase DBA for the ODBC client. This is a one table query so the justification for Gidd's tool just isn't there. I tried the eval when it was new and it was GREAT! They want it to be real time and batch imports ties up a person each time. The direct link via a Vendor form would allow some escalations to check the state of data in the Sybase system and pull changed info into the ARS db. I'll check out the link. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, September 14, 2006 12:58 PM To: arslist@ARSLIST.ORG Subject: Re: ARDBC plug-in to Sybase John, It is far from a "sample ARDBC plugin" but you might look at jtds for a few options. (http://jtds.sourceforge.net/) If you like Perl you could take a run at one of the following modules: DBD::Sybase, DBD::ODBC, or DBD::FreeTDS. Of If you like C and what to get it "straight from Sybase" then you could go the "Open Client" route. I doubt that was as much help as you wanted, but I hope it helps some. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/13/06, Reiser, John J <[EMAIL PROTECTED]> wrote: > Hello Listers, > > > ARS 6.3 Patch 14 > MS SQL Server 2000 > > > Has anyone seen any sample ARDBC plugin code for reading a remote > Sybase DB? > I looked at the Buoyant Solutions Integrations but there are two > problems. We have no money and it looks like the Sybase integration is > not ready yet. > > We are looking for a solution to read a remote Sybase table and either > use a Vendor form or just a Set Fields filter action. > I checked some other options from information I gleaned off of the List. > I have not been able to find a "gateway" for MS SQL to interact with > Sybase. I have control of the MS SQL Server but the Sybase system is > controlled by the corporation. > > > Thanks, > > John J. Reiser > Software Development Analyst > Remedy Administrator/Developer > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - > paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARDBC plug-in to Sybase
This is a bit basic but it works. Install the Sybase client on your DB Server. Setup an ODBC DSN to that DB. Go into SQL Server Enterprise Manager//Security/Linked Servers right click and tell it to create a new linked server. Choose 'Microsoft OLE DB Provider for ODBC Drivers'. Provide it with a DSN Name. Go into the Remedy DB (ARSystem?) and create a view using your new linked server, it took me forever to get the table names proper but I use ..DBA.. Now that you have a View in your Remedy DB you can create a vendor form base off of that view and you should be good to go. Please feel free to contact me off list if you need additional details or help getting it working. L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Wednesday, September 13, 2006 10:40 AM To: arslist@ARSLIST.ORG Subject: ARDBC plug-in to Sybase Hello Listers, ARS 6.3 Patch 14 MS SQL Server 2000 Has anyone seen any sample ARDBC plugin code for reading a remote Sybase DB? I looked at the Buoyant Solutions Integrations but there are two problems. We have no money and it looks like the Sybase integration is not ready yet. We are looking for a solution to read a remote Sybase table and either use a Vendor form or just a Set Fields filter action. I checked some other options from information I gleaned off of the List. I have not been able to find a "gateway" for MS SQL to interact with Sybase. I have control of the MS SQL Server but the Sybase system is controlled by the corporation. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARDBC plug-in to Sybase
John, It is far from a "sample ARDBC plugin" but you might look at jtds for a few options. (http://jtds.sourceforge.net/) If you like Perl you could take a run at one of the following modules: DBD::Sybase, DBD::ODBC, or DBD::FreeTDS. Of If you like C and what to get it "straight from Sybase" then you could go the "Open Client" route. I doubt that was as much help as you wanted, but I hope it helps some. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/13/06, Reiser, John J <[EMAIL PROTECTED]> wrote: Hello Listers, ARS 6.3 Patch 14 MS SQL Server 2000 Has anyone seen any sample ARDBC plugin code for reading a remote Sybase DB? I looked at the Buoyant Solutions Integrations but there are two problems. We have no money and it looks like the Sybase integration is not ready yet. We are looking for a solution to read a remote Sybase table and either use a Vendor form or just a Set Fields filter action. I checked some other options from information I gleaned off of the List. I have not been able to find a "gateway" for MS SQL to interact with Sybase. I have control of the MS SQL Server but the Sybase system is controlled by the corporation. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ARDBC plug-in to Sybase
Hello Listers, ARS 6.3 Patch 14 MS SQL Server 2000 Has anyone seen any sample ARDBC plugin code for reading a remote Sybase DB? I looked at the Buoyant Solutions Integrations but there are two problems. We have no money and it looks like the Sybase integration is not ready yet. We are looking for a solution to read a remote Sybase table and either use a Vendor form or just a Set Fields filter action. I checked some other options from information I gleaned off of the List. I have not been able to find a "gateway" for MS SQL to interact with Sybase. I have control of the MS SQL Server but the Sybase system is controlled by the corporation. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ardbc plug-in
Go to Community Downloads, search for getemployeedata. Here you find an example retrieving data from Oracle database, Or you can buy a solutuon here: http://www.buoyantsolutions.net/oracle_link.htm - Jarl On 8/21/06, Javier blasco Bernáldez <[EMAIL PROTECTED]> wrote: Hello everybody, In order to access an external Oracle database, I have to create an ardbc plug-in and use some vendor forms. I have taken a look at Remedy documentation (ardbcfs source included) but this is the first time I work with plug-ins and I don't know how to start. Please, ¿could anybody show me an ardbc code example? Thank you in advance. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ardbc plug-in
Hello everybody, In order to access an external Oracle database, I have to create an ardbc plug-in and use some vendor forms. I have taken a look at Remedy documentation (ardbcfs source included) but this is the first time I work with plug-ins and I don't know how to start. Please, ¿could anybody show me an ardbc code example? Thank you in advance. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
