It's been over a week and I still can't get the SSL to work. Up until this migration, I loved WestHost, but I'm not so sure anymore. Will someone please look into these two tickets?!?
[westhost.com #84675]
[westhost.com #90897]
These are the instructions I got to reenable SSL, but I don't know how to use SSH and need someone in Tech Support to help:
Because of the new implementation of WestHost 2.0, database access is a little different across the sharedSSL. To enable your database to be accessible from the secure server, you must follow these steps (from SSH):
1) Edit the /etc/my.cnf in the vds and place a # before the line for skip-networking
2) Add a new user into the mysql database with the same username and password but with the host being 69.36.161.29 (the ip for the secure server). You can do this with phpmyadmin or login to the mysql manager through SSH:
[accountname][/]$ mysql
mysql>use mysql
mysql>GRANT ALL PRIVILEGES ON *.* TO username@'69.36.161.29';
mysql>SELECT password FROM user WHERE user='username';
take this value, we'll call it password and run the following command
mysql>UPDATE user SET password='password' where user='username';
mysql>quit
3) Restart the vds through the site manager.
This is way beyond my technical expertise and I would hope WestHost would fix it. I didn't create this problem, but me and my clients are suffering the consequences.
In my opinion, the old system worked just fine...please help resolve this as soon as possible!!!
Brian
I have a similar problem where my Miva Order shopping cart needs to point to the right ssl port. I get the following error "Unable to authorize payment: CC-2501: Unable to connect to SSL Server.
Brian,
Looks like you can actually do all that stuff without having to use SSH:
Log in to your Site Manager, click on Site Management and then the Login button under File Manager. It'll prompt you for your username and password again. Once it has loaded, you can "move up" directories (or "search for directory") until you reach the root directory (if searching, enter "etc" no quotes). From there you can navigate to the etc directory and then you can click "edit" next to my.cnf. Make the changes required and click save. After you're done with that, you can close the File Manager. Now back in the Site Manager, click on Site Applications and make sure you have Mod PHP, mySQL and PhpMyAdmin installed (the latter two are in Database and former in Development). Then just click "link" next to PhpMyAdmin, and enter your username and password again. Once it has loaded, select the "mySQL" database from the drop down list on the left. It loads a page in the right frame. Click on the SQL link at the top of that page. It loads up another page that has a textarea box on it. In there, paste the following:
GRANT ALL PRIVILEGES ON *.* TO username@'69.36.161.29';
SELECT password FROM user WHERE user='username';
UPDATE user SET password='password' where user='username';
I'm assuming you need to substitute the relevant values in the code above... Hit "go" on the page. When you're done that, you can close the PhpMyAdmin window.
Going back to your Site Manager, to restart the VDS click on (while still in the Site Management section) Site Parameters and then the Restart button on the page that appears.
That should cover you. Let me know how it goes.
Thanks for the tip...WestHost was able to fix the problem, a lot of which had to do with cgi-bin paths changing. :)