>Can't connect to MySQL server on '127.0.0.1' MySQL-Server: my.ini - max_connections=800 (very old assp versions may require this)
assp.pl diff: 2.1.2(11329) - 2.4.4(14355) 4500 changed lines 14000 missing lines :-( :-( :-( Thomas Von: Trevor Jacques <tre...@videlicet.com> An: ASSP development mailing list <assp-test@lists.sourceforge.net> Datum: 29.12.2014 07:08 Betreff: [Assp-test] Changing to MySQL I’m running an older version of asap, 2.1.2(11329), and have followed Fritz’s instructions of 2008-03-18, and double-checked each MANY times: > 1. Install Tie::RDBM and the perl DBI driver for your DB > 2. you need the file assp_db_import.cfg in your assp base directory > 3. create the DB (tablesace / schema / ....) depends on the DB-type > 5. create a DB-user with full rights to this DB (minimum is create/alter/delete table) > 6. go to ASSP-web configuration section <File Path and Database> > 7. configure the db <myhost> <DBdriver> (the available are shown in help text) <mydb> <myuser> <mypassword> > 8. configure any of the following ASSP-options of your choice to the value DB: (case sensitive!!!!) > spamdb > whitelistdb > redlistdb > delaydb > ldaplistdb > pbdb (in section penalty box) > 9. stop and start ASSP Please note that step 4 seems to have always been missing…. :-/ No matter what I do for db and user names, locations, port, and passwords, I always get this: > 27-Dec-2014 22:26:34 [Worker_10000] Delaydb database error: TIEHASH: Can't open dbi:mysql:database=assp;host=127.0.0.1, Can't connect to MySQL server on '127.0.0.1' (61) at assp.pl line 8259 thread 1. The version of asap is the latest that my server config can run, but it runs all other aspects of assp perfectly. CPAN tells me that all the required perl modules are up to date, or better, as is MySQL. One strange thing is that the Perl Modules of the Info and Stats web page does not show either DBI or DBD::mysql in the list, even though they are present and, apparently, working. I’ve even tried with user root and its password. Nothing seems to help. MySQL is running and responding very well to other services (for example, I have many WordPress sites running on the server), but not to assp’s perl requests. General Debug Mode was not much more help, either. Each time the startup routine arrived at a database (for example, RebuildSpamdb, below), it croaked, but with very little information other than one line saying that assp “Can’t connect to MySQL server.” Here’s the last one in a testing startup debug file, just before assp chooses to use the old files instead of database assp. For testing, I was using only delaydb and ldapdb: >> 28-Dec-2014 08:48:39 [init] <Worker 7 undefines sub main::configUpdateGlobalHidden >> 28-Dec-2014 08:48:39 [init] <Worker 7 undefines sub main::configChangeSched >> 28-Dec-2014 08:48:39 [init] <Worker 7 undefines sub main::configChangeDoRebuildSpamdb >> 28-Dec-2014 08:48:39 [Worker_10000] <ReloadOptionFiles >> 28-Dec-2014 08:48:39 [Worker_10000] <idle loop (5 s) >> 28-Dec-2014 08:48:39 [Worker_7] Delaydb database error: TIEHASH: Can't open dbi:mysql:database=assp;host=127.0.0.1, Can't connect to MySQL server on '127.0.0.1' (61) at assp.pl line 8259 thread 9. > 28-Dec-2014 08:48:39 [Worker_7] Worker_7 started > 28-Dec-2014 08:48:39 [Worker_7] <ThreadGetNewCon >> 28-Dec-2014 08:48:39 [Worker_7] Worker_7 prepair to sleep > 28-Dec-2014 08:48:39 [Worker_7] <sleeping >> 28-Dec-2014 08:48:39 [Worker_7] Worker_7 will sleep now > 28-Dec-2014 08:48:39 [Worker_10001] <schedule waiting >> 28-Dec-2014 08:48:41 [init] Running ASSP version 2.1.2(11329) > 28-Dec-2014 08:48:41 [init] Info: starting general debug mode to file /usr/local/assp/debug/1419774521.dbg > 28-Dec-2014 08:48:41 [init] All Threads are started > 28-Dec-2014 08:48:41 [init] Info: CPU priority changed for Worker_10000 from 31 to 2 > 28-Dec-2014 08:48:41 [init] Info: CPU priority changed for Worker_10001 from 31 to 2 > 28-Dec-2014 08:48:41 [init] Try using mysql database <assp> for selected tables > 28-Dec-2014 08:48:41 [init] <ResetStats >> 28-Dec-2014 08:48:41 [init] Delaydb database error: TIEHASH: Can't open dbi:mysql:database=assp;host=127.0.0.1, Can't connect to MySQL server on '127.0.0.1' (61) at assp.pl line 8259. > 28-Dec-2014 08:48:41 [init] Warning: can not use defined database - switching over to use files instead of database assp! > 28-Dec-2014 08:48:41 [init] Error : DB-failover loading hashes from files > 28-Dec-2014 08:48:41 [init] Warning : setting configvalue for delaydb to delaydb > 28-Dec-2014 08:48:41 [init] Info: Delay loaded from /usr/local/assp/delaydb with 82 records > 28-Dec-2014 08:48:41 [init] Warning : setting configvalue for delaydb to delaydb > 28-Dec-2014 08:48:41 [init] Info: DelayWhite loaded from /usr/local/assp/delaydb.white with 53 records > 28-Dec-2014 08:48:41 [init] Warning : setting configvalue for ldaplistdb to ldaplist > 28-Dec-2014 08:48:41 [init] Info: LDAPlist loaded from /usr/local/assp/ldaplist with 86 records > 28-Dec-2014 08:48:41 [init] Warning : setting configvalue for adminusersdb to adminusers > 28-Dec-2014 08:48:41 [init] Warning : setting configvalue for adminusersdb to adminusers > 28-Dec-2014 08:48:41 [init] Info: adminusersdb (/usr/local/assp/) - loaded > 28-Dec-2014 08:48:41 [init] Info: adminusersdb (/usr/local/assp/.right) - loaded > 28-Dec-2014 08:48:41 [init] Listening for SMTP connections on ... One thing is clear, init starts debug mode AFTER the attempts to connect to the databases. :-/ This might well have been changed in the current version of assp. Anyone have any suggestions as to what may be wrong? Is there a way to test this? FWIW, I’ve tried turning on both assp and MySQL logging, but I can find no useful information in the logs…. Indeed, the logs did not display anything about the connection problem. Even using the DataBaseDebug checkbox gave me no extra informaation. :-/ Thanks. T. ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ 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! ******************************************************* ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
