The thing is, my AGI is working fine if I don't include DBD::Oracle library in my script. If I include DBD::Oracle library my AGI script gets aborted. I installed DBD::Oracle module in asterisk application home directory as its' permissions are listed below;<br>
<br>[asterisk@klpi062 ~]$ ls -lh /home/asterisk/perl-lib/lib/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/<br>total 40K<br>drwxr-xr-x 3 asterisk asterisk 4.0K Jan 3 14:16 auto<br>drwxr-xr-x 3 asterisk asterisk 4.0K Jan 3 14:16 DBD<br>
-rwxr-xr-x 1 asterisk asterisk 1.3K Aug 26 14:09 <a href="http://oraperl.ph">oraperl.ph</a><br>-rwxr-xr-x 1 asterisk asterisk 28K Oct 12 12:43 Oraperl.pm<br><br><div class="gmail_quote"><div>I also included the library path for locating DBD::Oracle module in my AGI. But still unable to understand even though asterisk has permissions to access DBD module but still AGI don't work when I include DBD library in it.<br>
<br> </div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Date: Wed, 4 Jan 2012 12:18:24 -0600<br>
From: "Danny Nicholas" <<a href="mailto:danny@debsinc.com">danny@debsinc.com</a>><br>
Subject: Re: [asterisk-users] asterisk -> AGI (perl) -> sqlplus<br>
(oracle)<br>
To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"<br>
<<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a>><br>
Message-ID: <010101cccb0d$3fa6a140$bef3e3c0$@<a href="http://debsinc.com" target="_blank">debsinc.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
What are the permissions on the module you are trying to run? (ls -l<br>
/var/lib/asterisk/agi-bin/module)<br>
<br>
<br>
<br>
From: <a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a><br>
[mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a>] On Behalf Of Ahmed Munir<br>
Sent: Wednesday, January 04, 2012 12:15 PM<br>
To: <a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a><br>
Subject: Re: [asterisk-users] asterisk -> AGI (perl) -> sqlplus (oracle)<br>
<br>
<br>
<br>
Hi,<br>
<br>
I installed the modules in asterisk user home directory with read and<br>
excitable permissions for asterisk but still my AGI not working.<br>
<br>
Please provide me other advise to resolve this issue.<br>
<br>
<br>
Date: Wed, 4 Jan 2012 11:30:34 -0600<br>
From: "Danny Nicholas" <<a href="mailto:danny@debsinc.com">danny@debsinc.com</a>><br>
Subject: Re: [asterisk-users] asterisk -> AGI (perl) -> sqlplus<br>
(oracle)<br>
To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"<br>
<<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a>><br>
Message-ID: <00ca01cccb06$911e8300$b35b8900$@<a href="http://debsinc.com" target="_blank">debsinc.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
The module probably isn't readable/executeable from Asterisk<br>
<br>
<br>
<br>
From: <a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a><br>
[mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a>] On Behalf Of Ahmed Munir<br>
Sent: Wednesday, January 04, 2012 10:45 AM<br>
To: <a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a><br>
Subject: [asterisk-users] asterisk -> AGI (perl) -> sqlplus (oracle)<br>
<br>
<br>
<br>
Hi all,<br>
<br>
I'm trying to run an AGI in PERL which uses the module DBD-Oracle. Currently<br>
my AGI is working fine in my two servers but not in my other four servers.<br>
When I tried execute an AGI (as a user asterisk) in command line it works<br>
fine (even I also declare environmental variables in user profile and in my<br>
AGI), but when I tried to call my AGI (perl) in dial plan, it don't get<br>
executed.<br>
<br>
Please advise me to resolve this issue.<br>
<br>
--<br>
Regards,<br>
<br>
Ahmed Munir Chohan<br>
<br>
<br>
<br>
<br></blockquote></div>-- <br>Regards,<br><br>Ahmed Munir Chohan<br><br><br>