Koozali.org: home of the SME Server

Legacy Forums => Suggestions => Topic started by: John Trombly on January 26, 2002, 02:32:33 AM

Title: Perl-MySQL RPM
Post by: John Trombly on January 26, 2002, 02:32:33 AM
Wanted:
e-smith RPM that installes the DBI-DBD functions so Perl can talk to MySQL.

I tried installing it from source, but e-smith does not come with MAKE (and that is probally a good thing). The RPMs that come from RH7.1 didn't help much either.

Having an e-smith RPM that will put this on the server would be very welcome.

At present, only PHP will talk to MySQL (other than command line).

If nothing else, perhaps a How-To so I can walk through it and get it put on there!
Title: Re: Perl-MySQL RPM
Post by: Charlie Brady on January 29, 2002, 03:18:39 AM
John Trombly wrote:

> Wanted:
> e-smith RPM that installes the DBI-DBD functions so Perl can
> talk to MySQL.

Just search for perl-DBD-MySQL and perl-DBI on http://www.rpmfind.net/. The versions for RedHat 7.1 or 7.2 should work just fine.

Regards

Charlie
Title: Re: Perl-MySQL RPM
Post by: John Trombly on January 30, 2002, 07:05:27 PM
The reason I asked for this is because I cannot get it to work. Here is a screen shot of what I did

login as: root
Sent username "root"
root@192.168.1.86's password:
Last login: Wed Jan 30 09:17:50 2002

Welcome to the March Networks SME Server V5.0
Kernel 2.2.19-7.0.8 on an i686

[root@gnatbox /root]# mc















[root@gnatbox rpm]# man rpm
bash: man: command not found
[root@gnatbox rpm]# rpm --test *.rpm
RPM version 4.0.2
Copyright (C) 1998-2000 - Red Hat, Inc.
This program may be freely redistributed under the terms of the GNU GPL

Usage: rpm {--help}
       rpm {--version}
       rpm {--initdb}   [--dbpath ]
       rpm {--install -i} [-v] [--hash -h] [--percent] [--force] [--test]
                        [--replacepkgs] [--replacefiles] [--root ]
                        [--excludedocs] [--includedocs] [--noscripts]
                        [--rcfile ] [--ignorearch] [--dbpath ]
                        [--prefix ] [--ignoreos] [--nodeps] [--allfiles]
                        [--ftpproxy ] [--ftpport ]
                        [--httpproxy ] [--httpport ]
                        [--justdb] [--noorder] [--relocate oldpath=newpath]
                        [--badreloc] [--notriggers] [--excludepath ]
                        [--ignoresize] file1.rpm ... fileN.rpm
       rpm {--upgrade -U} [-v] [--hash -h] [--percent] [--force] [--test]
                        [--oldpackage] [--root ] [--noscripts]
                        [--excludedocs] [--includedocs] [--rcfile ]
                        [--ignorearch]  [--dbpath ] [--prefix ]
                        [--ftpproxy ] [--ftpport ]
                        [--httpproxy ] [--httpport ]
                        [--ignoreos] [--nodeps] [--allfiles] [--justdb]
                        [--noorder] [--relocate oldpath=newpath]
                        [--badreloc] [--excludepath ] [--ignoresize]
                        file1.rpm ... fileN.rpm
       rpm {--query -q} [-afpg] [-i] [-l] [-s] [-d] [-c] [-v] [-R]
                        [--scripts] [--root ] [--rcfile ]
                        [--whatprovides] [--whatrequires] [--requires]
                        [--triggeredby]
                        [--ftpproxy ] [--ftpport ]
                        [--httpproxy ] [--httpport ]
                        [--provides] [--triggers] [--dump]
                        [--changelog] [--dbpath ] [targets]
       rpm {--verify -V -y} [-afpg] [--root ] [--rcfile ]
                        [--dbpath ] [--nodeps] [--nofiles] [--noscripts]
                        [--nomd5] [targets]
       rpm {--setperms} [-afpg] [target]
       rpm {--setugids} [-afpg] [target]
       rpm {--freshen -F} file1.rpm ... fileN.rpm
       rpm {--erase -e} [--root ] [--noscripts] [--rcfile ]
                        [--dbpath ] [--nodeps] [--allmatches]
                        [--justdb] [--notriggers] package1 ... packageN
       rpm {--resign} [--rcfile ] package1 package2 ... packageN
       rpm {--addsign} [--rcfile ] package1 package2 ... packageN
       rpm {--checksig -K} [--nopgp] [--nogpg] [--nomd5] [--rcfile ]
                           package1 ... packageN
       rpm {--rebuilddb} [--rcfile ] [--dbpath ]
       rpm {--querytags}
[root@gnatbox rpm]# rpm -V *.rpm
package mysql-devel-3.23.36-1.i386.rpm is not installed
package perl-DBD-MySQL-1.2215-1.i386.rpm is not installed
package perl-DBI-1.14-10.i386.rpm is not installed
[root@gnatbox rpm]# rpm rpm -Uvh my*.rpm
error: cannot open file rpm: No such file or directory
[root@gnatbox rpm]# rpm -Uvh my*.rpm
Preparing...                ########################################### [100%]
package mysql-devel-3.23.36-1 is already installed
[root@gnatbox rpm]# rpm -Uvh *.rpm
Preparing...                ########################################### [100%]
package mysql-devel-3.23.36-1 is already installed
package perl-DBD-MySQL-1.2215-1 is already installed
package perl-DBI-1.14-10 is already installed
[root@gnatbox rpm]# rpm -Uvh *.rpm
Preparing...                ########################################### [100%]
package mysql-devel-3.23.36-1 is already installed
package perl-DBD-MySQL-1.2215-1 is already installed
package perl-DBI-1.14-10 is already installed
[root@gnatbox rpm]# mc

[root@gnatbox cgi-bin]# ls
mminitmember.cgi
[root@gnatbox cgi-bin]# perl mminitmember.cgi
main::MAKE_MY_TABLE() called too early to check prototype at mminitmember.cgi line 31.
(offline mode: enter name=value pairs on standard input)
^[s

Can't locate object method "connect" via package "DBI" at mminitmember.cgi line 15, line 3.
[root@gnatbox cgi-bin]# Can't locate object method "connect" via package "DBI"

So for some reason, it cannot find the connect method, or the RPMs did not put it where it needs to go.

Any ideas on this?
Title: Re: Perl-MySQL RPM
Post by: John Trombly on January 31, 2002, 04:47:59 AM
Oops... RPMs from RH work fine!
It would still be nice to have it on a contrib page!