Beginning with phpPgAdmin

[Paul Smith]

Dear All

I have just installed phpPgAdmin and I have PostgreSQL running fine on
my computer. However, I do not know how to start phpPgAdmin. In fact,
I have never used php related stuff. Could someone please help me with
that?

Thanks in advance,

Paul

[Paul Smith]

On 2/4/06, Paul Smith  wrote:
> I have just installed phpPgAdmin and I have PostgreSQL running fine on
> my computer. However, I do not know how to start phpPgAdmin. In fact,
> I have never used php related stuff. Could someone please help me with
> that?

Do I need to install apache? The documentation on phpPgAdmin's site
does not indicate how to start it, up to my best knowledge.

Paul

[Craig White]

On Sat, 2006-02-04 at 21:54 +0000, Paul Smith wrote:
> On 2/4/06, Paul Smith  wrote:
> > I have just installed phpPgAdmin and I have PostgreSQL running fine on
> > my computer. However, I do not know how to start phpPgAdmin. In fact,
> > I have never used php related stuff. Could someone please help me with
> > that?
>
> Do I need to install apache? The documentation on phpPgAdmin's site
> does not indicate how to start it, up to my best knowledge.

----
yes - httpd would have to be installed...

probably php-pgsql too.

probably perl-DBI but I think that gets installed in most cases...

'yum install php-pgsql' would probably bring in everything you would
need as dependencies.

I tend to use tarball...

tar zxvf phppgadmin*

mv whatever the folder you just untarred to /var/www/html/phppgadmin

edit /var/www/html/phppgadmin/conf/conf.inc.php

to suit your situation

chkconfig httpd on

point your browser...

http://localhost/phppgadmin

Have at it.

Craig

[Paul Smith]

On 2/4/06, Craig White  wrote:
> > > I have just installed phpPgAdmin and I have PostgreSQL running fine on
> > > my computer. However, I do not know how to start phpPgAdmin. In fact,
> > > I have never used php related stuff. Could someone please help me with
> > > that?
> >
> > Do I need to install apache? The documentation on phpPgAdmin's site
> > does not indicate how to start it, up to my best knowledge.
>
> yes - httpd would have to be installed...
>
> probably php-pgsql too.
>
> probably perl-DBI but I think that gets installed in most cases...
>
> 'yum install php-pgsql' would probably bring in everything you would
> need as dependencies.
>
> I tend to use tarball...
>
> tar zxvf phppgadmin*
>
> mv whatever the folder you just untarred to /var/www/html/phppgadmin
>
> edit /var/www/html/phppgadmin/conf/conf.inc.php
>
> to suit your situation
>
> chkconfig httpd on
>
> point your browser...
>
> http://localhost/phppgadmin
>
> Have at it.

Thanks, Craig. When pointing to

http://localhost/phpPgAdmin

I get

"Firefox can't establish a connection to the server at localhost."

Any ideas? Firewall, maybe?

Paul

[John Summerfield]

Paul Smith wrote:
> > point your browser...
> >
> > http://localhost/phppgadmin
> >
> > Have at it.
>
> Thanks, Craig. When pointing to
>
> http://localhost/phpPgAdmin
>
> I get
>
> "Firefox can't establish a connection to the server at localhost."
>
> Any ideas? Firewall, maybe?

I hate "friendly" messages. Try
telnet localhost 80

I suspect it will say "connection refused" which means there's nothing 
listening on that port at that address.

It could also be firefox is configured to use some other machine as a 
proxy. That could mean "localhost" us the proxy box.

[Craig White]

On Sat, 2006-02-04 at 22:50 +0000, Paul Smith wrote:
> On 2/4/06, Craig White  wrote:
> > > > I have just installed phpPgAdmin and I have PostgreSQL running fine on
> > > > my computer. However, I do not know how to start phpPgAdmin. In fact,
> > > > I have never used php related stuff. Could someone please help me with
> > > > that?
> > >
> > > Do I need to install apache? The documentation on phpPgAdmin's site
> > > does not indicate how to start it, up to my best knowledge.
> >
> > yes - httpd would have to be installed...
> >
> > probably php-pgsql too.
> >
> > probably perl-DBI but I think that gets installed in most cases...
> >
> > 'yum install php-pgsql' would probably bring in everything you would
> > need as dependencies.
> >
> > I tend to use tarball...
> >
> > tar zxvf phppgadmin*
> >
> > mv whatever the folder you just untarred to /var/www/html/phppgadmin
> >
> > edit /var/www/html/phppgadmin/conf/conf.inc.php
> >
> > to suit your situation
> >
> > chkconfig httpd on
> >
> > point your browser...
> >
> > http://localhost/phppgadmin
> >
> > Have at it.
>
> Thanks, Craig. When pointing to
>
> http://localhost/phpPgAdmin
>
> I get
>
> "Firefox can't establish a connection to the server at localhost."
>
> Any ideas? Firewall, maybe?

----
try 'service httpd start'

Craig

[Paul Smith]

On 2/4/06, Craig White  wrote:
> > > > > I have just installed phpPgAdmin and I have PostgreSQL running fine on
> > > > > my computer. However, I do not know how to start phpPgAdmin. In fact,
> > > > > I have never used php related stuff. Could someone please help me with
> > > > > that?
> > > >
> > > > Do I need to install apache? The documentation on phpPgAdmin's site
> > > > does not indicate how to start it, up to my best knowledge.
> > >
> > > yes - httpd would have to be installed...
> > >
> > > probably php-pgsql too.
> > >
> > > probably perl-DBI but I think that gets installed in most cases...
> > >
> > > 'yum install php-pgsql' would probably bring in everything you would
> > > need as dependencies.
> > >
> > > I tend to use tarball...
> > >
> > > tar zxvf phppgadmin*
> > >
> > > mv whatever the folder you just untarred to /var/www/html/phppgadmin
> > >
> > > edit /var/www/html/phppgadmin/conf/conf.inc.php
> > >
> > > to suit your situation
> > >
> > > chkconfig httpd on
> > >
> > > point your browser...
> > >
> > > http://localhost/phppgadmin
> > >
> > > Have at it.
> >
> > Thanks, Craig. When pointing to
> >
> > http://localhost/phpPgAdmin
> >
> > I get
> >
> > "Firefox can't establish a connection to the server at localhost."
> >
> > Any ideas? Firewall, maybe?
>
> try 'service httpd start'

That is it: working now. Thanks!

Is there some danger that somebody malicious from outside can get
access to my databases, since the access is done via a web-browser?
What are the cautions to take?

Paul

[jludwig]

On Saturday 04 February 2006 18:18, Paul Smith wrote:
> On 2/4/06, Craig White  wrote:
>
> Is there some danger that somebody malicious from outside can get
> access to my databases, since the access is done via a web-browser?
> What are the cautions to take?
>
> Paul

If you have properly set up your firewall there should be no greater danger 
than before. 
Also make sure apache only listens to 127.0.0.1:80 or it will bind to all (I.E 
*.*.*.*:80) addresses. -->If I remember correctly.

[Craig White]

On Sat, 2006-02-04 at 23:18 +0000, Paul Smith wrote:
> On 2/4/06, Craig White  wrote:
> > > > > > I have just installed phpPgAdmin and I have PostgreSQL running fine on
> > > > > > my computer. However, I do not know how to start phpPgAdmin. In fact,
> > > > > > I have never used php related stuff. Could someone please help me with
> > > > > > that?
> > > > >
> > > > > Do I need to install apache? The documentation on phpPgAdmin's site
> > > > > does not indicate how to start it, up to my best knowledge.
> > > >
> > > > yes - httpd would have to be installed...
> > > >
> > > > probably php-pgsql too.
> > > >
> > > > probably perl-DBI but I think that gets installed in most cases...
> > > >
> > > > 'yum install php-pgsql' would probably bring in everything you would
> > > > need as dependencies.
> > > >
> > > > I tend to use tarball...
> > > >
> > > > tar zxvf phppgadmin*
> > > >
> > > > mv whatever the folder you just untarred to /var/www/html/phppgadmin
> > > >
> > > > edit /var/www/html/phppgadmin/conf/conf.inc.php
> > > >
> > > > to suit your situation
> > > >
> > > > chkconfig httpd on
> > > >
> > > > point your browser...
> > > >
> > > > http://localhost/phppgadmin
> > > >
> > > > Have at it.
> > >
> > > Thanks, Craig. When pointing to
> > >
> > > http://localhost/phpPgAdmin
> > >
> > > I get
> > >
> > > "Firefox can't establish a connection to the server at localhost."
> > >
> > > Any ideas? Firewall, maybe?
> >
> > try 'service httpd start'
>
> That is it: working now. Thanks!
>
> Is there some danger that somebody malicious from outside can get
> access to my databases, since the access is done via a web-browser?
> What are the cautions to take?

----
Is this computer directly connected to the Internet or are you using a
firewall/router appliance?

If directly connected to the Internet...are you running firewall?
'system-config-securitylevel' - make sure that it (Firewall) is on.

Craig

[Paul Smith]

On 2/5/06, Craig White  wrote:
> > Is there some danger that somebody malicious from outside can get
> > access to my databases, since the access is done via a web-browser?
> > What are the cautions to take?
>
> Is this computer directly connected to the Internet or are you using a
> firewall/router appliance?
>
> If directly connected to the Internet...are you running firewall?
> 'system-config-securitylevel' - make sure that it (Firewall) is on.

Yes, Craig, my computer is directly connected to the Internet, but I
am running a firewall (Shorewall).

Paul

[Craig White]

On Sun, 2006-02-05 at 02:20 +0000, Paul Smith wrote:
> On 2/5/06, Craig White  wrote:
> > > Is there some danger that somebody malicious from outside can get
> > > access to my databases, since the access is done via a web-browser?
> > > What are the cautions to take?
> >
> > Is this computer directly connected to the Internet or are you using a
> > firewall/router appliance?
> >
> > If directly connected to the Internet...are you running firewall?
> > 'system-config-securitylevel' - make sure that it (Firewall) is on.
>
> Yes, Craig, my computer is directly connected to the Internet, but I
> am running a firewall (Shorewall).

----
Well then if http (port 80) is open to the world per shorewall
rules...then so is phppgadmin and if shorewall has http (port 80)
blocked, then it is not available to the world.

Craig

[Paul Smith]

On 2/5/06, Craig White  wrote:
> > Yes, Craig, my computer is directly connected to the Internet, but I
> > am running a firewall (Shorewall).
>
> Well then if http (port 80) is open to the world per shorewall
> rules...then so is phppgadmin and if shorewall has http (port 80)
> blocked, then it is not available to the world.

How can I check that out?

Paul

[Craig White]

On Sun, 2006-02-05 at 02:54 +0000, Paul Smith wrote:
> On 2/5/06, Craig White  wrote:
> > > Yes, Craig, my computer is directly connected to the Internet, but I
> > > am running a firewall (Shorewall).
> >
> > Well then if http (port 80) is open to the world per shorewall
> > rules...then so is phppgadmin and if shorewall has http (port 80)
> > blocked, then it is not available to the world.
>
> How can I check that out?

----
1 - look at shorewall rules...

2 - see which ports are open and which are closed

3 - find out your ip address '# ifconfig' and go to someone else's house
and try to access it from their computer - http://your_ip_address

4 - get root shell prompt and type...

iptables -L -n > /tmp/firewall-rules.txt

and upload that file here and we will tell you.

Craig

[Paul Smith]

On 2/5/06, Craig White  wrote:
> > > Well then if http (port 80) is open to the world per shorewall
> > > rules...then so is phppgadmin and if shorewall has http (port 80)
> > > blocked, then it is not available to the world.
> >
> > How can I check that out?
>
> 1 - look at shorewall rules...
>
> 2 - see which ports are open and which are closed
>
> 3 - find out your ip address '# ifconfig' and go to someone else's house
> and try to access it from their computer - http://your_ip_address
>
> 4 - get root shell prompt and type...
>
> iptables -L -n > /tmp/firewall-rules.txt
>
> and upload that file here and we will tell you.

The contents of my /etc/shorewall/rules:

#ACTION  SOURCE         DEST            PROTO   DEST    SOURCE     ORIGINAL
RATE            USER
#                                               PORT    PORT(S)    DEST
LIMIT
ACCEPT  $FW     net     GRE
ACCEPT  net     $FW     GRE
ACCEPT  $FW     net     tcp     1723
ACCEPT  net     $FW     tcp     6881,4662,4711,1723
ACCEPT  net     $FW     udp     6881

Any danger? :-)

Paul

[Tim]

On Sun, 2006-02-05 at 02:20 +0000, Paul Smith wrote:
> Yes, Craig, my computer is directly connected to the Internet, but I
> am running a firewall (Shorewall).

If you have no intention to let people on the internet access your HTTP
server, then reconfigure it to only listen to local interfaces.  Don't
rely on your firewall to protect you, use the firewall as backup
protection.

[Paul Smith]

On 2/5/06, Tim  wrote:
> > Yes, Craig, my computer is directly connected to the Internet, but I
> > am running a firewall (Shorewall).
>
> If you have no intention to let people on the internet access your HTTP
> server, then reconfigure it to only listen to local interfaces.  Don't
> rely on your firewall to protect you, use the firewall as backup
> protection.

How can I do that?

Paul

[Tim]

Tim:
> > If you have no intention to let people on the internet access your
> > HTTP server, then reconfigure it to only listen to local interfaces.
> > Don't rely on your firewall to protect you, use the firewall as backup
> > protection.

Paul Smith
> How can I do that?

If one is using Apache as their HTTPD server, the Apache manual gives
the information.  It's quite well documented.

Look for the "Listen" directive in the Apache configuration file
"/etc/httpd/conf/httpd.conf", set it to listen to "127.0.0.1" on port
80, and restart the server.

i.e. Listen 127.0.0.1:80

[Paul Smith]

On 2/5/06, Tim  wrote:
> Tim:
> > > If you have no intention to let people on the internet access your
> > > HTTP server, then reconfigure it to only listen to local interfaces.
> > > Don't rely on your firewall to protect you, use the firewall as backup
> > > protection.
>
> Paul Smith
> > How can I do that?
>
> If one is using Apache as their HTTPD server, the Apache manual gives
> the information.  It's quite well documented.
>
> Look for the "Listen" directive in the Apache configuration file
> "/etc/httpd/conf/httpd.conf", set it to listen to "127.0.0.1" on port
> 80, and restart the server.
>
> i.e. Listen 127.0.0.1:80

Thanks, Tim.

Paul