RE: [mv] my mv4.0.3 makecat -> mysql hitch

["Cameron B. Prince" <cbp@internetexpertsllc.com>]

******    message to minivend-users from "Cameron B. Prince" <cbp@InternetExpertsLLC.com>     ******

Maybe someone would care to interject here with this question.

I have yet to look into CPAN and I am not certain the rpm is not the same
thing as what's provided with it.

I have setup three different machines with Linux/MySQL/MV4.04 and I
installed those files to make MySQL work with a Perl test script such as:

#!/usr/bin/perl

use DBI;

print "Content-type: text/html\n\n";

      $dbh = DBI->connect("DBI:mysql:test:localhost", "root","compaq",);

        $sql = "SELECT * FROM testtable;";
        $results = $dbh->prepare($sql);
        $results->execute;
        @rowarray = $results->fetchrow_array;

        print "\n@rowarray[0]\n";
        @rowarray = $results->fetchrow_array;
        print "\n@rowarray[1]\n";

        $results->finish;
        $dbh->disconnect();

Once I confirmed MySQL was working, I installed MiniVend.

Other than a small snag with trying to use MiniVend with no password, it's
working well on all three machines.

If you can make sense of the perl above, change it to match your tables and
try it.


Cameron


-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Michael Brian Bentley
Sent: Friday, May 05, 2000 3:33 PM
To: minivend-users@minivend.com
Subject: RE: [mv] my mv4.0.3 makecat -> mysql hitch
Importance: Low

******    message to minivend-users from Michael Brian Bentley
<bentley@crenelle.com>     ******

>******    message to minivend-users from Cameron Prince
><PRINCECB@novachem.com>     ******
>
>I realize you aren't running linux, but did you install the software
>comparable to these?
>
>Msql-Mysql-modules-1.2209.tar
>MySQL-3.22.32-1.i386.rpm
>MySQL-client-3.22.32-1.i386.rpm
>MySQL-devel-3.22.32-1.i386.rpm
>Mysql-DBI-perl-bin-1.1825-1.i386.rpm
>
>I think the most concern in your case will be the latter of these.
>(Mysql-DBI-perl-bin-1.1825-1.i386.rpm)

>JWEID/Msql-Mysql-modules-1.2213.tar

Appears to have been installed by CPAN

>MySQL-3.22.32-1.i386.rpm
>MySQL-client-3.22.32-1.i386.rpm
>MySQL-devel-3.22.32-1.i386.rpm

I don't know about the above,
I used mysql-3.22.32-sun-solaris2.7-sparc.tar

>Mysql-DBI-perl-bin-1.1825-1.i386.rpm

Is this installable via CPAN?

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list