aseuserkey and ssl

[robert_kratschmann]

Hi!

On Linux the following works fine:

[sybase@dimotion ase160]$ aseuserstore set sadkey 'dimotion.sybase.local 5010 ssl="CN=DIMOTION"' sa sybase
[sybase@dimotion ase160]$ isql -ksadkey
1> select @@ssl_ciphersuite
2> go
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
 -----------------------------------------------------------------------------------------------------------
 TLS_RSA_WITH_AES_128_GCM_SHA256                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      

(1 row affected)
1> exit
[sybase@dimotion ase160]$

Entering the same on Windows fails with an error, or with modifications he doesn't accept the filter:

C:\>aseuserstore set sadkey 'dimotion.sybase.local 5010 ssl="CN=DIMOTION"' sa sybase
Number of arguments provided does not match the SET command
Usage: set <KEY> <ENV> <USERNAME> <PASSWORD>

C:\>aseuserstore set sadkey "dimotion.sybase.local 5010 ssl='CN=DIMOTION'" sa sybase

C:\>isql -ksadkey
CT-LIBRARY error:
        ct_connect(): network packet layer: internal net library error: Failed to install network filter

C:\>aseuserstore list sadkey

KEY: SADKEY
  CON_ENV       : dimotion.sybase.local 5010 ssl='CN=DIMOTION'
  USERNAME      : sa
  PASSWORD      : ***


C:\>aseuserstore set sadkey "dimotion.sybase.local 5010 'ssl="CN=DIMOTION"'" sa sybase

C:\>isql -ksadkey
CT-LIBRARY error:
        ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

Inserting the key with aseuserstore -i works fine and can serve as a workaround. However, is there a way to populate the aseuserstore on Windows with an SSL connection non-interactively?

Thanks

Robert

[ryan_hansen · Accepted solution]

Hi,

Please use this syntax. Windows is a little different:

C:\Users\me>aseuserstore set mykey2 "host 5000 ssl=\"CN=ASEname\"" sa password

C:\Users\me>isql -k mykey2
1>

Hope this helps,
Ryan