Koozali.org: home of the SME Server

Phpmyadmin only from local net...

Offline linuxhelp

  • *
  • 173
  • +0/-0
    • Linux PC & Server Support
Phpmyadmin only from local net...
« 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?
Linux PC & Server Support
http://www.linuxonlinehelp.de
.. i Love SME..

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: Phpmyadmin only from local net...
« Reply #1 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.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline linuxhelp

  • *
  • 173
  • +0/-0
    • Linux PC & Server Support
Re: Phpmyadmin only from local net...
« Reply #2 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?
Linux PC & Server Support
http://www.linuxonlinehelp.de
.. i Love SME..

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: Phpmyadmin only from local net...
« Reply #3 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
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Re: Phpmyadmin only from local net...
« Reply #4 on: August 05, 2008, 02:37:29 PM »

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

Regards,
William

IF I give advise.. It's only if it was me....

Offline mmccarn

  • *
  • 2,651
  • +10/-0
Re: Phpmyadmin only from local net...
« Reply #5 on: August 05, 2008, 03:14:56 PM »
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?

Offline linuxhelp

  • *
  • 173
  • +0/-0
    • Linux PC & Server Support
Re: Phpmyadmin only from local net...
« Reply #6 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
Linux PC & Server Support
http://www.linuxonlinehelp.de
.. i Love SME..

Offline mercyh

  • *
  • 824
  • +0/-0
    • http://mercyh.org
Re: Phpmyadmin only from local net...
« Reply #7 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.

Offline linuxhelp

  • *
  • 173
  • +0/-0
    • Linux PC & Server Support
Re: Phpmyadmin only from local net...
« Reply #8 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..
Linux PC & Server Support
http://www.linuxonlinehelp.de
.. i Love SME..

Offline mercyh

  • *
  • 824
  • +0/-0
    • http://mercyh.org
Re: Phpmyadmin only from local net...
« Reply #9 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.............. :-?