Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi all,

I'm running SQL Anywhere 17 (2757) on a win7 Pro (64bit) notebook and a Raspberry Pi 3 with Raspbian. I wonder if SQL Anywhere Cockpit is supposed to run on the Raspberry.
I ran this sequence against the Win7 machine:

@set pwd=cockTale  
@set srvname=Cockpit_%computername:-=_%

dbinit -dba cpit,%pwd% Userdata.db  
dbspawn dbsrv17 -cdb "dbf=CPRepository.db" -xs http -n %srvname% -o %srvname%.lis UserData.db  
dbisql -c "server=%srvname%;dbn=UserData;uid=cpit;pwd=%pwd%" grant role cockpit_role to cpit

Afterwards, I could connect to the cockpit using http://192.168.178.27/sqlacockpit by authenticating myself as user cpit password cockTale. This also works from the RasPi web Browser.

Then I repeated the equivalent steps on the RasPi:

dbinit -dba cpit,cockTale Userdata.db
dbsrv17 -cdb "dbf=CPRepository.db" -xs http{port=8080} -n RasPiCockpit -o RasPiCockpit.lis Userdata.db
dbisqlc -c cpit,cockTale grant role cockpit_role to cpit

When I try to connect (with http://192.168.178.34:8080/sqlacockpit), I'm prompted with the Cockpit connect dialog, but when I specify my credentials, I get the error that (translated back from German) my username or password is invalid or the user hasn't been granted the COCKPIT_ROLE role. This again is consistent for local connections within the RasPi and remote connection from Win7 Firefox. I've checked that the grant role had been successful (select * from sysrolegrants where grantee_name = user_name () shows the COCKPIT_ROLE row).
I don't see any relevant difference between the two command sequences, so I wonder if SQL Anywhere Cockpit is supposed to run at all on Raspbian or, of course, somebody can point me to what I've missed there.

TIA
Volker Stoeffler
DB-TecKnowledgy

asked 20 Feb '17, 15:10

Volker%20DB-TecKy's gravatar image

Volker DB-TecKy
5453715
accept rate: 25%


Cockpit is not supported on the PI platform because OMNI/CIS is not enabled on the platform, and it is needed to do cross database connections.

permanent link

answered 20 Feb '17, 16:50

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

edited 20 Feb '17, 16:51

That general requirement has been discussed here.

(21 Feb '17, 02:26) Volker Barth

Thank you, Mark & Volker. I suspected something like that, but failed to find it.
As a suggestion for product development, I think a more precise error message might help.
-- Volker

(21 Feb '17, 11:01) Volker DB-TecKy
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:

×246
×4

question asked: 20 Feb '17, 15:10

question was seen: 2,436 times

last updated: 21 Feb '17, 11:01