RE: Unable to install DBD:Sybase-1.08 on my AIX 5.2 server with Perl 5.8.0 DBI-1.43
I did the upgrade to DBI-1.604 and this time DBD:Sybase-1.08 fails during make with a different error but an error non the less... Any help would be greatly appreciated... The output from the make command is as follows; S_SCUDA_903:/usr/src/DBD-Sybase-1.08 make cp dbd-sybase.pod blib/lib/DBD/dbd-sybase.pod cp Sybase.pm blib/lib/DBD/Sybase.pm /usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists(NAME = DBD::Sybase, DL_FUNCS = { }, FUNCLIST = [], DL_VARS = []);' /usr/bin/perl -p -e s/~DRIVER~/Sybase/g /usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/Driver.xst Sybase.xsi /usr/bin/perl /usr/opt/perl5/lib/5.8.0/ExtUtils/xsubpp -typemap /usr/opt/perl5/lib/5.8.0/ExtUtils/typemap Sybase.xs Sybase.xsc mv Sybas e.xsc Sybase.c cc_r -c -I/usr/local/include -DNO_BLK=1 -I/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POS IX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\1.08\ -DXS_VERSION=\ 1.08\ -I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE Sybase.c 1506-507 (W) No licenses available. Contact your program supplier to add additional users. Compilation will proceed shortly. cc_r -c -I/usr/local/include -DNO_BLK=1 -I/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POS IX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\1.08\ -DXS_VERSION=\ 1.08\ -I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE dbdimp.c 1506-507 (W) No licenses available. Contact your program supplier to add additional users. Compilation will proceed shortly. dbdimp.c, line 800.23: 1506-045 (S) Undeclared identifier BLK_VERSION_150. dbdimp.c, line 804.23: 1506-045 (S) Undeclared identifier BLK_VERSION_125. dbdimp.c, line 808.23: 1506-045 (S) Undeclared identifier BLK_VERSION_120. make: 1254-004 The error code from the last command is 1. Stop. Martin -Original Message- From: Martin Mann [mailto:[EMAIL PROTECTED] Sent: 13 June 2008 13:16 To: dbi-users@perl.org Subject: Unable to install DBD:Sybase-1.08 on my AIX 5.2 server with Perl 5.8.0 DBI-1.43 I have installed freetds-0.82 successfully to enable installing this and have configured the connection and it tests OK but when I get to the DBD:Sybase I run into problems... with the export of SYBASE=/usr/local the perl Makefile.PL works but when I run the make I get the following; usr/src/DBD-Sybase-1.08 make cc_r -c -I/usr/local/include -DNO_BLK=1 -I/usr/opt/perl5/lib/ site_perl/5.8.0/aix-thread-multi/auto/DBI -D_ALL_SOURCE - D_ANSI_C_SOURCE -D_POS IX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN - DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -O-DVERSION= \1.08\ -DXS_VERSION=\ 1.08\ -I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE Sybase.c 1506-507 (W) No licenses available. Contact your program supplier to add additional users. Compilation will proceed shortly. /usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ Driver_xst.h, line 14.17: 1506-045 (S) Undeclared identifier my_perl. /usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ Driver_xst.h, line 57.9: 1506-045 (S) Undeclared identifier my_perl. /usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/auto/DBI/ Driver_xst.h, line 78.5: 1506-045 (S) Undeclared identifier my_perl. make: 1254-004 The error code from the last command is 1. Any ideas? Is there a minimum level of DBI itself required for DBD::Sybase-1.08? I'll see if I can get DBI upped to 1.604 in the mean time but any comments appreciated if this as known issue... Martin This e-mail and its attachments are confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, forward, copy or take any action in respect of this email or any attachments. If you have received this e-mail in error, please delete it and notify the sender. While OTM have taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage, which you may sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment. Opus Trust Marketing Limited, 133 Scudamore Road, Braunstone Frith Industrial Estate, Leicester, LE3 1UQ Registered in England, Number 3829642
Re: perl out of memory error
Dear Satish, On Sun, Jun 15, 2008 at 2:53 AM, satish dane [EMAIL PROTECTED] wrote: I am using DBI 1.2 and DBD::oracle 1.58 version and 5.8perl version. the error is coming after some time.that is after exiting from script it is giving the error. an dplease tell about memory leak. Well, your version of DBI is antique - version 1.20 was released in Aug 2001, and 1.29 in Jul 2002. I am not sure that your version of DBD::Oracle is current either. If your version of Perl is 5.8.0, that too is archaic (Jul 2002); if it is 5.8.8, you are OK (Jan 2006), though you should review why 5.10.0 is not an option. Given that you are not using DBD::Informix, I am not able to offer a lot more help. The memory leak test in DBD::Informix::TestHarness could probably be adapted to work with DBD::Oracle - it basically invokes a function and monitors how the Perl process grows, and the content of the function doesn't actually matter, so it could exercise DBD::Oracle as well as DBD::Informix. Be aware that the options to 'ps' work on Solaris and may not work on your platform. Note that you've not mentioned the platform you are running on (operating system, hardware), nor the version of Oracle that you are using -- if you were using DBD::Informix, I would be after you for that information too. When I say which versions of everything, everything most definitely includes the operating system and the DBMS access package (OCI for Oracle; ESQL/C for Informix). It isn't a bad idea to include the C compiler, either. Further discussion of this must be sent to [EMAIL PROTECTED] However, the first instructions given will be 'upgrade to current versions' -- people have very limited interest in debugging ancient versions of the software. On Sun, 15 Jun 2008 Jonathan Leffler wrote : On Sat, Jun 14, 2008 at 3:14 AM, satish dane [EMAIL PROTECTED] wrote: i am trying to run the perl script which searches the data inside DAtabase and use it to run other utility. i am getting an error :Out of Memory I am not able to find the root cause of this error. please try to help me out of this because from last 4 days i am struggling to debug it. Are you using DBI and DBD::Informix? If so, which versions of everything? Does the out of memory error occur immediately, or after some time? Are you using shared memory connections? Can you try with a different connection type (eg olsoctcp or oltlitcp) and see whether that fixes the problem? If so, we can probably diagnose an issue with INFORMIXSHMBASE. Alternatively, there is a mechanism in DBD::Informix::TestHarness for checking whether there's a memory leak in a Perl script -- you could use that to see whether there's a memory leak. -- Jonathan Leffler [EMAIL PROTECTED] #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.
Re: Unable to install DBD:Sybase-1.08 on my AIX 5.2 server with Perl 5.8.0 DBI-1.43
Martin Mann wrote: I did the upgrade to DBI-1.604 and this time DBD:Sybase-1.08 fails during make with a different error but an error non the less... Any help would be greatly appreciated... dbdimp.c, line 800.23: 1506-045 (S) Undeclared identifier BLK_VERSION_150. dbdimp.c, line 804.23: 1506-045 (S) Undeclared identifier BLK_VERSION_125. dbdimp.c, line 808.23: 1506-045 (S) Undeclared identifier BLK_VERSION_120. make: 1254-004 The error code from the last command is 1. Those symbols are missing from the FreeTDS include files. Edit dbdimp.c, and somewhere near the top add: #define BLK_VERSION_150 BLK_VERSION_100 #define BLK_VERSION_125 BLK_VERSION_100 #define BLK_VERSION_120 BLK_VERSION_100 Michael -- Michael Peppler - Peppler Consulting SaRL [EMAIL PROTECTED] - http://www.peppler.org Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html