Re: perl-DBD-SQLite*
Okay perfect. This is exactly what I wanted to know.
Thanks to Eason and Dennis for actually digging into the code!!
Appreciate it!
On Wed, Mar 9, 2016 at 5:36 AM, Zhang, Yi (Eason) <yi.zh...@esgyn.cn> wrote:
> Hi,
>
> In my VM environment there’s only perl-DBD-SQLite installed, both ‘sqgen’
> and Trafodion can work well, so I think the package perl-DBD-SQLite2 is not
> needed.
>
> Thanks,
> Eason
>
>
> From: "D. Markt"
> Reply-To: "user@trafodion.incubator.apache.org"
> Date: Wednesday, March 9, 2016 at 16:03
> To: "user@trafodion.incubator.apache.org"
> Subject: RE: perl-DBD-SQLite*
>
> Hi,
>
>
>
> I’m not a yum expert, but could the ‘*’ actually be part of a glob
> expression? For example on a CentOS 6.5 node I did:
>
>
>
> yum list installed "perl-DBD-SQLite*"
>
> …
>
> perl-DBD-SQLite.x86_64
> 1.27-3.el6@base
>
> perl-DBD-SQLite2.x86_64
> 0.33-12.el6 @epel
>
>
>
> Then again without the ‘*’:
>
>
>
> yum list installed "perl-DBD-SQLite"
>
> …
>
> perl-DBD-SQLite.x86_64
> 1.27-3.el6@base
>
>
>
> So the ‘*’ was likely used to install both packages, but from an
> Internet search it looks like there is a SQLite2 but one site indicates it
> has been deprecated and that SQLite is actually version 3 of the software
> (and that was circa 2009). I did find several files under my somewhat
> dated source tree that have the common Perl suffix of “.pl”. Many of those
> files are under the local_hadoop directory so aren’t Trafodion files given
> a quick look. Looking for the SQLite term that one site mentioned I see:
>
>
>
> ./core/sqf/sql/scripts/gensq.pl:use DBI;
>
> ./core/sqf/sql/scripts/gensq.pl:$DBH =
> DBI->connect("dbi:SQLite:dbname=sqconfig.db","","",$dbargs);
>
>
>
> So I appears this is used by sqgen, and it doesn’t specifically ask for
> SQLite2. Looking at the sqconfig.db from a today’s install I see:
>
>
>
> more sqconfig.db
>
> SQLite format 3
>
> …
>
>
>
> So if you install SQLite on RHEL 7.1, and see the generated sqconfig.db
> file has the same “SQLite format 3” (or higher), which I’m sure it will,
> then that should be enough. Of course it’s always possible some other
> component is using SQLite but my recollection was sqgen was the one
> component that was using the package. If other Perl scripts are using
> SQLite2 then they should probably be enhanced to use the newer version
> anyway.
>
>
>
> Regards,
>
> Dennis
>
>
>
> *From:* Amanda Moran [mailto:amanda.mo...@esgyn.com
> <amanda.mo...@esgyn.com>]
> *Sent:* Tuesday, March 08, 2016 6:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: perl-DBD-SQLite*
>
>
>
> Yes, I totally agree with the way to test.
>
>
>
> I am waiting on some changes to be merged and I will do just that.
>
>
>
> Just was hoping, if anyone had any words of wisdom before then!
>
>
>
> Thanks!
>
>
>
> On Tue, Mar 8, 2016 at 3:59 PM, Carol Pearson <carol.pearson...@gmail.com>
> wrote:
>
> Hi Amanda,
>
>
>
> At one point, I know we used SQLite for some internal configuration
> information, but I've lost track of whether or not we still do. Otherwise,
> SQLite would be needed for a dependency, and at that point and we'd have to
> track that one down to see what's really needed.
>
>
>
> If we don't install the full set, does the install complete and does
> Trafodion start? No guarantees that we don't have a problem if it installs
> and starts because the dependency could be later in the execution path.
> But if install/start fails, at least that tells us that the dependency
> matters and points us to at least one place *where* something cares.
>
>
>
> -Carol P.
>
>
> -------------------
>
> Email:carol.pearson...@gmail.com
>
> Twitter: @CarolP222
>
> ---
>
>
>
> On Tue, Mar 8, 2016 at 2:55 PM, Amanda Moran <amanda.mo...@esgyn.com>
> wrote:
>
> Hi there All-
>
>
>
> In the current installer we try to install this package: perl-DBD-SQLite*
> (note the *), on RHEL 6 and Centos 6 this has worked fine.
>
>
>
> I am testing the installer on RHEL 7.1 and it is not able to
> install perl-DBD-SQLite* only perl-DBD-SQLite.
>
>
>
> Is just installing perl-DBD-SQLite going to be an issue?
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
--
Thanks,
Amanda Moran
RE: perl-DBD-SQLite*
Hi,
I’m not a yum expert, but could the ‘*’ actually be part of a glob
expression? For example on a CentOS 6.5 node I did:
yum list installed "perl-DBD-SQLite*"
…
perl-DBD-SQLite.x86_64 1.27-3.el6
@base
perl-DBD-SQLite2.x86_64
0.33-12.el6 @epel
Then again without the ‘*’:
yum list installed "perl-DBD-SQLite"
…
perl-DBD-SQLite.x86_64 1.27-3.el6
@base
So the ‘*’ was likely used to install both packages, but from an Internet
search it looks like there is a SQLite2 but one site indicates it has been
deprecated and that SQLite is actually version 3 of the software (and that was
circa 2009). I did find several files under my somewhat dated source tree that
have the common Perl suffix of “.pl”. Many of those files are under the
local_hadoop directory so aren’t Trafodion files given a quick look. Looking
for the SQLite term that one site mentioned I see:
./core/sqf/sql/scripts/gensq.pl:use DBI;
./core/sqf/sql/scripts/gensq.pl:$DBH =
DBI->connect("dbi:SQLite:dbname=sqconfig.db","","",$dbargs);
So I appears this is used by sqgen, and it doesn’t specifically ask for
SQLite2. Looking at the sqconfig.db from a today’s install I see:
more sqconfig.db
SQLite format 3
…
So if you install SQLite on RHEL 7.1, and see the generated sqconfig.db file
has the same “SQLite format 3” (or higher), which I’m sure it will, then that
should be enough. Of course it’s always possible some other component is using
SQLite but my recollection was sqgen was the one component that was using the
package. If other Perl scripts are using SQLite2 then they should probably be
enhanced to use the newer version anyway.
Regards,
Dennis
From: Amanda Moran [mailto:amanda.mo...@esgyn.com]
Sent: Tuesday, March 08, 2016 6:03 PM
To: user@trafodion.incubator.apache.org
Subject: Re: perl-DBD-SQLite*
Yes, I totally agree with the way to test.
I am waiting on some changes to be merged and I will do just that.
Just was hoping, if anyone had any words of wisdom before then!
Thanks!
On Tue, Mar 8, 2016 at 3:59 PM, Carol Pearson <carol.pearson...@gmail.com
<mailto:carol.pearson...@gmail.com> > wrote:
Hi Amanda,
At one point, I know we used SQLite for some internal configuration
information, but I've lost track of whether or not we still do. Otherwise,
SQLite would be needed for a dependency, and at that point and we'd have to
track that one down to see what's really needed.
If we don't install the full set, does the install complete and does Trafodion
start? No guarantees that we don't have a problem if it installs and starts
because the dependency could be later in the execution path. But if
install/start fails, at least that tells us that the dependency matters and
points us to at least one place *where* something cares.
-Carol P.
---
Email:carol.pearson...@gmail.com <mailto:carol.pearson...@gmail.com>
Twitter: @CarolP222
---
On Tue, Mar 8, 2016 at 2:55 PM, Amanda Moran <amanda.mo...@esgyn.com
<mailto:amanda.mo...@esgyn.com> > wrote:
Hi there All-
In the current installer we try to install this package: perl-DBD-SQLite* (note
the *), on RHEL 6 and Centos 6 this has worked fine.
I am testing the installer on RHEL 7.1 and it is not able to install
perl-DBD-SQLite* only perl-DBD-SQLite.
Is just installing perl-DBD-SQLite going to be an issue?
Thanks!
--
Thanks,
Amanda Moran
--
Thanks,
Amanda Moran
Re: perl-DBD-SQLite*
Hi Amanda, At one point, I know we used SQLite for some internal configuration information, but I've lost track of whether or not we still do. Otherwise, SQLite would be needed for a dependency, and at that point and we'd have to track that one down to see what's really needed. If we don't install the full set, does the install complete and does Trafodion start? No guarantees that we don't have a problem if it installs and starts because the dependency could be later in the execution path. But if install/start fails, at least that tells us that the dependency matters and points us to at least one place *where* something cares. -Carol P. --- Email:carol.pearson...@gmail.com Twitter: @CarolP222 --- On Tue, Mar 8, 2016 at 2:55 PM, Amanda Moran <amanda.mo...@esgyn.com> wrote: > Hi there All- > > In the current installer we try to install this package: perl-DBD-SQLite* > (note the *), on RHEL 6 and Centos 6 this has worked fine. > > I am testing the installer on RHEL 7.1 and it is not able to install > perl-DBD-SQLite* > only perl-DBD-SQLite. > > Is just installing perl-DBD-SQLite going to be an issue? > > Thanks! > > -- > Thanks, > > Amanda Moran >
