aseuserstore via network connections

[former_member300534]

Hello I have setup aseuserstore on our database server , new feature in ASE16 SP4

It works fine on the database server, however i cant connect / or configure via network, which would be fantastic to use it as it is where our batch jobs etc run from

As Sybase on the network host aka CLIENT - SERVER

isql -k TESTCIBC16CKEY CT-LIBRARY error: ct_con_props(): user api layer: external error: Reading information from secure store failed at SSFS_GETRECORD(DB_USER)

on the db server

sybase@ /home/sybase$ isql -k TESTCIBC16CKEY

1>

on network as another user

aseuserstore -i Command: set Key: tst05key Connection info: DEV16CI 5400 Username: sa Password: Unable to load SSFS dynamic library: 'libsapssfs.so'.

isql -v SAP CTISQL Utility/16.0 SP03 PL04/P-EBF27920/DRV.16.0.03.04/Linux x86_64/Linux 2.6.18-128.el5 x86_64/BUILD1600-021/64bit/OPT/Sun Apr 15 18:31:29 2018

[ryan_hansen]

Hi,

When you say over the network, have you sourced SYBASE.csh environment variables?

This tool uses environment variables to find libraries and keys.

When generating a key it goes into the user's $HOME/.ase directory
This is also specific to the host you are currently on.
You can modify the $HOME and $HOST environment variables so it can find the keys.

Example:
$ echo $HOME /home/me
$ ls $HOME/.ase aseuserstore.log hostname
$ echo $HOST hostname
If i modify hostname we can see that it will fail to find the file name above.
$ setenv HOST hostnamesomethingelse
$ isql -k key
CT-LIBRARY error: ct_con_props(): user api layer: external error: Reading information from secure store failed at SSFS_GETRECORD(DB_USER)

So you can modify the user with $HOME, $HOST for the user working with isql -k and it should work (if you have the correct permissions).

Regards,
Ryan