Hi,
Having some trouble with IMAP and DBmail 1.2.2.
Connecting to IMAP with any of the M$ Outlook variants fail.
SquirrelMail (webmail) works, but IMAP Folders does not.
Any ideas as to what might be wrong?
POP3 works a dream tho.
Regards,
John
Ok,
Found the problem.
^^...$$ in the selects.
Following patch fixes it.
---
diff -ruN dbmail_1_2_2/pgsql/dbpgsql.c dbmail-1.2.2/pgsql/dbpgsql.c
--- dbmail_1_2_2/pgsql/dbpgsql.cMon Jan 5 06:48:41 20
Install Dbmail 1.2.3
It contains a fix that solves this problem
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of SaPeR
Sent: Thursday, January 29, 2004 11:23 PM
To: dbmail@dbmail.org
Subject: [Dbmail] dbmail and squirrelmail
i've installed dbmail 1.2.1 a
My immediate attention is at #5 0x0804c81a in trace (level=5,
formatstring=0x807119a "%s,%s: executing query [%s]") at debug.c:93
Line 93 is a call to vsyslog.
My guess is that argp is null or even worse, uninitialised.
Try adding an if(argp) before using argp like this:
void trace (int level, c
Where can I put the dbmail 2.0rc1 debian packages?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens
Sent: Sunday, February 01, 2004 7:55 PM
To: dbmail@dbmail.org
Subject: Re: SV: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x
Here they are,
http://www.oztralis.com.au/bin/dbmail_2.0rc1-1.tar.gz
it may or may not work
I have not tested it as I haven't got a test box at present.
The package builds tho.
... John
About aliases,
Is it possible for dbmail to have one alias expand to several
destinations, eg. mailinglists?
Sort of like the aliases entry: list: user1,user2,user3,.
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Roel Rozendaal - IC&S
Se
izzas from Domino's to
be delivered to his house. Spammers are fecal matter.
--t
Quoth John Hansen:
> About aliases,
>
> Is it possible for dbmail to have one alias expand to several
> destinations, eg. mailinglists?
>
> Sort of like the aliases entry: list: user1,use
+a [EMAIL PROTECTED]
(see man dbmail-adduser for more info)
regards roel
Op 7-feb-04 om 11:23 heeft John Hansen het volgende geschreven:
> Cool, now the question is how?
>
> Seems alias in the db is a unique key, so it can't contain duplicates,
>
> Should deliver-to th
2 (alias_idnr)
>
>
> seems like pretty redundant to me.
>
>
> John Hansen wrote:
>> From dbmail 1.2.3, from create_tables.pgsql:
>> CREATE SEQUENCE alias_idnr_seq;
>> CREATE TABLE aliases (
>> alias_idnr INT8 DEFAULT nextval('alias_idnr_seq'),
Also, what on earth is the config table used for?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
John Hansen
Sent: Monday, February 09, 2004 7:05 AM
To: dbmail@dbmail.org
Subject: RE: Unique keys (was Re: [Dbmail] Does DBmail support spam-,
virus-filter
Got another question too,
With the aliases table, it doesn't seem to work like the aliases file,
eg:
/etc/aliases contains:
postmaster: root
webmaster: root
root: admin
admin: john
If I transfer these directly, it doesn't seem to work.
Only if
what seems to be the problem?
Bear in mind that dbmail is not an MTA, it relies on an MTA like
PostFIX.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Marc Hultquist
Sent: Monday, February 09, 2004 8:29 PM
To: DBMail
Subject: [Dbmail] Anyone ?
Is an
smtp -d `strip-domain.sh ${recipient}`
though i'm not sure if postfix will support this method; if not you can
use a wrapper-script for dbmail-smtp performing the stripping you need.
regards roel
Op 9-feb-04 om 10:25 heeft John Hansen het volgende geschreven:
> Got another question too
Can't say I have.
Using TWIG myself.
Just as fast as Squirrelmail, and just as easy to customize...
Give it a go!
Note, that the SQL script for TWIG/PG is broken tho.
All the SID and LID columns need to be enclosed in double quotes.
... John
-Original Message-
From: [EMAIL PROTECTE
some (chinese) emails fail to inject.
db_query(): executing query [INSERT I
NTO messageblks(messageblk,blocksize,message_idnr) VALUES
('
<84>h
<9E><9F>
V <9E><83>
Feb 18 15:20:51 oztralis dbmail/smtp[846]: db_query(): Error executing
query []
: [ERROR: Unicode characters greater than
ch to
postgresql.
John Hansen wrote:
> some (chinese) emails fail to inject.
>
> db_query(): executing query [INSERT I
> NTO messageblks(messageblk,blocksize,message_idnr) VALUES
> ('
>
> <84>h
>
<9E><9F>
> V <9E><83>
>
David,. Could you point me to where I can download these patches?
... John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of David
Sent: Friday, February 20, 2004 7:52 PM
To: dbmail@dbmail.org
Subject: [Dbmail] Using transport map for $mydestination
Hi, s
Probably a bug from being ported to postgres, as mysql is not case
sensitive, but postgresql is.
As such, all comparisons in where clauses should be cast using lower()
on both sides of the comparison sign. Or in the case of LIKE, use ILIKE.
Regards,
John
-Original Message-
From: [EMAIL
] On Behalf
Of Ilja Booij
Sent: Wednesday, March 03, 2004 8:47 PM
To: dbmail@dbmail.org
Subject: Re: [Dbmail] CAP domain results in "no such user" mail bounce
We can't use ILIKE, as it's not supported by MySQL. It's also not a part
of SQL92, is it? I'll look for a way around
", which should always be case insensitive.
Case insensitivity is limited to aliases (including domain aliases) and
usernames, I guess.
Ilja
John Hansen wrote:
> I'm confused, aren't the sql queries defined in each backend
driver?
>
> If not,
> lower(column)=lower("
nd we use.
any opinions?
Ilja
John Hansen wrote:
> Ilja,
>
> If you wan't RFC'ism, you should put code in the software to do the
> comparison, not in the SQL, mysql is not case sensitive,. So on mysql
> dbmail would not conform to the RFC in this case.
>
> ... John
That cast method is not valid in postgresql however
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Magnus Sundberg
Sent: Thursday, March 04, 2004 12:17 AM
To: dbmail@dbmail.org
Subject: Re: [Dbmail] CAP domain results in "no such user" mail bounce
Ilja
ently, mailboxes are case sensitive when using
>>> PostgreSQL, and case insensitive when using MySQL. This might not be
>>> what we want. We would probably like to have case sensitivity to be
>>> consistent, whichever database backend we use.
>>>
>>> any opinion
SQL. This might not be what we
>> want. We would probably like to have case sensitivity to be
>> consistent, whichever database backend we use.
>>
>> any opinions?
>>
>> Ilja
>>
>> John Hansen wrote:
>>
>>
>>> Ilja,
>>&g
l.org
Subject: Re: [Dbmail] CAP domain results in "no such user" mail bounce
Hi
John Hansen wrote:
> Ok,...
>
> In mysql you only need an index on column. It does not need an index
> on
> lower(column) as it will still use the index, so that's good news, no?
Problem
Yes,. And it's bloody annoying.
Is there anything that can be done about these bounces?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Beaudoin
Sent: Friday, March 05, 2004 11:31 AM
To: dbmail@dbmail.org
Subject: [Dbmail] Every time i send a
ower(alias).
Problem solved, I guess?
John, thanks for finding this out :)
Ilja
John Hansen wrote:
>>Problem is that MySQL will not use the index if the query says
>
> 'lower(column)'.
>
> mysql> explain sel
Wouldn't that in effect move the /etc/aliases functionality to dbmail?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ilja Booij
Sent: Friday, March 05, 2004 9:45 PM
To: dbmail@dbmail.org
Subject: Re: [Dbmail] CAP domain results in
Jesse Norell wrote:
Spammers in general should be sent to prison, and made to spend their entire
sentence with lonely men who's had their penis enlarged.
Hehe
... John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Weber
Sent: Thursday, March 11, 2004 10:52 PM
To: db
On Tue, 2004-06-22 at 08:37, Leonel Nunez wrote:
> On Sun, 2004-06-20 at 17:24, [EMAIL PROTECTED] wrote:
> > Is there a preferred version of Linux to run dbmail on? My first choice
> > was Red Hat until they went commercial. So now I'm wondering Fedora,
> > SUSE, Debian, Mandrake, etc. I imagine th
Earlier a thread was started regarding an nntp frontend to the dbmail
system.
Is there any progress on this or has it been canned?
I think it would make a great addition to dbmail for mailing lists and
small newsfeeds.
... John
Hi,
When using getmail to fetch messages via pop3, I've noticed that it
always fetches mail in descending date order. Is there any reason why
they're not fetched in ascending date order?
... John
The download link on the site is missing the .tgz extension.
Also, paul, when will the .deb packages be ready :)
... John
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ilja Booij
> Sent: Friday, October 15, 2004 12:07 AM
> To: DBMail mailinglis
policy, etc..
dbmail-users cannot be used to change the status, but has to be done
thru sql queries, and note that the default values has pop3/imap access
disabled completely.
Kind regards,
John Hansen
GeekNET
> I downloaded dbmail webmail and it seemed to be mysql specific. Has
> someone done a version for pg? Sorry to sound stupid but my background is
> CF so it was not immediately clear to me how to edit the php to work with
> pg.
This was actually developed for PostgreSQL, what made you think
otherw
> list.php01006440513307455607517011263 0ustar rootroot session_start();
> mysql_connect("localhost", "dbmail", "DBmail");
> $query = "SELECT a.messageidnr as messageidnr, a.messageblk as
> messageblk, b.messagesize as messagesize, c.maxmail_size FROM
> messageblk a, me
Hi again,...
I seem to have forgotten to actually attach the patch,
so here it is.
... John
diff -ruN dbmail-2.0.0.orig/auth/authldap.c dbmail-2.0.0/auth/authldap.c
--- dbmail-2.0.0.orig/auth/authldap.c 2004-08-18 19:48:23.0 +1000
+++ dbmail-2.0.0/auth/authldap.c 2004-10-21 10:30:29.
Weren't there going to be a cleanup tool to get rid of old messages no
longer linked from any mailbox?
I did some housekeeping, and still have 300.000+ messageblks, tho only
350 messages.
Also,... Has anyone written a dbmail2mbox tool?
Kind Regards,
John
at mailboxes SLmail uses. I beleive their
> mbx...You might need different flags...I'd suggest using a
> smaller .mbx file and a test dbmail user untill you're sure
> the flags will work right...
>
> John Hansen wrote:
> > Weren't there going to be a cleanup tool
> John,
>
> orphaned messageblks is exactly the sort of stuff dbmail-util
> is supposed to look for.
>
> if dbmail-util -r doesn't clean out those blks, we have a bug.
>
It did not... :(
Note however, that all these orphaned messages are from deleted
mailboxes.
... john
>
> > Useful for temporarily disabling a mailbox, so that mail is still
> > delivered to it, but the user has no access to it.
>
> Just a note, this reminds me of a discussion on #dbmail
> about 2 years back over exactly this issue - there was an ISP
> who prevented a user from downloading t
Hi
Attached the file from the postfix queue.
This email is failing delivery thru dbmail-smtp
second attachment, mail.log excerpt.
Kind regards,
John Hansen
A750E604A36
Description: Binary data
Oct 22 14:04:39 ns1 postfix/qmgr[516]: A750E604A36: from=<[EMAIL PROTECTED]>, size=6675, n
Paul,
> I've tested insertion of your message using dbmail-2.0.0. No
> problem there.
> Without TRACE_LEVEL=5 your mail.log is not very informative.
> Could be anything from a problem in the message parsing, to a
> user-quota or diskfull error.
Attached, TRACE_LEVEL=5 mail.log excerpt.
... J
Paul,
Any update on this?
> -Original Message-
> From: John Hansen
> Sent: Friday, October 22, 2004 6:15 PM
> To: 'DBMail mailinglist'
> Subject: RE: [Dbmail] failed delivery
>
> Paul,
>
> > I've tested insertion of your message using dbm
> Sorry John,
>
> From the looks of your logs I think it's a dbmail-pgsql
> issue, and I ran across a problem with the debian packages
> for dbmail-pgsql while setting up a test. That has to be fixed first.
Ahh,... What sort of problem,...?
BTW, I had to tell debian/rules to use automake/auto
> That's not an option. The current repository is maintainted
> by mini-dinstall, which means no overhead for me at all. All
> I have to do is run dupload on a freshly build package. And
> it looks like mini-dinstall doesn't provide automatic repositories.
Why not use debarchiver?
... John
Out of curiosity, what did you end up using to generate it?
> Hi there,
>
> For all you debian users of dbmail out there;
>
> I've changed the trivial apt repository on debian.nfgd.net
> into an automatic one.
... John
Ahh,... Sweet,...
> > Out of curiosity, what did you end up using to generate it?
>
> I followed your suggestion :-) Debarchiver does the trick.
... John
> As to disabling accounts, do you wish to block user access, or disable
> mail delivery, or both? For the former I use the UNIX tactic of changing
> the password string to !! and set the type to crypt.
Right, except that if you're managing a system with many users, you
don't wanna be resetting
> Exactly what I was looking for. I am brand spanking new to the linux world.
> How do you apply a patch? I am running debian woody and installed
> dbmail-mysql via apt-get.
apt-get source dbmail-mysql
save patchfile in debian/
dpkg-buildpackage
... John
> Proper support for capabilities is planned, and will be a nice
> solution once there (not just a quick hack). For something trivial
> like this, I would wholeheartedly recommend working within the existing
> code, otherwise you end up having to maintain your own patch sets every
> time you wan
> apt-get source dbmail
> apt-get build-dep dbmail
Thanks for that hint, didnt know about apt-get build-dep :)
... John
53 matches
Mail list logo
