On Tue, Nov 6, 2012 at 7:59 PM, 鱼 <nicholas@10122112.com> wrote:
I had installed it. Changed config file "Type=mysql" all to lower cap and now the error is gone. Fed passivetrap.pl with some mails but the mysql still not get updated. How can I trouble shoot? is mysql database working from phpmyadmin ?
Yes it is working. I had tested it with a little script
#!/usr/bin/perl use DBI; my $dbh = DBI->connect('dbi:mysql:dbname=dataname;host=localhost','username','password',{AutoCommit=>1,RaiseError=>1,PrintError=>0}); print "2+2=",$dbh->selectrow_array("SELECT 2+2"),"\n";
You tested if your script can connect to the database. Make it actually connect to the server, open a specific database (the one that has your trap data) and query something out of any table. ...Todd -- The total budget at all receivers for solving senders' problems is $0. If you want them to accept your mail and manage it the way you want, send it the way the spec says to. --John Levine