WARNING: this is an automatic post retrieved from the Asterisk-Users Mailing List, not an authored post
January 06, 2012
Tags: environmental variables, munir, perl sqlplus, sqlplus oracle
Here’s one more thing to try – do a “su – nobody” then run the agi – once it
runs under “su – nobody” there’s no reason it should run in Asterisk.
[mailto:email@example.com] On Behalf Of Ahmed Munir
Sent: Friday, January 06, 2012 9:33 AM
Subject: Re: [asterisk-users] asterisk -> AGI (perl) -> sqlplus(oracle)
Yes, I already declared ‘use lib
“/home/asterisk/lib/lib64/perl5/5.8.8/x86_64-linux-thread-multi/”;’ in my
AGI. When I execute the script as a user Asterisk, i.e. perl -wc test.pl in
return I’m getting OK and no error messages and script is running fine when
I try to run in shell.
Even though I already declared the environmental variables in .bash_profile.
At the end I tired every method but still stuck in this problem.
Date: Thu, 5 Jan 2012 14:07:59 -0800
From: “Ron Bergin”
Subject: Re: [asterisk-users] asterisk -> AGI (perl) -> sqlplus
To: “Asterisk Users Mailing List – Non-Commercial Discussion”
Ahmed Munir wrote:
> I installed the modules in asterisk user home directory with read and
> excitable permissions for asterisk but still my AGI not working.
IMO, it would have been better to install it in it’s normal location.
Is your script using the warnings and strict pragmas?
What error message do you receive when running the script from the command
Did you add the proper “use lib ‘….’” statement to add the install
directory to the @INC array?
> Please provide me other advise to resolve this issue.
>> Date: Wed, 4 Jan 2012 11:30:34 -0600
>> From: “Danny Nicholas”
>> Subject: Re: [asterisk-users] asterisk -> AGI (perl) -> sqlplus
>> To: “‘Asterisk Users Mailing List – Non-Commercial Discussion’”
>> Message-ID: <firstname.lastname@example.org>
>> Content-Type: text/plain; charset=”us-ascii”
>> The module probably isn’t readable/executeable from Asterisk
>> From: email@example.com
>> [mailto:firstname.lastname@example.org] On Behalf Of Ahmed
>> Sent: Wednesday, January 04, 2012 10:45 AM
>> To: email@example.com
>> Subject: [asterisk-users] asterisk -> AGI (perl) -> sqlplus (oracle)
>> Hi all,
>> I’m trying to run an AGI in PERL which uses the module DBD-Oracle.
>> my AGI is working fine in my two servers but not in my other four
>> When I tried execute an AGI (as a user asterisk) in command line it
>> fine (even I also declare environmental variables in user profile and in
>> AGI), but when I tried to call my AGI (perl) in dial plan, it don’t get
>> Please advise me to resolve this issue.
>> Ahmed Munir Chohan