OK this was driving me nuts and i finally figured it out.. i had all my domains setup fine and my hostname was changed and everything was working, but there was one minor annoyance. Everytime i created a new client, the notification email had in it. Nowhere on the system could i find that name when i grep'd except for some log entries. I had of course overlooked any mysql entries. :eek:

so if you're client creation notifications look something like this:

QUOTE

Subject: Notification of the client creation.

This is a notification of new client creation from Plesk.
Client contact name: test dude
Client login: testerman
Client password: testes
Plesk entry point: https://plain.rackshack.net:8443

then what you need to do is this:
(first off, be sure you have properly and completely changed your hostname already and tested services after that.

1.) i found some lingering PTR records in /var/named/ those should be cleaned up.

2.) do a mysqldump of your psa database with something like:
mysqldump -u root -pYourPassword --databases psa > psadump.sql

3.) open that psadump.sql in an editor. you need to check two tables specifically, one is called 'misc' and the other is 'dns_recs'. The important one is 'misc' which holds the 'FullHostName' variable which is what I had to change from plain.rackshack.net to my domain name. In dns_recs there was just a lingering incorrect PTR record.

4.) be sure to save your changes to your sql dump file.

5.) log into mysql and drop the psa database with "drop databse psa;" then logout of mysql and at the command line re-import the dump file with something like this:
mysql -u root -pYourPass < psadump.sql

i am sure there are easier and better ways of making those changes but i dont know much sql so this is the easy way for me. hopefully, someone will write a better guide to this than me later.

thanks,
mOjO

p.s. i think we should be strongly disappointed in plesk for not making available a simple tool for making these changes for us.

someobody asked me how to drop the psa database so here's quickie on the mysql commands:

i will assume that you know how to get to an ssh shell prompt.

heres the commands i posted so far.. i will just take those and cleanup a bit...

1.) i found some lingering PTR records in /var/named/ those should be cleaned up.

2.) do a mysqldump of your psa database with something like:


3.) open that psadump.sql in an editor. you need to check two tables specifically, one is called 'misc' and the other is 'dns_recs'. The important one is 'misc' which holds the 'FullHostName' variable which is what I had to change from plain.rackshack.net to my domain name. In dns_recs there was just a lingering incorrect PTR record.

4.) be sure to save your changes to your sql dump file. be very careful editing this dump because if the syntax is screwed then so are you. ;-)

5.) log into mysql and drop the psa database with:

(yes you need the ';') then logout of mysql with "q" and at the command line re-import the altered dump file with this:


now it would likely be a good idea to restart plesk with:


that should be it. :-)

JohnM recently posted this as a better way to do it in another thread and i thought it should be in this one too:

[SNIP]

Renaming Plesk 6 Sever

Hi,

I don't think it's necessarily a good idea to drop the whole PSA database just to change 1 value.

I think the following is a better way. get yourself logged in via SSH, then do this:

1. mysql -u admin -p psa

##psa is the database##
##you will be prompted for a password, this will be your Plesk admin password##

2. whatever-your-password-is

##misc is the PSA table that holds the server name##
##at the mysql prompt enter the following##

3. update misc set val='whatever-you-want-to-call-your-server' where param='FullHostName';

##you will get a reply saying 1 record has been changed##

There is no need to dump the database and is only asking for trouble.

Good luck.
John

[/SNIP]

Thanks - could a mod move this to the Plesk How To forum, so that it does not get lost

better yet.. someobody should just jump on plesks a** to make a script or interface for doing this for you... i mean they took out the reconfigurator script and replaced it with...???

and did anyone notice how the passwords for everything are stored right there in plain text in the psa database? nice security feature that is... :eek:

ok.. sorry about the rant.. but i must have logged 6 hours looking for where that stupid notification email was pulling that domain value from...