Menu
▾
▴
sql-ledger-users
|
From: Richard L. <ri...@th...> - 2002-01-02 16:58:20
|
Can anyone save me a lot of earching and learning and tell me: What are DBI and DBD? "Why do I get DBI not installed" instead of sql-ledger/admin? I've just installed sql-ledger on an RH7.1 workstation. I have searched Redhat's rpms for DBI to no avail. Rpmfind has some listed, but not RedHat -- and I've no idea if that is the right thing to do, as I simply don't know what I'm doing here. -- richard |
|
From: <gha...@fr...> - 2002-01-02 17:21:01
|
On Wed, 2 Jan 2002, Richard Lyons wrote: > Can anyone save me a lot of earching and learning and tell me: Sure. > What are DBI and DBD? DBI and DBD are (families of) Perl modules. DBI is a fairly high level of abstration for dealing with DataBase Interfaces (hence the name DBI). DBD modules are the DataBase Drivers used by the DBI to talk to the actual database. You can get the DBI module, and the particular DBD (in this case, it's PG for PostgreSQL) from some place called CPAN (Comprehensive Perl Archive Network) at http://www.cpan.org/ I am a Debian user, so I don't know how much of CPAN is available from Redhat. Certainly a good chunk of CPAN is available using apt-get from Debian (but they always change the names of the modules). If DBI and DBD::Pg are not available from Redhat, hopefully they do have cpan.pm available, which is a relatively painless way of downloading, compiling, testing and installing perl modules from CPAN. Gord |
|
From: John B. <Jo...@be...> - 2002-01-02 17:34:43
|
You probably don't want to use the cpan.pm module; the packages are available from Red Hat in /pub/redhat/linux/7.1/en/os/i386/RedHat/RPMS on ftp.redhat.com. Just get perl-DB*. Using the cpan.pm module causes (in some cases) base perl to be upgraded to the latest available, currently 5.6.1. Upgrading to 5.6.1 causes many things in Red Hat Linux to break - thinks like autoconf, libtool, automake, and printing. If you need a module upgraded that's not provided by Red Hat, use the /usr/lib/rpm/cpanflute script (provided in the rpm-build package) to create an RPM from a CPAN tarball; much better that way. On Wed, 02 Jan 2002, gha...@fr... wrote: > > On Wed, 2 Jan 2002, Richard Lyons wrote: > > > Can anyone save me a lot of earching and learning and tell me: > > Sure. > > > What are DBI and DBD? > > DBI and DBD are (families of) Perl modules. DBI is a fairly > high level of abstration for dealing with DataBase Interfaces > (hence the name DBI). DBD modules are the DataBase Drivers > used by the DBI to talk to the actual database. You can get > the DBI module, and the particular DBD (in this case, it's > PG for PostgreSQL) from some place called CPAN (Comprehensive > Perl Archive Network) at http://www.cpan.org/ I am a Debian > user, so I don't know how much of CPAN is available from Redhat. > Certainly a good chunk of CPAN is available using apt-get from > Debian (but they always change the names of the modules). If > DBI and DBD::Pg are not available from Redhat, hopefully they > do have cpan.pm available, which is a relatively painless > way of downloading, compiling, testing and installing perl > modules from CPAN. > > Gord > -- John Berninger GPG Key ID: A8C1D45C Fingerprint: B1BB 90CB 5314 3113 CF22 66AE 822D 42A8 A8C1 D45C It is a known fact that developers cannot document. That's why we have documentation specialists. If developers could document, they'd all be system administrators! -- |
|
From: Thomas G. <to...@ad...> - 2002-01-02 17:25:17
|
On Wed, 2 Jan 2002, Richard Lyons wrote: > Can anyone save me a lot of earching and learning and tell me: >=20 > What are DBI and DBD? >=20 > "Why do I get DBI not installed" instead of sql-ledger/admin? =20 >=20 > I've just installed sql-ledger on an RH7.1 workstation. I have=20 > searched Redhat's rpms for DBI to no avail. Rpmfind has some listed,=20 > but not RedHat -- and I've no idea if that is the right thing to do, as= =20 > I simply don't know what I'm doing here. >=20 > -- > richard Richard, check out the FAQ and email archive(s)...DBI is Database Interface a perl module and after you install it you need DBD-Pg, which is a=20 'database driver' for P(ost)g(res)...you can get these at www.cpan.org You'll want to make sure you have perl installed... good luck -------------------------------------------------------------------- Saint Vincent Catholic Medical Centers =20 -------------------------------------------------------------------- Thomas Good tomg@ { admin | q8 } .nrnet.org Programmer/Analyst Phone: 718-818-5528=20 Behavioral Health Services Fax: 718-818-5056 =20 Residential Services Mobile: 917-282-7359 =20 -------------------------------------------------------------------- /* Rekordmeister ist nur der FC Bayern M=FCnchen! */ -------------------------------------------------------------------- |
|
From: Damon T. <da...@ra...> - 2002-01-02 17:27:20
|
"The DBI is a database interface module for Perl. It defines a set of methods, variables and conventions that provide a consistent database interface independent of the actual database being used." The DBD is a database driver for a specific database engine. For example, DBD::Pg is the DBI implementation for Postgresql. Here is a FAQ http://dbi.symbolstone.org/doc/faq.html If you perform a search with your favourite search engine for "DBI" you will find lots of information. Damon Quoting Richard Lyons <ri...@th...>: > Can anyone save me a lot of earching and learning and tell me: > > What are DBI and DBD? > > "Why do I get DBI not installed" instead of sql-ledger/admin? > > I've just installed sql-ledger on an RH7.1 workstation. I have > searched Redhat's rpms for DBI to no avail. Rpmfind has some listed, > but not RedHat -- and I've no idea if that is the right thing to do, as > I simply don't know what I'm doing here. > > -- > richard > > Ranksix Solutions Inc. da...@ra... 250.514.6616 |
|
From: Brian J. <bjo...@je...> - 2002-01-02 18:44:11
|
The packages from my Red Hat 7.2 disk are: perl-DBD-Pg-1.01-1.i386.rpm perl-DBI-1.18-1.i386.rpm Look for something like that on your Red Hat 7.1 disks -----Original Message----- From: sql...@li... [mailto:sql...@li...]On Behalf Of Richard Lyons Sent: Wednesday, January 02, 2002 10:59 AM To: sql...@li... Subject: DBI Can anyone save me a lot of earching and learning and tell me: What are DBI and DBD? "Why do I get DBI not installed" instead of sql-ledger/admin? I've just installed sql-ledger on an RH7.1 workstation. I have searched Redhat's rpms for DBI to no avail. Rpmfind has some listed, but not RedHat -- and I've no idea if that is the right thing to do, as I simply don't know what I'm doing here. -- richard |
|
From: John C. S. <js...@im...> - 2002-01-02 19:23:48
|
Obviously the best place to find the most up-to-date modules is cpan.org. Just follow the links Dieter has kindly provided on the sql-ledger.org web page. By the way, both packages are available as rpms for Mandrake too: perl-DBD-Pg-1.01-1mdk perl-DBI-1.20-1mdk Cheers, John Christian Stoddart Caracas - Venezuela On Wed, 2002-01-02 at 14:49, Brian Johnson wrote: > The packages from my Red Hat 7.2 disk are: > perl-DBD-Pg-1.01-1.i386.rpm > perl-DBI-1.18-1.i386.rpm > > Look for something like that on your Red Hat 7.1 disks > > > > > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...]On Behalf Of > Richard Lyons > Sent: Wednesday, January 02, 2002 10:59 AM > To: sql...@li... > Subject: DBI > > > Can anyone save me a lot of earching and learning and tell me: > > What are DBI and DBD? > > "Why do I get DBI not installed" instead of sql-ledger/admin? > > I've just installed sql-ledger on an RH7.1 workstation. I have > searched Redhat's rpms for DBI to no avail. Rpmfind has some listed, > but not RedHat -- and I've no idea if that is the right thing to do, as > I simply don't know what I'm doing here. > > -- > richard > > |
|
From: John C. S. <js...@im...> - 2002-01-02 18:53:14
|
Maybe a shortish explanation should go in the faq. The DBI is Tim Bunce's extremely flexible, vendor independent database interface for the perl language. To quote him directly, 'DBI is a database access Application Programming Interface (API) for the Perl Language. The DBI API Specification defines a set of functions, variables and conventions that provide a consistent database interface independant of the actual database being used.'. Programmers write code using this interface. Should the programmer/user/client/etc decide, for any reason, to use a completely different database manager *after* the application is written, the code stays the same and all that has to be done is change the DBD driver. The DBD driver is the actual handling code that sits between DBI and the database managers. There are DBD drivers for all major databases. Thus programmers can write core code that transparently accesses a database. Most SQL-Ledger installations will use DBD::Pg, which is the appropriate driver for the PostgreSQL database manager but later on other options will be available. Good luck John Christian Stoddart Caracas - Venezuela On Wed, 2002-01-02 at 11:59, Richard Lyons wrote: > Can anyone save me a lot of earching and learning and tell me: > > What are DBI and DBD? > > "Why do I get DBI not installed" instead of sql-ledger/admin? > > I've just installed sql-ledger on an RH7.1 workstation. I have > searched Redhat's rpms for DBI to no avail. Rpmfind has some listed, > but not RedHat -- and I've no idea if that is the right thing to do, as > I simply don't know what I'm doing here. > > -- > richard > |
|
From: alta <al...@al...> - 2002-01-02 19:59:20
|
Although the following steps are for SuSE 7.3, I believe some of the
details may help you get through the installation on Red Hat, as well:
INSTALLATION INSTRUCTIONS: PostgreSQL and Perl DBD on SuSE 7.3
1. Install the following using YaST2:
(Suggestion: Install each line-item below in a separate YaST2
session.)
- Development/Libraries/Perl: perl-DBI
- Applications/Databases: all postgresql modules
- Development Libraries: postgresql-devl
2. Setup directories and paths for PostgreSQL:
> su - (change to root)
Setup disk directory for your db:
# mkdir /var/lib/pgsql/data
# chown postgres /var/lib/pgsql/data
- Put PostgreSQL path /usr/bin/psql into PATH in /etc/profile.local
3. Initialize the database, start it, and test it:
# /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/data
# rcpostgresql start
Quick-test the server:
# su postgres
> psql -d template1
\q to exit psql
Setup another db user:
> createuser <db-user> (should matach an existing Linux user)
Shall the new user be able to create databases? (y/n) y
Shall the new user be able to create new users? (y/n) n
Note: SuSE 7.3 appears to have a Pg DBD, but I could not get it to
work,
so...
4. Verify the existence of the following, which are required for the
DBD:
- /usr/include/pgsql/libpq-fe.h
- /usr/lib/libpq.so
5. Download DBD::Pg from www.CPAN.org .
6. Expand and examine the downloaded components:
- su to the <db-user> you setup for db access, but NOT root!
- Expand DBD-Pg-1.01.tar.gz into your favorite directory.
- Read the README file.
7. Prepare for the build:
> PATH=.:$PATH
> export POSTGRES_INCLUDE=/usr/include/pgsql
> export POSTGRES_LIB=/usr/lib
8. Try the build:
> perl Makefile.PL
> make
- Verify no errors from the make.
> make test
- Verify all "ok" from the make test.
9. Do the final DBD install:
> su - (and cd back to the build directory, if necessary)
# make install
DBD-Pg is installed!
--
Reed White - ALTA RESEARCH - www.alta-research.com
Phone: 877-360-2582 - Email: al...@al...
|
|
From: Richard L. <ri...@th...> - 2002-01-02 22:07:03
|
On Wednesday 02 January 2002 20:09, you wrote:
> Although the following steps are for SuSE 7.3, I believe some of the
> details may help you get through the installation on Red Hat, as well:
Well... This was timely as I was stuck about there. BUT: RedHat is
different. As far as I have discovered the differences are:
INSTALLATION INSTRUCTIONS:
PostgreSQL and Perl DBD on RH7.1 versus SuSE 7.3
> 1. <snip> instead of YaST2, RH has
RPMs: postgresql-devel-7.0.3-8.i386.rpm (I needed this cos of deps.)
perl-DBD-Pg-0.95-1.i386.rpm
perl-DBI-1.14-10.i386.rpm (thanks to those here who pointed
me to these)
RPMs installed for me quite happily (I had already installed
postgresql).
> 2. Setup directories and paths for PostgreSQL:
>
> su - (change to root) ;
> ; I didn't need to do
> Setup disk directory for your db: ; all this -- the directory
> # mkdir /var/lib/pgsql/data ; was already there and
> # chown postgres /var/lib/pgsql/data ; chowned (I suppose by rpm)
> - Put PostgreSQL path /usr/bin/psql ; not sure abt this. RH has
> into PATH in /etc/profile.local ; no /etc/profile.local. There
; is /etc/profile, but I opted
; not to fiddle with this
; shell script unless it
; proves necessary.
> 3. Initialize the database, start it, and test it:
>
> # /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/data ; it wouldn't
; let me: db
; already exists
> # rcpostgresql start ; in RH that is (I believe)
; # service postgresql start
> Quick-test the server:
> # su postgres ; something very similar was
> > psql -d template1 ; fine on my RH system
> \q to exit psql
> Setup another db user:
> > createuser <db-user> <snip> ; no problem here either
> 4. Verify the existence of the following,
> which are required for the DBD:
>
> - /usr/include/pgsql/libpq-fe.h ; I don't have this
> - /usr/lib/libpq.so ; I do have this
>
> 5. Download DBD <snip> ; already done as rpm
> 6. to 9. <large snip> ; not relevant, therefore
So it looked as though I had it easier than those with SuSE in this
instance. BUT (there is always a 'but'...)
When I try to connect to
http://localhost/sql-ledger/admin.pl
I get "Error. Permission denied: users/members"
So something ain't right yet. Anyone help me out here?
--
richard
|
|
From: Roderick A. A. <raa...@ti...> - 2002-01-02 22:57:26
|
On Wed, 2 Jan 2002, Richard Lyons wrote:
> RPMs: postgresql-devel-7.0.3-8.i386.rpm (I needed this cos of deps.)
> perl-DBD-Pg-0.95-1.i386.rpm
> perl-DBI-1.14-10.i386.rpm (thanks to those here who pointed
> me to these)
> RPMs installed for me quite happily (I had already installed
> postgresql).
This is getting to be an 'old' version of PostgreSQL :-) The current
version is 7.1.3 with 7.2 to be released soon. This should work fine
for SQL-Ledger but after you get a chance to play with it look into
upgrading to the then current version. Features and performance is
increasing quickly.
Cheers,
Rod
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
|
Thanks for helping keep SourceForge clean.
X