[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