::James Nelson
Steven Copeland wrote:
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/
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/
