phpmyadmin


Is this Nethserver module helpful to you?
Please consider donating to the author

Thank you kindly!

2019/03/04 11:32 · HF

Available NS6 and NS7

Implementation of phpMyAdmin for Nethserver, from the original ideas and works of all developers involved in smeserver-phpmyadmin.

Stephane de Labrusse at stephdl@de-labrusse.fr

NS7

First you need to install my repository, see how to do it

Then you can install the module

yum install nethserver-phpmyadmin --enablerepo=stephdl

NS6

yum install nethserver-phpmyadmin --enablerepo=stephdl

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

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

You have only the multiaccess mode, the login is admin and the password is stored under /root/.my.cnf. Once you retrieved it, you can change it in the phpmyadmin session for a password more easier to recall.

do in a terminal

cat /root/.my.cnf

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 (think to set a password to the user admin) 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 retrieved 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

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
mod_authnz_external-3.2.6-1.el6.x86_64.rpm  php-php-gettext-1.0.12-1.el6.noarch.rpm  php-tcpdf-dejavu-sans-fonts-6.2.11-1.el6.noarch.rpm
phpMyAdmin-4.0.10.18-1.el6.noarch.rpm       php-tcpdf-6.2.11-1.el6.noarch.rpm        pwauth-2.3.10-5.el6.x86_64.rpm

Please raise Issues on github

  • phpmyadmin.txt
  • Last modified: 2019/03/04 11:40
  • by HF