Vhost to phpmadmin.

[zyxep]

Hi there.

i have a big problem, i use Plesk to control my domains.
I hate the way to get into the phpmyadmin.
i want to make a simple link to phpmyadmin.

i have added a dns zone with name mysql.* to <ip>, then i edit manualy z010_psa_httpd.conf to get all mysql.* to the correct folder.

Everytime i install an update or do anything with the plesk it regenerates the config file.

Is there a simple mode to add this simple vhost to my config file?

 

[ziba@]

Hello,

Plesk does regenerate z010_psa_httpd.conf on update.
You can create new config file under /etc/httpd/conf.d - it will also be loaded by apache and will not be overwritten by Plesk so you should be able to put definition for mysql.* in this file.

 

[Amin Taheri]

If you wanted to do this on a per domain basis you could do

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -Ne "select Name from domains;" > /tmp/domainlist

for DOMAIN in `cat /tmp/domainlist` ; do 
"Whatever goes here" >> /var/www/vhosts/$DOMAIN/conf/vhost.conf;
"Whatever goes here" >> /var/www/vhosts/$DOMAIN/conf/vhost_ssl.conf;
done

/usr/local/psa/admin/sbin/websrvmng -va
rm -Rf /tmp/domainlist

You should of course try it on a single domain first. The method that ziba provided is more elegant and most likely the best way to do it, but if that doesnt work or isnt the way you want to do it then you can also try the way above.

 

[tim.johannessen]

I also wanted direct access foreach domain, using a global vhost, like webmail.* is mapped to horde, but
as far as I can tell, phpmyadmin is only present in /opt/psa/admin/htdocs/domains/databases/phpMyAdmin and setting up a vhost pointing to this directory doesn't seem to work, probably because of some ownership issues?

 

[tim.johannessen]

I also wanted to setup a global vhost for direct phpmyadmin access, just like it works with webmail.* which maps to horde (on my system) however, i tried to setup a phpmyadmin.* vhost, but as far as I can tell, phpmyadmin is only located under /opt/psa/admin/htdocs/domains/databases/phpMyAdmin - and setting the vhost to use this directory, doesn't seem to work - probably because of ownership or permission issues.

Anyone know how to fix this?

 

[Tim Johannessen]

Sorry for the double post, didn't notice the message stating that the post had to be approved before being visible.