cscmail-users

Re: [CSCMail-Users] Attachments

[Count Z. <cou...@cy...>]

Ok, these are MIME encoded filenames... I just added support for this, and
checked it into CVS... Please checkout the current CVS code and let me know
if it solves this problem... It should transparently fix it for existing
mail as well as new mail.

Let me know,

-CZ

----- Original Message -----
From: Daniel Schregenberger <np...@gm...>
To: CSCMail-Users <csc...@li...>
Sent: Saturday, December 08, 2001 9:31 AM
Subject: [CSCMail-Users] Attachments


> I've encountered some problems with attachments sent by windows-clients
(Opera,
> Notes, ...). They are using some kind of code for the filename instead of
a
> "normal" filename.
> The problem is that cscmail fails to save or view these attachments, I
think
> because of the '?' and '=' chars in the filename.
>
> Is there a better way to see these attachments nevertheless than exporting
the
> mail, modifying the attachment-filename and importing it again?
>
> I've added an attachment-header to show what I mean.
>
> Daniel
>
> PS: I've also seen some Mac-Clients sending attachments named
> "blah/blahblah/blah/file.ext" It's the same problem with them.
>
>
> Content-Disposition: attachment;
> filename==?windows-1252?Q?Philippe=20Amrein.doc?=
> Content-Type: application/msword;
> name==?windows-1252?Q?Philippe=20Amrein.doc?=
> Content-Transfer-Encoding: Base64
>
> _______________________________________________
> | Be sure to read the CSCMail FAQ:
> | http://www.cscmail.net/cscmail.faq
> |
> | CSCMail Home Page:
> | http://www.cscmail.net
> |
> | To unsubscribe or change your preferences:
> | https://lists.sourceforge.net/lists/listinfo/cscmail-users
>
>

[CSCMail-Users] Attachments

[Daniel S. <np...@gm...>]

I've encountered some problems with attachments sent by windows-clients (Opera,
Notes, ...). They are using some kind of code for the filename instead of a
"normal" filename.
The problem is that cscmail fails to save or view these attachments, I think
because of the '?' and '=' chars in the filename.

Is there a better way to see these attachments nevertheless than exporting the
mail, modifying the attachment-filename and importing it again?

I've added an attachment-header to show what I mean.

Daniel

PS: I've also seen some Mac-Clients sending attachments named
"blah/blahblah/blah/file.ext" It's the same problem with them.


Content-Disposition: attachment;
	filename==?windows-1252?Q?Philippe=20Amrein.doc?=
Content-Type: application/msword;
	name==?windows-1252?Q?Philippe=20Amrein.doc?=
Content-Transfer-Encoding: Base64

Re: [CSCMail-Users] (no subject)

[Homer P. <hp...@ho...>]

On Thu, 6 Dec 2001 17:31:43 -0500
"Count Zero" <cou...@cy...> wrote:
 
> Let me know if that solves it... as for the GDK errors, I am not sure,
but
> please let me know if CSCMail works even with the GDK errors...
> 

	It worked fine ;) thanks!! Months of logs archived in there.. One of
these days (years?? ;), I'm going to use them in a SQL db of their own to
plot trends on our firewall.. Anyway, that got it, thanks!!! There's still
these erros, but.. Seem to run k even with them ;)

[hparker@pluto hparker]$ cscmail
HTML Widget is: text
Thu Dec  6 20:35:45 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
Thu Dec  6 20:35:45 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
Thu Dec  6 20:35:45 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
Thu Dec  6 20:35:45 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
[hparker@pluto hparker]$ 

--- 
Homer Parker (The Bogus One)

http://www.homershut.net
telnet://bbs.homershut.net

This e-mail message is 100% Microsoft free!

WARNING: THIS ACCOUNT BELONGS TO A RABID
ANTI-SPAMMER NET-NAZI DOT-COMMUNIST.

   /"\
   \ /     ASCII Ribbon Campaign
    X      Against HTML Mail
   / \

Re: [CSCMail-Users] (no subject)

[Count Z. <cou...@cy...>]

Ok, so your layout should look something like this:

Folders
--Inbox
--ISP Lists
----ISP-Equip
--RedHat Lists
----RedHat Announce
--Misc Lists
----Pronto
----NNTP Cache
----FishCart
----CSC Mail
----NCA
----Video4Linux
----IC Radius
--Search
--PC Services
----Wireless Info
----Credit Card
----Quotes
----Orders
----Wireless Orders
----Airport
--Misc Stuff
----Stuff I Want To Do
----Reference
----Old
----Internic
--Logs
----Scans
----Root-russellks
----City Firewall
--Outbox
--Deleted Items
--Drafts
--Sent Items
--Bounced email

???

There is a break in the folder flow between Drafts and Sent Items... I am
sure this is due to the buggy folder ordering system in earlier versions of
CSCMail... issue this SQL command and see if it fixes things:

update boxlist set sibling = 3 where id = 5;

Essentially, for any branch of the tree, only ONE folder at that branch
should have sibling == NULL, all other folders at that branch need to have
sibling pointing at the folder directly beneath them in the layout. (ie:
Inbox.sibling == ISP Lists, ISP Lists.sibling == RedHat Lists, etc... down
to the last folder, Bounced email.sibling == NULL)

Having two folders in the same branch with a sibling == NULL produces
undefined behavior (apparently, it crashes! hehe)  The old version of
CSCMail (pre 1.7.10) used a slightly different folder ordering scheme, one
that really shouldn't have ever worked for anyone, but somehow seemed to
work ok for non-complex folder trees.  However, once the folder tree
structure grew in complexity, the old system would produce fairly random
folder ordering... it would also introduce wierdness like multiple folders
in a branch having invalid siblings (or the same sibling) ... the new code
won't do that, but in a migration scenerio, the state of the old DB may be
invalid...

Let me know if that solves it... as for the GDK errors, I am not sure, but
please let me know if CSCMail works even with the GDK errors...

-CZ

----- Original Message -----
From: Homer Parker <hp...@ho...>
To: Count Zero <cou...@cy...>
Cc: <csc...@li...>
Sent: Thursday, December 06, 2001 3:00 PM
Subject: Re: [CSCMail-Users] (no subject)


> On Thu, 6 Dec 2001 14:43:31 -0500
> "Count Zero" <cou...@cy...> wrote:
>
> > very odd... if you don't mind, do me a favor, and send me the results of
> the
> > following SQL query:
> >
> > select * from boxlist;
>
> hparker=# select * from boxlist;
>  id  |        name        | sibling | parent | query | body |  type
> -----+--------------------+---------+--------+-------+------+--------
>   18 | FishCart           |      16 |     33 |       |      | local
>   20 | NNTP Cache         |      18 |     33 |       |      | local
>   24 | Pronto             |      20 |     33 |       |      | local
>   11 | Video4Linux        |       9 |     33 |       |      | local
>   25 | Quotes             |      22 |     23 |       |      | local
>   17 | Credit Card        |      25 |     23 |       |      | local
>   30 | Wireless Info      |      17 |     23 |       |      | local
>   21 | Old                |      19 |     34 |       |      | local
>   27 | Reference          |      21 |     34 |       |      | local
>   28 | Scans              |      10 |     31 |       |      | local
>   29 | Stuff I Want To Do |      27 |     34 |       |      | local
>   22 | Orders             |      37 |     23 |       |      | local
>   37 | Wireless Orders    |      38 |     23 |       |      | local
>   35 | NCA                |      11 |     33 |       |      | local
>   10 | Root-russellks     |      13 |     31 |       |      | local
>   16 | CSC Mail           |      35 |     33 |       |      | local
>    2 | Outbox             |       4 |      0 |       |      | local
>    3 | Sent Items         |       8 |      0 |       |      | local
>    1 | Inbox              |      12 |      0 |       |      | local
>   12 | ISP Lists          |      32 |      0 |       |      | local
>   32 | RedHat Lists       |      33 |      0 |       |      | local
>   23 | PC Services        |      34 |      0 |       |      | local
>   34 | Misc Stuff         |      31 |      0 |       |      | local
>   31 | Logs               |       2 |      0 |       |      | local
>   33 | Misc Lists         |     100 |      0 |       |      | local
>    4 | Deleted Items      |       5 |      0 |       |      | local
>  100 | Search             |      23 |      0 |       |      | search
>    0 | Folders            |         |     -1 |       |      | local
>    8 | Bounced email      |         |      0 |       |      | local
>    9 | IC Radius          |         |     33 |       |      | local
>    6 | ISP-Equip          |         |     12 |       |      | local
>   19 | Internic           |         |     34 |       |      | local
>   26 | RedHat Announce    |         |     32 |       |      | local
>   13 | City Firewall      |         |     31 |       |      | local
>   38 | Airport            |         |     23 |       |      | local
>    5 | Drafts             |         |      0 |       |      | local
> (36 rows)
>
> hparker=#
>
>
> > It will help me debug this further.  As for the Gdk-Image stuff from
> line
> > 49, that is occuring when I am initializing the Gdk::Rgb engine, so is
> most
> > likely either a bug in your current Gtk-Theme, or some sort of Gtk::Perl
> > glitch... What theme are you running, and what versions of Gtk+ and
> > Gtk::Perl are you running?
> >
>
> cpan> i Gtk
> Module id = Gtk
>     DESCRIPTION  binding of the Gtk library used by GIMP
>     CPAN_USERID  LUPUS (Paolo Molaro <lu...@de...>)
>     CPAN_VERSION 0.7008
>     CPAN_FILE    L/LU/LUPUS/Gtk-Perl-0.7008.tar.gz
>     DSLI_STATUS  bdcO (beta,developer,C,object-oriented)
>     MANPAGE      Gtk - Perl module for the Gimp Toolkit library
>     INST_FILE    /usr/lib/perl5/site_perl/5.6.1/i686-linux/Gtk.pm
>     INST_VERSION 0.7008
>
>
> cpan>
>
> [root@pluto hparker]# rpm -qa | grep -i gtk+
> gtk+-devel-1.2.8-7
> gtk+-1.2.8-7
> gtk+10-1.0.6-9
> gtk+-gtkbeta-devel-1.3.1b-2
> gtk+-gtkbeta-1.3.1b-2
> [root@pluto hparker]#
>
> Hopefully that's the info your looking for ;) As for theme, which
> machine?? I'm ssh'd to that workstation and running it using ssh as the
> tunnel..
>
> ---
> Homer Parker (The Bogus One)
>
> http://www.homershut.net
> telnet://bbs.homershut.net
>
> This e-mail message is 100% Microsoft free!
>
> WARNING: THIS ACCOUNT BELONGS TO A RABID
> ANTI-SPAMMER NET-NAZI DOT-COMMUNIST.
>
>    /"\
>    \ /     ASCII Ribbon Campaign
>     X      Against HTML Mail
>    / \
>
> _______________________________________________
> | Be sure to read the CSCMail FAQ:
> | http://www.cscmail.net/cscmail.faq
> |
> | CSCMail Home Page:
> | http://www.cscmail.net
> |
> | To unsubscribe or change your preferences:
> | https://lists.sourceforge.net/lists/listinfo/cscmail-users
>
>

Re: [CSCMail-Users] (no subject)

[Homer P. <hp...@ho...>]

On Thu, 6 Dec 2001 14:43:31 -0500
"Count Zero" <cou...@cy...> wrote:

> very odd... if you don't mind, do me a favor, and send me the results of
the
> following SQL query:
> 
> select * from boxlist;

hparker=# select * from boxlist;
 id  |        name        | sibling | parent | query | body |  type  
-----+--------------------+---------+--------+-------+------+--------
  18 | FishCart           |      16 |     33 |       |      | local
  20 | NNTP Cache         |      18 |     33 |       |      | local
  24 | Pronto             |      20 |     33 |       |      | local
  11 | Video4Linux        |       9 |     33 |       |      | local
  25 | Quotes             |      22 |     23 |       |      | local
  17 | Credit Card        |      25 |     23 |       |      | local
  30 | Wireless Info      |      17 |     23 |       |      | local
  21 | Old                |      19 |     34 |       |      | local
  27 | Reference          |      21 |     34 |       |      | local
  28 | Scans              |      10 |     31 |       |      | local
  29 | Stuff I Want To Do |      27 |     34 |       |      | local
  22 | Orders             |      37 |     23 |       |      | local
  37 | Wireless Orders    |      38 |     23 |       |      | local
  35 | NCA                |      11 |     33 |       |      | local
  10 | Root-russellks     |      13 |     31 |       |      | local
  16 | CSC Mail           |      35 |     33 |       |      | local
   2 | Outbox             |       4 |      0 |       |      | local
   3 | Sent Items         |       8 |      0 |       |      | local
   1 | Inbox              |      12 |      0 |       |      | local
  12 | ISP Lists          |      32 |      0 |       |      | local
  32 | RedHat Lists       |      33 |      0 |       |      | local
  23 | PC Services        |      34 |      0 |       |      | local
  34 | Misc Stuff         |      31 |      0 |       |      | local
  31 | Logs               |       2 |      0 |       |      | local
  33 | Misc Lists         |     100 |      0 |       |      | local
   4 | Deleted Items      |       5 |      0 |       |      | local
 100 | Search             |      23 |      0 |       |      | search
   0 | Folders            |         |     -1 |       |      | local
   8 | Bounced email      |         |      0 |       |      | local
   9 | IC Radius          |         |     33 |       |      | local
   6 | ISP-Equip          |         |     12 |       |      | local
  19 | Internic           |         |     34 |       |      | local
  26 | RedHat Announce    |         |     32 |       |      | local
  13 | City Firewall      |         |     31 |       |      | local
  38 | Airport            |         |     23 |       |      | local
   5 | Drafts             |         |      0 |       |      | local
(36 rows)

hparker=# 


> It will help me debug this further.  As for the Gdk-Image stuff from
line
> 49, that is occuring when I am initializing the Gdk::Rgb engine, so is
most
> likely either a bug in your current Gtk-Theme, or some sort of Gtk::Perl
> glitch... What theme are you running, and what versions of Gtk+ and
> Gtk::Perl are you running?
> 

cpan> i Gtk
Module id = Gtk
    DESCRIPTION  binding of the Gtk library used by GIMP
    CPAN_USERID  LUPUS (Paolo Molaro <lu...@de...>)
    CPAN_VERSION 0.7008
    CPAN_FILE    L/LU/LUPUS/Gtk-Perl-0.7008.tar.gz
    DSLI_STATUS  bdcO (beta,developer,C,object-oriented)
    MANPAGE      Gtk - Perl module for the Gimp Toolkit library
    INST_FILE    /usr/lib/perl5/site_perl/5.6.1/i686-linux/Gtk.pm
    INST_VERSION 0.7008


cpan> 

[root@pluto hparker]# rpm -qa | grep -i gtk+
gtk+-devel-1.2.8-7
gtk+-1.2.8-7
gtk+10-1.0.6-9
gtk+-gtkbeta-devel-1.3.1b-2
gtk+-gtkbeta-1.3.1b-2
[root@pluto hparker]# 

	Hopefully that's the info your looking for ;) As for theme, which
machine?? I'm ssh'd to that workstation and running it using ssh as the
tunnel..

--- 
Homer Parker (The Bogus One)

http://www.homershut.net
telnet://bbs.homershut.net

This e-mail message is 100% Microsoft free!

WARNING: THIS ACCOUNT BELONGS TO A RABID
ANTI-SPAMMER NET-NAZI DOT-COMMUNIST.

   /"\
   \ /     ASCII Ribbon Campaign
    X      Against HTML Mail
   / \

Re: [CSCMail-Users] (no subject)

[Count Z. <cou...@cy...>]

very odd... if you don't mind, do me a favor, and send me the results of the
following SQL query:

select * from boxlist;

It will help me debug this further.  As for the Gdk-Image stuff from line
49, that is occuring when I am initializing the Gdk::Rgb engine, so is most
likely either a bug in your current Gtk-Theme, or some sort of Gtk::Perl
glitch... What theme are you running, and what versions of Gtk+ and
Gtk::Perl are you running?

-CZ

----- Original Message -----
From: Homer Parker <hp...@ho...>
To: Count Zero <cou...@cy...>
Cc: <lcs...@li...>
Sent: Thursday, December 06, 2001 1:53 PM
Subject: Re: [CSCMail-Users] (no subject)


> On Thu, 6 Dec 2001 13:06:24 -0500
> "Count Zero" <cou...@cy...> wrote:
>
> > When you upgraded, did you add the "type" field to the database?
>
> Ok, I missed that one.. That helped, but...
>
> [hparker@pluto hparker]$ cscmail
> HTML Widget is: text
> Thu Dec  6 12:54:35 2001 Gdk-LOG **: file gdkimage.c: line 416
> (gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
> line 49.
> Thu Dec  6 12:54:35 2001 Gdk-LOG **: file gdkimage.c: line 416
> (gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
> line 49.
> Thu Dec  6 12:54:35 2001 Gdk-LOG **: file gdkimage.c: line 416
> (gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
> line 49.
> Thu Dec  6 12:54:35 2001 Gdk-LOG **: file gdkimage.c: line 416
> (gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
> line 49.
> node is not of type Gtk::CTreeNode at /usr/bin/cscmail line 1567.
> [hparker@pluto hparker]$
>
> Ideas?
>
> ---
> Homer Parker (The Bogus One)
>
> http://www.homershut.net
> telnet://bbs.homershut.net
>
> This e-mail message is 100% Microsoft free!
>
> WARNING: THIS ACCOUNT BELONGS TO A RABID
> ANTI-SPAMMER NET-NAZI DOT-COMMUNIST.
>
>    /"\
>    \ /     ASCII Ribbon Campaign
>     X      Against HTML Mail
>    / \
>
>

Re: [CSCMail-Users] (no subject)

[Count Z. <cou...@cy...>]

When you upgraded, did you add the "type" field to the database?

With PostgreSQL, the appropriate statements are:

> UPGRADERS:
>
> There has been a change to the boxlist table in the database...
>
> alter table boxlist add column type text;
>
> update boxlist set type = 'local';
> update boxlist set type = 'search' where id = 100;
> update boxlist set type = 'virtual' where id > 100;
> update boxlist set sibling = NULL where sibling = 65535;

-CZ

----- Original Message ----- 
From: Homer Parker <hp...@ho...>
To: <csc...@li...>
Sent: Thursday, December 06, 2001 12:28 PM
Subject: [CSCMail-Users] (no subject)

[CSCMail-Users] (no subject)

[Homer P. <hp...@ho...>]

	I have been running CSCMail 1.7.x (before blineum bug fix) for a while
now, with no problems (asides from the ordering). Last night I updated
OpenSSH and OpenSSL on the system to cover some holes that have cropped
up... Go to check mial this morning, and CSCMail wasn't very cooperative..
I forget teh initial error.. But, it didn't work.. Motivation enough to
upgrade.. Ok, got CSCMail from cvs.. Not much better.. Got 1.7.10.. Not
much better... Jumped into CPAN and updated everything... Here is what I'm
left with:


[hparker@pluto hparker]$ cscmail
HTML Widget is: text
Thu Dec  6 11:12:16 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
Thu Dec  6 11:12:16 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
Thu Dec  6 11:12:16 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
Thu Dec  6 11:12:16 2001 Gdk-LOG **: file gdkimage.c: line 416
(gdk_image_destroy): assertion `image != NULL' failed. at /usr/bin/cscmail
line 49.
DBD::Pg::st execute failed: ERROR:  Attribute 'type' not found at
/usr/bin/cscmail line 1798.
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/bin/cscmail line 1799.
DBD::Pg::st execute failed: ERROR:  Attribute 'type' not found at
/usr/bin/cscmail line 1563.
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/bin/cscmail line 1564.
Use of uninitialized value in concatenation (.) or string at
/usr/bin/cscmail line 1607.
node is not of type Gtk::CTreeNode at /usr/bin/cscmail line 1593.
[hparker@pluto hparker]$ 

	I'm no programmer, so when I looked at the code on line 1798, it looked
fine to me.. Any help appreciated..

--- 
Homer Parker (The Bogus One)

http://www.homershut.net
telnet://bbs.homershut.net

This e-mail message is 100% Microsoft free!

WARNING: THIS ACCOUNT BELONGS TO A RABID
ANTI-SPAMMER NET-NAZI DOT-COMMUNIST.

   /"\
   \ /     ASCII Ribbon Campaign
    X      Against HTML Mail
   / \

Re: [CSCMail-Users] Bugreport 2nd Part

[Count Z. <cou...@cy...>]

What version of CSCMail, and what database backend?

-CZ

----- Original Message -----
From: Daniel Schregenberger <np...@gm...>
To: CSCMail-Users <csc...@li...>
Sent: Wednesday, October 31, 2001 3:45 PM
Subject: [CSCMail-Users] Bugreport 2nd Part


> I just recognized it didnt delete the messages in the subfolder either. So
I
> had to change their boxlist-entry to make them apear again and to delete
them
> correctly (including the files, not only the database entries) via
cscmail.
>
> daniel
>
> _______________________________________________
> | Be sure to read the CSCMail FAQ:
> | http://www.cscmail.net/cscmail.faq
> |
> | CSCMail Home Page:
> | http://www.cscmail.net
> |
> | To unsubscribe or change your preferences:
> | https://lists.sourceforge.net/lists/listinfo/cscmail-users
>
>

[CSCMail-Users] Bugreport 2nd Part

[Daniel S. <np...@gm...>]

I just recognized it didnt delete the messages in the subfolder either. So I
had to change their boxlist-entry to make them apear again and to delete them
correctly (including the files, not only the database entries) via cscmail.

daniel

[CSCMail-Users] Bugreport

[Daniel S. <np...@gm...>]

I just deleted a folder with a subfolder and some messages in the subfolder
(none in the folder).
When I emptied the deleted items folder, cscmail crashed and after a restart it
ate 100% cpu-power and repeatet these messages in an (infinite?) loop:

Use of uninitialized value at /usr/local/bin/cscmail line 1814.
Use of uninitialized value at /usr/local/bin/cscmail line 1813.


I took a look on the boxlist-table and recognized, that cscmail hadn't deleted
the subfolder, so i manually did this, now it starts again and seems to work
fine.

I thought this may interest you CZ.

Daniel

[CSCMail-Users] DBD::CSV

[Steven K. <st...@re...>]

The use of DBD::CSV as a database driver is no longer supported in
CSCMail, as of version 1.7.10

If you must use CSV instead of a real database, do not upgrade to
1.7.10, as CSCMail will not run.

The reason for this is a bug in the CSV driver that causes it to
improperly handle NULL data fields.

Also, the CSV driver does not properly deal with bind variables that are
dereferenced pointers.

Example:

$foo = 1;

&a(\$foo);

sub a {
	( $ref ) = @_;
	$bar = ${$ref};

	# prints a "1"
	print ($bar, "\n");

	# returns no values, even if there are rows where id == 1
	$query = $dbh->prepare("select name from boxlist where id = ?");
	$query->execute($bar);

	# returns all rows with id == 1
	$bam = 1;
	$query->execute($bam);	
}

These are completely equivalent perl expressiens, and in fact all other
DBD's handle this without any issues... DBD::CSV does not...  I am not
even sure how it finds out that $bar holds a dereferenced value, since
Data::Dumper doesn't seem to know... (dumping $bar and $bam show
identical data structures...)

I appologize to any users still using CSV, I plan to have a non database
dependant C version usable soon (I know, I've been saying that for a
year now.. but I am finally working on CSCMail again...)

Thank you for using CSCMail...

-CZ

Re: [CSCMail-Users] Linebreaks

[Steven K. <st...@re...>]

Daniel Schregenberger wrote:
> 
> Actually this fixed the "problem". The messages look like before and like I'm
> used to.
> 
> In fact I never noticed the layout wasn't correct (the thing with the TABs)
> 
> You're right: converting a \t to 8 spaces is just a hack but I don't care much
> about that (I don't think it's important to format emails (at least for me)).
> So for me this is alright. But for the long term your right.
> I noticed the widget used to edit messages also replaces \t by a number of
> spaces. Maybe the source of this one could help for a temporary fix. (just a
> suggestion)

The editing widget is a text widget...  The core of the problem is that
there is no &tab; character in HTML...  HTML was never designed to be a
text layout language.  In other words, it is designed to define "types"
of content, and the display agent is supposed to provide proper
formatting.  For example, the <P> </P> tag pair... A "good" HTML display
agent should indent the first line of the paragraph.  None do... HMTL
specifically ignores whitespace.  This includes \n, \t and even <space>
characters.  For example, like a good typist, I insert TWO spaces after
a sentance.  You can't see that though, because HTML ignores the
whitespace, dropping the 2nd space.  Of course, we have a <P> tag, but
no <SENTANCE> tag.  HTML designers dropped the ball there.  Is it a text
layout language?   NO! they say, user agents control text layout, HTML
simply defines the text types.  That is why they are removing things
like align=center from tags.  Problem is, in the real world, people want
to use HTML as a text formatting language.  They want to specify that
this paragraph should be centered, and not leave that up to the user
agent.  It's a mess, but anyway, I rant too much.

Ideally, I should use a text widget to display text/plain messages, and
an HTML widget to display text/html messages.  However, I think users
like the "pseudo" HTML formatting that using an HTML widget for
everything provides (things like auto-hyperlinks)

> btw: I noticed that HTML-Mails not declared as such (which means normal
> text-mail with html-content, just like I would write this mail with html) have
> not been displayed correctly with the PRE-Tags. This is actually not cscmail's
> fault, but the programs who created such mails, but its a hint that this was a
> hack.
> If you like to I can forward you one such message.

Yeah, this is one area where I have been "strict" .. If a message is
"text/plain" then I treat it as such... This is a "good thing" in my
mind... That way, I can send you text email that contains code snippets
or HTMl examples (eg: "the use of <P align="center"> is depreciated)
without it getting munged into some sort of HTML mess...

(If your MTA is displaying all this text centered, it's time to switch
to CSCMail <grin>)

If an MTA is sending out "true" HTML mail that has it's MIME type set to
text/plain, it's broken, and there's nothing I can do about it... If you
want to email someone a "hyperlink" just send them the URL... all modern
MTA's (including CSCMail) will automagically turn URLs in text/plain
messages into hyperlinks...  CSCMail is stricter than say Outlook
Express, in that it requires a real URL (http://cscmail.net) and won't
attempt to turn www.cscmail.net into a hyperlink (that's not a URL,
there is no protocol specifier)  Outlook, and all MS product's as far as
I can tell, do the "wrong thing" and attempt to turn anything that
"looks like" a url into a hyperlink.  Of course, they miss a lot of
things, and turn the wrong things into links a lot of the time, so it's
a mess I avoid by only autohyperlinking true URLs.

Herm, soapbox mode off....

-CZ

Re: [CSCMail-Users] Linebreaks

[Daniel S. <np...@gm...>]

Actually this fixed the "problem". The messages look like before and like I'm
used to.

In fact I never noticed the layout wasn't correct (the thing with the TABs)

You're right: converting a \t to 8 spaces is just a hack but I don't care much
about that (I don't think it's important to format emails (at least for me)).
So for me this is alright. But for the long term your right.
I noticed the widget used to edit messages also replaces \t by a number of
spaces. Maybe the source of this one could help for a temporary fix. (just a
suggestion)

btw: I noticed that HTML-Mails not declared as such (which means normal
text-mail with html-content, just like I would write this mail with html) have
not been displayed correctly with the PRE-Tags. This is actually not cscmail's
fault, but the programs who created such mails, but its a hint that this was a
hack.
If you like to I can forward you one such message.

Daniel

PS: thanks! this was really fast!


Count Zero wrote:

> Ok, I had been playing with using <PRE> </PRE> around text e-mail to
> preserve formatting in a non-hackish manner...
> 
> This of course makes the HTML widget us a fixed width font, and tells it not
> to autowrap lines...
> 
> I removed the <PRE> tags and checked a new csclib.pl into CVS, so that will
> fix these problems in the short term... However,
> text mail will still not display completely accurately... For example:
> 
>     This line is indented with TAB
> 
> This line is not...
> 
> With <PRE> that displayed correctly, without it, it doesn't... We used to do
> hackish things like convert \t to 8 &nbsp; characters, but I really really
> don't like that fix...
> 
> I'll try to think of something...
> 
> Anyway, in the short term, checkout csclib.pl from CVS on sourceforge to
> solve the linewrap/fixed font's issue...
> 
> -CZ
> 
> ----- Original Message -----
> From: Daniel Schregenberger <np...@gm...>
> To: <csc...@li...>
> Sent: Wednesday, October 17, 2001 9:58 AM
> Subject: [CSCMail-Users] Linebreaks
> 
> 
> > hi
> >
> > i recently upgraded to 1.7.10 and everything went well, except mails
> without
> > any linebreaks in them arent automatically wraped anymore.
> > any ideas how to fix that?
> >
> > i'm using cschtml 1.1 (and cscmail tells me it still uses this widget to
> > display messages (so the update hasnt killed it)) and html mails work fine
> so i
> > suppose this has nothing to do with cschtml.
> >
> > btw: the font has also changed, messages are now displayed with some kind
> of
> > standard fixed pitch font (except they are html)
> >
> > daniel

Re: [CSCMail-Users] Linebreaks

[Count Z. <cou...@cy...>]

Ok, I had been playing with using <PRE> </PRE> around text e-mail to
preserve formatting in a non-hackish manner...

This of course makes the HTML widget us a fixed width font, and tells it not
to autowrap lines...

I removed the <PRE> tags and checked a new csclib.pl into CVS, so that will
fix these problems in the short term... However,
text mail will still not display completely accurately... For example:

    This line is indented with TAB

This line is not...

With <PRE> that displayed correctly, without it, it doesn't... We used to do
hackish things like convert \t to 8 &nbsp; characters, but I really really
don't like that fix...

I'll try to think of something...

Anyway, in the short term, checkout csclib.pl from CVS on sourceforge to
solve the linewrap/fixed font's issue...

-CZ

----- Original Message -----
From: Daniel Schregenberger <np...@gm...>
To: <csc...@li...>
Sent: Wednesday, October 17, 2001 9:58 AM
Subject: [CSCMail-Users] Linebreaks


> hi
>
> i recently upgraded to 1.7.10 and everything went well, except mails
without
> any linebreaks in them arent automatically wraped anymore.
> any ideas how to fix that?
>
> i'm using cschtml 1.1 (and cscmail tells me it still uses this widget to
> display messages (so the update hasnt killed it)) and html mails work fine
so i
> suppose this has nothing to do with cschtml.
>
> btw: the font has also changed, messages are now displayed with some kind
of
> standard fixed pitch font (except they are html)
>
> daniel
>
> _______________________________________________
> | Be sure to read the CSCMail FAQ:
> | http://www.cscmail.net/cscmail.faq
> |
> | CSCMail Home Page:
> | http://www.cscmail.net
> |
> | To unsubscribe or change your preferences:
> | https://lists.sourceforge.net/lists/listinfo/cscmail-users
>
>

[CSCMail-Users] Linebreaks

[Daniel S. <np...@gm...>]

hi

i recently upgraded to 1.7.10 and everything went well, except mails without
any linebreaks in them arent automatically wraped anymore.
any ideas how to fix that?

i'm using cschtml 1.1 (and cscmail tells me it still uses this widget to
display messages (so the update hasnt killed it)) and html mails work fine so i
suppose this has nothing to do with cschtml.

btw: the font has also changed, messages are now displayed with some kind of
standard fixed pitch font (except they are html)

daniel

[CSCMail-Users] quoted text display problem

[jonescm <jo...@go...>]

Hello,
   I have just installed cscmail on my second machine at work, and am having a
display problem with quoted replies.  I don't seem to have this problem with my
box at home.  (the installation is nearly identical, only difference is the
machine hardware)  If a line starts with one or more > characters, there is no
linefeed afterwards.  Each and every line that starts with the > prints
directly over the last one, and what I get is one single line of all quoted
lines in the email superimposed over each other.  Anyone else had this problem?
 Is there perhaps a perl module I should upgrade, or look into?  Here are the
stats on this machine...


Slackware 8
perl 5.6.1
gtk 1.2.10
gtk-perl from cscmail.net
cscmail 1.7.10 installed from CVS
mysql 11.15 Distrib 3.23.41
using the GtkHTML widget

If you need any further information, just email me, but don't quote anything...
:)

Charles Jones

[CSCMail-Users] CSCMail 1.7.10 Released

[Count Z. <cou...@cy...>]

Ok, CSCMail 1.7.10 is in CVS now...

I'll be releasing a snapshot tarball later this evening...

UPGRADERS:

There has been a change to the boxlist table in the database...

alter table boxlist add column type text;

update boxlist set type = 'local';
update boxlist set type = 'search' where id = 100;
update boxlist set type = 'virtual' where id > 100;
update boxlist set sibling = NULL where sibling = 65535;

That should handle the database changes...  Actually, there is another
change, the "name" field is no longer required to be unique, but if it is in
your installation, nothing will break (you just won't be able to have
dupelicate folder names)

BUG FIXES
=========
The "billenium" bug is fixed in this version.

The folder tree layout bugs have all been fixed.  Specifically, in past
versions, quite a few folder layout changes wouldn't stick... CSCMail would
display the folders in an improper order.  This especially reared is ugly
head when you would try to put a new (high id) folder before an old (low id)
folder... in certain combinations, this simply wouldn't work...

Basically, the folder handling code has been almost completely re-written
from scratch... Gone are a lot of the lame global variables and hacks like
%foldernametoid ... there is now a single global %f_info structure that
mantains the folder layout in memory, as well as things like new, total
counts, etc...

No longer is the folder list attached to the Copy... and Move... menuitems
(which caused problems for people with a large number of folders)  ... Now,
selecting "Copy to folder..." or "Move to folder..." brings up a nice
folder_tree dialog that allows you to select the destination folder (this is
just like Outlook Express)

You are no longer limited to 65535 folders (hehe) nor are folder ID's > 100
reserved for "virtual" folders... the new "type" attribute stores the
folder's type, and so the ID is used only as a unique key, with the
exception of the first 6 "default" folders that are created on new
installations... These folder ID's are used for special purposes, but the
program won't let you do anything funky to those folders anyway...

Folders are no longer required to have a unique name.  However, the database
was created in the past with an SQL unique flag set on that column, so
unless you re-create your tables in the DB, you will get an SQL error when
you attempt to make a folder with a non-unique name...

There are a couple of new icons in this release... All folders now show an
icon next to themselves in the folder_tree to help display the folders
type... Currently valid types are "local" "remote" "search" and "virtual"
THEMERS: the icon names are: "localf.xpm" "remotef.xpm" "search.xpm" and
"vfolder.xpm" respectively

Don't get to excited by the inclusion of the "remote" folder type (nor the
IMAP account type option in the new account dialog)  THEY DON'T WORK YET!!!!
hehe   I haven't decided for sure if I am going to impliment IMAP support in
the Perl version of CSCMail or not... It may be more trouble than it's
worth, as there are quite a few assumptions made that simply don't apply
anymore when your dealing with a remote mailstore...  Of course, the whole
"folder rewrite" was started because I was investigating what would need to
change to support IMAP... so yeah, the new folder structure is designed with
the possibility of remote folders in mind...

Anyway, check it out, let me know how it works for you... if things are
smooth enough for enough people, this may become the long awaited 1.8.0
release!

-Count Zero

Re: [CSCMail-Users] Global symbol error on first startup attempt

[Count Z. <cou...@cy...>]

argh!  hehe, you caught me!

You checked out a version of CSCMail from CVS that doesn't run... it's my
fault, I checked in non-working code at work to finish from home...

I am about to check in 1.7.10-final which includes a complete re-do of the
folder code, a lot of things are much nicer now, so give me a few more
minutes to do some debugging, and then re-checkout from CVS... I'll post a
message when it's ready....

-CZ

----- Original Message -----
From: <as...@ph...>
To: <csc...@li...>
Sent: Wednesday, October 10, 2001 10:16 PM
Subject: [CSCMail-Users] Global symbol error on first startup attempt


> Hello,
>   This is my first post to the list, so "re" everyone...
>
> Here's the problem I'm having.  After an apparently successful
compilation/installation of all required modules, and cscmail itself... I
receive the following error trying to run the program:
>
> Global symbol "$new_sib" requires explicit package name at
/usr/local/bin/cscmail line 1821.
> Global symbol "$new_sib" requires explicit package name at
/usr/local/bin/cscmail line 1823.
> BEGIN not safe after errors--compilation aborted at /usr/local/bin/cscmail
line 5741.
>
>
> For the information on my box:
>
> Slackware 8
> Perl 5.6.1
> DBD-CSV-0.1027
> DBI-1.20
> DateManip-5.40
> HTML-Parser-3.25
> IO-stringy-2.108
> Lingua-Ispell-0.07
> MIME-Types-0.06
> MIME-tools-5.411
> MailTools-1.40
> Msql-Mysql-modules-1.2216
> SQL-Statement-0.1020
> Text-CSV_XS-0.23
> cscmail-1.7.x (CVS)  (1.7.10 I believe)
> gnome-perl (CVS)
> gtkhtml (CVS)
> gtk-1.2.10
> mysql-3.23.41
>
>
> Hope that info helps.  I am really looking forward to getting this client
up and running... Sooooooo tired of StarOffice for a mail client.
>
> --
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GIT/ED/CC d-- s++:- a- C++++ UL/S+++$ P+>+++ L+++>++++ E--- W+(+++) N+ o+
> K++ w-- O++@ M- V-- PS+ PE+ Y+(++) PGP++(+++) t++@ 5+ X+ R++(+) tv b++ DI+
> D++ G++>++++ e* h---- r+++ y++++(*)
> ------END GEEK CODE BLOCK------
>
> Death:  Life's way of saying "You can let go of your ankles now..."
>
> _______________________________________________
> | Be sure to read the CSCMail FAQ:
> | http://www.cscmail.net/cscmail.faq
> |
> | CSCMail Home Page:
> | http://www.cscmail.net
> |
> | To unsubscribe or change your preferences:
> | https://lists.sourceforge.net/lists/listinfo/cscmail-users
>
>

[CSCMail-Users] Global symbol error on first startup attempt

[<as...@ph...>]

Hello,
  This is my first post to the list, so "re" everyone...

Here's the problem I'm having.  After an apparently successful compilation/installation of all required modules, and cscmail itself... I receive the following error trying to run the program:

Global symbol "$new_sib" requires explicit package name at /usr/local/bin/cscmail line 1821.
Global symbol "$new_sib" requires explicit package name at /usr/local/bin/cscmail line 1823.
BEGIN not safe after errors--compilation aborted at /usr/local/bin/cscmail line 5741.


For the information on my box:

Slackware 8
Perl 5.6.1
DBD-CSV-0.1027
DBI-1.20
DateManip-5.40
HTML-Parser-3.25
IO-stringy-2.108
Lingua-Ispell-0.07
MIME-Types-0.06
MIME-tools-5.411
MailTools-1.40
Msql-Mysql-modules-1.2216
SQL-Statement-0.1020
Text-CSV_XS-0.23
cscmail-1.7.x (CVS)  (1.7.10 I believe)
gnome-perl (CVS)
gtkhtml (CVS)
gtk-1.2.10
mysql-3.23.41


Hope that info helps.  I am really looking forward to getting this client up and running... Sooooooo tired of StarOffice for a mail client.

-- 
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GIT/ED/CC d-- s++:- a- C++++ UL/S+++$ P+>+++ L+++>++++ E--- W+(+++) N+ o+
K++ w-- O++@ M- V-- PS+ PE+ Y+(++) PGP++(+++) t++@ 5+ X+ R++(+) tv b++ DI+
D++ G++>++++ e* h---- r+++ y++++(*)
------END GEEK CODE BLOCK------

Death:  Life's way of saying "You can let go of your ankles now..."

[CSCMail-Users] CSCMail 1.6.2 Released

[Steven K. <st...@re...>]

CSCMail 1.6.2 is out!  The only change vs. version 1.6.1 is the fixing
of the billenium bug, which caused messages received after Sep. 9th to
be sorted incorrectly.  All users of 1.6.1 should upgrade immediately.

Users of the 1.7.x series can expect the fix to be included in the next
CVS snapshot (1.7.10) which should be available soon...

Thank you,

-CZ

Re: [CSCMail-Users] Billenium Bug

[Count Z. <cou...@cy...>]

> Hi Steve,
>
> I fixed this for Pronto on Sept. 9th when it all happened. Here is what
> you need to do:
>
> $message_clist->set_compare_func(\&my_sort_func);
>
> sub my_sort_func
> {
> my ($clist, $first, $second) = @_;
> if ($first =~ /^\d+$/) {

What if we are sorting the subject field and one node is numeric, and the
other is text? This will attempt to sort that numerically (incorrect)

> if ($first > $second) { return -1; }
> if ($first == $second) { return 0; }
> return 2;

Why not use <=> ? thats what it's for....

> }
> my @stuff = ($first,$second);

A two element array?

> my @sorted = sort {uc($a) cmp uc($b)} @stuff;

Sort our two elements the first time using cmp... (which compares them...)

> if ($sorted[0] eq $first) { return -1; }

compare two elements (why? you just did that...)

> if ($first eq $second) { return 0; }

compare two elements (redundant)

> return 2;
> }
Oh, you just re-implimented cmp!?

Ouch!

Try:

sub my_sort_func {
        my ($clist, $a, $b) = @_;

# Might as well handle sortdir here (not strictly needed)
        if ($clist->{'sortdir'} eq "descending") {
                my $tmp = $a;
                $a = $b;
                $b = $tmp;
        }

# Are both nodes numeric?
        if ($a =~ /^\d+$/ and $b =~ /^\d+$/) {
                return ($a <=> $b);
# nope....
        } else {
                return (uc($a) cmp uc($b));
        }
}


CSCMail users: I will be releasing version 1.7.10 in the next few days that
addresses this bug as well encorporating quite a few other code cleanups...
In fact, the reason I am not releasing it right this second involves these
code cleanups... I was in the middle of re-coding the way Folders are
handled internally, as well as getting rid of the "no more than 99 normal
folders" restriction (this involves folders with id's equal to or greater
than 100 being treated as "virtual" search folders... I am adding a new
field to the database that handles the type of folder so there will no
longer be any arbitrary limits to the number of folders)

I guess I should release a 1.6.x version that fixes this bug as well?  Is
anyone still using 1.6.x?

-CZ

Re: [CSCMail-Users] Billenium Bug

[Maher A. <mu...@mu...>]

Hi Steve,

	I fixed this for Pronto on Sept. 9th when it all happened. Here is what
you need to do:

$message_clist->set_compare_func(\&my_sort_func);

sub my_sort_func
{
	my ($clist, $first, $second) = @_;
	if ($first =~ /^\d+$/) {
		if ($first > $second) { return -1; }
		if ($first == $second) { return 0; }
		return 2;
	}
	my @stuff = ($first,$second);
	my @sorted = sort {uc($a) cmp uc($b)} @stuff;
	if ($sorted[0] eq $first) { return -1; }
	if ($first eq $second) { return 0; }
	return 2;
}

This function sorts numerric and alphas the right way, as the gtk built in
function always does alpha sort.  

Maher

On Fri, 05 Oct 2001 16:15:40 -0400, Steven Kordik said:

> Ok, fun fun fun...
>  
>  To fix this, I need to setup a custom sort function to pass to
>  gtk_clist_set_compare_func()
>  
>  It'll take me a bit of time because I have to figure out how to do this in the
>  context of the Perl bindings (it would be trivial in C, but wrappers make
>  things complex)  I'll see what I can hack together over the weekend.
>  
>  Also, Gavin: what version of CSCMail are you running?  (I am sure this bug
>  exists in all versions, but I am curious due to the line number differences you
>  mention)
>  
>  -CZ
>  
>  Gavin Brown wrote:
>  
>  > > If you want to see this column, simply comment out line 4760 in cscmail.
>  >
>  > In both installations of cscmail I checked, line 4760 looks like
>  >
>  >  $folder_tree->{'popup'}->{'emptyfolder'}->signal_connect("activate" =>
>  > \&empty_folder);
>  >
>  > which I guess deals with the context menu options in the Folders pane. I did
>  > find line 4771 though:
>  >
>  >  $message_clist(set_column_visibility(7,0);
>  >
>  > Changing 0 to 1 did the trick.
>  >
>  > The hidden field shows a correct timestamp but when viewed, messages from
>  > before and after the billenium look like this:
>  >
>  > blah    blah    blah    1002310777
>  > blah    blah    blah    997052467
>  >
>  > Sorted alphanumerically, 1002310777 comes before 997052467, since the list
>  > order is A-Za-z0-9. Sorted numerically it's the other way around.
>  >
>  > I've had e-mail from two other people reporting the same bug.
>  >
>  > Hope this helps.
>  >
>  > Gavin.
>  
>  
>  _______________________________________________
>  | Be sure to read the CSCMail FAQ:
>  | http://www.cscmail.net/cscmail.faq
>  |
>  | CSCMail Home Page:
>  | http://www.cscmail.net
>  |
>  | To unsubscribe or change your preferences:
>  | https://lists.sourceforge.net/lists/listinfo/cscmail-users
>  
>  

-- 
http://www.muhri.net -- mu...@mu...

Re: [CSCMail-Users] Billenium Bug

[Steven K. <st...@re...>]

Ok, fun fun fun...

To fix this, I need to setup a custom sort function to pass to
gtk_clist_set_compare_func()

It'll take me a bit of time because I have to figure out how to do this in the
context of the Perl bindings (it would be trivial in C, but wrappers make
things complex)  I'll see what I can hack together over the weekend.

Also, Gavin: what version of CSCMail are you running?  (I am sure this bug
exists in all versions, but I am curious due to the line number differences you
mention)

-CZ

Gavin Brown wrote:

> > If you want to see this column, simply comment out line 4760 in cscmail.
>
> In both installations of cscmail I checked, line 4760 looks like
>
>  $folder_tree->{'popup'}->{'emptyfolder'}->signal_connect("activate" =>
> \&empty_folder);
>
> which I guess deals with the context menu options in the Folders pane. I did
> find line 4771 though:
>
>  $message_clist(set_column_visibility(7,0);
>
> Changing 0 to 1 did the trick.
>
> The hidden field shows a correct timestamp but when viewed, messages from
> before and after the billenium look like this:
>
> blah    blah    blah    1002310777
> blah    blah    blah    997052467
>
> Sorted alphanumerically, 1002310777 comes before 997052467, since the list
> order is A-Za-z0-9. Sorted numerically it's the other way around.
>
> I've had e-mail from two other people reporting the same bug.
>
> Hope this helps.
>
> Gavin.

Re: [CSCMail-Users] Billenium Bug

[Steven K. <st...@re...>]

Gavin Brown wrote:

> I've been doing a bit of investigation and I think (although I'm not sure) that CSCMail might have a bug. It would probably apply to Pronto too. The short explanation is:
>
> CSCMail's got the Billenium Bug!
>
> It seems that all mail in any folder with a date after the Billenium (when the UNIX epoch became 1000000000, or Sun Sep 9 01:46:39 2001) is listed *before* all mail before that date. I guess that the first digit is stripped off to fit the database column, so that a mail message with a date of 1001939646 becomes 001939646. This is obviously < 999999999, and so is sorted above it.

save_message() uses date_to_localdate() to convert the "string representation" of a date found in the message header to UNIX epoch time.  date_to_localdate() uses the &UnixDate() routine of Date::Manip.  I have tested Date::Manip, and it "does the right thing"

Message sorting is handled by using a "hidden" column in the GtkCList widget that contains the UNIX Epoch time value.  It is this column (which is not displayed) that is actually getting sorted when you click the "Date" column.

If you want to see this column, simply comment out line 4760 in cscmail.  This will allow you to verify that the proper number has been inserted into the table.  Please do this for me so we can troubleshoot this bug.  It is intirely possible that Gtk+ does the truncation you discribe in it's sort routine...

Let me know what you find out, also are others seeing this problem?

-Count Zero