<div dir="ltr">Thanks for reply, <div><br></div><div>I have switched from sqlite to mysql and made great progress. At least I can in UI and things working fine except normal users can't see things because of some access issue. </div><div><br></div><div><p style="margin:0px 0px 0.8em;padding:0px;width:auto;max-width:75em;color:rgb(0,0,0);font-family:"Ubuntu Mono variable","Ubuntu Mono",Consolas,Monaco,Courier,monospace;font-size:12.8px">This is my skyline.yaml file</p><p style="margin:0px 0px 0.8em;padding:0px;width:auto;max-width:75em;color:rgb(0,0,0);font-family:"Ubuntu Mono variable","Ubuntu Mono",Consolas,Monaco,Courier,monospace;font-size:12.8px">#################</p><p style="margin:0px 0px 0.8em;padding:0px;width:auto;max-width:75em;color:rgb(0,0,0);font-family:"Ubuntu Mono variable","Ubuntu Mono",Consolas,Monaco,Courier,monospace;font-size:12.8px">default:<br> access_token_expire: 3600<br> access_token_renew: 1800<br> cors_allow_origins: []<br> #database_url: sqlite:////tmp/skyline.db<br> database_url: mysql://skyline:skyline123@localhost:3306/skyline<br> debug: true<br> log_dir: /var/log/skyline<br> log_file: skyline.log<br> prometheus_basic_auth_password: ''<br> prometheus_basic_auth_user: ''<br> prometheus_enable_basic_auth: false<br> prometheus_endpoint: <a rel="nofollow" href="http://localhost:9091/" style="color:rgb(0,51,170);text-decoration-line:none">http://localhost:9091</a><br> secret_key: aCtmgbcUqYUy_HNVg5BDXCaeJgJQzHJXwqbXr0Nmb2o<br> session_name: session<br> ssl_enabled: false<br>openstack:<br> base_domains:<br> - heat_user_domain<br> default_region: RegionOne<br> enforce_new_defaults: true<br> extension_mapping:<br> floating-ip-port-forwarding: neutron_port_forwarding<br> fwaas_v2: neutron_firewall<br> qos: neutron_qos<br> vpnaas: neutron_vpn<br> interface_type: public<br> keystone_url: <a rel="nofollow" href="http://192.168.18.100:5000/v3" style="color:rgb(0,51,170);text-decoration-line:none">http://192.168.18.100:5000/v3</a><br> nginx_prefix: /api/openstack<br> reclaim_instance_interval: 604800<br> service_mapping:<br> baremetal: ironic<br> compute: nova<br> container: zun<br> container-infra: magnum<br> database: trove<br> identity: keystone<br> image: glance<br> key-manager: barbican<br> load-balancer: octavia<br> network: neutron<br> object-store: swift<br> orchestration: heat<br> placement: placement<br> sharev2: manilav2<br> volumev3: cinder<br> sso_enabled: false<br> sso_protocols:<br> - openid<br> sso_region: RegionOne<br> system_admin_roles:<br> - admin<br> - system_admin<br> system_project: service<br> system_project_domain: Default<br> system_reader_roles:<br> - system_reader<br> system_user_domain: Default<br> system_user_name: skyline<br> system_user_password: 'skyline123'<br>setting:<br> base_settings:<br> - flavor_families<br> - gpu_models<br> - usb_models<br> flavor_families:<br> - architecture: x86_architecture<br> categories:<br> - name: general_purpose<br> properties: []<br> - name: compute_optimized<br> properties: []<br> - name: memory_optimized<br> properties: []<br> - name: high_clock_speed<br> properties: []<br> - architecture: heterogeneous_computing<br> categories:<br> - name: compute_optimized_type_with_gpu<br> properties: []<br> - name: visualization_compute_optimized_type_with_gpu<br> properties: []<br> gpu_models:<br> - nvidia_t4<br> usb_models:<br> - usb_c</p><p style="margin:0px 0px 0.8em;padding:0px;width:auto;max-width:75em;color:rgb(0,0,0);font-family:"Ubuntu Mono variable","Ubuntu Mono",Consolas,Monaco,Courier,monospace;font-size:12.8px">############</p><p style="margin:0px 0px 0.8em;padding:0px;width:auto;max-width:75em;color:rgb(0,0,0);font-family:"Ubuntu Mono variable","Ubuntu Mono",Consolas,Monaco,Courier,monospace;font-size:12.8px">My problem is if I login as admin then everything works!! But for normal account (end-user) I am able to login in UI but when I click any instance or anything it throwing access error and in logs its showing me following:</p><p style="margin:0px 0px 0.8em;padding:0px;width:auto;max-width:75em;color:rgb(0,0,0);font-family:"Ubuntu Mono variable","Ubuntu Mono",Consolas,Monaco,Courier,monospace;font-size:12.8px">2023-08-08 04:49:04.869 | DEBUG | keystoneauth1.session:request:946 - GET call to identity for <a rel="nofollow" href="http://192.168.18.100:5000/v3/users/e8b10077f9f84e03bf115aa10ae13852/projects" style="color:rgb(0,51,170);text-decoration-line:none">http://192.168.18.100:5000/v3/users/e8b10077f9f84e03bf115aa10ae13852/projects</a> used request id req-8988e75a-97c4-4b2a-8a37-23572453d31d<br>2023-08-08 04:49:04.912 | DEBUG | urllib3.connectionpool:_make_request:456 - <a rel="nofollow" href="http://192.168.18.100:5000/" style="color:rgb(0,51,170);text-decoration-line:none">http://192.168.18.100:5000</a> "POST /v3/auth/tokens HTTP/1.1" 401 109<br>2023-08-08 04:49:04.913 | DEBUG | keystoneauth1.session:request:976 - Request returned failure status: 401<br>2023-08-08 04:49:04.914 | DEBUG | skyline_apiserver.api.v1.policy:list_policies:103 - Keystone token is invalid. No privilege to access system scope.</p><p style="margin:0px 0px 0.8em;padding:0px;width:auto;max-width:75em;color:rgb(0,0,0);font-family:"Ubuntu Mono variable","Ubuntu Mono",Consolas,Monaco,Courier,monospace;font-size:12.8px">It is clear that skyline doesn't pass proper token or authorization when using a normal user account but it does work with admin account. What could be wrong here?</p></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Aug 8, 2023 at 10:58 PM 朱博祥 <<a href="mailto:bxzhu_5355@163.com">bxzhu_5355@163.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: break-word;"><div>Hi,</div><div><br></div><div>For sqlite DB for skyline, I think you can followed by this step[1].</div><div><br></div><div>[1] <a href="https://opendev.org/openstack/skyline-apiserver#deployment-with-sqlite" target="_blank">https://opendev.org/openstack/skyline-apiserver#deployment-with-sqlite</a></div><div><br></div><div>Thanks</div><div>Boxiang</div><div><br></div><br><div><br><blockquote type="cite"><div>2023年8月8日 上午7:21，Satish Patel <<a href="mailto:satish.txt@gmail.com" target="_blank">satish.txt@gmail.com</a>> 写道：</div><br><div><div dir="ltr">Folks,<br><div><br></div><div>Try to install skyline UI to replace horizon using doc: <a href="https://docs.openstack.org/skyline-apiserver/latest/install/docker-install-ubuntu.html" target="_blank">https://docs.openstack.org/skyline-apiserver/latest/install/docker-install-ubuntu.html</a> </div><div><br></div><div>Everything went well and I got a login page on <a href="http://x.x.x.x:9999/" target="_blank">http://x.x.x.x:9999</a> also it pulled Region/Domains. When I am trying to login with my account, I get an error: Username or Password is incorrect. </div><div><br></div><div>I am using sqlite DB for skyline as per documents. </div><div><br></div><div>No errors in logs command</div><div>$ docker logs skyline </div><div><br></div><div>When I use Chrome Developer Tools then it was indicating an error in these URLs. </div><div><br></div><div><a href="http://openstack.example.com:9999/api/openstack/skyline/api/v1/profile" target="_blank">http://openstack.example.com:9999/api/openstack/skyline/api/v1/profile</a><br></div><div><span style="color:rgb(48,57,66);font-family:".SFNSDisplay-Regular","Helvetica Neue","Lucida Grande",sans-serif;font-size:12px"><a href="http://openstack.example.com:9999/api/openstack/skyline/api/v1/policies" target="_blank">http://openstack.example.com:9999/api/openstack/skyline/api/v1/policies</a></span><br></div><div><span style="color:rgb(48,57,66);font-family:".SFNSDisplay-Regular","Helvetica Neue","Lucida Grande",sans-serif;font-size:12px"><br></span></div><div><span style="color:rgb(48,57,66);font-family:".SFNSDisplay-Regular","Helvetica Neue","Lucida Grande",sans-serif;font-size:12px">401 Unauthorized ( </span><span>{"detail":"no such table: revoked_token"} ) </span></div></div></div></blockquote><div><br></div><div>For this error message, I think you did not do bootstrap for skyline when you use sqlite db.</div><div><br></div><br><blockquote type="cite"><div><div dir="ltr"><div><span><br></span></div><div><span>Find attached screenshot</span></div><div><span style="color:rgb(48,57,66);font-family:".SFNSDisplay-Regular","Helvetica Neue","Lucida Grande",sans-serif;font-size:12px"><br></span></div><div><span style="color:rgb(48,57,66);font-family:".SFNSDisplay-Regular","Helvetica Neue","Lucida Grande",sans-serif;font-size:12px"><br></span></div></div>
<span id="m_1180502749743540285cid:f_ll1hybpg0"><Screenshot 2023-08-07 at 7.21.21 PM.png></span></div></blockquote></div><br></div></blockquote></div>