Hello everyone, I heard about DBmail on Freshmeat Monday and decided to try it out. It seems to have promise. But I found a few things that I hope will help make using it a bit better. 1. the build.sh has 3 errors in it. lines 65. 68 I believe there needs to be a space after that [ so it reads [ -f instead of [-f. and line 118 you need to reference ./install-dbmail.sh instead of install-dbmail.sh otherwise they fail. there is also a bug in the install-dbmail.sh but I haven't spent much time on it yet I'm afraid. I built Postgres7.4Beta (yes I know it's beta code) for the db. And tried to use your mbox2dbmail utility. With Numberous difficulties. mostly responses saying pipe broken etc. Even when I took the extra space out of the mbox2dbmail.c line 22 from the regex. I was still having difficulty. The debug information lead me to realize that the database was looking for userid 0. Why I wonder would this be.. so I dug further.. You have to read the code to realise the arg[1] is suppose to be a number. It also showed if you put the user number as the first line in the mbox file the mail converter would attempt to use that as the user_idnr problem however is in the sql query in the pgsql directory. It checks for a match of this number against the user name. userid is a string. user_idnr is a number.
line 197 in dbauthpgsql.c should read WHERE user_idnr='%s' instead of WHERE userid='%s' It looks like an attempt is in the works to let you use the user name to identify what mailbox the messages are suppose to go into. I used thunderbird 0.2 as my mail agent to test out the imap4 functions. and I'm not sure if i'm not abusing the system or what. imap worked, it slowly fed the message list to thunderbird and after about 30 minutes I had all 5255 messages. (Yes I used a very huge mailbox) Uploading it with mbox2dbmail wasn't very exciting either but hey. This is the ground I've thought about for a long time and I'm happy to see someone spilled their blood and coffee putting something like this together. If you like I would like to try and help. I'm very adept at sql and I understand mta's and such to a point. I would also be willing to write documentation to help. I'm not skilled at all yet writing man pages. but I can do pretty good with text and html. Please let me know if I messed up this thing at all. Mare
