No Clients appearing in the management console

[yoyocestmoi]

Hello,

I recently subscribed a dedicated server with Plesk installed. (8.01 on Fedora)

I successfully added a new client, and attached a new domain to it.

Then, several days later, I decided to delete this client , and recreate it again.

All creation steps went well (including, attaching an IP to the client).

But then, when looking again at the Clients lists, it remains empty.
I tried to add again the same client, but the system tells me the client already exists.
I tried to add other clients, with different names. Addition is succesful, but the clients list remains empty.

What should I do to retrieve my client list?

I had a look at the underlying database, and the clients table seems to be well populated with 3 records.

Thanks,

Lionel.

 

[raaqi]

I had similar problems with domain templates and client templates.

No amount of playing with the PSA database worked. The only way i fixed it was to REVERT to a backup of the PSA database 1 day before the problem.

If plesk is reporting that the client already exists, you may be able to fix it using the PSA dbase.

If you make a dump of your PSA database i'd like to take a look.
mysqldump -u admin -pPASSWORD --databases psa > psadump.sql

 

[yoyocestmoi]

Hello,

Actually, I didn't really had time to wait for a reply, as I have to install a website before the end of the weekend, so the best solution I found was reinstalling everything (Fedora, Plesk 8.01, etc....) on the server, and start from scratch.

Normally, I would have digged into the code to see which query is executed in order to retrieve existing clients, but here again, no time.

Concerning the psa database, is it automatically backed up every day? Is it done using mysqldump? When I have time, I'll perhaps manage to create scripts to automatically back it up every day or so.

Thanks,

Lionel.

 

[raaqi]

I created this little script. Works for me, alter it for your own use.


tb_timestamp=`/bin/date +%Y%b%d'-'%I%M%p`
tb_dir=/usr/local/backup/files/
tb_bakdir=/mnt/hdc3/backup/files/
tb_file=tb_psa_only_
tb_filename=$tb_dir$tb_file$tb_timestamp
tb_bakfilename=$tb_bakdir$tb_file$tb_timestamp


########## BACKUP PSA DATABASE #########
mysqldump -u admin -pPASSWORD --databases psa > $tb_filename.sql

########## COMPRESS IT UP ##############
tar -c -f $tb_filename.tar $tb_filename.sql --remove-files 2> /dev/null
gzip $tb_filename.tar

########## BACKUP ONTO HDC3 ############
cp $tb_filename.tar.gz $tb_bakdir

########## BACKUP ONTO FTP ############
lftp ftpbackup.com <<EOFTP
user UNAME PASSWORD
put $tb_filename.tar.gz
bye
EOFTP
echo Backup Fully Completed.