Changing the default IP PLesk 11

[KrazyBob]

The instructions for changing the default IP in Plesk 11 do not appear to be the same as for Plesk 8.x, 9.x and 10.x. They were:

Code: Select all

mysql> select IP_Addresses.ip_address from IP_Addresses, misc where misc.val=IP_Addresses.id and misc.param='def_ip_id';
------------------+
| ip_address      |
+-----------------+
| 123.123.123.123 |
+-----------------+
1 row in set (0.00 sec)

mysql>
Default IP address is set during initial configuration. You should reconfigure Parallels Plesk Panel anew to change default IP address.

If Parallels Plesk Panel is configured parameter 'psa_configured' is set to 'true' in table psa.misc:


mysql> select * from misc where param='psa_configured';
+----------------+------+
| param          | val  |
+----------------+------+
| psa_configured | true |
+----------------+------+
1 row in set (0.00 sec)

mysql>
To perform initial configuration, change parameter 'psa_configured' to 'false':

mysql> update misc set val='false' where param='psa_configured';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

If they are the same then the mysql password is not the default that I set. In that case how does one change the default mysql password in Plesk 11?

Code: Select all

[root@hw006 ~]# vzctl enter 114
entered into Container 114
CT-114-bash-4.1# mysql -uadmin -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

I can login in fine.

[KrazyBob]

I should say that I can login to admin and SSH, not mysql.

I don't want to corrupt a working server. This used to allow me to delete a stubborn IP. Now Plesk 11 says I cannot delete an IP because it is assigned to DNS -- to nothing.

Code: Select all

Error: IP address xx.xx.xx.xx cannot be removed because it is used by DNS zone of one or more domains. 

NOPE. Not assigned to anything.

Code: Select all

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa;
mysql> delete from IP_Addresses where ip_address = 
mysql> 'THAT.IP.ADDRESS.HERE';