PHPMyAdmin

[CSN-Carl]

Why is Plesk 9 still shipping with PHPMyAdmin 2.8.4 ?

 

[GARMTECH]

I'm not sure about current Plesk 9 package, but they really should provide a how-to on manual PHPMyAdmin upgrade, or at least provide on-time updates for that.

 

[TerryM]

Totally agreed, as I also do not know how to upgrade phpMyAdmin to the latest version (and seems strange this is not done for Plesk 9), any help much appreciated.

Thank you
Terry

 

[Kalimari]

Setting up sepearte phpMyAdmin from Plesk

This should only be attempted if you are comfortable using command line

In Plesk (up to 8.6, not sure if this will work under 9):

1. Select your primary_domain (one which uses https)
2. create new web_user (e.g. myadmin) give scripting privileges and check php option

SSH as root:

1. Get latest version of phpMyAdmin, unzip and clean up:
cd /var/www/vhosts/primary_domain/web_users/
wget http://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-3.1.1-english.tar.bz2
bunzip2 -d phpMyAdmin-3.1.1-english.tar.bz2
tar -xvf phpMyAdmin-3.1.1-english.tar
rm phpMyAdmin-3.1.1-english.tar

2. Copy the unpacked dir to myadmin (or whatever web user you created in plesk step 2) and clean up:
mv --reply=no phpMyAdmin-3.1.1-english/* myadmin
rm -r phpMyAdmin-3.1.1-english

3. Set correct ownership of dir/contents to match pleskusername (change to whatever the username the webuser uses):
chown pleskusername.psaserv myadmin
chown -R pleskusername.psaserv myadmin/*

4. Configure phpMyAdmin to use http authentication:
cd myadmin
cp config.sample.inc.php config.inc.php
vi config.inc.php and alter as follows:
$cfg['Servers'][$i]['auth_type'] = 'http';

5. Now alter vhost, check apache config and restart
cd ../conf
vi vhost_ssl.conf (remember https only)
Alias /myadmin /var/www/vhosts/primary_domain/web_users/myadmin
/usr/sbin/apachectl configtest
OK?
/etc/init.d/httpd reload
NOTE: You may have to run: /usr/local/psa/admin/sbin/websrvmng -u --vhost-name=primary_domain first!

6. Go to browser:
https://www.primary_domain/myadmin/
Note: it is also accessible via: https://www.primary_domain/~myadmin

Username/password as for https://www.primary_domain:8443

This could probably be done using a subdomain just as easily...

 

[TerryM]

Hi

Thanks for that but as it has not been tried on Plesk 9, I will leave for now as I have just upgraded to plesk 9.

Much appreciated.
Terry

 

[breun]

I wouldn't know why this wouldn't work under Plesk 9. It's the same Apache after all.

I just install the phpMyAdmin package from the EPEL repository. That's even easier to set up, and yum keeps it up to date for me.

 

[TerryM]

I wouldn't know why this wouldn't work under Plesk 9. It's the same Apache after all.

I just install the phpMyAdmin package from the EPEL repository. That's even easier to set up, and yum keeps it up to date for me.

Anychance you can tell me if when installing phpMyAdmin there is any other settings that need to be, to make compatible with the databases etc. in Plesk as surely there is custom build of config.

 

[breun]

There is no Plesk-specific config needed. As far as phpMyAdmin is concerned, you're just running a plain MySQL server (and you are, really).

 

[TerryM]

There is no Plesk-specific config needed. As far as phpMyAdmin is concerned, you're just running a plain MySQL server (and you are, really).

Ah yes I know I can install easily to each domain but I wanted to replace the one Plesk uses for its own use from Control Panel etc. aswell

Thanks for your help

 

[breun]

You can install your own phpMyAdmin using a global alias, so you don't need to install it for every domain. Even better: install it on an SSL-enabled domain and let your customers use that copy.

Replacing the phpMyAdmin in Plesk is probably not something you want to do yourself, as that one is heavily patched specifically to work inside Plesk (I believe).

 

[TerryM]

You can install your own phpMyAdmin using a global alias, so you don't need to install it for every domain. Even better: install it on an SSL-enabled domain and let your customers use that copy.

Replacing the phpMyAdmin in Plesk is probably not something you want to do yourself, as that one is heavily patched specifically to work inside Plesk (I believe).

Thanks, yeah found that out last year when we tried to replace Plesks but shame when Plesk 9 was released they did not update the Plesk version of phpMyAdmin and left at a quite old version now.

Will consider adding phpMyAdmin like you say but for now like many just want a stable Plesk back lol, and maybe after getting Plesk 9 to work again will never update again. Just to make sure never get these issues again.

 

[105547111]

If anyone can write a updated phpmyadmin would be Scott from atomic. I think the patching is simply different configs and file locations rather than a true patch.

Hopefully Scott may see this and comment

 

[TerryM]

If anyone can write a updated phpmyadmin would be Scott from atomic. I think the patching is simply different configs and file locations rather than a true patch.

Hopefully Scott may see this and comment

Yeah would be great if somebody could do this as not sure why in new versions we get left with older stuff, eg. AwStats is old and 6.8 is out. I am manually updating that now, but not the point. We pay good money for hopefully good quality.

 

[GravuTrad]

Parallels has already struggling to out new corrects versions and updates for plesk, you ask the impossible lol...

without laughing, it should be done to each update (updating of the softwares used..), why they don't do it??