The problem with storing the folder names is that MySQL used the '\' character to specify special characters (\n = new line, \r = carriage return, etc). To pass it string data with a '\' you need ot use '\\'. So when the data is sent to MySQL for storage, it should look like:

d:\\imail\\domain_net\\users\\bob

When you query the MySQL database, the data is returned containing single '\'s

James Nelson wrote:

Somewhat answered my own question, in that I found an ancient post in the archives (http://www.mail-archive.com/[EMAIL PROTECTED]/msg42133.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/
---
[This E-mail scanned for viruses by Declude Virus / Sophos AV]




-- ------------------------------------------------------------------- Diagonally parked in a parallel universe. ------------------------------------------------------------------- Bud Durland, CNE Mold-Rite Plastics Network Administrator http://www.mrpcap.com -------------------------------------------------------------------


--- [This E-mail scanned for viruses by Declude Virus / Sophos AV]


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/

Reply via email to