MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

MySQL, can't connect



******    message to minivend-users from George Knerr <dnr@webalution.net>     ******

Hello,

I'm getting this error on startup:

Configuring catalog simple...simple config error: Can't connect, no
database driver specified at /usr/local/mvend/lib/Vend/Table/DBI.pm line
193

Ran the perl script below to check DBI and it worked fine.


#!/usr/bin/perl

use DBI;

($dbh = DBI->connect("DBI:mysql:minivend:localhost",'root',''))
or die "Could not connect to database dbname $DBI::errstr";

print "Content-type: text/html\n\n";
print "<ul>\n";
($c = $dbh->prepare("select code, description from products order by
code"))
or die "Could not prepare cursor";
$c->execute;
while(($code, $description) = $c->fetchrow) {
print "<li>$code $description\n";
}
print "</ul>\n";
$c->finish;
$dbh->disconnect;

exit(0);

Here is my catalog.cfg entries:

Database            products     products.asc      SQL

Database	products products.asc dbi:mysql:minivend:localhost:3306

Database            products DELIMITER    TAB
#Database            products LongReadLen  128

# Not needed unless your database requires a login
Database            products USER   root
Database            products PASS   

RH Linux 5.2
Mvend 3.12
DBI-1.06
Msql-Mysql-modules-1.2017

Thanks,

George Knerr
gknerr@webalution.net
-
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


Search for: Match: Format: Sort by: