On 2015-12-08 Adam Thompson wrote:
And to use Oracle DB in perl you need the module named "DBI" and the so-called driver for Oracle in DBI: "DBD::Oracle".
If you can find those in "packages" instead of self-compiling, that helps. DBI comes standard in perl now I think?
At the very minimum, get perl from a repo like Adam says, and use cpan to build the modules. It's not hard and is pretty stable once you have your build environment setup.
My one recommendation against the default config in cpan is to turn *off* automatic recursive prerequisite building. That usually ends in disaster. I would have it report the prereq's, which it does on the build step, and then chase them down manually one by one. It doesn't take as long as you'd think.
If you need more tips, etc, I'm a (self-proclaimed!) perl expert, ask away; but I can't help you with Solaris specifics. But I feel your pain... back when I was AIX-only for 6 years I faced the exact same problems. And then linux came and made all the pain go away. :-) Well, almost all.
Yeesh:
# pkgadd -d http://get.opencsw.org/now pkgadd: ERROR: Failure occurred with http(s) negotiation: <Not a HTTP/1.1 server> pkgadd: ERROR: unable to download package datastream from < http://get.opencsw.org/now%3E.
Any thoughts? This was on Solaris 10.
On Tue, Dec 8, 2015 at 7:44 PM, Adam Thompson athompso@athompso.net wrote:
Also, on our Solaris 11 system:
$ ./testdb Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/site_perl/5.12/sun4-solaris-64int /usr/perl5/site_perl/5.12 /usr/perl5/vendor_perl/5.12/sun4-solaris-64int /usr/perl5/vendor_perl/5.12 /usr/perl5/5.12/lib/sun4-solaris-64int /usr/perl5/5.12/lib .) at ./testdb line 3. BEGIN failed--compilation aborted at ./testdb line 3.
So DBI does *not* come standard in Solaris 11 perl 5.12.
What should I try next?
On Thu, Dec 17, 2015 at 3:21 PM, Kevin McGregor kevin.a.mcgregor@gmail.com wrote:
On 2015-12-17 Kevin McGregor wrote:
So DBI does *not* come standard in Solaris 11 perl 5.12.
Doh.
Hmm, looks like you can get dbi, etc, the same place you get perl, opencsw:
pm_dbi 1.616,REV=2011.03.09 DBI: Database independent interface for Perl
pm_dbdoracle 1.23,REV=2010.02.16 Oracle database driver for the DBI module
That's all you should need.
this looks useful too: pm_datetime_format_oracle 0.06,REV=2012.07.19 DateTime-Format-Oracle: Parse and format Oracle dates and timestamps
http://www.opencsw.org/manual/for-administrators/setup-behind-proxy.html#set...
Or just download the file locally, scp it to the Solaris 10 box and run pkgadd -d <fully-qualified-path-to-file>.
Meanwhile, on Solaris 11.3 with the Support Tools Bundle installed,
root@t4-1:~# locate DBI.pm /usr/lib/ocm/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/Apache/AuthDBI.pm /usr/lib/ocm/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/Apache/DBI.pm /usr/lib/ocm/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBI.pm /usr/lib/ocm/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/Bundle/DBI.pm
but otherwise you can install it in Solaris 11 (11.3, anyway, should work in 11.2 also) with "pkg install pkg:/library/perl-5/database"
-Adam
On 15-12-17 03:21 PM, Kevin McGregor wrote:
Well, progress.
Initially I got this: $ ./testdb Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/site_perl/5.12/sun4-solaris-64int / usr/perl5/site_perl/5.12 /usr/perl5/vendor_perl/5.12/sun4-solaris-64int /usr/perl5/vendor_ perl/5.12 /usr/perl5/5.12/lib/sun4-solaris-64int /usr/perl5/5.12/lib .) at ./testdb line 3 . BEGIN failed--compilation aborted at ./testdb line 3.
Then after pkg install pkg:/library/perl-5/database (worked!), I now get # ./testdb install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/perl5/site_perl/5.12/sun4-solaris-64int /usr/perl5/site_perl/5.12 /usr/perl5/vendor_perl/5.12/sun4-solaris-64int /usr/perl5/vendor_perl/5.12 /usr/perl5/5.12/lib/sun4-solaris-64int /usr/perl5/5.12/lib .) at (eval 3) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge. at ./testdb line 12
Is there a "DBD::mysql" package I can install? I tried pkg search -r dbd pkg search -r mysql but I didn't see anything related to perl *and* mysql.
Is the stuff on OpenCSW compatible with the Oracle-supplied perl? Or will I need to install perl/DBI/DBD all from OpenCSW?
On Thu, Dec 17, 2015 at 4:11 PM, Adam Thompson athompso@athompso.net wrote:
Oh, right -- also, on Solaris 10 # pkgadd -x ourproxy:3128 -d http://get.opencsw.org/now pkgadd: ERROR: Failure occurred with http(s) negotiation: <Not a HTTP/1.1 server> pkgadd: ERROR: unable to download package datastream from < http://get.opencsw.org/now%3E.
I think that's a problem with squid. I'll try downloading it/installing manually.
On Fri, Dec 18, 2015 at 8:41 AM, Kevin McGregor kevin.a.mcgregor@gmail.com wrote:
I'm downloading OpenCSW from a mirror to a local Linux box with Internet access. None of the Solaris boxes have Internet access, so I can't bootstrap it that way. And of course I can't use rsync, so wget. Sigh. I hope it works, after all this.
On Fri, Dec 18, 2015 at 9:03 AM, Kevin McGregor kevin.a.mcgregor@gmail.com wrote:
On 2015-12-18 Kevin McGregor wrote:
Is there a "DBD::mysql" package I can install? I tried
Did my last email come through with the opencsw pacakge names? Looking at the list I see mysql is called this:
pm_dbd_mysql 4.024,REV=2013.10.14 DBD-mysql: MySQL driver for the Perl5 Database Interface (DBI)
"pm" appears to be the prefix for "perl module" and the dbi drivers are all called "dbd_something".
So that's the one you need for mysql in perl DBI. My previous email gives you the one for oracle DB.
The complete list is here: https://www.opencsw.org/get-it/packages/
-
Adam Thompson -
Kevin McGregor -
Trevor Cordes