James, if you are already using MySQL for other user information, then why are you using Access for Imail???? Imail and MySQL work fine together. You just have to get the correct ODBCUSER.DLL file. You can get one from http://wwwg2.dpzone.com/products/software/imail/odbcuser/index.html
Steven Copeland [EMAIL PROTECTED] P.S. I've been using Imail and MySQL for years with no problems. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of James Nelson > Sent: Tuesday, August 05, 2003 3:39 PM > To: [EMAIL PROTECTED] > Subject: Re: [IMail Forum] UserDir being updated incorrectly in ODBC > > > Somewhat answered my own question, in that I found an ancient post in > the archives > (http://www.mail-archive.com/[EMAIL PROTECTED]/msg4213 > 3.html). > I'd try the .dll linked, but we had to modify ours to work with MD5 > password hashes. And since the linked site does not provide source code > or info on what it did, I don't think I'd be able to get it to work > without changing our DB to store plaintext plaintext passwords. I tried > changing the USERDIR field to a binary field, but that caused some > problems. Any ideas on how to get this to work with MySQL? I'll look > through some mySQL sources to see what I can come up with. > > Thanks in advance, > ::James Nelson > > James Nelson wrote: > > > We have a MySQL user database with all of our user information. For > > IMail, I have an MS Access file that queries the MySQL table and > > re-arranges & renames fields into the format that IMail wants. > However, > > whenever an email account is accessed (POP3 or WebMsg), IMail will > > update the USERDIR and remove the backslashes (ie: > > d:\imail\domain_net\users\bob becomes d:imaildomain_netusersbob). This > > will then recreate their user directory and has to be fixed manually. > > Right now, I've removed Update privileges from Imail, but since this is > > needed for the "TYPE" field, I'd like to get this figured out. Either > > getting IMail to update this properly or just stopping it from > trying to > > update it would work fine. > > > > Thanks for any assistance, > > ::James Nelson > > > > > > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html > > List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ > Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
