I put in a ticket, but I thought I'd also throw this question out to you
guys. I'm having some problems with a script that is using sqlite. I'll
cut and paste from the ticket:
POE::Component::EasyDBI Got STDERR from child, which should never happen
( <- errstr= ( 'no such table: trapdlog(1) at dbdimp.c line 412' ) [1
items] at SubProcess.pm line 866 ) at
/usr/local/lib/perl5/site_perl/5.8.5/POE/Component/EasyDBI.pm line 678.
I keep getting these messages when I run my perl script with
DBI->trace(1);
I created my database and table and its very simple
here are the steps I use as root (my script also runs as root)
dbish dbi:SQLite2:trapdlog.db
create table trapdlog (epochtime, trap_category, trap_create_time,
ip_hostname, trap_source, description, status);
This code works:
use DBI;
my $dbh = DBI->connect("dbi:SQLite2:dbname=trapdlog.db","","");
my $sql = "INSERT INTO trapdlog (epochtime, trap_category,
trap_create_time, ip_hostname, trap_source, descriptio n, status) values
('epoc','trapc','trapcxi','ip','tsrc','moocow','CLEAR')";
my $sth = $dbh->prepare($sql) or die("$DBI::errstr\n");
$sth->execute;
I am able to go into the dbi shell and see the record, but my program
doesn't seem to want to think the table exists. The database and script
calling the database are in the same cwd as well.
Any idears?
*** Note new e-mail address
--
Michael J. Freeman
Netco Government Services
[EMAIL PROTECTED]
--
