On 05/31/2017 10:21 PM, Thomas Eckardt wrote:
> 1. create the import files
> 2. setup the db config parameters
> 3. restart assp
>
> watch the import
>
Or not.
Where is this magical file "mysql_config" (see cpan errors below)
supposed to exist? Is it something I must create?
The ASSP logs indicated that DBD::mysql was not available.
----[ assp logs ]----
2017-06-01 12:26:50 Spamdb database error: install_driver(mysql) failed:
Can't locate DBD/mysql.pm in @INC (you may need to install the
DBD::mysql module) (@INC contains: /usr/local/bin/assp2/lib
/usr/lib/perl5/site_perl/5.18.2/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.18.2
/usr/lib/perl5/vendor_perl/5.18.2/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.18.2
/usr/lib/perl5/5.18.2/x86_64-linux-thread-multi /usr/lib/perl5/5.18.2
/usr/lib/perl5/site_perl/5.18.1/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.18.1
/usr/lib/perl5/vendor_perl/5.18.1/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.18.1 /usr/lib/perl5/site_perl .
/usr/local/bin/assp2 /usr/local/bin/assp2/Plugins) at (eval 652) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, Proxy,
SQLite, Sponge.
at sub main::checkDBCon line 63 thread 7.
2017-06-01 12:26:50 Error: unable to use defined database - switching
over to use /usr/local/bin/assp2/spamdb instead of table spamdb!
----[ end ]----
So I tried to install it. That did not go well either.
I added the privileges indicated in the error message, and verified
them. It made no difference.
----[ cpan session ]----
$ cpan DBD::mysql
Reading '/root/.cpan/Metadata'
Database was generated on Wed, 31 May 2017 23:55:13 GMT
Running install for module 'DBD::mysql'
Checksum for
/root/.cpan/sources/authors/id/M/MI/MICHIELB/DBD-mysql-4.042.tar.gz ok
Configuring M/MI/MICHIELB/DBD-mysql-4.042.tar.gz with Makefile.PL
Can't exec "mysql_config": No such file or directory at Makefile.PL line 87.
Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'sma-user3x' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'sma-user3x'@'localhost'
identified by 's3kr1t';
You can also optionally set the user to run 'make test' with:
perl Makefile.PL --testuser=username
Can't exec "mysql_config": No such file or directory at Makefile.PL line
574.
Can't find mysql_config. Use --mysql_config option to specify where
mysql_config is located
Failed to determine directory of mysql.h. Use
perl Makefile.PL --cflags=-I<dir>
to set this directory. For details see DBD::mysql::INSTALL,
section "C Compiler flags" or type
perl Makefile.PL --help
Warning: No success on command[/usr/bin/perl Makefile.PL]
MICHIELB/DBD-mysql-4.042.tar.gz
/usr/bin/perl Makefile.PL -- NOT OK
----[ end ]----
--
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
Think.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
