Good day Thomas.Alright I found the issue. Apparently the assp.cfg file got altered when I ran the assp.mod install.cmd file, mainly the MYUSER and MYPASSWORD section under the database section. When I ran the debug like you instructed I saw the entry fly past on screen about the user name being passed over was not what MYSQL has for a allowed username. Once I changed this in the config again to match what I have as a valid username and password then all is well.
Another tidbit I just wanted to share, I tried several versions of Strawberry Perl before I found the above issue and I kept running into problems where Win32::Unicode and Schedule::Cron would not load. This was with both 32 and 64bit 5.18, 5.20.3 ans 5.22. I know you have nothing to do with Strawberry Perl, but I just wanted to put this out there in case anyone else ran into this. I resolved that issue with ActiveState Perl. So when I gave up on Strawberry Perl and installed ActiveState Perl 5.20.3.2003 32bit w/64Int all the modules installed just fine. I only had to install 2 modules through the cpan manager in the command line.
Thank you for the guidance Thomas. On 3/22/2016 5:23 AM, Thomas Eckardt wrote:
enable 'DataBaseDebug' start assp interactive at the console Thomas Von: Jay <h...@herodata.com> An: For Users of ASSP <assp-user@lists.sourceforge.net> Datum: 21.03.2016 22:58 Betreff: [Assp-user] ASSP startup log issue So I am testing this on my secondary mail server. I uninstalled ActiveState perl 5.16.3 32bit and installed Strawberry Perl 5.20.33 (32bit). This server is running ASSP 2.4.5(15272) and MySQL 5.5.48 (64bit). When I start ASSP this is what I see in the log file: Mar-21-16 17:39:42 [init] Try using mysql database <ASSP_DB> for selected tables Mar-21-16 17:39:42 [init] Spamdb database error: Usage tie(%h,Tie::RDBM,<DBI_data_source>,%options) at sub main::initDBHashes line 51. Mar-21-16 17:39:42 [init] Warning: can not use defined database - switching over to use files instead of database ASSP_DB! and Mar-21-16 17:40:10 [Worker_10001] Warning: database table spamdb has failed state - try to reconnect Mar-21-16 17:40:10 [Worker_10001] Spamdb database error: Usage tie(%h,Tie::RDBM,<DBI_data_source>,%options) at sub main::checkDBCon line 69 thread 7. I get this same scenario even on the 64bit version of Strawberry Perl. Each instance, I uninstalled Perl totally, installed the other version of Strawberry Perl, and then run the latest assp.mod batch file to install all the necessary Perl modules. It seems there's a module error, but when I checked the moduleLoadErrors.txt it has "There were no module load errors detected." Anyone here running Strawberry Perl 5.20.33? Just trying to compare that's all. Thanks. ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 _______________________________________________ Assp-user mailing list Assp-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-user 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! ******************************************************* ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 _______________________________________________ Assp-user mailing list Assp-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-user
------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________ Assp-user mailing list Assp-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-user
