1. create the import files
2. setup the db config parameters
3. restart assp
watch the import
Thomas
Von: James Moe <ji...@sohnen-moe.com>
An: ASSP development mailing list <assp-test@lists.sourceforge.net>
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
assp-u...@lists.sourceforge.net
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
Assp-test@lists.sourceforge.net
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
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
