Re: [asterisk-users] asterisk - AGI (perl) - sqlplus(oracle)

2012-01-07 Thread Steve Edwards
On Fri, 6 Jan 2012, Dale Noll wrote: I found the following lines to be helpful. $ENV{TNS_ADMIN}=/usr/lib/oracle/11.2/client/; $ENV{ORACLE_HOME}=/usr/lib/oracle/11.2/client/; $ENV{LD_LIBRARY_PATH}=/usr/lib/oracle/11.2/client/lib/; I think a 'better practice' would be to put the 'stuff

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus(oracle)

2012-01-06 Thread Ahmed Munir
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 r...@i.frys.com Subject: Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle) To: Asterisk Users

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus(oracle)

2012-01-06 Thread Danny Nicholas
9:33 AM To: asterisk-users@lists.digium.com 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

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus(oracle)

2012-01-06 Thread Ron Bergin
: Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle) To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Message-ID: 69ecf8ff3230bc206837478422f97aad.squir...@webmail.i.frys.com Content-Type: text/plain;charset=iso-8859-1

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus(oracle)

2012-01-06 Thread Dale Noll
On 01/06/2012 10:30 AM, Ron Bergin wrote: Add a BEGIN {...} block prior to the use statements and in there redirect STDERR to a file. This will aloow you to capture compilation errors You should also add some debugging statements at key points in the script. Then run the script and review

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus(oracle)

2012-01-05 Thread Ahmed Munir
da...@debsinc.com Subject: Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle) To: 'Asterisk Users Mailing List - Non-Commercial Discussion' asterisk-users@lists.digium.com Message-ID: 010101cccb0d$3fa6a140$bef3e3c0$@debsinc.com Content-Type: text/plain; charset=us-ascii

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle)

2012-01-05 Thread Ron Bergin
da...@debsinc.com Subject: Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle) To: 'Asterisk Users Mailing List - Non-Commercial Discussion' asterisk-users@lists.digium.com Message-ID: 00ca01cccb06$911e8300$b35b8900$@debsinc.com Content-Type: text/plain; charset=us

[asterisk-users] asterisk - AGI (perl) - sqlplus (oracle)

2012-01-04 Thread Ahmed Munir
Hi all, I'm trying to run an AGI in PERL which uses the module DBD-Oracle. Currently my AGI is working fine in my two servers but not in my other four servers. When I tried execute an AGI (as a user asterisk) in command line it works fine (even I also declare environmental variables in user

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle)

2012-01-04 Thread Danny Nicholas
- AGI (perl) - sqlplus (oracle) Hi all, I'm trying to run an AGI in PERL which uses the module DBD-Oracle. Currently my AGI is working fine in my two servers but not in my other four servers. When I tried execute an AGI (as a user asterisk) in command line it works fine (even I also declare

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle)

2012-01-04 Thread Ahmed Munir
-users] asterisk - AGI (perl) - sqlplus (oracle) To: 'Asterisk Users Mailing List - Non-Commercial Discussion' asterisk-users@lists.digium.com Message-ID: 00ca01cccb06$911e8300$b35b8900$@debsinc.com Content-Type: text/plain; charset=us-ascii The module probably isn't readable

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle)

2012-01-04 Thread Danny Nicholas
@lists.digium.com Subject: Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle) Hi, I installed the modules in asterisk user home directory with read and excitable permissions for asterisk but still my AGI not working. Please provide me other advise to resolve this issue. Date: Wed, 4 Jan

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle)

2012-01-04 Thread Steve Edwards
Un-top-posting... On Wed, 4 Jan 2012, Ahmed Munir wrote: I'm trying to run an AGI in PERL which uses the module DBD-Oracle. Currently my AGI is working fine in my two servers but not in my other four servers. When I tried execute an AGI (as a user asterisk) in command line it works fine

Re: [asterisk-users] asterisk - AGI (perl) - sqlplus (oracle)

2012-01-04 Thread LL
I guess this is a permissions issue. Make sure your agi script has execute permissions (755) and it belongs to asterisk:asterisk . for that you need: chmod 755 /var/lib/asterisk/agi-bin/agi-script-name.agi chown asterisk:asterisk /var/lib/asterisk/agi-bin/agi-script-name.agi Regards, LL