DBI/DBD question
I am taking over the Perl stuff for someone that was laid off. The previous guy built Perl with CGI, DBI and DBD modules for use with a Informix database and IBM IHS web server. He then tar'd it all up and copied it to a different server and where thing do not all working. I know, sounds obvious. There are some scripts that are interactive or run by Unix CRON scheduler on the system and others that are web pages used for reporting. The interactive stuff works fine on the new system, but the web pages fail. The error is: Software error: install_driver(Informix) failed: Can't load '/home/users/polling/perl/lib/site_perl/5.8.8/sun4-solaris-64/auto/DBD/Informix/Informix.so' for module DBD::Informix: ld.so.1: SdtQuery.pl: fatal: libifsql.so: open failed: No such file or directory at /home/users/polling/perl/lib/5.8.8/sun4-solaris-64/DynaLoader.pm line 230. at (eval 32) line 3 Compilation failed in require at (eval 32) line 3. Perhaps a required shared library or dll isn't installed where expected at /home/users/polling/SDT-2.0/SDT/SDTDB.pm line 443 This is Perl 5.8.8 running on Solaris 2.8 on V490 Hardware. All is 64 bit. I am considering rebuilding these modules. I have the source for DBI and DBD but don't seem to have the source for CGI. I figured I would check with the pros before I start doing things. Any ideas or suggestions? Thank you for your time! Royce
Re: DBI/DBD question
Am 27.04.2010 um 20:17 schrieb Royce Miller: install_driver(Informix) failed: Can't load '/home/users/polling/perl/lib/site_perl/5.8.8/sun4-solaris-64/auto/DBD/Informix/Informix.so' for module DBD::Informix: ld.so.1: SdtQuery.pl: fatal: libifsql.so: open failed: No such file or directory at /home/users/polling/perl/lib/5.8.8/sun4-solaris-64/DynaLoader.pm line 230. at (eval 32) line 3 Compilation failed in require at (eval 32) line 3. Perhaps a required shared library or dll isn't installed where expected at /home/users/polling/SDT-2.0/SDT/SDTDB.pm line 443 This is the error: Perhaps a required shared library or dll isn't installed where expected. You need to install DBD::Informix. -- Michael.Ludwig (#) XING.com
Re: DBI/DBD question
Royce Miller wrote: I am taking over the Perl stuff for someone that was laid off. The previous guy built Perl with CGI, DBI and DBD modules for use with a Informix database and IBM IHS web server. He then tar'd it all up and copied it to a different server and where thing do not all working. I know, sounds obvious. There are some scripts that are interactive or run by Unix CRON scheduler on the system and others that are web pages used for reporting. The interactive stuff works fine on the new system, but the web pages fail. The error is: Software error: install_driver(Informix) failed: Can't load '/home/users/polling/perl/lib/site_perl/5.8.8/sun4-solaris-64/auto/DBD/Informix/Informix.so' for module DBD::Informix: ld.so.1: SdtQuery.pl: fatal: libifsql.so: open failed: No such file or directory at /home/users/polling/perl/lib/5.8.8/sun4-solaris-64/DynaLoader.pm line 230. at (eval 32) line 3 Compilation failed in require at (eval 32) line 3. You do not have the correct Informix binaryes install, or they are not installed or you are not pointing to them in the ENV. I do not think it has anything to do with CGI. Perhaps a required shared library or dll isn't installed where expected at /home/users/polling/SDT-2.0/SDT/SDTDB.pm line 443 This is Perl 5.8.8 running on Solaris 2.8 on V490 Hardware. All is 64 bit. I am considering rebuilding these modules. I have the source for DBI and DBD but don't seem to have the source for CGI. I figured I would check with the pros before I start doing things. Any ideas or suggestions? Thank you for your time! Royce
Re: DBI/DBD question
On Tue, Apr 27, 2010 at 2:17 PM, Royce Miller royce...@pacbell.net wrote: The interactive stuff works fine on the new system, but the web pages fail. Sounds like the informix client libs are either not accessible to the apache/cgi user, or the environment variables pointing to them are missing when running under cgi. allan -- The truth is an offense, but not a sin
(Fwd) Problems inserting into a CLOB field type using DBI PERL
- Forwarded message from Arshad Mahmood arshad.mahm...@manchester.ac.uk - Date: Mon, 26 Apr 2010 12:52:41 +0100 From: Arshad Mahmood arshad.mahm...@manchester.ac.uk To: Tim Bunce tim.bu...@pobox.com Subject: Problems inserting into a CLOB field type using DBI PERL X-Mailer: Oracle Connector for Outlook 10.1.3.0.10 100801 (11.0.5510) Hi Tim, I am doing some programming on a red hat linux env using DBI with perl and trying to insert into an Oracle database and particularly a CLOB field. The perl version is perl, v5.8.8 built for x86_64-linux-thread-multi The dbi version I am using is most likely the latest version of DBI The oracle database I am using is 11g The CLOB field that I am inserting into is called request_notes My code is below; $Sql3 = INSERT into bas_aba_immediaterequests (request_id,submitter,create_date,last_modified_by,modified_date,status,short_description,requesters_name,requesters_email_address,managers_name,managers_email_address,roles,software,request_status_,user_id,tasks,ip_address,facultyschool,other,get_details_live_link_only,documents_oracle_financials_on,budgetcode_oracle_financials_o,responsibility_oracle_financia,responsibility_give_details_or,receive_reports_oracle_financi,ctrro_oracle_financials_only,desktop_set_up_complete,atacf,atacs,cc,fctn,ipn,req,sameas,fcas,please_give_details,location,training_complete,fwall_complete,usertel,mgrtel,checkrlhrauth1,checkrlhrauth2,wfifu,csc,empno,purchasingunit,jobtitle,brrother,team,repbusinessarea,request_notes) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); $Statement3 = $Dbh-prepare($Sql3) or die Can't Prepare:$DBI::errstr\n; Then I do the bind for each field The bind code for the CLOB field is: $Statement3-bind_param(53, $Data, {ora_type = ORA_CLOB, ora_field = 'request_notes'}) $Statement3-execute() || Cannot Execute SQL Statement insert_sql into its_servicedesk correspond: $DBI::errstr\n; I get the following error in the log files [Mon Apr 26 12:19:04 2010] [error] [client 130.88.157.213] Can't bind unknown placeholder ':p53' (53) Can you please assist as ive been stuck on this problem for quite a while now.. Many Thanks Ash - End forwarded message -
Re: [DBI-Users] (Fwd) Problems inserting into a CLOB field type using DBI PERL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hello ash Tim Bunce wrote: [...] $Sql3 = INSERT into bas_aba_immediaterequests (request_id,submitter,create_date,last_modified_by,modified_date,status,short_description,requesters_name,requesters_email_address,managers_name,managers_email_address,roles,software,request_status_,user_id,tasks,ip_address,facultyschool,other,get_details_live_link_only,documents_oracle_financials_on,budgetcode_oracle_financials_o,responsibility_oracle_financia,responsibility_give_details_or,receive_reports_oracle_financi,ctrro_oracle_financials_only,desktop_set_up_complete,atacf,atacs,cc,fctn,ipn,req,sameas,fcas,please_give_details,location,training_complete,fwall_complete,usertel,mgrtel,checkrlhrauth1,checkrlhrauth2,wfifu,csc,empno,purchasingunit,jobtitle,brrother,team,repbusinessarea,request_notes) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); $Statement3 = $Dbh-prepare($Sql3) or die Can't Prepare:$DBI::errstr\n; [...] The bind code for the CLOB field is: $Statement3-bind_param(53, $Data, {ora_type = ORA_CLOB, ora_field = 'request_notes'}) [...] [Mon Apr 26 12:19:04 2010] [error] [client 130.88.157.213] Can't bind unknown placeholder ':p53' (53) the sql statement contains only 52 columns and 52 placeholders. request_notes is number 52. greetings hermann -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkvYKxwACgkQpZ4QdpzGMxwd+ACfY7u9pL4rSjgIL6xnawh2JShB YLwAoMYua1nFO1LeyYgY7rQ4HkyO4GA7 =RdAF -END PGP SIGNATURE-
Re: (Fwd) Problems inserting into a CLOB field type using DBI PERL
Nothing to DBI or DBD oracle Check your SQL statement you have only 52 '?' but you are trying to bind field 53 cheers John Scoles Tim Bunce wrote: - Forwarded message from Arshad Mahmood arshad.mahm...@manchester.ac.uk - Date: Mon, 26 Apr 2010 12:52:41 +0100 From: Arshad Mahmood arshad.mahm...@manchester.ac.uk To: Tim Bunce tim.bu...@pobox.com Subject: Problems inserting into a CLOB field type using DBI PERL X-Mailer: Oracle Connector for Outlook 10.1.3.0.10 100801 (11.0.5510) Hi Tim, I am doing some programming on a red hat linux env using DBI with perl and trying to insert into an Oracle database and particularly a CLOB field. The perl version is perl, v5.8.8 built for x86_64-linux-thread-multi The dbi version I am using is most likely the latest version of DBI The oracle database I am using is 11g The CLOB field that I am inserting into is called request_notes My code is below; $Sql3 = INSERT into bas_aba_immediaterequests (request_id,submitter,create_date,last_modified_by,modified_date,status,short_description,requesters_name,requesters_email_address,managers_name,managers_email_address,roles,software,request_status_,user_id,tasks,ip_address,facultyschool,other,get_details_live_link_only,documents_oracle_financials_on,budgetcode_oracle_financials_o,responsibility_oracle_financia,responsibility_give_details_or,receive_reports_oracle_financi,ctrro_oracle_financials_only,desktop_set_up_complete,atacf,atacs,cc,fctn,ipn,req,sameas,fcas,please_give_details,location,training_complete,fwall_complete,usertel,mgrtel,checkrlhrauth1,checkrlhrauth2,wfifu,csc,empno,purchasingunit,jobtitle,brrother,team,repbusinessarea,request_notes) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); $Statement3 = $Dbh-prepare($Sql3) or die Can't Prepare:$DBI::errstr\n; Then I do the bind for each field The bind code for the CLOB field is: $Statement3-bind_param(53, $Data, {ora_type = ORA_CLOB, ora_field = 'request_notes'}) $Statement3-execute() || Cannot Execute SQL Statement insert_sql into its_servicedesk correspond: $DBI::errstr\n; I get the following error in the log files [Mon Apr 26 12:19:04 2010] [error] [client 130.88.157.213] Can't bind unknown placeholder ':p53' (53) Can you please assist as ive been stuck on this problem for quite a while now.. Many Thanks Ash - End forwarded message -
Re: DBI/DBD question
On Tue, Apr 27, 2010 at 11:17 AM, Royce Miller royce...@pacbell.net wrote: I am taking over the Perl stuff for someone that was laid off. The previous guy built Perl with CGI, DBI and DBD modules for use with a Informix database and IBM IHS web server. He then tar'd it all up and copied it to a different server and where thing do not all working. I know, sounds obvious. There are some scripts that are interactive or run by Unix CRON scheduler on the system and others that are web pages used for reporting. The interactive stuff works fine on the new system, but the web pages fail. The error is: Software error: install_driver(Informix) failed: Can't load '/home/users/polling/perl/lib/site_perl/5.8.8/sun4-solaris-64/auto/DBD/Informix/Informix.so' for module DBD::Informix: ld.so.1: SdtQuery.pl: fatal: libifsql.so: open failed: No such file or directory at /home/users/polling/perl/lib/5.8.8/sun4-solaris-64/DynaLoader.pm line 230. at (eval 32) line 3 Compilation failed in require at (eval 32) line 3. Perhaps a required shared library or dll isn't installed where expected at /home/users/polling/SDT-2.0/SDT/SDTDB.pm line 443 This is Perl 5.8.8 running on Solaris 2.8 on V490 Hardware. All is 64 bit. I am considering rebuilding these modules. I have the source for DBI and DBD but don't seem to have the source for CGI. I figured I would check with the pros before I start doing things. Any ideas or suggestions? Thank you for your time! Royce Dear Royce, This is all about Informix and nothing to do with CGI per se - as others have said. In future, please include DBD::Informix in the subject line - it helps me spot that the question is about Informix. Or copy the email address dbd.infor...@gmail.com with the request too. This information is in the README file for DBD::Informix. You should find under one of the DBD/Informix directories (probably /home/users/polling/perl/lib/site_perl/5.10.1/sun4-solaris-64/DBD/Informix) you should a file Defaults.pm. In there, you should find a value for INFORMIXDIR. sub default_INFORMIXDIR { return '/usr/informix/11.50.FC3'; } sub default_INFORMIXSERVER { return 'black_19'; } This is from my machine (Solaris 10, Perl 5.10.1). You need to ensure that the LD_LIBRARY_PATH (or LD_LIBRARY_PATH_64) includes the directories: $INFORMIXDIR/lib $INFORMIXDIR/lib/esql If the specified directory does not exist, then you need to review what to do next. Options include (1) creating a symlink at the official location pointing to the current in-service $INFORMIXDIR, (2) poking around the ld.so.1 configuration with crle (intuitive name!) to add Informix directories to the system list of directories, or (3) rebuilding DBD::Informix to use the new location of $INFORMIXDIR. Option (3) may be the 'best' solution. You can also build DBD::Informix with the environment variable DBD_INFORMIX_RELOCATABLE_INFORMIXDIR set to 1 or yes or anything else that Perl will evaluate as 'true' (so not empty, nor 0). This means that the libraries will be linked solely via the LD_LIBRARY_PATH or crle settings - rather than having a path built in. This is more typically a nuisance (especially in contexts such as web servers - because web servers reset their environment completely and zap the inherited value for LD_LIBRARY_PATH) and is not the default behaviour. -- Jonathan Leffler jonathan.leff...@gmail.com #include disclaimer.h Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org Blessed are we who can laugh at ourselves, for we shall never cease to be amused.
centos perl-DBD:Oracle
What are the steps to install perl-DBD:Oracle on a centos 5 server? I have the following oracle rpm's installed rpm -qa | grep oracle oracle-instantclient11.2-odbc-11.2.0.1.0-1 oracle-instantclient-sqlplus-10.2.0.3-1 oracle-instantclient-basic-10.2.0.3-1 oracle-instantclient11.2-basic-11.2.0.1.0-1 oracle-instantclient11.2-devel-11.2.0.1.0-1 oracle-instantclient-devel-10.2.0.3-1 oracle-instantclient-jdbc-10.2.0.3-1 when I try to install the following, I get rpm -i perl-DBD-Oracle-1.19-1.el5.i386.rpm warning: perl-DBD-Oracle-1.19-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e42d547b error: Failed dependencies: libclntsh.so.10.1 is needed by perl-DBD-Oracle-1.19-1.el5.i386 libnnz10.so is needed by perl-DBD-Oracle-1.19-1.el5.i386 libocci.so.10.1 is needed by perl-DBD-Oracle-1.19-1.el5.i386 libociei.so is needed by perl-DBD-Oracle-1.19-1.el5.i386 libocijdbc10.so is needed by perl-DBD-Oracle-1.19-1.el5.i386 echo $LD_LIBRARY_PATH /usr/lib/oracle/10.2.0.3/client/lib
how to post
How do I post a question to this forum? Thanks, Pam Wampler Senior Oracle Database Administrator Advanced Call Center Technologies, LLC. 3035 Boones Creek Road Johnson City, TN 37615 Office: 423-283-5020 Cell: 423-426-6305 pwamp...@acttoday.com
Re: how to post
On Wed, 28 Apr 2010 22:11:42 -0400 Pam Wampler pwamp...@acttoday.com wrote: How do I post a question to this forum? Hi, Maybe a read of this, http://www.catb.org/~esr/faqs/smart-questions.html would be a good start Read some of the archives, http://www.mail-archive.com/dbi-users@perl.org to get the idea of what people ask, and how. Owen
Re: how to post
Hi Pam, Depending on the nature of your question you might need to include additional information like: - perl interpreter version (perl -v perhaps even perl -V) - Operating system and platform (uname -a on Unix) - DBI version, (perl -MDBI -e 'print $DBI::VERSION\n') - DBD::Oracle version (perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION\n') - Version of Oracle drivers jonasbn -- AIM: BjonasN Gtalk: jona...@gmail.com ICQ: 62401545 MSN: jona...@io.dk twitter: jonasbn blog: http://e-diot.dk/ On 29/04/2010, at 04.11, Pam Wampler wrote: How do I post a question to this forum? Thanks, Pam Wampler Senior Oracle Database Administrator Advanced Call Center Technologies, LLC. 3035 Boones Creek Road Johnson City, TN 37615 Office: 423-283-5020 Cell: 423-426-6305 pwamp...@acttoday.com