psa database

[pahuja]

I am using a code that accesses information from the psa database. This database stores all information about the servers and hosting and has several tables. I am not able to locate where the following information is stored.
a) FTP username
b) FTP password
c) control panel username and password

Thanks

 

[brainlag]

Why don't you use Plesk powertoys ? Much easier and GUI.

 

[pahuja]

Powertoys does not give me all details that I want and I have done almost everything else. I am unable to find the table where this information is stored. One I find this, my job is complete.

 

[jamesyeeoc]

It's not in a single table. Usernames (all) are stored in 'pd_users' table, passwords are stored in 'accounts' table. Referenced via 'pd_users.account_id' ==> 'accounts.id'.

 

[pahuja]

I am on Plesk 8.0
my pd_user contains the following fields
id | int(10) unsigned
login | char(20) binary
passwd | char(15)
pd_id | int(10) unsigned

the accounts table is

id | int(10) unsigned
type | enum('plain','crypt')
password varchar(255).

The solution which you have offered does not help.

Thanks