Phpmyadmin for NethServer

Howto
, , ,
1

Maintainer

Stephane de Labrusse AKA @stephdl (stephdl [@] de-labrusse.fr )

Description

Implementation of phpMyAdmin for Nethserver, from the original ideas and works of all developers involved in “smeserver-phpmyadmin”: http://wiki.contribs.org/PHPMyAdmin.

Installation

nethserver-phpmyadmin is on NethForge repository which is not part of default NethServer installation. Read the instructions for installing NethForge repository.

After nethserver-nethforge-release has been installed proceed with:

yum install --enablerepo=nethforge nethserver-phpmyadmin

see default settings, please issue that command in a root terminal

config show phpmyadmin

phpmyadmin=configuration
access=private
adminaccess=enabled
multiaccess=disabled

You have two principal modes to log in phpmyadmin, all combinations are possible.
You can use adminaccess and multiaccess together or one instead the other.

Mode adminaccess

Access with admin/password (same as the password of server-manager) via:

https://yourdomain/phpmyadmin

In this mode you are in a single mode only, no other ways to delegate the DB management to other users.

In order to enable or disable :

config setprop phpmyadmin adminaccess enabled/disabled
signal-event nethserver-phpmyadmin-save

Mode multiaccess

In this mode you can delegate the DB management to other users by the user and the password of the database.
Furthermore this mode is more convenient since the authentication is made with cookies. You can easily close the session.

With the multiaccess mode, the admin account gets a new password which comes from ‘/etc/my.pwd’.
Once you retrieve it, you can change it in the phpmyadmin session for a password more easier to recall.

to retrieve the admin password :

cat /etc/my.pwd

You can access via:

https://yourdomain/phpmyadmin-multi 		if adminacces is enabled and multiaccess is enabled

https://yourdomain/phpmyadmin 			if adminacces is disabled and multiaccess is enabled

In order to enable or disable :

config setprop phpmyadmin multiaccess enabled/disabled
signal-event nethserver-phpmyadmin-save

Restrict access (local network or internet)

You can set how the access to phmyadmin is allowed

public : all internet (can be dangerous)
private : only your local network

In order to enable or disable :

config setprop phpmyadmin access public/private
signal-event nethserver-phpmyadmin-save
4 Likes
2

just installed…good work @stephdl !

1 Like
3

hi now it has a Bug ,
after i run signal-event nethserver-phpmyadmin-save
i could not access to WebUi by user “admin”

Pasted image1440×900 91.8 KB

4

@Nas You are trying to enter nethserver or phpmyadmin?

https://yourdomain/phpmyadmin-multi
https://yourdomain/phpmyadmin

5

I try to login to phpmyadmin and webui, in template I found old DB parameter , maybe it does some harm :frowning:

6

Yellow Crowd;
wondering if I was alone in my ship!
actually the installation works pretty well
and from what I see, i’m in single admin access mode
when I tried to authentified myself nothing work
I’d tried with the user root or admin
with my common password working for the SSH and the WEBUI
and or Nethesis,1234 even with the one from /etc/my.pwd
but without success

it is normal, should I restart mysql into a rescue mode and reset the root mysql password ?

Thank!

Jonathan

7

So i’d just reset my admin password with the same password, and now my admin/root password works for phpmyadmin :wink:

I just tried by passing in multiuser mode and it work too

Great works @stephdl

1 Like
8

Will phpmyadmin be included a module for NS7?

I have tried to install the current version of phpmyadmin (using the compressed source provided by the project site) and found that it requires PHP version 5.5.0 or above (NS7 RC2 has v5.4.16 installed).

9

Please check this:
http://wiki.nethserver.org/doku.php?id=phpmyadmin

3 Likes
10

A good walk-through provided by stephdl!

3 Likes
11

Hello,
I do not know 'if they are in the right place.
my question is:
if you change my ip to the server after there 'more access to the phpmyadmin
If ip reset returns available.

12

I’m not sure to fully understand your question, but phpmyadmin is alias based in apache, so it never looks after the server IP.

to reach phpmyadmin

https://SERVER_IP/phpmyadmin

13

¿It uses the trusted networks for config the Apache?, if not please tell me how to write the template to allow OpenVPN network for phpmyadmin.

14

openvpn should be part of the local network, at least for openvpn bridge

15

I made the probe, it´s only to declare the trusted network and signal-event nethserver-phpmyadmin-save makes the right template.

This is pretty good. Salud2

16

You even don’t need to launch the event netheserver-phpmyadmin-save, the event trusted-networks-modify when you save the new local network in the panel should be enough, but I missedd to restart the http service

new version is coming

17

done