Looking for SQL statement to set ALL plans and sites SSL support off

[RationalPolymer]

Rather than using intensive manual Panel operations or iterative scripting command-line operations to change the SSL support attribute in Plans and the SSL support attribute in Site/Hosting, I would like to know of separate SQL statements that would accomplish each of these two tasks.

 

[KristianM]

Hi,

well this would actually not really help you.
Changing values in the database will still not change any configuration files.
So the best thing to do is actually either use CLI Tools or API Commands.

You should not play with the psa Database.

Regards,
Kristian

 

[shall]

And the way to do this with the CLI is this command:

/usr/local/psa/bin/subscription -u example.com -ssl false

Replace example.com with the subscription name. You can also do it all in one fell swoop with this (makes path assumptions):

pushd /var/www/vhosts
	for eaDomain in `ls .`
	do
		case "$eaDomain" in
			"chroot")
				;; # ignore
			"default")
				;; # ignore
			"fs")
				;; # ignore
			"fs-passwd")
				;; # ignore
			*)
				/usr/local/psa/bin/subscription -u $eaDomain -ssl false
		esac
	done
popd

 

[KristianM]

Hi,

another easy way:

	for eaDomain in `/usr/local/psa/bin/subscription -l`
	do
				/usr/local/psa/bin/subscription -u $eaDomain -ssl false
	done

Does the same basicly

Regards,
Kristian