I cannot do a Global Installation of phpMyAdmin

Virtualmin
1
SYSTEM INFORMATION
OS type and version Ubuntu Linux 22.04.5
Webmin version 2.630
Usermin version 2.530
Virtualmin version 8.1.0 Professional
Theme version 26.30
Apache version 2.4.52
Package updates 48 package updates are available, of which 1 is security update

when installing phpMyadmin webapp I do not get an option to install this as a global app.

Can someone guide me how this should be done, perhaps with a picture of the install as global checkbox.

thanks

2

I don’t think anyone does from the install screen I see this

image
image1414×562 58.6 KB

the only thing I see is the auto login option & no option to globalise the app. can you supply a link to where you saw this feature being implemented

3
4

Most likely not been released yet as the option shown in the screen shot is not present,

image
image527×534 78.4 KB

try a dev build of virtualmin on a vm somewhere and see if the option is there

5

I think it is added, the back of my head says that something needs to be done on pre-existing systems to get this option to show.

image
image769×316 16.5 KB

6

This might be useless info, but before clicking go on a selected web installer, try the show install options button.

Also, you can get a narrow phpMyAdmin instance to be the manager for all databases without having Virtualmin set it as the go to instance. Inside the Webmin → Servers → MariaDB Database Server module look at the user management, and also the one next to it, maybe database connections section?

If you tweak the permissions in those two areas, you can give one login access to all the internal databases. You can also add login credentials with any limitations you desire for a user to get at a table without being a Virtualmin user at all.

If you do this second method, really think about how your security footprint is expanding.

7
  • I do not have this option.
  • I have checked the code is present on my dev system and it is up to date.
  • Maybe this is a bug, permission, or setting that needs to be turned on.
  • or there is a patch, but the ones I have seen address http_auth and not the setting being missing.

I am at a loss

8

Reading through the tooltip on the screenshot you supplied it looks like it needs to be enabled, perhaps there is a setting in the script installer module settings as suggested by @WNYmathGuy. Personally I don’t use the script installer to install phpmyadmin as it is in the repository which means I get the version that the version of my os recommends rather than a version that may need a different version of php which I might not have installed

9

@Ilia I know you are busy so if this is a bit more involved that a quick answer, it can wait, but my Global Install option is missing for phpMyAdmin.

I am running Virtualmin 8.1.0 Pro, was there something I needed to do to activate the global install option so it would appear, or is this a bug that is still present, maybe a patch is available, the only patches I found were for fixing a http_auth issue.

thanks

10

You need to be logged in as a master administrator to see that option. Are you?

11

Yes, I only ever log in with that at the minute.

12

Can you provide the full screenshot of the page, including the navigation menu and the user account used?

13

I will get that sorted I the morning. Thanks.

14
  • I don’t know if this has any relevance, this is my dev server and this is the server with the full list off apps but is GPL.
  • I have just updated to Webmin 2.650 this morning.
  • Is this a script caching issue?
  • I could not get the full menu in the image because it is scrollable.

So I made some images of my currently installed phpMyAdmin Web app

image
image1257×794 57.6 KB

image
image1260×771 67.9 KB

Proof that I have logged in using the master admin

image
image285×537 15.7 KB

I uninstalled phpMyadmin Web app so I could show the install page with no global option

image
image1254×781 68 KB

Is this what you need, I can do more if these are the wrong ones.

thanks

15

I don’t see global either, not that I need it :slight_smile:

16

I’d recommend waiting until a new Virtualmin 8.2.0 release comes out. I don’t see any good reason why it wouldn’t show up.

17

Are the script cache locally until a new app version is available?

18

It’s easy to check:

find / -name phpmyadmin.pl
19

So I ran the command above and got the 2 results. they do not have the same contents.

/usr/share/webmin/virtual-server/scripts/phpmyadmin.pl   12KB
/etc/webmin/virtual-server/latest-scripts/phpmyadmin.pl    21KB
  • Why is there 2 locations for scripts?
    • Pro and GPL?
  • Are the scripts downloaded upon demand or are the always stored locally? I always assume they were, but I still am not sure.
  • /usr/share/webmin/virtual-server/scripts/phpmyadmin.pl
    • This has the newer version of the script and has global_def and the http_auth code in it.
    • Are these Pro only scripts but also includes the Free ones
  • /etc/webmin/virtual-server/latest-scripts/phpmyadmin.pl
    • i am guessing this is the GPL only scripts folder
    • This version of my file is an old version

Does this help? Is the fix still to wait for v8.1.0 which I don’t mind.

thanks

20

One comes packaged, while the other gets updated whenever a new version of the app is available.

What is the output of:

ls -lsa /etc/webmin/virtual-server/latest-scripts/phpmyadmin.pl