Resolved can't connect to :8443 after upgrade

[pierre88]

Hi Guys,
im unable to connect to plesk after update from 12 to 12.5 latest version.

Checking plesk logs I see:

# cat /var/log/sw-cp-server/error_log

2016/07/07 04:32:09 [error] 20717#0: *1544 FastCGI sent in stderr: "PHP message: PHP Warning: psasem_rinit(): failed to open semaphore file: /usr/local/psa/var/psasem.sem: Permission denied in Unknown on line 0" while reading response header from upstream, client: 81.XXX.XXX.XXX, server: , request: "POST /relay HTTP/1.1", upstream: "fastcgi://127.0.0.1:19001", host: "domain.com:8443", referrer: "https://domain.com:8443/login_up.php3?window_id=&requested_url=https://domain.com:8443/&return_host="

My php version:

# php -v

PHP 5.3.3 (cli) (built: May 10 2016 21:39:50)

Copyright (c) 1997-2010 The PHP Group

Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v4.6.0, Copyright (c) 2002-2014, by ionCube Ltd.

What happened guys? Any solution?

 

[UFHH01]

Hi pierre88,

this looks as if your upgrade didn't finish as expected. Consider to use

plesk repair all -y

followed by

/usr/local/psa/admin/sbin/autoinstaller --select-release-current --reinstall-patch --install-component base​

Pls. check as well your updates with "apt-get"/"aptitude" ( on Debian/Ubuntu - based systems ) or with "yum" ( RHEL/CentOS - based systems ).

 

[pierre88]

Hi, thanks a lot for your reply.

Our Centos system was updated before the Plesk update procedure:

Linux mydomain.com 3.8.13-xxxx-std-ipv6-64 #4 SMP Mon Aug 5 14:25:53 CEST 2013 x86_64 x86_64 x86_64 GNU/Linux

I just run first and second command, but I'm still unable to login.

It's like if the login page goes in loop, it auto-loads continuously.

Before to get the login page in "loop" I've seen the new login interface of Plesk, I've entered my login datas and then you see in loop the page like these two following screenshots.

http://pasteboard.co/8G6FFRjIk.png

http://pasteboard.co/8G75OeD9H.png

Repeating the command cat /var/log/sw-cp-server/error_log, I get so many errors like this:

2016/07/07 19:14:38 [error] 9604#0: *3496 FastCGI sent in stderr: "PHP message: PHP Warning:  psasem_rinit(): failed to open semaphore file: /usr/local/psa/var/psasem.sem: Permission denied in Unknown on line 0" while reading response header from upstream, client: 93.35.XXX.XXX, server: , request: "POST /relay HTTP/1.1", upstream: "fastcgi://127.0.0.1:19001", host: "mydomain.it:8443", referrer: "https://mydomain.it:8443/login_up.php3?window_id=&requested_url=https%3A%2F%2Fcoverstyle.it%3A8443%2F&return_host="

Furthermore if you need I've executed this command:

[root@myserver ~]# cd /etc/sso
[root@myserver sso]# ls
sso-bp7lug.pem  sso-ca.pem  sso_config.ini  sso.pem  sso-public.pem
[root@myserver sso]# ls -la
totale 36
drwxr-xr-x  2 root root  4096  7 lug 03:37 .
drwxr-xr-x 98 root root 12288  7 lug 04:23 ..
-rw-------  1 root root  2183  7 lug 03:37 sso-bp7lug.pem
-rw-------  1 sso  root  2138  7 lug 03:24 sso-ca.pem
-rw-r--r--  1 root root  1711  7 lug 03:26 sso_config.ini
-rw-------  1 sso  root  2183  7 lug 03:24 sso.pem
-rw-------  1 sso  root  1111  7 lug 03:24 sso-public.pem
[root@myserver sso]#

 

[UFHH01]

Hi pierre88,

at the moment, you use "sso" ( single - sign - on ) on your server and it could be the case, that your previous upgrade didn't finish as expected, or with failures.

Consider to switch off "sso" with the command:

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

or

/usr/local/psa/bin/sso -d

IF you don't use "sitebuilder" or/and "Custom billing manager", you don't actually need "sso" and you can leave the offline - state as it is!​

To repair the "sso" - configuration use:

Check your hostname with the command:

hostname​

Reconfigure "server preferences" and "sso":

/usr/local/psa/bin/server_pref --update -hostname YOUR_HOSTNAME_FROM_YOUR_ABOVE_COMMAND​

/usr/local/psa/bin/sso -s -server https://YOUR_HOSTNAME_FROM_YOUR_ABOVE_COMMAND:11443 -url https://YOUR_HOSTNAME_FROM_YOUR_ABOVE_COMMAND:11444​

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

or​

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

To make sure, that "psa" - service is running, you can use:

service psa restart​

 

[pierre88]

Hi UFHH01,
First command ok:

[root@mydomain ~]# /usr/local/psa/bin/sso --disable
SUCCESS: SSO disabled

Second command ok:

[root@mydomain ~]# /usr/local/psa/bin/server_pref --update -hostname mydomain.com
SUCCESS: Server preferences are successfully updated

I get this error running the 3rd command (/usr/local/psa/bin/sso -s -server https://YOUR_HOSTNAME_FROM_YOUR_ABOVE_COMMAND:11443 -url https://YOUR_HOSTNAME_FROM_YOUR_ABOVE_COMMAND:11444), see it:

[root@mydomain ~]# /usr/local/psa/bin/sso -s -server https://mydomain.com:11443 -url https://mydomain.com:11444
PHP Warning: stream_socket_client(): unable to connect to ssl://mydomain.com:11443 (Connection refused); File: /usr/local/psa/admin/externals/Net/Socket.php, Line: 139

Can not request registration in Identity Provider: 111:Connection refused

[root@mydomain ~]#

PSA is running..

How to solve it?

 

[UFHH01]

Hi pierre88,

first of all, pls. make sure that your hostname is reachable and necessary ports are not blocked by a firewall!

Second, pls. connect to your PSA database and check your stored definition for "sso":

plesk db psa
mysql> select * from misc where param like '%sso%';

Third, pls check as well "/etc/hosts" for possible misconfigurations:

cat /etc/hosts

Fourth, pls. make sure that your used ssl - certificates are up-to-date and valid.

locate sso.pem on your server
replace it, if not valid, or misconfigured with a valid certificate
restart sw-cp-server afterwards​

 

[pierre88]

First command error:

[root@mydomain httpd]# plesk db psa
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'psa' at line 1
exit status 1

 

[UFHH01]

Hi pierre88,

if the short utility doesn't work for you, consider to use the "long version":

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

( you should see then => mysql> , which shows, that you are now connected to your selected database! )

Pls. continue with:

mysql> select * from misc where param like '%sso%';

​

 

[pierre88]

Anyway I didn't checkd but now it works!

I'm logged it into the new plesk!

But one of my main site result in:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

 

[UFHH01]

Hi pierre88,

pls. mark this thread as resolved and open an additional thread if you experience a total different issue to the title of your current thread.