announce: dbmail-2.0.8

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Dbmail 2.0.8 released

This is mostly a bugfix release with some minor additional
features.

    * added ON UPDATE CASCADE to create_table files
    * do not close database connection on startup (closes:
#271)
    * change dbmail_messageblks.messageblk from longtext to
longblob in

      mysql create scripts
    * fix incorrect quoting in quoted_string_out (closes:
#204)
    * added CHILDREN capability
    * enable QUOTA in CAPABILITY

- --
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org


iD8DBQFD159w8iITvBH4zTERAhFqAJsHnJFUzm9Ek3Bmu+qbZqaqT/90zQCg
t1XL
hmEQlVzCdd7FlN3yawSOTTg=
=oYJx
-----END PGP SIGNATURE-----
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Paul J Stevens wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> Dbmail 2.0.8 released
> 
> This is mostly a bugfix release with some minor
additional features.
> 
>     * added ON UPDATE CASCADE to create_table files
>     * do not close database connection on startup
(closes: #271)
>     * change dbmail_messageblks.messageblk from
longtext to longblob in
> 
>       mysql create scripts
>     * fix incorrect quoting in quoted_string_out
(closes: #204)
>     * added CHILDREN capability
>     * enable QUOTA in CAPABILITY

I just did an upgrade from 2.0.7 -> 2.0.8 (to test the
quota) and the 
results were that postgresql went immediately nuts.

Jan 26 12:02:56 vanessa postgres[24177]: [10-2] HINT:  No
function 
matches the given name and argument types. You may need to
add explicit 
type casts.
Jan 26 12:02:56 vanessa postgres[24181]: [10-1] ERROR: 
function 
if(boolean, integer, integer) does not exist

Had to go back to 2.0.7 (no errors there, I ever re-compiled
the 2.0.7 
to see if this was some dependency problem)

freebsd5.4, postgresql 8.0.3

-- 
br,
Tommi
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Hi,

before i start updating some questions:
(1) are there statements included to alter the mysql
database
(tablechange,...)
(2) what happens to existing mails and accounts?  (e.g. text
became blob)
(3) are there any 2.0.7 -> 2.0.8 scripts or does dbmail
2.0.8 automaticly
upgrade existent data to 2.0.8 (database consistency)

regards

Simon

> -----Original Message-----
> From: dbmail-bouncesdbmail.org 
> [mailto:dbmail-bouncesdbmail.org] On Behalf Of
Paul J Stevens
> Sent: Wednesday, January 25, 2006 4:55 PM
> To: DBMail mailinglist
> Subject: [Dbmail] announce: dbmail-2.0.8
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> Dbmail 2.0.8 released
> 
> This is mostly a bugfix release with some minor
additional features.
> 
>     * added ON UPDATE CASCADE to create_table files
>     * do not close database connection on startup
(closes: #271)
>     * change dbmail_messageblks.messageblk from
longtext to 
> longblob in
> 
>       mysql create scripts
>     * fix incorrect quoting in quoted_string_out
(closes: #204)
>     * added CHILDREN capability
>     * enable QUOTA in CAPABILITY
> 
> - --
>  
____________________________________________________________
____
>   Paul Stevens                                     
paul at nfg.nl
>   NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
>   The Netherlands________________________________http://www.nfg.nl
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

> 
>
iD8DBQFD159w8iITvBH4zTERAhFqAJsHnJFUzm9Ek3Bmu+qbZqaqT/90zQCg
t1XL
> hmEQlVzCdd7FlN3yawSOTTg=
> =oYJx
> -----END PGP SIGNATURE-----
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

There are *no* changes in the database at all! The changes
in the create
files are not required for continued operation on existing
installs.



Simon Lange wrote:
> Hi,
> 
> before i start updating some questions:
> (1) are there statements included to alter the mysql
database
> (tablechange,...)
> (2) what happens to existing mails and accounts?  (e.g.
text became blob)
> (3) are there any 2.0.7 -> 2.0.8 scripts or does
dbmail 2.0.8 automaticly
> upgrade existent data to 2.0.8 (database consistency)
> 
> regards
> 
> Simon
> 
> 
>>-----Original Message-----
>>From: dbmail-bouncesdbmail.org 
>>[mailto:dbmail-bouncesdbmail.org] On Behalf Of
Paul J Stevens
>>Sent: Wednesday, January 25, 2006 4:55 PM
>>To: DBMail mailinglist
>>Subject: [Dbmail] announce: dbmail-2.0.8
>>
> 
> Dbmail 2.0.8 released
> 
> This is mostly a bugfix release with some minor
additional features.
> 
>     * added ON UPDATE CASCADE to create_table files
>     * do not close database connection on startup
(closes: #271)
>     * change dbmail_messageblks.messageblk from
longtext to 
> longblob in
> 
>       mysql create scripts
>     * fix incorrect quoting in quoted_string_out
(closes: #204)
>     * added CHILDREN capability
>     * enable QUOTA in CAPABILITY
> 
> --
>  
____________________________________________________________
____
>   Paul Stevens                                     
paul at nfg.nl
>   NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
>   The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail


-- 
 
____________________________________________________________
____
  Paul Stevens                                 
mailto:paulnfg.nl
  NET FACILITIES GROUP                     PGP: finger
paulnfg.nl
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Tommi Lätti wrote:
> Jan 26 12:02:56 vanessa postgres[24181]: [10-1] ERROR: 
function
> if(boolean, integer, integer) does not exist
> 
> Had to go back to 2.0.7 (no errors there, I ever
re-compiled the 2.0.7
> to see if this was some dependency problem)

That not good. Sounds like a regression. Will fix.
-- 
 
____________________________________________________________
____
  Paul Stevens                                 
mailto:paulnfg.nl
  NET FACILITIES GROUP                     PGP: finger
paulnfg.nl
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

SORT will not be fixed in 2.0. It's fixed in svn-trunk and
will start
appearing in released versions as of 2.1.4 (rsn).



zamri wrote:
> 
> 
> On 1/25/06, *Paul J Stevens* <paulnfg.nl
<mailto:paulnfg.nl>> wrote:
> 
> 
> Dbmail 2.0.8 released
> 
> This is mostly a bugfix release with some minor
additional features.
> 
>    * added ON UPDATE CASCADE to create_table files
>    * do not close database connection on startup
(closes: #271)
>    * change dbmail_messageblks.messageblk from longtext
to longblob in
> 
>      mysql create scripts
>    * fix incorrect quoting in quoted_string_out
(closes: #204)
>    * added CHILDREN capability
>    * enable QUOTA in CAPABILITY
> 
> 
>> How about SORT capability Paul? Is it still broken?
> 
> --
>
____________________________________________________________
____
> Paul Stevens                                      paul
at nfg.nl
> <http://nfg.nl>
> NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
> The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org <mailtobmaildbmail.org>
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

>
------------------------------------------------------------
------------

> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

-- 
 
____________________________________________________________
____
  Paul Stevens                                 
mailto:paulnfg.nl
  NET FACILITIES GROUP                     PGP: finger
paulnfg.nl
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

I've fixed this in the 2.0 branch. Expect a 2.0.9 release
later this
week which will contain this one fix, together with a fix
for bug #293
which I fixed yesterday.


Paul J Stevens wrote:
> 
> Tommi Lätti wrote:
> 
>>Jan 26 12:02:56 vanessa postgres[24181]: [10-1]
ERROR:  function
>>if(boolean, integer, integer) does not exist
>>
>>Had to go back to 2.0.7 (no errors there, I ever
re-compiled the 2.0.7
>>to see if this was some dependency problem)
> 
> 
> That not good. Sounds like a regression. Will fix.

-- 
 
____________________________________________________________
____
  Paul Stevens                                 
mailto:paulnfg.nl
  NET FACILITIES GROUP                     PGP: finger
paulnfg.nl
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Hi Paul,
Sounds good, but to be honest i guess you had good reasons
to change the
table fieldtypes and other database-structures.
So, is there a golden way to update 207 to 208 without loss
of data AND get
the advantage of those database-changes. Or why you have
changed them if
nobody "needs" to change their database-modell?!

best regards

Simon
 

> -----Original Message-----
> From: dbmail-bouncesdbmail.org 
> [mailto:dbmail-bouncesdbmail.org] On Behalf Of
Paul J Stevens
> Sent: Thursday, January 26, 2006 2:10 PM
> To: DBMail mailinglist
> Subject: Re: [Dbmail] announce: dbmail-2.0.8
> 
> There are *no* changes in the database at all! The
changes in 
> the create files are not required for continued
operation on 
> existing installs.
> 
> 
> 
> Simon Lange wrote:
> > Hi,
> > 
> > before i start updating some questions:
> > (1) are there statements included to alter the
mysql database
> > (tablechange,...)
> > (2) what happens to existing mails and accounts? 
(e.g. text became 
> > blob)
> > (3) are there any 2.0.7 -> 2.0.8 scripts or
does dbmail 2.0.8 
> > automaticly upgrade existent data to 2.0.8
(database consistency)
> > 
> > regards
> > 
> > Simon
> > 
> > 
> >>-----Original Message-----
> >>From: dbmail-bouncesdbmail.org
> >>[mailto:dbmail-bouncesdbmail.org] On Behalf Of
Paul J Stevens
> >>Sent: Wednesday, January 25, 2006 4:55 PM
> >>To: DBMail mailinglist
> >>Subject: [Dbmail] announce: dbmail-2.0.8
> >>
> > 
> > Dbmail 2.0.8 released
> > 
> > This is mostly a bugfix release with some minor
additional features.
> > 
> >     * added ON UPDATE CASCADE to create_table
files
> >     * do not close database connection on startup
(closes: #271)
> >     * change dbmail_messageblks.messageblk from
longtext to 
> longblob 
> > in
> > 
> >       mysql create scripts
> >     * fix incorrect quoting in quoted_string_out
(closes: #204)
> >     * added CHILDREN capability
> >     * enable QUOTA in CAPABILITY
> > 
> > --
> >  
____________________________________________________________
____
> >   Paul Stevens                                    
 paul at nfg.nl
> >   NET FACILITIES GROUP                    
GPG/PGP: 1024D/11F8CD31
> >   The
Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
> > _______________________________________________
> > Dbmail mailing list
> > Dbmaildbmail.org
> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
> 
> --
>  
____________________________________________________________
____
>   Paul Stevens                                 
mailto:paulnfg.nl
>   NET FACILITIES GROUP                     PGP: finger
paulnfg.nl
>   The Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Simon Lange wrote:
> Hi Paul,
> Sounds good, but to be honest i guess you had good
reasons to change the
> table fieldtypes and other database-structures.
> So, is there a golden way to update 207 to 208 without
loss of data AND get
> the advantage of those database-changes. Or why you
have changed them if
> nobody "needs" to change their
database-modell?!

The ON UPDATE CASCADE is only needed if for instance you
want to
re-organize your user_idnr values. I needed that when I
migrated my main
dbmail installations to LDAP with existing UID values.

The longtext to longblob change in the mysql tables reflect
the need to
store messages as-is: without the tables being sensitive to
character
encodings and such. Longblobs are binary fields, longtexts
are character
fields. So, if you want to play safe: update that field.

ALTER TABLE dbmail_messageblks CHANGE messageblk messageblk
longblob not
null;

should do the trick. But it may run a long time and eat your
disks if
you have a lot of mail.




> 
> best regards
> 
> Simon
>  
> 
> 
>>-----Original Message-----
>>From: dbmail-bouncesdbmail.org 
>>[mailto:dbmail-bouncesdbmail.org] On Behalf Of
Paul J Stevens
>>Sent: Thursday, January 26, 2006 2:10 PM
>>To: DBMail mailinglist
>>Subject: Re: [Dbmail] announce: dbmail-2.0.8
>>
>>There are *no* changes in the database at all! The
changes in 
>>the create files are not required for continued
operation on 
>>existing installs.
>>
>>
>>
>>Simon Lange wrote:
>>
>>>Hi,
>>>
>>>before i start updating some questions:
>>>(1) are there statements included to alter the
mysql database
>>>(tablechange,...)
>>>(2) what happens to existing mails and accounts?
 (e.g. text became 
>>>blob)
>>>(3) are there any 2.0.7 -> 2.0.8 scripts or
does dbmail 2.0.8 
>>>automaticly upgrade existent data to 2.0.8
(database consistency)
>>>
>>>regards
>>>
>>>Simon
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>From: dbmail-bouncesdbmail.org
>>>>[mailto:dbmail-bouncesdbmail.org] On Behalf Of
Paul J Stevens
>>>>Sent: Wednesday, January 25, 2006 4:55 PM
>>>>To: DBMail mailinglist
>>>>Subject: [Dbmail] announce: dbmail-2.0.8
>>>>
>>>
>>>Dbmail 2.0.8 released
>>>
>>>This is mostly a bugfix release with some minor
additional features.
>>>
>>>    * added ON UPDATE CASCADE to create_table
files
>>>    * do not close database connection on
startup (closes: #271)
>>>    * change dbmail_messageblks.messageblk from
longtext to 
>>
>>longblob 
>>
>>>in
>>>
>>>      mysql create scripts
>>>    * fix incorrect quoting in quoted_string_out
(closes: #204)
>>>    * added CHILDREN capability
>>>    * enable QUOTA in CAPABILITY
>>>
>>>--
>>> 
____________________________________________________________
____
>>>  Paul Stevens                                  
   paul at nfg.nl
>>>  NET FACILITIES GROUP                    
GPG/PGP: 1024D/11F8CD31
>>>  The
Netherlands________________________________http://www.nfg.nl
>>
>>_______________________________________________
>>Dbmail mailing list
>>Dbmaildbmail.org
>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>>
>>>_______________________________________________
>>>Dbmail mailing list
>>>Dbmaildbmail.org
>>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>>
>>--
>> 
____________________________________________________________
____
>>  Paul Stevens                                 
mailto:paulnfg.nl
>>  NET FACILITIES GROUP                     PGP:
finger paulnfg.nl
>>  The Netherlands________________________________http://www.nfg.nl
>>_______________________________________________
>>Dbmail mailing list
>>Dbmaildbmail.org
>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> 
> 
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

-- 
 
____________________________________________________________
____
  Paul Stevens                                 
mailto:paulnfg.nl
  NET FACILITIES GROUP                     PGP: finger
paulnfg.nl
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail