Alexander, I' ve done a test with ODBC to SQL2005SP2 with DSN using the STD SQL-Server driver(not native Client). Import, Export ,Rebuild start stop all is OK . DBD::ODBC is version 1.15 !
Test with ADO driver version 2.96 using the same DSN was also successfull. Thomas "Shabalin, Alexander" <ashaba...@jgl.ru> 27.07.2009 08:37 Bitte antworten an ASSP development mailing list <assp-test@lists.sourceforge.net> An "ASSP development mailing list" <assp-test@lists.sourceforge.net> Kopie Thema Re: [Assp-test] Antwort: ASSP + MSSQL (ODBC and ADO access) errors DBD::ODBC: Area: Site - Version: 1.22 - Available: 1.22 Area: Perl - Version: 1.16 - Available: No value Best regards, Alexander Shabalin -----Original Message----- From: Thomas Eckardt/eck [mailto:thomas.ecka...@thockar.com] Sent: 27 июля 2009 г. 1:25 To: ASSP development mailing list Subject: [Assp-test] Antwort: ASSP + MSSQL (ODBC and ADO access) errors I've had a look in to module code - it looks like the ODBC driver is doing wrong things on 'prepair' SQL statements! What version of DBD::ODBC is running? Thomas "Shabalin, Alexander" <ashaba...@jgl.ru> 24.07.2009 16:26 Bitte antworten an ASSP development mailing list <assp-test@lists.sourceforge.net> An <assp-test@lists.sourceforge.net> Kopie Thema [Assp-test] ASSP + MSSQL (ODBC and ADO access) errors Hello! I've configured ASSP to use MSSQL by ODBC: spamdb:=DB: whitelistdb:=DB: redlistdb:=DB: delaydb:=DB: ldaplistdb:=DB: myhost:= SQLApp.DOMAIN.LOCAL DBdriver:=ODBC,DSN=asspdb mydb:=ASSPDB myuser:=<Domain user name encrypted> mypassword:=<Password encrypted> and configured ODBC Source with name "ASSPDB" pointing to database on ms sql server 2005. Database doesn't contain any tables. After first time running assp.pl and forcing spamdb rebuild I've got error on Log 1. Tables are created successfully and some info has been inserted into table spamdb. I don't use service, because I has been tried it on productive server with different port settings. On testing environment I've got the same errors. But if I stop and restart assp.pl - I've got fatal error while loading and seen a command prompt again. (Log 2) Running assp.pl with empty tables (without forced spamdb rebuild) give me no errors. And the last testing (tables deleted) with settings DBdriver:=ADO,DSN=asspdb give me a new created tables, no errors and NO data in tables. What do I do wrong? Log 1: ... Jul-24-09 16:03:24 [Main_Thread] Admin Update: task RunRebuildNow was queued to run Jul-24-09 16:03:27 [Worker_10001] RebuildSpamDB started Jul-24-09 16:03:27 [Worker_10001] Maxfiles: 50000 Jul-24-09 16:03:27 [Worker_10001] 'move to num' started for spamlog Jul-24-09 16:03:27 [Worker_10001] 'move to num' processed 1 files in spamlog Jul-24-09 16:03:27 [Worker_10001] 'move to num' started for notspamlog Jul-24-09 16:03:28 [Worker_10001] 'move to num' processed 1 files in notspamlog Jul-24-09 16:03:28 [Worker_10001] 'move to num' started for correctednotspam Jul-24-09 16:03:28 [Worker_10001] 'move to num' processed 1 files in correctednotspam Jul-24-09 16:03:28 [Worker_10001] 'move to num' started for correctedspam Jul-24-09 16:03:28 [Worker_10001] 'move to num' processed 1 files in correctedspam Jul-24-09 16:03:28 [Worker_10001] ./errors/spam Jul-24-09 16:03:28 [Worker_10001] File Count: 2 Jul-24-09 16:03:28 [Worker_10001] Processing... errors/spam with 2 files Jul-24-09 16:03:28 [Worker_10001] Imported Files: 2 Jul-24-09 16:03:28 [Worker_10001] Finished in 1 second(s) Jul-24-09 16:03:28 [Worker_10001] ./errors/notspam Jul-24-09 16:03:28 [Worker_10001] File Count: 2 Jul-24-09 16:03:28 [Worker_10001] Processing... errors/notspam with 2 files Jul-24-09 16:03:28 [Worker_10001] Imported Files: 2 Jul-24-09 16:03:28 [Worker_10001] Finished in 1 second(s) Jul-24-09 16:03:28 [Worker_10001] ./spam Jul-24-09 16:03:28 [Worker_10001] File Count: 623 Jul-24-09 16:03:28 [Worker_10001] Processing... spam with 623 files Jul-24-09 16:03:52 [Worker_10001] Imported Files: 623 Jul-24-09 16:03:52 [Worker_10001] Finished in 24 second(s) Jul-24-09 16:03:52 [Worker_10001] ./notspam Jul-24-09 16:03:52 [Worker_10001] File Count: 857 Jul-24-09 16:03:52 [Worker_10001] Processing... notspam with 857 files Jul-24-09 16:04:25 [Worker_10001] Imported Files: 857 Jul-24-09 16:04:25 [Worker_10001] Finished in 33 second(s) Jul-24-09 16:04:33 [Worker_10001] Cleaning old Spamdb records Jul-24-09 16:04:33 [Worker_10001] Error: rebuildspamdb failed - Can't call method "fetchrow_arrayref" on an undefined value at C:/Perl/site/lib/Tie/RDBM.pm line 166. Jul-24-09 16:04:33 [Worker_10001] INFO: RebuildSpamdb removed from queue ... Log 2: ... Jul-24-09 16:47:25 [init] Try using ODBC database <ASSPDB> for selected tables Jul-24-09 16:47:25 [init] Info: internal hashes are using 'BerkeleyDB' version 4.7 in directory ./tmpDB Jul-24-09 16:47:25 [init] Info: list IPNumTries is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list IPNumTriesDuration is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list IPNumTriesExpiration is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list SMTPSessionIP is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list SMTPdomainIP is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list SMTPdomainIPTries is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list SMTPdomainIPTriesExpiration is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list SSLfailed is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list Stats is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list WhiteOrgList is using 'BerkeleyDB' version 4.7 - cachesize is 648.0kB Jul-24-09 16:47:25 [init] Info: list BackDNS2 is using 'BerkeleyDB' version 4.7 - cachesize is 24.9MB Jul-24-09 16:47:25 [init] Using table <whitelist> in ODBC Database <ASSPDB> instead of file ./whitelist Jul-24-09 16:47:25 [init] Using table <redlist> in ODBC Database <ASSPDB> instead of file ./redlist Jul-24-09 16:47:25 [init] Using table <delaydb> in ODBC Database <ASSPDB> instead of file ./delaydb Jul-24-09 16:47:25 [init] Using table <delaywhitedb> in ODBC Database <ASSPDB> instead of file ./delaydb.white Jul-24-09 16:47:25 [init] Using table <spamdb> in ODBC Database <ASSPDB> instead of file ./spamdb Jul-24-09 16:47:25 [init] Using table <spamdbhelo> in ODBC Database <ASSPDB> instead of file ./spamdb.helo Jul-24-09 16:47:25 [init] Using table <ldaplist> in ODBC Database <ASSPDB> instead of file ./ldaplist Jul-24-09 16:47:25 [init] Info: adminusersdb (./adminusers) - loaded Jul-24-09 16:47:25 [init] Info: adminusersdb (./adminusers.right) - loaded Can't call method "fetchrow_arrayref" on an undefined value at C:/Perl/site/lib/Tie/RDBM.pm line 166. C:\_assp> Best regards, Alexander Shabalin ------------------------------------------------------------------------------ _______________________________________________ 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! ******************************************************* ------------------------------------------------------------------------------ _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test ------------------------------------------------------------------------------ _______________________________________________ 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! ******************************************************* ------------------------------------------------------------------------------ _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
