Resolved Admin access impossible

[Steph95]

Hi
I'm having a ubuntu server (12.04.5) with plesk 12.5.30. I made a mistake few days ago about the permissions on var folder. I put back the correct permissions on each folder and files, all the websites are back, all the sql base is working well thought website and thought the ssh.
But when i'm trying to log in the admin panel i have this message
-------
Server error (code 500): Exception with message 'SQLSTATE[HY000] [14] unable to open database file' caught at top level.
-------
on the page /relay
i had a look on the panel.log and nothing special
I used the plesk repair tools to check and correct all the error ... but it's still the same.
I also checked var folder isn't full
-----
Filesystem 1K-blocks Used Available Use% Mounted on

rootfs 20026172 5108508 13877336 27% /

/dev/root 20026172 5108508 13877336 27% /

devtmpfs 2011872 4 2011868 1% /dev

none 402468 392 402076 1% /run

none 5120 0 5120 0% /run/lock

none 2012328 0 2012328 0% /run/shm

/dev/md2 459913256 123602248 312925720 29% /var
-----

I checked the https_access_log and may be there is something wrong here
------
127.0.0.1 - - [12/Sep/2016:11:04:45 +0200] "GET /favicon.ico HTTP/1.1" 400 166 "-" "-" "-"'/favicon.ico' '' '/opt/psa/admin/htdocs'

127.0.0.1 - - [12/Sep/2016:11:09:47 +0200] "GET /favicon.ico HTTP/1.1" 400 166 "-" "-" "-"'/favicon.ico' '' '/opt/psa/admin/htdocs'

127.0.0.1 - - [12/Sep/2016:11:14:49 +0200] "GET /favicon.ico HTTP/1.1" 400 166 "-" "-" "-"'/favicon.ico' '' '/opt/psa/admin/htdocs'

******* - - [12/Sep/2016:11:19:47 +0200] "GET / HTTP/1.1" 200 1516 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/601.7.7 (KHTML, like Gecko) Version/9.1.2 Safari/601.7.7" "-"'/index.php' '' '/opt/psa/admin/htdocs'

******* - - [12/Sep/2016:11:19:47 +0200] "GET / HTTP/1.1" 200 1516 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/601.7.7 (KHTML, like Gecko) Version/9.1.2 Safari/601.7.7" "-"'/index.php' '' '/opt/psa/admin/htdocs'

******* - - [12/Sep/2016:11:19:47 +0200] "GET /login.php3?window_id=&requested_url=https%3A%2F%2F*******%2F HTTP/1.1" 303 0 "*******" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/601.7.7 (KHTML, like Gecko) Version/9.1.2 Safari/601.7.7" "-"'/login.php3' '' '/opt/psa/admin/htdocs'

******* - - [12/Sep/2016:11:19:47 +0200] "GET /login.php3?window_id=&requested_url=https%3A%2F%2F*******%2F HTTP/1.1" 303 0 "https://*******/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/601.7.7 (KHTML, like Gecko) Version/9.1.2 Safari/601.7.7" "-"'/login.php3' '' '/opt/psa/admin/htdocs'
------

If anyone can help me
Thanks

 

[UFHH01]

Hi Steph95,

unfortunately, you are missing a very important fact, that you are using "SSO" ( Single Sign-On feature ) and you even reduced your log-file and anonymized the URL. "Normally", it would have been impossible, to help you here, because of missing informations, but due to the fact that you missed to remove the IP in your post, I could investigate, that you can solve your issue, by disabling the "SSO" over the command line:

/usr/local/psa/bin/sso --help

/usr/local/psa/bin/sso --disable​

Your issue is a misconfiguration of your "Single Sign-On feature". Consider either to correct your sso - configuration, or to leave it disabled.




Another hint for feature questions/issues/problems: the MORE information you provide, the better will be ( possible ) investigations from people willing to help you. If you provide too less informations/facts, you might never get suggestions/solutions for your issue/problems.

 

[Steph95]

Hi
In first thank you for your help.
In second ... bingo disable the SSO gave me back the access to the admin.
Now i have to find why the SSO doesn't work on my server but it's more then a big help you gave me