arsperl-users — Discussions regarding the use of ARSperl

Re: ars_CreateEntry

[Jeff M. <jcm...@sm...>]

Miriam Yaged insists:
>
>After defining the following statement:
>local($create_result) = ars_CreateEntry($ctrl, $schema, $fieldvalues);
>Why wouldn't $create_result be equal to anything??
>
>It is not giving me any error messages but it is not creating the ticket
>either.


as with all arsperl calls, if they fail or do something unexpected, 
you should always inspect $ars_errstr

in the above, CreateEntry is being used incorrectly.
see the online doc for the command syntax.

jeff

Re: ARS Perl on NCR Unix

[tim.widowfield <ta...@dn...>]

That's a start.  Thanks.  BTW, please note the corrected e-mail address
above.

--Tim Widowfield, 
  tim...@en...


On Mon, 9 Dec 1996, Jeff Murphy wrote:

> >Here's some of the stderr from gcc:
> >
> >In file included from /usr/gnu/lib/perl5/sys3k/5.003/CORE/perl.h:619,
> >                 from ARS.c:34:
> >/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h:12: parse error before `ssize_t'
> 
> 
> ssize_t is usually defined in sys/types.h or unistd.h ..
> 
> trying defining I_SYS_PARAM and PARAM_NEEDS_TYPES when compiling ARSperl
> maybe? 
> 
> sorry, no experience on ncr unix.
> 

Re: ARS Perl on NCR Unix

[Jeff M. <jcm...@sm...>]

>Here's some of the stderr from gcc:
>
>In file included from /usr/gnu/lib/perl5/sys3k/5.003/CORE/perl.h:619,
>                 from ARS.c:34:
>/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h:12: parse error before `ssize_t'


ssize_t is usually defined in sys/types.h or unistd.h ..

trying defining I_SYS_PARAM and PARAM_NEEDS_TYPES when compiling ARSperl
maybe? 

sorry, no experience on ncr unix.

ARS Perl on NCR Unix

[tim.widowfield <ta...@en...>]

Don't laugh.  Aything's possible, right?

I haven't had much success yet.  I'm using Perl 5.003 and ARS 2.1.3.
Should I jump back a rev. on Perl?

I've attached error messages.  We have two compilers to choose from: cc
(Metaware) and gcc.  With either, compilation fails.  Using "cc" I get
complaints about Perl's av.h.  Using "gcc" I get errors from the ARS.c
file, referencing av.h again.

--------------------------
Here's what I see from cc:

damfino(69)# make
        /bin/cc -c -I/usr/ar/api/include -I/usr/include -I/usr/ucbinclude -I/usr
/gnu/include -O -Xa -DOVR_DBL_DIG=17     -DVERSION=\"1.3\"  -DXS_VERSION=\"1.3\"
 -Kpic -I/usr/gnu/lib/perl5/sys3k/5.003/CORE -g -DWASTE_MEM -DPROFILE ARS.c
(/bin/cc:) Warning: -g or -ql specified, optimization restricted
NCR High Performance C Compiler R1.0c
(c) Copyright 1992-94, NCR Corporation
(c) Copyright 1987-94, MetaWare Incorporated

E "/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h",L12/C13:   (syntactic)  unexpected
symbol:'<IDENTIFIER>':xav_fill
REPAIR:   ',' was inserted before '<IDENTIFIER>':xav_fill@"/usr/gnu/lib/perl5/sy
s3k/5.003/CORE/av.h",L12/C13

E "/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h",L13/C13:   (syntactic)  unexpected
symbol:'<IDENTIFIER>':xav_max
REPAIR:   ',' was inserted before '<IDENTIFIER>':xav_max@"/usr/gnu/lib/perl5/sys
3k/5.003/CORE/av.h",L13/C13
2 user errors   No warnings
*** Error code 8 (bu21)

make: fatal error.   

-----------------------------
Here's some of the stderr from gcc:

.....many warnings deleted......

In file included from /usr/gnu/lib/perl5/sys3k/5.003/CORE/perl.h:619,
                 from ARS.c:34:
/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h:12: parse error before `ssize_t'
/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h:12: warning: no semicolon at end of str
uct or union
/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h:13: warning: data definition has no typ
e or storage class
/usr/gnu/lib/perl5/sys3k/5.003/CORE/av.h:22: parse error before `}'
In file included from ARS.c:34:
/usr/gnu/lib/perl5/sys3k/5.003/CORE/perl.h:1367: parse error before `top_env'
/usr/gnu/lib/perl5/sys3k/5.003/CORE/perl.h:1367: warning: data definition has no
 type or storage class
ARS.c: In function `dup_Value':
ARS.c:873: warning: assignment makes pointer from integer without a cast
ARS.c:876: warning: assignment makes pointer from integer without a cast
*** Error code 1 (bu21)

make: fatal error.   




--Tim Widowfield, 
  tim...@en...

Re: ars_DeleteEntry

[Jeff M. <jcm...@sm...>]

>	ars_DeleteEntry($ctrl,$schema,$entry_id);
>
>where $schema and $entry_id are set earlier in the script, I'm getting the
>following error from $ars_errstr:
>
>	Entry does not exist in database
>
>But it does!  Has anyone else had this same kind of problem?


i use the following script frequently and have never seen an error.
it runs as an Administrator user.

#!/usr/local/bin/perl
#
use ARS;
 
($schema, $eid) = @ARGV;
if(!defined($eid)) {
    print "Usage: $0 [schema] [entry id]\n";
    exit 0;
}
 
$ctrl = ars_Login($SERVER, $ACCOUNT, $PASSWORD);
 
if(ars_DeleteEntry($ctrl, $schema, $eid) == 0) {
    printf "entry $eid deleted from \"$schema\"\n";
} else {
    print "Couldn't delete entry $eid from $schema: $ars_errstr\n";
}
 
ars_Logoff($ctrl);

Re: ars_DeleteEntry

[Joel M. <jm...@cn...>]

> where $schema and $entry_id are set earlier in the script, I'm getting the
> following error from $ars_errstr:
> 
> 	Entry does not exist in database
> 
> But it does!  Has anyone else had this same kind of problem?
> 

off hand, you might need to pad the entry_id with zeros.  ars_padEntryid
does this for you.

ars_DeleteEntry

[Brad E. <bev...@fo...>]

I'm having trouble getting ars_DeleteEntry to work.  I'm logging into the
server using a user with administrator privileges and I can successfully
retrieve the entry id that meets my query requirements; however when I try to
delete the entry using the following statement:

	ars_DeleteEntry($ctrl,$schema,$entry_id);

where $schema and $entry_id are set earlier in the script, I'm getting the
following error from $ars_errstr:

	Entry does not exist in database

But it does!  Has anyone else had this same kind of problem?

SetEntry

[Miriam Y. <mir...@nb...>]

Thanks so much for all your help.

Your last suggestion was real helpful!

I got another problem - 

When I call the function ars_SetEntry - to modify 1 field :

ars_SetEntry($ctrl, $schema,"000000000000013", $getTime, $fields{"Log"},
"138.8.132.190")) || die "Can't modify entry $ars_errstr";

It works every other time I run the program. (It is extremely
consistent!)

Do you have any suggestions??

Thanks.

Miriam

Re: ARSperl - GetFieldTable and GetFieldByName

[Joel M. <jm...@cn...>]

ah, try:

(%fields = ars_GetFieldTable($ctrl, $schema)) || die "Can't retrieve field name
s $ars_errstr";

Re: ARSperl - GetFieldTable and GetFieldByName

[Miriam Y. <mir...@gs...>]

actually ars__GetFieldTable never displays any error messages it just doesn't
store anything in the associative array - only the first time I ran the script
it did - and after that it hasn't:

%fields = ars_GetFieldTable($ctrl, $schema) || die "Can't retrieve field names
$ars_errstr";

When I print out the fields array it doesn't print anything:

foreach $fieldname (sort (keys %fields)){
    print "$fieldname \n";
}

And so when I call ars_CreateEntry - it fails because it doesn't contain the
field ids:

ars_CreateEntry($ctrl, $schema, $fields{"Email From"}, $sender, $fields{"Email
To"}, $receiver, $fields{"Email Size"}, $size, $fields{"Message-ID"}, $msgid,
$fields{"Message Date"}, $date, $fields{"Submitter"}, $submitter,
$fields{"Infosec Person"}, $referred, $fields{"Employee Relations Person"},
$Relations, $fields{"History"}, $history, $fields{"Description of contents"},
$contents, $fields{"Type of information in email"}, $type,
$fields{"Assigned-to"}, "Shabbir Safdar") || die "Can't create ticket
$ars_errstr";


All help will be greatly appreciated.

Miriam Yaged
Information Security
Goldman Sachs, & Co.
(212) 357-1939

Re: ARSperl - GetFieldTable and GetFieldByName

[Joel M. <jm...@cn...>]

> the script it works perfectly - However the next time the script breaks
> at these two functions.  It seems to consistently work every other time.
> Do you have any suggestions on how I can rectify this problem??
> 

you should change the $ar_errstr to $ars_errstr so you get meaningful
error messages.  Then, what is the error message it gives you?

(You should also change your password for Demo if you haven't already.)

Joel

ARSperl - GetFieldTable and GetFieldByName

[Miriam Y. <mir...@nb...>]

Attached is one of the scripts which I am having problems with.  It
seems to be the GetFieldTable and GetFieldbyName - The first time I run
the script it works perfectly - However the next time the script breaks
at these two functions.  It seems to consistently work every other time.
Do you have any suggestions on how I can rectify this problem??

I also used GetFieldTable - and stored the results in an associative
array  but decided to try GetFieldByName and see if I'd get better
results.

Thanks alot.

Re: SetEntry for diary fields

[Miriam Y. <mir...@gs...>]

Thanks alot.

Miriam Yaged
Information Security
Goldman Sachs, & Co.
(212) 357-1939

Re: SetEntry for diary fields

[Jeff M. <jcm...@sm...>]

>I would like to modify a diary field using the function ars_SetEntry()-
>Will I run into problems ? Is there anything special I have to declare
>or do because it's a diary field?


performing a SetEntry on a diary field will add a new entry to the diary.
you can not modify or remove old entries from the diary field for the
record you specify. 

performing a SetEntry on a diary field is just like any other field.. 
arsperl will figure out that you want to add an entry to the diary and
will "do the right thing".

jeff

SetEntry for diary fields

[Miriam Y. <mir...@nb...>]

First of all I am quite pleased with ARSperl!!!!!

I had no idea about you guys but decided to search the Internet to see
if anyone used perl with Remedy - and I was pleasently surprised to see 
your site - I downloaded it two days ago and the installation was a 
breeze.

I would like to modify a diary field using the function ars_SetEntry()-
Will I run into problems ? Is there anything special I have to declare
or do because it's a diary field?

Thanks alot.

Miriam Yaged
Information Security 
Goldman Sachs & Co.
(212) 357-1939

Installation woes

[Kurt S. <ku...@mi...>]

G'day

This should be easy.

Trying to install ARSperl on Solaris2.5.1.  It installed perfectly on a 
machine that has DBD and DBI installed on it.  

e.g. error from running Dump_Users.pl:
error in ars_LoadQualifier at ./Dump_Users.pl line 46

Is DBD and DBI needed for the install/system to work correctly?

Any help would be appreciated.

bye
Kurt
-----------------------------------------------------------------
Kurt Sterzl (BE-Comp Sys) Systems Administrator, Systems Integration
MINCOM Pty Ltd  PO Box 72  Stones Corner  QLD  4120 
Email: ku...@mi...  Ph: +61 7 3364 9999  Fax: +61 7 3394 2844

Re: perl5.003_7 breaks ARSperl

[Jeff M. <jcm...@sm...>]

>Anyone else try the 003_7 release?


since 003_7 isn't an officially "supported" version of perl.. we don't
recommend using it.. once the next version of perl is released, we'll
test out arsperl on it and release (if need be) an updated distribution
to work with the new version. 

perl5.003_7 breaks ARSperl

[Bruce W. H. <bh...@ad...>]

After installing the above named perl version and reinstalling all
external modules (including ARS) using the WWW/ client and sever cgi
scripts would no longer successfully connect to the the ARS database.  A
return error message complained about an improperly formatted header line
being generated.  No other information was displayed.

This was true for both ARSperl 1.2.2 and 1.3.

Reverting back to perl5.003 (the stable release) renabled the ARS
module.  I was able to revert to the original distribution as I
installed the 003_7 package somewhere else.

I could did not troubleshoot this problem any further than this.

Anyone else try the 003_7 release?

Peace.

Re: SunOS 4.1.3 Install Problems

[<ch...@mi...>]

I had the same compiling error on HP platform. I even upgraded the compiler on the HP box, no luck.
GCC compiled charmingly, it is amazing what free stuff can do.

charlie> 
> On Sun, 24 Nov 1996, Duane Rapp wrote:
> 
> > Sorry if this has been posted before:
> > 
> > 
> > Do you need the gcc compiler to run the make command on step 2 of the 
> > ARSperl install. I am using the cc compiler, and am getting many many 
> > errors similar to the following. I am assuming that the compiler I am using
> > cannot handle the function pointer definition, but I could use any offline 
> > comments you can give me. 
> 
> Bingo!  I came up against this same problem, and installing gcc solved it.
> Make sure you are up to date on perl5 as well.
> 
> > 
> > I am running ARS 2.02 on a SunOS 4.1.3_U1 Sparc 
> > 
> > "ARS.c", line 67: syntax error at or near symbol *
> > "ARS.c", line 67: ARStatusStruct declared as parameter to non-function
> > 
> > Thanks
> > 
> > 
> > Duane D. Rapp
> > Motorola LMPS RNSG IS
> > Voice: (847) 576-1336
> > 
> 
>      ____/    ____/   ___ \     ____/        David A. Bolton (da...@ss...)
>   ____  /  ____  /   /__/ /  ____  /         2290 Lakeview Dr. Suite E
> _______/ _______/ _______/ _______/, Inc.    Beavercreek, OH 45431
> "Business Driven Technology Solutions"       (937) 429-2091
> 
> 
> 

Re: SunOS 4.1.3 Install Problems

[Dave B. (S. Administrator) <dav...@ss...>]

On Sun, 24 Nov 1996, Duane Rapp wrote:

> Sorry if this has been posted before:
> 
> 
> Do you need the gcc compiler to run the make command on step 2 of the 
> ARSperl install. I am using the cc compiler, and am getting many many 
> errors similar to the following. I am assuming that the compiler I am using
> cannot handle the function pointer definition, but I could use any offline 
> comments you can give me. 

Bingo!  I came up against this same problem, and installing gcc solved it.
Make sure you are up to date on perl5 as well.

> 
> I am running ARS 2.02 on a SunOS 4.1.3_U1 Sparc 
> 
> "ARS.c", line 67: syntax error at or near symbol *
> "ARS.c", line 67: ARStatusStruct declared as parameter to non-function
> 
> Thanks
> 
> 
> Duane D. Rapp
> Motorola LMPS RNSG IS
> Voice: (847) 576-1336
> 

     ____/    ____/   ___ \     ____/        David A. Bolton (da...@ss...)
  ____  /  ____  /   /__/ /  ____  /         2290 Lakeview Dr. Suite E
_______/ _______/ _______/ _______/, Inc.    Beavercreek, OH 45431
"Business Driven Technology Solutions"       (937) 429-2091

SunOS 4.1.3 Install Problems

[<dr...@ar...>]

Sorry if this has been posted before:


Do you need the gcc compiler to run the make command on step 2 of the 
ARSperl install. I am using the cc compiler, and am getting many many 
errors similar to the following. I am assuming that the compiler I am using
cannot handle the function pointer definition, but I could use any offline 
comments you can give me. 

I am running ARS 2.02 on a SunOS 4.1.3_U1 Sparc 

"ARS.c", line 67: syntax error at or near symbol *
"ARS.c", line 67: ARStatusStruct declared as parameter to non-function

Thanks


Duane D. Rapp
Motorola LMPS RNSG IS
Voice: (847) 576-1336

arsperl 1.3 released

[Jeff M. <jcm...@sm...>]

1.3 Notes
---------

We've added some features for performance analysis. In particular, 
we've added the "profiling" feature to ARSperl. Now, when you call
ars_Login() it initializes a profiling variable that will track
the number of queries your script makes against the server. You
can then access this information using the ars_GetProfileInfo() call.

We send this information to syslog() automatically at the end of
each script and then process the syslog file later on to keep stats
on our API scripts. In this fashion, we can quickly determine which
scripts are triggered the most, and which make the most queries. We
can then concentrate out optimization efforts on those particular
API scripts.

In addition, a few new functions were added (GetFilter, GetCharMenu and
GetServerStatistics). The first two are used by the WhoUsesIt.pl 
utility. This utility (found in the "examples" directory) is handy for
locating which filter or menu is referencing a particular file, or 
seeing exactly what filters a particular schema uses.. etc. This 
cuts down the amount of time it takes to figure out a poorly documented
system (what? poor documentation? not us!! :)

The GetServerStatistics function was added to provide a simpler method
for checking server health. I might provide a server analysis tool 
built around this function in a future release. 

Joel added a cache to the internal GetField routine. This should cut
down on the number of queries made by some of the functions like
GetFieldTable and such.

jeff


ARSperl:

http://smurfland.cit.buffalo.edu/ARSperl/index.html

check out the two utilities included in the package (doc is available 
on the web page):

	DumpSetup.pl (will work with 1.22 installations)
		archive your server definitions using RCS nightly (via cron)

	WhoUsesIt.pl (requires 1.3)
		track down menu files, process files, see what active links
		a schema uses.. etc. 

Re: ars_GetField($ctrl, $schema, $id)

[Joel M. <jm...@cn...>]

> This procedure does not seem to work. I am expecting a hash to be 
> returned, and get nothing.  ars_errstr is not set either.  could
> you please elucidate our problem?

GetField actually returns a reference to a hash, you would need to use
"keys %$field_props", and "$field_props->{$property}".  Keep in mind
that some of the values are themselves references.  So you might need
to do something like $field_props->{displayList}[0]{label} to get
what you want.

ars_GetField($ctrl, $schema, $id)

[Rahul A. <ra...@ki...>]

This procedure does not seem to work. I am expecting a hash to be 
returned, and get nothing.  ars_errstr is not set either.  could
you please elucidate our problem?

Here is the code excerpt:
#!/usr/local/bin/perl

use ARS;

$field=pop(@ARGV);
$schema=pop(@ARGV);
$ctrl=ars_Login(VALID INFO HERE);
$id=ars_GetFieldByName($ctrl, $schema, $field);
%field_props=ars_GetField($ctrl, $schema, $id);
print "$id\n";
foreach $property (keys %field_props){
        print "$property: $field_props{$property}\n";
}

print "$ars_errstr\n";
ars_Logoff($ctrl);     

_______________________________________________________________
Rahul Argade
902-B8 Park Ridge Road
Durham, NC 27713
919.403.9777

Re: Returned mail: User unknown

[Dave B. (S. Administrator) <dav...@ss...>]

	Try compiling it with gcc (instead of the local cc compiler)
     ____/    
____/   ___ \     ____/        David A. Bolton (da...@ss...)
  ____  /  ____  /   /__/ /  ____  /         2290 Lakeview Dr. Suite E
_______/ _______/ _______/ _______/, Inc.    Beavercreek, OH 45431
"Business Driven Technology Solutions"       (513) 429-2091