Hi Liridon, Thank you for your reply.
> select * from cloud.account where id = 2; and select * from roles where > id in (select role_id from account where id = 2); I did not find the role table and account.role_id column. The cloudstack version of my system is 4.2.1. Is there no table/column in this version? > As it seems that your user Admin can log in but maybe your account or > role is inactive or not properly configured. Can you check if you are > able to log in with another account / user which is not under the admin > account? I confirmed login with another account. I tried with multiple accounts, but I couldn't log in all. Best regards, Eiji Sagawa > -----Original Message----- > From: Ismaili, Liridon (SWISS TXT) [mailto:liridon.isma...@swisstxt.ch] > Sent: Friday, July 5, 2019 6:00 PM > To: users@cloudstack.apache.org > Cc: Shigemoto, Yasumasa/重元 康昌 <shigemoto.ya...@fujitsu.com>; > Hoshikawa, Toyohiko/星川 豊彦 <t-hoshik...@fujitsu.com> > Subject: AW: Unable to log in to the cloudstack management page (Web UI) > > Hi Eiji > > the JSON inside the body tells the same as the error you posted already. > May you check the DB if there is something misconfigured with the accounts > or roles? > Please run this query and post the results: > select * from cloud.account where id = 2; and select * from roles where > id in (select role_id from account where id = 2); > > As it seems that your user Admin can log in but maybe your account or > role is inactive or not properly configured. Can you check if you are > able to log in with another account / user which is not under the admin > account? > > Regards > Liridon > ________________________________ > Von: sagawa_e...@fujitsu.com <sagawa_e...@fujitsu.com> > Gesendet: Freitag, 5. Juli 2019 10:31 > An: users@cloudstack.apache.org > Cc: shigemoto.ya...@fujitsu.com; t-hoshik...@fujitsu.com > Betreff: RE: Unable to log in to the cloudstack management page (Web UI) > > Hi Gregor, > > Thank you very much for answering my questions. > > > > > 192.168.122.1 - - [01/Jul/2019:06:13:10 +0900] "GET > > > > > > /client/api?command=listCapabilities&response=json&sessionkey=h1Lwsk > > 9 > > > dqVwZxGAwk0owzFDtmi4%3D&_=1561961591972 HTTP/1.1" 432 151 > > > > This happens just after login and indicates something is wrong. > > It might not help much, but can you post the JSON body of the response? > > This JSON body was returned. > ----------------------- > { "errorresponse" : > {"uuidList":[],"errorcode":432,"cserrorcode":9999,"errortext":"The > given command does not exist or it is not available for user"} } > ----------------------- > > Do you know anything from this JSON body? > > > Best regards, > Eiji Sagawa > > > > -----Original Message----- > > From: Riepl, Gregor (SWISS TXT) [mailto:gregor.ri...@swisstxt.ch] > > Sent: Wednesday, July 3, 2019 10:00 PM > > To: users@cloudstack.apache.org > > Cc: Shigemoto, Yasumasa/重元 康昌 <shigemoto.ya...@fujitsu.com>; > > Hoshikawa, Toyohiko/星川 豊彦 <t-hoshik...@fujitsu.com> > > Subject: Re: Unable to log in to the cloudstack management page (Web > > UI) > > > > Hi Eiji, > > > > > 192.168.122.1 - - [01/Jul/2019:06:09:22 +0900] "GET > > > > > > /client/api?command=listCapabilities&response=json&sessionkey=null&_ > > = > > > 1561961364158 HTTP/1.1" 401 101 > > > > This happens before login and is ok. > > I see that too when I open the login page without an active session. > > > > > ==> /var/log/cloudstack/management/access_log.2019-07-01.txt > > <== > > > 192.168.122.1 - - [01/Jul/2019:06:13:10 +0900] "POST /client/api > > > HTTP/1.1" 200 321 > > > > This is the actual login call, and returns status 200 (success). > > > > > 192.168.122.1 - - [01/Jul/2019:06:13:10 +0900] "GET > > > > > > /client/api?command=listCapabilities&response=json&sessionkey=h1Lwsk > > 9 > > > dqVwZxGAwk0owzFDtmi4%3D&_=1561961591972 HTTP/1.1" 432 151 > > > > This happens just after login and indicates something is wrong. > > It might not help much, but can you post the JSON body of the response? > > > > > 2019-07-01 06:13:10,963 DEBUG [cloud.api.ApiServlet] (catalina- > > > exec-22:null) ===START=== 192.168.122.1 -- GET > > > command=listCapabilities&response=json&sessionkey=h1Lwsk9dqVwZxG > > > Awk0owzFDtmi4%3D&_=1561961591972 > > > 2019-07-01 06:13:10,976 DEBUG [cloud.api.ApiServer] (catalina- > > > exec-22:null) The given command:listCapabilities does not exist or > > > it is not available for user with id:2 > > > > > > ==> /var/log/cloudstack/management/apilog.log <== > > > 2019-07-01 06:13:10,979 INFO [cloud.api.ApiServer] (catalina- > > > exec-22:null) 192.168.122.1 -- GET > > > > > > command=listCapabilities&response=json&sessionkey=h1Lwsk9dqVwZxGAwk0 > > o > > > wzFDtmi4%3D&_=1561961591972 432 The given command does not exist or > > it > > > is not available for user > > > > These log messages relate to the failing listCapabilities call after > login. > > I think you should focus on these. > > > > Regards, > > Gregor
