[Assp-user] Getting ASSP to use Mysql

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Assp-user] Getting ASSP to use Mysql

James Moe-2
Hello,
  assp 2.5.5 (17073)
  linux 4.4.62-18.6-default x86_64
  perl 5.18.2

  ASSP is recommending that I use a database to manage data.

  myhost: localhost
  DBdriver: mysql
  mydb: asspdb
  myuser: assp_admin
  mypassword: ************

$  ll mysql/dbimport/
total 28804
-rw-r--r-- 1 root root    33843 May 27 13:48 delay.add
-rw-r--r-- 1 root root 29182952 May 27 13:46 spamdb.add
-rw-r--r-- 1 root root   274019 May 27 13:47 whitelist.add

  I did all of the above. The database exists. The database credentials
are valid.
- I checked "Import all files..."
- I selected the "Apply Changes and ..." button
- Additional red text appeared.

  Nothing happened. No tables were created in the database. The only
entry in the log file:
 2017-05-27 14:05:15 Admin Update: task ImportMysqlDB was queued to run
in worker 10000

  No entries in the mysql logs.
  Apparently the process quietly dies without even a whimper.

  Later: Adding the above entries causes ASSP to silently consume memory
until it crashes due to lack of memory.

  What next?

--
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-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Assp-user] Getting ASSP to use Mysql

Thomas Eckardt/eck
1. create the import files
2. setup the db config parameters

3. restart assp

watch the import

Thomas




Von:        James Moe <[hidden email]>
An:        ASSP development mailing list <[hidden email]>
Datum:        01.06.2017 01:01
Betreff:        [Assp-test] [Assp-user] Getting ASSP to use Mysql




Hello,
 assp 2.5.5 (17073)
 linux 4.4.62-18.6-default x86_64
 perl 5.18.2

 ASSP is recommending that I use a database to manage data.

 myhost: localhost
 DBdriver: mysql
 mydb: asspdb
 myuser: assp_admin
 mypassword: ************

$  ll mysql/dbimport/
total 28804
-rw-r--r-- 1 root root    33843 May 27 13:48 delay.add
-rw-r--r-- 1 root root 29182952 May 27 13:46 spamdb.add
-rw-r--r-- 1 root root   274019 May 27 13:47 whitelist.add

 I did all of the above. The database exists. The database credentials
are valid.
- I checked "Import all files..."
- I selected the "Apply Changes and ..." button
- Additional red text appeared.

 Nothing happened. No tables were created in the database. The only
entry in the log file:
2017-05-27 14:05:15 Admin Update: task ImportMysqlDB was queued to run
in worker 10000

 No entries in the mysql logs.
 Apparently the process quietly dies without even a whimper.

 Later: Adding the above entries causes ASSP to silently consume memory
until it crashes due to lack of memory.

 What next?

--
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-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test






DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no known virus in this email!
*******************************************************


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: {DKIM Fail} Re: [Assp-user] Getting ASSP to use Mysql

James Moe-2
On 05/31/2017 10:21 PM, Thomas Eckardt wrote:
> 1. create the import files
> 2. setup the db config parameters
>
  I also followed all of the steps listed by Robert Koffman in the ASSP
users list.


--
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Assp-user] Getting ASSP to use Mysql

James Moe-2
In reply to this post by Thomas Eckardt/eck
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: {DKIM Fail} Re: [Assp-user] Getting ASSP to use Mysql

James Moe-2
On 06/01/2017 12:56 PM, James Moe 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 missing sauce: I needed to install the MySQL (MariaDB) development
package.
  All good now.

--
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
Loading...