Virtualmin GPL & phpMyAdmin

Virtualmin
1

This is a two part post with regards to Virtualmin GPL 3.84 on CentOS 5.6

  1. Is it possible to have one single phpMyAdmin install for all vhosts, instead of one per vhost?

  2. The correct name of the yum package for mcrypt on CentOS 5.6 (in my case) is “php-mcrypt.x86_64”, but Virtualmin doesnt seem to know that. It failed to install mcrypt:

… download complete.

PHP module mcrypt is recommended …
Enabling module in PHP configuration …
… done
Installing package php5-mcrypt …
Installing package(s) with command yum -y install php5-mcrypt …

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile

  • atomic: www4.atomicorp.com
  • base: mirror.san.fastserv.com
  • extras: mirror.san.fastserv.com
  • updates: mirrors.versaweb.com
    Setting up Install Process
    Resolving Dependencies
    –> Running transaction check
    —> Package php-mcrypt.i386 0:5.3.6-3.el5.art set to be updated
    –> Processing Dependency: libltdl.so.3 for package: php-mcrypt
    –> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt
    —> Package php-mcrypt.x86_64 0:5.3.6-3.el5.art set to be updated
    –> Processing Dependency: libltdl.so.3()(64bit) for package: php-mcrypt
    –> Processing Dependency: libmcrypt.so.4()(64bit) for package: php-mcrypt
    –> Running transaction check
    —> Package libmcrypt.x86_64 0:2.5.8-4.el5.centos set to be updated
    —> Package libtool-ltdl.i386 0:1.5.22-7.el5_4 set to be updated
    —> Package libtool-ltdl.x86_64 0:1.5.22-7.el5_4 set to be updated
    —> Package php-mcrypt.i386 0:5.3.6-3.el5.art set to be updated
    –> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt
    –> Finished Dependency Resolution
    php-mcrypt-5.3.6-3.el5.art.i386 from atomic has depsolving problems
    –> Missing Dependency: libmcrypt.so.4 is needed by package php-mcrypt-5.3.6-3.el5.art.i386 (atomic)
    Error: Missing Dependency: libmcrypt.so.4 is needed by package php-mcrypt-5.3.6-3.el5.art.i386 (atomic)
    You could try using --skip-broken to work around the problem
    You could try running: package-cleanup --problems
    package-cleanup --dupes
    rpm -Va --nofiles --nodigest
    The program package-cleanup is found in the yum-utils package.
    … install failed!
    Installing package php53-mcrypt …
    Installing package(s) with command yum -y install php53-mcrypt …

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile

Configuring Apache PHP settings …
… done
Applying web server configuration …
… done

Now installing phpMyAdmin version 3.3.9.2 …

See here for more info regarding how picky CentOS is with the name of mcrypt package.

2
1) Is it possible to have one single phpMyAdmin install for all vhosts, instead of one per vhost?

I’d actually recommend setting up phpMyAdmin in one central Virtual Server, and having your users access that one central Virtual Server.

So if your server’s domain name is “example.com”, you could setup phpMyAdmin in a domain named “phpmyadmin.example.com”, and have your users access that.

2) The correct name of the yum package for mcrypt on CentOS 5.6 (in my case) is “php-mcrypt.x86_64”, but Virtualmin doesnt seem to know that. It failed to install mcrypt:

Well, it looks like you have a third party repository enabled that may be causing some problems.

It’s trying to pull in the php-mcrypt package from that repo, but yum isn’t seeing one of the dependencies that package has, “libmcrypt.so.4”.

-Eric

3

  1. how would I do that? “install script” is a subfeature of a vhost, not of virtualmin as a whole, and it defaults to only give access to the DBs that belong to that vhost. i cant even login as root (which shouldnt be done since phpmyadmin login pages is not https)

  2. would that repo be atomic?

Thanks!

4

erased because of double post.

5

1) how would I do that? “install script” is a subfeature of a vhost, not of virtualmin as a whole, and it defaults to only give access to the DBs that belong to that vhost. i cant even login as root (which shouldnt be done since phpmyadmin login pages is not https)

If you setup phpMyAdmin for a given Virtual Server, although it belongs to that specific Virtual Server, any user should be able to use it, and gain access to all the databases they have permission to see.

would that repo be atomic?

Yup, the Atomic repository isn’t enabled on a default CentOS setup, and the dependency issues you’re seeing are related to the packages within it. You’d need to work with the Atomic folks to figure out what’s going wrong there :slight_smile:

Alternatively, if you just want a newer PHP version, there’s a package named “php53” that comes with CentOS 5.6 that provides PHP 5.3.3. Or, you could obtain PHP 5.2.17 by using the Virtualmin bleed repository, as described here:

http://www.virtualmin.com/documentation/system/bleed

6

I had real headaches installing Magento 1.5.1 on CentOS 5.6, not just because of upgrading PHP 5.1 to PHP 5.3.6 but also getting phpMyAdmin on it. Anyway, I wrote a full post on it with step by step detailed commands - http://www.geakeit.co.uk/2011/06/09/installing-magento-1-5-1-on-centos-5-6-x64/