Originally posted by: phiiiiiiiil

Hello,
I have an issue with the mail adapter. I use the resource registry to store the password of the user of a pop3 account. This password value is a unix environment variable. So the entry in the resource registry looks like :

   <Resource>
     <Name>E_RECRUITEMENT_PASSWD</Name>
    <Value encrypt="OFF" Server="skylab">$(E_RECRUITEMENT_PASSWD)</Value>
   </Resource>

Here is the mail adapter trace :

Copyright <A9> 2004, IBM Corporation.  All rights reserved
Built for SUN on Jul 16 2007 at 11:49:55.
Retry Count is 0. Retry Interval is 0. OnFailure is Rollback.
Fetch Unit is 1.  Card Mode is Integral.
Run Started at 17:15:07.090 on 08/26/08.
GetMailCoreInfo: Successful.
WSAStart: Entering
WSAStart: bWSStarted = 0, nWSClients = 0
Sockets Client ID 1 enabled.
WSAStart: Exiting (rc = 1)
Server host is 'skylab'.
Using port 'pop3' for the connection.
Connecting to 'skylab'.
Socket Opened.
Connected.
+OK POP3 skylab 2006e.96 server ready (S)
USER $(E_RECRUITEMENT_PASSWD)
+OK User name accepted, password please (S)
PASS
-ERR Bad login (E)
QUIT
+OK Sayonara (S)
Socket Closed.

It's look like the unix environment variable is never evaluated before authenticating to the mail sever.

This way to store password works fine for every other adapter we use ( especially Database ) except the mail one.

Do someone encounter such problem or have a suggestion of what the problem could be ?

Thanks in advance for your help,

Regards,
Phil
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I would call IBM Support with an issue like this. Sounds like a bug.

You didn't identify what release of the software you are running or what OS but with 8.2, you have the option of using the WebSphere mail adapter.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: phiiiiiiiil

Hello Jim,

Actually we are on Solaris10 and running the WTX 8.1.0.2.. Since we don't have the Websphere Mail Adapter, we'll post a PMR to IBM for this issue that seems to be a bug.

Thanks for your reply,

Regards,
Phil
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

Looking at your trace

USER $(E_RECRUITEMENT_PASSWD)
+OK User name accepted, password please (S)
PASS

would seem to indicate that it is trying to use the resource registry entry as the USER name but it isn't translating the environment variable into a real value. Can you use environment variables in this way?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: phiiiiiiiil

Hello Janhess,
Exactly, we use environment variable in the Resource Registry for most of our database adapter connection string which works well . But for the mail one it seems that the environment variable are never evaluated. We have open a PMR, let's see what the IBM support tell about that...

Thanks,
Phil.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender