(Having finally remembered to configure Horde/Imp to send email via tmda-ofmipd now...)
Has anybody attempted to integrated TMDA's DB_BARE_APPEND/DB_CONFIRM_APPEND with the schema for Horde/Turba's address book in MySQL? A couple of problems I'm not quite sure how to solve yet: * Each row in the Turba table has a unique "object id" field that's generated via the PHP code md5(uniqid(rand())) [or similar], rather than an auto-incrementing column in MySQL. I'm thinking the simplest solution to this is to change the SQL schema to use an auto-increment column, then update the Turba code to use this, rather than trying to work out how TMDA might generate some form of unique data for this column... * TMDA simply performs INSERTs (well, at least, simply executes one single SQL statement - can it be a non-INSERT?). So, if the user already has an entry in the address book, but TMDA receives a valid confirmation response, it will attempt to add the entry into the address book, which will actually succeed, since the combination of (TMDA_recipient, email_sender) isn't a unique key in the schema - I though about making it one and adding the IGNORE option to the SQL so that duplicate inserts were no-op'd, but the fields are too large for MySQL to allow me to create a key (max 500 chars allowed, each field is 255 chars). I'm really not sure how to solve this. Can TMDA be modified to do a SELECT, then INSERT only if there were no existing matches? MySQL doesn't seem to support stored procedures (at least not in 4.0.x) so I can't just call one. Otherwise, perhaps we could have an EXEC_BARE_APPEND and EXEC_CONFIRM_APPEND to call a custom script "exec $script $recipient $sender" to do whatever updates are required... Any thoughts. I've trawled google for ideas for hours but didn't really come up with anything. Thanks! -- Stephen Warren, Software Engineer, Parama Networks, San Jose, CA [EMAIL PROTECTED] http://www.wwwdotorg.org/ _____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
