Can phpMyAdmin be installed on Virtualmin?

30 posts / 0 new
Last post
#1 Sun, 07/19/2015 - 06:21
eiger3970

Can phpMyAdmin be installed on Virtualmin?

Hello, I think I need to install phpMyAdmin so I can install a CMS on the Virtualmin webserver. Can I install phpMyAdmin on Virtualmin? I Created a Database, but that doesn't seem to allow the CMS to connect the database it runs.

Mon, 07/20/2015 - 00:47
tpnsolutions
tpnsolutions's picture

Hi,

Yes, phpMyAdmin or any other database management tool can be installed a virutal server as desired.

Typically you need to "create database", then tell your CMS installer (or config file) how to connect to the newly created database including: hostname (often localhost), username, password, and database name.

Ask me about my new support plans which include a FREE copy of Virtualmin Pro!!!

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist
Fri, 07/31/2015 - 00:24
eiger3970

Thanks. I created the Virtualmin database, but apparently I need to set full privileges for the user. I'm trying to install phpMyAdmin, but error: No package phpmyadmin. I then need to figure out how to join the Virtualmin database to the CMS.

I set /home/domain.com/public_html to 777, but still doesn't load?

Mon, 07/27/2015 - 08:00
eiger3970

Thanks. How do I install phpMyAdmin on Virtualmin? I need this to allow a CMS to work. I don't see any clear instructions in the Virtualmin forums.

Mon, 07/27/2015 - 11:07
andreychek

Howdy,

phpMyAdmin is one of the Install Scripts, and is available even on Virtualmin GPL.

You can install that by going into the "Install Scripts" menu for any of your domains.

Note though that we don't recommend creating databases or adding permissions outside of Virtualmin -- you should be able to access a database with the permissions provided after creating it in Virtualmin.

If a database is created outside of Virtualmin, it won't be backed up.

If you're unable to access a database created from Virtualmin, then something unusual is going on... that may be the part that needs troubleshooting.

-Eric

Tue, 07/28/2015 - 01:04
eiger3970

Thanks. Yes, I'm happy to setup a database within Virtualmin, however the CMS in unable to setup a database. Therefore, the CMS people said to install phpMyAdmin.

Virtualmin > domain > Install Scripts > Available Scripts > Database > select radio button phpMyAdmin > 4.4.12 (Latest) > Show Install Options > error: This script cannot be installed, as this virtual server does not meet its requirements : phpMyAdmin requires MySQL version 5.5 or later

Virtualmin is currently on mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1.

I tried SSH into Virtualmin and command # sudo yum update mysql-server, but error:

Loaded plugins: fastestmirror Setting up Update Process Loading mirror speeds from cached hostfile * base: mirror.aarnet.edu.au * epel: epel.mirror.digitalpacific.com.au * extras: mirror.aarnet.edu.au * updates: mirror.aarnet.edu.au No Packages marked for Update

I can't find any clear Virtualmin documentation on how to upgrade the MySQL? https://www.virtualmin.com/node/33426 http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/updating-yum-repo.html

Tue, 07/28/2015 - 09:41
andreychek

The packages on your server, and the ones Virtualmin uses, are the ones included with your Linux distribution, which are all stable and known to work well.

You are currently using the most recent MySQL version available to your distribution.

We don't provide any documentation on upgrading MySQL, as we only recommend using the packages included with your distribution.

The only way to upgrade MySQL would be to use packages from third party repositories; those can often cause problems, and may not be as stable and reliable as the ones provided with your distribution. Problems can also occur during the upgrade process.

If you need a newer MySQL version, our recommendation is to upgrade your distribution, rather than using packages from a third party repository.

-ERic

Tue, 07/28/2015 - 17:43
eiger3970

Thanks. I found out that phpMyAdmin is quite flexible and does work on lesser MySQL 5.1 versions, as someone else tested and showed to me.

This tells me Virtualmin is causing a problem of false error.

Moving forward, I manually install phpMyAdmin on CLI, however now: phpmyadmin is in /home/domain/public_html/phpmyadmin. The browser has www.domain.com/phpmyadmin, but error: Not Found. The requested URL /phpmyadmin was not found on this server.

Tue, 07/28/2015 - 18:08
tpnsolutions
tpnsolutions's picture

HI,

As an alternative, you can always give "Adminer" a try, it's literally one (1) file in size.

http://www.adminer.org

Best Regards,
Peter Knowles
TPN Solutions

Email: pknowles@tpnsolutions.com
Phone: 604-782-9342
Skype: tpnsupport
Website: http://www.tpnsolutions.com

Ask me about my new support plans which include a FREE copy of Virtualmin Pro!!!

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist
Tue, 07/28/2015 - 19:08
eiger3970

Thanks. For now, I need to just use what the most common and easiest thing is. I'll stick with phpMyAdmin, which should work. Still figuring out what's broken.

Wed, 07/29/2015 - 08:34
tpnsolutions
tpnsolutions's picture

Hi,

Just so you know, "adminer" is what we use in place of phpMyAdmin, is a single file in size and equally as powerful. Most phpMyAdmin issues are either related to the version of MySQL or PHP installed on your system. That and/or missing PHP extensions.

I can be contracted for a small flat rate fee to address your installation should you continue to have problems. Drop me a line on Skype if you require my assistance with this or anything else.

Best Regards,
Peter Knowles
TPN Solutions

Email: pknowles@tpnsolutions.com
Phone: 604-782-9342
Skype: tpnsupport
Website: http://www.tpnsolutions.com

Ask me about my new support plans which include a FREE copy of Virtualmin Pro!!!

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist
Sat, 08/01/2015 - 18:37 (Reply to #11)
siteXmedia

I have just recommended http://sqlbuddy.com on another post but I forgot all about adminer, I have used it before and it is good

Wed, 07/29/2015 - 08:35
eiger3970

phpmyadmin is in /home/domain/public_html/phpmyadmin. The browser has www.domain.com/phpmyadmin, but error: Not Found. The requested URL /phpmyadmin was not found on this server.

Wed, 07/29/2015 - 09:05
andreychek

My best guess is that a global alias has been added to Apache, telling it to look somewhere else when /phpmyadmin is accessed.

That can happen if phpMyAdmin had been installed as a RPM/DEB package.

It's possible that package was since removed, but the config may be remaining, causing the problem you're seeing.

You may want to review your Apache config, and look for any lines in it that are setting up a phpMyAdmin alias.

-Eric

Wed, 07/29/2015 - 20:31
eiger3970

Thank you for the reply. I don't think an RPM/DEB package was installed into the Virtualmin server, running Red Hat CentOS 6.6.

phpMyAdmin was downloaded from https://www.phpmyadmin.net/downloads/ using this file: phpMyAdmin-4.4.12-english.tar.gz, into directory Virtualmin/home/domain.com/public_html, then unzipped and renamed to phpmyadmin.

There's an apache config file named httpd in /usr/sbin, however editing the httpd file show only gobbledegook script, unlike the usual script.

I found /etc/httpd/conf/httpd.conf which has a correct httpd.conf file. /etc/httpd/conf/httpd.conf code seems to show all the virtualservers/virtualhosts set up with the same style code for each virtualhost. I don't think there's any global alias code.

Wed, 07/29/2015 - 22:24
eiger3970

Someone thinks I should install to the main Virtualmin. I checked /usr/share and there's only a php direcory, not phpmyadmin directory.

I found this to install phpmyadmin on Virtualmin, but I'm wondering if apache and phpmyadmin are already installed on Virtualmin. INSTALLATION OF PHPMYADMIN

https://www.virtualmin.com/node/10199 1) If you want to install PhpMyAdmin from YUM's repository, you can check this page (http://wiki.mediatemple.net/w/Install_ISPConfig_on_CentOS_5.5), look for "Install Apache, MySQL, phpMyAdmin" 2) Edit /etc/httpd/conf.d/phpmyadmin.conf 3) Change internal "Aliases" in phpmyadmin.conf and save it 4) Restart Apache (/etc/init.d/httpd restart)

According this link https://www.virtualmin.com/node/9467, installing Virtualmin should install phpMyAdmin, but phpMyAdmin is not in the /usr/share folder?

Fri, 07/31/2015 - 00:18
eiger3970

So, still can't install a CMS, so trying to install the phpMyAdmin database. Can someone clarify the permissions which might be a factor? I manually installed phpMyAdmin (Virtualmin Install Script has error) on root and also the /home/domain.com/public_html. I assume I set permissions to 777 in root or /home/domain.com/public_html?

Fri, 07/31/2015 - 00:59
eiger3970

www.domain.com/adminer.php works and www.domain.com/phpsomedifferencenamemyadmin loads. ww.domain.com/phpmyadmin refuses to load.

Fri, 07/31/2015 - 09:55
andreychek

Howdy,

If files in the main public_html folder are accessible, then the only permission that should matter are to make sure that the phpmyadmin folder is world readable. You can do that using "chmod 755" on the phpmyadmin folder.

-Eric

Fri, 07/31/2015 - 10:26
eiger3970

Thanks. The /home/domain.com/public_html/phpmyadmin folder's permissions are: drwxr-xr-x 10.

Fri, 07/31/2015 - 20:35
eiger3970

Ok, so phpMyAdmin fixed and working on Virtualmin. Now back to the error: phpMyAdmin error: You should upgrade to MySQL 5.5.0 or later.

Fri, 07/31/2015 - 22:07
andreychek

Howdy,

The more recent versions of phpMyAdmin do indeed require MySQL 5.5.x.

Our suggestion is to use an older phpMyAdmin version without that requirement, that's the easiest way around that issue.

Alternatively, the only other thing we'd recommend is to use a distribution that comes with MySQL 5.5.

Some people do upgrade MySQL on older distributions, but that can be problematic... it doesn't always go smoothly, and you end up with a MySQL version that isn't as well tested.

-Eric

Sat, 08/01/2015 - 16:12
eiger3970

Ok, the old phpMyAdmin manual install worked. Now, I can focus on completing the CMS install.

Mon, 08/03/2015 - 05:10
privateventureclub

Hello,

I'm new to this Webmin control panel and setup my first Virtual server now when I go to install script I get this error message:

Failed to install script : Download of https://files.phpmyadmin.net/phpMyAdmin/4.4.11/phpMyAdmin-4.4.11-english... failed : Failed to lookup IP address for files.phpmyadmin.net

The same thing happend with installing SquirrelMail

Failed to install script : Download of http://prdownloads.sourceforge.net/sourceforge/squirrelmail/squirrelmail... failed : Failed to lookup IP address for prdownloads.sourceforge.net

Anyone who know what the problem here is???

Ferry

Mon, 08/03/2015 - 09:03 (Reply to #24)
andreychek

Howdy,

It sounds like your server is experiencing a DNS issue.

You may want to verify that the DNS servers listed in /etc/resolv.conf are correct, and that BIND is running.

If that doesn't help -- it may be best to start a new Forum thread, since the issue you're seeing is different from the issue being seen above... that'll make it easier to provide assistance. Thanks!

-Eric

Wed, 07/19/2017 - 02:26
eiger3970

Well, I've just had issues installing phpmyadmin again. After updating php, domain.tld/phpmyadmin was missing plugin mbstring. Fixed the mbstring plugin. Now error: Forbidden. You don't have permission to access /phpmyadmin/ on this server. /home/domain/public_html/phpmyadmin permission is drwxr-xr-x 10

Tue, 03/27/2018 - 01:21
eiger3970

Okay, I am refreshing this thread as phpmyadmin is installing nicely in Virtualmin GUI. However, the error when navigating to www.domain.tls/phpmyadmin says: Forbidden. Might be a duplicate of this new thread? https://www.virtualmin.com/node/56463

Tue, 04/03/2018 - 17:00
tpnsolutions
tpnsolutions's picture

@eiger3970,

Are you able to confirm that the "phpmyadmin" folder exists directly inside the "public_html" folder, and that all the files including "index.php" exist?

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist
Fri, 04/06/2018 - 04:15
eiger3970

Thanks, however this is now solved here https://www.virtualmin.com/node/56689

Sat, 04/07/2018 - 15:12
tpnsolutions
tpnsolutions's picture

@eiger3970,

Glad to hear you were able to resolve things :-)

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist