Thanks for the tip...it should work for me since I'm just testing it.
Kevin
On 11/9/05, Leonel Nunez <[EMAIL PROTECTED]> wrote:
>
> K C wrote:
>
> > I tried move a message from one mailbox(non-dbmail) into dbmail box,
> > and that one result sql error. However, the sql statement was
> > truncated in /var/log/maillog that I can't investigate the cause(or
> > potential a bug).
> >
> > Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
> > dbmail/imap4d[4177]: dbpgsql.c,db_query: executing query [SELECT
> > physmessage_id FROM dbmail_messages WHERE message_idnr = '11']
> > Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
> > dbmail/imap4d[4177]: dbpgsql.c,db_query: executing query [INSERT INTO
> > dbmail_messageblks (is_header, messageblk,blocksize, physmessage_id)
> > VALUES ('0','-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 -
> > ---------------------------------------------------------------------
> > PostgreSQL New RPM Set 2005-11-08 Version: 8.1.0 Set labels:
> > 8.1.0-2PGDG -
> > ---------------------------------------------------------------------
> > -
> > ---------------------------------------------------------------------
> > Release Info: PostgreSQL RPM Building Project has released RPMs for
> > 8.1.0, and they are available in main FTP site and its mirrors. We
> > currently have RPMs for: - - Fedora Core 3 - - Fedora Core 4 - -
> > Fedora Core 4-x86_64 - - Red Hat Linux 9 - - Red Hat Enterprise Linux
> > Enterprise Server 3.0 - - Red Hat Enterprise Linux Enterprise Server
> > 4 - - Red Hat Enterprise Linux Enterprise Server 4-x86_64 - - Red Hat
> > Enterprise Linux Advanced Server 4 - - Red Hat Enterprise Linux
> > Advanced Server 4-x86_64 More ma
> > Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
> > dbmail/imap4d[4177]: dbpgsql.c, db_query: Error executing query
> > [INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize,
> > physmessage_id) VALUES ('0','-----BEGIN PGP SIGNED MESSAGE----- Hash:
> > SHA1 -
> > ---------------------------------------------------------------------
> > PostgreSQL New RPM Set 2005-11-08 Version: 8.1.0 Set labels:
> > 8.1.0-2PGDG -
> > ---------------------------------------------------------------------
> > -
> > ---------------------------------------------------------------------
> > Release Info: PostgreSQL RPM Building Project has released RPMs for
> > 8.1.0, and they are available in main FTP site and its mirrors. We
> > currently have RPMs for: - - Fedora Core 3 - - Fedora Core 4 - -
> > Fedora Core 4-x86_64 - - Red Hat Linux 9 - - Red Hat Enterprise Linux
> > Enterprise Server 3.0 - - Red Hat Enterprise Linux Enterprise Server
> > 4 - - Red Hat Enterprise Linux Enterprise Server 4-x86_64 - - Red Hat
> > Enterprise Linux Advanced Server 4 - - Red Hat Enterprise Linux
> > Advanced Server 4-x86_64
> > Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
> > dbmail/imap4d[4177]: db.c,db_insert_message_block: error inserting
> > messageblks for physmessage [6]
> > Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
> > dbmail/imap4d[4177]: pipe.c,store_message_in_blocks:
> > db_insert_message_block() failed
> >
> > Anyway to let maillog retain the full text?
> >
> > Thanks,
> > Kevin
> >
> >------------------------------------------------------------------------
> >
> >_______________________________________________
> >Dbmail mailing list
> >Dbmail@dbmail.org
> >https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >
>
>
> enable loggin on postgresql.conf
>
> but it will slow your database
>
>
> leonel
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
