Spam Filter ISP Forums : database creation issues https://www.logsat.com/spamfilter/forums/ Tue, 17 Mar 2026 05:39:00 +0000 Tue, 23 Nov 2010 17:53:41 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6899 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[database creation issues : update: Seems if you go back...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13906&title=database-creation-issues#13906 Author: njtech
Subject: 6899
Posted: 23 November 2010 at 5:53pm

update: Seems if you go back create the connection string, hit save
then goto the enterprise / standard version tab then click check/create
database tables (instead of the database setup tab) then hit save again it seems to update the connection string properly. The database setup tab seems to have a bug where it does not save the conn string.


Edited by njtech - 23 November 2010 at 5:54pm]]> Tue, 23 Nov 2010 17:53:41 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13906&title=database-creation-issues#13906 <![CDATA[database creation issues : Ok updated and now creates the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13905&title=database-creation-issues#13905 Author: njtech
Subject: 6899
Posted: 23 November 2010 at 5:45pm

Ok updated and now creates the tables (only using sql auth in the conn string  by the way) Windows auth does not work. just locks up after creating the non
ent. tables... its should using admin acct.

So using sql auth.. now its the activity log is complaining about missing  tables ... tblreloadtableinfo.. table is present in my db wonder if the app is not
saving the connection string correctly? I am hitting save..
]]> Tue, 23 Nov 2010 17:45:40 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13905&title=database-creation-issues#13905 <![CDATA[database creation issues : was using .834 will try the update...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13904&title=database-creation-issues#13904 Author: njtech
Subject: 6899
Posted: 23 November 2010 at 5:31pm

was using .834 will try the update thanks]]> Tue, 23 Nov 2010 17:31:36 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13904&title=database-creation-issues#13904 <![CDATA[database creation issues : njtech,Can you please let us know...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13903&title=database-creation-issues#13903 Author: LogSat
Subject: 6899
Posted: 22 November 2010 at 11:07pm

njtech,

Can you please let us know what version of SpamFilter you are using? I ask due to this bug that was discovered/fixed recently:

// New to VersionNumber = '4.2.4.838';
{TODO -cFix SpamFilter Enterprise would not recognize the "SQL Native Client" (SQLNCLI.1) provider for Microsoft SQL Server}
]]> Mon, 22 Nov 2010 23:07:26 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13903&title=database-creation-issues#13903 <![CDATA[database creation issues : I am having issues creating the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13901&title=database-creation-issues#13901 Author: njtech
Subject: 6899
Posted: 22 November 2010 at 11:13am

I am having issues creating the enterprise database tables. with
MSQL 2008

1) The connection string never saves after hitting save settings it reverts back
to defaults which will end up creating tables in the master db if
you don't set the connection string each time going into the menu.

2) Using the correct connection string, it can't seem
to create the enterprise tables even using the sa user.
the standard tables were created.

please wait...
tblQuarantine - not found
tblMsgs - not found
tblRejectCodes - not found
tblLogins - not found
tblServers - not found
Some Database tables not found - recreating...
and just hangs.. correct db and using sa

At one point I was getting further:
tblBL_EmailsToPresent - not found
tblBL_HoneypotblockedIPsPresent - not found
tblBL_HoneypotEmailsPresent - not found
tblBL_IPsPresent - not found
tblBL_KeywordsPresent - not found
tblBL_MAPSPresent - not found
tblBL_SURBLPresent - not found
tblReloadTableInfoPresent - not found
tblWL_AuthorizedTOEmailsPresent - not found
tblWL_AutoWhitelistForceDeliveryPresent - not found
tblWL_DomainsIPsPresent - not found
tblWL_EmailsFromPresent - not found
tblWL_EmailsToPresent - not found
tblWL_KeywordsPresent - not found
Some Enterprise Database tables not found - recreating...
Retrieved ServerID from tblServers: 1
Error updading/checking IsEmptytbl_LocalDomains - Invalid object name 'tbl_localdomains'
Done.
 
]]> Mon, 22 Nov 2010 11:13:13 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6899&PID=13901&title=database-creation-issues#13901