Re: [Assp-test] whitelist info in new database

[K P. <nnt...@gm...>]

My table defs looks good:

CREATE TABLE [dbo].[whitelist](
[pkey] [varchar](254) NOT NULL,
[pvalue] [varchar](255) NULL,
[pfrozen] [int] NOT NULL,
 CONSTRAINT....

I copied the import file and opened it in an editor just as a way to check
that the data wasn't truncated there.  It seems like the 30 character
truncation happens upon import, but I can't tell why.    Have you ever seen
this before?  I haven't found the spot in the code that the import gets
made to look at the code.

Strange right?  I obviously can't test the other areas of the system until
this critical bit is working.

On Fri, Feb 27, 2015 at 7:05 AM, Thomas Eckardt <Tho...@th...>
wrote:

> 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 <nnt...@gm...>
> An:     ASSP development mailing list <ass...@li...>
> 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 <nnt...@gm...> 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:
> > us...@th... (fine)
> > us...@th...,ou...@us... (fine I assume pers white)
> > long-username@longdomainname.o  (truncated @ 30 chars)
> > us...@th...,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
> Ass...@li...
> 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
> Ass...@li...
> https://lists.sourceforge.net/lists/listinfo/assp-test
>