Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: linuxhelp on August 04, 2008, 01:48:05 AM

Title: Phpmyadmin only from local net...
Post by: linuxhelp on August 04, 2008, 01:48:05 AM

db configuration setprop phpmyadminmulti access (private|public)
signal-event ibay-modify
if i set to private or public an send a
signal-event post-upgrade
signal-event post-update

the phpadmin interface is open to internet? Why

Should i take an other paket?

Title: Re: Phpmyadmin only from local net...
Post by: janet on August 04, 2008, 02:03:25 AM

linuxhelp

It helps if you use the correct commands.

These commands should (generically always) enable a change:

db configuration setprop phpmyadminmulti access private
signal-event post-upgrade
signal-event reboot

If you look at the wiki here
http://wiki.contribs.org/Phpmyadminmulti
it says:

To limit access to local network :

db configuration setprop phpmyadminmulti access private
signal-event console-save

Note that usually a console save will require a reboot afterwards.

Title: Re: Phpmyadmin only from local net...
Post by: linuxhelp on August 04, 2008, 02:27:05 AM

Hi Mary

thanks for your help,

but why i phpmyadmin available to me? i can login as root
with setting private? ab reboot i have seen some red messages
from mysql - horde communication?

some headaches.. the admin account wasn't created at the installation on
phpmyadminmulti i was forced to make an mysqladmin -u root password newpassword to
open the phpmyadmin-interface

Bug?

Title: Re: Phpmyadmin only from local net...
Post by: janet on August 04, 2008, 03:04:15 AM

linuxhelp

I don't wish to troubleshoot your existing (somewhat scattered and obscure) problems.

I suggest uninstalling with

rpm -e smeserver-phpmyadmin-multiuser

Then try reinstalling using the instructions here:
http://wiki.contribs.org/Phpmyadminmulti

which are as simple as

Code: [Select]

wget
"http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"
yum localinstall smeserver-phpmyadmin-multiuser-*.noarch.rpm

Title: Re: Phpmyadmin only from local net...
Post by: william_syd on August 05, 2008, 02:37:29 PM

Quote from: mary on August 04, 2008, 03:04:15 AM

which are as simple as

Code: [Select]

wget
"http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"
yum localinstall smeserver-phpmyadmin-multiuser-*.noarch.rpm

What about....

[root@c3 ~]# yum --enablerepo=smecontribs install smeserver-phpmyadmin-multiuser

Title: Re: Phpmyadmin only from local net...
Post by: mmccarn on August 05, 2008, 03:14:56 PM

Quote from: linuxhelp on August 04, 2008, 02:27:05 AM

but why i phpmyadmin available to me? i can login as root
with setting private? ab reboot i have seen some red messages
from mysql - horde communication?

Setting a service to "private" access will allow access only from systems connected to one of the "local" networks.

If you have (for example) added 0.0.0.0/0 as a "local" network, then "private" access and "public" access will be identical.  What do you get from db networks show?

Title: Re: Phpmyadmin only from local net...
Post by: linuxhelp on August 05, 2008, 04:38:40 PM

Hello

thanks for help
is my network, but you are right i have set 0.0.0.0 at the "Remote access" to reach the
manager-interface during the net.. thats very unsecure?

192.168.178.0=network
    Mask=255.255.255.0
    SystemLocalNetwork=yes

Title: Re: Phpmyadmin only from local net...
Post by: mercyh on August 05, 2008, 08:53:20 PM

Quote

thats very unsecure?

YES as in no firewall at all.

This has been discussed many times in the forums. You need to either VPN into your server or you can use SSH with public/private keys to access the command line.

Title: Re: Phpmyadmin only from local net...
Post by: linuxhelp on August 05, 2008, 09:05:43 PM

Hello

ok i will test it next time, there is only one port public = 80 at the firewall-router
not more..

i try to learn the inside structure of sme more...

thanks..

Title: Re: Phpmyadmin only from local net...
Post by: mercyh on August 05, 2008, 09:18:13 PM

Quote

there is only one port public = 80 at the firewall-router
not more..

and you can access server-manager from the www ???

That is strange as server-manager is https: which is port 443.............. :-?