122182 – beancounter 0.8.1: setup_beancounter fails

Bug 122182 - beancounter 0.8.1: setup_beancounter fails

Summary: beancounter 0.8.1: setup_beancounter fails

Status:	RESOLVED TEST-REQUEST

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	All Linux

Importance:	High normal (vote)
Assignee:	Gentoo Linux bug wranglers

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2006-02-08 15:02 UTC by Karsten Kötter
Modified:	2006-02-08 15:26 UTC (History)
CC List:	0 users

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Karsten Kötter 2006-02-08 15:02:22 UTC

I installed beancounter 0.8.1 and setup_beancounter fails both with mysql and postgresql.


mysql:

koetter@kk2:~> setup_beancounter -m
Now using MySQL
Creating beancounter database

Creating beancounter database tables
Verifying database access from Perl
Config file /home/koetter/.beancounterrc not found, ignored.
install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: . /etc/perl /usr/lib/perl5/site_perl/5.8.7/i686-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.6/i686-linux /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.7/i686-linux /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.6/i686-linux /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.7/i686-linux /usr/lib/perl5/5.8.7 /usr/local/lib/site_perl .) at (eval 8) line 3.
Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysql.
 at /usr/lib/perl5/vendor_perl/5.8.7/Finance/BeanCounter.pm line 88
Failure -- please check database permission, possible requirement of
a password and other sources of failure to establish a connection.
koetter@kk2:~>       



postgresql:

koetter@kk2:~> setup_beancounter
Creating beancounter database
** Running:     createdb beancounter
CREATE DATABASE


Creating beancounter database tables
Verifying database access from Perl
Config file /home/koetter/.beancounterrc not found, ignored.
install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: . /etc/perl /usr/lib/perl5/site_perl/5.8.7/i686-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.6/i686-linux /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.7/i686-linux /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.6/i686-linux /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.7/i686-linux /usr/lib/perl5/5.8.7 /usr/local/lib/site_perl .) at (eval 8) line 3.
Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysql.
 at /usr/lib/perl5/vendor_perl/5.8.7/Finance/BeanCounter.pm line 88
Failure -- please check database permission, possible requirement of
a password and other sources of failure to establish a connection.
koetter@kk2:~>       


I don't think, that this is a issue of missing permissions as user koetter has all privileges on both databases. I'm a novice to db administration, but 'mysqladmin -f drop beancounter' and 'dropdb beancounter' are working, therefore I assume the permissions are ok.


Additional info:

root@kk2:/home/koetter>  emerge --info
Portage 2.0.54 (default-linux/x86/2005.0, gcc-3.3.6, glibc-2.3.5-r2, 2.6.14-gentoo-r4 i686)
=================================================================
System uname: 2.6.14-gentoo-r4 i686 AMD Athlon(tm)
Gentoo Base System version 1.6.14
ccache version 2.3 [enabled]
dev-lang/python:     2.3.5-r2, 2.4.2
sys-apps/sandbox:    1.2.12
sys-devel/autoconf:  2.13, 2.59-r6
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1
sys-devel/binutils:  2.16.1
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=athlon-xp -mcpu=athlon-xp -pipe -fomit-frame-pointer -momit-leaf-frame-pointer -ftracer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.2/share/config /usr/kde/3.3/env /usr/kde/3.3/share/config /usr/kde/3.3/shutdown /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/ /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/gconf /etc/splash /etc/terminfo /etc/env.d"
CXXFLAGS="-O2 -march=athlon-xp -mcpu=athlon-xp -pipe -fomit-frame-pointer -momit-leaf-frame-pointer -ftracer"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig candy ccache distlocks sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LINGUAS="de"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 3dnow X aac alsa apache2 apm arts audiofile avi berkdb bitmap-fonts bluetooth bzip2 cdparanoia cdr crypt cups curl divx4linux emboss encode esd exif expat fam ffmpeg flac flash foomaticdb fortran gcj gdbm gif glut gmp gpm gstreamer gtk2 idn imagemagick imlib ipv6 jack java jpeg junit kde lcms libg++ libwww mad mikmod mmx mng motif mp3 mpeg mpeg4 mysql ncurses nls offensive ogg oggvorbis opengl oss pam pcre pdflib perl png postgres ppds python qt quicktime readline recode samba scanner sdl slang spell sse ssl svga tcltk tcpd tetex tiff truetype truetype-fonts type1-fonts udev usb v4l v4l2 vorbis xine xml2 xmms xpdf xprint xv xvid zlib linguas_de userland_GNU kernel_linux elibc_glibc"
Unset:  ASFLAGS, CTARGET, LANG, LC_ALL, LDFLAGS, PORTDIR_OVERLAY

Comment 1 Jakub Moc (RETIRED) gentoo-dev

2006-02-08 15:06:25 UTC

run 'perl-cleaner all' and after it completes, try again.

Comment 2 Karsten Kötter 2006-02-08 15:26:15 UTC

The solution is already in the error message:
emerge DB-Pg (for mysql or postgresql)
emerge DB-SQLite (for SQLite)
Could you please fix in the dependencies? Or print out a message after emerging?

Regards,
Karsten



(In reply to comment #0)
> I installed beancounter 0.8.1 and setup_beancounter fails both with mysql and
> postgresql.
> 
> 
> mysql:
> 
> koetter@kk2:~> setup_beancounter -m
> Now using MySQL
> Creating beancounter database
> 
> Creating beancounter database tables
> Verifying database access from Perl
> Config file /home/koetter/.beancounterrc not found, ignored.
> install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: .
> /etc/perl /usr/lib/perl5/site_perl/5.8.7/i686-linux
> /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.4
> /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.6
> /usr/lib/perl5/site_perl/5.8.6/i686-linux /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.7/i686-linux /usr/lib/perl5/vendor_perl/5.8.7
> /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.6/i686-linux
> /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.7/i686-linux /usr/lib/perl5/5.8.7
> /usr/local/lib/site_perl .) at (eval 8) line 3.
> Perhaps the DBD::Pg perl module hasn't been fully installed,
> or perhaps the capitalisation of 'Pg' isn't right.
> Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysql.
>  at /usr/lib/perl5/vendor_perl/5.8.7/Finance/BeanCounter.pm line 88
> Failure -- please check database permission, possible requirement of
> a password and other sources of failure to establish a connection.
> koetter@kk2:~>       
> 
> 
> 
> postgresql:
> 
> koetter@kk2:~> setup_beancounter
> Creating beancounter database
> ** Running:     createdb beancounter
> CREATE DATABASE
> 
> 
> Creating beancounter database tables
> Verifying database access from Perl
> Config file /home/koetter/.beancounterrc not found, ignored.
> install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: .
> /etc/perl /usr/lib/perl5/site_perl/5.8.7/i686-linux
> /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.4
> /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.6
> /usr/lib/perl5/site_perl/5.8.6/i686-linux /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.7/i686-linux /usr/lib/perl5/vendor_perl/5.8.7
> /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.6/i686-linux
> /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.7/i686-linux /usr/lib/perl5/5.8.7
> /usr/local/lib/site_perl .) at (eval 8) line 3.
> Perhaps the DBD::Pg perl module hasn't been fully installed,
> or perhaps the capitalisation of 'Pg' isn't right.
> Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysql.
>  at /usr/lib/perl5/vendor_perl/5.8.7/Finance/BeanCounter.pm line 88
> Failure -- please check database permission, possible requirement of
> a password and other sources of failure to establish a connection.
> koetter@kk2:~>       
> 
> 
> I don't think, that this is a issue of missing permissions as user koetter has
> all privileges on both databases. I'm a novice to db administration, but
> 'mysqladmin -f drop beancounter' and 'dropdb beancounter' are working,
> therefore I assume the permissions are ok.
> 
> 
> Additional info:
> 
> root@kk2:/home/koetter>  emerge --info
> Portage 2.0.54 (default-linux/x86/2005.0, gcc-3.3.6, glibc-2.3.5-r2,
> 2.6.14-gentoo-r4 i686)
> =================================================================
> System uname: 2.6.14-gentoo-r4 i686 AMD Athlon(tm)
> Gentoo Base System version 1.6.14
> ccache version 2.3 [enabled]
> dev-lang/python:     2.3.5-r2, 2.4.2
> sys-apps/sandbox:    1.2.12
> sys-devel/autoconf:  2.13, 2.59-r6
> sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1
> sys-devel/binutils:  2.16.1
> sys-devel/libtool:   1.5.22
> virtual/os-headers:  2.6.11-r2
> ACCEPT_KEYWORDS="x86"
> AUTOCLEAN="yes"
> CBUILD="i686-pc-linux-gnu"
> CFLAGS="-O2 -march=athlon-xp -mcpu=athlon-xp -pipe -fomit-frame-pointer
> -momit-leaf-frame-pointer -ftracer"
> CHOST="i686-pc-linux-gnu"
> CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.2/share/config
> /usr/kde/3.3/env /usr/kde/3.3/share/config /usr/kde/3.3/shutdown
> /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown
> /usr/kde/3/share/config /usr/lib/X11/xkb /usr/share/config
> /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/
> /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/
> /usr/share/texmf/xdvi/ /var/qmail/control"
> CONFIG_PROTECT_MASK="/etc/gconf /etc/splash /etc/terminfo /etc/env.d"
> CXXFLAGS="-O2 -march=athlon-xp -mcpu=athlon-xp -pipe -fomit-frame-pointer
> -momit-leaf-frame-pointer -ftracer"
> DISTDIR="/usr/portage/distfiles"
> FEATURES="autoconfig candy ccache distlocks sandbox sfperms strict"
> GENTOO_MIRRORS="http://distfiles.gentoo.org
> http://distro.ibiblio.org/pub/linux/distributions/gentoo"
> LINGUAS="de"
> MAKEOPTS="-j2"
> PKGDIR="/usr/portage/packages"
> PORTAGE_TMPDIR="/var/tmp"
> PORTDIR="/usr/portage"
> SYNC="rsync://rsync.gentoo.org/gentoo-portage"
> USE="x86 3dnow X aac alsa apache2 apm arts audiofile avi berkdb bitmap-fonts
> bluetooth bzip2 cdparanoia cdr crypt cups curl divx4linux emboss encode esd
> exif expat fam ffmpeg flac flash foomaticdb fortran gcj gdbm gif glut gmp gpm
> gstreamer gtk2 idn imagemagick imlib ipv6 jack java jpeg junit kde lcms libg++
> libwww mad mikmod mmx mng motif mp3 mpeg mpeg4 mysql ncurses nls offensive ogg
> oggvorbis opengl oss pam pcre pdflib perl png postgres ppds python qt quicktime
> readline recode samba scanner sdl slang spell sse ssl svga tcltk tcpd tetex
> tiff truetype truetype-fonts type1-fonts udev usb v4l v4l2 vorbis xine xml2
> xmms xpdf xprint xv xvid zlib linguas_de userland_GNU kernel_linux elibc_glibc"
> Unset:  ASFLAGS, CTARGET, LANG, LC_ALL, LDFLAGS, PORTDIR_OVERLAY
>