on 2017 Feb 20 3:10 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That general requirement has been discussed here.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.