Hi, I managed to load up the sql file by deleting the first 4 lines and change TYPE to ENGINE. I had recycled some deleted email addresses which are still getting spam. Parsed aliases to /opt/spamikaze/scripts/passivetrap.pl. Mysql does not get update. I went through the document again and tried the remaining installation. Tried to run text.pl and encountered error below. [root@fantastic ~]# /opt/spamikaze/scripts/text.pl spamikaze-list.txt install_driver(MySQL) failed: Can't locate DBD/MySQL.pm in @INC (@INC contains: /opt/spamikaze/scripts /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 13) line 3. Perhaps the DBD::MySQL perl module hasn't been fully installed, or perhaps the capitalisation of 'MySQL' isn't right. Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge, mysql. at /opt/spamikaze/scripts/Spamikaze.pm line 127 remove.cgi and listing.cgi do not run too. Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. How do I troubleshoot? Is there a full documentary whereby it will tell me what are all the files are for and where should they reside in the server? Many thanks nic
Hi 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? Regards nic -----Original Message----- From: spamikaze-bounces@kernelnewbies.org [mailto:spamikaze-bounces@kernelnewbies.org] On Behalf Of Benny Pedersen Sent: Tuesday, 6 November, 2012 1:29 AM To: spamikaze@kernelnewbies.org Subject: Re: installation 鱼 skrev den 03-11-2012 21:03:
[root@fantastic ~]# /opt/spamikaze/scripts/text.pl spamikaze-list.txt install_driver(MySQL) failed: Can't locate DBD/MySQL.pm in @INC (@INC
install DBD::MySQL from cpan or from your distro if that does not do the trick, is DBI missing ? _______________________________________________ Spamikaze mailing list Spamikaze@kernelnewbies.org http://lists.kernelnewbies.org/mailman/listinfo/spamikaze
鱼 skrev den 06-11-2012 02:15:
Hi
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 ?
Regards nic
-----Original Message----- From: spamikaze-bounces@kernelnewbies.org [mailto:spamikaze-bounces@kernelnewbies.org] On Behalf Of Benny Pedersen Sent: Tuesday, 6 November, 2012 1:29 AM To: spamikaze@kernelnewbies.org Subject: Re: installation
鱼 skrev den 03-11-2012 21:03:
[root@fantastic ~]# /opt/spamikaze/scripts/text.pl spamikaze-list.txt install_driver(MySQL) failed: Can't locate DBD/MySQL.pm in @INC (@INC
install DBD::MySQL from cpan or from your distro
if that does not do the trick, is DBI missing ?
_______________________________________________ Spamikaze mailing list Spamikaze@kernelnewbies.org http://lists.kernelnewbies.org/mailman/listinfo/spamikaze
_______________________________________________ Spamikaze mailing list Spamikaze@kernelnewbies.org http://lists.kernelnewbies.org/mailman/listinfo/spamikaze
鱼 skrev den 06-11-2012 02:15: Hi
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 ?
Hi Benny, 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"; I can get the correct end result of 2+2 = 4 Regards nic <snip>
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
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','pa ssword',{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.
Hi Todd, How do I accomplish that? There is no entry. I fed passivetrap.pl with some mails, but they are not written into my trap mysql database Thanks nic
participants (3)
-
Benny Pedersen -
Todd Lyons -
鱼