Owner with default schema "dbo" on ASSPDB database.
Best regards, Alexander Shabalin -----Original Message----- From: Маллиндайн Стивен (Steve Mallindine) [mailto:st...@sc.ru.ru] Sent: 24 июля 2009 г. 19:04 To: ASSP development mailing list Subject: Re: [Assp-test] ASSP + MSSQL (ODBC and ADO access) errors Alexander, What are the permissions for the SQL user? Steve Sent from my iPhone On 24.07.2009, at 18:30, "Shabalin, Alexander" <ashaba...@jgl.ru> wrote: > 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 ------------------------------------------------------------------------------ _______________________________________________ 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
