headers
Jesse Norell | 2 Jan 2004 19:18
Favicon
Gravatar

RE: Fix for wrong internal date


Hello,

  For those interested, to fix dates in postgres this worked for us
(postgresql 7.3.2):

update messages set internal_date = internal_date - ('1 year'::reltime)
where internal_date > now();

Jn

---- Original Message ----
From: Bret Baptist <dbmail <at> dbmail.org>
To: dbmail <at> dbmail.org
Subject: [Dbmail] Fix for wrong internal date
Sent: Tue, 30 Dec 2003 08:59:56 -0600

> This code uses the next year of this current week if the last week
of the 
> year:
> strftime(timestr, sizeof(timestr), "%G-%m-%d %H:%M:%S", &tm);
> 
> 
> This code will always use the current year:
> strftime(timestr, sizeof(timestr), "%Y-%m-%d %H:%M:%S", &tm);
> 
> You need to go through the dbmail sources and change all strftime
lines to 
> look like above, with a %Y, instead of a %G.
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Igor Olemskoi | 4 Jan 2004 16:03

1.x -> 2.x

Hello,

I tried to upgrade 1.x to 2.x using sql script by Christian G. Warden, but
I got an error when I tried to access my mailbox.

I tried to upgrade 1.x to 2.x using python script from 2.x CVS
(migration_1_x_to_2_0alpha.py), but it wrotes:

...
...
...
user 1508, size 0
user 1509, size 0
copying mailboxes table
copied 11468 records from mailboxes table
copy messages table to messages and physmessage table
copied 78382 records of messages into messages and physmessage
copying records from messageblks table
Out of memory (Needed 1420536 bytes)
copied 0 records of messageblks into messablks

Can anybody please advice me how to upgrade? :-)

Thank you!

Best regards,
Igor.
Permalink | Reply | 2 comments |
headers
Christian G. Warden | 4 Jan 2004 18:30

Re: 1.x -> 2.x

On Sun, Jan 04, 2004 at 05:03:54PM +0200, Igor Olemskoi wrote:
> I tried to upgrade 1.x to 2.x using sql script by Christian G. Warden, but
> I got an error when I tried to access my mailbox.

You're probably just missing the shared mailbox tables which were added
after I wrote that migration script.

DROP TABLE IF EXISTS shared_mailbox;
CREATE TABLE shared_mailbox (
  id bigint(21) NOT NULL auto_increment,
  mailbox_id bigint(21) NOT NULL default '0',
  maxmail_size bigint(21) NOT NULL default '0',
  curmail_size bigint(21) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY (mailbox_id),
  FOREIGN KEY (`mailbox_id`) REFERENCES `mailboxes` (`mailbox_idnr`) ON DELETE CASCADE
) TYPE=InnoDB;

DROP TABLE IF EXISTS shared_mailbox_access;
CREATE TABLE shared_mailbox_access (
  id bigint(21) NOT NULL auto_increment,
  shared_mailbox_id bigint(21) NOT NULL default '0',
  user_id bigint(21) NOT NULL default '0',
  lookup_flag tinyint(1) NOT NULL default '0',
  read_flag tinyint(1) NOT NULL default '0',
  insert_flag tinyint(1) NOT NULL default '0',
  write_flag tinyint(1) NOT NULL default '0',
  is_subscribed tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY (shared_mailbox_id),
(Continue reading)

Permalink | Reply | 1 comment |
headers
Igor Olemskoi | 5 Jan 2004 01:33

Re: [Dbmail] 1.x -> 2.x

> On Sun, Jan 04, 2004 at 05:03:54PM +0200, Igor Olemskoi wrote:
>> I tried to upgrade 1.x to 2.x using sql script by Christian G. Warden,
>> but
>> I got an error when I tried to access my mailbox.
> You're probably just missing the shared mailbox tables which were added
> after I wrote that migration script.
> If that's not it, post the error you're getting at debug level 5.

Thank you for help!
I have converted database using your sql script and tried to login via
squirrelmail. It began work fine when I disabled uid_support in
squirrelmail's config.
What is uid_support? Why dbmail2 doesn't support it?
Permalink | Reply | 0 comments |
headers
Igor Olemskoi | 5 Jan 2004 01:34

Aarons patches

Hello,

When Aarons patches will be submitted to the CVS?

Best regards,
Igor.
Permalink | Reply | 1 comment |
headers
Ilja Booij | 5 Jan 2004 09:56
Picon

Re: Aarons patches

Hi,

as soon as possible. Probably later this week, or early next week :)

Ilja

On 5 Jan 2004, at 01:34, Igor Olemskoi wrote:

> Hello,
>
> When Aarons patches will be submitted to the CVS?
>
>
> Best regards,
> Igor.
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
IC&S
Stadhouderslaan 57
3583 JD Utrecht
telnr. 030-6355730
faxnr. 030-6355731

PGP-key:
http://www.ic-s.nl/keys/ilja.txt
(Continue reading)

Permalink | Reply | 0 comments |
headers
Ilja Booij | 5 Jan 2004 11:04
Picon

Re: SV: Fix for wrong internal date

Done :)

The changes are in CVS (in both 1.2 and 2.0) and I've made a DBMail 
1.2.2 release, which can be found on www.dbmail.org, using the fix.

Bret, thanks for finding the problem so quickly.

Ilja

On 30 Dec 2003, at 21:41, Mikael Syska wrote:

> Will the team behind DBMail make a patch to the 1.2 source???
>
> -----Oprindelig meddelelse-----
> Fra: dbmail-admin <at> dbmail.org [mailto:dbmail-admin <at> dbmail.org] På vegne 
> af
> Bret Baptist
> Sendt: 30. december 2003 16:00
> Til: dbmail <at> dbmail.org
> Emne: [Dbmail] Fix for wrong internal date
>
> This code uses the next year of this current week if the last week of 
> the
> year:
> strftime(timestr, sizeof(timestr), "%G-%m-%d %H:%M:%S", &tm);
>
>
> This code will always use the current year:
> strftime(timestr, sizeof(timestr), "%Y-%m-%d %H:%M:%S", &tm);
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Eelco van Beek - IC&S | 5 Jan 2004 20:25
Picon

Native dbmail mail client

Hi All,

I want to create a native dbmail client. Not a webbased client but a 
full e-mail application for both windows and os X. My main problem is 
authentication. Since i won't be using pop or imap i don't really know 
how to handle authentication. The MySQL authentication meganism won't 
suffice since it only authenticates on Tables, not on rows..

I've been thinking about this for quite a long time but i don't see a 
real solution (except to create an intermediate language. The problem 
with that is that some new wheels are needed to be re-invented..).

Anybody?

Best regards,

Eelco

_________________________
E.J.A. van Beek
ICT Manager
IC&S
T: +31 30 6355730
F: +31 30 6355731

PGP-key:
www.ic-s.nl/keys/eelco.txt
Permalink | Reply | 8 comments |
headers
Micah | 5 Jan 2004 20:51

Re: Native dbmail mail client


I don't see how it's possible without writing a server daemon that has access 
to the database. Otherwise the client will have access to everyone's mail. 

Once you start doing that, you're almost reinventing the wheel, so why bother? 
I would bet if you gave it some thought you could make a server that was 
faster than pop or imap, but is it worth it? 

What about including some dbmail specific commands for the existing pop server 
that would take advantage of capabilities of the system. Your client could 
use them, but the overall server would still be compatible with the pop 
standard (or IMAP for that matter..) 

my half a cent..
-Micah

On Mon January 05 2004 11:25 am, Eelco van Beek - IC&S wrote:
> Hi All,
>
> I want to create a native dbmail client. Not a webbased client but a
> full e-mail application for both windows and os X. My main problem is
> authentication. Since i won't be using pop or imap i don't really know
> how to handle authentication. The MySQL authentication meganism won't
> suffice since it only authenticates on Tables, not on rows..
>
> I've been thinking about this for quite a long time but i don't see a
> real solution (except to create an intermediate language. The problem
> with that is that some new wheels are needed to be re-invented..).
>
> Anybody?
(Continue reading)

Permalink | Reply | 2 comments |
headers
Jesse Norell | 5 Jan 2004 20:58
Favicon
Gravatar

RE: Native dbmail mail client


Hello,

  The only solutions I can think of involve having an authentication
daemon somewhere (probably on the database server).  Aaron's daemon
to handle saving sieve scripts would have to handle this same thing,
and potentially other things down the road, too.  It'd need to tie
into the current auth system to support ldap authentication, etc.

---- Original Message ----
From: Eelco van Beek - IC&S <dbmail <at> dbmail.org>
To: dbmail <at> dbmail.org
Subject: [Dbmail] Native dbmail mail client
Sent: Mon, 5 Jan 2004 20:25:41 +0100

> Hi All,
> 
> I want to create a native dbmail client. Not a webbased client but a 
> full e-mail application for both windows and os X. My main problem is 
> authentication. Since i won't be using pop or imap i don't really know 
> how to handle authentication. The MySQL authentication meganism won't 
> suffice since it only authenticates on Tables, not on rows..
> 
> I've been thinking about this for quite a long time but i don't see a 
> real solution (except to create an intermediate language. The problem 
> with that is that some new wheels are needed to be re-invented..).
> 
> Anybody?
> 
> Best regards,
(Continue reading)

Permalink | Reply | 0 comments |

Gmane