Re: [Dbmail] emptying database

2009-06-18 Thread Piotr Wadas
> > Piotr, I'll release 2.3.6 real soon now, which should fix all your issues. Allright, I'll look forward to checkout :) regards, P. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Marc Dirix
Attached the trace.txt I also tried some output tests: If in config.c I put printf("%s\n",port_string); in line 263, it writes "5434" to the command line before the error. Then second try, line 262, I write printf("%d\n",strtoul(port_string, NULL, 10)); which also writes "5434" t

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Paul J Stevens
Marc Dirix wrote: >> strace -o /tmp/trace.txt -ff /usr/sbin/dbmail-timsieved Please do try to provide the lines from a trace leading up to the exit. They should be interesting. -- Paul Stevens

Re: [Dbmail] emptying database

2009-06-18 Thread Paul J Stevens
Jonathan Feally wrote: > A couple extra maybe?? Not too far off. >> dbmail_tofield| 5011 >> > This is about 5x the correct size - this is just a view so nothing can > be deleted from it. This count be close to the fromfield count. Only one > to and from header per message. Nons

Re: [Dbmail] emptying database

2009-06-18 Thread Jonathan Feally
Piotr Wadas wrote: > The count(*) result is zero, anyway rows are still available in mentioned > tables, as listed :/ > Well then it sounds like the tables just need to be shrunk/optimized in postgres. I'm not sure what the syntax is to do that as I'm a mysql guy. -Jon -- Scanned for viruse

Re: [Dbmail] emptying database

2009-06-18 Thread Piotr Wadas
> Try: > select count(*) from dbmail_partlists left join dbmail_physmessage on > (dbmail_physmessage.id=dbmail_partlists.physmessage_id) where > dbmail_physmessage.id is null; > > That should confirm if there are any parts being left there. Count=0 > means no leftovers, Count>0 then there are

Re: [Dbmail] emptying database

2009-06-18 Thread Jonathan Feally
Piotr Wadas wrote: > dbmail_physmessage| 994 > dbmail_fromfield | 994 > These match - that is good - should be one from header for each message > dbmail_envelope | 1057 > A couple extra maybe?? Not too far off. > dbmail_tofield| 5011 > This

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Marc Dirix
Are you perhaps then starting the wrong daemon, or one looking at the wrong dbmail.conf? Try: strace -o /tmp/trace.txt -ff /usr/sbin/dbmail-timsieved grep dbmail.conf /tmp/trace.txt or something similar. I already tried that. There is only one daemon in the path. dbmail-timsieved -V gi

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Paul Stevens
Marc Dirix wrote: > >> >> This means the value specified for sqlport cannot be parsed into a 'long >> long unsigned int'. >> >> Something *must* have changed on your system. >> >> > I did do an debian upgrade, and reinstalled dbmail from the nfg server. > (first tried a downgrade to a manual co

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Marc Dirix
This means the value specified for sqlport cannot be parsed into a 'long long unsigned int'. Something *must* have changed on your system. I did do an debian upgrade, and reinstalled dbmail from the nfg server. (first tried a downgrade to a manual compiled 2.2.10 which introduced the pro

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Marc Dirix
Paul J Stevens schreef: Marc Dirix wrote: Jun 18 12:39:37 gamma dbmail-timsieved[5934]: FATAL:[config] config.c,GetDBParams(+263): wrong value for sqlport in config file This means the value specified for sqlport cannot be parsed into a 'long long unsigned int'. Something *must* hav

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Paul J Stevens
Marc Dirix wrote: > Jun 18 12:39:37 gamma dbmail-timsieved[5934]: FATAL:[config] > config.c,GetDBParams(+263): wrong value for sqlport in config file This means the value specified for sqlport cannot be parsed into a 'long long unsigned int'. Something *must* have changed on your system. --

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Marc Dirix
Hi Paul, I am a bit out of it, this is a level TRACE_STDERR of 5, is that not the highest value? r...@gamma:/var/src/dbmail# dbmail-timsieved Jun 18 12:39:37 gamma dbmail-timsieved[5934]: Debug:[serverparent] serverparent.c,LoadServerConfig(+262): server will create [2] children Jun 18 12:39:37

Re: [Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Paul J Stevens
Marc Dirix wrote: > Hi, > > Although I did not change my config file, now dbmail-timsieved does not > start anymore. > Version: 2.2.11 > It says: > Jun 18 11:40:57 gamma dbmail-timsieved[10118]: FATAL:[config] > config.c,GetDBParams(+263): wrong value for sqlport in config file > failed failed! >

Re: [Dbmail] emptying database

2009-06-18 Thread Paul J Stevens
Jonathan Feally wrote: > Jorge Bastos wrote: >> I think there's something incomplete on that function 'cause when I used the >> git version when that was added, messages were not being completely removed. >> > It might be that we are missing the partlists cleanup. If the parts > aren't being de

[Dbmail] Problem starting dbmail-timsieved

2009-06-18 Thread Marc Dirix
Hi, Although I did not change my config file, now dbmail-timsieved does not start anymore. Version: 2.2.11 It says: Jun 18 11:40:57 gamma dbmail-timsieved[10118]: FATAL:[config] config.c,GetDBParams(+263): wrong value for sqlport in config file failed failed! The database is on a non-default por