Koozali.org: home of the SME Server
Obsolete Releases => SME 8.x Contribs => Topic started by: beast on March 18, 2014, 11:52:09 PM
-
Hi All
Tried to enable the multiuser access from here: http://wiki.contribs.org/PHPMyAdmin#Configuration (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 (https://myip/phpmyadmin-multi) is not found.
Anything I have misunderstood?
Regards
Benny
-
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
-
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.
-
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 ?
-
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
-
beast
show output of
rpm -q smeserver-phpmyadmin
or better still show
rpm -q smeserver-phpmyadmin libmcrypt php53-mcrypt php53-php-gettext phpMyAdmin3
-
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
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
-
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)
?????
-
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
-
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?
-
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.
-
It works fine now - thank you Janet :-P