![]() ![]() Select domains.name,dns_recs.host,dns_recs.type,dns_recs.val from domains,dns_recs where domains.dns_zone_id=dns_recs.dns_zone_id and domains.name=’’ Select domains.name,log_rotation.period_type,log_rotation.period,log_rotation.max_number_of_logfiles,log_rotation.turned_on from domains,dom_param,log_rotation where domains.id=dom_param.dom_id and dom_param.param=”logrotation_id” and dom_param.val=log_rotation.id Mysql psa -uadmin -p`cat /etc/psa/.psa.shadow` -e ‘select sys_,sys_users.login,accounts.password from sys_users,accounts where sys_users.account_id=accounts.id order by home ’ Select clients.login, accounts.password from clients,accounts where clients.account_id=accounts.id Select domains.name,sys_users.login,accounts.password,clients.email from domains,sys_users,hosting,accounts,clients where domains.id=hosting.dom_id and hosting.sys_user_id=sys_users.id and sys_users.account_id=accounts.id and clients.id=domains.cl_id order by domains.name Select domains.name,sys_users.login,accounts.password from domains,sys_users,hosting,accounts where domains.id=hosting.dom_id and hosting.sys_user_id=sys_users.id and sys_users.account_id=accounts.id order by domains.name ĭomain Users accounts and passwords and email. Mysql psa -uadmin -p`cat /etc/psa/.psa.shadow` -e ‘select domains.name, accounts.password from domains, accounts, dom_level_usrs where domains.id=dom_level_usrs.dom_id and accounts.id=dom_level_usrs.account_id order by domains.name ’ Select domains.name,IP_Addresses.ip_address from domains,hosting,IP_Addresses where domains.id=hosting.dom_id and hosting.ip_address_id=IP_Addresses.id order by IP_Addresses.ip_address,domains.name ftp users with additional details(shell,quota):.Show database users and passwords created in Plesk. ![]() List all Mail redirect/forwards to external domains:.List status of all mail to non-existent users:.All enabled mailboxes (local or redirect).Bandwidth by service for the month(change date string accordingly).Domains expiration in human readable time.SSL certificate files not in use by any domain.SSL certificate files associated with IP address.SSL certificate files associated with default domain on IP.SSL certificates installed under domains.I got some Parallel Certifications a couple years ago, this stuff will help you mine mysql information that you might need if your running a business. I decided to blog this for people who use parallels plesk with mysql.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |