Topic: Phpmyadmin multiuser access

[beast]

Hi All

Tried to enable the multiuser access from here: http://wiki.contribs.org/PHPMyAdmin#Configuration

config setprop phpmyadmin multiaccess enabled
expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart

But even after restart the page https://myip/phpmyadmin-multi is not found.

Anything I have misunderstood?

Regards
Benny

[janet]

beast

Show output of
config show phpmyadmin

Where are you accessing from LAN or WAN ?
Did you use https ?
What IP did you use (LAN or WAN) in https://your-sme-ip/phpmyadmin-multi  ?

Did you configure private or public access ?

config setprop phpmyadmin access private
or
config setprop phpmyadmin access public

Followed by
signal-event ibay-modify

[beast]

Output of "config show phpmyadmin"

phpmyadmin=configuration
    access=private
    multiaccess=enabled

I try to access from LAN and tried both with https and http

I have not configured private or public access and therefore it must be private (https://my-sme-ip/phpmyadmin works fine).

Have tried both with the real LAN IP address and also with the main server domain name.

have made a "yum update" followed by "signal-event post-upgrade; signal-event reboot" after the multiuser access attemp with no change.

[janet]

beast

OK all that sounds fine.

Just checking though as you did not specify it, what IP did you use, is it the sme server LAN IP ?

Can you access the server Primary ibay homepage if you do
http://server-LAN-IP    ?


The latter section of the wiki article you refer to says:
"prevent the admin access

in certain cases you may want to forbid the adminaccess and allow only the multiaccess, so you have to set the adminaccess to disabled and the multiaccess to enabled

config setprop phpmyadmin adminaccess disabled
config setprop phpmyadmin multiaccess enabled

and do these commands

expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart

therefore the access for multi user will be available through the url https://your-sme-ip/phpmyadmin (instead of phpmyadmin-multi) "


It seems to imply that you can then only access using the URL
https://your-sme-ip/phpmyadmin

and not using
https://your-sme-ip/phpmyadmin-multi

so that appears to be what you are experiencing.
Is there really any problem ?

[beast]

Yes I am using the server LAN IP and I can access the primary http://server-LAN-IP with no problem.

I do not want to prevent the admin access so I have not followed the latter section and in my view this imply that both https://your-sme-ip/phpmyadmin and https://your-sme-ip/phpmyadmin-multi must be active currently?

I have also tried to use the user credentials at https://your-sme-ip/phpmyadmin but it just return with the login dialog all the time

[janet]

beast

show output of
rpm -q smeserver-phpmyadmin

or better still show
rpm -q smeserver-phpmyadmin libmcrypt php53-mcrypt php53-php-gettext phpMyAdmin3

[janet]

beast

Output of "config show phpmyadmin"
phpmyadmin=configuration
    access=private
    multiaccess=enabled

Well a default install of smeserver-phpmyadmin on sme8.1 shows
config show phpmyadmin
phpmyadmin=configuration
    access=private
    adminaccess=enabled
    multiaccess=disabled

So maybe adminaccess has become disabled & that's why access is limited.

Issue the following commands
config setprop phpmyadmin adminaccess enabled
config setprop phpmyadmin multiaccess enabled
expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart

Check the settings are are as desired/correct (this checks for typos or entry errors etc)
config show phpmyadmin

It should look like
phpmyadmin=configuration
    access=private
    adminaccess=enabled
    multiaccess=enabled

Then try again to access using the "multi" URL
https://your-sme-ip/phpmyadmin-multi

PS Note when you do finally get access via the multi login, you need to have previously added those users to the mysql database & given them permission (grant) to access various db's & tables, or else they will not be able to login.
These users are not the normal smeserver users (accounts).

PPS I just installed this following instructions in the wiki & it all appears to work for me.
I did not add seperate users to mysql & grant them permissions but I do get the multi user login page.

PPPS Furthermore with settings configured as
config show phpmyadmin
phpmyadmin=configuration
    access=private
    adminaccess=disabled
    multiaccess=enabled

Both the URLs
https://your-sme-ip/phpmyadmin
or
https://your-sme-ip/phpmyadmin-multi
open the multi user login page, which makes sense as the special smeserver admin user only login page is no longer accessible (ie being disabled).

[beast]

beast

show output of
rpm -q smeserver-phpmyadmin

or better still show
rpm -q smeserver-phpmyadmin libmcrypt php53-mcrypt php53-php-gettext phpMyAdmin3

smeserver-phpmyadmin-3.5.2.2-2.el5.sme
libmcrypt-2.5.8-4.el5.centos
php53-mcrypt-5.3.3-1.el5
php53-php-gettext-1.0.11-3.el5
phpMyAdmin3-3.5.4-1.el5

[beast]

After following your procedure I now have:

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

But I am still unable to access via

https://your-sme-ip/phpmyadmin-multi

as the page is not found and

https://your-sme-ip/phpmyadmin

does not allow me to access with a mysql user with permissions on a specific database (only mysql admin can get access)

?????

[beast]

BTW: Root is also listed as user in mysql but I am also unable to get access with this user??

    root    LinuxServer    Ja    ALL PRIVILEGES    Ja    Ret privilegier Ret privilegier   Eksporter Eksporter
   root    localhost    Ja    ALL PRIVILEGES    Ja    Ret privilegier Ret privilegier   Eksporter Eksporter

[beast]

BTW: Root is also listed as user in mysql but I am also unable to get access with this user??

    root    LinuxServer    Ja    ALL PRIVILEGES    Ja    Ret privilegier Ret privilegier   Eksporter Eksporter
   root    localhost    Ja    ALL PRIVILEGES    Ja    Ret privilegier Ret privilegier   Eksporter Eksporter

Just checked and the hash of the password is different so this makes sense - wonder what the password for this root user is then?

[janet]

beast

It seems you had a previous old install you did not tell us about.

smeserver-phpmyadmin-3.5.2.2-2.el5.sme
phpMyAdmin3-3.5.4-1.el5

Both those have newer versions in sme8 smecontribs repo
I suggest you do
yum upgrade smeserver-phpmyadmin phpMyAdmin3 --enablerepo=smecontribs

Followed by
config setprop phpmyadmin adminaccess enabled
config setprop phpmyadmin multiaccess enabled
expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart

Check the correct latest packages are installed using previously given command against those listed here
http://distro.ibiblio.org/smeserver/releases/8/smecontribs/i386/RPMS/

Note the simple yum update
command you did earlier did not specify the smecontribs repo switch
--enablerepo=smecontribs
so the newer packages were not found & updated

Note that the sme server OS install sets a root mysql user with a longish special password that you should never change.
That is the password to use if you are trying to login to phpmyadmin as user root, refer
http://wiki.contribs.org/MySQL

You should NOT need to reset this password unless you have manually changed it at the command prompt.
This is not the sme server root & admin user password, this is different to the mysql root user password.

Reinstalling the correct rpms should resolve your problems.

[beast]

It works fine now - thank you Janet