[gentoo-user] How to emerge bugzilla w/ postgresql

[gentoo-user] How to emerge bugzilla w/ postgresql

[Richard Broersma Jr]

I am creating a new gentoo server, and I am in the handbook section to specify USE variables.
No matter how I errange my USE variable in the make.conf,

emerge --update --pretend bugzilla  -- wants to use mysql

[ebuild  N    ] dev-db/mysql-4.1.20
[ebuild  N    ] dev-perl/DBD-mysql-2.9007

...

USE="server symlink bugzilla sshd postgresql -mysql -mysqli postfix -X -xorg -berkdb -kde -gnome
-metacity"

Is there a way to override this selection and have postgresql and DBD-pg installed instead?

Any ideas?

Regards,

Richard Broersma Jr.
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] How to emerge bugzilla w/ postgresql

[kashani]

Richard Broersma Jr wrote:
> I am creating a new gentoo server, and I am in the handbook section to specify USE variables.
> No matter how I errange my USE variable in the make.conf,
> 
> emerge --update --pretend bugzilla  -- wants to use mysql
> 
> [ebuild  N    ] dev-db/mysql-4.1.20
> [ebuild  N    ] dev-perl/DBD-mysql-2.9007
> 
> ...
> 
> USE="server symlink bugzilla sshd postgresql -mysql -mysqli postfix -X -xorg -berkdb -kde -gnome
> -metacity"

emerge -pv bugzilla
[ebuild   R   ] www-apps/bugzilla-2.22  USE="apache2 graphviz mysql 
vhosts -extras -postgres" 1,911 kB

Change postgresql to postgres in your USE flags. Mysql is probably a 
default if no db is specified.

kashani
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] How to emerge bugzilla w/ postgresql

[Richard Broersma Jr]

> emerge -pv bugzilla
> [ebuild   R   ] www-apps/bugzilla-2.22  USE="apache2 graphviz mysql 
> vhosts -extras -postgres" 1,911 kB
> 
> Change postgresql to postgres in your USE flags. Mysql is probably a 
> default if no db is specified.

Thanks for the suggestion.  I defenitly see an improvement!  But the problem hasn't completly gone
away.

[ebuild  N    ] dev-db/mysql-4.1.20
[ebuild  N    ] dev-perl/DBD-mysql-2.9007
[ebuild  N    ] dev-db/libpq-8.1.4
[ebuild  N    ] dev-db/postgresql-8.1.4
[ebuild  N    ] dev-perl/DBD-Pg-1.43

Any other idea?

Regards,

Richard Broersma Jr.
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] How to emerge bugzilla w/ postgresql

[kashani]

Richard Broersma Jr wrote:
> Thanks for the suggestion.  I defenitly see an improvement!  But the problem hasn't completly gone
> away.
> 
> [ebuild  N    ] dev-db/mysql-4.1.20
> [ebuild  N    ] dev-perl/DBD-mysql-2.9007
> [ebuild  N    ] dev-db/libpq-8.1.4
> [ebuild  N    ] dev-db/postgresql-8.1.4
> [ebuild  N    ] dev-perl/DBD-Pg-1.43
> 
> Any other idea?

try emerge -pvt bugzilla for tree mode so you can see what's pulling in 
Mysql.

kashani
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] How to emerge bugzilla w/ postgresql

[Richard Broersma Jr]

 
> try emerge -pvt bugzilla for tree mode so you can see what's pulling in 
> Mysql.

[ebuild  N    ] net-www/mod_ssl-2.8.25-r10  801 kB
[ebuild  N    ]  net-www/apache-1.3.34-r11  USE="pam ssl -doc -lingerd -no-suexec -static-modules"
2,437 kB
[ebuild  N    ]   dev-libs/mm-1.3.0  220 kB
[ebuild  N    ]  dev-perl/PatchReader-0.9.5  USE="perl -minimal" 8 kB
[ebuild  N    ]   virtual/perl-File-Temp-0.16  0 kB
[ebuild  N    ]  dev-perl/Chart-2.3  USE="perl -minimal" 503 kB
[ebuild  N    ]  dev-perl/DBD-mysql-2.9007  USE="perl -minimal" 114 kB
[ebuild  N    ]   dev-db/mysql-4.1.20  USE="berkdb perl ssl -big-tables -cluster -debug -embedded
-xtraengine -latin1 -minimal -raid -srvdir -static" 16,917 kB

Here is what I get.  It looks net-www/mod_ssl is the highest parent in the tree.

One thing I should point out is that this tree is comming from my working server. The new server
is still building its new kernel so I couldn't actually test it.

Thanks for all of the help.

Regards,

Richard Broersma Jr.
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] How to emerge bugzilla w/ postgresql

[Richard Broersma Jr]

Here is what I get on the new server.

(chroot) livecd linux # emerge -pvt bugzilla

These are the packages that I would merge, in reverse order:

Calculating dependencies ...done!
[ebuild  N    ] www-apps/bugzilla-2.18.5  -apache2 -mysql -vhosts 1,623 kB
[ebuild  N    ]  dev-perl/Template-Toolkit-2.14  -gd -minimal -mysql +perl +postgres +xml 823 kB
[ebuild  N    ]   dev-perl/XML-XPath-1.13  -minimal +perl 38 kB
[ebuild  N    ]   dev-perl/text-autoformat-1.12  -minimal +perl 16 kB
[ebuild  N    ]    dev-perl/text-reform-1.11  -minimal +perl 20 kB
[ebuild  N    ]   dev-perl/XML-DOM-1.44  -minimal +perl 114 kB
[ebuild  N    ]    dev-perl/libwww-perl-5.803-r1  -minimal +perl +ssl 229 kB
[ebuild  N    ]     dev-perl/HTML-Tree-3.19.01  -minimal +perl 116 kB
[ebuild  N    ]     dev-perl/Compress-Zlib-1.41  -minimal +perl 148 kB
[ebuild  N    ]     dev-perl/HTML-Parser-3.48  -minimal +perl -unicode 80 kB
[ebuild  N    ]      dev-perl/HTML-Tagset-3.10  -minimal +perl 7 kB
[ebuild  N    ]     dev-perl/Crypt-SSLeay-0.51  -minimal +perl 114 kB
[ebuild  N    ]     virtual/perl-libnet-1.19  0 kB
[ebuild  N    ]     virtual/perl-Digest-MD5-2.36  0 kB
[ebuild  N    ]    dev-perl/XML-RegExp-0.03-r1  -minimal +perl 3 kB
[ebuild  N    ]    dev-perl/libxml-perl-0.08  -minimal +perl 62 kB
[ebuild  N    ]   dev-perl/DBD-Pg-1.43  -minimal +perl 128 kB
[ebuild  N    ]    virtual/perl-Test-Harness-2.56  0 kB
[ebuild  N    ]    dev-db/postgresql-8.1.4  -doc -kerberos +libg++ +nls +pam +perl -pg-intdatetime
+python +readline (-selinux) +ssl -tcltk -threads +xml +zlib 7,993 kB
[ebuild  N    ]     dev-libs/libxslt-1.1.17  +crypt -debug +python 1,865 kB
[ebuild  N    ]      dev-libs/libgcrypt-1.2.2-r1  +nls 939 kB
[ebuild  N    ]       dev-libs/libgpg-error-1.0-r1  +nls 316 kB
[ebuild  N    ]      dev-libs/libxml2-2.6.26  -debug -doc +ipv6 +python +readline -test 3,338 kB
[ebuild  N    ]     dev-python/egenix-mx-base-2.0.5  571 kB
[ebuild  N    ]     dev-db/libpq-8.1.4  -kerberos +nls +pam +readline +ssl -threads +zlib 0 kB
[ebuild  N    ]   dev-perl/XML-RSS-1.05  -minimal +perl 37 kB
[ebuild  N    ]    dev-perl/Test-Manifest-1.14  -minimal +perl 5 kB
[ebuild  N    ]  dev-perl/PatchReader-0.9.5  -minimal +perl 8 kB
[ebuild  N    ]   virtual/perl-File-Temp-0.16  0 kB
[ebuild  N    ]  dev-perl/Chart-2.3  -minimal +perl 503 kB
[ebuild  N    ]  dev-perl/DBD-mysql-2.9007  -minimal +perl 114 kB
[ebuild  N    ]   dev-db/mysql-4.1.20  -berkdb -big-tables -cluster -debug -embedded -extraengine
-latin1 -minimal +perl -raid (-selinux) -srvdir +ssl -static 16,917 kB

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] How to emerge bugzilla w/ postgresql

[Paul Varner]

On Wed, 2006-07-26 at 16:08 -0700, Richard Broersma Jr wrote:
> I am creating a new gentoo server, and I am in the handbook section to specify USE variables.
> No matter how I errange my USE variable in the make.conf,
> 
> emerge --update --pretend bugzilla  -- wants to use mysql
> 
> [ebuild  N    ] dev-db/mysql-4.1.20
> [ebuild  N    ] dev-perl/DBD-mysql-2.9007
> 
> ...
> 
> USE="server symlink bugzilla sshd postgresql -mysql -mysqli postfix -X -xorg -berkdb -kde -gnome
> -metacity"
> 
> Is there a way to override this selection and have postgresql and DBD-pg installed instead?

It is a bug in the ebuild dependencies.  It has a hard dependency on
DBD-mysql, which in turn has a hard dependency on mysql.

It appears to be fixed in the later unstable ebuilds.

For information on how to install unstable ebuilds, read Chapter 3.
Working with Portage in the handbook.

Regards,
Paul
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] How to emerge bugzilla w/ postgresql

[Richard Broersma Jr]

> > I am creating a new gentoo server, and I am in the handbook section to specify USE variables.
> > No matter how I errange my USE variable in the make.conf,
> > 
> > emerge --update --pretend bugzilla  -- wants to use mysql
> > 
> > [ebuild  N    ] dev-db/mysql-4.1.20
> > [ebuild  N    ] dev-perl/DBD-mysql-2.9007
> > 
> > ...
> > 
> > USE="server symlink bugzilla sshd postgresql -mysql -mysqli postfix -X -xorg -berkdb -kde
> -gnome
> > -metacity"
> > 
> > Is there a way to override this selection and have postgresql and DBD-pg installed instead?
> 
> It is a bug in the ebuild dependencies.  It has a hard dependency on
> DBD-mysql, which in turn has a hard dependency on mysql.
> 
> It appears to be fixed in the later unstable ebuilds.
> 
> For information on how to install unstable ebuilds, read Chapter 3.
> Working with Portage in the handbook.

Sounds good I will give it a try tomarrow!

Thanks for the feedback

Regards,

Richard Broersma Jr.
-- 
gentoo-user@gentoo.org mailing list