In Sybase Central IQ an authentication layer is implemented between the Sybase Central IQ Client and Sybase Central IQ Agent, which allows only authenticated clients to access the agent's Remote Method Invocation (RMI) methods.
As a result of RMI authentication layer implementation, there are some behavior changes in Sybase Central:
- Open Agent properties and enter Agent username and password, if you are performing an operation that requires communication with the IQ Agent.
- Text box is included for agent username and password in all the property and wizard pages that require IQ Agent port number.
- Default agent username and password is dba/sql or DBA/sql.
- Agent username and passwordHash are saved in a flat file passfile, which is located in $IQDIR15/java/ folder and is generated by the installer at install time.
- Only one username and passwordHash is stored in every line.
- You can add, remove or change agent username and password manually using a text editor.
- You can generate a passwordHash using a utility $IQDIR15/bin/32/passhash.bat or $IQDIR15/bin/64/passhash.sh.
- To print the corresponding hash value, you need to pass a plain-text password as a command line argument:
$ passhash sql
$ Hash: jbbuisadgsuiadgbasjkd89237yer8yhqwuiofh8923sdf890uy230
- You need to copy and paste the PasswordHash value against username in passfile in following format.
- You can move passfile to another location by changing the absolute path in login.config file.