I have just upgraded my authenticated installation from 12.01.4165 to 12.01.4301 (the latest EBF I can find in my SAP account).

Since upgrading, when I execute the 'set temporary option connection_authentication' statement it fails with the error 'Authentication failed' (SQLCode -218).

I've been using the same authentication key for years through countless upgrades and EBFs without this happening before and I can't see anything in the release notes that mentions any relevant behaviour change.

Is this a known problem? Is there anything else I need to do following the installation of 12.01.4301 to get my authentication key working again?

asked 03 Sep '15, 14:57

Luke's gravatar image

Luke
576111530
accept rate: 33%

edited 03 Sep '15, 15:02


Please see the answer to this question. In short, a bug was introduced in build 12.0.1.4294 that caused authentication problems in some tools (such as Sybase Central and dbisql). This is fixed in 12.0.1.4307.

permanent link

answered 03 Sep '15, 15:11

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109
accept rate: 52%

Thanks for the quick response. I saw that question but it made no mention of any error when setting the key and also implied that the problem was only to do with the with administrative tools.

Do you have any idea when 12.0.1.4307 (or later) will be available for download?

Edited to clarify: I get the problem with my own Powerbuilder application connecting via ODBC as well as seeing the problem using dbisqlc

(03 Sep '15, 15:18) Luke
Replies hidden

Sorry, I'm afraid I have no idea.

(03 Sep '15, 15:23) Graeme Perrow

I am not sure that the problem that Graeme describes is the cause of your issue - as that problem is limited to the self authentication of SQL Anywhere utilities.

There are two possible authentication errors. One is -98 and the -218 that you describe. The -218 means that there is a problem with either the database_authentication or the connection_authentication values set at the time of the error. Are you able to send me those values for investigation to first.last@sap.com?

(03 Sep '15, 16:20) Chris Keating
Replies hidden

I've been looking at this further and think I know what the problem is.

When we first started using the authenticated version we generated two pairs of keys and ended up using the CONNECTION_AUTHENTICATION string from one pair with the DATABASE_AUTHENTICATION string from the other. This was really as a result of not understanding how the authentication mechanism worked at the time but it has never caused a problem until now.

The two pairs of keys have different 'Application' elements but the same 'Company' element (other than a change in case of some of the letters). My assumption has been that so long as the 'Company' elements are the same (other than case) and the 'Signature' element is valid then the connection will authenticate.

With 4301 it looks like either the 'Application' element also has to match or the 'Company' element has been made case sensitive.

I can change our software to resolve this easily enough but can you confirm this change in behaviour?

(I have sent you the values as requested in case it's useful)

(04 Sep '15, 04:34) Luke
1

My apologies for misleading you. Chris is right; the bug fix I was referring to was only for the SQL Anywhere utilities. In "such as Sybase Central and dbisql", "such as" should have been "only".

I can also confirm the behaviour change you mentioned - the comparison for Application and Company names in the authentication strings is now case-sensitive where it wasn't before.

(08 Sep '15, 09:05) Graeme Perrow
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×19

question asked: 03 Sep '15, 14:57

question was seen: 487 times

last updated: 08 Sep '15, 09:05