Cannot create a new subscription

[DavideR]

Hi all,
after upgrade tu Plesk 10.4.4 on Ubuntu server when i try to create a new Subscription, after pressing the ok button the error is

Error: system user update is failed: Some fields are empty or contain an improper value. ('shell' = '')

I get the mail of new subscription creation but the subscription is not present in the list.

 

[IgorG]

Check value of option 'SSH access to the server shell under' in Service Plan for this Subscription.

 

[DavideR]

Under Hosting Parameters "SSH access to the server shell under" is unchecked, if i check it the select near it is empty...

 

[IgorG]

What sort of output following SQL query:

select * from ServiceNodeProperties where name='server.os.availableShells';

Did you try bootstrapper repair?

 

[DavideR]

The Result of the query is empty.

No I haven't try bootstrapper repair.

 

[IgorG]

It should be something like:

mysql> select * from ServiceNodeProperties where name='server.os.availableShells'\G
*************************** 1. row ***************************
serviceNodeId: 1
name: server.os.availableShells
value: a:8:{s:10:"/bin/false";a:3:{s:4:"name";s:9:"Forbidden";s:5:"empty";b:1;s:8:"chrooted";b:0;}s:7:"/bin/sh";a:3:{s:4:"name";s:7:"/bin/sh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:9:"/bin/bash";a:3:{s:4:"name";s:9:"/bin/bash";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:13:"/sbin/nologin";a:3:{s:4:"name";s:13:"/sbin/nologin";s:5:"empty";b:1;s:8:"chrooted";b:0;}s:9:"/bin/tcsh";a:3:{s:4:"name";s:9:"/bin/tcsh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:8:"/bin/csh";a:3:{s:4:"name";s:8:"/bin/csh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:27:"/usr/local/psa/bin/chrootsh";a:3:{s:4:"name";s:20:"/bin/bash (chrooted)";s:5:"empty";b:0;s:8:"chrooted";b:1;}s:10:"/bin/rbash";a:3:{s:4:"name";s:10:"/bin/rbash";s:5:"empty";b:0;s:8:"chrooted";b:0;}}
1 row in set (0.00 sec)

Seems database was not correctly upgraded. Try bootstrapper repair.

 

[DavideR]

After bootstrapper repair the query is still 0 rows....

===> Preparing upgrade
Stopping psa... done
psa is stopped
Stopping psa... done
===> Cumulative database upgrade has been started
===> Upgrade completed.
* Reloading Postfix configuration...
...done.
System startup links for /etc/init.d/xinetd already exist.
System startup links for /etc/init.d/xinetd already exist.
This module is already enabled!
ln: creating symbolic link `/var/named/run-root/etc/bind/rndc.conf': File exists
update-rc.d: /etc/init.d/named: file does not exist
mknod: `/var/www/vhosts/chroot/dev/null': File exists
This module is already enabled!
This module is already enabled!
This module is already enabled!
This module is already enabled!
===> Cumulative upgrade has been started
===> Upgrade completed.
This module is already enabled!
This module is already enabled!
This module is already enabled!
This module is already enabled!
This module is already enabled!
System startup links for /etc/init.d/psa already exist.
Stopping psa... done
Starting psa... done
Starting xinetd service... done
Starting bind9 service... done
Starting mysql service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
Plesk: Starting Mail Server... already started
Starting psa... done

Congratulations!
All stages of the upgrade were successful.
psa is now running on your system.
To complete the system configuration process, please proceed to URL:
https://XXXX.XXX.XX.it:8443/ or
https://127.0.0.1:8443/
Use 'admin' and '<YOUR ADMIN PASSWORD>' as login name and password.

Further, use the following commands to start and stop the system:
/etc/init.d/psa start and
/etc/init.d/psa stop respectively.

 

[DavideR]

Excuse me... Te problem is still present after the sugguest of bootstrapper repair.... Anyone know how can it be solved???? Tnx a lot

 

[IgorG]

Did you repair missing table what I wrote before?

 

[DavideR]

I tryed bootstrapper repair with command /usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/bootstrapper.sh repair... but nothing changes!!!!! ow can i repair missing tables???

 

[IgorG]

Do you have content of this table as it is described above? Contact Support Team if you can't repair it by yourself.

 

[DavideR]

No, i haven't content of this table as described above, the query you give mi is still empty!!!!

 

[IgorG]

I know that it is empty. Therefore, I advise you to restore it. Contact Support Team if you can't.