Check the table structure - assp checks it at every startup
....
CREATE TABLE [dbo].[PBBlack](
[pkey] [varchar](254) NOT NULL,
[pvalue] [varchar](255) NULL,
[pfrozen] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(....
NEVER EVER open an import file in an editor and store it! These files are
NOT plain text - even they look like.
Thomas
Von: K Post <nntp.p...@gmail.com>
An: ASSP development mailing list <assp-test@lists.sourceforge.net>
Datum: 27.02.2015 02:58
Betreff: Re: [Assp-test] whitelist info in new database
Looks like each table's keys are truncated to 30 chars. I can't imagine
that's right.
I looked at the import files, and the length of the values is fine.
Any idea where I (or the code) could be going wrong?
thanks
On Thu, Feb 26, 2015 at 6:35 PM, K Post <nntp.p...@gmail.com> wrote:
> I just was able to import a flat whitelist into a test MSSQL 2012
database
> (thrilled)
>
> 2 questions:
> 1) I see a persblack (which I assume to be personal blacklist), but no
> perswhite. Is that correct?
>
> 2) In looking at the whitelist table, it appears that the maximum length
> of addresses in 30 characters. I see addresses like:
> u...@thedomain.com (fine)
> u...@thedomain.com,o...@us.org (fine I assume pers white)
> long-username@longdomainname.o (truncated @ 30 chars)
> u...@thedomain.com,ouruser@our (truncated @ 30 chars)
>
> Is this the way it's supposed to work? I checked the table def and its
> set at 255 chars (why not have that be even longer?)
>
>
>
>
------------------------------------------------------------------------------
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
