Mailing List Archive: DBMail: users

2.3.5 perspective and question

Index | Next | Previous | View Threaded

jake at vapourforge

Jan 15, 2009, 8:41 AM

Post #1 of 4 (398 views)
Permalink

2.3.5 perspective and question

Due to an unfortunate hdd controller issue my upgrade to this version
was a little more rapid than i had hoped.
All seems to be well with it now.
Unfortunatly mysql was stupid and let all the tables be created as
myisam rather than innodb without throwing an error due to a
misconfiguration not letting innodb run.
sorted that out by dumping the database and reloading it into a new
innodb version.

It seems really fast, but that might be the fact its got 2mb worth of
email in it now Vs 5 Gb it had before...
needless to say i'll be attempting recovery of that and getting a decent
backup system in place post haste.

It seems that the create_tables.mysql only has 2.3.4 in it because i
needed to run the 2.3.4>.5 sql to get dbmail to run.
So you might want to update that.

I am really keen on using TLS for security but I have NFI how to even
begin with using it, anybody have a place to start?
braindump or a grep through .bash_history for "openssl" would be really
helpfull. Promise i'll write it up in the wiki ;->

_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

paul at nfg

Jan 15, 2009, 10:52 AM

Post #2 of 4 (370 views)
Permalink

Re: 2.3.5 perspective and question [In reply to]

Jake Anderson wrote:

> It seems that the create_tables.mysql only has 2.3.4 in it because i
> needed to run the 2.3.4>.5 sql to get dbmail to run.
> So you might want to update that.

What are you talking about? The create script is uptodate.

>
> I am really keen on using TLS for security but I have NFI how to even
> begin with using it, anybody have a place to start?

For now, please use an ssl wrapper. There is still a problem in the tls
code I'm working on.

In general: you need to set:

#
# A file containing a list of CAs in PEM format
tls_cafile =

# A file containing a PEM format certificate
tls_cert =

# A file containing a PEM format RSA or DSA key
tls_key =

all three may point to one pem file generated with openssl.

I use:

#!/bin/sh

cd /etc/ssl/certs

echo -n "pemfile [foobar.pem]: "
read PEMFILE
[ -z "$PEMFILE" ] && exit
openssl req -new -x509 -nodes -days 1825 -out $PEMFILE -keyout $PEMFILE
chmod 600 $PEMFILE
[ -e temp_file ] && rm -f temp_file
dd if=/dev/urandom of=temp_file count=2
openssl dhparam -rand temp_file 512 >> $PEMFILE
ln -sf $PEMFILE `openssl x509 -noout -hash < $PEMFILE`.0

> braindump or a grep through .bash_history for "openssl" would be really
> helpfull. Promise i'll write it up in the wiki ;->

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

jake at vapourforge

Jan 15, 2009, 6:30 PM

Post #3 of 4 (367 views)
Permalink

Re: 2.3.5 perspective and question [In reply to]

Paul J Stevens wrote:
> Jake Anderson wrote:
>
>
>> It seems that the create_tables.mysql only has 2.3.4 in it because i
>> needed to run the 2.3.4>.5 sql to get dbmail to run.
>> So you might want to update that.
>>
>
> What are you talking about? The create script is uptodate.
>
I was using the debs, apt-get updated from 2.3.4
the create tables.mysql doesn't have these changes in it.

ALTER TABLE dbmail_mailboxes ADD seq bigint DEFAULT 0 NOT NULL;
ALTER TABLE dbmail_mailboxes ADD KEY seq (seq);
ALTER TABLE dbmail_mailboxes DROP mtime;
ALTER TABLE dbmail_users MODIFY COLUMN passwd VARCHAR(130) NOT NULL;

Unless its an artefact from updating, but I thought the doc/examples
folder would be updated as well.

other than that it all seems to be working well.

paul at nfg

Jan 16, 2009, 12:05 AM

Post #4 of 4 (368 views)
Permalink

Re: 2.3.5 perspective and question [In reply to]

Jake Anderson wrote:
> I was using the debs, apt-get updated from 2.3.4
> the create tables.mysql doesn't have these changes in it.

If you upgrade from 2.3.4 you need to apply the migration.
If you do a fresh 2.3.5 install use the create_tables.xxx in the debs.
They *are* up-to-date.

>
> ALTER TABLE dbmail_mailboxes ADD seq bigint DEFAULT 0 NOT NULL;
> ALTER TABLE dbmail_mailboxes ADD KEY seq (seq);
> ALTER TABLE dbmail_mailboxes DROP mtime;
> ALTER TABLE dbmail_users MODIFY COLUMN passwd VARCHAR(130) NOT NULL;
>
> Unless its an artefact from updating, but I thought the doc/examples
> folder would be updated as well.

They are. I've double checked.

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com