[Dbmail] Mail filtering to IMAP folders

start doing it by myself... :-) Thanks. -- Andrea Brancatelli http://andrea.brancatelli.it/

Re: [Dbmail] Mail filtering to IMAP folders

iblett email: [EMAIL PROTECTED] > Network AdministratorPhone: (352) 334-3400 > Gainesville Regional Utilities Web: http://www.gru.net/ > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Andrea

Re: [Dbmail] help! :) --> dbmysql.c, db_query: mysql_real_query failed: Cannot add or update achild row:aforeign key constraint fails

Hello Mike, ok, I'll try to be a little more clear on the timeline :-) The server we are talking about (reddevil) used to have something like 40 domains on it... Now I have another server and I moved about a dozen of domains from that server to another one. I run fetchmail from the new server to

Re: [Dbmail] help! :) --> dbmysql.c, db_query: mysql_real_query failed: Cannot add or update achild row:aforeign key constraint fails

obviously i mean dbmail-users -d when I'm talking about deleting users... In data 28/2/2006, "Andrea Brancatelli" <[EMAIL PROTECTED]> ha scritto: >Hello Mike, > >ok, I'll try to be a little more clear on the timeline :-) > >The server we are talking abo

[Dbmail] Errors

Some users have been reporting errors with their mail since a while, today I sneeked a look and found this: May 9 14:08:31 carota dbmail/smtp[363]: Error [Cannot delete or update a parent row: a foreign key constraint fails (`dbmail`.`dbmail_datefield`, CONSTRAINT `dbmail_datefield_ibfk_1` FOR

[Dbmail] My previous mail... ?

Anyone read my previous mail with title "Error"? Any hints? Is my message base exploding? Thanks... Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Errors

critto: Please log into your database with psql on the command line, and post back the output of '\d dbmail_datefield'. I suspect that you might be missing the "ON UPDATE CASCADE ON DELETE CASCADE" part of the foreign key definition. Aaron On Wed, 2007-05-09 at 14:22 +020

Re: [Dbmail] Errors

r database with psql on the command line, and post back the output of '\d dbmail_datefield'. I suspect that you might be missing the "ON UPDATE CASCADE ON DELETE CASCADE" part of the foreign key definition. Aaron On Wed, 2007-05-09 at 14:22 +0200, Andrea Brancatelli wrote:

Re: [Dbmail] Errors

y definition. Aaron On Wed, 2007-05-09 at 14:22 +0200, Andrea Brancatelli wrote: Some users have been reporting errors with their mail since a while, today I sneeked a look and found this: May 9 14:08:31 carota dbmail/smtp[363]: Error [Cannot delete or update a parent row: a foreign key const

Re: [Dbmail] Errors

f '\d dbmail_datefield'. I suspect that you might be missing the "ON UPDATE CASCADE ON DELETE CASCADE" part of the foreign key definition. Aaron On Wed, 2007-05-09 at 14:22 +0200, Andrea Brancatelli wrote: Some users have been reporting errors with their mail since a while, t

Re: [Dbmail] Errors

tables are missing the on update cascade on delete cascade... I'll start to fix them manually... Maybe dbmail-util should check (and maybe fix) this? Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fast

Re: [Dbmail] Errors

I can't really get beyond this problem now... HELP! :-) Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Errors

Thank you very much Aaron. I finally did the script by myself but your's much better :-) Thanks anyhow... Il giorno 14/mag/07, alle ore 18:48, Aaron Stone ha scritto: Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list D

[Dbmail] Ok another problem :-)

ror could not update user login time Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Ok another problem :-)

ng 4/5/6 concurrent imap connections with the same user. Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] I got it

. I'm investigating on this... Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

[Dbmail] Shared folder

What happens if I manually enforce two different mailboxes to reference the same (IMAP) folder? Is it actually techically possible? Will it work? Thanks :-) ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Invalid message range specified

The very same thing happens to me with a much older version... (2.2.4) Usually if I just close and reopen Outlook it works. In data 27/5/2007, "Jorge Bastos" <[EMAIL PROTECTED]> ha scritto: >Or sometimes, when i go to select the new message, OE gives me >"Message is no longer available on the se

Re: [Dbmail] Invalid message range specified

As I said it's happening to me too but I'm using Outlook from Office XP, not Outlook Express. It started happening after the upgrade from 2.2.2 to 2.2.4. In data 27/5/2007, "Paul J Stevens" <[EMAIL PROTECTED]> ha scritto: > >I keep hitting Send/Recv, Purge, and F5 while messages come in, and all

Re: [Dbmail] Invalid message range specified

Il giorno 28/mag/07, alle ore 09:10, Paul J Stevens ha scritto: Andrea Brancatelli wrote: As I said it's happening to me too but I'm using Outlook from Office XP, not Outlook Express. It started happening after the upgrade from 2.2.2 to 2.2.4. Outlook Office is no longer an issue i

[Dbmail] Here we go again

Nobody changed anything on the DB in the latest week but here we are again: May 31 17:49:34 carota dbmail/smtp[69105]: Error [Cannot delete or update a parent row: a foreign key constraint fails (`dbmail`.`dbmail_datefield`, CONSTRAINT `dbmail_datefield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFER

Re: [Dbmail] Here we go again

y to do with multi-byte >characters?, that ended up dropping their constraints. > >Although, as you mention it happened "again", I wonder if it's you that >I was thinking of? :) If so, wasn't your problem some 3rd party >program last time? > > >On Thu,

R: [Dbmail] Here we go again

Donnerstag, 31. Mai 2007 Andrea Brancatelli wrote: > I'm not using any guy. That's good, as that could be forbidden in your country ;-) SCNR mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.idea

R: [Dbmail] Here we go again

ything else writing to it. -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Paul J Stevens Inviato: giovedì 31 maggio 2007 23.56 A: DBMail mailinglist Oggetto: Re: [Dbmail] Here we go again Andrea Brancatelli wrote: > No, it wasn't me. I had the proble

Re: R: [Dbmail] Here we go again

e versioning. I supposed the 5.1 beta to become a stable version somewhen... but it seems not. I'll update it and let you know. Il giorno 01/giu/07, alle ore 09:42, Paul J Stevens ha scritto: Andrea Brancatelli wrote: Yup, the cascades are gone again. I'm attaching to the mail

[Dbmail] SQlite

I read somewhere that DBMail supports SQlite. Is it stable? How can I switch from mysql to SQlite? Would it be terribly slower? Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman

[Dbmail] ...

Upgraded mysql to 5.1.18, reapplied all the constraints. We'll se what happens now. Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

[Dbmail] Just a question

Would it be terribly complex to write some query to delete the garbage that has been left behind by the broken cascades? Andrea Brancatelli [EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo

[Dbmail] Still headbanging

I'm still freaking out, but this time the problems isn't the message base (at least I hope). When I login using Mac OS X's Mail in IMAP after just a few minutes the account becomes unavailable. I have to accounts on the same server. Sometimes one is available and the other isnt', some time the ot

Re: [Dbmail] Still headbanging

No probably it's just make && make install anyway, the "problem" are the dependencies between different software and future upgrade, so, no, I will wait. Hopefully it should come out pretty soon. Il giorno 04/giu/07, alle ore 16:57, Paul J Stevens ha scritto: Andrea

R: [Dbmail] Anybody using RoundCube

The problem I had (in the past) with roundcube and dbmail was that roundcube was asking for a command that dbmail did not understand. But we’re talking about ages ago. Like one year. _ Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di zamri Inviato: venerdì 8 giugno 2007 9.3

[Dbmail] ???

I have an user who had a lot of mail, and it suddenly disappeared and this is strange, i think: [/var/[EMAIL PROTECTED] #dbmail-users -l [EMAIL PROTECTED] [EMAIL PROTECTED]:x:34:0:256.00:62.61: [/var/[EMAIL PROTECTED] #telnet 127.0.0.1 110 Trying 127.0.0.1... Connected to localhost.branc

Re: [Dbmail] ???

ave any physmessages. And then? If restoring his messages requires less than 3 minutes it's ok, if it requires more than that I'm just interested in fixing his quota and cleaning up a bit the DB!! Andrea Brancatelli [EMAIL PROTECTED] Raged Records s.r.

Re: [Dbmail] ???

cked. IIRC this is the default for Thunderbird. If he was deleting his mail then his quota would be 0%. BTW he's using IlohaMail, our webmail. Andrea Brancatelli [EMAIL PROTECTED] Raged Records s.r.l. http://www.ragedrecords.com/ ___ DBma

Re: [Dbmail] ???

bout his mails :-) but he obviously do. But I don't care much about him (and what he cares) too. Clear enough? ;-) Andrea Brancatelli [EMAIL PROTECTED] Raged Records s.r.l. http://www.ragedrecords.com/ ___ DBmail mailing list DBmail@dbmail.org htt

Re: [Dbmail] ???

his mail disappear after not checking it for more than 3 weeks I'm way more worried about my customers, that's why I'm asking. Andrea Brancatelli ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

R: [Dbmail] Help on scoreboard

This is gold! Why is it undocumented!? (is it undocumented?) -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Aaron Stone Inviato: venerdì 13 luglio 2007 19.32 A: DBMail mailinglist Oggetto: Re: [Dbmail] Help on scoreboard On Fri, Jul 13, 2007, Paul J Ste

[Dbmail] About MySQL/InnoDB: May be very interesting

This document may be very interesting to many of us: http://www.innodb.com/wp/wp-content/uploads/2007/05/uc2007-innodb-performanc e-optimization.pdf it's an official optimization guide for InnoDB over

R: [Dbmail] Table dbmail_messages is full

I strongly suggest you to use the innodb_file_per_table and to run an optimize table dbmail_messages (and not only, also the others) from time to time to free some disk space. ciaociao -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Sascha Braun Inviato:

R: R: [Dbmail] Table dbmail_messages is full

o innodb. Curtis Andrea Brancatelli wrote: > I strongly suggest you to use the innodb_file_per_table and to run an > optimize table dbmail_messages (and not only, also the others) from time > to > time to free some disk space. > > ciaociao > > -Messaggio originale-

R: [Dbmail] Changelog

First of all I'd install an english copy of pgsql :-) Eheh sorry just joking but I couldn't resist... :- -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Michael Monnerie Inviato: martedì 31 luglio 2007 16.30 A: DBMail mailinglist Oggetto: Re: [Dbmail

R: [Dbmail] Advantages of innodb_file_per_table (was: Table dbmail_messages is full)

I partially explained in my last email. Let me try to summarize everything. WITHOUT innodb_file_per_table: - you have one shared tablespace for all the tables. This gives you the advantage of limiting the space your db will be using (unless you activate the autoextend) but give you the disadvan

R: [Dbmail] Advantages of innodb_file_per_table (was: Tabledbmail_messages is full)

EMAIL PROTECTED] Per conto di Andrea Brancatelli Inviato: martedì 31 luglio 2007 17.16 A: 'DBMail mailinglist' Oggetto: R: [Dbmail] Advantages of innodb_file_per_table (was: Tabledbmail_messages is full) I partially explained in my last email. Let me try to summarize everyt

R: R: [Dbmail] Advantages of innodb_file_per_table (was:

a FAQ, and the bits of information we do have about it are scattered all over the place. Aaron On Tue, Jul 31, 2007, Andrea Brancatelli <[EMAIL PROTECTED]> said: > Just an addendum. > > With innodb_file_per_table whenever you delete a table or a database, the > whole .idb f

R: R: [Dbmail] Advantages of innodb_file_per_table (was:Table dbmail_messages is full)

are like balls: everyone's got their own. -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Peter Rabbitson Inviato: martedì 31 luglio 2007 22.26 A: DBMail mailinglist Oggetto: Re: R: [Dbmail] Advantages of innodb_file_per_table (was:Table dbmai

R: R: R: [Dbmail] Advantages of innodb_file_per_table (was:

martedì 31 luglio 2007 23.12 A: DBMail mailinglist Oggetto: Re: R: R: [Dbmail] Advantages of innodb_file_per_table (was: Thanks! Ok, will do :-) On Tue, Jul 31, 2007, Andrea Brancatelli <[EMAIL PROTECTED]> said: > Ok, i'll write some more rants about optimizing innodb tomorrow if

R: R: R: [Dbmail] Table dbmail_messages is full

No, no, no, when I said trash it I didn’t mean delete it! The shared tablespace still contains the table definitions, thus it still needs to exist. Shrinking it is a really complicate matter, if it’s not really big I suggest you to leave it just like that. _ Da: [EMAIL PROTECTED] [

RE: [Dbmail] Db growing size

Il giorno dom, 03/08/2008 alle 13.03 +0100, Jorge Bastos ha scritto: > I'm not whining! You're having a wrong point of view from me. Yes but you still haven't run an optimize table on all the tables in the dbmail database. I dont' know why you talk about locking during the optimize table but my

RE: [Dbmail] Db growing size

Il giorno dom, 03/08/2008 alle 18.29 +0100, Jorge Bastos ha scritto: > It wasn’t me who talked about tabled being locked during optimize > Andrea, > Yes, but we all know English is a poor language and that is a limitation of the "you" word. I wasn't talking about YOU but about YOU (all of you) e

[Dbmail] IMAP folders

Hello everybody, altough I understand very well that this is not a dbmail issue and I also know why it's happening, I was wondering is there's something dbmail could implement to avoid the common problem of having duplicated folders when using different mail client. For example here on this comp

[Dbmail] IMAP and multiple sessions

Hello everybody. I have a small problem here and maybe some of you can help me. There are a few persons here at my company who bought an iPhone and promptly switched to POP3 to IMAP in order to keep their mailboxes in sync between the phone and their pc. Now the problem is that sometimes one

Re: [Dbmail] Imap Sync

Il giorno ven, 09/01/2009 alle 10.03 +, Jorge Bastos ha scritto: > one dbmail imap in a place, where the users will be around 20 users > accessing just one account. > In this server must exist a tool, so synchronize all email in this > email, with another imap server, for example 5 in 5 minute

RE: [Dbmail] Imap Sync

Il giorno ven, 09/01/2009 alle 12.42 +, Jorge Bastos ha scritto: > Thanks for the answer shane, but no, i don't want to use the same BD. > Just want to synchronize a particular account, on both sides Mmm then I didn't understand... :-) <>___ DBmail

Re: [Dbmail] Performance, IMAP backend, etc.

Il giorno ven, 23/01/2009 alle 07.33 +1100, Dan ha scritto: > > With power like that, all you really need locally is a front-end. No? > I use RoundCube ( http://roundcube.net/ ) . It caches things in a database I have big problems using roundcube with DBMail. Haven't you ever experienced hangs

Re: [Dbmail] why...?

Il giorno dom, 29/03/2009 alle 14.53 +0200, Paul J Stevens ha scritto: > > 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, > > datefield) VALUES (467171,'1970-01-01 00:00:00')] > > How do I fix this? dbmail-util doesn't fix it in any way. > Remove the entries that are in the wa

Re: [Dbmail] /tmp full

Il giorno 23/apr/09, alle ore 15:37, Guntis Bumburs ha scritto: > I can resolve them by restarting dbmail -imap daemon and there will be > no need to run fsck because by restarting dbmail i solve unref files Restarting dbmail-imapd doesn't resolve anything on my machine, I have to restart mysq

Re: [Dbmail] /tmp full

Just to clarify I have at least three different FreeBSD + DBMail server under hands and it happens regulary in all three of them. FreeBSD 6.0 on one, 6.2 on the other and 7.0 on the latter. Different levels of mysql, different levels of dbmail. Lowering Maxconnect in the past didn't solve the

Re: [Dbmail] /tmp full

it happens to me too from freebsd 6.0 'till today. I'm doing a 2GB /tmp on every dbmail server now and sometime i restart mysql. It's not dbmail the problem, it's mysql. It you restart mysql, even without restartin dbmail, everything fixes. But it only happens with dbmail, so i would say it'

Re: [Dbmail] /tmp full

Il giorno 23/apr/09, alle ore 07:26, Anatoly ha scritto: >> > fsck /tmp > -- Useless. It happens on fresh volumes as well ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] /tmp full

Il giorno lun, 27/04/2009 alle 08.14 +1000, Josh Marshall ha scritto: > What I noticed is that running du -hs on the drive shows that there is > plenty of space free, so I'm thinking that somewhere a temporary file is > being deleted while still open and being written to. So the file listing > ent

Re: [Dbmail] /tmp full

litio# df -h Filesystem SizeUsed Avail Capacity Mounted on /dev/ad1s1a1.9G1.1G670M63%/tmp litio# /usr/local/etc/rc.d/dbmail-imapd restart Stopping dbmail_imapd. Waiting for PIDS: 78180, 78180. Starting dbmail_imapd. litio# df -h Filesystem SizeUsed Avail C

[Dbmail] Version

Now, that's funny :-) [r...@mirtillo ~]# pkg_info | grep dbmail dbmail-2.3.6An SQL database-based mail system (POP3 and IMAP) [r...@mirtillo ~]# dbmail-imapd -V This is DBMail version 0.9.9 Is this "correct"? :-) ___ DBmail mailing list DBmail@

Re: [Dbmail] Which spam filtering package do you think is best?

Propor calm down. I'm using greylisting since ages and have no problem with gmail and such. Google uses mailnly 2, maybe 3 IPs. Mails may sometime arrive a bit later, it's true but it's not a serious issue... Andrea Brancatelli Inviato da iPad Il giorno 30/dic/2010, alle or

[Dbmail] Problem with dbmail-lmtp

taking all this memory? The server is not very privacy-critical so, Paul if you are curious to investigate deeper I can also give you ssh access to the machine. Andrea Brancatelli ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/m

Re: [Dbmail] not seen message in Thunderbird

e moved to google services for domain on that particular customer. There are things you have to watch out, like auto increment offset and such, but it's not rocket science... (and have an automated monitoring script that halts everything if replication goes out sync!!) Andrea Brancatelli

Re: [Dbmail] Problem with dbmail-lmtp

Unfortunately 2.3.6 is the lastest one in freebsd's tree: http://www.freebsd.org/cgi/ports.cgi?query=dbmail&stype=all How comes 2.3.0-rc2 being newer than 2.3.6? :-) Am I missing something? On Thu, Feb 24, 2011 at 10:24 AM, Paul J Stevens wrote: > On 02/24/2011 02:14 AM, Andrea

Re: [Dbmail] mail migration between two dbmail hosts

maybe something like: dbmail-users -l | grep domain.com | cut -d ':' -f 1 | while read a; do dbmail-export -u $a -o $a.mbox; done On Thu, Feb 24, 2011 at 12:35 PM, Anatoly wrote: > fp wrote: > >> On 24.02.2011 11:21, Anatoly wrote: >> >>> admin wrote: >>> Hello! I wonder if th

Re: [Dbmail] not seen message in Thunderbird

Il giorno 24/feb/2011, alle ore 18:39, Paul J Stevens ha scritto: > On 02/24/2011 10:35 AM, Andrea Brancatelli wrote: >> Pardon me but if you write only on one node the it's not multi master >> :-) > > Even if it's not *used* as multi-master, it can still be *

Re: [Dbmail] MySQL Cluster Support

This topic is very interesting to me, so please keep the list updated! My previuos experiments (not DBMail-related, I must say) with NDB wasn't really good. I tried to "clusterize" a standard application without very good results, so instead I switched to standard circular replication + auto_incre

[Dbmail] Mem Leak?

Hello everybody, I'm struggling with a dbmail instance that after a couple of days of usage gets terribly slow. At first I was looking at the db, the server itself but couldn't find anything reasonable. Today I realized the dbmail-imapd was allocating 800MB of Ram. The server is not so loaded (

Re: [Dbmail] Mem Leak?

Thanks. Unfortunately 3.1.13 hasn't been received yet in freebsd's ports. I'll apply the nightly restart and will take a look at dovecot in the meantime.. Thanks. Andrea "Mr.SK" Brancatelli > On 08/apr/2014, at 20:39, Paul J Stevens wrote: > > >> On

Re: [Dbmail] Mem Leak?

You’re right: sorry, the machine was built a couple of weeks ago. I suppose you meant 23 march ;-) I'm upgrading it right now. --- Andrea Brancatelli Il giorno 09/apr/2014, alle ore 10:17, Alan Hicks ha scritto: > DBMail 3.1.13 has been available in ports since 23 May 2014. You s

[Dbmail] Sieve / Spam folder

I'm a bit confused after googling around: has "global sieve" (read, a default sieve for all the user) been implemented in dbmail? I would like to send mail marked as Spam by Spamassassin into a sub folder for each user called Spam. Do any of you do this? How? My best shot would be a sieve scrip

Re: [Dbmail] Sieve / Spam folder

delete it. > > Please correct me if I am wrong. > > Christian > > >> Am 01.05.2014 um 02:12 schrieb Andrea Brancatelli : >> >> I'm a bit confused after googling around: has "global sieve" (read, a >> default sieve for all the user) been

Re: [Dbmail] Sieve / Spam folder

.de > > NovaTec Consulting GmbH > Dieselstrasse 18/1 - D-70771 Leinfelden-Echterdingen > > > > Sitz der Gesellschaft: > > Waldenbuch > > Handelsregister: > > Stuttgart – HRB 739078 > > Geschäftsführer: > > Hans-Dieter Brenner – Michael Schuc

[Dbmail] Stupid question on dbmail-users ;)

Hello everybody Is there an option for dbmail-users to have listed only real users and not forwards? Maybe dbmail-users -lr (real users) / -lf (forwards)... --- Andrea Brancatelli Schema 31 S.r.l. Socio Unico Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell

Re: [Dbmail] Feedback from 3.1.13

3.1.13 is pretty stable here! --- Andrea Brancatelli Schema 31 S.r.l. Socio Unico Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax: +39. 055.71.880.466 Società del Gruppo SC31 ITALIA Il giorno 07/mag/2014, alle ore 10:30, Jorge Bastos ha

[Dbmail] dbmail wiki

Hello. I’d like to make an update to the sendmail - dbmail integration on freebsd but either I can’t login on the wiki itself (there’s no “password lost?” link?) or maybe there no public editing? Should I send the updated text to someone…? Thanks. --- Andrea Brancatelli

Re: [Dbmail] dbmail wiki

On 16/mag/2014, at 21:03, Paul J Stevens wrote: > I can add you to the list of users if you like. Yes please, there's a couple of thing that needs update, both on the Sendmail and the Freebsd scenario. ___ DBmail mailing list DBmail@dbmail.org http://

[Dbmail] Imap idle

Hello What are the pro and cons of enabling (or disabling) IMAP idle? I have a problem with Mac OS X mail falling asleep with the IMAP session. You press "fetch mail", nothing happens. You close mail and reopen it and dozens of mail appear. Maybe that could be a workaround? What about general

Re: [Dbmail] Imap idle

x from the iPad, deleting stuff at the same time from the smartphone and why not looking at the mailbox from roundcube... Unfortunately I don't have an exact pattern, tho... Andrea "Mr.SK" Brancatelli > On 31/mag/2014, at 10:36, Paul J Stevens wrote: > >> On 30-05-14 18

[Dbmail] dbmail freebsd port -> libsieve

from another machine but they were coming from dbmail 3.1.12, I hope I don’t break up everything… ;) --- Andrea Brancatelli ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] dbmail freebsd port -> libsieve

Il giorno 14/giu/2014, alle ore 15:44, Reindl Harald ha scritto: > Am 14.06.2014 15:20, schrieb Andrea Brancatelli: >> Is there any particular reason dbmail’s binary is not compiled with sieve >> support? > > there is no upstream binary but whoever built yours > did d

Re: [Dbmail] dbmail freebsd port -> libsieve

Yes, I know that building from the ports you have the option to enable it, but since FreeBSD is steadily pushing toward binary distributions, it would be probably supercool to have it enabled by default, so that the binary get the option enabled. --- Andrea Brancatelli Schema 31 S.r.l

Re: [Dbmail] dbmail freebsd port -> libsieve

Thank you very much, that would be supercool. --- Andrea Brancatelli Schema 31 S.r.l. Socio Unico Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax: +39. 055.71.880.466 Società del Gruppo SC31 ITALIA Il giorno 15/giu/2014, alle ore 13:41

Re: [Dbmail] Offtopic, again!

we’re using http://radicale.org with some good results, but it’s been just one month, so don’t take it as a full endorsement :) --- Andrea Brancatelli Il giorno 19/lug/2014, alle ore 20:59, Jorge Bastos ha scritto: > Hi guys, > > Sorry for this offtopic once again, > I’m

[Dbmail] what's going on here?

geblks' doesn't exist Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db] db_query(+371): failed query [SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_messageblks b JOIN dbmail_physmessage p ON b.physmessage_id=p.id WHERE b.physmessage_id = 8201117 ORDER BY b.messageblk_idnr] I blanked out the mail addresses bit they are all valid. I’m worried both by the data to long and by the dbmail_messageblks doesn’t exist… ? --- Andrea Brancatelli signature.asc Description: Message signed with OpenPGP using GPGMail ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

[Dbmail] Duplicate messages

Hello. For various reason a big bunch of duplicated messages have been copied with imapsync in our message base We are filtering them with imapfilter searching for duplicated msgid in the same mailbox and it working ok. Obviously it's pretty slow as it's working on the IMAP side of the problem

Re: [Dbmail] what's going on here?

om my iPad > On 22/lug/2014, at 12:35, Reindl Harald wrote: > > > > Am 22.07.2014 12:29, schrieb Andrea Brancatelli: >> Hello, can anybody help me with this output from dbmail-util -ay ? >> >> Dbmail is 3.1.13 > > Jul 22 11:49:44 rubidio.roma.sc dbmail-

[Dbmail] Message body search

ilbox_idnr = 1 AND m.status IN (0,1) AND (v.headervalue LIKE '%gcloud%' OR k.data LIKE BINARY '%gcloud%') ORDER BY m.message_idnr That takes almost 40 seconds to run, enough for RoundCube to timeout (or for the user to get bored). Thanks P.S. Peter: I wrote you a few pr

Re: [Dbmail] Message body search

part? Thus even by touching almost nothing else in the code we could change the “SEARCH” query to search only on text (text, text/html, whatever) parts, not on everything? Thanks. --- Andrea Brancatelli Il giorno 14/set/2014, alle ore 13:23, Andrea Brancatelli ha scritto: > Hello everyb

[Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

Thank you. --- Andrea Brancatelli ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

We tried to switch to 3.2.0 on an older machine but it segfaults the same… Please, we need some help! --- Andrea Brancatelli Schema 31 S.p.a. Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax: +39. 055.71.880.466 Società del Gruppo SC31

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

Sure Paul, I’m sending you privately at your mailbox. Thanks. --  Andrea Brancatelli Schema31 S.p.a. Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax: +39. 055.71.880.466 Società del Gruppo SC31 ITALIA Il giorno 03 gennaio 2015 @ 12:03:02, Paul

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

| 0 | | +---+-+--+-+-++ 13 rows in set (0.02 sec) --- Andrea Brancatelli Schema31 S.p.a. Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax: +39. 055.71.880.466 Società del Gruppo SC31 ITA

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

sr/lib/libssl.so.7 (0x804283000) libcrypto.so.7 => /lib/libcrypto.so.7 (0x8044ee000) libc++.so.1 => /usr/lib/libc++.so.1 (0x8048e1000) libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x804b9c000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x804db6000) I didn't read it but I suppose it to b

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

Hello eveybody. So I was able to get a dbmail-imapd crash while running inside gdb. It run for about 4 hours and served about 380 sessions (from dbmail_authlog) before crashing. I wasn’t able to recompile with symbols yet, but maybe the stack trace can already give you any hint of what’s happe

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

Yes, everything in on AMD64 and built with Clang... FreeBSD is 10.1 --- Andrea Brancatelli Schema31 S.p.a. Il 2015-01-04 16:26 Alan Hicks ha scritto: > Hello Andrea, > > Your libraries glib, gettext-runtime, mhash, libevent2, libzdb, libiconv, > pcre, libffi and mysql56-clie

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

P.S.: Yes, I have IPV6 enabled and working. I'll take a look at the authlog table and maybe just try to disable the authlog function. --- Andrea Brancatelli Schema31 S.p.a. Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax

Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD)

You're right, src_ip and dst_ip are VARCHAR(16), that wouldn't work with an IPV6 Address, but I don't know if this could cause a Segmentation Fault. I guess dbmail_authlog needs tuning anyhow. --- Andrea Brancatelli Schema31 S.p.a. Responsabile IT ROMA - FIRENZE - PALERMO

  1   2   >